You need a levenshtein function in MySQL and query like
$word = mysql_real_escape_string($word);
mysql_qery("SELECT `term` FROM `words` WHERE levenshtein('$word', `term`) BETWEEN 0 AND 4");
More Related Contents:
- How to avoid to display this error in PHP?
- Disappears \ from db value [closed]
- What to put in database columns when creating registration/login system? (xampp)
- mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource
- How to properly set up a PDO connection
- Query with multiple values in a column
- Preserve Line Breaks From TextArea
- Search with comma-separated value mysql
- How to do this in Laravel, subquery where in
- php / Mysql best tree structure
- Trying to get property of non-object in [duplicate]
- PHP & MySQL Pagination
- How to write a REST API?
- how to access the command line for xampp on windows
- PHP inserting multiple checkbox AND textbox arrays into MySQL Database
- How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?
- PHP, MySQL and Time Zones
- How do I loop through a MySQL query via PDO in PHP?
- display data from SQL database into php/ html table [closed]
- Getting time difference between two times in PHP [duplicate]
- Using LIKE in bindParam for a MySQL PDO Query [duplicate]
- Is there a way to show a WHERE clause just for one field in MySQL?
- Password_Hash not working on my PHP login
- MySQL Stored Procedure vs. complex query
- Formatting an SQL timestamp with PHP
- Finding free blocks of time in mysql and php?
- Select mySQL based only on month and year
- Mysql InnoDB engine in Laravel
- MySQL: Group by two columns and sum
- phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’