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

267 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
coolness103774(None) 
boonless10328352boonless
coalless1038192coalless
coldness1137952coldness
colonels104210452colonels
colones96124432colone_s
cookless14258632cookless
coolers93522492cool_ers
coolest9318642cool_est
coolies93824962coolie_s
coolnesses1237182coolnesses
cosiness103214282cosiness
coxless1637742coxl_ess
coyness1277322c_oyness
coziness19319822coziness
foulness11236652foulness
goodness1036252goodness
moonless10278042moonless
mootness1036752mootness
poorness1036352poorness
toolless836342toolless
wooliness12147692wooliness
aloofness1242493aloofness
boldness1136973boldness
boloneys1334503boloneys
boniness102211803boniness
bootless103410983bootless
booziness20135613booziness
bowless123310313bowl_ess
boxiness17247813boxiness
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
canoness1039393canoness
capless114312763capl_ess
carless95118493carl_ess
chicness1535593chicness
chillness1455373chillness
chinless1337493chinless
cholents1337623cholents
cholers124215193chol_ers
cholines132214483choline_s
civilness1444223civilness
cloners94514823clo_ners
clones84526563clo_ne_s
closeness1137613closeness
coalers94419333coal_ers
coaliest10316223coaliest
coatless1039693coatless
cobles104622883cobl_e_s
cockiness17248783cockiness
cockneys1934493cockneys
codeless112010113codeless
coholders1535613coholders
cohostess1443433cohostess
cohunes1249713cohune_s
coignes103912153coigne_s
coilers93619903coil_ers
coiners93620753c_oiners
cojones163512103cojone_s
coldest102514753c_oldest
coles76055063c_ol_e_s
coleus86818273c_ol_eus
colies84837053c_olie_s
colleens1036843colleens
collets93517903c_ollets
colliers103613583colliers
collies94326583collie_s
collinses1138283collinses
colognes11310603cologne_s
colone85425003colone__
colonel94213283colone_l
colonics123711613colonics
colonies103620013colonies
colonise102514283colonise
colonises112814013colonises
colonist102617923colonist
colonists112512503colonists
colons86028683colon__s
colonus94413443colon_us
coloreds1138093coloreds
colorers10312183colorers
colorless1145683colorless
colters93522433c_olters
comeliness1446993comeliness
comfiness1646953comfiness
commonness1644363commonness
compress1439053compress
cones76457423c_o_ne_s
coneys115218423c_o_neys
confess12399903c_onfess
congress1138073congress
conines93827793conine_s
conners94023113c_onners
cooches143515833cooche_s
cooees85621893coo__ees
cooers84324563coo__ers
cooeys114914483coo__eys
cookers134619463coo_kers
cookeys16478503coo_keys
cookies133719273cookie_s
coolants1039943coolants
cooled95224583cool_e_d
cooler84824713cool_e_r
coolie83821603coolie__
coolish12312523cool_ish
cools75632633cool___s
coolths1236013cool_ths
coombes133810663coombe_s
coons76737283coo_n__s
coopers114019483coo_pers
cooters94525713coo_ters
cooties93725733cootie_s
cordless11299963cordless
coreless103013833coreless
corkiness152810443corkiness
corneas94716993c_orneas
cornels94716663c_ornels
corners94723313c_orners
cornets94820573c_ornets
corniness112611183corniness
coronels104012143coronels
coroners104016223coroners
coronets103814363coronets
cosines94122673cosine_s
costless10310003costless
costliness1245983costliness
couldest1148353couldest
coulees9315503coul_ees
coulters103614303coulters
countess103710043countess
cozeners19297783cozeners
crones84729243cro_ne_s
crooners103911393crooners
cropless1237793cropless
crossness1137093crossness
crowners133710743crowners
crownets13407673crownets
crownless1443423crownless
cruelness1145053cruelness
curliness1138553curliness
curtness1037263curtness
cuteness1039673cuteness
doneness9411513doneness
doolees83711613dool_ees
doolies83920713doolie_s
doorless936713doorless
dopiness11289973dopiness
dourness947683dourness
downless1236363downless
doziness18228553doziness
drollness1043623drollness
dullness934873dullness
dulness8307983_dulness
echoless1345603echol_ess
egoless836983egol_ess
evilness1135043evilness
fellness1135913fellness
fogless1138193fogl_ess
fondness1237213fondness
foodless12338383foodless
footless113710803footless
foxiness18257403foxiness
foziness20257803foziness
fullness1135443fullness
fulness10248963_fulness
goalless935723goalless
godless938403godl_ess
godliness1136593godliness
goneness9310763goneness
gooeyness1343533gooeyness
goofiness1365603goofiness
gooneys11407073goo_neys
goriness9310753goriness
hokiness152510183hokiness
holiness112512503holiness
hominess132712453hominess
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279253hoopless
hornless1137363hornless
hotness1038603_hotness
illness736473_illness
ironness836953ironness
jobless16237563jobl_ess
jokiness19227393jokiness
jolliness1636213jolliness
jowliness1934853jowliness
joyless17226513joyl_ess
kookiness1235563kookiness
lioness739093lio_ness
localness1145223localness
loginess9310163loginess
loneness8512093loneness
longness938543longness
looneys10487013loo_neys
looniness9137573looniness
loopiness11136543loopiness
looseness937463looseness
lornness836493lornness
lostness837683lostness
loudness937013loudness
lowliness1236403lowliness
lowness1037813_lowness
moodiness12197593moodiness
mooleys1236863mool_eys
mooners94015343moo_ners
mooniness11157863mooniness
moonlets10247473moonlets
mopiness12259063mopiness
moreness10911573moreness
nobleness1147513nobleness
nosiness83211393nosiness
nounless837253nounless
nowness1037033_nowness
oddness935313_oddness
oiliness8311563_oiliness
oldness836403_oldness
oneness7512143_oneness
ooziness17237513ooziness
ovalness1134673ovalness
pokiness14219863pokiness
poolers94217423pool_ers
poshness1356643poshness
realness8410443realness
rodless8310073rodl_ess
roofless11316733roofless
roominess1157293roominess
rootiness979063rootiness
rootless83910443rootless
ropiness102311073ropiness
rosiness82613173rosiness
slowness1135013slowness
softness1136433softness
soilless8279023soilless
soleness8814263soleness
solonets838233solonets
sonless72612613sonl_ess
sooners73916643soo_ners
soonest7415593soo_nest
sootiness999833sootiness
soreness8914793soreness
soulless8218763soulless
sourness839543sourness
tallness837103tallness
toeless72612393toel_ess
toolers74416503tool_ers
topless92511123topl_ess
townless1135653townless
toyless10268713toyl_ess
vocalness1444383vocalness
voidness1235553voidness
vowless13246603vowl_ess
wellness1135793wellness
wholeness1545373wholeness
woeness1020211543_woeness
woodiness13147873woodiness
woodless12278453woodless
woolens10398843wool_ens
woolers104214023wool_ers
woolies104117363woolie_s
wooliest113011643wooliest
woollens1144093woollens
woolliness1343563woolliness
wooziness21125213wooziness
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.203880251.2
2DLD Change Limit1461622677.48319532.5
3Display Results2672670.1102427.3
 (SQL Overall)1786912677.79622920.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.