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

323 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
spangle103840(None) 
spangled1236141spangled
spangles1138891spangles
spangly1336471spangly
angle64528872__angle
bangle94018952_bangle
bespangle1442542bespangle
dangle84119302_dangle
jangle144416292_jangle
mangle93921322_mangle
pungle94413572_pungle
shingle117711282shingle
single74520602s_ingle
spackle15369562spackle
spale74929212spa__le
spancel1147362spancel
spang84919732spang__
spanglier1244192spanglier
spaniel948922spaniel
spansule1043622spansule
sparge94216042sparg_e
sparkle133710202sparkle
spatzle1834572spatzle
spindle103210092spindle
spinule9299992spinule
sponge939662spong_e
strangle98411502strangle
swingle113510562swingle
tangle74019952_tangle
twangle1145802twangle
wangle103817502_wangle
wrangle1137382wrangle
anele55628833__anele
angel65019563__angel
angled84219083__angled
angler74017863__angler
angles74426703__angles
anglo65215373__anglo
anile54634463__anile
ankle95220253__ankle
anole55330373__anole
apanage1036803apanage
argle65421563__argle
asparkle1443833asparkle
atingle848253atingle
bangles103617413_bangles
beagle93612593bea_gle
bespangled1641893bespangled
bespangles1542133bespangles
bungle97116113_bungle
candle94321483_candle
cangue91012443_cangue
cantle84522153_cantle
change124116753chang_e
crankle133610063crankle
cringle103010353cringle
daggle93711903_daggle
dandle84218093_dandle
dangled104013153_dangled
dangler96912813_dangler
dangles93618423_dangles
dangly114212263_dangly
dingle84317073_dingle
dongle83612493_dongle
draggle1056103draggle
eagle64219483_ea_gle
entangle966243entangle
espanol943783espanol_
espanoles1143943espanoles
espiegle1142603espiegle
evangel1134303evangel
fenagle11197153fenagle
finagle11238313finagle
flange103411973flang_e
gaggle93412623_gaggle
gangly113911583_gangly
gangue81310573_gangue
gargle84215463_gargle
grange83716203grang_e
granule839473granule
haggle113511983_haggle
handle104219293_handle
hantle94318203_hantle
ingle64120433__ingle
jangled164111563_jangled
jangler153811833_jangler
jangles154015683_jangles
jangly174310603_jangly
jingle143815223_jingle
jungle144012653_jungle
langley1147453_langley
langue71012173_langue
mange84930183_mang_e
mangel94017533_mangel
mangled113615263_mangled
mangler103215643_mangler
mangles104021463_mangles
mantle84420923_mantle
mingle93518783_mingle
octangle1143833octangle
orange74016323orang_e
paddle104615143_paddle
padle84522343_pa_dle
page76036103_pa_g_e
pale66055013_pa__le
pane64950283_pan__e
panel76023623_panel_
paneled10612573_paneled
panels84716523_panels
pang75336283_pang__
panga85323533_pang_a
pangas99921103_pangas
panged104722333_panged
pangen94115913_pangen
pangene102711963_pangene
pangs84628663_pang_s
panicle11129983_panicle
panne76623653_pan_ne
pantie84326473_pantie
pantile93918483_pantile
papule102212133_papule
parge85831853_parg_e
parle75836163_pa_rle
parole84425253_parole
penile82219603_penile
pinole83218783_pinole
pintle83818263_pintle
pongee94920193_pongee
pungled114210083_pungled
pungles104013713_pungles
raggle83712883_raggle
range64728413_rang_e
rankle103414883_rankle
sable74732163s_a_ble
saddle83915493s_addle
sage55044593s_a_g_e
sale44959703s_a__le
sample104215013s_ample
sane45954333s_an__e
sanely93114613s_anely
sang55441223s_ang__
sanga66023793s_ang_a
sangar73617683s_angar
sangas75222653s_angas
sanger74524563s_anger
sangh95517453s_ang_h
sanghs105312063s_anghs
sanicle91210263s_anicle
sarge65531133s_arg_e
scabble13168653scabble
scale74629143sca__le
scantly12419553scantly
seance83716683sean_ce
semiangle1243963semiangle
senile63420213s_enile
shackle16409543shackle
shale85332833sha__le
shamble14149263shamble
shingled13358323shingled
shingler12268633shingler
shingles123111113shingles
shingly143210813shingly
singe65731133s_ing_e
singled93914683s_ingled
singles83520433s_ingles
singlet84120113s_inglet
singly104015853s_ingly
skatole1135683skatole
slang66324023slang__
slanged94112853slanged
slangier9117933slangier
slangily1235383slangily
slangs75615343slang_s
slangy105411393slang_y
slantly10399323slantly
smuggle11265013smuggle
snaffle13216243snaffle
sniggle9316833sniggle
snuggle9275713snuggle
space95325673spa__ce
spackled17297793spackled
spackles16319943spackles
spade84423323spa__de
spadille1145193spadille
spae65034323spa___e
spaetzle1942233spaetzle
spahee11313443spa_hee
spail74921553spa_il_
spails84817823spa_ils
spake114322743spa__ke
spales84728103spa__les
spall74919303spa__ll
spalled103113123spa_lled
spaller92713473spa_ller
spalls84217343spa_lls
span65234663span___
spanceled1443683spanceled
spancels1245273spancels
spandex1735833spandex
spandrel1144063spandrel
spangliest1345143spangliest
spangling1336373spangling
spaniels1045963spaniels
spank115919573span__k
spanked143111723spanked
spanker133612353spanker
spanks124514123span_ks
spanless10247363span_less
spanned104111223spanned
spanner94312563spanner
spans74528733span__s
spansules1143613spansules
sparable121611973sparable
spare75135563spa__re
sparely123410663sparely
sparged113512753sparged
sparger103613073sparger
sparges104016333sparges
sparingly1537283sparingly
sparkled15317723sparkled
sparkler14317973sparkler
sparkles143210483sparkles
sparklet143110583sparklet
sparkly16348123sparkly
sparse84516343spa_rse
spate74731583spa__te
spathe115115693spa_the
spatula935893spatula
spatzles1935303spatzles
spavie113611383spa_vie
speckle15297553speckle
spence103813793spen_ce
spense83912433spen_se
spicule11269933spicule
spiegel1034553spiegel
spile75230083sp__ile
spinage10289653spinage
spinal84915313spinal_
spinals93911863spinals
spinate93114813spinate
spindled12287643spindled
spindler11297983spindler
spindles112710353spindles
spindly13257383spindly
spine76534423spin__e
spinel85317333spinel_
spinelle1046213spinelle
spinels94512443spinels
spinose937943spinose
spinula9257903spinula
spinulae10276963spinulae
spinules10249333spinules
spittle937923spittle
spondee10310593spondee
sponged1137953sponged
sponger1038523sponger
sponges10311043sponges
spongier1135733spongier
spongily1444903spongily
spongin1036363spongin
spongy1236743spong_y
sporule937273sporule
spraddle12194163spraddle
sprang95713523sprang__
sprangs104610053sprang_s
sprattle1054763sprattle
springe103913983spring_e
springlet1257523springlet
sprinkle1434893sprinkle
spunkie13215293spunkie
spurge93711323spurg_e
spurtle937453spurtle
stabile9312063stabile
stable83921643sta_ble
staddle9288093staddle
stage65330193sta_g_e
staggie9138463staggie
stale55637103sta__le
stance84316913stan_ce
standee83514513standee
stane55933003stan__e
stang66424683stang__
stanged94113843stanged
stangs75018163stang_s
stanine73417073stanine
stanol6310723stanol_
stanols739733stanols
staple84415823sta_ple
startle72511123startle
straggle10359133straggle
strange85416343strang_e
strangled11268983strangled
strangler10369473strangler
strangles103011553strangles
suable83920553sua_ble
swaddle12276743swaddle
swage94919563swa_g_e
swaggie12135783swaggie
swale85221593swa__le
swang95519723swang__
swindle11389183swindle
swinge105614383swing_e
swingled13337433swingled
swingles12319543swingles
tangled94214633_tangled
tangler83515073_tangler
tangles83920043_tangles
tangly104413913_tangly
tingle74319063_tingle
triangle935533triangle
twangled1364173twangled
twangler1244113twangler
twangles1245743twangles
untangle966323untangle
waggle113612303_waggle
wandle105316663_wandle
wangled123312413_wangled
wangler113312653_wangler
wangles113416933_wangles
whangee14268613whangee
wrangled1335593wrangled
wrangler1245473wrangler
wrangles1237463wrangles

Search took 10 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.186960704.3
2DLD Change Limit1340273238.78315259.8
3Display Results3233230.1562070.5
 (SQL Overall)1786913239.12519582.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.