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 “twinkle” 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.

203 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
twinkle146477(None) 
tinkle103714451t_inkle
twinkie1434571twinkie
twinkled1663941twinkled
twinkler1564071twinkler
twinkles1535071twinkles
twinkly1733911twinkly
winkle133812831_winkle
crinkle13359412crinkle
dwindle12415882dwindle
inkle94515832__inkle
swindle11389182swindle
swingle113510562swingle
tickle124616742t_ickle
tingle74319062t_ingle
tinkled123910472t_inkled
tinkler113610542t_inkler
tinkles113713922t_inkles
tinkly134811152t_inkly
trickle133613442trickle
trindle83311362trindle
twangle1145802twangle
twiddle12305482twiddle
twine85822362twin__e
twinge104210402twin_ge
twinkies1535982twinkies
twinklers1633062twinklers
windle104617952_windle
winkled15299592_winkled
winkles143412772_winkles
wintle94014602_wintle
wrinkle14296922wrinkle
ankle95220253__ankle
atingle848253atingle
bindle94516263_bindle
brickle15279933brickle
brindle104210103brindle
crankle133610063crankle
cringle103010353cringle
crinkled15357153crinkled
crinkles14269163crinkles
crinkly16387523crinkly
dindle84417223_dindle
dingle84317073_dingle
dinkly144311083_dinkly
dwindled14385023dwindled
dwindles13366023dwindles
dwine95616143dwin__e
fickle153912973_fickle
finale94116763_finale
gwine95513663gwin__e
ingle64120433__ingle
inkles103515653__inkles
jingle143815223_jingle
kindle114414233_kindle
meikle1236653mei_kle
mickle143715133_mickle
mingle93518783_mingle
minke115421763_mink_e
nickle123814483_nickle
pickle144215653_pickle
pinkie124414273_pinkie
pinkly155012243_pinkly
pinole83218783_pinole
pintle83818263_pintle
prickle153611013prickle
rankle103414883_rankle
runkle103611543_runkle
shingle117711283shingle
sickle124418323_sickle
single74520603_single
spindle103210093spindle
spinule9299993spinule
sprinkle1434893sprinkle
stickle132410973stickle
strickle1467793strickle
swindled13307623swindled
swindler12257723swindler
swindles12319503swindles
swine85625303swin__e
swinge105614383swin_ge
swingled13337433swingled
swingles12319543swingles
swink125116353swink__
swinked15349033swinked
swinks134610653swink_s
swiple11379233swi_ple
swipple1444633swipple
swizzle1854103swizzle
tackle123815733t_ackle
taille63116923tai_lle
tangle74019953t_angle
thickly19415573thickly
thimble1435873thimble
thine85026863thin__e
think125018803think__
thinkable1844063thinkable
thinker143610683thinker
thinks134613363think_s
thinly1238673thin_ly
thistle10107803thistle
tickled144313133t_ickled
tickler133612653t_ickler
tickles133416853t_ickles
tike85534483t_i_k_e
tile45451443t_i__le
tine45855133t_in__e
tinge64626623t_in_ge
tingled93712803t_ingled
tingler83613343t_ingler
tingles83818323t_ingles
tingly103815973t_ingly
tinily94014433t_inily
tinker103619923t_inker
tinklers12298183t_inklers
tinklier1255443t_inklier
tinsel639443t_insel
tipple103411913t_ipple
title54721073t_i_tle
tittle63613323t_ittle
toile54626493toi__le
triable92515393triable
triangle935533triangle
trickie132611033trickie
trickled152610433trickled
trickles143013763trickles
trickly16369893trickly
trifle94012883tri_fle
trike95320163tri_k_e
trinal6516963trinal_
trindled10388693trindled
trindles93211683trindles
trine54734603trin__e
trinket11314813trinket
triple84215923tri_ple
triskele1244573triskele
truckle13358863truckle
trundle8307873trundle
tuille63012643tui_lle
tunicle9308033tunicle
twaddle12245713twaddle
twangled1364173twangled
twangler1244113twangler
twangles1245743twangles
twankies1535893twankies
twanky16445773twank_y
twattle1064273twattle
tweedle1134193tweedle
twibil1133563twibil_
twibill1242743twibill
twibils1253113twibils
twice104711123twi__ce
twiddled14284633twiddled
twiddler13244873twiddler
twiddles13265613twiddles
twiddly15233773twiddly
twill85612723twi__ll
twilled11398033twi_lled
twills9489793twi_lls
twin76023083twin___
twined104413123twin_ed
twiner94012593twin_er
twiners10459633twiners
twines94717273twin_es
twinged12398363twinged
twinges11409453twinges
twinier1037313twinier
twining113211443twining
twinjet1735113twinjet
twinkling1743643twinkling
twinned11366333twinned
twins85118983twin__s
twinset1039373twinset
twiny116012813twin__y
twirl85011943twi_rl_
twirled11385983twi_rled
twirler10285203twi_rler
twirls9478123twi_rls
twirly12427083twi_rly
unwrinkle1642473unwrinkle
veinule1056243veinule
wandle105316663_wandle
wangle103817503_wangle
widdle113814843_widdle
wiggle113713013_wiggle
wile75944373_wi__le
wimble133211923_wimble
wimple133611363_wimple
wince105220883_win_ce
windled123713483_windled
windles113518493_windles
wine74953423_win__e
winglet113115983_winglet
wink116435023_wink__
winked144018603_winked
winker134220293_winker
winks125325433_wink_s
wintled11339843_wintled
wintles103414983_wintles
winze175014853_win_ze
wrinkled16275353wrinkled
wrinkles15296693wrinkles
wrinkly17295753wrinkly

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272037.78017227.1
3Display Results2032030.0802537.5
 (SQL Overall)1786912038.01622291.8
 
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.