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

259 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
weddings1435553(None) 
beddings13407921beddings
waddings14356471waddings
wedding133411871wedding_
beadings123711782beadings
bedding124114482bedding_
biddings13397562biddings
buddings13326652buddings
edgings10256242_edgings
endings92910442_endings
geldings11316162geldings
headings133510492headings
leadings103511242leadings
mendings12338302mendings
paddings13297012paddings
puddings13325502puddings
readings103512642readings
redding103218512redding_
redwings13305732redwings
reedings103510362reedings
sleddings12263782sleddings
tedding103210882tedding_
wadding133711942wadding_
webbings1633242webbings
wedging13308722wedging_
weeding123815212weeding_
weepings14346482weepings
welding123213252welding_
weltings12388202weltings
wending123816842wending_
westings12429802westings
wettings12348402wettings
wildings13287932wildings
windings13329972windings
wordings13328562wordings
adding93914963_adding_
audings9289393_audings
beading113221863beading_
bearings113912253bearings
beatings114113233beatings
beduins1039123beduin_s
beings94613033be__ings
bellings113811153bellings
beltings11369253beltings
bending114420893bending_
bidding123613513bidding_
bindings123810473bindings
birdings12378823birdings
bladings12337753bladings
bleedings13264643bleedings
bodings113711653_bodings
bondings12369413bondings
breedings13375763breedings
budding123712403budding_
cardings123812633cardings
ceding104014803ce_ding_
ceilings11397993ceilings
claddings1433213claddings
codding124014693codding_
codlings123110103codlings
cordings123011353cordings
dealings103510703dealings
deckings16346683deckings
deeding103315123deeding_
dings76331403___dings
doings84913183__doings
dredgings13252953dredgings
dwellings14244213dwellings
dyings11478133__dyings
earings84517713_earings
eatings84616443_eatings
eddies83313163_eddi_es
eddying1335293_eddying_
edging93510713_edging_
embeddings1741513embeddings
ending83220253_ending_
fadings12469303_fadings
feeding123515073feeding_
feelings12338933feelings
feltings12317903feltings
fencings14225663fencings
fending123717603fending_
feuding123410263feuding_
findings13328443findings
gadding113411453gadding_
gearings10359503gearings
gelding103911793gelding_
gildings11356973gildings
godding113911943godding_
godlings11367493godlings
heading122919113heading_
hearings123611853hearings
hedging13348953hedging_
heeding123515063heeding_
heelings12359753heelings
helpings14255653helpings
herding122915123herding_
herrings12379533herrings
hidings12349703_hidings
hildings13347503hildings
hoddins12289373hoddin_s
holdings13297743holdings
jestings16368023jestings
kedging14357563kedging_
keepings15345943keepings
keglings14245233keglings
kennings13315273kennings
kidding14389773kidding_
ladings93814133_ladings
landings103110073landings
leading93419553leading_
leanings94010183leanings
leasings9379843leasings
leavings12407493leavings
leggings11316193leggings
lemmings13254733lemmings
lending94118533lending_
lidding103611433lidding_
loadings10378383loadings
lodgings11336243lodgings
lordings10368503lordings
madding123711993madding_
meanings11329163meanings
meddling13257933meddling_
medinas103411463me_dinas
meetings11287413meetings
melding113414273melding_
mending114018683mending_
middlings14194313middlings
moldings12267203moldings
mudding123310813mudding_
mueddins1243483mueddin_s
neckings15346113neckings
neddies92710703neddi_es
needing93214423needing_
needlings11294693needlings
nervings12256323nervings
nettings9288103nettings
nodding103811523nodding_
padding123412513padding_
paddlings14224363paddlings
peddling13217973peddling_
peelings11339523peelings
pending114119773pending_
pettings11349703pettings
pleadings13285543pleadings
podding124113183podding_
pudding124010803pudding_
puddlings14243793puddlings
radding103715003radding_
readding11411363readding_
reading93327213reading_
reddens9259783redden_s
reddling112911813reddling_
redfins1139923redfin_s
reding83825563re_ding_
redlines93916083redlines
redoing93516733redoing_
redwing122811983redwing_
reeding94124133reeding_
reedlings11236343reedlings
reelings94012563reelings
rending93924263rending_
rewedding1535093rewedding_
ridding103314193ridding_
ridings93412093_ridings
rodding103814533rodding_
seatings93614303seatings
seeding93719483seeding_
seedlings11195953seedlings
seeings84411293se_eings
seemings11337643seemings
seisings9398523seisings
seizings18326473seizings
sending94221373sending_
sergings10299213sergings
servings12249223servings
settings93810073settings
sewings11369173se_wings
shadings13327433shadings
shedding14278113shedding_
sidings94011463_sidings
sledding11248503sledding_
snedding11246953snedding_
sodding103712733sodding_
speedings13265403speedings
steadings11307083steadings
studdings1242933studdings
sweepings15345633sweepings
sweetings13326183sweetings
swellings13296103swellings
teddies92711283teddi_es
tending94419163tending_
tidings93810263_tidings
undoings1035793undoings
veilings12357313veilings
veinings12306433veinings
vending124015263vending_
verdins112812333verdin_s
vestings12359143vestings
waddies124214753waddi_es
waddling14237933waddling_
waddying17204723waddying_
wading114619533w_ading_
waitings123413743waitings
walkings16327313walkings
warding123918143warding_
warnings12358453warnings
washings15419273washings
waxings18366453w_axings
waxwings2232953waxwings
weaklings1794003weaklings
weaning114117193weaning_
weanlings1394413weanlings
wearing113318863wearing_
weaving143211623weaving_
webbing1536123webbing_
wedders123610723wedd_ers
wedeling1338773wedeling_
wedelns11325243wedeln_s
wedgies123910213wedgi_es
weediness13247043weediness
weening114113973weening_
weeping133613673weeping_
weeting113816053weeting_
weirding1335593weirding_
welkins1437173welkin_s
welling112920313welling_
welting113615313welting_
wendigo12845403wendi_go
wendigos13434553wendigos
westing115020273westing_
wetting114117383wetting_
whalings15256763whalings
wheelings16284933wheelings
whidding1734573whidding_
whitings15287063whitings
wickings18357183wickings
widdies123514033widdi_es
widdling14228743widdling_
wielding13286863wielding_
wiggings14316173wiggings
wilding123814293wilding_
wildlings14244923wildlings
winding123517913winding_
windlings14236723windlings
wingdings1543683wingdings
wings95727243w___ings
winnings12327583winnings
wirings113910113w_irings
witlings12328443witlings
wittings12328733wittings
wooding123012023wooding_
wording123014563wording_
workings16337503workings
wreckings19233683wreckings
wrings104012973w__rings
writings12298113writings
yealings12257703yealings

Search took 7 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 Limit1461622596.14023804.9
3Display Results2592590.1102354.5
 (SQL Overall)1786912596.67326778.2
 
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.