Advanced Search of a snippet throughout a Name

When I search and filter by Customer Name in List View, I want it to search more rigorously. For example, If I have a customer named “Michael Alfred”, I want the search to match for search keywords including “MICHAEL”, “alfred” and “fred”. I want the search to be match many as much as possible. Any advice on how to accomplish this?

Search should be case-insensitive by default.

For the partial searches, try using a % wildcard character.

If you need to configure it, search these forums for these config_override.php options:

$sugar_config['search_wildcard_char'] = '%';
$sugar_config['search_wildcard_infront'] = true;

Finally, you might want to set up an Elastic Search server connected to your database and get a lot more search functionality.