Hi, I followed the discussion silently, and let me just give my2c:
First: Even an english only algorithm is better than none; maybe, writing your application, you'd have to find some workarounds. Second: I'd like to have this like a plugin architecture, similar to the well known dictionairies - sure, this needs some more thinking about - but this would return the task to the people asking for language XYZ: And I'm sure we'll find some volunteers helping us out there. Thomas Am 02.04.2013 22:42, schrieb Kjell Rilbe: > > Den 2013-03-30 10:02 skrev m. Th. såhä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-ö like Swedish? What about ü, ï, Ç 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 > -- Mit freundlichen Grüßen, Thomas Beckmann Diplom-Informatiker Wielandstraße 14c • 23558 Lübeck Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559 Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de> ASSFINET-Logo *ASSFINET Dienstleistungs-GmbH* Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de <http://www.assfinet.de/> Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann Registergericht Koblenz HRB 23331 Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. ------------------------------------------------------------------------------ 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