It all depends at the end of a day, how crucial is that functionality
to your app ?
If very, I would add to every insert/update a trigger, that would
update info on other table(s) with stats per character.
Other option, is to write a function in C that would parse word and
chop it in C,O (character, number of occurrences ) result.
--
GJ