How do I search a string for a specific name even if the string is misspelled

[Lorna]

I am looking for a specific employer in a SAS data set. The data set has not been reviewed for spelling so if I am looking for University it could be entered as Unversity, University, Univercity ... and I need to pick them all up

I've tried scaning, counting the matching letters, 'contains'. These are work but I am still missing some.

Any ideas?

[Reeza]

SOUNDS LIKE.
http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#p0a62rd151ctown1x3...

[Lorna]

thank you for taking the time to reply.  I did the "sounds like" technique.  I ended up getting Pizza Hut as a return for Puget and got nothing when the word was Pudget.  I figured there would be something more.

Thanks again

[ChrisBrooks]

As well as the excellent suggestion from @Reeza there are some other ideas here -> https://blogs.sas.com/content/sgf/2015/01/27/how-to-perform-a-fuzzy-match-using-sas-functions/ although having done some fuzzy matching in the past I couldn't guarantee that anything you try will always catch all the potential matches you'd like. You might have to incorporate several of the suggested techniques to get a good coverage.

[Lorna · Accepted solution]

Thank you.  I looked at those too but did not go that route, yet.  Guess I had better dive in and do it.