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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
sprinkle143489(None) 
sprinkled1633711sprinkled
sprinkler1543571sprinkler
sprinkles1534921sprinkles
besprinkle1851262besprinkle
crinkle13359412_crinkle
prickle153611012_prickle
spindle103210092sp_indle
spinule9299992sp_inule
springe103913982sprin_ge
springlet1257522springlet
sprinklers1642972sprinklers
strickle1467792strickle
wrinkle14296922_wrinkle
besprinkled2051053besprinkled
besprinkles1951103besprinkles
brickle15279933_brickle
brindle104210103_brindle
crankle133610063_crankle
cringle103010353_cringle
crinkled15357153_crinkled
crinkles14269163_crinkles
crinkly16387523_crinkly
inkle94515833___inkle
pickle144215653_p_ickle
pinkie124414273_p_inkie
pinkly155012243_p_inkly
pinole83218783_p_inole
pintle83818263_p_intle
prickled17358073_prickled
prickles162511093_prickles
prickly18367893_prickly
prince104114763_prin_ce
prink114719673_prink__
prinked143412163_prinked
prinker133412743_prinker
prinks124315383_prink_s
rankle103414883__rankle
runkle103611543__runkle
scribble14175433scribble
serine65432673serin__e
shingle117711283s_hingle
shrike134513243shri_k_e
shrine94920053shrin__e
shrink134511733shrink__
shrinkable1942493shrinkable
shrinkage1741903shrinkage
shrinker15236363shrinker
shrinks14397913shrink_s
sickle124418323s__ickle
single74520603s__ingle
spackle15369573sp_ackle
spangle1038403sp_angle
sparingly1537283sparingly
sparkle133710213sp_arkle
speckle15297553sp_eckle
spicule11269933sp_icule
spike114922843sp_i_k_e
spile75230083sp_i__le
spinage10289653sp_inage
spinal84915313sp_inal_
spinals93911863sp_inals
spinate93114813sp_inate
spindled12287643sp_indled
spindler11297983sp_indler
spindles112710353sp_indles
spindly13257383sp_indly
spine76534423sp_in__e
spinel85317333sp_inel_
spinelle1046223sp_inelle
spinels94512443sp_inels
spinose937943sp_inose
spinula9257903sp_inula
spinulae10276963sp_inulae
spinules10249333sp_inules
spiracle1255803spiracle
spittle937923sp_ittle
spline86020533splin__e
spraddle12194163spraddle
sprattle1054763sprattle
spring94526013sprin__g
springal1145973springal
springald1343683springald
springals1245373springals
springed123911323springed
springer113311753springer
springes114014033springes
springier1236023springier
springily1545583springily
springlets1344023springlets
springlike1742993springlike
springs104415923sprin_gs
springy13359663sprin_gy
sprinklered1851263sprinklered
sprinkling1743823sprinkling
sprint84526793sprin__t
sprinted113411163sprinted
sprinter103810813sprinter
sprints94113773sprin_ts
sprite84421773spri__te
spunkie13215303sp_unkie
stickle132410973s_tickle
strangle98411503strangle
strickled1665833strickled
strickles1567813strickles
strike105619733stri_k_e
surcingle1243953surcingle
swindle11389183s_windle
swingle113510563s_wingle
syringe11349473syrin_ge
tinkle103714453__tinkle
trickle133613443_trickle
trindle83311363_trindle
twinkle1464773_twinkle
unwrinkle1642473unwrinkle
winkle133812833__winkle
wrinkled16275353_wrinkled
wrinkles15296693_wrinkles
wrinkly17295753_wrinkly

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621196.62322068.9
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.09225196.1
 
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.