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

481 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
spanning11331108(None) 
panning104019391_panning
scanning113310771scanning
spanking153911971spanking
spawning14296911spawning
spinning113310811spinning
swanning12338811swanning
banning103818232_banning
branning112911092branning
canning103620132_canning
fanning113615072_fanning
inspanning1343202inspanning
japanning1943382japanning
manning103616382_manning
paining103920242_paining
panging113319112_panging
panting104025422_panting
pawning134711412_pawning
penning103616492_penning
pinning103417852_pinning
planning113610222planning
punning103414992_punning
saining83621392s_aining
sanding93520602s_anding
saning75127642s_a_ning
scannings12264822scannings
scanting113914762scanting
shanking163612282shanking
shinning123211022shinning
shunning12367842shunning
sinning83918442s_inning
skanking12288742skanking
skinning13327892skinning
slanging103413432slanging
slanting94115092slanting
spacing123614492spa_cing
spading113114382spa_ding
spaeing103413542spa_eing
spalling113213462spalling
spamming15317602spamming
spangling1336372spangling
spankings16215002spankings
sparging122611132sparging
sparing104823872spa_ring
sparking152812542sparking
sparling112714532sparling
sparring113112222sparring
spasming13227202spasming
spatting113111762spatting
spaying133014622spa_ying
speaning113512242speaning
spending122712432spending
spinnings12294852spinnings
splining11310772splining
sponging1238822sponging
spooning112811442spooning
spraining1248152spraining
spunking15258062spunking
spurning11258662spurning
staining9413372staining
standing103413632standing
stanging104013652stanging
staning83922242sta_ning
stunning9298462stunning
sunning83715672s_unning
swanking16399962swanking
tanning83618252_tanning
vanning113912462_vanning
wanning113816212_wanning
anting75827023__anting
aproning11311793aproning
awning105013393__awning
banding114921413_banding
banging114019863_banging
baning95127833_ba_ning
banking144621353_banking
barning104320353_barning
beaning103820683bea_ning
binning103615453_binning
blanking154411933blanking
braining113414683braining
branding122513683branding
caning94128623_ca_ning
cannings113710333_cannings
canting104725903_canting
chaining142810783chaining
chancing162810283chancing
changing153211513changing
chanting143413533chanting
chinning14329653chinning
clanging124012123clanging
clanking154313063clanking
conning103718763_conning
craning103620303cra_ning
cranking154613073cranking
cunning104214623_cunning
damning114211633_damning
dancing113611563_dancing
danging103716093_danging
darning93817333_darning
dawning124111013_dawning
deaning94020473dea_ning
denning93515173_denning
dinning93416553_dinning
donning93512763_donning
draining103312673draining
dunning93514473_dunning
eanling81416673_eanling
earning83418213_earning
expanding2044793expanding
fawning14409133_fawning
finning113615113_finning
flanging132710583flanging
flanking164211083flanking
franking164310863franking
funning113813613_funning
gaining94015663_gaining
ganging103216193_ganging
ginning93313983_ginning
glancing1247063glancing
graining102813183graining
granting103514523granting
grinning1037863grinning
gunning93413173_gunning
handing123518893_handing
hanging123518703_hanging
hanking154619103_hanking
hanting114124483_hanting
impawning1743423impawning
inning73617633__inning
islanding1135623islanding
kenning124010543_kenning
lancing103314123_lancing
landing92819323_landing
leaning83721203lea_ning
learning978553learning
loaning83614833loa_ning
meaning103918703mea_ning
mispenning1545773mispenning
misplanning1653873misplanning
moaning103714443moa_ning
opaquing2042313opaquing
opening1039933op_ening
opining10311743op_ining
outspanning1443563outspanning
pacing114522753_pa_cing
packing164420723_packing
padding123412513_padding
paging104020403_pa_ging
paiking143814813_paiking
painting113614423_painting
pairing103716733_pairing
paling93530133_pa_ling
palling104024483_palling
palming123914013_palming
palping124112873_palping
pandying15217663_pandying
paneling111013623_paneling
panini8314273_pa_nini
panino8315683_pa_nino
pannier93613353_pannier
parging113318603_parging
paring94236493_pa_ring
parking143423043_parking
parling103823763_parling
parring103222063_parring
parsing103819553_parsing
parting103527383_parting
pashing135120513_pashing
passing104318423_passing
pasting103826553_pasting
patining11312303_patining
patting103722343_patting
pausing103912813_pausing
paving124519743_pa_ving
pawing124519553_pa_wing
paying123722163_pa_ying
peening103318303_peening
peining104619153_peining
pending114119773_pending
pennine93712953_pennine
phoning13312053_phoning
pinging113419553_pinging
pining93726533_p_ining
pinking143918943_pinking
plaining113911553plaining
planing103418253_planing
planking153513013planking
plannings12325453plannings
planting113515383planting
poncing122913583_poncing
ponding114317083_ponding
ponging113416153_ponging
ponying133312123_ponying
prancing132612163prancing
pranging123012723pranging
pranking153813383pranking
prawning1446963prawning
pruning10311733_pruning
psalming1375473psalming
punting103318443_punting
quanting1849233quanting
raining83922693_raining
ranging94120263_ranging
ranking124320883_ranking
ranting84025413_ranting
remanning12229033remanning
repinning12258973repinning
replanning1345313replanning
rinning83216743_rinning
running83514593_running
sabbing123314743s_abbing
sabeing102611863s_abeing
sabring102614843s_abring
sacking144122703s_acking
sacring103115983s_acring
sagging103116103s_agging
sailing83927373s_ailing
sainting93215733sainting
salting84120793s_alting
salving113913153s_alving
sandling102214413s_andling
sapling103217863s_apling
saponin9310263saponin_
saponine1039223saponine
saponins1039453saponins
sapping123519313s_apping
sashing114621473s_ashing
sassing84615553s_assing
sating74735453s_a_ting
saucing10311003s_aucing
saunaing937013saunaing
saving104724513s_a_ving
sawing104323813s_a_wing
saying104325543s_a_ying
scabbing15277193scabbing
scalding12339393scalding
scaling103519373sca_ling
scalping133410453scalping
scamming15328543scamming
scamping153510193scamping
scantling12107233scantling
scaping123715693sca_ping
scarfing14309713scarfing
scaring103421973sca_ring
scarping133312463scarping
scarring112511513scarring
scarting113415263scarting
scathing14269703scathing
scatting113311813scatting
scending122610583scending
scenting113212813scenting
sconcing1338263sconcing
scorning1169133scorning
seagoing1038193seagoing
sealing83528563sea_ling
seaming103222113sea_ming
searing83330923sea_ring
seasoning1037413seasoning
seating84130683sea_ting
seining84020773s_eining
sending94221373s_ending
sensing84116953s_ensing
shacking184014083shacking
shading123115563sha_ding
shafting15278683shafting
shagging14349053shagging
shaking153317253sha_king
shaming133016743sha_ming
shamming16289413shamming
shannies113411263shannies
shantung1232743shantung
shaping133116183sha_ping
sharing113723243sha_ring
sharking163912973sharking
sharping143011373sharping
shauling1249393shauling
shaving143414333sha_ving
shawing143514883sha_wing
shawling1558223shawling
sheening123010803sheening
shending132511253shending
shining113816523s_hining
shinnying16193723shinnying
shrining122610853shrining
shunting123610433shunting
signing92713963s_igning
singing93221423s_inging
sinking123320543s_inking
siphoning1546133siphoning
skating123613853ska_ting
skeining1347073skeining
skinking12299773skinking
skunking12256653skunking
slabbing13287783slabbing
slacking153914133slacking
slagging113711583slagging
slaking123717473sla_king
slamming133310003slamming
slapping133510843slapping
slashing123713413slashing
slating83724653sla_ting
slatting94014233slatting
slaving113514833sla_ving
slaying113316843sla_ying
slinging103312863slinging
slinking133412983slinking
smacking173510763smacking
smarting113212453smarting
smashing143310243smashing
snacking153411703snacking
snafuing1235083snafuing
snagging11319373snagging
snailing92912973snailing
snaking123915303sna_king
snapping13349653snapping
snarfing12358663snarfing
snaring83920953sna_ring
snarling92513183snarling
snawing113612483sna_wing
soaking123116613soa_king
soaping103616223soa_ping
soaring83521893soa_ring
sorning83116813s_orning
sounding102712873sounding
spacings13287043spa_cings
spackling18266503spackling
spaeings11276253spa_eings
spanceling1543943spanceling
spang84919733spa___ng
spaniel948923spa_niel
spanned104111223spann_ed
spanner94312563spann_er
spanners103710773spanners
sparkling16226353sparkling
sparlings12257153sparlings
spartina1037983spartina
spavin114210653spa_vin_
spavins12419323spa_vins
speaking153212493speaking
spearing113216103spearing
speccing15306643speccing
specking17359733specking
speeding122810933speeding
speeling112713123speeling
speering113116323speering
speiling113612973speiling
speiring113711263speiring
spelling113315233spelling
spewing133110453sp_ewing
sphering142811943sphering
spicing123914533sp_icing
spieling113212523spieling
spiering112713353spiering
spiffing17237083spiffing
spiking144312883sp_iking
spiling102919703sp_iling
spilling113113943spilling
spindling13136273spindling
spinnies103210543spinnies
spiring103918183sp_iring
spirting112913633spirting
spiting103917623sp_iting
spitting113012323spitting
splashing1535703splashing
splatting1235983splatting
splaying14219303splaying
splicing1338963splicing
splinting1238193splinting
spoiling112911553spoiling
spoking143212223sp_oking
spongin1036373spongin_
spongins1136563spongins
spoofing14228363spoofing
spooking15269803spooking
spooling113212563spooling
spooring113111463spooring
sporing104319413sp_oring
sporting112415463sporting
spotting112812093spotting
spousing11198733spousing
spouting113511953spouting
sprawling15175123sprawling
spraying14299883spraying
spring94526013sp__ring
springing1338743springing
sprinting12310033sprinting
sprucing1336893sprucing
spudding1335653spudding
spuing94313363sp__uing
spuming1248523sp_uming
spurring11339763spurring
spurting113111633spurting
spying123913253sp__ying
stabbing13238763stabbing
stabling112913653stabling
stacking154215083stacking
staffing15247493staffing
stagging113310513stagging
staging93818373sta_ging
staking123919803sta_king
staling83925423sta_ling
stalking133512223stalking
stalling95116703stalling
stamping133310963stamping
stanching1538083stanching
standings11257153standings
stanine73417073sta_nine
stannic936663stanni_c
stannite847583stannite
stapling112813153stapling
staring84527053sta_ring
starling93017123starling
starring92312953starring
starting93116173starting
starving122510173starving
stashing123511583stashing
stating83725163sta_ting
staving113915703sta_ving
staying114017323sta_ying
stinging103213453stinging
stinking133113543stinking
stinting93415743stinting
stoning83717443s_toning
straining10410563straining
stranding1149653stranding
stunting92811503stunting
suntanning1143983suntanning
swabbing16246453swabbing
swagging14328093swagging
swaging124210633swa_ging
swamping16307923swamping
swapping16348673swapping
swarding1359003swarding
swarming1458223swarming
swashing15369743swashing
swathing15248713swathing
swatting12309593swatting
swaying143610643swa_ying
swinging133411113swinging
swinking163410323swinking
swooning12278203swooning
swouning12246563swouning
syncing13177223s_yncing
syphoning1845393syphoning
tanging93419533_tanging
tanking123918793_tanking
tannin62613933_tannin_
tannings9268633_tannings
tannins72813223_tannins
thanking16409523thanking
thinning12319093thinning
tinning83117283_tinning
training93015863training
trancing112812023trancing
trapanning1343213trapanning
trepanning1344153trepanning
tunning83514453_tunning
twanging13287063twanging
twinning12367043twinning
unbanning1235893unbanning
unmanning1245873unmanning
unpenning1236183unpenning
unpinning1245623unpinning
upending12258133upending
waning103623803_wa_ning
wanking154216783_wanking
wanting114220173_wanting
warning113717093_warning
weaning114117193wea_ning
weanling12118643weanling
whanging16267143whanging
winning113516553_winning
wonning113210793_wonning
yanking154512463_yanking
yarning113512953_yarning
yawning14378343_yawning
yeaning113814633yea_ning
yeanling12107063yeanling
yearning1296983yearning
yenning11369493_yenning

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 Filter1786911461620.436409841.7
2DLD Change Limit1461624819.14015991.5
3Display Results4814810.2032369.5
 (SQL Overall)1786914819.77918272.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.