Hi,
More and more lately it feels the need to have an aproximate (phonetic) search
on character fields.
In fact it is a common feature nowadays (thanks, Google) and the users want to
see it also in their applications.
PostgreSQL has it (see this for a neat implementation)
http://www.postgresql.org/docs/current/static/fuzzystrmatch.html
MSSQL has it (see this for neat conversion from C++ to T-SQL)
http://www.sqlmag.com/article/tsql3/double-metaphone-sounds-great-26094
MySQL has it (see this for a neat discussion)
http://stackoverflow.com/questions/369755/how-do-i-do-a-fuzzy-match-of-company-names-in-mysql-with-php-for-auto-complete
Like the other Databases said, I would propose a Double Metaphone
implementation in FB 3.0
For Double Metaphone see in the middle of the Wikipedia Metaphone page:
http://en.wikipedia.org/wiki/Metaphone
Comments?
------------------------------------------------------------------------------
Own the Future-Intel(R) Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest. Compete
for recognition, cash, and the chance to get your game on Steam.
$5K grand prize plus 10 genre and skill prizes. Submit your demo
by 6/6/13. http://altfarm.mediaplex.com/ad/ck/12124-176961-30367-2
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
