SOUNDEX

Converts text to a SOUNDEX code for phonetic matching

Description	The SOUNDEX() function is used to convert a text string into a SOUNDEX code, which is a phonetic algorithm for indexing names by sound. This function is helpful for phonetic matching, which allows you to find similar-sounding words or names in a dataset.
Syntax	SOUNDEX(text)

1. text: The input text string that you want to convert into a SOUNDEX code.

Example

Table

ID	Name
1	Smith
2	Smythe
3	Johnson
4	Jonson

Function

SOUNDEX(`Name`)

Results

SOUNDEX (text)
S530
S530
J525
J525