sql - Good database and structure to store synonyms

Question

If you could choose the database you want and have to store (query and update) word synonyms then what database would you choose? And how would you store them? Let's assume that there will be a lot of synonyms (but I guess data size won't be a problem here).

Answer 1

Keeping it very simple, you could create a table of words and a relationship table for synonyms. You could consider adding a restriction like WordID1 < WordID2 to prevent repeating pairs of words (e.g, (1,2) and (2,1)).