Searching column cells for similar text values and summarising in another column

Ok so it would seem the prior solution was:

=LET(list,TEXTSPLIT(C2," "),SUM(--(MMULT(--ISNUMBER(SEARCH(" "&list&" "," "&$B$2:$B$10&" ")),SEQUENCE(COLUMNS(list),,1,0))>0)))

so lets build on that:

=LET(list,TEXTSPLIT(C2," "),
         data, $B$2:$B$10,
         dates, $C$2:$C$10,
         month, $F$1,
         fdata, FILTER(data, 
                 (MMULT(--ISNUMBER(SEARCH(" "&list&" "," "&data&" ")),SEQUENCE(COLUMNS(list),,1,0))>0) *
                 (dates> EOMONTH(month,-1) ) * (dates <= EOMONTH(month,0) ),
                 "none found")
         IF( TAKE(fdata,1)="none found" , 0 , ROWS(fdata) )
)

so on row 6 is the same check used before but instead of doing a 'sum' of the 0's and 1's it produces, I use it as a filter and multiply it by line 7 which is a filter for the date range (assuming F1 is an actual date in the month of interest).

Line 9 wil then output how many rows were found 

To output the actual rows just change row 9 to "fdata" to return that filtered range.

hope that makes sense and works

First off I'm glad this is helpful.  As for a tweak to make it match words exactly might be:

=LET(list,TEXTSPLIT(C2," "),SUM(--(MMULT(--ISNUMBER(SEARCH(" "&list&" "," "&$B$2:$B$10&" ")),SEQUENCE(COLUMNS(list),,1,0))>0)))

but of course then "topic" will NOT find "topics" or "topic-1" or "1)topic"

fyi what i did was add a " " before and after each search term AND before and after each cell so if the cell has "topic" as the beginning, end or only word it will still be found.