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

246 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
nearness83831(None) 
dearness939971dearness
neatness839151neatness
clearness1135632clearness
deadness1039232deadness
deafness1236212deafness
earless74316072_earless
earners74016452_earners
earnest7318732_earnest
earnests837852_earnests
farness102912202_farness
fearless1137872fearless
gearless937372gearless
harness102413932_harness
leanness837372leanness
learners8398152learners
meanness1037182meanness
nearest73415842near_est
nearnesses1039102nearnesses
newness1035702ne_wness
peartness1137772peartness
realness8410442realness
teariness9310632teariness
tearless848712tearless
unharness1245252unharness
weakness1535352weakness
weariness1238842weariness
yearners11346372yearners
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
darkness13247343_darkness
darnels83710433_darnels
darners83815773_darners
deaconess1245543deaconess
dearest83618673dear_est
dearies83526273dearie_s
dearnesses1139583dearnesses
deepness1136443deepness
deftness1236303deftness
demoness1138053demoness
depress10239873depr_ess
dewiness1238453dewiness
dourness947683dourness
drabness1135803drabness
dreariness1146283dreariness
dwarfness1642793dwarfness
eagerness1046263_eagerness
earliness939693_earliness
earned74818333_earne_d
earner63617223_earne_r
earns55927563_earn__s
easiness8313043_easiness
eeriness8311873eeriness
egress73310433_egr_ess
ernes55224813_e_rne_s
fairness1136563fairness
fatness103311293_fatness
fearers104815273fear_ers
fellness1135913fellness
fernless1136063fe_rnless
fewness1335003fe_wness
feyness1334923fe_yness
flatness1138153flatness
garners83815983_garners
garnets84115403_garnets
gayness1136843_gayness
gladness1036153gladness
glariness1038553glariness
grayness1235933grayness
greatness1036903greatness
hardness122411083_hardness
headiness132510363headiness
headless12289863headless
hearers104319783hear_ers
hearkens15336693hearkens
hearses104414533hearse_s
heartens113010153heartens
heartiness1338033heartiness
heartless1236393heartless
heatless113011463heatless
heaviness15207063heaviness
heiress1036813heir_ess
heirless1146053heirless
hoariness1238823hoariness
ineptness1145073ineptness
inertness947973inertness
innerness946913innerness
inverness1247133inverness
inwardness1443773inwardness
keenness1234883keenness
kermess13396223ke_rmess
kernels11417953ke_rnels
kernes104717523ke_rne_s
largess8408913_largess
laxness1436043_laxness
leadless9248793leadless
leafiness1236483leafiness
leafless11246573leafless
leakiness1337503leakiness
leakless12246983leakless
leaners73718173lea_ners
leanest7415863lea_nest
leariest83117843leariest
learned8329303learne_d
learner7319383learne_r
learns65513743learn__s
leeriness938323leeriness
lewdness1254173lewdness
madness10310073_madness
meagerness1344183meagerness
mealiness11310063mealiness
mealless10288363mealless
meaners94415243mea_ners
meanest9315703mea_nest
meatiness11311183meatiness
meatless103410863meatless
meekness1434303meekness
meetness1036653meetness
merriness1138293merriness
napless93110283n_apless
nares55544153n_ar_e_s
neared75119803near_e_d
nearer64618893near_e_r
nearliest949363nearliest
nears55529423near___s
neatens73310403nea_tens
neatest72516003nea_test
neatnesses10310013neatnesses
neatniks1242763neatniks
neckless14236433neckless
necroses10310563necroses
neediness10227733neediness
needless9308333needless
nenes55329673ne__ne_s
nerdiness10208333nerdiness
nereis6315343ne_r_eis
nerves94216193ne_rve_s
nerviness12226873nerviness
netless739863ne_tless
neurines8311193neurine_s
neurones839673neurone_s
neuroses8310153neuroses
newsiness1236033newsiness
newsless1134533newsless
niceness1039843niceness
nighness1236103nighness
nosiness83211393nosiness
nowness1037033n_owness
nudeness936733nudeness
numbness1234413numbness
oarless73913373_oarless
oneness7512143one__ness
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
sharpness1434933sharpness
sheerness1236273sheerness
smartness1136143smartness
sneakiness1454873sneakiness
sourness839543sourness
spareness1139863spareness
starkness1335963starkness
starless81610843starless
swartness1236113swartness
tartness82210133_tartness
tearers75218233tear_ers
teariest82417263teariest
ternes65422903te_rne_s
unearned9310063unearne_d
uneasiness1046393uneasiness
unfairness1342813unfairness
unwariness1365883unwariness
waeness102512783_waeness
wanness102610683_wanness
wariness11313213_wariness
warless104015103_warless
warmness1337063_warmness
warners103315563_warners
weaners104613833wea_ners
wearers104615903wear_ers
wearies103020223wearie_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.1561145455.1
2DLD Change Limit1461622469.14015991.5
3Display Results2462460.0932645.2
 (SQL Overall)1786912469.38919032.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.