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

264 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
upending1225813(None) 
pending114119771_pending
spending122712431spending
unending10239941unending
upsending1334901upsending
amending12308912amending
appending1536282appending
bending114420892_bending
blending12249962blending
depending14208782depending
emending12298892emending
ending83220252__ending
expending2045932expending
fending123717602_fending
impending1535932impending
lending94118532_lending
mending114018682_mending
opening1039922open_ing
penning103616492_penning
ponding114317082_ponding
rending93924262_rending
scending122610582scending
sending94221372_sending
shending132511252shending
speeding122810932speeding
suspending1445032suspending
tending94419162_tending
trending103012832trending
unbending1337462unbending
unpenning1236182unpenning
upbinding1544302upbinding
vending124015262_vending
wending123816842_wending
agenting1039383agenting
ascending1336283ascending
attending11136373attending
avenging1345863avenging
banding114921413_banding
beading113221863_beading
bedding124114483_bedding
bielding12237473bielding
binding113819383_binding
bleeding12359053bleeding
blinding123210163blinding
bonding113318433_bonding
bounding123012133bounding
branding122513683branding
breading123515463breading
breeding123411843breeding
ceding104014803_ce_ding
censing104215263_censing
cupeling1338863cupe_ling
cupelling1436283cupelling
deeding103315123_deeding
defending15298353defending
denning93515173_denning
denting94422183_denting
denuding1137113_denuding
denying123711293_denying
dispending1547923dispending
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
keening123713153keen_ing
kenning124010543_kenning
kneading1436373kneading
landing92819323_landing
leading93419553_leading
lensing84015103_lensing
melding113414273_melding
mendings12338303_mendings
mensing103915103_mensing
minding113317893_minding
mounding123311263mounding
needing93214423_needing
nonending1138003nonending
offending1744093offending
omening10310093omen_ing
openings1134803open_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
queening1846113queen_ing
reading93327213_reading
redding103218513_redding
reding83825563_re_ding
reeding94124133_reeding
relending112412023relending
remending132311313remending
renting84026853_renting
repenting122316553repenting
resending112313363resending
ripening1138573ripen_ing
rounding102812283rounding
sanding93520603_sanding
scenting113212813scenting
seeding93719483_seeding
sensing84116953_sensing
shedding14278113shedding
sledding11248503sledding
snedding11246953snedding
sounding102712873sounding
spading113114383sp_ading
spanking153911973spanking
spanning113311083spanning
speaking153212493speaking
speaning113512243speaning
spearing113216103spearing
speccing15306643speccing
specking17359733specking
speedings13265403speedings
speeling112713123speeling
speering113116323speering
speiling113612973speiling
speiring113711263speiring
spelling113315233spelling
spendier1147143spendier
spewing133110453spe_wing
spindling13136273spindling
spinning113310813spinning
sponging1238823sponging
spreading1339653spreading
spudding1335653spudding
spunking15258063spunking
standing103413633standing
steading103613593steading
subpenaing1544633subpenaing
subtending1445103subtending
sueding92613753sue_ding
supering11317683supe_ring
tedding103210883_tedding
tensing84616653_tensing
tenting84621153_tenting
treading103515333treading
unbendings1443163unbendings
unbinding1336513unbinding
undine7817263u__ndine
undoing9312243u__ndoing
undying1238503u__ndying
unendingly1544323unendingly
unerring9311273unerring
unfading1347693unfading
unfencing1545953unfencing
unhanding1437203unhanding
unheeding1446103unheeding
unlading1058863unlading
unleading1138673unleading
unpegging1443863unpegging
unpinning1245623unpinning
unwinding1435843unwinding
upbearing1435033upbearing
upcoming1535173upcoming
updating1236593updating
updiving1534223updiving
updrying1534013updrying
upend85011043upend___
upended11267323upend_ed
upends9438763upend__s
upfling1337093up_fling
upfolding1642943upfolding
upgazing2133313upgazing
upgirding1442373upgirding
upgoing1135353up_going
upgrading1444903upgrading
upheaping1743853upheaping
upheaving1843803upheaving
upholding1643373upholding
upleaping1434363upleaping
uplinking1634623uplinking
uploading1334663uploading
uppiling1335853uppiling
upping114013703up__ping
uprating11311113uprating
uprearing1238373uprearing
uprising1138953uprising
upsetting1275563upsetting
upsizing2035413upsizing
upspring1335703upspring
upstanding1443713upstanding
upswing1335593up_swing
uptearing1236103uptearing
upwelling1535233upwelling
venging123710943_venging
venting114218093_venting
wedding133411873_wedding
weeding123815213_weeding
weening114113973ween_ing
welding123213253_welding
wielding13286863wielding
winding123517913_winding
wounding13249403wounding
yenning11369493_yenning
yielding13205033yielding

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.423422437.4
2DLD Change Limit1461622647.09320606.5
3Display Results2642640.1232146.3
 (SQL Overall)1786912647.63923391.9
 
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.