how to get similar search results in MySQL?

by

You should start by looking into the Soundex algorithm. It assigns a “sound” to a given string which can be used to find closely matching words.

It’s particularly suited to English text but, provided you can live with that, it’s not too bad.

For example, both Pax and packs generate P200, heiress and hares both give H620 and, for your question, both Picadilly and Piccadilly give P234.

So, if you store the Soundex code alongside the word in a database, and indexed on that code, you could very quickly get a list of close matches.

More Related Contents:

  1. Delete the entire content of all table in a Database [closed]
  2. Yet Another SQL Query
  3. How do I import an SQL file using the command line in MySQL?
  4. Alternative to Intersect in MySQL
  5. How to find all tables that have foreign keys that reference particular table.column and have values for those foreign keys?
  6. How can I use mySQL replace() to replace strings in multiple records?
  7. GROUP_CONCAT ORDER BY
  8. MySQL: ALTER TABLE if column not exists
  9. Find and Replace text in the entire table using a MySQL query
  10. Can I reuse a calculated field in a SELECT query?
  11. MySQL SELECT increment counter
  12. Prevent auto increment on MySQL duplicate insert
  13. Error Code: 1215. Cannot add foreign key constraint (foreign keys)
  14. Query from two tables in report
  15. MySQL – force not to use cache for testing speed of query
  16. Is it safe to store usernames and passwords in the database?
  17. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  18. How to count all rows when using SELECT with LIMIT in MySQL query?
  19. How to fix double-encoded UTF8 characters (in an utf-8 table)
  20. How to integrate ElasticSearch with MySQL?
  21. MySQL INSERT INTO … VALUES and SELECT
  22. How do I get SUM function in MySQL to return ‘0’ if no values are found?
  23. MySQL LOAD_FILE() loads null values
  24. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  25. MySQL Select ID’s which occur on different rows with multiple specific values for a column
  26. How to compare timestamp dates with date-only parameter in MySQL?
  27. How to sort a MYSQL table in a permanent way?
  28. UPDATE with ORDER BY and LIMIT not working in MYSQL
  29. Mysql stored procedure don’t take table name as parameter
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment