PHP Classes

What is the best PHP auto correct spelling class?: I need search class that suggests available keyword in database

Recommend this page to a friend!
  All requests RSS feed  >  What is the best PHP auto correct spe...  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

What is the best PHP auto correct spelling class?

Edit

Picture of saurabh claritus by saurabh claritus - 10 years ago (2015-02-04)

I need search class that suggests available keyword in database

This request is clear and relevant.
This request is not clear or is not relevant.

+3

I have multiple Hindi songs in our site but at time of searching I did not get the right song due to spelling mismatch.

So I need a solution which can make search into my database with wrong spelling as well return the right song, for instance PHOOL is similar to POOL, FOOL, FUL.

So it must suggest all available records from database.

  • 1 Clarification request

  • 1. Picture of Tariqul Islam by Tariqul Islam - 10 years ago (2015-02-04) Reply

    You can use following code to search:

    SELECT * FROM table WHERE table.column LIKE SOUNDEX('search_value');

    If its not helpful for you or need any further assistance then inform me.

    Ask clarification

    1 Recommendation

    PHP MySQL Full Text Search: Perform full text search on MySQL with autocorrect

    This class can perform full text searches on MySQL with auto-correct.

    It takes a given keyword and performs a SQL query on a given MySQL database table field using full text search matching.

    If the search returns no results, the class may fallback to pattern searching.

    The class may optionally perform auto-correction of the search keyword using Felipe Ribeiro spell corrector class.

    The class can also alter the MySQL table to add a full text search index to the field to be search. If necessary it may alter the table type to MyISAM in case the current table type does not support full text searching.
    This recommendation solves the problem.
    This recommendation does not solve the problem.

    +2

    Picture of Manuel Lemos by Manuel Lemos Reputation 26695 - 10 years ago (2015-02-10) Comment

    It seems this package does exactly what you want. It can search your database for records but first it may auto-correct your search keywords using another class.

    Recommend package
    : 
    :