php - 搜索建议 - PHP - MySQL

Question

我有一个 MySQL 查询如下；

$query = "SELECT * FROM dictionary WHERE word LIKE '%".$word."%' ORDER BY word LIMIT 10";

这将在我的字典数据库中搜索(并显示)单词。

搜索将返回；

醉了就醉了，等等，等等.. ,醉酒醉酒，等等，等等..和醉酒醉酒，等等，等等..

但它不会为 Drunkin 返回 Drunken。我想将这个词显示为建议词(就像我们在谷歌中看到的那样)。我怎样才能做到这一点？

下面是我的完整代码供引用；

$db = new pdo("mysql:host=localhost;dbname=dictionary", "root", "password");
$query = "SELECT * FROM dictionary WHERE word LIKE '%".$word."%' ORDER BY word LIMIT 10";
$result = $db->query($query);
$end_result = '';
if ($result) {
    while ( $r = $result->fetch(PDO::FETCH_ASSOC) ) {
        $end_result .= $r['word'].'<br>';
    }
}
echo $end_result;

Answer 1

尝试使用 SOUNDEX

Soundex keys have the property that words pronounced similarly produce the same soundex key, and can thus be used to simplify searches in databases where you know the pronunciation but not the spelling. This soundex function returns a string 4 characters long, starting with a letter.

以下是一些关于 SO 的问题，可以引导您走向正确的方向:

• How does the Google “Did you mean?” Algorithm work?
• How do you implement a “Did you mean”?

希望这有帮助。