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

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

57 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
fingerprintings2221127(None) 
fingerprinting21181701fingerprinting_
fingerpickings277933fingerp_ickings
fingerprints1851483fingerprint___s
fingerpicking2661184fingerp_icking_
fingerprint1752484fingerprint____
fingerprinted2061024fingerprint__ed
underpaintings1862024_underpaintings
fingerings1545075finge__r___ings
fingerlings1642895finge__r__lings
imprintings1652765_i___mprintings
interlinings1355065_inter_lin_ings
interplanting1655345_interplanting_
interpreting1588305_interpr_eting_
overprinting1846875__overprinting_
underpainting1763555_underpainting_
underpinnings1762015_underp_innings
blueprinting1751816_blue_printing_
counterpointing2063036counterpointing_
enterprising1554086_enterpri_sing_
ferretings14133496f___er_r_etings
ferritins1247276f___er_ri_tin_s
fingering1439196finge__r___ing_
fingerling1544836finge__r__ling_
fingernails1551646finge__r_nai_ls
fingerpicks2351416fingerp____icks
fingerposts1751856fingerp_ost___s
fingertips1692776finge__r__ti_ps
freewritings1951256f__reewri_tings
imprinting1546026_i___mprinting_
inebriating1446056_in_e_briating_
ingraining1245626_ing_r_ain_ing_
ingratiating1454066_ing_ratiating_
inheriting1448856_inhe__ri_ting_
interdicting1647456_inter_dicting_
intergrafting1854146_intergrafting_
interjoining2054656_interjoin_ing_
interknitting1853286_interknitting_
interlining1249136_inter_lin_ing_
interlinking1755056_inter_linking_
intermitting1547256_inter_mitting_
interpolating1657796_interpolating_
interrupting1546246_inter_rupting_
intertwining1654226_intertwin_ing_
intertwisting1753316_intertwisting_
misprinting1646826mi___sprinting_
pinpointing1643106pin___pointing_
preprinting1647416__pre_printing_
printings12268106______printings
reinterpreting1762326reinterpr_eting_
reprinting131510586___re_printing_
sandpaintings176916san__dpaintings
songwritings1761266song__wri_tings
surprinting1444556___surprinting_
underpinning1653426_underp_inning_
underpricing1853986_underpri_cing_
underwriting1754126_underwri_ting_

Search took 8 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.356501941.0
2DLD Change Limit95024576.76614044.3
3Display Results57570.0461239.1
 (SQL Overall)178691577.16824929.0
 
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.