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

353 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
oiliness831156(None) 
wiliness1139111wiliness
airiness8412212airiness
dailiness1038672dailiness
filminess1435982filminess
godliness1136592godliness
hilliness1248922hilliness
holiness112512502holiness
iciness938862_iciness
illness736472_illness
jolliness1636212jolliness
jowliness1934852jowliness
liminess10510642liminess
lowliness1236402lowliness
mildness1136522mildness
milkiness1536522milkiness
miriness10310462miriness
noisiness948342noisiness
oiliest72817682oili_est
oilinesses101512442oilinesses
oldness836402o_ldness
ooziness17237512ooziness
pipiness1238002pipiness
pixiness1736092pixiness
riminess10510092riminess
silkiness1337252silkiness
silliness9510362silliness
siziness1737422siziness
tidiness938792tidiness
tininess8310632tininess
ugliness936862ugliness
vileness1139982vileness
wildness1236202wildness
wiriness1138952wiriness
wooliness12147692wooliness
achiness1339703achiness
agileness1046493agileness
airliners945983airliners
airlines8312793airline_s
aliners74717723_aliners
alines65735223_aline_s
anilines8415143aniline_s
artiness81615403artiness
ashiness1138963ashiness
baldness1137043baldness
balkiness1556903balkiness
balminess1356593balminess
biasness1035813biasness
bigness1038193bi_gness
bilinear1044043bilinear
bittiness11228333bittiness
bogginess1335603bogginess
boldness1136973boldness
boniness102211803boniness
bonniness1136733bonniness
booziness20135613booziness
boskiness15196513boskiness
bossiness11257423bossiness
bowlines133211623bowline_s
boxiness17247813boxiness
brininess1138203brininess
bulginess1245633bulginess
bulkiness1555933bulkiness
burliness1137833burliness
business102110693business
byliners1334753byliners
bylines1239243byline_s
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
chilliness1555313chilliness
chillness1455373chillness
cilices113814023cilice_s
civilness1444223civilness
clines84926043_cline_s
cockiness17248783cockiness
coldness1137953coldness
collinses1138283collinses
comeliness1446993comeliness
comfiness1646953comfiness
coolness1037743cool_ness
corkiness152810443corkiness
corniness112611183corniness
cosiness103214283cosiness
costliness1245993costliness
coziness19319823coziness
curliness1138553curliness
dailyness1343643dailyness
dewiness1238453dewiness
dimness1038843di_mness
dinginess1137823dinginess
dippiness1435973dippiness
direness9311303direness
dirtiness1039473dirtiness
ditsiness1048143ditsiness
ditziness1945883ditziness
diviners12308353diviners
divines113514723divine_s
divinest123012173divinest
dizziness1834183dizziness
dodginess1235283dodginess
doilies84017363doili_e_s
dopiness11289973dopiness
dorkiness14248053dorkiness
dottiness1058043dottiness
dowdiness1485693dowdiness
downiness13106713downiness
doziness18228553doziness
dullness934873dullness
dulness8307983dul_ness
earliness939693earliness
easiness8313043easiness
edginess1036053edginess
eeriness8311873eeriness
evilness1135043evil_ness
felines104718073feline_s
fellness1135913fellness
fieriness1238623fieriness
filibegs1442223filibegs
filings115213073filin_gs
filmless1344553filmless
filthiness1643713filthiness
fineness11310643fineness
firmness1334743firmness
fishiness1537343fishiness
fitness10299393fi_tness
foaminess1437503foaminess
fogginess1434973fogginess
forkiness16268703forkiness
foulness11236653foul_ness
foxiness18257403foxiness
foziness20257803foziness
fullness1135443fullness
fulness10248963ful_ness
gaminess112911063gaminess
gelidness1144473gelidness
giddiness1234683giddiness
gillnets934733gillnets
glibness1134133glibness
gluiness937363gluiness
goofiness1365603goofiness
goriness9310753goriness
goutiness1038763goutiness
griminess1236703griminess
grisliness1155143grisliness
growliness1494073growliness
guiltiness1144193guiltiness
hairiness1238013hairiness
haleness11312623haleness
halfness1435563halfness
haziness20248513haziness
highness1536053highness
hiltless11297123hiltless
hiplines13310593hipline_s
hipness12277383hi_pness
hippiness1635463hippiness
hoariness1238823hoariness
hokiness152510183hokiness
homeliness1545763homeliness
hominess132712453hominess
horniness12309143horniness
horsiness12259473horsiness
hotlines11811643hotline_s
ickiness1436753ickiness
idleness936843idleness
iffiness1435023iffiness
imines84918353_imine_s
inkiness1238693inkiness
iodines83616633iodine_s
iolites73819483iolite_s
jokiness19227393jokiness
juiciness1835153juiciness
kindliness1544043kindliness
kindness13236653kindness
kingliness1543953kingliness
kinkiness1235763kinkiness
kookiness1235563kookiness
laciness102112553laciness
laziness17239983laziness
licitness1145373licitness
likeness12229863likeness
lilies63021413lili_e_s
limpness1246703limpness
linens64818393__linens
liners65428853__liners
lines57054573__line_s
lioness739103li_oness
lippiness1335413lippiness
liteness82213213liteness
liveliness1345633liveliness
liveness112411393liveness
lividness1344713lividness
loaminess1137493loaminess
loftiness1236573loftiness
loginess9310163loginess
loneliness1046083loneliness
looniness9137573looniness
loopiness11136543loopiness
lordliness1144883lordliness
lousiness9219033lousiness
loveliness1345303loveliness
maleness10312313maleness
malines93625603maline_s
maltiness112910573maltiness
manliness111310123manliness
matiness102114753matiness
maziness19239543maziness
mealiness11310063mealiness
midlines112613333midline_s
miffiness1734523miffiness
milieus939803mili_eus
milkless1434773milkless
milliners11289953milliners
millines102718063milline_s
milnebs11113793mil_nebs
mistiness111911633mistiness
moistness1146343moistness
moldiness12227053moldiness
moodiness12197593moodiness
mooniness11157863mooniness
mopiness12259063mopiness
mossiness11258323mossiness
mousiness11219023mousiness
niceness1039843niceness
niftiness1236363niftiness
nighness1236103nighness
nippiness1334713nippiness
nobleness1147523nobleness
nosiness83211393nosiness
obligees1143953obligees
obligers1134723obligers
obliges1037143oblige_s
oddness935313o_ddness
oilers64721193oil__ers
oilier64417233oili_e_r
oiling74925313oilin__g
oilseeds943703oilseeds
oleines7313393oleine_s
olingos846013o_lingos
olives94313953o_live_s
olivines1137473olivine_s
oneness7512143o_neness
online6315843online__
oolites72817843oolite_s
opalines10311423opaline_s
openness1035473openness
opines84820703o_pine_s
ordines83014903ordine_s
orpines94414793orpine_s
oscines9310363oscine_s
outliners9228363outliners
outlines82418093outline_s
ovalness1134673ovalness
ovines94614343o_vine_s
owlishness1644163owlishness
paleness10312983paleness
pickiness1737623pickiness
pigginess1375453pigginess
pileless1088623pileless
pilings103313613pilin_gs
pilsners1035533pilsners
pinkness1436513pinkness
pithiness1437563pithiness
pitiless10127333pitiless
pokiness14219863pokiness
porkiness15249193porkiness
portliness1246833portliness
potlines10714213potline_s
pottiness1179703pottiness
pulpiness1335603pulpiness
puniness101610273puniness
raciness102413453raciness
raininess949273raininess
relines75331323reline_s
richness1337433richness
rifeness1138583rifeness
rigidness1145123rigidness
ripeness1039363ripeness
riskiness1336963riskiness
ritziness1835823ritziness
rockiness15237833rockiness
roiliest8312283roili_est
roominess1157303roominess
rootiness979063rootiness
ropiness102311073ropiness
rosiness82613173rosiness
rowdiness1396233rowdiness
salines74029413saline_s
saltiness93312113saltiness
saltness82610243saltness
scaliness1149303scaliness
selfness1135153selfness
sexiness1537943sexiness
shininess1237333shininess
sickliness1645003sickliness
sickness1437833sickness
silanes72517163silane_s
sissiness8217963sissiness
sliminess1137423sliminess
slimness1036523slimness
slyness1035263_slyness
soapiness1138293soapiness
sogginess1136183sogginess
soilless8279033soil_less
soleness8814263soleness
solidness1036903solidness
sootiness999833sootiness
soppiness1336543soppiness
sorriness939583sorriness
spiciness1347053spiciness
spikiness1536313spikiness
spininess1137963spininess
splines94718893spline_s
stillness936103stillness
sulkiness1347353sulkiness
surliness939943surliness
talkiness1356913talkiness
tallness837103tallness
tilings84212793tilin_gs
timeliness1245303timeliness
timidness1244623timidness
tinniness936093tinniness
tipsiness1135703tipsiness
titaness836723titaness
toplines102412563topline_s
towlines112610343towline_s
validness13125363validness
valines104520213valine_s
villainess1343853villainess
vividness1643933vividness
voidness1235553voi_dness
wariness11313213wariness
waviness1437723waviness
waxiness1836723waxiness
wellness1135793wellness
whininess1535123whininess
wideness12259473wideness
wifeliness1644483wifeliness
wiliest103416593wili_est
wilinesses131911093wilinesses
wimpiness1635293wimpiness
windiness1337373windiness
wiseness112010753wiseness
wispiness1435633wispiness
witness103010013wi_tness
wittiness12197223wittiness
wobbliness1742903wobbliness
woodiness13147873woodiness
woolliness1343563woolliness
wooziness21125213wooziness
wordiness13138633wordiness
worminess14127613worminess
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.436409841.7
2DLD Change Limit1461623537.54619369.5
3Display Results3533530.1562262.8
 (SQL Overall)1786913538.13821957.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.