That sounds quite good, at least for a start! Thanks! (DB2 is used in this project, but it has got that function too.)
2009/4/4 chris burgess <[email protected]> > Are you using MySQL, or another DB with soundex? If so: SOUNDEX() may help > you do a fuzzy "sounds like" search. > > http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_soundex > > > CREATE TABLE words ( word varchar(255) default NULL, KEY `idx_words` > (`word`) ) ; > > ALTER TABLE words ADD index idx_words ( word ) ; > > LOAD DATA INFILE '/usr/share/dict/words' INTO TABLE words ; > > SELECT * FROM words WHERE SOUNDEX(word) LIKE SOUNDEX('fire'); > > The results are pretty loose (returns 'favor' for 'fire' in the example > above, fire gets 100+ matches from my dictionary). > Disclaimer: I haven't actually used this in the "real world", I just know > it's there :) > > Good luck! > > On Sat, Apr 4, 2009 at 8:49 PM, mikael letang <[email protected]>wrote: > >> I am looking for a method to be able to make a kind of "search like" tool >> in a search engine, considering that the search request may >> - be a translation in latin alphabet of non-latin word (e.g., in cyrillic, >> japanese, ... ) >> - have typing mistake >> >> The database in which I would search is a database of Company names from >> all over the world, all translated in latin alphabet. >> >> I searched briefly on google, but I am not even sure how to express in few >> words what I am looking for... >> > > > > > --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
