SELECT * FROM _users WHERE SOUNDEX(name) LIKE SOUNDEX('jon');
Not ActionScript, but the coolest thing I’ve seen in Mysql in awhile, the soundex function will convert a string into a soundex index… read more about it on wikipedia.
I did some tests and it matches things like:
what’s your name? & whats yer name
very cool… since this isn’t ActionScript, I will post another snippet right after this.
UPDATE: Actually started reading more about this stuff and dug up some algorithms… metaphone etc… fun stuff, maybe I’ll port some of it to actionscript…