I write an example to be more practive. I need to know if it is possible to next search based on the data I have in my database, fulltextsearch engines in sqlserver-2008 or Apache Solr:
Case 1:
Data in the database:
Myriam
Miriam
Myrian
Miriam
...
Query:
Myria
Results that I want to return:
Myriam
Miriam
Myrian
Miriam
Case 2:
Data in the database:
Roberto Gonzalez
Roberto Perez
...
Query:
Robeto
Results that I want to return:
Roberto Bonzalez
Roberto Perez
I want to know if is possible to search in both engines and decide which of these work
Thanks