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

170 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
loopiness1113654(None) 
looniness9137571looniness
bloodiness1344352bloodiness
booziness20135612booziness
dopiness11289972_dopiness
floppiness1742872floppiness
gloominess1343832gloominess
goofiness1365602goofiness
kookiness1235562kookiness
lippiness1335412lippiness
loaminess1137492loaminess
loftiness1236572loftiness
loginess9310162l_oginess
loopiest103011322loopi_est
loopinesses13116732loopinesses
looseness937482looseness
lousiness9219042lousiness
lowliness1236402lowliness
lumpiness1336482lumpiness
moodiness12197592moodiness
mooniness11157862mooniness
mopiness12259062_mopiness
ooziness17237512_ooziness
roominess1157302roominess
rootiness979062rootiness
ropiness102311072_ropiness
sloppiness1443752sloppiness
soapiness1138292soapiness
sootiness999832sootiness
soppiness1336542soppiness
woodiness13147872woodiness
wooliness12147692wooliness
wooziness21125212wooziness
aloofness1242493aloo_fness
blowiness1435623blowiness
bogginess1335603bogginess
boniness102211803_boniness
bonniness1136733bonniness
boskiness15196513boskiness
bossiness11257423bossiness
boxiness17247813_boxiness
broodiness1344653broodiness
bumpiness1535283bumpiness
campiness1537543campiness
chopines152711733chopine_s
choppiness1973563choppiness
cloudiness1344113cloudiness
cockiness17248783cockiness
comfiness1646953comfiness
coolness1037743coo_lness
corkiness152810443corkiness
corniness112611183corniness
cosiness103214283_cosiness
coziness19319823_coziness
dippiness1435973dippiness
dodginess1235283dodginess
dorkiness14248053dorkiness
dottiness1058043dottiness
dowdiness1485693dowdiness
downiness13106713downiness
doziness18228553_doziness
dumpiness1435653dumpiness
foaminess1437503foaminess
fogginess1434973fogginess
forkiness16268703forkiness
foxiness18257403_foxiness
foziness20257803_foziness
glossiness11284993glossiness
godliness1136593godliness
goodness1036253goo_dness
gooeyness1343543gooeyness
goopiest112710553goopi_est
goriness9310753_goriness
goutiness1038773goutiness
grapiness1238263grapiness
happiness1636003happiness
hippiness1635463hippiness
hoariness1238823hoariness
hokiness152510183_hokiness
holiness112512503_holiness
hominess132712463_hominess
hoopless13279263hoop_less
horniness12309143horniness
horsiness12259483horsiness
humpiness1635773humpiness
jokiness19227393_jokiness
jolliness1636213jolliness
jowliness1934853jowliness
jumpiness2034293jumpiness
laciness102112553l_aciness
lankiness1338053lankiness
larkiness1338123larkiness
laziness17239983l_aziness
leafiness1236483leafiness
leakiness1337503leakiness
leeriness938323leeriness
legginess1135033legginess
liminess10510643l_iminess
limpidness1543083limpidness
limpness1246703limp_ness
lioness739103lio__ness
loathness1244703loathness
localness1145233localness
loneliness1046083loneliness
loneness8512093l_oneness
longness938553l_ongness
loobies93814103loobi_e_s
looies65025833loo_i_e_s
looneys10487013loo__neys
loonies73919543looni_e_s
looniest83313253looni_est
looninesses1197993looninesses
loopers93914033loop__ers
loopier93711193loopi_e_r
looping103615283loopin__g
looseners945413looseners
loppiest122410113loppi_est
lordliness1144883lordliness
loriners839963l_oriners
lornness836493l_ornness
lostness837683l_ostness
loudness937013l_oudness
loveliness1345303loveliness
lowness1037813l_o_wness
luckiness1596573luckiness
lupines93912503l_upine_s
lustiness92010453lustiness
moldiness12227053moldiness
mootness1036753moo_tness
mossiness11258323mossiness
mousiness11219033mousiness
nappiness1335233nappiness
nippiness1334713nippiness
noisiness948353noisiness
nosiness83211393_nosiness
oiliness8311563_oiliness
opines84820703__opine_s
orpines94414793_orpine_s
peppiness1235183peppiness
phoniness1436303phoniness
pipiness1238003_pipiness
pokiness14219863_pokiness
poorness1036363poo_rness
porkiness15249203porkiness
pottiness1179703pottiness
propines122618933propine_s
prosiness11311693prosiness
pulpiness1335603pulpiness
raspiness1137303raspiness
rockiness15237833rockiness
rosiness82613183_rosiness
rowdiness1396233rowdiness
sappiness1337443sappiness
showiness1576073showiness
sleepiness1245133sleepiness
smokiness1535543smokiness
snootiness1085833snootiness
snowiness1296243snowiness
sogginess1136183sogginess
sorriness939583sorriness
spookiness1644433spookiness
stoniness938343stoniness
tropines102214923tropine_s
waspiness1435793waspiness
weepiness14215963weepiness
wimpiness1635293wimpiness
wispiness1435633wispiness
woolliness1343563woolliness
wordiness13138633wordiness
worminess14127613worminess

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.436409841.7
2DLD Change Limit1486411706.75022020.9
3Display Results1701700.0802125.0
 (SQL Overall)1786911707.26624592.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.