Alien vs. Predator search query

Question

How do you do this when you search for “alien versus predator” you also get results with the string “alienS vs predator” with “S”
example http://www.torrentz.com/search?q=alien+vs+predator
like them implemented it?
is it an advanced search engine?

Answer 1

This is called Word Stemming . When the text is indexed, the words "flock" to their "roots". Thus, the struggle becomes the struggle, the ski becomes the ski, the run starts, etc. The same is done with the text that the user enters during the search, so when the search terms are compared with the values ​​in the index, they match.

The Lucene project supports this. I would not consider it as an additional function. Especially with the expectations that Google has set.

Answer 2

- . Stemming - . . wikipedia: http://en.wikipedia.org/wiki/Stemming , .

Answer 3

, , , :

SELECT * FROM TBLMOVIES WHERE NAME LIKE '%ALIEN%'

, ALIEN NAME, , ALIENS.

Answer 4

, . , "", "", "", "" "".

"".

. - http://tartarus.org/~martin/PorterStemmer/

Answer 5

, , .

, , , , .

Answer 6

soundex() . soundex , , LIKE 'XXX%', . , .

. : http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_soundex