A body has been discovered during the search for a man who has been missing for over six months