Matching Rows by Sound

With the SOUNDEX function, you can match rows by sound, as well as by spelling.

Searching Surnames by Sound

Suppose a phone message was left for a name that sounded like “Brown.” Which employees in the company have names that sound like Brown?To list employees with surnames that sound like Brown, type the following:

SELECT Surname, GivenName
FROM Employees
WHERE SOUNDEX( Surname ) = SOUNDEX( 'Brown' )

Surname	GivenName
Braun	Jane

Jane Braun is the only employee matching the search condition.