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

263 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
spangled123615(None) 
spangle1038401spangle_
spangles1138891spangles
angled84219092__angled
bespangled1641902bespangled
dangled104013152_dangled
jangled164111562_jangled
mangled113615262_mangled
paneled10612572_paneled
panged104722342_pang_ed
pungled114210082_pungled
shingled13358322shingled
singled93914682s_ingled
slanged94112852slang_ed
spackled17297802spackled
spalled103113132spa_lled
spanceled1443692spanceled
spanglier1244192spanglier
spangly1336472spangl_y
spanked143111732span_ked
spanned104111222span_ned
sparged113512762sparg_ed
sparkled15317732sparkled
spindled12287642spindled
sponged1137952spong_ed
stanged94113852stang_ed
strangled11268982strangled
swingled13337432swingled
tangled94214642_tangled
twangled1364172twangled
wangled123312412_wangled
wrangled1335592wrangled
aneled74719283__aneled
angeled93211513__angeled
angle64528883__angle_
angler74017863__angler
angles74426703__angles
ankled114313483__ankled
argled85314553__argled
banged104923733_bang_ed
bangle94018963_bangle_
bangles103617413_bangles
bespangle1442543bespangle_
bespangles1542133bespangles
bungled114112243_bungled
canaled103615563_canaled
candled113815743_candled
changed144214143chang_ed
clanged114212653clang_ed
crankled15408153crankled
daggled11329463_daggled
dandled103313543_dandled
danged94819493_dang_ed
dangle84119313_dangle_
dangler96912813_dangler
dangles93618423_dangles
draggled1254673draggled
eagled82914043_ea_gled
empaneled1443433empaneled
entangled1184513entangled
espanoles1143943espanoles
fanged114318233_fang_ed
fenagled13184853fenagled
finagled13205293finagled
flanged123810843flang_ed
gaggled11359913_gaggled
ganged94619203_gang_ed
gargled104210673_gargled
haggled13359283_haggled
handled124114533_handled
hanged114222403_hang_ed
impaneled1443563impaneled
jangle144416303_jangle_
jangler153811833_jangler
jangles154015683_jangles
jingled164111063_jingled
jungled16349643_jungled
langley1147453_langley
mangle93921333_mangle_
mangler103215643_mangler
mangles104021463_mangles
mantled104113393_mantled
mingled113612733_mingled
paddled123612023_paddled
paged95926783_pa_g_ed
paled85538723_pa__led
palled94625163_pa_lled
pandied113913443_pandied
paned85437183_pan__ed
panelled1138963_panelled
pangen94115923_pang_en
panicled13106783_panicled
panned94123433_pan_ned
panted95024823_pan_ted
pantiled113111593_pantiled
parged104922043_parg_ed
parled94626293_pa_rled
paroled104217633_paroled
pinged104321383_ping_ed
ponged105619353_pong_ed
pranged114512553prang_ed
pungle94413573_pungle_
pungles104013713_pungles
ranged84824323_rang_ed
rankled123910653_rankled
repaneled1245333repaneled
saddled103112033s_addled
sagged94120013s_a_gged
sailed74327763s_a_iled
sampled123410793s_ampled
sandaled1039243s_andaled
sanded84920613s_an_ded
saned65636273s_an__ed
sanger74524573s_ang_er
scabbled15156303scabbled
scaled94822443sca__led
scandaled1344663scandaled
scanned104110893scan_ned
scanted104114393scan_ted
sealed74328363sea__led
sepaled10510593sepa__led
sepalled1156903sepa_lled
shackled18277603shackled
shagged134210133sha_gged
shaled105023953sha__led
shambled16156153shambled
shanked153212123shan_ked
shauled1148793sha_uled
shawled1437773sha_wled
shingle117711283shingle_
shingler12268633shingler
shingles123111113shingles
signaled1035393signaled
singed85422293s_ing_ed
single74520603s_ingle_
singles83520433s_ingles
singlet84120113s_inglet
skanked11338103skan_ked
slagged104312773sla_gged
slangier9117933slangier
slanted83514743slan_ted
smuggled13254223smuggled
snaffled15285213snaffled
snagged104010673sna_gged
snailed83811923sna_iled
snarled83612363sna_rled
sniggled11275743sniggled
snuggled11234953snuggled
spaced114517253spa__ced
spackle15369573spackle_
spackles16319953spackles
spaded103816753spa__ded
spaed85522273spa___ed
spale74929213spa__le_
spales84728103spa__les
spaller92713473spa_ller
spammed14348523spa_mmed
spancel1147363span_cel
spancelled1543003spancelled
spancels1245273spancels
spandex1735833span_dex
spandrel1144063spandrel
spang84919733spang___
spangliest1345163spangliest
spangling1336373spangling
spaniel948923span_iel
spaniels1045963spaniels
spanker133612353span_ker
spanless10247363span_less
spanner94312563span_ner
spansule1043623spansule_
spansules1143613spansules
spared95427493spa__red
sparge94216053sparg_e_
sparger103613083sparg_er
sparges104016343sparg_es
sparked143513143spa_rked
sparkle133710213sparkle_
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparred104512863spa_rred
spasmed12296993spa_smed
spathed134013183spa_thed
spatted104014143spa_tted
spatzle1834583spatzle_
spatzles1935303spatzles
spavined1434333spavined
spawned13316803spa_wned
spayed124213613spa__yed
speaned103411523spean__ed
speckled17255833speckled
speeled103712453sp_eeled
speiled104412123sp_eiled
spelled103714743sp_elled
spieled104811883sp_ieled
spiled94621993sp__iled
spilled103613623sp_illed
spindle103210093spindle_
spindler11297983spindler
spindles112710353spindles
spined95423943spin__ed
spinule9299993spinule_
spinules10249333spinules
spiraled1137733spiraled
spoiled104811353sp_oiled
sponge939663spong_e_
sponger1038523spong_er
sponges10311043spong_es
spongier1135743spongier
spooled104613523sp_ooled
spraddled14203463spraddled
sprattled1263313sprattled
sprawled1434523sprawled
sprigged13316223sprigged
springed123911323spring_ed
springlet1257523springlet
sprinkled1633713sprinkled
spunked14307783spun_ked
stabled103514953sta_bled
staged84521563sta_g_ed
stagged104212083sta_gged
staled74728103sta__led
stalled83515693sta_lled
stanched14208903stanched
staned74824643stan__ed
stanzaed1843873stanzaed
stapled103613703sta_pled
startled9208563startled
straggled12296853straggled
strangle98411503strangle_
strangler10369473strangler
strangles103011563strangles
swaddled14254963swaddled
swaged114212253swa_g_ed
swagged13419153swa_gged
swanked15359543swan_ked
swanned11358173swan_ned
swindled13307623swindled
swinged123810793swing_ed
swingle113510563swingle_
swingles12319543swingles
tanged84622513_tang_ed
tangle74019973_tangle_
tangler83515083_tangler
tangles83920053_tangles
tangoed9318843_tangoed
tingled93712803_tingled
triangled1143943triangled
twanged12387283twang_ed
twangle1145813twangle_
twangler1244113twangler
twangles1245743twangles
unaneled939793unaneled
untangled1165123untangled
waggled13389363_waggled
wangle103817513_wangle_
wangler113312653_wangler
wangles113416933_wangles
whanged15447613whang_ed
wrangle1137383wrangle_
wrangler1245473wrangler
wrangles1237473wrangles

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.420425454.8
2DLD Change Limit1461622637.55019359.2
3Display Results2632630.0932828.0
 (SQL Overall)1786912638.06322161.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.