Question

What are the difference between the use of fuzzy and term masking?

Answer 1

What are the difference between the use of fuzzy and term masking?

Explanation:

Fuzzy Search: When you use this search and A in Country list box then all the values which has character with A is moved to the top of the list, the best matched values are moved to the top of the list, while other values are displayed below.

Advanced Search: Supposed if you want to select by using some expression then you can use advanced search.  For example if you give

=Sum(Sales) > 300

then India and USA is selected, since it has sales > 300.