It would be far easier to use a word cloud library/module in your favorite language than use SQL. You could probably write a function to count word frequency per body and update counts into a temp table, which you then return the top 100 rows of the temp table as the “most frequent words counted”.
2 Likes