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

172 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
drabness113580(None) 
darkness13247342darkness
deadness1039232deadness
deafness1236212deafness
dearness939972dearness
drabbest13295662drabbest
drabbets13294822drabbets
drabnesses1336482drabnesses
dragnets10136562dragnets
drainers92811252drainers
dryness11114782dr_yness
dumbness1334612dumbness
grayness1235932grayness
rawness1038152_rawness
abbess10509773__abbess
arabesk1332863arab_esk
arabesks1442743arab_esks
arables91814973arable_s
archness1337513archness
aridness939223aridness
artiness81615403artiness
awayness1443303awayness
badness1039573_badness
barbless12318713barbless
bareness10912813bareness
baroness101210063baroness
biasness1035813biasness
brainless1136403brainless
braless92910563bra_less
branners104010923branners
brashness1436323brashness
braveness14237763braveness
broadness1256663broadness
crabbers14358753crabbers
cranes84330753cra_ne_s
crassness1136213crassness
craziness2037383craziness
dabbers123813213d_abbers
daftness1235533daftness
damners104112113d_amners
dampness1336073dampness
dankness13256693dankness
darbies104216983darbie_s
darnels83710433d_arnels
darners83815773d_arners
deaconess1245543deaconess
deepness1136443deepness
deftness1236303deftness
demoness1138053demoness
dewiness1238453dewiness
diabases1137223diabases
dimness1038843d_imness
direness9311303direness
dirtiness1039473dirtiness
doneness9411513doneness
dopiness11289973dopiness
dorkiness14248053dorkiness
dourness947683dourness
doziness18228553doziness
drabbed13428723drabbe_d
drabber12438593drabbe_r
drabbet12319573drabbe_t
drabbles13308523drabbles
drabs85119673drab___s
dracenas1145793dracenas
draftees12225253draftees
drafters12338533drafters
draftiness1444863draftiness
dragees9359483dra_gees
draggers11357393draggers
dragnet91211433dragne_t
dragonets11134503dragonets
drained93713253draine_d
drainer83012843draine_r
drains73719403drain__s
drakes114715863dra_ke_s
drapers105313353dra_pers
drapes95419653dra_pe_s
drawees11378363dra_wees
drawers113610073dra_wers
drawlers12307313drawlers
dreaminess1345313dreaminess
dreamless1243513dreamless
dreariness1146283dreariness
dress65319833dr___ess
driblets11266093driblets
dripless1135243dripless
drollness1043623drollness
droners84114383dr_oners
drones75023433dr_one_s
drowners12428273drowners
drubbers13386033drubbers
druidess1043083druidess
dueness82310123d_ueness
dullness934873dullness
dulness8307983d_ulness
dunness8298983d_unness
durableness1446713durableness
durables11237013durable_s
dwarfness1642793dwarfness
farness102912203_farness
fatness103311293_fatness
flatness1138153flatness
frailness1236543frailness
frankness1655223frankness
freeness11710443freeness
garbless11388253garbless
gayness1136843_gayness
gladness1036153gladness
glibness1134133glibness
grabbers13337883grabbers
grabens10367003grab_ens
grainers93012073grainers
grainless1035893grainless
grandness1138303grandness
grapiness1238253grapiness
grapnels1134393grapnels
graveness13288383graveness
greatness1036903greatness
greyness1235243greyness
grimness1175993grimness
hardness122411083hardness
harness102413933_harness
irateness9310493irateness
ironness836953ironness
laxness1436043_laxness
leanness837373leanness
madness10310073_madness
meanness1037183meanness
nearness838313nearness
neatness839153neatness
numbness1234413numbness
oratress834553oratress
orbless937493or_bless
ovalness1134673ovalness
patness92912283_patness
prawners1346003prawners
prebless1236823prebless
primness1276763primness
rabbets11279423_rabbets
rabidness12145263_rabidness
rabies85226023_rabie_s
raciness102413453_raciness
rainless8129703_rainless
ranees64623963_ra_nees
rankness12267943_rankness
raptness1046733_raptness
rareness81112853_rareness
rashness1138093_rashness
rayless10239003_rayless
realness8410443realness
redness82012443_redness
ribless93410343_ribless
sadness8310613_sadness
snubness1044373snubness
tartness82210133tartness
trainees82712063trainees
trainers83114643trainers
tramless1037503tramless
trapnest10310923trapnest
trapnests1144433trapnests
trigness968403trigness
trimness1067563trimness
trueness838693trueness
urbanest10117533urbanest
waeness102512783_waeness
wanness102610683_wanness
wariness11313213wariness
warmness1337063warmness
weakness1535353weakness
whatness1435093whatness
wryness13113983wr_yness

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.420425454.8
2DLD Change Limit1461621726.78321548.3
3Display Results1721720.0632730.2
 (SQL Overall)1786911727.26624592.8
 
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.