MySQL 8.0

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

CREATE TABLe t1 (title varchar(20),
          FULLTEXT (title))
insert into t1 VALUES ("men\'s t'shirts"),("men\'s socks"),("men\'s socks short")

Records: 3  Duplicates: 0  Warnings: 0


SELECT * ,
(IF(MATCH (title)
        AGAINST ("men\'s" IN NATURAL LANGUAGE MODE) > 0,1,0) 
        )+
        (IF(MATCH (title)
        AGAINST ('socks' IN NATURAL LANGUAGE MODE) > 0,2,0) )
+
        (IF(MATCH (title)
        AGAINST ("+men\'s +socks" IN NATURAL LANGUAGE MODE) > 0.03,3,0))    as weight   
        FROM t1


title
weight


men's t'shirts
1

men's socks
6

men's socks short
6