A body has tragically been found in a search for a missing woman, police have confirmed.