Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “fingerprint” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

33 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
fingerprint175248(None) 
fingerprints1851481fingerprints
fingerprinted2061022fingerprinted
fingering1439193finge__ring
fingerling1544833finger_ling
fingerpick2251493fingerp_ick
fingerpost1652813fingerp_ost
fingerprinting21181703fingerprinting
interpoint12411883_interpoint
fingerer12127224fingerer___
fingerers13136304fingerer__s
fingerings1545074finge__rings
fingerlike1842944finger_like
fingerlings1642894finger_lings
fingernail1451684fingernai_l
fingernails1551644fingernails
fingerpicking2661184fingerpicking
fingerpicks2351414fingerpicks
fingerposts1751854fingerposts
fingerprintings22211274fingerprintings
fingertip1572734finger_ti_p
fingertips1692784finger_tips
gingering1238874ginge__ring
gingerroot1252384ginger_root
inerrant8412494_in_er_rant
inferring1338614_infer_ring
innerspring1452654_innerspring
interplant12119574_interplant
interpret11413364_interpr_et
interring10315424_inter_ring
lingering11310514linge__ring
overprint14412254__overprint
silverpoint1651914silverpoint

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911488190.423422437.4
2DLD Change Limit148819338.43617640.9
3Display Results33330.0162062.5
 (SQL Overall)178691338.87520134.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.