Is Filter Contains all words working well? I have a View and a filter, with "Contains all words". I see that the SQL contains the expression

'%word1%' AND '%word2%',


but this is making that if I write "angular", just when I start writing the "a", also words which have the character a and not necessarily start with a will appear, for example "matter". 

Shouldn't the placeholder % be only in one place, this way:

LIKE ( 'word1%' AND ' word2%' ) AND (' word1%' OR 'word2%')  ... [other combinations]


I am hurrying on the suggestion, but that way, it will look for a beggining of string as one of the two (or more) words, and the other words must have an empty space before them if they are not at the beginning.
Change your Operator to Starts with and Apply.



If you need use a specific filter you can alter your view query with this hook:

function YOUR_MODULE_views_query_alter(&amp;$view, &amp;$query) 
{
    if($view-&gt;name == 'NAME') {

    //here modify your query

    }

}