One thing that can help simplify the creation of the wordlist table is to instead use a materialized view (with a gin or gist trigram index), and just refresh i

One thing that can help simplify the creation of the wordlist table is to instead use a materialized view (with a gin or gist trigram index), and just refresh it on some schedule. Of course, this means that your fuzzy search capability will lag somewhat behind live data in the case where a new distinct word has just been added to the corpus, but in many cases this is acceptable: people looking for recently created records will most likely have some exact reference for them, and will only resort to using fuzzy search to find older records for which their reference is rather more, well, fuzzy.