Wildcard search in phrases

MongoDB Atlas
, , ,
1

Hello!
Is there a way to do wildcard search in phrases?
I have a term “blood disorder” and my search query is “blo order”. I would like to see “blood disorder” in the result. Any ideas of how to do this?
I tried the following and it didn’t work:

{
 index: 'fts',
"wildcard": {
                   "query": "blo* *orders",
                   "path": "Text",
                   allowAnalyzedField:true
                   }
}

Snippet of the analyzer:

 "Text": {
        "analyzer": "lucene.standard",
        "multi": {
          "mySecondaryAnalyzer": {
            "analyzer": "lucene.english",
            "type": "string"
          },
          "wildcardAnalyzer": {
            "analyzer": "lucene.keyword",
            "type": "string"
          }
        },
        "type": "string"
      }

I have the lucene.keyword and standard analyzer on the field that has terms.

Thanks,
Supriya

2

Hi @Supriya_Bansal,

It sounds like this type of search is more suitable to regex operator no?

https://docs.atlas.mongodb.com/reference/atlas-search/regex/

I haven’t tested the wildcard pattern yet, but using a custom analyzer with ngram adjustment might better tokenize results for your searches…

Thanks
Pavel

3

Thanks @Pavel_Duchovny. I tried nGram analyzer and it does work. However the search results are little different than expected because of the minGram. For now, I have decided to go with wildcard approach.

{
  index: 'fts',
  "compound": {
    "must":[
                {
                  "wildcard": {
                    "query": "blo*",
                    "path": "Text",
                    allowAnalyzedField:true
                  }
                },
                 {
                  "wildcard": {
                    "query": "*orders*",
                    "path": "Text",
                    allowAnalyzedField:true
                  }
                }
  ]
  }
}

Best,
Supriya