I am very puzzled with the results returns by Spotlight on macOS Ventura 13.5.1. I am trying to find all text and pdf files containing a sentence "in our house". It turns out that Spotlight does not lists files that contain this sentence and for which this sentence exists and is found within Preview.
I have tried to use mdfind
as I have more confidence in what a command line command gives me back, but it turns out that I came to realize that:
mdfind -onlyin ~/Documents "house"
gives me list of files which does not show up when I use the command
mdfind -onlyin ~/Documents "ouse"
which is very puzzling to me as the "ouse" is a substring of "house". I suspect that spotlight has a weird behaviour with substring and with spaces that I don't find documented anywhere.
Do you know how spotlight works with respect to that?