Azure Search filter for “like” or “contains”

Question

What is the correct filter syntax for doing a like or contains?

I would like to pull all fileNames that contain "test" in the file name.

I've tried this in the search explorer, but it didn't work

$filter=search.in(fileName, 'test')  

or

$filter=search.ismatch('test')  

I also need to do this via the C# Azure Search:

            SearchOptions options = new SearchOptions()  
            {  
                Filter = string.Format("{0} ne '{1}'", FileManagerMetadataContants.IsFileDeleted, FileManagerMetadataContants.IsFileDeletedValue),  
                SearchMode = SearchMode.Any,  
                IncludeTotalCount = true,  
            };  

![59465-image.png][1]

Here are the versions I'm on:

Answer 1

@ttaylor2727 ,

There are different ways to achieve a “contains” query.

1) You could use wildcard matching Lucene query syntax, as mentioned in this doc, however, this is potentially very slow for large indexes.

2) You could use a custom analyzer such as NGram or EdgeNGram. This will index all the permutations of the field which creates a larger index but makes queries much faster. Check out this blog article for more information: Custom analyzers in Azure Search

Note that the blog uses EdgeNGram which will give you a “prefix” query and not a “contains” query. Change it to “ngram” or “ngram_v2” instead. See the list of tokenizers available here: Add custom analyzers to string fields