Levenshtein distance based methods Vs Soundex
As per this comment in a related thread, I'd like to know why Levenshtein distance based methods are better than Soundex. ...
soundex
How to make an International Soundex?
E.g. the Soundex algorithm is optimized for English. Is there a more universal algorithm that would apply across large families of languages? ...
Is it possible to use Soundex (or other SQL functions) in LinqToSql?
Guess the title says it all. I'm refactoring some code currently implemented in stored procedures to use LinqToSql (for use in training). Is it possible to use SQL functions in a linqToSql Query? ...
Double-metaphone errors
I'm using Lawrence Philips Double-Metaphone algorithm with great success, but I have found the odd "unexpected result" for some combinations. Does anyone else have additions or changes to the algorithm for other parts of it they wouldn't mind sharing, or just the combinations that they've found that do not work as expected. eg. I had i...
Data structure for soundex algorithm?
Can anyone suggest me on what data structure to use for a soundex algorithm program? The language to be used is Java. If anybody has worked on this before in Java. The program should have these features: be able to read about 50,000 words should be able to read a word and return the related words having the same soundex I don't want t...
SQL Server's SoundEx function on non-Latin character sets?
Does SQL Server's (2000) Soundex function work on Asian character sets? I used it in a query and it appears to have not worked properly but I realize that it could be because I don't know how to read Chinese... Furthermore, are there any other languages where the function might have trouble working on? (Russian for example) Thank you,F...
How to check SOUNDEX in php when php SOUNDEX outputs only 3 digits
I am trying to do a comparison between company names using SOUNDEX, but the php call for soundex only outputs 3 digits so the comparisons aren't quite accurate. Is there a way to get a better soundex output so that the results are more accurate? ...
Soundex Algorithm implementation using C++
Put simply a Soundex Algorithm changes a series of characters into a code. Characters that produce the same Soundex code are said to sound the same. The code is 4 characters wide The first character of the code is always the first character of the word Each character in the alphabet belongs in a particular group (at least in this exa...
"sounds-like", "did you mean THAT" functionality using full text search in SQL Server 2005
I have implemented full text search over SQL Server 2005 database using CONTAINSTABLE keyword. I was wondering is there a way to add a "sounds like" or google's "did you mean THAT" functionality if the original query yields no results. ...
Enabling soundex/metaphone for non-English characters
Hi all, I've been studying soundex, metaphone and other string search techniques the past few days, and in my understanding both algorithms work well in handling non-English words transliterated to English. However the requirement that I have would be for such search to work in the original, untransliterated languages, accomodating alp...
Could use some help with this soundex coding.
The US census bureau uses a special encoding called “soundex” to locate information about a person. The soundex is an encoding of surnames (last names) based on the way a surname sounds rather than the way it is spelled. Surnames that sound the same, but are spelled differently, like SMITH and SMYTH, have the same code and are filed toge...
Soundex algorithm in Python (homework help request)
The US census bureau uses a special encoding called “soundex” to locate information about a person. The soundex is an encoding of surnames (last names) based on the way a surname sounds rather than the way it is spelled. Surnames that sound the same, but are spelled differently, like SMITH and SMYTH, have the same code and are filed toge...
Is there a "Sounds-Like" string matching algorithm implemented in Dutch?
I know about the Soundex and Double-Methaphone algorithms for "sounds-like" stringmatching in English. Where can I find a similar algorithm, or a port of one of the algorithms for the Dutch Language? ...
PHP/MySQL: Highlight "SOUNDS LIKE" query results
Quick MYSQL/PHP question. I'm using a "not-so-strict" search query as a fallback if no results are found with a normal search query, to the tune of: foreach($find_array as $word) { clauses[] = "(firstname SOUNDS LIKE '$word%' OR lastname SOUNDS LIKE '$word%')"; } if (!empty($clauses)) $filter='('.implode(' AND ', $clauses).')'; $quer...
Use SOUNDEX() word by word on SQL Server
Hi there, Here is my problem. For example I have a table Products that contain a field Name: Products ID | Name | .. 1 | "USB Key 10Go" 2 | "Intel computer" 3 | "12 inches laptop computer" ... I'm currently implementing a simple search engine (SQL Server and ASP .NET, C#) for an iPhone web-app and I would like to use the SOUNDEX()...
trying to use SOUNDEX in query but getting an error in terms of database columns in mysql...
Hi, Trying to figure out what went wrong, must be a silly syntax. $objDatabase = QApplication::$Database[1]; $strQuery = 'UPDATE `account` SET `sndx`=SOUNDEX("'.$objAccount->Name.'") WHERE `Id`='.$aid; $objDbResult = $objDatabase->Query($strQuery); The error I get is: MySqli Error: Unknown column 'sndx' in 'field list' Exception Typ...
Do MVA 1.0 and EntityFramework and SQL Server Soundex play together?
I want to implement a simple soundex-based query in an existing EF-based MVC app. Has anyone done this? If so, how do you construct the query? I've found several Linq examples, but I'm after pure EF. ...
Optimizing a Soundex Query for finding similar names
My application will offer a list of suggestions for English names that "sound like" a given typed name. The query will need to be optimized and return results as quick as possible. Which option would be most optimal for returning results quickly. (Or your own suggestion if you have one) A. Generate the Soundex Hash and store it in the...
How do I transform an audio clip?
I want to get an audio clip from the microphone on my iPhone/iPad or iPod Touch. How do I transform it? Basically take the wavelength and modify it with sin (30) (or any angle). ...
Getting started with Soundex
My MVC site (sql08 back-end - nHibernate in the middle) asks for a company name when a user creates a new account. My business rules dictate that i accept whatever the user enters but into a field named CompanynameProvisional. Management needs to confirm that entry so we can enforce a One-to-Many relationship. (a single company can have ...