How is synonym search implemented in PostgreSQL database in PHP?

Question

PostgreSQL

How to implement a search for synonyms of an expression in the database? This is necessary to identify different spellings of the same expression. For example, before adding the product "Vendor Model Color" to the table, you need to find out if the product "Vendor Model" or "Vendor Model Something" is not there. Someone must have come across this issue. Please tell me how to implement it.

Answer 1

For complex cases: www.postgresql.org/docs/9.1/static/dict-xsyn.html
For simple cases:LIKE

Answer 2

Do you really know the meaning of the word "synonyms"? From your example, you can see that the usual LIKE will do.