Enable partial word search in database search API drupal 8 & 9

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?

Buy me a drink 🍺 to keep me motivated to create free content like this!