I'm just blogging this because it took me way too long to find the answer. It turns out that SugarCRM v5.2.2 DOES INDEED support 'fuzzy search', aka 'unified search', out of the box. What this means, is you can get partial matches when you're searching fields. Say you're searching your list of leads on a custom field you made called 'region'. You've added region to the search area, but region doesn't have the prettiest data. For example, say you have three leads, and their region data is 'CA, TX, AZ', 'TX and surrounding states', and 'Dallas, TX'. You want your search to return ALL of these leads when you're trying to find leads that operate in Texas, but how?

The secret is the wildcard operator '%'. Just do a search using the 'Advanced Search' form, and under your 'region' field put '%TX'. This will pull up all three of your leads because they all containg the string 'TX' in their region data. Not so awesome when you only have three leads, but TOTALLY FREAKING SWEET WHEN YOU HAVE SAY, 2465 :D\

[a]