sql - MySQL Show best match between two tables -

i have challenge in mysql, i'm complete rookie on subject really, here goes.

i'm trying make application lets user input ingredients have @ home, , give response recipes user make.

i have 2 tables.

recipe id - name - description

and

ingre id - name

so far sql looking this:

create temporary table temptable(     id int( 3 ) not null auto_increment primary key,        searchword varchar( 255 )     );  insert temptable( searchword ) values ('carrot'),('potato');  select * ingre, temptable     ingre.name concat('%', temptable.searchword, '%'); 

my idea make count recipe table see how many ingredients specific recipe requires , response make list of "best matches".

to more clear:

if recipe example above requires 1 carrot, 1 potato , 1 onion, know fulfill 66% of recipe, , result should shown above recipe requires 1 carrot, 1 potato, 1 onion , 1 apple.

do guys have idea how should proceed this?

kind regards,