Return the count of all words in a column

Is there a way to take a column and use a spill formula to return in the next two columns A) the words the column consists of and B) the count that the word appears in from the column?

background: I have a spreadsheet where column A is the survey ID and B has the written responses from the survey. I want to take column B and make a formula that returns the count of every word from column B. I am likely going to remove common words like the or he she etc so it runs better.