SQL query to identify Name/address duplicate suspects in a table
$100-250 USD
Paid on delivery
We are looking for an efficient query to identify possible duplicate contact records in a ms sql 2008 table.
Table structure is:
Firstname
Lastname
Company
Address1
Address2
City
State
Zip
Workphone
Homephone
Cellphone
The challenging part is fuzzy and soundex searching on name and address fields. The result list will be displayed by a web app to a user to confirm duplicates and deal with them so it doesn't need to be perfect, but just go beyond basic exact matches.
We'll work with you to refine the tolerance. We'd prefer a bid from someone who already has a similar query/algorithm developed who can adapt it to this table.
Please provide a basic description of your approach.
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
## Platform
MS SQL 2008
Project ID: #3678755