----- 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.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.