[Bug]: Unified search issues

⚠️ This issue respects the following points: ⚠️

[X] This is a bug, not a question or a configuration/webserver/proxy issue.
[X] This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
[X] Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
[X] I agree to follow Nextcloud's Code of Conduct.

Bug description

Unified search in Nextcloud is semantic to the point where spaces are treated literally. To me this is a bug, though not sure how developers will feel about this. I run a personal Nextcloud server and tried using Nextcloud for a small company which just voted to switch to Google Drive today, with search being the 1st complaint that employees had.

Our folder names do not contain any spaces, as the Unix way has suggested. Because of this, if any user searches, for example, "Meeting Minutes", the folder "Meeting_Minutes" does not show up. The space is treated literally. This is not the way the average, non-technical user, expects search to behave in 2023. I do have Elasticsearch installed which works pretty well for text within files, but this does not show directories, only files.

I'm going to continue to run my personal instance of Nextcloud as I'm a huge fan, but am very bummed that my company now went proprietary Google Drive. Sure enough, now that we've migrated the data, searching "Meeting Minutes" in GDrive shows the folder "Meeting_Minutes" no problem, which solves one of their biggest issues.

Steps to reproduce

Have directory names that contain underscores instead of spaces
Search for a directory using spaces
Watch as no results show up

Expected behavior

Don't treat spaces as literal strings and figure out that the search term "Meeting Minutes" should show the folder "Meeting_Minutes"

Installation method

Community Manual installation with Archive

Nextcloud Server version

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Apache (supported)

Database engine version

PostgreSQL

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

[X] Default user-backend (database)
[ ] LDAP/ Active Directory
[ ] SSO - SAML
[ ] Other

Configuration report

No response

List of activated Apps

No response

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response

nextcloud / server