MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tutorial (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, 
description TEXT, 
FULLTEXT(description)
) ENGINE=InnoDB;
insert into tutorial(description) 
values('Acifree -O 10ml'),
('Acifree O 10ml'),
('Acifree -O 5ml'),
('Acifree -O 7ml'),
('Acifree -O 5 ml  ')

Records: 5  Duplicates: 0  Warnings: 0


select *, MATCH(Description) AGAINST('Acifree -O 10ml' IN NATURAL LANGUAGE MODE)
as score
from tutorial 
where MATCH(Description) AGAINST('Acifree -O 10ml' IN NATURAL LANGUAGE MODE)
and MATCH(Description) AGAINST('Acifree -O 10ml' IN NATURAL LANGUAGE MODE)=
(select  max(MATCH(Description) AGAINST('Acifree -O 10ml' IN NATURAL LANGUAGE MODE))
from tutorial
)


id
description
score


1
Acifree -O 10ml
0.15835624933242798

2
Acifree O 10ml
0.15835624933242798

id	description	score
1	Acifree -O 10ml	0.15835624933242798
2	Acifree O 10ml	0.15835624933242798