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

getting NULL value for string 'marketing' and 'makeing' as soundex drops vowels only as both have same soundex string value

Write a query to return the list of employee IDs with incorrectly spelled departments, from the Emp Master table. correct data is in Dept_Master with no foreign key. SELECT * FROM Emp_Master as orig LEFT OUTER JOIN Dept_Master as correct ON…
prasad
  • 1
0
votes
0 answers

How do I implement fuzzy searching for a word within a field?

I have some very basic beginner SQL knowledge. I've come across SOUNDEX and LIKE and have tried to implement them in my code. In my database, I have a names column that contains all available names for a person (first, second, third, etc). So far it…
Ali
  • 1
0
votes
0 answers

SQL Server Soundex() and Difference() to Compare a Columns observations to Itself

I am looking for some assistance in using Soundex() and Difference() in SQL Server with the goal of comparing one observation in a column to another observation in that same column. Here is some context of how the data looks. All of these street…
AdamBandola
  • 1
0
votes
1 answer

Using SOUNDEX function on WHERE clause in MySQL

How can I use soundex function on the following WHERE clause? WHERE usr.name LIKE CONCAT('%', :search, '%') Given that the general approach for using SOUNDEX function is: SELECT name FROM users WHERE soundex('Dennis') = soundex(name) However, I am…
Relaxing Music
  • 452
  • 4
  • 13
0
votes
1 answer

Fuzzy search on Oracle database

I need to implement fuzzy search in our web application. At first we had hardcoded options on our frontend, but now we have to work with database data (only return top 10 candidates). I just want to ask about the best approach how the data flow…
adammartiska
  • 35
  • 1
  • 4
0
votes
2 answers

Trying to compare two tables with SOUNDEX

Could someone please explain how to use SOUNDEX (mysql/php) to match multiple words? I'm trying to make a simple in-site ad system. I have one table with columns "ad_id" and "keywords", and another table with "page_url" and "keywords". The problem…
Test Tester
  • 1,409
  • 4
  • 14
  • 14
0
votes
1 answer

Using Soundex in wordpress or woocommerce default search Query?

Trying to use soundex() function in search so I can get the results whose value sounds like same. I have created 6 posts. Hur Hur The Beautiful Hoor Hoor the Brand Hwr Hwr the beautiful All above 6 posts contains (Hur, Hoor, Hwr) and sounds same…
Asfandyar Khan
  • 1,677
  • 15
  • 34
0
votes
1 answer

UnicodeDecodeError: with apply function in column for each row

I have a dataframe and I want to encode each word in my column by using soundex, so I have to use split because Soundex take only the first word then I apply this line of code but I got this error: table['soundex'] = table['name'].apply(lambda x:'…
Fatima
  • 497
  • 5
  • 21
0
votes
1 answer

Talend: get SOUNDEX of String in tMap

I am inserting data from a CSV file to a MySQL database, and one of the columns should contain the SOUNDEX representation of a string. For example, I have the first name as a column in the CSV and the database should contain its SOUNDEX. I am using…
Majed Badawi
  • 27,616
  • 4
  • 25
  • 48
0
votes
1 answer

Fuzzy matching a string in in pyspark or SQL using Soundex function or Levenshtein distance

I had to apply Levenshtein Function on last column when passport and country are same. matrix = passport_heck.select(\ f.col('name_id').alias('name_id_1'), …
aamirmalik124
  • 125
  • 15
0
votes
0 answers

How to search MYSQL table with misspelled words?

I am using Codeigniter framework. I have a database table 'product', it has a column 'title' and the title is 'Canon Digital SLR Camera'. I want to search my table with the text 'cannon' (double n) and it should return 'Canon Digital SLR…
Rathan Kumar
  • 1
0
votes
2 answers

Best way to design soundex based search

I have a table of forum posts, and want to improve the basic search functionality as we get a lot of users from all over the world who are not native English speakers and will have trouble finding results when they spell incorrectly. The current…
Tom Gullen
  • 61,249
  • 84
  • 283
  • 456
0
votes
0 answers

Enable Soundex in Sqlite

I want to use soundex with sqlite.The goal is for homophones to be encoded to the same representation so that they can be matched despite minor differences in spelling. I am using below code- class SearchDBManager private constructor(context:…
Android Developer
  • 9,157
  • 18
  • 82
  • 139
0
votes
1 answer

Find SOUNDEX of each word in the column

I have the following data: create table testing ( name varchar(100) ); insert into testing values('Mr.Alex James Henrry'); insert into testing values('Mr John Desto'); insert into testing values('Ms.Lisa Jack Jerry Han'); insert into testing…
MAK
  • 6,824
  • 25
  • 74
  • 131
0
votes
1 answer

How to use MySQL SOUNDEX function with SQLAlchemy

Looking for any example of making SOUNDEX queries on MySQL from SQLAlchemy, if possible at all. Any alternatives?
martincho
  • 4,517
  • 7
  • 32
  • 42
1 2 3
…
10 11