I want search results from the Levenshtein distance. Please Login to comment Full-text searches in MySQL are performed when certain indexes are in use and those indexes have many unique nuances including the following: In order for the index to be considered a full-text index, the index must be of the FULLTEXT type. Double Metaphone expands the Soundex algorithm, which are both phonetic search algorithms. This query, for example, will return elephant, since metaphone of "elefant" is "ELFNT", the same as metaphone of "elephant".
nest...