Heartbreaking tributes have been paid to a man following the news that a body has been found in the search for the missing 46-year-old.