A body has been found in the search for a missing man, police have confirmed.