title: A good SQL strategy for fuzzy matching possible duplicates using SQL Server 2005
body: <p>I want to find possible candidate duplicate records in a large database matching on fields like COMPANYNAME and ADDRESSLINE1</p>
  
  <p>Example:</p>
  
  <p>For a record with the following COMPANYNAME:</p>
  
  <ul>
  <li>"Acme, Inc."</li>
  </ul>
  
  <p>I would like for my query to spit out other records with these COMPANYNAME values as possible dups:</p>
  
  <ul>
  <li>"Acme Corporation" </li>
  <li>"Acme, Incorporated" </li>
  <li>"Acme"</li>
  </ul>
  
  <p>I know how to do the joins, correlated subqueries, etc. to do the mechanics of pulling the set of data I want. And I know that has been covered on here before.  I am interested hearing thoughts on the best way to do the fuzzy searching - should I use full-text indexing or the soundex function or something else that I am unware of for this process? (I am using SQL Server 2005)</p>
  
  <p>Any help is appreciated!</p>