Stemming causes false positives in filters about temboz HOT 5 CLOSED

select * from (
  select rule_text, sum(case when item_loaded < julianday('2015-06-22') then 1 else 0 end) as before,
  sum(case when item_loaded > julianday('2015-06-22') then 1 else 0 end) as after
  from fm_rules join fm_items on item_rule_uid=rule_uid
  where rule_type like '%_word' group by 1
) order by after/(before + 1) desc limit 20;

select * from (
  select rule_uid, rule_type, rule_text,
    sum(case when item_loaded < julianday('2015-06-22') then 1 else 0 end)
      as before,
    sum(case when item_loaded > julianday('2015-06-22') then 1 else 0 end)
      as after
  from fm_rules
  join fm_items on item_rule_uid=rule_uid
  where rule_type like '%_word' and rule_type not like '%exactword'
  group by 1,2,3
)
order by after/(before + 1) desc
limit 20;

update fm_rules set rule_type=replace(rule_type, '_word', '_exactword')
where rule_uid in (...,...,...);

update fm_rules set rule_type=replace(rule_type, '_word', '_exactword')
where rule_uid in (
  select rule_uid from (
    select rule_uid, rule_type, rule_text,
      sum(case when item_loaded < julianday('2015-06-22') then 1 else 0 end)
        as before,
      sum(case when item_loaded > julianday('2015-06-22') then 1 else 0 end)
        as after
    from fm_rules
    join fm_items on item_rule_uid=rule_uid
    where rule_type like '%_word' and rule_type not like '%exactword'
    group by 1,2,3
  )
  order by after/(before + 1) desc
  limit 20
);