Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL Server
Expertise: Beginner
Apr 20, 1997



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Phonetic Searches

How can I perform a phonetic search in SQL? I need to search a database of names, but exact matches won't work. Using phonetic matching, I could find a name registered as, for example, "Beeter" when searching on "Bester".

The fastest solution for text-based searches, including phonetic searches, is to use an add-on product to your front-end application development system (the product you choose will depend on your application development system).

The best advice I can offer, short of purchasing a product designed for complex text searches, is to create your own function or external routine. Joe Celko's book "SQL for Smarties" includes a routine for performing phonetic matching (please see my Books page under Resources for more information about the book).

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date