Oracle 求文本相似度的问题

http://docs.oracle.com/cd/E18283_01/appdev.112/e16760/u_match.htm

http://www.tuicool.com/articles/NBZFfe

https://en.wikipedia.org/wiki/String_similarity

https://github.com/rockymadden/stringmetric/

String metric

From Wikipedia, the free encyclopedia

  (Redirected from String similarity)

"String distance" redirects here. For the distance between strings and the fingerboard in musical instruments, see  Action (music).

In mathematics and computer science, a string metric (also known as a string similarity metric or string distance function) is a metric that measuresdistance ("inverse similarity") between two text strings for approximate string matching or comparison and in fuzzy string searching. A necessary requirement for a string metric (e.g. in contrast to string matching) is fulfillment of the triangle inequality. For example, the strings "Sam" and "Samuel" can be considered to be close. A string metric provides a number indicating an algorithm-specific indication of distance.

The most widely known string metric is a rudimentary one called the Levenshtein Distance (also known as Edit Distance). It operates between two input strings, returning a number equivalent to the number of substitutions and deletions needed in order to transform one input string into another. Simplistic string metrics such as Levenshtein distance have expanded to include phonetic, token, grammatical and character-based methods of statistical comparisons.

String metrics are used heavily in information integration and are currently used in areas including fraud detection, fingerprint analysis, plagiarism detection, ontology merging, DNA analysis, RNA analysis, image analysis, evidence-based machine learning, database data deduplication, data mining,incremental search, data integration, and semantic knowledge integration.