Mimicking the Soundex Capability

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
ALW
Posts: 41
Joined: Thu Jun 25, 2015 1:56 am

Mimicking the Soundex Capability

Post by ALW »

I need to do a duplicate check in my system to find Company Names that are similar but may have been entered in a different way - similar to a soundex type of comparison. So for example - if the user is entering in "Walmart" as a new company but the company already exists in the system as "Wal-mart" or they enter in ABC Company but it is already in the system as "A.B.C Company" - I want to alert the user that there is likely a duplicate in the system. Is there a way to do this? I guess I could store the name as another field with no punctuation or spaces and check against this but wanted to see if anyone has run into a similar business need scenario.

Thanks!
johntalbott
Posts: 614
Joined: Wed Jun 17, 2015 11:16 pm
Location: Omaha, Nebraska
Contact:

Re: Mimicking the Soundex Capability

Post by johntalbott »

SQL Server and MySQL have Soundex functions. You could call a stored procedure that uses a soundex function as part of your duplicate check process.
VocalDay Solutions - Agility - Predictability - Quality

We specialize in enabling business through the innovative use of technology.

Services:
-Web/Mobile App Design/Development
-Project Management - Agile, Scrum, Kanban
-Business Analysis
-Testing
ALW
Posts: 41
Joined: Thu Jun 25, 2015 1:56 am

Re: Mimicking the Soundex Capability

Post by ALW »

Thank you - that is a great idea!
Post Reply