SOUNDEX

Converts text to a SOUNDEX code for phonetic matching

Updated over a week ago

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)

Output

text

Variables

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

Example'

SOUNDEX(`Name`)

ID

Name

SOUNDEX

1

Smith

S530

2

Smythe

S530

3

Johnson

J525

4

Jonson

J525

Did this answer your question?