We are getting the below error message after deleting a Region without deleting the sites first and trying to add the old sites again to the system

FAILURE :Site with same name already exists. Please provide a different value.

Can anyone please advise how to delete the old sites from the Database as they are not showing in the web console?

thanks in advance