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

190 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
twinkler156407(None) 
tinkler113610541t_inkler
twinkle1464771twinkle_
twinkled1663941twinkled
twinklers1633061twinklers
twinkles1535071twinkles
swindler12257722swindler
thinker143610682think_er
tickler133612652t_ickler
tingler83613342t_ingler
tinker103619922t_ink_er
tinkle103714452t_inkle_
tinkled123910472t_inkled
tinklers12298182t_inklers
tinkles113713922t_inkles
tinklier1255442t_inklier
twangler1244112twangler
twiddler13244872twiddler
twiner94012592twin__er
twinier1037312twin_ier
twinkie1434572twinkie_
twinkies1535982twinkies
twinkly1733912twinkl_y
twirler10285202twi_rler
winker134220292_wink_er
winkle133812832_winkle_
winkled15299592_winkled
winkles143412772_winkles
blinker134110213blink_er
chinkier17377363chinkier
clinker133811663clink_er
crinkle13359413crinkle_
crinkled15357153crinkled
crinkles14269163crinkles
crinklier1543843crinklier
dinkier123411503_dinkier
drinker12349483drink_er
dwindle12415883dwindle_
dwindled14385023dwindled
dwindles13366023dwindles
fickler16348423_fickler
hinkier143610793_hinkier
inker94421093__ink_er
inkier104013783__inkier
inkle94515833__inkle_
inkles103515653__inkles
jingler154311093_jingler
jinker174013543_jink_er
kindler12309983_kindler
kinkier10319433_kinkier
linker104321473_link_er
mickler153310233_mickler
mingler104213843_mingler
pinker125322443_pink_er
plinker134010963plink_er
prinker133412743prink_er
shingler12268633shingler
sinker103620903_sink_er
skinker10319443skink_er
slinkier12206933slinkier
spindler11297983spindler
sprinkler1543573sprinkler
stickler14259573stickler
stinker113313313stink_er
stinkier12278543stinkier
swanker14369483swank_er
swankier15225503swankier
swiller103211663swi_ller
swindle11389183swindle_
swindled13307623swindled
swindlers13306033swindlers
swindles12319503swindles
swinger113812563swin_ger
swingier12267003swingier
swingle113510563swingle_
swingled13337433swingled
swingles12319543swingles
swinked15349033swink_ed
swizzler1963223swizzler
tackler134013323t_ackler
tailer63823733tai__ler
tangler83515073t_angler
tanker104521123t_ank_er
thanker14309593thank_er
thicker163611023thick_er
thinkers15308703think_ers
thinner10358973thin_ner
ticker124321503t_ick_er
tickle124616743t_ickle_
tickled144313133t_ickled
ticklers14339303t_icklers
tickles133416853t_ickles
tiddler93110003t_iddler
tiler56131023t_i__ler
tiller64222543t_i_ller
tinder73821803t_in_der
tingle74319063t_ingle_
tingled93712803t_ingled
tinglers93710593t_inglers
tingles83818323t_ingles
tinglier956403t_inglier
tinier63622233t_in_ier
tinkerer1286803t_inkerer
tinkers113517143t_ink_ers
tinkly134811153t_inkl_y
tinner64119963t_in_ner
tinnier72910143t_innier
tinter63923643t_in_ter
tippler11348343t_ippler
toiler63918283toi__ler
tricker134615523trick_er
trickier143010233trickier
trickle133613443trickle_
trickled152610433trickled
trickles143013763trickles
tricklier15256823tricklier
trifler103912153tri_fler
triller74215893tri_ller
trindle83311363trindle_
trindled10388693trindled
trindles93211683trindles
trinket11314813trink_et
trinketer1344563trinketer
truckler14297453truckler
trundler9256153trundler
tunneler864473tunneler
twaddler13314643twaddler
twanger11327433twan_ger
twangier1254243twangier
twangle1145803twangle_
twangled1364173twangled
twanglers1363433twanglers
twangles1245743twangles
twankies1535893twankies
tweakier1533143tweakier
twiddle12305483twiddle_
twiddled14284633twiddled
twiddlers14313693twiddlers
twiddles13265613twiddles
twiddlier1441863twiddlier
twier84713293twi___er
twiggier1333073twiggier
twilled11398033twi_lled
twine85822363twin__e_
twined104413123twin__ed
twiners10459633twin__ers
twines94717273twin__es
twinflower1951993twinflower
twinge104210403twin_ge_
twinged12398363twin_ged
twinges11409453twin_ges
twinjet1735113twin_jet
twinkling1743643twinkling
twinned11366333twin_ned
twinset1039373twin_set
twirled11385983twi_rled
twirlers11274303twi_rlers
twirlier1133513twirlier
twister10308953twi_ster
twistier1134813twistier
twitcher16135343twitcher
twitter10278093twi_tter
wangler113312653_wangler
wanker134219973_wank_er
wicker154518673_wick_er
wiggler123110763_wiggler
willer94021063_wi_ller
wincer115018193_win_cer
wincher153410653_wincher
winder104025263_win_der
windier113412163_windier
windle104617953_windle_
windled123713483_windled
windles113518493_windles
winger104125443_win_ger
wingier113413283_wingier
winglet113115983_winglet
winier94522453_win_ier
winked144018603_wink_ed
winkers143517113_wink_ers
winner94219933_win_ner
winter94222803_win_ter
wintle94014603_wintle_
wintled11339843_wintled
wintles103414983_wintles
wonkier1437423_wonkier
wrinkle14296923wrinkle_
wrinkled16275353wrinkled
wrinkles15296693wrinkles
wrinklier1643013wrinklier

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 Filter1786911461620.483369960.7
2DLD Change Limit1461621907.73618893.7
3Display Results1901900.0633015.9
 (SQL Overall)1786911908.28221575.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.