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

sql join 2 tables if they have similar names/values

I'm trying to join 2 tables that have the common column 'NAME', but data is sorted like this: TABLE A NAME B C Corporations Tefal Inc. West, Tom Anne Zagabi (C) NamyangSoy TABLE B NAME BC Corporations Tefal Inc Tom West AnneZagabi ( C )…
user2810030
  • 63
  • 2
  • 8
0
votes
1 answer

how to perform MySQL smart text search in a column?

I am trying to search for a shop name in one of MySQL table, the table has a field called fullname. As of now I am using the SOUNDS LIKE method of MySQL however here's an example that failed: Say I have the string Banana's Shop. Then using SOUNDS…
adit
  • 32,574
  • 72
  • 229
  • 373
0
votes
1 answer

Soundex comparison with comma separated subquery?

I am performing a soundex query on a table of users. A subquery of users is provided as a comma separated list of strings. I want to do something akin to the following, but I cannot find the write syntax to make this work. select * from ((Select…
The Prophet
  • 338
  • 5
  • 11
0
votes
0 answers

SOUNDEX function in MYSQL

How soundex function can be used if I have following problem : name | Soundex_value Kap Pup Nup | K151 ( came from soundex('Kup Pup Nup') Kap | K100 Now if I want to get all the rows where name field contains any soundex value of…
Satish Saini
  • 2,880
  • 3
  • 24
  • 38
0
votes
2 answers

SQLite soundex string length

Does soundex function in sqlite has limitation on string length? As I found that the result of SELECT soundex('Schneider Thomson'), soundex('Schneider Rene'), soundex('Schneider') Are all the same value which equal S536, However the result of…
Ahmed Alaa
  • 5
  • 3
0
votes
3 answers

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…
Josh
  • 17
  • 1
  • 2
0
votes
0 answers

How to search for names in a text field in SQL Server

I need to redact proper names from text fields in SQL Server. Let's say I have the following table: PersonTable FirstName LastName Notes I could do this: UPDATE PersonTable SET Notes = REPLACE(REPLACE(Notes, FirstName, 'REDACTED'),…
sydneyos
  • 4,527
  • 6
  • 36
  • 53
0
votes
3 answers

Soundex with numbers as String parameter

Do you know some explanation why SOUNDEX does not work with NUMBERS as string? These queries works fine: select 1 from dual where soundex('for you') = soundex('for u') ; select 1 from dual where soundex('for you') = soundex('for you') ; But this…
Osy
  • 1,613
  • 5
  • 21
  • 35
0
votes
1 answer

correcting spelling mistakes in a column based on another table in mysql

my mysql table has a cityname column. the values in the cityname column has some spelling mistakes. each of the spelling mistakes of city needs to be corrected. another table has a column that contains all correct city names. based on this table the…
silverkid
  • 9,291
  • 22
  • 66
  • 92
0
votes
0 answers

MySQL Sounds Like Results Too Broad

Evening, Is there any way to tweak SOUNDS LIKE in MySQL so it returns results from a narrower phonetic range? Or another feature that allows this. I am looking for as narrow a range as possible, e.g. Hopkins matches Hopkins John doesn't match…
Kohjah Breese
  • 4,008
  • 6
  • 32
  • 48
0
votes
1 answer

Printing the contents and index location of one file by matching it with other file using python

I'm new to python What I want is to be able to print content of a file I have like this.. Mashed Potatoes , topped with this and that ...................... 9.99$ similarly Product_name , description ......................... price when I match…
boyfromnorth
  • 958
  • 4
  • 19
  • 41
0
votes
1 answer

Is sql soundex query meant for general search?

I've been using a LIKE query for searching a search string in a knowledge base site. So, the term "phone" would likely turn up all pages that have something with the word "phone" written in it, logically. But when getting into less typical searches,…
Kristian
  • 21,204
  • 19
  • 101
  • 176
0
votes
1 answer

How to use Soundex in PHP with SQLITE to get 'Did you mean..'

I know there is a similar thread but it has no useful answer. I am using SQLITE (can not change language) and when a user fills out a form one of the fields is Category. I want them to enter a category for example, they can enter: gardening. But…
JEV
  • 2,494
  • 4
  • 33
  • 47
-1
votes
0 answers

How do i convert a user input value to a SOUNDEX value? using .net core webAPI 7

I want the user submitted value to arrive in the MS SQL DB as a SOUNDEX value. eg. soundex(Amnesia) = A520 I have this Function in my dbcontext: [DbFunction(name: "SOUNDEX", IsBuiltIn = true, IsNullable = false)] public string Soundex(string…
SkyReel
  • 160
  • 10
-1
votes
1 answer

Implementing Soundex Encoding Algorithm

Soundex is a phonetic algorithm that encodes a word into a letter followed by three numbers that roughly describe how the word sounds. Similar sounding words have the same four-character codes. For instance, the words Carrot and Caret are both…
cupof
  • 7
  • 3
1 2 3
…
10
11