'Contains any word' exposed filter criterion matches strings rather than words

I just wanted to say thanks for your work on this. I am dealing with the same weirdness in my university museum's new Drupal site, and it really surprised me to find out that (1) by default, Views filters return 'football' on a 'foo' search and that (2) there's not a way to change that! Seems like a no-brainer that Views would offer an option to 'require whole word'. So thanks again for helping to make this happen.

This would be great for contains any word and for contains all words operators (whether exposed or not), so that we can specify to match whole words and not partial strings.

For example, searching an exposed filter title for men is returning results for women, so it is certainly a problem.

When I try your patch for contains any word, i'm getting the error:

Notice: Undefined variable: string in views_handler_filter_string->op_word()

Thanks for giving this some attention!

this worked well on regular single field filters containing all or any words...

i tried it on combined fields filter and couldn't get it to work there... i'm assuming some similar patch needs to apply to views_handler_filter_combine.inc to get it to work there. i tried myself hacking the file a bit based on your patch but couldn't get it to work... perhaps you can take a look, thanks so much...

Patch in #7 worked for me. Thanks!

Patch works great!

But I was wondering if it could be added as separate handler or an extension to the class via a custom module.
Because unless everyone agrees this should be the new behaviour the patch won't get commited, and having to remember to repatch everytime views gets updated is not an option.

Patch #7 worked for me. When filtering on a taxonomy view containing these terms: "child care", "a car loan", "day care", filtering for car returns just a car loan and filtering for care returns just child care and day care.

When I first tried "contains any word," this is the results I expected. If I wanted just a partial match, the contains filter would have handled that case just fine. I could not see a difference between "contains any word" and "contains" prior to installing this patch.

attached a modified patch that add this capability also for 'combine' filters.

Is it at all possible to do this at the theme level by overriding the function?

I've also tried placing ([[:<:]]|^)([[:>:]]|$) into the view regular expression filter, but I'm not sure how to get the search words.

If I add the combined filter value to the regex string it works a treat without the patch, but I'm having trouble passing the combined value dynamically in the to regex string.

Example that works well:

([[:<:]]|^)foo([[:>:]]|$) - works for all instances of 'foo' but not 'food' which is correct.

Question is, is there a way of dynamically getting the value of 'foo'?

I've tried ([[:<:]]|^)!1([[:>:]]|$) and ([[:<:]]|^)%1([[:>:]]|$), but neither work.

Thoughts?

Despite its old age, patch #13 applied cleanly and works as advertised. Thanks @robertom and @a-fro!

Is there a version of the above module for Drupal 8?

Since the issue is relevant for Drupal 8, I've duplicated it here: https://www.drupal.org/project/drupal/issues/3173367