Search for duplicates in column with mixed format data

Greetings,

Newbie here trying to find duplicates in addresses listed in 3 separate columns (street, city, state) from 2 different sources. Issue is street addresses ( and some cities) are in mixed format (Road, Rd, Street, St., saint martin, saint-martin... ) and I thought convert text to column might work but it did not pan out to desired result. I also attempted to replace all on st with street,... and that did not work as it should probably due to my fault.

Is there another way or formula that can be used for this purpose?

Your assistance is appreciated.