The White House has said a raid in Yemen on an al-Qaeda stronghold that likely killed civilians was a "very thought-out process".