Database search is powerful with search API modules. I stumbled upon looking for the button to enable partial search. I figured out it is already in the creation of your database server at /admin/config/search/search-api/server/database/edit:

Partial search api drupal

Saved you some valuable time?

Donate and get more free time-saving code on this website in the future.