----- Original Message -----
> From: hsv@stripped
> I wish to join two tables on likeness, not equality, of character
> strings. Soundex does not work. I am using the Levenstein edit
> distance, written in SQL, a very costly test, and I am in no
> position to write it in C and link it to MySQL--and joining on
> equality takes a fraction of a second, and this takes hours. Any
> good ideas?
Looks like Sphinx might be a helpful addition to your stack. Way too much to explain how
to do so here, but it's a proper fulltext engine, and has a MySQL-compatible interface.
Unhappiness is discouraged and will be corrected with kitten pictures.