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

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

87 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
sprinkling174382(None) 
sprinklings1841861sprinklings
besprinkling2151142besprinkling
crinkling16145862_crinkling
prickling1836532_prickling
prinking153212452_prink_ing
shrinking1735652shrink_ing
spindling13136272sp_indling
springeing1444372springeing
springing1338742sprin_ging
sprinklering1951082sprinklering
sprinting12310032sprin_ting
strickling1744952strickling
wrinkling17144952_wrinkling
crankling16147293_crankling
drinking14308913_drink_ing
inkling122911303___inkling
pickling17239203_p_ickling
pindling122110983_p_indling
pinking143918943_p_ink_ing
plinking153611243_plink_ing
pranking153813383_prank_ing
pricking173212603_prick_ing
prilling113413413_pri_lling
princeling1544653_princeling
printing113216083_prin_ting
rankling132610113__rankling
runkling13217613__runkling
scribbling1742553scribbling
shingling14136973s_hingling
shrieking1734583shriek_ing
shrilling13307693shri_lling
shrining122610853shrin__ing
shriveling1743253shriveling
sickling152910333s__ickling
singling101913003s__ingling
sinking123320543s__ink_ing
skinking12299773s_kink_ing
slinking133412983s_link_ing
spackling18266503sp_ackling
spangling1336373sp_angling
spanking153911973sp_ank_ing
sparkling16226353sp_arkling
speckling18235583sp_eckling
speiling113612973spei__ling
spieling113212523sp_i_eling
spiking144312883sp_i_k_ing
spiling102919703sp_i__ling
spilling113113943sp_i_lling
spinning113310813sp_in_ning
spiraling1237953sp_iraling
spiralling1343963spiralling
splining11310773splin__ing
splinting1238193splin_ting
spoiling112911553spoi__ling
spraddling1542313spraddling
spraining1248153sprain__ing
sprattling1363053sprattling
sprawling15175123spr_awling
sprigging1435893spri_gging
springings1444663sprin_gings
springlike1742993springlike
sprinkle1434893sprinkl__e
sprinkled1633713sprinkl_ed
sprinkler1543573sprinkl_er
sprinklers1642983sprinklers
sprinkles1534933sprinkl_es
spritzing2135393spri_tzing
spunking15258063sp_unk_ing
stickling1647003s_tickling
stinking133113543s_tink_ing
strangling1256403strangling
striking133012233stri_k_ing
stringing1139753strin_ging
stripling1257783stri_pling
surcingling1551823surcingling
swindling14135833s_windling
swingling14156203s_wingling
swinking163410323s_wink_ing
syringing1435883syrin_ging
tinkling13239233__tinkling
trickling1647723_trickling
trindling1137133_trindling
twinkling1743643_twinkling
unwrinkling1951563unwrinkling
uplinking1634623uplink_ing
winkling16298293__winkling

Search took 7 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 Filter1786911406030.420425454.8
2DLD Change Limit140603875.73624512.4
3Display Results87870.0461891.3
 (SQL Overall)178691876.20228811.8
 
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.