Phonetic Searches

Phonetic Searches

How can I perform a phonetic search in SQL? I need to search a database ofnames, but exact matches won’t work. Using phonetic matching, I could finda 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 developmentsystem (the product you choose will depend on your application developmentsystem).

The best advice I can offer, short of purchasing a productdesigned for complex text searches, is to create your own function orexternal routine. Joe Celko’s book “SQL for Smarties” includes a routinefor performing phonetic matching (please see my Books page under Resourcesfor more information about the book).

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular