php - How do I divide words with certain criteria? -
i have list of 100k names. example:
hp dell google microsoft techcrunch stcakoverflow
want search database find similar names. looking if name hp
no trim if dell
trim last 1 called del
, if google
became goo
trim last 3 , if microsoft
micro
trim rest. , if techcrunch
should techcr
, if stackoverflow
should stackov
that. want achieve want find similar names name going search.
this answer may possibly you, alternative or something...
implementation of levenshtein distance mysql/fuzzy search?
or link http://www.artfulsoftware.com/infotree/queries.php#552
Comments
Post a Comment