I have some data in my database which contains address data. The problem with it is that it is of very terrible quality. Say I have 3 orders placed by the same woman. Those orders could be in the database as:
Carol Smith 101 State St Boston Masachusets
Carel Smythe One Hundred One State Street Boston Massachusetts
C. Smth One Zero One State Boston MA
I even have country data with some records. I tried using soundex, but I get tons of false positives. Is there any other way to query this data so that I get all of poor Carol's orders!!! I am willing to purchase ANY third part tool which will help with this.