I have a declared variable in bigquery with words that I want to identify in a table

DECLARE words_to_find DEFAULT r'(CASA|PERRO|CORAZON|GALLETA)';

WITH tabla AS
(    select 1 as row_id, 'QUIERO IR CASA' as name union all
    select 2 as row_id, 'PERRO BONITO' as name union all
    select 3 as row_id, 'GRANDE CORAZON' as name union all
    select 4 as row_id, 'LA GALLETA' as name
)

SELECT
  *
FROM tabla

I would like to extract the words that match the declared variable from the column “name”, and save them in a new column, it would be something like this

Thanks for your help

How Can I achieve this? I try using REGEXP_EXTRACT but didn’t work.