…
This of course would only work if it will be searched for the “display name” string. Like “mda: Dynamics”. Searching for “mda dyn” or “mda filter” would actually then show a result, not nothing 
A dream would be then an additionaltextfield called “alias names” (or “search tags”) which could be filled in for each plugin.
For example for “mda dynamics” I could add to this new field: “freeware compressor”
So on next search for “freeware” or “mda compressor”, it would be displayed.
That’s maybe the most simple approach to realize some kind of search tags.
Or you could use the short name field for that purpose… So if you consider adding the AND-clause, then please consider also searching inside the short name field. Like internally string appending “display name” and “short name” to one search field first before starting search. And I will do the rest here.
Split searchterm in substrings by whitespace.
SELECT CONCAT(pluginname, pluginvendor) as name WHERE (name LIKE ‘%term1%’) AND(name LIKE ‘%term2%’) …
Something like this…