US president Barack Obama said he had "never seen devastation like this" as he viewed the wreckage left by tornadoes which killed almost 300 people in the US South.