Dave Jarvis' Repositories

select
  *
from
  recipe.ingredient_name rin1,
  recipe.ingredient_name rin2
where
  rin1.label <> rin2.label and
  similarity( rin1.label, rin2.label ) > 0.7;

/*
delete from recipe.ingredient_name_category where ingredient_name_id in (2113,1378);
delete from recipe.ingredient_name where id in (2113, 1378);
--update recipe.ingredient_name set label='long-grain white rice' where id=1991;
*/