Language inter-relation table
I've always wanted to make language barriers a significant feature of my worldbuilding projects, but not being a conlanger (and not having developed the language skills to even start doing it justice yet), I thought I'd try a different approach. Perhaps it's something other folks would be interested in as well.
Basically I set up a table in excel, plotted out all of my cultures and their respective languages on the axes (grouped into potential language families), and set up some conditional formatting for a percentage value for different combinations.
The percentage values are based loosely on some research I found for mutual intelligibility of Romance languages, where they found that Portuguese and Spanish were about at the functional limits of mutual intelligibility and were given a \~65% 'similarity score' based on shared linguistics and grammar. I extended that a bit to include other thresholds:
* \>85% is a dialect * \>65% is mutually intelligible * \>40% is at least understandable in fragments, and easier to learn * \>20% has some similarity in structure and possibly a few loanwords, but isn't understandable. Slightly easier to learn * \>5% has perhaps the odd loanword and/or slight similarities in structure
The idea I had in my head was that this table could be used to garble speech provided to players of either a video game or tabletop RPG if their language skill wasn't sufficient. Say, if you approached a merchant and wanted to buy something but didn't speak the local language, the speech options would be a random jumble of letters. As your skill improved, it would successively de-scramble words until you could fully understand it.
That way, acquiring language skills would be a genuinely useful thing to do in-game.
A side benefit of plotting out the languages like this is it's given me inspiration for a number of cultures based on creoles between different languages, or historic connections between cultures as reflected in their language.
Anyway, hope someone out there thinks it's useful in some way!