SQL Fix misspelled business names

Vote count:

0

I'm looking for advice on how to tackly the issue of different spelling for the same name. I have a SQL Database with company names, and there are some companies that are the same but the spelling is different. For example:

Building Supplies pty
Buidings Supplies pty
Building Supplied l/d 

The problem is that there are no clear consistencies in the varation. Sometimes its an extra 's', other times its an extra space. Unfortunately I don't have a lookup list, so I can't use Fuzzy LookUp. I need to create the clean list.

Is there a method that people use to deal with this problem?

p.s I tried searching for this problem but can't seem to find a similar thread Thanks

asked 1 min ago

jmich738

16

SQL Fix misspelled business names