On Wed, 2022-08-17 at 14:33 +0300, Mohammed falih wrote: > I created the dictionary by this query > CREATE TEXT SEARCH DICTIONARY arabic_dict ( > TEMPLATE = ispell, > DictFile = th_ar, > AffFile = th_ar, > Stopwords = arabic); > and as you know the purpose in dictionary is like when you're searching for an > example a "house" the results will also retrieve a records with "home" because > it's a synonymous but when I run queries nothing happens That would be a "synonym dictionary": https://www.postgresql.org/docs/current/textsearch-dictionaries.html#TEXTSEARCH-SYNONYM-DICTIONARY An Ispell dictionary normalizes words, for example by removing suffixes for plural and case. You'd have to create a synonym file yourself. Yours, Laurenz Albe
