Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LukeD
Starting Member
5 Posts |
 Posted - 2011-02-10 : 04:16:06
|
| Hi,I have a table containing a colum 'OrganisationName' which comprises of a list of OrganisationNames that are believed to exist within my database, ofcourse not all will be exact matches, I wish to return all possible simularities of each OrganisationName within that table that exist within my database. This is ofcourse part of a data cleasing process but I the manual labour required to determine ALL existent data is unpractical and at the mercy of human error.Is there a query? or systematic method of exposing such data?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-02-10 : 06:49:38
|
| Look up the SOUNDEX() and DIFFERENCE() functions in SQL Server Books Online. They perform rudimentary "sounds alike" matches that may help you. Also look at the Fuzzy Lookup operator in Integration Services. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
|
|
|
Identifying ALL possible renditions of a string