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

387 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
holiness11251250(None) 
hokiness152510181hokiness
hominess132712451hominess
boldness1136972boldness
boniness102211802boniness
boxiness17247812boxiness
cholines132214492choline_s
coldness1137952coldness
cosiness103214282cosiness
coziness19319822coziness
dopiness11289972dopiness
doziness18228552doziness
foxiness18257402foxiness
foziness20257802foziness
godliness1136592godliness
goriness9310752goriness
haleness11312622haleness
halfness1435562halfness
haziness20248512haziness
hilliness1248922hilliness
hoariness1238822hoariness
holeless1189362holeless
holies94630032holi_e_s
holiest104319622holi_est
holinesses13511492holinesses
homeliness1545762homeliness
homines123518642homine_s
horniness12309142horniness
horsiness12259472horsiness
hotlines11811642hotline_s
hotness1038612ho_tness
jokiness19227392jokiness
jolliness1636212jolliness
jowliness1934852jowliness
loginess9310162loginess
lowliness1236402lowliness
moldiness12227052moldiness
mopiness12259062mopiness
nosiness83211392nosiness
oiliness8311562oiliness
oldness836402_oldness
ooziness17237512ooziness
phoniness1436302phoniness
pokiness14219862pokiness
ropiness102311072ropiness
rosiness82613172rosiness
showiness1576072showiness
soleness8814262soleness
solidness1036902solidness
ugliness936862ugliness
unholiness1344982unholiness
wholeness1545372wholeness
wiliness1139112wiliness
wooliness12147692wooliness
achiness1339703achiness
airiness8412213airiness
aliners74717723_aliners
alines65735223_aline_s
artiness81615403artiness
ashiness1138963ashiness
baldness1137043baldness
balkiness1556903balkiness
balminess1356593balminess
blowiness1435623blowiness
bodiless1135913bodiless
bogginess1335603bogginess
bolides10515073bolide_s
boloneys1334503boloneys
boltless10338283boltless
bonniness1136733bonniness
booziness20135613booziness
boskiness15196513boskiness
bossiness11257423bossiness
bovines12412663bovine_s
bowlines133211623bowline_s
bulginess1245633bulginess
bulkiness1555933bulkiness
burliness1137833burliness
business102110693business
byliners1334753byliners
bylines1239243byline_s
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
chariness14310063chariness
chewiness1744823chewiness
chilliness1555313chilliness
chillness1455373chillness
choline122915383choline__
chopines152711733chopine_s
choppiness1973563choppiness
chorines132917253chorine_s
clines84926043_cline_s
cockiness17248783cockiness
coiners93620753co_iners
colies84837053coli_e_s
colinear1045913colinear
colins85229043colin__s
collinses1138283collinses
colonels104210453colonels
colones96124433colone_s
comeliness1446993comeliness
comfiness1646953comfiness
conines93827793conine_s
coolness1037743coolness
corkiness152810443corkiness
corniness112611183corniness
cosines94122673cosine_s
costliness1245993costliness
coyness1277323co_yness
curliness1138553curliness
dailiness1038673dailiness
dewiness1238453dewiness
dodginess1235283dodginess
domines102918973domine_s
doneness9411513doneness
dorkiness14248053dorkiness
dottiness1058043dottiness
dourness947683dourness
dowdiness1485693dowdiness
downiness13106713downiness
drollness1043623drollness
dullness934873dullness
dulness8307983dul_ness
earliness939693earliness
easiness8313043easiness
edginess1036053edginess
eeriness8311873eeriness
eloiners8128153eloiners
eosines73718293eosine_s
evilness1135043evilness
felines104718073feline_s
fellness1135913fellness
filminess1435983filminess
foaminess1437503foaminess
fogginess1434973fogginess
folksiness1743573folksiness
fondness1237213fondness
forkiness16268703forkiness
foulness11236653foulness
fullness1135443fullness
fulness10248963ful_ness
gaminess112911063gaminess
gelidness1144473gelidness
ghostliness1542563ghostliness
glibness1134133_glibness
gluiness937363gluiness
goneness9310763goneness
goodness1036253goodness
goofiness1365603goofiness
goutiness1038763goutiness
growliness1494073growliness
hairiness1238013hairiness
halides113416663halide_s
halites103221193halite_s
haltless11308443haltless
hamminess1635713hamminess
handiness132110933handiness
happiness1636003happiness
hardiness132310363hardiness
hardness122411083hardness
harness102413933h_arness
hastiness122410883hastiness
headiness132510363headiness
heaviness15207063heaviness
heftiness1536313heftiness
heiress1036813h_eiress
helices12313723helice_s
helixes1739133helixe_s
helmless1334273helmless
helpless1335063helpless
hemlines13310623hemline_s
highness1536053highness
hiltless11297123hiltless
hiplines13310593hipline_s
hipness12277383h_ipness
hippiness1635463hippiness
hoidens11329083ho_idens
hoises94823673ho_ise_s
hokeyness1943803hokeyness
hokiest144114243hoki_est
hokinesses1758943hokinesses
holders113715903hol_ders
holdings13297743holdin_gs
holes84748653hol__e_s
holibuts1363953holibuts
holidays1544103holidays
holier94921623holi_e_r
holing104025073holin__g
holism113713753holi__sm
holisms123811113holi_sms
holist94723213holi__st
holists104413963holi_sts
hollers103818233hol_lers
hollies103420813hollie_s
holloes103818193holloe_s
hollowness1642543hollowness
holsters113211943holsters
homeless131110133homeless
homeyness1745013homeyness
homies114524723homi_e_s
homiest124116633homi_est
hominesses15510863hominesses
hominids14297363hominids
hominies133012953hominies
honers94324973ho__ners
hones88144493ho__ne_s
honest94822423ho__nest
honeys124016083ho__neys
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
hoplites13310543hoplite_s
hornets104113553ho_rnets
horniest112814043horniest
hornless1137363hornless
horridness1443843horridness
hosiers104212643hosi_ers
hostess103210243ho_stess
hotline10712353hotline__
hotlinks1574193hotlin_ks
hotpress1344303hotpress
huffiness1844283huffiness
hugeness1237373hugeness
humidness1544023humidness
humpiness1635773humpiness
huskiness16206583huskiness
hyalines14169333hyaline_s
iciness938863_iciness
ickiness1436753ickiness
idleness936843idleness
iffiness1435023iffiness
illness736473_illness
inkiness1238693inkiness
iodines83616633iodine_s
iolites73819483iolite_s
isolines8312303isoline_s
joiners144211573jo_iners
kaolines1239293kaoline_s
koines10415733ko_ine_s
kookiness1235563kookiness
laciness102112553laciness
laziness17239983laziness
liminess10510643liminess
linens64818393__linens
liners65428853__liners
lines57054573__line_s
lioness739103__lioness
loaminess1137493loaminess
loftiness1236573loftiness
loneliness1046083loneliness
loneness8512093loneness
longness938553longness
looniness9137573looniness
loopiness11136543loopiness
lordliness1144883lordliness
loriners839963loriners
lornness836493lornness
lostness837683lostness
loudness937013loudness
lousiness9219033lousiness
loveliness1345303loveliness
lowness1037813lo_wness
maleness10312313maleness
malines93625603maline_s
maltiness112910573maltiness
manliness111310123manliness
matiness102114753matiness
maziness19239543maziness
mealiness11310063mealiness
mildness1136523mildness
milkiness1536523milkiness
miriness10310463miriness
molies84429513moli_e_s
moline84422033moline__
moodiness12197593moodiness
mooniness11157863mooniness
mootness1036753mootness
moreness10911573moreness
mossiness11258323mossiness
mousiness11219023mousiness
nobleness1147523nobleness
noisiness948343noisiness
nominees1037363nominees
nowness1037033no_wness
oddness935313_oddness
oleines7313393_oleine_s
olingos846013_olingos
olives94313953_olive_s
oneness7512143_oneness
oolites72817843oolite_s
opines84820703_opine_s
ovines94614343_ovine_s
paleness10312983paleness
pipiness1238003pipiness
pixiness1736093pixiness
poleless1089873poleless
policers12259993policers
polices113118053police_s
polies84034583poli_e_s
politeness1247983politeness
politesse1143673politesse
politest10312943politest
poorness1036363poorness
porkiness15249193porkiness
portliness1246833portliness
poshness1356653poshness
potlines10714213potline_s
pottiness1179703pottiness
prolines102619693proline_s
prosiness11311683prosiness
pulpiness1335603pulpiness
puniness101610273puniness
raciness102413453raciness
relines75331323reline_s
riminess10510093riminess
rockiness15237833rockiness
roominess1157303roominess
rootiness979063rootiness
rowdiness1396233rowdiness
salines74029413saline_s
saltiness93312113saltiness
saltness82610243saltness
scaliness1149303scaliness
selfness1135153selfness
sexiness1537943sexiness
shadiness1337463shadiness
shakiness1637083shakiness
shininess1237333shininess
shoddiness1543563shoddiness
shortness1236733shortness
silkiness1337253silkiness
silliness9510363silliness
siziness1737423siziness
slimness1036523_slimness
slowness1135013slowness
slyness1035263_slyness
smokiness1535543smokiness
snowiness1296243snowiness
soapiness1138293soapiness
softness1136433softness
sogginess1136183sogginess
soilless8279033soilless
soleless8910033soleless
solidest9310383solidest
solonets838233solonets
sootiness999833sootiness
soppiness1336543soppiness
soreness8914793soreness
sorriness939583sorriness
sourness839543sourness
sozines16611263sozine_s
splines94718893spline_s
stoniness938343stoniness
sulkiness1347353sulkiness
surliness939943surliness
talkiness1356913talkiness
tallness837103tallness
thorniness13264343thorniness
tidiness938793tidiness
tininess8310633tininess
tolanes74216313tolane_s
toplines102412563topline_s
towlines112610343towline_s
toxines142912263toxine_s
validness13125363validness
valines104520213valine_s
vileness1139983vileness
voidness1235553voidness
wariness11313213wariness
waviness1437723waviness
waxiness1836723waxiness
wellness1135793wellness
whininess1535123whininess
wildness1236203wildness
wiriness1138953wiriness
wobbliness1742903wobbliness
woeness1020211543wo_eness
woodiness13147873woodiness
woolliness1343563woolliness
wooziness21125213wooziness
wordiness13138633wordiness
worminess14127613worminess
wornness1136363wornness
zaniness1738663zaniness

Search took 9 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.440406115.9
2DLD Change Limit1461623877.51319454.5
3Display Results3873870.1562480.8
 (SQL Overall)1786913878.10922036.1
 
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.