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

301 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
dearness93997(None) 
deadness1039231deadness
deafness1236211deafness
nearness838311nearness
clearness1135632clearness
darkness13247342d_arkness
darnels83710432d_arnels
darners83815772d_arners
deaconess1245542deaconess
dearest83618672dear_est
dearies83526272dearie_s
dearnesses1139582dearnesses
deepness1136442deepness
deftness1236302deftness
demoness1138052demoness
depress10239872depr_ess
dewiness1238452dewiness
dourness947682dourness
drabness1135802drabness
dreariness1146282dreariness
dwarfness1642792dwarfness
earless74316072_earless
earners74016452_earners
earnest7318732_earnest
earnests837852_earnests
farness102912202_farness
fearless1137872fearless
gearless937372gearless
harness102413932_harness
leanness837372leanness
learners8398152learners
meanness1037182meanness
neatness839152neatness
peartness1137772peartness
realness8410442realness
teariness9310632teariness
tearless848712tearless
weakness1535352weakness
weariness1238842weariness
yearners11346372yearners
adeptness1273953adeptness
apartness1146053apartness
awareness1236343awareness
awayness1443303awayness
badness1039573_badness
bareness10912813_bareness
barless94317003_barless
barneys12569563_barneys
baroness101210063_baroness
beadiness12249233beadiness
beakless14297383beakless
beamless12327003beamless
beardless1234913beardless
bearers94619593bear_ers
beatless103311593beatless
beeriness1137863beeriness
biasness1035813biasness
blarneys13183193blarneys
bleakness1543593bleakness
bleariness1246053bleariness
caress85720263_car_ess
carless95118493_carless
carnets93918403_carnets
carneys124310543_carneys
chariness14310063chariness
charnels13328173charnels
cheapness1643743cheapness
cleanness1144973cleanness
daftness1235533daftness
damners104112113d_amners
dampness1336073dampness
dankness13256693dankness
darers75921873d_ar_ers
dares66146703d_ar_e_s
darkens12409873d_arkens
darkest122512623d_arkest
darkeys15356533d_arkeys
darndest1067223d_arndest
darndests1183143d_arndests
darned85018483d_arne_d
darnel74312183d_arne_l
darner74017303d_arne_r
darns66927893d_arn__s
darters84017603d_arters
deadeners1146283deadeners
deadens93410693dea_dens
deadest93014883dea_dest
deadliness12115893deadliness
deadnesses1238943deadnesses
deafens11317253dea_fens
deafest112911513dea_fest
deafnesses1436223deafnesses
dealers84118613dea_lers
deaned84620453dea_ne_d
deanery1137613dea_nery
deans66131393dea_n__s
dearer74822803dear_e_r
dearie73319813dearie__
dears65736883dear___s
dearths11498843dear_ths
deashes113313903deashe_s
deathless1335223deathless
deaves105319533dea_ve_s
debarkers16164553debarkers
deboners11268113deboners
debones103315113debone_s
debriefs1433533debriefs
debtless1135653debtless
decanes103118913decane_s
decares102818533decar_e_s
decayless1542863decayless
decreers11277623decreers
decrees102513123decr_ees
decriers11299733decriers
decries103319813decrie_s
deedless10318253deedless
defenses1237913defenses
definers124211193definers
defines114118683define_s
degrees92810723degr_ees
dehorners1344743dehorners
dekares122710873dekar_e_s
delaines9312963delaine_s
demureness1344243demureness
denes65639723de__ne_s
denseness1046863denseness
departees1265723departees
depones103717093depone_s
derangers1136703derangers
deranges1039973deranges
derates84028893derate_s
derries83124623derrie_s
derrises93012783derrises
detainees10267153detainees
detainers10269103detainers
dewless1137473de_wless
dharnas1155373dharn_as
diaries83321953diarie_s
digress938323digr_ess
dimness1038843d_imness
direness9311303direness
doneness9411513doneness
doorless936713doorless
dopiness11289973dopiness
doziness18228553doziness
dragnets10136563dragnets
drainers92811253drainers
dreaminess1345313dreaminess
dreamless1243513dreamless
drearies92313413drearie_s
dreariest10229123dreariest
dress65319833d__r_ess
dryness11114783d_ryness
dueness82310123d_ueness
dullness934873dullness
dulness8307983d_ulness
dumbness1334613dumbness
dunness8298983d_unness
duress74712063d_ur_ess
dwarfest1543473dwarfest
dwarves1434463dwarve_s
eagerness1046263_eagerness
earliness939693_earliness
earned74818333_earne_d
earner63617223_earne_r
earns55927563_earn__s
easiness8313043_easiness
edginess1036053edginess
eeriness8311873eeriness
egress73310433_egr_ess
ernes55224813_e_rne_s
fairness1136563fairness
fatness103311293_fatness
fearers104815273fear_ers
fellness1135913fellness
fernless1136063fe_rnless
fewness1335003fe_wness
feyness1334923fe_yness
flatness1138153flatness
garners83815993_garners
garnets84115413_garnets
gayness1136843_gayness
gladness1036153gladness
glariness1038553glariness
grayness1235933grayness
greatness1036903greatness
hardness122411083_hardness
headiness132510363headiness
headless12289863headless
hearers104319783hear_ers
hearkens15336693hearkens
hearses104414543hearse_s
heartens113010153heartens
heartiness1338033heartiness
heartless1236393heartless
heatless113011463heatless
heaviness15207063heaviness
heiress1036813heir_ess
heirless1146053heirless
hoariness1238823hoariness
idealess935653idea_less
idealless1042953idealless
keenness1234883keenness
kermess13396223ke_rmess
kernels11417953ke_rnels
kernes104717533ke_rne_s
largess8408913_largess
laxness1436043_laxness
leadless9248793leadless
leafiness1236483leafiness
leafless11246573leafless
leakiness1337503leakiness
leakless12246983leakless
leaners73718173lea_ners
leanest7415863lea_nest
leariest83117853leariest
learned8329303learne_d
learner7319383learne_r
learns65513743learn__s
leeriness938323leeriness
lewdness1254173lewdness
madness10310073_madness
meagerness1344183meagerness
mealiness11310063mealiness
mealless10288363mealless
meaners94415243mea_ners
meanest9315703mea_nest
meatiness11311183meatiness
meatless103410863meatless
meekness1434303meekness
meetness1036653meetness
merriness1138293merriness
nearest73415843near_est
nearnesses1039113nearnesses
newness1035703ne_wness
oarless73913373_oarless
ovalness1134673ovalness
patness92912283_patness
peakless14236683peakless
pearlers1039033pearlers
peartest10311303peartest
peeress939503peer_ess
peerless1037513peerless
pertness10310093pertness
poorness1036363poorness
queerness1844213queerness
rareness81112853_rareness
rawness1038153_rawness
readiness102611853readiness
rearers74323563rear_ers
rearrest8311603rearrest
rearrests945313rearrests
reassess836513reassess
redness82012443re_dness
redress82511873redr_ess
regalness1045473regalness
regress82711453regr_ess
repress92712683repr_ess
sadness8310613_sadness
scariness11310183scariness
scarless10189053scarless
seaminess11310473seaminess
seamless10238723seamless
searest73322023sear_est
seatless83213003seatless
seeress7311573seer_ess
selfness1135153selfness
sexiness1537943sexiness
sharpness1434943sharpness
sheerness1236273sheerness
smartness1136143smartness
sourness839543sourness
spareness1139863spareness
starkness1335963starkness
starless81610843starless
swartness1236113swartness
tartness82210133_tartness
tearers75218233tear_ers
teariest82417263teariest
ternes65422903te_rne_s
unharness1245253unharness
waeness102512783_waeness
wanness102610683_wanness
wariness11313213_wariness
warless104015103_warless
warmness1337063_warmness
warners103315563_warners
weaners104613833wea_ners
wearers104615903wear_ers
wearies103020233wearie_s
weariest112914793weariest
weariless1234763weariless
weirdness1343593weirdness
wellness1135793wellness
wetness10277723we_tness
whatness1435093whatness
yarners104312203_yarners
yearends12234483yearends
yearned11327373yearne_d
yearner10336873yearne_r
yearns9509543yearn__s

Search took 10 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.813219792.1
2DLD Change Limit1461623018.81316584.8
3Display Results3013010.1102736.4
 (SQL Overall)1786913019.73618353.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.