Thank you, I tried it. Unfortunately I still have the same problem. While doing my investigations, I found an old backup of my notes (outdated) with Joplin 1.0.216. The search function was working well in this back-up instance.
I guess there might be some kind of corruption in my current database. I will open a new support ticket to ask for help with corrupted database.