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

326 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
spangles113889(None) 
spangle1038401spangle_
spangled1236151spangled
angles74426702__angles
bangles103617412_bangles
bespangles1542132bespangles
dangles93618422_dangles
espanoles1143942espanoles
jangles154015682_jangles
mangles104021462_mangles
pungles104013712_pungles
shingles123111112shingles
singles83520432s_ingles
spackles16319952spackles
spales84728102spa__les
spancels1245272spancels
spanglier1244192spanglier
spangliest1345152spangliest
spangly1336472spangl_y
spaniels1045962spaniels
spanless10247362span_less
spansules1143612spansules
sparges104016342sparg_es
sparkles143210492sparkles
spatzles1935302spatzles
spindles112710352spindles
spinules10249332spinules
sponges10311042spong_es
strangles103011552strangles
swingles12319542swingles
tangles83920042_tangles
twangles1245742twangles
wangles113416932_wangles
wrangles1237462wrangles
aneles64626293__aneles
angels74416173__angels
angle64528873__angle_
angled84219093__angled
angler74017863__angler
anglers84014823__anglers
anglos74413913__anglos
ankles104818383__ankles
anoles64827433__anoles
apanages1137013apanages
argles75218483__argles
bangle94018953_bangle_
beagles103212123bea_gles
bespangle1442543bespangle_
bespangled1641893bespangled
bungles104116763_bungles
candles104422343_candles
cangues10611823_cangues
cantles94721413_cantles
changes134517583chang_es
crankles143510153crankles
cringles11329463cringles
daggles103611913_daggles
dandles94218533_dandles
dangle84119303_dangle_
dangled104013153_dangled
dangler96912813_dangler
danglers103610593_danglers
dingles93818323_dingles
dongles93212873_dongles
draggles1145963draggles
eagles73819163_ea_gles
entangles1075563entangles
evangels1243733evangels
fangless1237663_fangless
fenagles12186083fenagles
finagles12237553finagles
flanges113413273flang_es
gaggles103512593_gaggles
gangues9149753_gangues
gargles94214893_gargles
granges93516523grang_es
granules939933granules
haggles123312483_haggles
handles114020653_handles
hantles104117513_hantles
ingles74420873__ingles
jangle144416293_jangle_
jangled164111563_jangled
jangler153811833_jangler
janglers16319373_janglers
jingles153816383_jingles
jungles154112543_jungles
langley1147453_langley
langleys1245103_langleys
langues81211913_langues
mangels103614493_mangels
manges94628943_mang_es
mangle93921323_mangle_
mangled113615263_mangled
mangler103215643_mangler
manglers113311903_manglers
mangoes104316133_mangoes
mantles94820703_mantles
mingles103719003_mingles
octangles1243463octangles
oranges84215333orang_es
paddles113515643_paddles
padles95221123_pa_dles
pages85235073_pa_g_es
pales75753803_pa__les
pandies104224503_pandies
paneled10612573_paneled
paneless102611763_paneless
panels84716523_panel_s
panes76148693_pan__es
pangas99921103_pang_as
panged104722333_pang_ed
pangen94115913_pang_en
pangenes112612823_pangenes
pangens103112063_pangens
pangs84628663_pang__s
panicles121010113_panicles
pannes85522853_pan_nes
pansies94521983_pansies
panties94230933_panties
pantiles103617153_pantiles
papules112411573_papules
parges94529543_parg_es
parles86334403_pa_rles
paroles95025883_paroles
pingoes105116523_pingoes
pinoles93418703_pinoles
pintles94118723_pintles
pongees104212543_pongees
pungle94413573_pungle_
pungled114210083_pungled
raggles93813283_raggles
ranges73826923_rang_es
rankles113114543_rankles
sables85026693s_a_bles
saddles95415743s_addles
sages65339063s_a_g_es
sales56055593s_a__les
samples112815453s_amples
sandless93212343s_andless
sanes55649073s_an__es
sangars83116253s_angars
sangas75222653s_ang_as
sanger74524563s_ang_er
sangers84421943s_angers
sanghs105312063s_ang_hs
sanicles10149943s_anicles
sanies63031953s_an_ies
sarges75128593s_arg_es
scabbles14167983scabbles
scales84529313sca__les
scanties103215423scanties
seances93015343sean_ces
semiangles1343473semiangles
seniles72618023s_eniles
shackles173010593shackles
shales94731253sha__les
shambles15159043shambles
shandies122714103shandies
shannies113411253shannies
shanties113116583shanties
shingle117711283shingle_
shingled13358323shingled
shingler12268633shingler
shinglers13246443shinglers
singes74326853s_ing_es
single74520603s_ingle_
singled93914683s_ingled
singlet84120113s_inglet
singlets93611473s_inglets
skatoles1236143skatoles
slanged94112853slang_ed
slangier9117933slangier
slangiest10129073slangiest
slangs75615343slang__s
smuggles12225443smuggles
snaffles14246043snaffles
sniggles10307313sniggles
snuggles10306143snuggles
songless9218823s_ongless
spaceless1335733spaceless
spaces104722633spa__ces
spackle15369573spackle_
spackled17297803spackled
spades94222583spa__des
spadices1336093spadices
spadilles1244993spadilles
spadixes1834113spadixes
spadones1137253spadones
spaes76029973spa___es
spaetzles2042153spaetzles
spahees1238263spa_hees
spails84817823spa_il_s
spale74929213spa__le_
spalled103113133spa_lled
spaller92713473spa_ller
spallers102910733spa_llers
spalls84217343spa__lls
spancel1147363span_cel
spanceled1443693spanceled
spandex1735833span_dex
spandexes1943453spandexes
spandrel1144063spandrel
spandrels1243253spandrels
spang84919733spang___
spangling1336373spangling
spaniel948923span_iel
spanked143111733span_ked
spanker133612353span_ker
spankers14369863spankers
spanks124514123span__ks
spanned104111223span_ned
spanner94312563span_ner
spanners103710773spanners
spans74528733span___s
spansule1043623spansule_
sparables13167163sparables
spares84834553spa__res
sparge94216053sparg_e_
sparged113512763sparg_ed
sparger103613083sparg_er
spargers11389733spargers
sparkle133710213sparkle_
sparkled15317733sparkled
sparkler14317983sparkler
sparklers15315643sparklers
sparklet143110593sparklet
sparklets15275843sparklets
spates85028173spa__tes
spathes125116533spa_thes
spatulas1045473spatulas
spatzle1834583spatzle_
spavies123012943spa_vies
spazzes1735263spa_zzes
speckles16268133speckles
spences113413923spen_ces
spenses92913573spen_ses
sphinges14267483sphing_es
spicules12219803spicules
spiegels1133873spiegels
spiles84227913sp__iles
spinages11289293spinages
spinals93911863spinal_s
spindle103210093spindle_
spindled12287643spindled
spindler11297983spindler
spindlers12286453spindlers
spineless1136133spineless
spinelles1146083spinelles
spinels94512443spinel_s
spines85132033spin__es
spinless10238703spin_less
spinnies103210543spinnies
spinule9299993spinule_
spittles1038333spittles
spondees1136483spondees
sponge939663spong_e_
sponged1137953spong_ed
sponger1038523spong_er
spongers1137603spongers
spongier1135743spongier
spongiest1237083spongiest
spongins1136563spongins
sporules1037703sporules
spraddles13194283spraddles
sprangs104610053sprang__s
sprattles1174883sprattles
springes114014033spring_es
springlet1257523springlet
springlets1344023springlets
sprinkles1534923sprinkles
spunkies14227593spunkies
spurges104111653spurg_es
spurtles1037783spurtles
stabiles10311403stabiles
stables93219073sta_bles
staddles10258693staddles
stages75629493sta_g_es
staggies101210323staggies
stales65538293sta__les
stances93715963stan_ces
stanches132312793stanches
standees93310143standees
stanes64933403stan__es
stanged94113843stang_ed
stangs75018163stang__s
stanines85115673stanines
stanols739733stanol_s
staples93617213sta_ples
startles82111963startles
stingless1046463stingless
straggles11328503straggles
stranges94516763strang_es
strangle98411503strangle_
strangled11268983strangled
strangler10369473strangler
stranglers11396823stranglers
swaddles13296453swaddles
swages104417073swa_g_es
swaggies13136693swaggies
swales93920763swa__les
swindles12319503swindles
swinges113413423swing_es
swingle113510563swingle_
swingled13337433swingled
tangle74019953_tangle_
tangled94214633_tangled
tangler83515073_tangler
tanglers92911973_tanglers
tingles83818323_tingles
triangles1035743triangles
twangle1145803twangle_
twangled1364173twangled
twangler1244113twangler
twanglers1363433twanglers
untangles1054713untangles
waggles123812003_waggles
wangle103817503_wangle_
wangled123312413_wangled
wangler113312653_wangler
wanglers123310033_wanglers
whangees15275063whangees
wrangle1137383wrangle_
wrangled1335593wrangled
wrangler1245473wrangler
wranglers1344273wranglers

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.420425454.8
2DLD Change Limit1461623266.42322756.0
3Display Results3263260.1262587.3
 (SQL Overall)1786913266.96925640.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.