tag:blogger.com,1999:blog-3782954984366933851.post1754792839539168151..comments2023-06-19T01:22:31.258+12:00Comments on Steve's Software Development Blog: What's this Soundex in Delphi?Steve Peacockehttp://www.blogger.com/profile/03155137500284265720noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-3782954984366933851.post-39583397184707912062015-05-29T09:23:05.346+12:002015-05-29T09:23:05.346+12:00What about another languages that use latin letter...What about another languages that use latin letters?Anonymoushttps://www.blogger.com/profile/10749349258902364973noreply@blogger.comtag:blogger.com,1999:blog-3782954984366933851.post-11825741696049388052007-09-04T08:29:00.000+12:002007-09-04T08:29:00.000+12:00Loïs, you are correct. Although I would suggest on...Loïs, you are correct. Although I would suggest only the 4 characters in length, you could definately alter the Soundex system to suit your specific requirements. This would improve disparities like "Gates" and "Bates" having different codes.<BR/><BR/>Other improvements include the "Daitch-Mokotoff" soundex system. In a book "SQL For Smarties", Joe Celko outlines a "Celko Improved Soundex" algorithm.<BR/><BR/>The New York State Division of Criminal Justice Services introduced the NYSIIS Soundex system in 1970.<BR/><BR/>Looking up Soundex in the Wikipedia, it states... "Lawrence Philips developed the Metaphone algorithm .. later developed an improvement to Metaphone, which he called Double-Metaphone". I hadn't come across either.<BR/><BR/>Thanks for the insight Loïs.Steve Peacockehttps://www.blogger.com/profile/03155137500284265720noreply@blogger.comtag:blogger.com,1999:blog-3782954984366933851.post-943601599786434792007-09-04T00:44:00.000+12:002007-09-04T00:44:00.000+12:00Having a Soundex code like "A4521" isn't very effi...Having a Soundex code like "A4521" isn't very efficient, though.<BR/>It's better to use an algo that produce a "pure integer" value code like "654521" or similar.<BR/>In other words, avoid to store the first "char"; instead replace it with an integer.<BR/><BR/>The main advantage is when the soundex value is to be stored into i.e. retrieved from a database - using indexing functionality makes things faster :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3782954984366933851.post-35669040173081625262007-09-03T07:48:00.000+12:002007-09-03T07:48:00.000+12:00Anon: Yes, you are of course correct :)Delhihobbyi...Anon: Yes, you are of course correct :)<BR/><BR/>Delhihobbyist: Thanks. Love your site btw.<BR/><BR/>Alex ... and good morning to you too :)Steve Peacockehttps://www.blogger.com/profile/03155137500284265720noreply@blogger.comtag:blogger.com,1999:blog-3782954984366933851.post-36392911137308719602007-09-03T05:01:00.000+12:002007-09-03T05:01:00.000+12:00The Delphi's StrUtils Soundex is enough. No need i...The Delphi's StrUtils Soundex is enough. No need in custom procedure, IMHO. Also hard to read too much text.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3782954984366933851.post-68998542525017474622007-08-31T10:24:00.000+12:002007-08-31T10:24:00.000+12:00Thanks Steve, I enjoyed that.Thanks Steve, I enjoyed that.TDelphiHobbyisthttps://www.blogger.com/profile/16988423327342669888noreply@blogger.comtag:blogger.com,1999:blog-3782954984366933851.post-13500622356732491722007-08-31T09:59:00.000+12:002007-08-31T09:59:00.000+12:00it's 5 1/4" floppies, not 5.5 or 5.25 :)it's 5 1/4" floppies, not 5.5 or 5.25 :)Anonymousnoreply@blogger.com