Den 2013-03-30 10:02 skrev m. Th. sa*ha"r:
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.
[snip]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?
Well, I've been looking a few times for phonetic matching algorithms
that would work for Swedish data. I did read about Metaphone as well as
a few others.
The problem with a built-in phonetic matching engine in FB is that it
would either be huge or useless. If it's supposed to support only
English data, including names from other languages but pronounced in
English, that would be fine, but for most applications quite useless. A
lot of data exists out there that's not English at all.
Transliterating e.g. Cyrillic, Hebrew or other alphabets into some latin
alphabet (a-z? a-o" like Swedish? What about u", i", C, etc?) would not
be enough. The fact is that the same latin-alphabet word can sound
completely different in different languages.
Take my name as an example: kjell. In English it's almost
"unpronouncable"(?) like "jelly" with a "K" in front and drop the
trailing "Y". But it does in fact sound like an Englishman would
pronounce "chell" (not "shell").
For this to work, the phonetic engine would have to know the
pronunciation rules of hundreds of different languages. A huge task.
Otherwise, many many applications would be unable to use it.
In an ideal world I'd say "Yes, go for it!", because I would just love
this feature. But in the real world I think the development time should
be put to better use.
Regards,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
