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

262 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
coldness113795(None) 
boldness1136971boldness
oldness836401_oldness
baldness1137042baldness
calmness1236642calmness
coldest102514762cold_est
coldnesses1338422coldnesses
colonels104210452colonels
colones96124432colone_s
coolness1037742coolness
cordless11299962cordless
cosiness103214282cosiness
coyness1277322co_yness
coziness19319822coziness
fondness1237212fondness
goodness1036252goodness
holiness112512502holiness
loudness937012loudness
mildness1136522mildness
moldiness12227052moldiness
oddness935312_oddness
soleness8814262soleness
solidness1036902solidness
voidness1235552voidness
wildness1236202wildness
acidness1136723acidness
acridness1245073acridness
agedness1036683agedness
aridness939223aridness
avidness1246113avidness
badness1039573_badness
blondness1234963blondness
boldest102613063bold_est
boldnesses1337233boldnesses
boloneys1334503boloneys
boltless10338283boltless
bondless1148813bondless
boniness102211803boniness
boundness1235943boundness
boxiness17247813boxiness
broadness1256663broadness
caginess11310303caginess
cakiness1449553cakiness
canoness1039393canoness
chadless1436403chadless
chicness1535593chicness
childless1543813childless
chillness1455373chillness
cholines132214493choline_s
clines84926043c_line_s
cloners94514823c_loners
clones84526563c_lone_s
closeness1137613closeness
cloudiness1344113cloudiness
cloudless1243153cloudless
coalless1038193coalless
coatdress1243193coatdress
coatless1039693coatless
cockiness17248783cockiness
cockneys1934493cockneys
codders114114453co_dders
coddlers12359173coddlers
coddles114213593coddle_s
codecs115112933co_d_ecs
codeless112010113codeless
codens94821013co_d_ens
coders95426983co_d_ers
codes86247293co_d_e_s
codgers115113933co_dgers
cohunes1249713cohune_s
coignes103912153coigne_s
coiners93620753co_iners
cojones163512103cojone_s
colanders1238013colanders
colder95121853cold_e_r
coldish1399303cold_ish
colds85726973cold___s
coles76055063col__e_s
coleus86818273col__eus
coleuses1039723coleuses
colies84837053col_ie_s
colinear1045913colinear
colins85229043colin__s
colleens1036843colleens
collets93517903col_lets
colliers103613583colliers
collies94326583collie_s
collinses1138283collinses
colognes11310603cologne_s
colone85425003colone__
colonel94213283colone_l
colonics123711613colonics
colonies103620013colonies
colonise102514283colonise
colonises112814013colonises
colonist102617933colonist
colonists112512503colonists
colons86028683colon__s
colonus94413443colon_us
coloreds1138093coloreds
colorers10312183colorers
colorless1145683colorless
colters93522443col_ters
columels1244813columels
columneas1343013columneas
colures9315143colure_s
comeliness1446993comeliness
comfiness1646953comfiness
compress1439053compress
condense1179613condense
condenses12710133condenses
condoes104319203condoe_s
condoners122811513condoners
condones112817393condone_s
cones76457423co__ne_s
coneys115218423co__neys
confess12399903co_nfess
congress1138073congress
conines93827793conine_s
conners94023113co_nners
cookless14258633cookless
corders104520883cord_ers
coreless103013833coreless
corkiness152810443corkiness
corneas94717003co_rneas
cornels94716663co_rnels
corners94723313co_rners
cornets94820573co_rnets
corniness112611183corniness
coronels104012143coronels
coroners104016223coroners
coronets103814363coronets
cosines94122673cosine_s
costless10310003costless
costliness1245993costliness
couldest1148353could_est
countess103710053countess
coxless1637743co_xless
cozeners19297783cozeners
crossness1137093crossness
crudeness1245753crudeness
curliness1138553curliness
curtness1037263curtness
cuteness1039673cuteness
deadness1039233deadness
doneness9411513doneness
dopiness11289973dopiness
dourness947683dourness
dowdiness1485693dowdiness
doziness18228553doziness
drollness1043623drollness
dullness934873dullness
dulness8307983dul_ness
eldress835003_eldress
eyedness1245103eyedness
fellness1135913fellness
folders113514393fold_ers
foodless12338383foodless
fordless12289003fordless
foulness11236653foulness
foxiness18257403foxiness
foziness20257803foziness
fullness1135443fullness
fulness10248963ful_ness
gelidness1144473gelidness
gladness1036153gladness
goddess1035263go_ddess
godless938403go_dless
godliness1136593godliness
goldenest1147873goldenest
goldenness1243413goldenness
goldest92411173gold_est
goneness9310763goneness
goriness9310753goriness
haleness11312623haleness
halfness1435563halfness
hardness122411083hardness
hokiness152510183hokiness
holders113715903hold_ers
holeless1189363holeless
hominess132712453hominess
hoodless12289733hoodless
hotness1038613ho_tness
idleness936843idleness
illness736473_illness
jokiness19227393jokiness
jolliness1636213jolliness
jowliness1934853jowliness
kindness13236653kindness
lewdness1254173lewdness
loginess9310163loginess
loneness8512093loneness
longness938553longness
lordless9277483lordless
lornness836493lornness
lostness837683lostness
lowliness1236403lowliness
lowness1037813lo_wness
madness10310073_madness
maleness10312313maleness
molders103315553mold_ers
moldiest11249693moldiest
moodiness12197593moodiness
mootness1036753mootness
mopiness12259063mopiness
moreness10911573moreness
nobleness1147523nobleness
nosiness83211393nosiness
notedness1047323notedness
nowness1037033no_wness
oiliness8311563oiliness
oldest72114093_old_est
oldies7314423_oldie_s
oldnesses1037703_oldnesses
oneness7512143_oneness
ooziness17237513ooziness
paleness10312983paleness
pokiness14219863pokiness
polders103617373pold_ers
poleless1089873poleless
poorness1036363poorness
poshness1356653poshness
proudness1246693proudness
redness82012443_redness
roadless937703roadless
rodless8310073ro_dless
ropiness102311073ropiness
rosiness82613173rosiness
roundness1047013roundness
rowdiness1396233rowdiness
sadness8310613_sadness
saltness82610243saltness
scaliness1149303scaliness
scolders11288993scold_ers
selfness1135153selfness
slowness1135013slowness
slyness1035263_slyness
softness1136433softness
solders83517773sold_ers
soldiers9277773soldiers
soleless8910033soleless
solonets838233solonets
soreness8914793soreness
soundness1036963soundness
sourness839543sourness
tallness837103tallness
toadless936313toadless
tolanes74216313tolane_s
ugliness936863ugliness
validness13125363validness
vileness1139983vileness
weldless12285813weldless
wellness1135793wellness
wholeness1545373wholeness
wiliness1139113wiliness
woeness1020211543wo_eness
woodiness13147873woodiness
woodless12278453woodless
wooliness12147693wooliness
wordiness13138633wordiness
wordless12258843wordless
wornness1136363wornness

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 Limit1461622626.58022213.1
3Display Results2622620.0932817.2
 (SQL Overall)1786912627.09325192.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.