I am working on a semantic search engine and I need to be able to search for synonyms and inflections of the words in the phrase that the user enters.
I have encountered the problem that the parameter “contains_search_condition” of the Contains or ContainsTable command is limited to 4000 characters.
Just by searching for the synonyms and inflections of a word, this limit can be exceeded. It is not solved even if the words are entered into a Varchar(max) variable and passed to the parameter.
Several years ago I reported this problem and others that I have found in writing to Microsoft Spain, who reported it to Microsoft USA. They told me that "they were going to work on these problems."
I have not heard anything again and I need a solution, because I am stuck on this problem.
I can't write the text of the query because it says "violation of the code of conduct" and deletes the post.