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

196 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
twinkies153598(None) 
twankies1535891twankies
twinkie1434571twinkie_
twinkles1535071twinkles
dinkies123716032_dinkies
pinkies133818262_pinkies
tinkles113713922t_inkles
twenties1137502twenties
twines94717272twin__es
twinges11409452twin_ges
twinier1037312twin_ier
twiniest1147152twin_iest
twinkle1464772twinkle_
twinkled1663942twinkled
twinkler1564072twinkler
twinklers1633062twinklers
winkles143412772_winkles
bikies124515163_bi_kies
birkies133712433_birkies
brinies93317913brin_ies
chinkier17377363chinkier
chinkiest1867023chinkiest
crinkles14269163crinkles
dainties9312403dainties
dickies143416343_dickies
dingies93618243_dingies
dinkier123411503_dinkier
dinkiest133812873_dinkiest
dwindles13366023dwindles
dwines105013103dwin__es
flinkites1643483flinkites
flunkies1536393flunkies
hankies143617763_hankies
heinies102514543hein_ies
hickies163614743_hickies
hinkier143610793_hinkier
hinkiest153311753_hinkiest
hinnies103615103_hinnies
honkies143015143_honkies
hunkies143214503_hunkies
indies73822783__indies
inkier104013783__inkier
inkiest113415043__inkiest
inkles103515653__inkles
junkies183711693_junkies
kinkier10319433_kinkier
kinkiest113110503_kinkiest
lindies8416583_lindies
meinies92516073mein_ies
minkes124618783_mink_es
minnies93617363_minnies
ninnies73713613_ninnies
pinkie124414273_pinkie_
pinkoes135512313_pinkoes
pinnies93318443_pinnies
pliskies1475973pliskies
punkies134216803_punkies
quickies2336773quickies
quinsies1737623quinsies
shindies122610503shindies
shinnies113010913shinnies
sickies133717503_sickies
silkies113715693_silkies
slinkier12206933slinkier
slinkiest13188073slinkiest
spinnies103210543spinnies
spunkies14227583spunkies
stickies142211973stickies
stinkier12278543stinkier
stinkiest13198463stinkiest
swankier15225503swankier
swankiest16136203swankiest
swindles12319503swindles
swinges113413423swin_ges
swingier12267003swingier
swingiest13207573swingiest
swingles12319543swingles
swinked15349033swink_ed
swinking163410323swinking
swinks134610653swink__s
talkies113415733t_alkies
tansies74521243t_ansies
tawnies102812503tawn_ies
tekkies1035943t_ekkies
tennies73017973t_ennies
thinker143610683think_er
thinkers15308703thinkers
thinking16289863thinking
thinkings17255053thinkings
thinks134613363think__s
thirties1139723thirties
tickles133416853t_ickles
tidies74721833t_i_dies
tikes95628903t_i_k_es
tikis95615973t_i_ki_s
tineids8337873t_ineids
tines54848423t_in__es
tinges74722333t_in_ges
tingles83818323t_ingles
tinier63622233t_in_ier
tiniest73020123t_in_iest
tinker103619923t_ink_er
tinkers113517143t_inkers
tinkle103714453t_inkle_
tinkled123910473t_inkled
tinkler113610543t_inkler
tinklers12298183t_inklers
tinklier1255443t_inklier
tinkliest1336133t_inkliest
tinnier72910143t_innier
tinniest82911463t_inniest
titties73617363t_itties
tizzies15287893t_izzies
toonies73719883toon_ies
townies103113623town_ies
trannies8415013trannies
trendies9312213trendies
trickie132611033trickie_
trickier143010233trickier
trickiest1549023trickiest
trickles143013763trickles
trikes105419493tri_k_es
trilbies1037693trilbies
trindles93211683trindles
trines64132563trin__es
trinities9313343trinities
trinket11314813trink_et
trinkets1237143trinkets
trinkums1443413trinkums
tunnies73614263t_unnies
twangier1254243twangier
twangiest1355223twangiest
twangles1245743twangles
tweakier1533143tweakier
tweakiest1634053tweakiest
tweenies11146393tweenies
twibils1253113twi_bils
twiddles13265613twiddles
twiggier1333073twiggier
twiggiest1443413twiggiest
twine85822363twin__e_
twined104413123twin__ed
twiner94012593twin__er
twiners10459633twin_ers
twinge104210403twin_ge_
twinged12398363twin_ged
twinging13278423twinging
twining113211443twin_ing
twinjet1735113twin_jet
twinjets1842413twinjets
twinkling1743643twinkling
twinklings1841883twinklings
twinkly1733913twink_ly
twinned11366333twin_ned
twinning12367043twinning
twinnings13253663twinnings
twins85118983twin___s
twinset1039373twin_set
twinsets1133663twinsets
twinships1744123twinships
twirlier1133513twirlier
twirliest1234503twirliest
twistier1134813twistier
twistiest1235433twistiest
twitches16156373twitches
twoonies1155693twoonies
whinnies14237273whinnies
whiskies1835953whiskies
widdies123514033_widdies
wienies102213683_wienies
willies103920153_willies
winces114819113_win_ces
winches154714373_winches
windier113412163_windier
windiest122213233_windiest
windles113518493_windles
wineries112316533_wineries
wines85546863_win__es
wingier113413283_wingier
wingiest123214283_wingiest
winier94522453_win_ier
winiest103419693_win_iest
winked144018603_wink_ed
winker134220293_wink_er
winkers143517113_winkers
winking153317963_winking
winkle133812833_winkle_
winkled15299593_winkled
winks125325433_wink__s
winoes94317013_win_oes
wintles103414983_wintles
winzes184313053_win_zes
withies133913543_withies
wonkier1437423_wonkier
wonkiest1538943_wonkiest
wrinkles15296693wrinkles

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 Limit1461621967.31319986.6
3Display Results1961960.0633111.1
 (SQL Overall)1786911967.79922912.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.