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 “fingerprintingsa” with Change Limit: [1] [2] [3] [4] [5] [6] [7] [8]

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

58 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
fingerprintings22211271fingerprintings_
fingerprinting21181702fingerprinting__
fingerpickings277934fingerp_ickings_
fingerprints1851484fingerprint___s_
fingerpicking2661185fingerp_icking__
fingerprint1752485fingerprint_____
fingerprinted2061025fingerprint___ed
underpaintings1862025_underpaintings_
fingerings1545076finge__r___ings_
fingerlings1642896finge__r__lings_
imprintings1652766_i___mprintings_
interlinings1355066_inter_lin_ings_
interplanting1655346_interplanting__
interpreting1588306_interpr_eting__
overprinting1846876__overprinting__
underpainting1763556_underpainting__
underpinnings1762016_underp_innings_
blueprinting1751817_blue_printing__
counterpointing2063037counterpointing__
enterprising1554087_enterpri_sing__
ferretings14133497f___er_r_etings_
ferritins1247277f___er_ri_tin_s_
fingering1439197finge__r___ing__
fingerling1544837finge__r__ling__
fingernails1551647finge__r_nai_ls_
fingerpicks2351417fingerp____icks_
fingerposts1751857fingerp_ost___s_
fingertips1692777finge__r__ti_ps_
freewritings1951257f__reewri_tings_
imprinting1546027_i___mprinting__
inebriating1446057_in_e_briating__
ingraining1245627_ing_r_ain_ing__
ingratiating1454067_ing_ratiating__
ingratiatingly1961467_ing_ratiatingly
inheriting1448857_inhe__ri_ting__
interdicting1647457_inter_dicting__
intergrafting1854147_intergrafting__
interjoining2054657_interjoin_ing__
interknitting1853287_interknitting__
interlining1249137_inter_lin_ing__
interlinking1755057_inter_linking__
intermitting1547257_inter_mitting__
interpolating1657797_interpolating__
interrupting1546247_inter_rupting__
intertwining1654227_intertwin_ing__
intertwisting1753317_intertwisting__
misprinting1646827mi___sprinting__
pinpointing1643107pin___pointing__
preprinting1647417__pre_printing__
printings12268107______printings_
reinterpreting1762327reinterpr_eting__
reprinting131510587___re_printing__
sandpaintings176917san__dpaintings_
songwritings1761267song__wri_tings_
surprinting1444557___surprinting__
underpinning1653427_underp_inning__
underpricing1853987_underpri_cing__
underwriting1754127_underwri_ting__

Search took 10 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 Filter178691950240.343520965.0
2DLD Change Limit95024588.73610877.3
3Display Results58580.0461260.9
 (SQL Overall)178691589.12519582.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.