How to 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:
![How to enable partial word search in database search API drupal 8 & 9](/sites/default/files/inline-images/partial_word_search_api_drupal.png)