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
3
votes
1 answer

Soundex/Metaphone for phonegap on android

I need to make sql-searches using something like: soundex or metaphone for android over phonegap. But neither soundex nor metaphone works. Example: SELECT * FROM customers WHERE soundex(surname) = soundex('Mayer'); This brings me the message,…
afriend
  • 421
  • 1
  • 4
  • 6
3
votes
1 answer

Localized (Double) Metaphone for Portuguese (pt_PT)

I want to see how phonetically similar two non-English strings are, AFAIK soundex and metaphone implementations only work correctly for English based strings, for instance coração and corassão sound exactly the same in Portuguese but metaphone()…
Alix Axel
  • 151,645
  • 95
  • 393
  • 500
2
votes
2 answers

Sql Server Soundex Name search - find shortened form of a name

I would like to allow my app to search for names and return similar first names. I.e. if the user searches for John, Jonathan's should be returned as well. A Soundex search does not seem to do this. Are there any alternatives other than storing a…
MillinMo
  • 395
  • 1
  • 7
  • 21
2
votes
2 answers

Optimal search string in the where clause

Want to search the string using PATINDEX and SOUNDEX within the WHERE clause or any optimal way. I have the following table with some sample data to search the given string using PATINDEX and SOUNDEX. create table tbl_pat_soundex ( col_str…
MAK
  • 6,824
  • 25
  • 74
  • 131
2
votes
2 answers

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?
AFG
  • 1,675
  • 3
  • 22
  • 23
2
votes
1 answer

Implement soundex in .Net for entire sentences

I have a regex/soundex type method: public static string SoundEx(string word) { if (word.All(char.IsDigit)) { //sentenceParts = words; return word; } word = word.ToUpper(); word = word[0] + Regex.Replace( …
VinnyGuitara
  • 605
  • 8
  • 26
2
votes
0 answers

fuzzy installed successfully but fuzzy.Soundex(4) has problems in python

Code: >>> import fuzzy >>> soundex = fuzzy.Soundex(4) Error: Traceback (most recent call last): File "", line 1, in soundex = fuzzy.Soundex(4) AttributeError: 'module' object has no attribute 'Soundex' I really…
Jennifier
  • 21
  • 3
2
votes
3 answers

In MySQL how to write SQL to search for words in a field?

create table tbl ( id int, comment varchar(255), primary key (id) ); insert into tbl (id, comment) values ('1', 'dumb,'); insert into tbl (id, comment) values ('2', 'duuumb,'); insert into tbl (id, comment) values ('3', 'dummb'); insert into…
davidjhp
  • 7,816
  • 9
  • 36
  • 56
2
votes
1 answer

Improve finding fuzzy duplicates using MySQL

I have a table of names or companies or products that attracted duplicate records due to operator entry error. I'm attempting to create a tool to manage this problem. It won't be a high-traffic page, but it still shouldn't kill the database when…
PeteSE4
  • 309
  • 1
  • 4
  • 21
2
votes
1 answer

Mysql - Calculate soundex difference between two strings

I have some song names and their pre-calculated soundex stored in a mysql table. I want to compare the soundex of user input with the pre-calculated soundex'es. And get the results in ascending order of difference between the user input and song…
Aqeel Ashiq
  • 1,988
  • 5
  • 24
  • 57
2
votes
2 answers

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…
user189375
1
vote
0 answers

The soundex function from oracle has a result different from official documentation

Following this documentation from oracle. The example select soundex('SACHS' from dual; should be return S200, but I received S220 in many different oracle version. Anyone have any idea? Thanks and best regards!
Johnnathan Almeida
  • 11
  • 1
1
vote
2 answers

How to check %match between 2 string in prestosql?

What im looking for is I have 2 words e.g. 'Family' and 'Family Tree' then I would love to know that how much does both texts match to each others. let say 'Family' and 'Family' >> 100 % not sure any workaround or not. Thank you so much.
Paper.J
  • 13
  • 1
  • 5
1
vote
1 answer

Why is my stored procedure query returning extra results?

I have the following query inside of a stored procedure: CREATE PROCEDURE [s_Staff_ByLikeLastNmByLikeFirstNm] @LastNm varchar(10), @FirstNm varchar(10) /*WITH ENCRYPTION*/ AS SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL…
thecoolmacdude
  • 2,036
  • 1
  • 23
  • 38
1
vote
0 answers

c# comparing strings with a bit of leniency

I am currently working on a database project where we have some given names that need to be compared to some historical names in an existing database. These names belong to indigenous people in Malaysia are being gathered from anthropologists doing…
Megaphone Man
  • 11
  • 2
1 2 3
…
10 11