Seriously, if you’re motivated enough to do this, you should give programming a try. Python or Ruby or Javascript are ideal for this kind of thing, and you can solve problems like this in a few lines of code… just look up “word frequency in Python” or whatever language for examples.

If you want to see what the next level of this kind of analysis looks like, watch a few videos about how Elasticsearch works… not so much so you can USE Elasticsearch (although you can, it’s free), but just to get a sense of how they approach problems like this: Like imagine instead of just counting word occurrences, you kept track of WHERE in the text the word was. You could still count the number of occurrences, but also find surrounding text and do a bunch of other interesting things too.