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

399 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
dimness103884(None) 
aimless93610812aimless
bigness1038192bigness
damners104112112damners
dampness1336072dampness
demoness1138052demoness
dienes75719902diene_s
digress938322digress
dimers94321092dim_ers
dimes85833042dim_e_s
dimmers123811562dimmers
dimmest1249252dimmest
dimnesses1238212dimnesses
diners75525952di_ners
dines66449152di_ne_s
dinners83915442dinners
dipnets10109032dipnets
direness9311302direness
dryness11114782dryness
dueness82310122dueness
dulness8307982dulness
dumbness1334612dumbness
dunness8298982dunness
firmness1334742firmness
fitness10299392fitness
grimness1175992grimness
hipness12277382hipness
liminess10510642liminess
limners93311562limners
limpness1246702limpness
lioness739102lioness
primness1276762primness
riminess10510092riminess
rimless9369362rimless
simnels976102simnels
slimness1036522slimness
trimness1067562trimness
witness103010012witness
acidness1136723acidness
aidless83612073aidless
aimers84621913aim_ers
airiness8412213airiness
airless73712043airless
almners9399563almners
amines84727983amine_s
aptness9268573aptness
aridness939223aridness
armless9369943armless
avidness1246113avidness
badness1039573badness
biasness1035813biasness
bibless11439173bibless
biners85023633bi_ners
bines76946793bi_ne_s
brimless1235273brimless
calmness1236643calmness
chicness1535593chicness
chimneys1883643chimneys
cines75239683ci_ne_s
coyness1277323coyness
daftness1235533daftness
dailiness1038673dailiness
dailyness1343643dailyness
daimones11208803daimone_s
dames85435853dam_e_s
dammers123214273dammers
damndest1276003damndest
damndests1392793damndests
damned104212913damne_d
damner95213433damne_r
damns84916923damn__s
dampens12348563dampens
dampers123915693dampers
dampest12411043dampest
damsels10126703damsels
dankness13256693dankness
darkness13247343darkness
darnels83710433darnels
darners83815773darners
deadness1039233deadness
deafness1236213deafness
dearness939973dearness
deepness1136443deepness
deftness1236303deftness
dements103016623dements
demes86032693dem_e_s
demies94825803demie_s
demises103719563demises
demoses103815823demoses
denes65639723d_ene_s
depress10239873depress
dewiness1238453dewiness
dewless1137473dewless
diadems1135393diadems
dialers83614303dialers
diamines11311643diamine_s
diapers104713913diapers
dibbers124013173dibbers
dicers94720743di_cers
dices86434243di_ce_s
diciest103316523diciest
dickens144410133dickens
dickers144117663dickers
dickeys17479303dickeys
didies84621833didie_s
didoes85716963didoe_s
diene65720133diene__
diereses938693diereses
dieresis956853dieresis
dies55653523di__e_s
diesels8429143diesels
dieses75218693di__eses
diesis74013493di__esis
dieters83216433dieters
diets66026643di__ets
differs14339973differs
digeneses1147393digeneses
digenesis1145333digenesis
digest84019623di_gest
digests93610613di_gests
diggers104413393diggers
dikers114418793di_kers
dikes105831333di_ke_s
dime76237643dim_e__
dimer85625603dim_e_r
dimeters11411093dimeters
diminish14127523diminish
dimmed124110323dimme_d
dimmer114112613dimme_r
dimouts1037893dimouts
dimples122813213dimples
dims75435023dim___s
dimwits1344513dimwits
dinars75417563di_nars
dine55555333di_ne__
dined76431993di_ne_d
diner65632903di_ne_r
dinero75612643di_nero
dineros83812333di_neros
dingers94321383dingers
dinges83825423di_nges
dingeys12458403dingeys
dinginess1137823dinginess
dings76331403di_n_gs
dingus83611843di_ngus
dinkeys15507263dinkeys
dinks105927953di_n_ks
dinned84317613dinne_d
dinner74217163dinne_r
dinos65428063di_n_os
dins56652043di_n__s
dints67431313di_n_ts
diocese1036853diocese
dioceses1137113dioceses
diodes83915783diode_s
dipnet91317473dipne_t
dippers123615183dippers
dippiness1435973dippiness
direst75024243di_rest
dirges84915103dirge_s
dirndls933893dirndls
dirtiness1039473dirtiness
discuss10357953discuss
dishes104622653dishe_s
dismalness1344043dismalness
dismes95617673disme_s
dismiss1038153dismiss
dispels10310503dispels
diss56434483di___ss
disses75225963disse_s
distress9311713distress
disuses84015413disuses
dites66339153di_te_s
dithers114016153dithers
ditsiness1048143ditsiness
ditzes163212423ditze_s
ditziness1945883ditziness
diureses936453diureses
diuresis945133diuresis
divers105024963di_vers
dives95832403di_ve_s
divest106820073di_vest
divests114510933di_vests
diviners12308353diviners
divines113514723divine_s
divinest123012173divinest
dizens164911393di_zens
dizziness1834183dizziness
domes85735563dom_e_s
domines102918973domine_s
donees74519493d_onees
doneness9411513doneness
donnees84210363donnees
dopiness11289973dopiness
dourness947683dourness
downers113912773downers
downless1236363downless
doziness18228553doziness
drabness1135803drabness
dress65319833d__ress
dripless1135243dripless
droners84114383droners
drones75023433drone_s
duchess1335553duchess
dullness934873dullness
dumbest1238743dumbest
dumpers123412663dumpers
dumpiness1435653dumpiness
dunes65332173d_une_s
dunnest83312263dunnest
duress74712063d_uress
dwines105013103dwine_s
dynels10536813d_ynels
dynes95917583d_yne_s
edginess1036053edginess
editress944933editress
evilness1135043evilness
fairness1136563fairness
farness102912203farness
fatness103311293fatness
fewness1335003fewness
feyness1334923feyness
filminess1435983filminess
filmless1344553filmless
fineness11310643fineness
fines86644263fi_ne_s
finesse10187643fi_nesse
finest94321733fi_nest
finless102810783finless
fulness10248963fulness
gameness112810693gameness
gaminess112911063gaminess
gayness1136843gayness
giantess933893giantess
gimels938893gim_els
gimlets10338433gimlets
gimmes113010903gimme_s
ginners84314223ginners
glibness1134133glibness
glumness1135203glumness
griminess1236703griminess
gumless10228273gumless
harness102413933harness
highness1536053highness
hipless12399923hipless
hitless103211193hitless
hominess132712453hominess
hotness1038613hotness
hymnless1632803hymnless
iciness938863iciness
idleness936843idleness
illness736473illness
imbeds11456743_imbeds
imines84918353_imine_s
immesh1334113_immesh
impels10389523_impels
impress1137773_impress
inmesh1134863_inmesh
inners63919353_inners
innless7288293_innless
jimpest18297553jimpest
jitneys17313173jitneys
kidneys1533423kidneys
kindness13236653kindness
kines95039133ki_ne_s
kineses113111253ki_neses
kinesis11259593ki_nesis
kinless113310273kinless
kirmess13234313kirmess
lameness102612673lameness
laxness1436043laxness
lianes63819323liane_s
lidless8309273lidless
likeness12229863likeness
limbers113614743limbers
limbless12246313limbless
limeless10249663limeless
limens84618033lim_ens
limes75636503lim_e_s
limeys11429273lim_eys
limiest93716103limiest
limmers113413083limmers
limned94811473limne_d
limner84112873limne_r
limns75718393limn__s
limpers113815223limpers
limpest113712313limpest
limpets11329783limpets
linens64818393li_nens
liners65428853li_ners
lines57054573li_ne_s
linnets739833linnets
lipless9259553lipless
liteness82213213liteness
liveness112411393liveness
lowness1037813lowness
madness10310073madness
mess65932433__m_ess
mildness1136523mildness
milnebs11113793milnebs
mimeos104511543mim_eos
mimers105520183mim_ers
mimes95732023mim_e_s
mimeses1139073mim_eses
mimesis1137323mim_esis
miners84126633mi_ners
mines75651953mi_ne_s
miriness10310463miriness
ness45526563___ness
newness1035703newness
niceness1039843niceness
nighness1236103nighness
nimbyness1641543nimbyness
nines55937343ni_ne_s
nowness1037033nowness
numbness1234413numbness
oddness935313oddness
oiliness8311563oiliness
oldness836403oldness
oneness7512143oneness
patness92912283patness
pines76048863pi_ne_s
pinkness1436513pinkness
pinners93518603pinners
pipiness1238003pipiness
pixiness1736093pixiness
primeness1338653primeness
rawness1038153rawness
redness82012443redness
ribless93410343ribless
richness1337433richness
rifeness1138583rifeness
rimers84522553rim_ers
rimes75634543rim_e_s
rimiest93215853rimiest
rimmers113812883rimmers
rinses64720383ri_nses
ripeness1039363ripeness
sadness8310613sadness
sameness102712683sameness
shyness1344993shyness
sickness1437833sickness
signees83510803signees
signers84714443signers
signets83311503signets
simmers113314613simmers
simnel857023simne_l
simpers113014123simpers
sines55954823si_ne_s
sinews94210623si_news
sinless73014213sinless
sinners74019023sinners
siziness1737423siziness
sliminess1137423sliminess
slyness1035263slyness
sumless92611123sumless
tameness102411253tameness
thinness11277163thinness
tidiness938793tidiness
tieless72512563tieless
tigress836093tigress
timbers113111853timbers
timeless10239543timeless
timers84420993tim_ers
times75630823tim_e_s
timidness1244623timidness
tineas64616483ti_neas
tines54848423ti_ne_s
tininess8310633tininess
tinners73717313tinners
tipless92610063tipless
titaness836723titaness
trigness968403trigness
vainness1136063vainness
vileness1139983vileness
vines85137643vi_ne_s
voidness1235553voidness
waeness102512783waeness
wanness102610683wanness
warmness1337063warmness
wetness10277723wetness
wideness12259473wideness
wieners103212483wieners
wigless11359673wigless
wildness1236203wildness
wiliness1139113wiliness
wimpiness1635293wimpiness
wines85546863wi_ne_s
winless103212283winless
winners104316913winners
wiriness1138953wiriness
wiseness112010753wiseness
witless103310983witless
witneys13274723witneys
woeness1020211543woeness
wryness13113983wryness
zinebs17606803zi_nebs
zines145232653zi_ne_s
zipless18276303zipless

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273996.76319817.7
3Display Results3993990.1562557.7
 (SQL Overall)1786913997.32524394.7
 
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.