The search for a man who is missing at sea after he was caught by a large wave as he reportedly spread his sister's ashes off the English coast has been called off.