soundex() Function

Returns the soundex code, used to render similar sounding names via phonetic similarities into identical four (4) character codes.

Supports US English text only.

Syntax

soundex( text )

text: (Text) The text to be converted.

Returns

Text

Notes

The soundex code is all uppercase. The first character is retained. From the remainder, vowels are dropped.

Repeated letters are made into single letters.

"BFPV" are coded as "1", "CGJKQSXZ"] as "2","DT" as "3", "L" as "4", "MN" as "5", and "R" as "6" and unfilled characters are "0". For example, "Sullivan" and "Suliban" are both "S415". "Smith" and "Smythe" are both "S530".

Examples

soundex("John Smith") returns J525

Open in Github Built: Fri, Nov 04, 2022 (07:10:52 PM)

On This Page

FEEDBACK