Using JOIN a ON a.field SOUNDS LIKE b,field

[George Brooks]

If this is posted incorrectly, please advise.

In an effort to avoid duplicating names in a PHP application, I'm using a SQL statement that includes the phrase "join organizations o2 on o1.organization sounds like o2.organization where o2.organization=$orgname". (o1 and o2 are the same table.) What I cannot understand is why if $orgname = 'Truckee Donner Historical Society' I will get existing misspellings of the name (e.g., 'Truckee-Donner Historical Society', where there's an added hyphen), but if $orgname='Truckee Donner Histerical Society' (an organization that does not exist in the table) I get an empty result set. Yet when I compare the soundex values of the two possibilities they are identical.

If there is a better approach to this problem, please let me know.

Many thanks.

George