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

273 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
direness931130(None) 
airiness8412212airiness
bareness10912812bareness
darkness13247342darkness
dienes75719902di_ene_s
digeneses1147392digeneses
digenesis1145332digenesis
dimness1038842di_mness
directness1344192directness
direnesses11311482direnesses
dirtiness1039472dirtiness
doneness9411512doneness
dryness11114782d_ryness
dueness82310122d_ueness
fineness11310642fineness
fireless112810592fireless
firmness1334742firmness
idleness936842idleness
ireless72312242_ireless
likeness12229862likeness
liteness82213212liteness
liveness112411392liveness
miriness10310462miriness
moreness10911572moreness
niceness1039842niceness
pureness101110182pureness
rareness81112852rareness
rifeness1138582rifeness
ripeness1039362ripeness
soreness8914792soreness
sureness8912902sureness
tiredness1036932tiredness
tireless82510262tireless
vileness1139982vileness
wideness12259472wideness
wireless11249632wireless
wiriness1138952wiriness
wiseness112010752wiseness
agileness1046493agileness
airless73712043air_less
alikeness1336333alikeness
aliveness1238223aliveness
arenes64928393_arene_s
aridness939223aridness
awareness1236343awareness
baroness101210063baroness
baseness10910943baseness
biasness1035813biasness
bigness1038193bi_gness
biremes1138773bireme_s
blueness1038213blueness
briefness1444113briefness
careless102813633careless
coreless103013833coreless
crenels93711013_crenels
cureless10319703cureless
curtness1037263curtness
cuteness1039673cuteness
daftness1235533daftness
dailiness1038673dailiness
dailyness1343643dailyness
dampness1336073dampness
dankness13256693dankness
darkeners1435153darkeners
darnels83710433dar_nels
darners83815773dar_ners
datedness1187753datedness
dateless9259963dateless
dazedness20114963dazedness
deadness1039233deadness
deafness1236213deafness
dearness939973dearness
deepness1136443deepness
defenses1237913defenses
deftness1236303deftness
demoness1138053demoness
demureness1344243demureness
denes65639723d__ene_s
denseness1046863denseness
derepress1243583derepress
dewiness1238453dewiness
diaereses1045593diaereses
diaeresis1044773diaeresis
diageneses1245583diageneses
diagenesis1244583diagenesis
dickenses1645073dickenses
diene65720133di_ene__
diereses938693di_ereses
dieresis956853di_eresis
diesels8429143di_esels
dieses75218693di_ese_s
dieters83216433di_eters
digress938323di_gress
digresses1137863digresses
diluteness1145193diluteness
dimeters11411093dimeters
diners75525953di__ners
dines66449153di__ne_s
dinginess1137823dinginess
dinners83915443di_nners
dipnets10109033di_pnets
dippiness1435973dippiness
directest1246303directest
directress1343103directress
directs102710263dire_cts
direst75024243dir__est
dirges84915103dir_ge_s
dirndls933893dir_ndls
dirties83119383dirtie_s
dirtiest93014203dirtiest
diseases92415813diseases
diseuses93112763diseuses
dispenses121210763dispenses
distress9311713distress
ditsiness1048143ditsiness
ditziness1945883ditziness
diureses936453diurese_s
diverseness1554773diverseness
diviners12308353diviners
divines113514723divine_s
divinest123012173divinest
dizened18267333dizene_d
dizens164911393dizen__s
dizziness1834183dizziness
dopeyness1543473dopeyness
dopiness11289973dopiness
dorkiness14248053dorkiness
dourness947683dourness
doziness18228553doziness
drabness1135803drabness
drees65628523d_re_e_s
dress65319833d_r__ess
dresses83716173d_resses
dripless1135243dripless
drivenness1443463drivenness
droners84114383d_roners
drones75023433d_rone_s
dullness934873dullness
dulness8307983d_ulness
dumbness1334613dumbness
dunness8298983d_unness
duress74712063dur__ess
duresses939173duresses
dwarfness1642793dwarfness
edibleness1345293edibleness
eeriness8311873eeriness
entireness1048363entireness
fairness1136563fair_ness
farness102912203far_ness
fierceness1543793fierceness
fieriness1238623fieriness
firstness1245013firstness
fitness10299393fi_tness
fixedness2043713fixedness
freeness11710443freeness
gameness112810693gameness
goneness9310763goneness
goriness9310753goriness
greyness1235243_greyness
grimness1175993grimness
gyrenes11267523gyrene_s
hairiness1238013hairiness
haleness11312623haleness
hardness122411083hardness
harness102413933har_ness
hideless12278713hideless
highness1536053highness
hipness12277383hi_pness
hirees95117293hire_e_s
hiveless14227933hiveless
hugeness1237373hugeness
iceless9219963_iceless
iciness938863_iciness
illness736473_illness
irateness9310493_irateness
irenics937833_irenics
ironers74813553_ironers
irones64724013_irone_s
ironness836953_ironness
kindness13236653kindness
kirmess13234313kir_mess
lameness102612673lameness
largeness1038273largeness
lateness82614073lateness
licenses10118923licenses
liernes739623lierne_s
lifeless11228143lifeless
limeless10249663limeless
liminess10510643liminess
limpness1246703limpness
lineless82711943lineless
lioness739103li_oness
litheness1247363litheness
liveners11217933liveners
loneness8512093loneness
lornness836493lornness
maleness10312313maleness
mildness1136523mildness
mirexes1636993mirexe_s
muteness1039013muteness
naiveness1277493naiveness
nighness1236103nighness
nudeness936733nudeness
oiliness8311563oiliness
oneness7512143_oneness
paleness10312983paleness
pertness10310093pertness
pileless1088623pileless
pinenes93416673pinene_s
pinkness1436513pinkness
pipeless12107663pipeless
pipiness1238003pipiness
pixiness1736093pixiness
precess11310863_precess
primeness1338653primeness
primness1276763primness
pyrenes123511223pyrene_s
recess8314263__recess
redness82012443__redness
renest64529713__renest
renests74014213__renests
renews93811753__renews
richness1337433richness
riminess10510093riminess
ripeners1036833ripeners
rudeness938083rudeness
safeness11239633safeness
sageness92111983sageness
sameness102712683sameness
saneness82313723saneness
serenes73222903serene_s
serenest82717623serenest
sickness1437833sickness
sidedness1146783sidedness
sirees64624583sire_e_s
sirens65318153siren__s
siziness1737423siziness
snideness1067683snideness
soleness8814263soleness
spareness1139863spareness
spryness1334003spryness
tameness102411253tameness
tartness82210133tartness
terseness948403terseness
tideless9269083tideless
tidiness938793tidiness
tieless72512563ti_eless
timeless10239543timeless
tininess8310633tininess
tiredest938403tiredest
titaness836723titaness
trienes74118413triene_s
trigness968403trigness
trimness1067563trimness
triteness9310363triteness
trueness838693trueness
tweeness11246403tweeness
viceless1337983viceless
waeness102512783_waeness
wariness11313213wariness
warmness1337063warmness
weirdness1343593weirdness
whiteness1546483whiteness
wideners12257993wideners
wieners103212483wi_eners
wifeless14277483wifeless
wildness1236203wildness
wiliness1139113wiliness
wineless112711173wineless
witness103010013wi_tness
woeness1020211543_woeness
wornness1136363wornness
wryness13113983_wryness

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 Limit1461622737.03020791.2
3Display Results2732730.1102481.8
 (SQL Overall)1786912737.56323627.0
 
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.