I want to implement a database search that is insensitive to plural/singular, order and case of the words used in an input string. I am using MySQL database. For example if the input string is: "woman looking for a desktop, Printers and laptopS" the search must return all rows that contain any of the following words in any order and whether they contain upper or lower case letters: woman women desktop desktops printer printers laptop laptops How do I do this? MySQL fulltext search cannot handle the plural/singular and regular expressions in MySQL are sensitive to the order of the words.