Hello, I am pretty new to MySQL and currently in the process of creating a translation dictionary web application.

Here are a few of the entries:
-different language word
-english word

My question is, how would you all address the issue of synonyms? For example, stone and rock. If a user searches for either, I want the results of both to be returned.

How would the data model look like, and how would I be able to query it? Any help? Thanks!