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

a simple relational structure might be like this:

word
------
word_id
text

synonym
---------
word_1_id
word_2_id

Answer 2

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)).