With the SOUNDEX function, you can match rows by sound. 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?
In Interactive SQL, execute the following query:
SELECT Surname, GivenName FROM Employees WHERE SOUNDEX( Surname ) = SOUNDEX( 'Brown' );
The algorithm used by SOUNDEX makes it useful mainly for English-language databases.
For more information, see SOUNDEX function [String].