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

258 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
deadness103923(None) 
deafness1236211deafness
dearness939971dearness
badness1039572_badness
beadiness12249232beadiness
deaconess1245542deaconess
deadeners1146282deadeners
deadens93410692dead_ens
deadest93014882dead_est
deadliness12115892deadliness
deadnesses1238942deadnesses
deedless10318252deedless
deepness1136442deepness
deftness1236302deftness
demoness1138052demoness
dewiness1238452dewiness
drabness1135802drabness
gladness1036152gladness
headiness132510362headiness
headless12289862headless
leadless9248792leadless
leanness837372leanness
lewdness1254172lewdness
madness10310072_madness
meanness1037182meanness
nearness838312nearness
neatness839152neatness
readiness102611852readiness
realness8410442realness
redness82012442re_dness
sadness8310612_sadness
weakness1535352weakness
acidness1136723acidness
adeptness1273953adeptness
agedness1036683agedness
aridness939223aridness
avidness1246113avidness
awayness1443303awayness
baldness1137043baldness
beaders104120183bead_ers
beadiest113815533beadiest
beadles103414733beadle_s
beakless14297383beakless
beamless12327003beamless
beardless1234913beardless
beatless103311593beatless
bedless1039703be_dless
biasness1035813biasness
blandness1235973blandness
bleakness1543593bleakness
boldness1136973boldness
breadless1235943breadless
broadness1256663broadness
chadless1436403chadless
cheapness1643743cheapness
cleanness1144973cleanness
clearness1135633clearness
coldness1137953coldness
dadoes85616533d_adoe_s
daftness1235533daftness
damners104112113d_amners
dampness1336073dampness
danders93921183d_anders
dankness13256693dankness
darkness13247343darkness
darnels83710433d_arnels
darners83815773d_arners
datedness1187753datedness
dazedness20114963dazedness
deadbeat1245803deadbeat
deadbeats1343683deadbeats
deaden83714323dead_e_n
deadened1137233deadened
deadener1036743deadener
deader84220473dead_e_r
deadeye1245163dead_eye
deadeyes1344563deadeyes
deadhead1444433deadhead
deadheads1544023deadheads
deadliest1138183deadliest
deadlines11138503deadline_s
deadmen11248573deadme_n
deadpans12205173deadpans
deads75726913dead___s
deafens11317253dea_fens
deafest112911513dea_fest
deafnesses1436223deafnesses
dealers84118613dea_lers
deaned84620453dea_ne_d
deanery1137613dea_nery
deans66131393dea_n__s
dearest83618673dea_rest
dearies83526273dearie_s
dearnesses1139583dearnesses
deashes113313903deashe_s
deathless1335223deathless
deaves105319533dea_ve_s
deboners11268113deboners
debones103315113debone_s
debtless1135653debtless
decadents1346393decadents
decades113615513decad_e_s
decanes103118913decane_s
decayless1542863decayless
dedans85915073dedan__s
deediest102912253deediest
defenses1237913defenses
definers124211193definers
defines114118683define_s
delaines9312963delaine_s
demanders13247573demanders
denes65639723de__ne_s
denseness1046863denseness
depones103717093depone_s
depress10239873de_press
detainees10267153detainees
detainers10269103detainers
dewless1137473de_wless
diadems1135393diad_ems
dimness1038843d_imness
direness9311303direness
doneness9411513doneness
dopiness11289973dopiness
dourness947683dourness
dowdiness1485693dowdiness
doziness18228553doziness
dragnets10136563dragnets
drainers92811253drainers
dreaminess1345313dreaminess
dreamless1243513dreamless
dreariness1146283dreariness
dryness11114783d_ryness
dueness82310123d_ueness
dullness934873dullness
dulness8307983d_ulness
dumbness1334613dumbness
dunness8298983d_unness
dwarfness1642793dwarfness
earless74316073_earless
earners74016453_earners
earnest7318733_earnest
earnests837853_earnests
easiness8313043_easiness
edginess1036053edginess
eeriness8311873eeriness
eldress835003_eldress
endless839833_endless
eyedness1245103eyedness
fadedness1445613fade_dness
farness102912203_farness
fatness103311293_fatness
fearless1137873fearless
fellness1135913fellness
fetidness1345443fetidness
fewness1335003fe_wness
feyness1334923fe_yness
flatness1138153flatness
fondness1237213fondness
gayness1136843_gayness
gearless937373gearless
gelidness1144473gelidness
goodness1036253goodness
grandness1138303grandness
grayness1235933grayness
greatness1036903greatness
hardness122411083hardness
harness102413933_harness
headdress1443753headdress
headends13326723headends
headers113819393head_ers
headiest123015553headiest
headrest122910203headrest
headrests13245023headrests
headsets1236053headsets
heatless113011463heatless
heaviness15207063heaviness
heedless12278813heedless
idealess935653idea_less
idealless1042953idealless
jadedness1844693jade_dness
keenness1234883keenness
kindness13236653kindness
laxness1436043_laxness
leadenness1144443leadenness
leadens83610983lead_ens
leaders83819603lead_ers
leadiest93314983leadiest
leafiness1236483leafiness
leafless11246573leafless
leakiness1337503leakiness
leakless12246983leakless
leaners73718173lea_ners
leanest7415863lea_nest
learners8398153learners
loudness937013loudness
mealiness11310063mealiness
mealless10288363mealless
meanders1168833meanders
meaners94415243mea_ners
meanest9315703mea_nest
meatiness11311183meatiness
meatless103410863meatless
meekness1434303meekness
meetness1036653meetness
mildness1136523mildness
neediness10227733neediness
needless9308333needless
nerdiness10208333nerdiness
newness1035703ne_wness
oddness935313_oddness
oldness836403_oldness
ovalness1134673ovalness
patness92912283_patness
peakedness1744863peakedness
peakless14236683peakless
peartness1137773peartness
pertness10310093pertness
rawness1038153_rawness
readdress1143823readdress
readers83823773read_ers
readies83324713readie_s
readiest93719043readiest
reassess836513reassess
redress82511873re_dress
reediness10239613reediness
regalness1045473regalness
roadless937703roadless
seaminess11310473seaminess
seamless10238723seamless
seatless83213003seatless
seediness10219173seediness
seedless9319513seedless
selfness1135153selfness
sexiness1537943sexiness
shadiness1337463shadiness
sidedness1146783side_dness
staidness1037033staidness
steadiness1146703steadiness
teariness9310633teariness
tearless848713tearless
tepidness1244343tepidness
toadless936313toadless
treadless1036003treadless
vexedness2043863vexedness
voidness1235553voidness
waeness102512783_waeness
wanness102610683_wanness
weaners104613833wea_ners
weariness1238843weariness
weediness13247043weediness
weedless12287963weedless
weirdness1343593weirdness
weldless12285813weldless
wellness1135793wellness
wetness10277723we_tness
whatness1435093whatness
wildness1236203wildness
yearners11346373yearners

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 Limit1461622587.64019131.2
3Display Results2582580.1102345.5
 (SQL Overall)1786912588.17321863.6
 
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.