The US government has said it is " tremendously sorry"  for killing two hostages held by al-Qaeda during a counterterrorism operation in the border region of Afghanistan and Pakistan earlier this year.