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

443 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
spending12271243(None) 
pending114119771_pending
scending122610581scending
sending94221371s_ending
shending132511251shending
speeding122810931speeding
upending12258131upending
amending12308912amending
appending1536282appending
ascending1336282ascending
bending114420892_bending
blending12249962blending
depending14208782depending
dispending1547922dispending
emending12298892emending
ending83220252__ending
expending2045932expending
fending123717602_fending
impending1535932impending
lending94118532_lending
mending114018682_mending
opening1039932open_ing
penning103616492_penning
ponding114317082_ponding
rending93924262_rending
sanding93520602s_anding
scenting113212812scenting
seeding93719482s_eeding
sensing84116952s_ensing
shedding14278112shedding
sledding11248502sledding
snedding11246952snedding
sounding102712872sounding
spading113114382sp_ading
spanking153911972spanking
spanning113311082spanning
speaking153212492speaking
speaning113512242speaning
spearing113216102spearing
speccing15306642speccing
specking17359732specking
speedings13265402speedings
speeling112713122speeling
speering113116322speering
speiling113612972speiling
speiring113711262speiring
spelling113315232spelling
spendier1147142spendier
spewing133110452spe_wing
spindling13136272spindling
spinning113310812spinning
sponging1238822sponging
spreading1339652spreading
spudding1335652spudding
spunking15258062spunking
standing103413632standing
steading103613592steading
sueding92613752sue_ding
suspending1445032suspending
tending94419162_tending
trending103012832trending
unending10239942unending
upsending1334902upsending
vending124015262_vending
wending123816842_wending
agenting1039383agenting
aspersing1237603aspersing
assenting1038163assenting
attending11136373attending
avenging1345863avenging
banding114921413_banding
beading113221863_beading
bedding124114483_bedding
bielding12237473bielding
binding113819383_binding
bleeding12359053bleeding
blinding123210163blinding
bonding113318433_bonding
bounding123012133bounding
branding122513683branding
breading123515463breading
breeding123411843breeding
ceding104014803_ce_ding
censing104215263_censing
deeding103315123_deeding
defending15298353defending
denning93515173_denning
denting94422183_denting
denuding1137113_denuding
denying123711293_denying
descending1546113descending
desponding1555663desponding
dispensing1448233dispensing
distending1348333distending
dreading113712803dreading
endings92910443__endings
enduing9249723__enduing
evening11310223even_ing
expanding2044793expanding
expensing1946003expensing
extending1835853extending
feeding123515073_feeding
fencing132411133_fencing
feuding123410263_feuding
fielding13206863fielding
finding124116543_finding
flensing1246973flensing
fonding123815423_fonding
founding133010793founding
friending1495553friending
funding124113663_funding
gelding103911793_gelding
grinding1139863grinding
handing123518893_handing
heading122919113_heading
heeding123515063_heeding
henting113719653_henting
herding122915123_herding
hounding132610053hounding
impeding1436563impe_ding
intending1139983intending
islanding1135623islanding
keening123713153keen_ing
kenning124010543_kenning
kneading1436373kneading
landing92819323_landing
leading93419553_leading
lensing84015103_lensing
melding113414273_melding
mendings12338303_mendings
mensing103915103_mensing
minding113317893_minding
mispenning1545773mispenning
missending1446493missending
misspending1743653misspending
mistending1447953mistending
mounding123311263mounding
needing93214423_needing
nonending1138003nonending
offending1744093offending
omening10310103omen_ing
openings1134813open_ings
opining10311743opin_ing
outspending1544313outspending
padding123412513_padding
pandying15217663_pandying
panging113319113_panging
panning104019393_panning
panting104025423_panting
peacing124117073_peacing
peaking144317693_peaking
pealing104123203_pealing
peching154513903_peching
pecking164017783_pecking
peddling13217973_peddling
peeing94618083_pe_eing
peeking144414953_peeking
peeling102919873_peeling
peening103318303_peening
peeping123615213_peeping
peering103520353_peering
peeving135112243_peeving
pegging122811133_pegging
peining104619153_peining
peising103416763_peising
pelting102917273_pelting
penang92511113_pen_ang
pendant10314853_pendant
pendent10314723_pendent
pennine93712953_pennine
pepping113511623_pepping
perking143716463_perking
perming123416093_perming
perpending1646683perpending
petting103720953_petting
pindling122110983_pindling
pinging113419553_pinging
pining93726533_pin_ing
pinking143918943_pinking
pinning103417853_pinning
pleading123011443pleading
podding124113183_podding
poinding122510003poinding
poncing122913583_poncing
ponging113416153_ponging
ponying133312123_ponying
pounding123311473pounding
priding113317543_priding
propending1646143propending
pudding124010803_pudding
punning103414993_punning
punting103318443_punting
reading93327213_reading
redding103218513_redding
reding83825563_re_ding
reeding94124133_reeding
relending112412023relending
remending132311313remending
renting84026853_renting
repenting122316553repenting
resending112313363resending
responding1437403responding
ripening1138573ripen_ing
rounding102812283rounding
saining83621393sain_ing
sainting93215733sainting
sandling102214413s_andling
saning75127643s_an_ing
saunaing937013saunaing
scalding12339393scalding
scanning113310773scanning
scanting113914763scanting
scolding12278913scolding
sconcing1338263sconcing
screeding1336323screeding
scudding1335673scudding
sealing83528563s_ealing
seaming103222113s_eaming
searing83330923s_earing
seating84130683s_eating
seceding12288563seceding
seconding1337613seconding
seedling102610953seedling
seeing74222143s_e_eing
seeking124016063s_eeking
seeling83522003s_eeling
seeming103216263s_eeming
seeping103817913s_eeping
seething1239023seething
seining84020773s_eining
seising84018863s_eising
seizing174114833s_eizing
selfing112911623s_elfing
selling83225833s_elling
serenading1246103serenading
serging93416673s_erging
sering74731813s_e_ring
serving113014983s_erving
setting83621393s_etting
sewing103819623s_e_wing
sexing144313893s_e_xing
shading123115563s_hading
shanking163612283shanking
sheafing15329483sheafing
shealing123415463shealing
shearing123915903shearing
sheaving154110253sheaving
sheening123010803sheening
sheering123715103sheering
sheeting122712833sheeting
shelling123515213shelling
shelving15278173shelving
shewing143812193she_wing
shielding1434553shielding
shindig12244243shindi_g
shining113816523shin_ing
shinning123211023shinning
shredding1544513shredding
shunning12367843shunning
shunting123610433shunting
siding83822133s__iding
sieging92613203sie_ging
sieving112311233sie_ving
signing92713963sign_ing
silencing1245053silencing
sinewing1267593sinewing
singing93221423s_inging
sinking123320543s_inking
sinning83918443s_inning
skanking12288743skanking
skeeing12308853ske_eing
skeining1347073skeining
skelping1535973skelping
skewing15318723ske_wing
skidding1535463skidding
skinking12299773skinking
skinning13327893skinning
sklenting1475123sklenting
skunking12256653skunking
slanging103413433slanging
slanting94115093slanting
sleaving123310983sleaving
sleddings12263783sleddings
sledging11288183sledging
sleeking133410963sleeking
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
slewing113311353sle_wing
sliding93114553s_liding
slinging103312863slinging
slinking133412983slinking
smearing113511753smearing
smeeking15317833smeeking
smelling113712733smelling
smelting11339713smelting
smerking15258473smerking
sneaking133211093sneaking
sneaping11349493sneaping
sneering93414503sneering
sneezing18267053sneezing
snelling93913563snelling
snooding102910433snooding
sodding103712733s_odding
sorning83116813sorn_ing
soundings11266153soundings
spacing123614493sp_acing
spaeing103413543sp_aeing
spalling113213463spalling
spamming15317603spamming
spangling1336373spangling
spankings16215003spankings
sparging122611133sparging
sparing104823873sp_aring
sparking152812543sparking
sparling112714533sparling
sparring113112223sparring
spasming13227203spasming
spatting113111763spatting
spawning14296913spawning
spaying133014623sp_aying
speakings16345933speakings
speckling18235583speckling
speedier1146623speedier
speedily1465183speedily
speerings12276843speerings
spellings12296553spellings
spelunking17112003spelunking
spend85619333spend___
spender103713693spend_er
spenders113211743spenders
spendiest1237533spendiest
spends94714473spend__s
spendy124911143spend__y
spermine12311433spermine
sphering142811943sphering
spicing123914533sp_icing
spieling113212523spieling
spiering112713353spiering
spiffing17237083spiffing
spiking144312883sp_iking
spiling102919703sp_iling
spilling113113943spilling
spinnings12294853spinnings
spiring103918183sp_iring
spirting112913633spirting
spiting103917623sp_iting
spitting113012323spitting
splaying14219303splaying
splendent1246073splendent
splendid1244643splendi_d
splicing1338963splicing
splining11310773splining
splinting1238193splinting
splodging1433303splodging
spoiling112911553spoiling
spoking143212223sp_oking
spongin1036373spongin_
spongins1136563spongins
spoofing14228363spoofing
spooking15269803spooking
spooling113212563spooling
spooning112811443spooning
spooring113111463spooring
sporing104319413sp_oring
sporting112415463sporting
spotting112812093spotting
spousing11198733spousing
spouting113511953spouting
spraying14299883spraying
spring94526013sp__ring
springing1338743springing
sprinting12310033sprinting
sprucing1336893sprucing
spuing94313363sp__uing
spuming1248523sp_uming
spurning11258663spurning
spurring11339763spurring
spurting113111633spurting
spying123913253sp__ying
standings11257153standings
stanging104013653stanging
staning83922243stan_ing
steadings11307083steadings
steadying14154503steadying
stealing93416603stealing
steaming114013213steaming
steeking133411353steeking
steeling93615143steeling
steeping113412583steeping
steering93916793steering
steeving12359653steeving
stemming13408203stemming
stepping13329073stepping
sterling93615553sterling
stetting93410713stetting
stewing113412493ste_wing
stinging103213453stinging
stinking133113543stinking
stinting93415743stinting
stoning83717443ston_ing
stounding1136233stounding
stranding1149653stranding
striding102713603striding
studding1136703studding
stunning9298463stunning
stunting92811503stunting
subpenaing1544633subpenaing
subtending1445103subtending
sunning83715673s_unning
supering11317683supe_ring
swanking16399963swanking
swanning12338813swanning
swarding1359003swarding
swearing123711443swearing
sweating123213023sweating
sweeping14389143sweeping
sweeting123911313sweeting
swelling123212753swelling
swerving1546113swerving
swindling14135833swindling
swinging133411113swinging
swinking163410323swinking
swounding1434133swounding
syncing13177223s_yncing
tedding103210883_tedding
tensing84616653_tensing
tenting84621153_tenting
treading103515333treading
unbending1337463unbending
unpenning1236183unpenning
upbinding1544303upbinding
venging123710943_venging
venting114218093_venting
wedding133411873_wedding
weeding123815213_weeding
weening114113973ween_ing
welding123213253_welding
wielding13286863wielding
winding123517913_winding
wounding13249403wounding
yenning11369493_yenning
yielding13205033yielding

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.423422437.4
2DLD Change Limit1461624437.48319532.5
3Display Results4434430.1902331.6
 (SQL Overall)1786914438.09622071.5
 
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.