how do you populate/maintain the synonym/stemming database? is this something that “standard” datasets exist for? asking because this problem will fall on my plate at work sometimes in the next few months :-)
[1] https://cwiki.apache.org/confluence/display/solr/LanguageAna...
IIRC the stemming was done by an algorithm and not from a database...but I don't remember the exact details.