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

257 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
soapiness113829(None) 
soppiness1336541soppiness
dopiness11289972do_piness
foaminess1437502foaminess
grapiness1238242grapiness
hoariness1238822hoariness
loaminess1137492loaminess
loopiness11136542loopiness
mopiness12259062mo_piness
ropiness102311072ro_piness
sappiness1337432sappiness
scaliness1149302scaliness
scariness11310182scariness
seaminess11310472seaminess
shadiness1337462shadiness
shakiness1637082shakiness
slatiness92511362slatiness
sloppiness1443742sloppiness
snakiness1367472snakiness
snappiness1443822snappiness
soapiest102412842soapi_est
soapinesses1339702soapinesses
soapless10278072soap_less
sogginess1136182sogginess
sootiness999832sootiness
sorriness939582sorriness
spaciness1337082spaciness
staginess1038752staginess
swampiness1773352swampiness
aptness9268573__aptness
beadiness12249233beadiness
bogginess1335603bogginess
boniness102211803bo_niness
bonniness1136733bonniness
booziness20135613booziness
boskiness15196513boskiness
bossiness11257423bossiness
boxiness17247813bo_xiness
bumpiness1535283bumpiness
caginess11310303_caginess
cakiness1449553_cakiness
campiness1537543campiness
chariness14310063chariness
choppiness1973563choppiness
cockiness17248783cockiness
comfiness1646953comfiness
corkiness152810443corkiness
corniness112611183corniness
cosiness103214283co_siness
coziness19319823co_ziness
craziness2037383craziness
dippiness1435973dippiness
dodginess1235283dodginess
dorkiness14248053dorkiness
dottiness1058043dottiness
dowdiness1485693dowdiness
downiness13106713downiness
doziness18228553do_ziness
dumpiness1435653dumpiness
easiness8313043_easiness
flakiness1636473flakiness
floppiness1742863floppiness
fogginess1434973fogginess
forkiness16268703forkiness
foxiness18257403fo_xiness
foziness20257803fo_ziness
gaminess112911053_gaminess
glariness1038553glariness
glaziness1935753glaziness
godliness1136593godliness
goofiness1365603goofiness
goriness9310753go_riness
goutiness1038763goutiness
happiness1635993happiness
haziness20248513_haziness
headiness132510363headiness
heaviness15207063heaviness
hippiness1635463hippiness
hokiness152510183ho_kiness
holiness112512503ho_liness
hominess132712453ho_miness
horniness12309143horniness
horsiness12259463horsiness
humpiness1635773humpiness
inaptness1144333inaptness
jokiness19227393jo_kiness
jolliness1636213jolliness
jowliness1934853jowliness
jumpiness2034293jumpiness
kookiness1235563kookiness
laciness102112553_laciness
laziness17239983_laziness
leafiness1236483leafiness
leakiness1337503leakiness
lippiness1335413lippiness
loathness1244703loathness
loftiness1236573loftiness
loginess9310163lo_giness
looniness9137573looniness
lousiness9219033lousiness
lowliness1236403lowliness
lumpiness1336483lumpiness
matiness102114743_matiness
maziness19239543_maziness
mealiness11310063mealiness
meatiness11311173meatiness
moldiness12227053moldiness
moodiness12197593moodiness
mooniness11157863mooniness
mossiness11258323mossiness
mousiness11219023mousiness
nappiness1335233nappiness
nippiness1334713nippiness
noisiness948343noisiness
nosiness83211393no_siness
oiliness8311563_oiliness
ooziness17237513_ooziness
opines84820703_o_pine_s
orpines94414793_orpine_s
peppiness1235183peppiness
pipiness1238003_pipiness
pokiness14219863po_kiness
porkiness15249193porkiness
pottiness1179693pottiness
pulpiness1335603pulpiness
quakiness2236073quakiness
raciness102413453_raciness
rapidness12155473_rapidness
rapines95120863_rapine_s
raptness1046733_raptness
raspiness1137303raspiness
readiness102611853readiness
rockiness15237833rockiness
roominess1157293roominess
rootiness979063rootiness
rosiness82613173ro_siness
rowdiness1396233rowdiness
sabines94318483s_abine_s
sadness8310613s_a_dness
safeness11239633s_afeness
sageness92111983s_ageness
salines74029413s_aline_s
saltiness93312113saltiness
saltness82610243s_altness
sameness102712683s_ameness
sandiness102111713sandiness
saneness82313723s_aneness
sapiens9310173s_api_ens
sapients1037423s_apients
sapless93313443s_ap_less
sassiness8249333sassiness
satinets8311733s_atinets
sauciness1138043sauciness
savines104417633s_avine_s
savviness1534713savviness
scantiness1236873scantiness
scantness1135733scantness
scrappiness1752283scrappiness
seediness10219173seediness
sexiness1537943s_exiness
shabbiness1743133shabbiness
shagginess1543933shagginess
shapeless1435563shapeless
shapeliness1663163shapeliness
sharpness1434933sharpness
shininess1237333shininess
shoddiness1543563shoddiness
showiness1576073showiness
silkiness1337253silkiness
silliness9510353silliness
sissiness8217963sissiness
siziness1737423s_iziness
skimpiness1842863skimpiness
slackness1535433slackness
slanginess1146273slanginess
sleaziness19104703sleaziness
sleepiness1245133sleepiness
sliminess1137423sliminess
smallness1174513smallness
smarminess1444303smarminess
smartness1136143smartness
smokiness1535543smokiness
snapless10287463snap_less
sneakiness1454873sneakiness
snootiness1085833snootiness
snottiness1055593snottiness
snowiness1296233snowiness
soapers93715923soap__ers
soapier93411713soapi_e_r
soaping103616223soapin__g
soarings93210393soarin_gs
soberness1186463soberness
softness1136433so_ftness
solanines9310073solanine_s
soleness8814263so_leness
solidness1036903solidness
sopites93817173so_pite_s
soppiest122511933soppi_est
soppinesses1566843soppinesses
sordidness1244633sordidness
sordines92414063sordine_s
soreness8914793so_reness
soundness1036963soundness
soupiest102212903soupi_est
soupless10268463soup_less
sourness839543so_urness
sozines16611263so_zine_s
spareness1139863spareness
spiciness1347053spiciness
spikiness1536313spikiness
spinels94512443s__pinels
spines85132033s__pine_s
spinets94714813s__pinets
spininess1137963spininess
spinless10238703s__pinless
sponginess1344593sponginess
spookiness1644433spookiness
sportiness1278233sportiness
spottiness1285763spottiness
staidness1037033staidness
stainers83212173sta_iners
stainless9176493sta_inless
staleness9310783staleness
stanines85115663stanine_s
starkness1335963starkness
steadiness1146703steadiness
steaminess1236773steaminess
stockiness1645243stockiness
stodginess1243893stodginess
stoniness938343stoniness
storminess1245213storminess
stupidness1343033stupidness
suaveness1247693suaveness
sulkiness1347353sulkiness
sunniness9247943sunniness
supines94216383s_upine_s
surliness939943surliness
swankiness1744253swankiness
swartness1236113swartness
sweatiness1336463sweatiness
teariness9310633teariness
unaptness1154173unaptness
vapidness15144423_vapidness
wariness11313213_wariness
waspiness1435793waspiness
waviness1437723_waviness
waxiness1836723_waxiness
weariness1238843weariness
weepiness14215963weepiness
wimpiness1635293wimpiness
wispiness1435633wispiness
woodiness13147873woodiness
wooliness12147693wooliness
wooziness21125213wooziness
wordiness13138633wordiness
worminess14127613worminess
zaniness1738663_zaniness

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 Filter1786911486410.186960704.3
2DLD Change Limit1486412578.40617682.7
3Display Results2572570.1102336.4
 (SQL Overall)1786912578.70220534.5
 
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.