protected function getSearchQueriesForColumn($column, $relevance, $words)
{
$queries = [];
// look for a direct match
$wordsTogether = implode(' ', $words);
$veryRelevant = $relevance * 10;
$queries[] = "if({$column} LIKE '%{$wordsTogether}%', {$veryRelevant}, 0)";
// look for fuzzy text searches
$words = $this->filterCommonWords($words);
$this->totalWords = count($words);
foreach ($words as $word) {
$queries[] = "if({$column} LIKE '%{$word}%', {$relevance}, 0)";
}
return $queries;
}