Stack Overflow
Stack Overflow

Questions tagged [soundex]

Soundex is an phonetic algorithm for indexing names based on their pronunciation in spoken English.

Soundex is a phonetic algorithm for indexing names by sound, as pronounced in English. The goal is for homophones to be encoded to the same representation so that they can be matched despite minor differences in spelling.

Soundex is the most widely known of all phonetic algorithms mainly because it is a standard feature of popular database software (such as MySQL, MS SQL Server and Oracle) and some programming languages (such as PHP).

Soundex was developed by Robert C. Russell and Margaret K. Odell and patented in 1918 and 1922

Articles

159 questions
1
vote
1 answer

MS Access 2003 Using SoundEx to search from a form

I need to get a search to look for "fuzzy matches" in a database when searching by Surname. I have implemented the following function to enable a SoundEx function, which has no issues. I am getting issues when it comes to building the SQL to search…
Daniel
  • 13
  • 3
1
vote
1 answer

Tried understand the Soundex algorithm in Python

What does this number parameter in Soundex function mean? Code: import fuzzy soundex = fuzzy.Soundex(6)
P.Hazarika
  • 11
  • 2
1
vote
1 answer

TSQL Using soundex across linked servers

(Object names in this post have been changed to protect the idiocent). I was matching lists of employee names where one list was on Server_A column collation:Latin1_General_CI_AS column data type: VARCHAR(50) Column nullability NULL SQL Server…
DatumPoint
  • 419
  • 4
  • 21
1
vote
0 answers

Soundex to match common SMS or IM short forms

I was doing bit of experimentation the Apache commons soundex. And, I found it works quite well for strings. I was looking for an API or way by which I can match words or strings in sms or usual IM formats formats which are like soundex. The…
Abhishek
  • 6,862
  • 22
  • 62
  • 79
1
vote
3 answers

Is it better to use PHP or MySQL for Soundex queries?

I am just wondering whether it would be better to use PHP's Soundex Function or MySQL's Soundex Function? Also do the PHP and MySQL Soundex function produce the same results?
Aran
  • 3,298
  • 6
  • 32
  • 33
1
vote
2 answers

Soundex Function for Turkish Language in Python

Soundex function is originally implemented for English language, but as Turkish language has lots of specially characters, I couldn't find good solution for the case, there is one very good example here for English one Soundex implementation in…
GurhanCagin
  • 185
  • 2
  • 13
1
vote
0 answers

Predict Similar Suppliers in the supplier/Trader list using pattern matching in SQL

Help required at your earliest guys! I have duplicate records for consignor name who trade with us... I want to search similar consignor names that are entered misspelled or have entered wrongly in the system. For example parameter : ABC trader The…
Nabeel Arif
  • 21
  • 4
1
vote
1 answer

SQL Server soundex and MySQL soundex difference

Hello I want to use Soundex on SQL Server. I found good example for MySQL: SELECT SOUNDEX('game of thrones') When I tried this query: MySQL returns : G513652 SQL Server returns : G500 I searched but couldn't find why. Aren't they same?
serdar
  • 454
  • 1
  • 8
  • 26
1
vote
1 answer

why soundex return irrelevant result

I wonder why : WHERE 1=1 AND LTRIM(RTRIM(lastName)) ='Schmdli' OR ( SOUNDEX(lastName) = SOUNDEX('Schmdli') ) Return me result like…
istiti
  • 141
  • 1
  • 11
1
vote
1 answer

Sphinx how to use wordforms with soundex?

I am using sphinx with soundex morphology. I want to use wordworms. Which form of word do I need to use like a result? call keywords ('azori', 'test', 1); +------+-----------+------------+------+------+ | qpos | tokenized | normalized | docs | hits…
Andrey Vorobyev
  • 896
  • 1
  • 10
  • 37
1
vote
0 answers

Mysql Soundex Query How Can I Take Best Result

Mysql query and results are this img. http://i.hizliresim.com/6JoaNv.jpg select * FROM kelimekontrol WHERE SOUNDEX(kelime) = SOUNDEX('ağde') i think it is the best result of ağda words but idont get this result. how can i improve best result for…
B. Mert
  • 19
  • 5
1
vote
4 answers

F# - Remove subsequent duplicates from an array of characters (unordered)

I am trying to learn F#. And I need som help with a simple soundex expression. I am using the following ruleset for Simplified (also called American) soundex: 1.) Assign characters to classes 2.) Remove duplicate values here, e.g. 222 becomes 2 …
Slurken
  • 13
  • 3
1
vote
1 answer

Soundex or Metaphone algorithm for typos in search term

In our search we need to return results which match searched term with Levensthein distance max of 2. The problem is that we need to apply Levensthein distance algorithm for every row in table which has millions of rows and then query is very…
michal.jakubeczy
  • 8,221
  • 1
  • 59
  • 63
1
vote
1 answer

Is there easy way to match word from a database table field with soundex?

Hi Just Before going deep into soundex, wanted to ask quick qiestion. 1 - field in the table[title] contains a "Sentence that has WORD I am looking for" Q - Is there are easy way to match the WORD using a sundex ?
simple
  • 149
  • 13
1
vote
1 answer

How to flag if a word sounds like any word within a character field, using SOUNDEX?

I have a character variable that's long (up to 12,000 characters), and I would like to find a string within the variable that sounds like a certain word. I'd also like to create a variable that equals one if the string is in the variable. Let's…
user7415976
  • 13
  • 2
1 2 3
…
10 11