Comment 1 for bug 1969926

If you want to match multiple apostrophes, say so in your search expression.

title:~Gravity['՚]s

https://manual.calibre-ebook.com/gui.html#the-search-interface

As for having calibre do it magically, the effort isnt worth it to me,
but patches are most welcome. I will note that searching inside the calibre viewer already does this.