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
3 answers

finding similar strings to given by keywords, each keyword have got it's own 'power'

This question is a chalenge for me, my friend can`t tell me how to do it, but he is really good programmer (I think). Users can put into database sentences. When user puts a sentence it is saved in sentences table. Next, sentence is split into…
monthon1
  • 245
  • 3
  • 10
0
votes
0 answers

Building sqlite under windows with soundex function

I am trying to build sqlite under windows with soundex funtion, while build succeeds, i still don't get soundex functionality. i couldn't figure out where is the error. cl -DSQLITE_THREADSAFE=0 -DSQLITE_SOUNDEX sqlite3.c -link -dll…
GurhanCagin
  • 185
  • 2
  • 13
0
votes
0 answers

Fuzzy match algorithm between full names from different manual inputs in TSQL?

I'm hoping to implement a fuzzy match algorithm in TSQL (without MDS) that compares full names. The names are coming from separate manual inputs with no controls over what's entered. One of the systems also tends to cut off the end of names as it…
user3457834
  • 314
  • 3
  • 12
0
votes
1 answer

ORDER BY soundex with WHERE (MySql)

Query code: SELECT * FROM example WHERE name LIKE '%test%' OR SOUNDEX(name) LIKE 'T230%' OR SOUNDEX(name) LIKE 'T23%' I want to show first the results matched with WHERE name LIKE '%test%' and after SOUNDEX(name) LIKE 'T230%' and the lasts rows is…
Miguilim
  • 25
  • 2
  • 7
0
votes
1 answer

How to properly use soundex() in mysql

Hello I am practicing to build an e-commerce site using vanilla PHP , I want that when I search for a certain item in search bar even if there is a typo such "trffic" it can still found the item traffic. The code below seems to only work for correct…
Chrissa
  • 155
  • 2
  • 14
0
votes
1 answer

Mysql on update and default

I want to have a column on a table that is automatically updated when the row is updated, this column is a soundex version of another column, hypothetically, something like this: CREATE TABLE `test` (`title` VARCHAR(255), `title_soundex`…
Rod
  • 2,046
  • 2
  • 20
  • 24
0
votes
1 answer

How can I generate all the wrong variants of words consisting of more than two letters?

There is an array in which there are many million words. And you need to create an associative array with the wrong variants of all these words passing the correct version of that word as the key. And the wrong variant of the word must not coincide…
John
  • 468
  • 3
  • 16
0
votes
1 answer

How to use Soundex with SQLITE in android

Could someone please guide me on how to use soundex in sqlite. or can we use "soundex" function in sqlite. if we can use it Please provide an example if possible. thanks in advance.
kksal55
  • 500
  • 7
  • 14
0
votes
1 answer

use Soundex and Substring to be able to get potential duplicate values from DB

I asked a similar question [Querying database to find potential duplicates based on multiple columns and it was kindly answered by master of SQL Gordon Linoff. All in all I have about 100k client records, only to find out now that there's…
BobSki
  • 1,531
  • 2
  • 25
  • 61
0
votes
1 answer

PostgreSQL: Address matching using fuzzymatch from two tables

What I want to do; I have two tables with two address columns , both stored as text I want to create a view returning the matching rows. What I've tried; I've created and index on both columns and tables as below; CREATE INDEX idx_table1_fulladdress…
mapping dom
  • 1,737
  • 4
  • 27
  • 50
0
votes
1 answer

Elasticsearch Soundex Match Query - NEST

Can anyone think why this may not be working? I basically have two fields which I index using a soundex analyzer see configuration below but when I search using names similar to what is stored in the index it doesn't…
GWilkinson
  • 107
  • 1
  • 11
0
votes
0 answers

Query for words with special characters and normal input in mysql

I have a database with special characters like ā or ă so when the input is something like amor I want to query also the word āmor or ămor. I used the Sounds Like function but it does not work properly. Here is my question: How do I do that?
user7001372
0
votes
0 answers

Eliminate low score from solr answer

Really is it possible to filter out low score from solr results? This is a very helpful thing, even if documentation advise against it. Let's say that I am doing a search after 4 fields, like field 1 field 2 field 3 field 4 and then merge all…
Claudiu Hardalau
  • 167
  • 1
  • 11
0
votes
0 answers

Best way for matching a key in a hashmap with input string (using soundex)

I have a HashMap with country names as keys. I also have a JSON file for alternate names that can be used for these countries. Now, I need to ask the user for a country name and proceed accordingly. If they give a valid country name, my code will…
KKG
  • 11
  • 3
0
votes
1 answer

Error with Soundex: cannot find symbol

Getting the following error: error: cannot find symbol so = Soundex.parse(s, true); public static List getSimilar(String s) { List simWords = new LinkedList<>(); // Find uppercase and lowercase Soundex ID for letters …
Tii
  • 1
1 2 3
…
10 11