Hi! I'm senior lecturer on databases. I know how to count N amount of words in the select query.
select (char_length(title) - char_length(replace(title,substr,''))) div char_length(substr) as count_in_title,
(char_length(keywords) - char_length(replace(keywords,substr,''))) div char_length(substr) as count_in_keywords, (char_length(notes) - char_length(replace(notes,substr,''))) div char_length(substr) as count_in_notes
from table
And then, ordered a result may be on weight of each amount.