Matching rows by sound

With the SOUNDEX function, you can match rows by sound, as well as by spelling. For example, suppose a phone message was left for a name that sounded like “Ms. Brown”. Which employees in the company have names that sound like Brown?

Searching surnames by sound

To list employees with surnames that sound like Brown, type the following:

SELECT emp_lname, emp_fname
FROM employee
WHERE SOUNDEX( emp_lname ) = SOUNDEX( 'Brown' )

emp_lname

emp_fname

Braun

Jane

Jane Braun is the only employee matching the search condition.