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

180 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
lumpiness133648(None) 
bumpiness1535281bumpiness
dumpiness1435651dumpiness
humpiness1635771humpiness
jumpiness2034291jumpiness
campiness1537542campiness
clumsiness1444332clumsiness
grumpiness1543272grumpiness
gumminess1454972gumminess
liminess10510642lim_iness
limpidness1543082limpidness
limpness1246702limp_ness
lippiness1335412lippiness
loopiness11136542loopiness
luckiness1596572luckiness
lumpiest1239252lumpi_est
lumpinesses15107112lumpinesses
lumpishness1843152lumpishness
lupines93912502lu_pine_s
lustiness92010452lustiness
plumpness1543472plump_ness
pulpiness1335602pulpiness
wimpiness1635292wimpiness
yumminess1653642yumminess
alumines10411683alum_ine_s
blurriness1243483blurriness
bugginess1395123bugginess
bulginess1245633bulginess
bulkiness1555933bulkiness
bumpiest1437873bumpi_est
bumpinesses17126373bumpinesses
burliness1137833burliness
bushiness14177763bushiness
business102110693bu_siness
bustiness111810473bustiness
chumminess1943113chumminess
clamminess1643613clamminess
clubbiness1642993clubbiness
clumpiest1535343clumpi_est
comfiness1646953comfiness
crumminess1643693crumminess
curliness1138553curliness
cushiness14197183cushiness
dampness1336073damp_ness
dippiness1435973dippiness
dopiness11289973_dopiness
dumbness1334613dum_bness
dumpiest1338743dumpi_est
dumpinesses16126253dumpinesses
dumpings14295763dumpin_gs
duskiness14216683duskiness
dustiness102211033dustiness
emptiness1335373_emptiness
flimsiness1543453flimsiness
floppiness1742863floppiness
fluffiness1542603fluffiness
flukiness1635453flu_kiness
funkiness16226873funkiness
funniness12256533funniness
furriness12287603furriness
fussiness12226583fussiness
fustiness121910243fustiness
fuzziness2033173fuzziness
gaminess112911063gam_iness
gemminess1464643gemminess
gluiness937363glu__iness
glumness1135203glum__ness
glumpiest1434943glumpi_est
grapiness1238253grapiness
gumlines11238573gumline_s
gushiness13206853gushiness
gustiness10189893gustiness
gutsiness10226963gutsiness
hamminess1635713hamminess
happiness1635993happiness
hippiness1635463hippiness
hominess132712453hom_iness
huffiness1844283huffiness
humanness1443793humanness
humidness1544023humidness
humpiest1538963humpi_est
humpinesses18106243humpinesses
humpless15226333hump_less
huskiness16206583huskiness
juiciness1835153juiciness
jumpiest1936863jumpi_est
jumpinesses22125343jumpinesses
klutziness2342273klutziness
laciness102112553l_aciness
lameness102612673lam_eness
lankiness1338053lankiness
larkiness1338113larkiness
laziness17239983l_aziness
leafiness1236483leafiness
leakiness1337503leakiness
leeriness938323leeriness
legginess1135033legginess
loaminess1137493loaminess
loftiness1236573loftiness
loginess9310163l_oginess
looniness9137573looniness
lousiness9219033lousiness
lowliness1236403lowliness
lucidness1244313lucidness
luminesce1343483lum_inesce
luminesces1443963lum_inesces
luminism1247353lum_inism
luminisms1346543lum_inisms
luminist10410563lum_inist
luminists1147173lum_inists
luminous1037113lum_inous
lumpens11298263lump__ens
lumpers113514483lump__ers
lumpier113410143lumpi_e_r
lumping123314643lumpin__g
lumpingly1784663lumpingly
lumpish14127383lumpi__sh
lupine84013533lu_pine__
lupins84514463lu_pin__s
luridness1045193luridness
lushness1136233lu_shness
mopiness12259063_mopiness
muddiness1334763muddiness
mugginess1354633mugginess
murkiness15206293murkiness
mushiness14248223mushiness
muskiness15237443muskiness
mussiness11238303mussiness
mustiness112211663mustiness
muzziness1933143muzziness
nappiness1335233nappiness
nippiness1334713nippiness
nubbiness1334173nubbiness
numbness1234413num_bness
nuttiness9207563nuttiness
peppiness1235183peppiness
pipiness1238003_pipiness
pluckiness1883823pluckiness
plumbness1543133plum_bness
plushiness1544093plushiness
pudginess1374733pudginess
puffiness1764363puffiness
pugginess1384963pugginess
pumpless14236373pump_less
puniness101610273pu_niness
punkiness15226983punkiness
pursiness1138453pursiness
pushiness14197283pushiness
quakiness2236073quakiness
raspiness1137303raspiness
riminess10510093rim_iness
ropiness102311073_ropiness
ruddiness1135123ruddiness
rumpless12256543rump_less
runniness9247103runniness
runtiness92410393runtiness
rustiness92111933rustiness
ruttiness9258793ruttiness
sappiness1337433sappiness
skimpiness1842863skimpiness
sleepiness1245133sleepiness
sliminess1137423slim_iness
sloppiness1443743sloppiness
slushiness1344643slushiness
soapiness1138293soapiness
soppiness1336543soppiness
sulkiness1347353sulkiness
sunniness9247943sunniness
supines94216383su_pine_s
surliness939943surliness
swampiness1773353swampiness
tubbiness1334423tubbiness
tumidness1243843tumidness
tumplines1346023tumpline_s
ugliness936863_ugliness
umpires1137813_umpire_s
waspiness1435793waspiness
weepiness14215963weepiness
wispiness1435633wispiness
yuckiness1874923yuckiness

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411806.86021667.8
3Display Results1801800.0931935.5
 (SQL Overall)1786911807.39324170.3
 
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.