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]
-~----------~----~----~----~------~----~------~--~---
