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

283 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
loveless116857(None) 
moveless1367751moveless
boneless10310212boneless
codeless112010112codeless
coreless103013832coreless
coverless1436802coverless
groveless13235362groveless
hiveless14227932hiveless
holeless1189362holeless
homeless131110132homeless
hopeless13118302hopeless
laceless10239852laceless
levelers11259322levelers
levelness1245452levelness
lifeless11228142lifeless
limeless10249662limeless
lineless82711942lineless
liveness112411392liveness
loamless10235212loamless
loftless1135902loftless
loneness8512092loneness
lordless9277482lordless
lossless835472lossless
lovefest1444892lovefest
lovefests1541942lovefests
lovelessly1683172lovelessly
lovelies1139892lovelies
loveliest1246972loveliest
loveliness1345302loveliness
noseless839512noseless
noteless839402noteless
poleless1089872poleless
popeless1288472popeless
soleless8910032soleless
toeless72612392to_eless
toneless8610392toneless
voteless1137492voteless
waveless1437482waveless
yokeless1535302yokeless
zoneless1737822zoneless
ageless8310343_ageless
aliveness1238223aliveness
aloneness957313aloneness
aweless1038723_aweless
baseless1099563baseless
bevelers13389453bevelers
bladeless1234303bladeless
blameless1334733blameless
bloodless1234513bloodless
bloomless1342963bloomless
blotless10347153blo_tless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boonless10328353boonless
bootless103410983bootless
bowelless1443833bowelless
bowless123310313bo_wless
careless102813633careless
closeness1137613closeness
cloudless1243153cloudless
clueless1035883clueless
coalless1038193coalless
coatless1039693coatless
cookless14258633cookless
cordless11299963cordless
costless10310003costless
coverers132712123coverers
coverlets1437053coverlets
coveters132411083coveters
coxless1637743co_xless
cureless10319703cureless
dateless9259963dateless
doneness9411513doneness
doorless936713doorless
dovekeys1941723dovekeys
dowerless1344013dowerless
downless1236363downless
edgeless1034883edgeless
eyeless1058053_eyeless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
feeless103511103_feeless
fireless112810593fireless
flameless1435353flameless
flockless1843163flockless
floorless1243793floorless
flourless1243533flourless
flowerless1642883flowerless
foamless13195843foamless
fogless1138193fo_gless
foodless12338383foodless
footless113710803footless
forceless1435723forceless
fordless12289003fordless
forelegs1236613forelegs
forkless15267433forkless
formless13248083formless
foveoles1496643foveole_s
foveolets15103233foveolets
fumeless13236603fumeless
fuseless11237233fuseless
gateless9279953gateless
glebeless1242953glebeless
goalless935723goalless
godless938403go_dless
goneness9310763goneness
gormless11235443gormless
governess1346173governess
graveless13226693graveless
grovelers13305163grovelers
hideless12278713hideless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hornless1137363hornless
horseless1237213horseless
houseless1237463houseless
hoveled14209293hovele_d
hovels125413333hovel__s
hoverers14289023hoverers
hueless1058823_hueless
iceless9219963_iceless
ireless72312243_ireless
isleless834853isleless
jobless16237563jo_bless
joyless17226513jo_yless
labelers10249413labelers
lameness102612673lameness
landless94011173landless
lateness82614073lateness
laveers10329363lave_ers
lawless1037033l_awless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
legless838013l_egless
lensless835583lensless
levees93714523leve_e_s
leveled114010383levele_d
leveler10399903levele_r
levellers12286043levellers
levels94113283level__s
leverets11297603leverets
libelees10227213libelees
libelers10238623libelers
lidless8309273l_idless
likeness12229863likeness
limbless12246313limbless
linerless936333linerless
lintless82710013lintless
lipless9259553l_ipless
listless8269263listless
liteness82213213liteness
liveliest1247093liveliest
liveliness1345633liveliness
liveners11217933liveners
lobelias1047203lobelias
lobules92510813lobule_s
locales93715093locale_s
localness1145233localness
locules92812603locule_s
loess55714703lo___ess
loesses7310033lo_esses
logicless1242523logicless
loginess9310163loginess
lollers72713793lo_llers
loneliest949443loneliest
loneliness1046083loneliness
longness938553longness
looseness937473looseness
lornness836493lornness
losels64714583losel__s
lostness837683lostness
loudness937013loudness
lovages1138033lovage_s
lovebugs1441873lovebugs
lovelier1136433lovelier
lovelily1444333lovelily
lovelock1743253lovelock
lovelocks1842873lovelocks
lovelorn1144353lovelorn
lovely12339713lovel__y
lovers94223433lov__ers
loves85332013lov__e_s
loveseat1145783loveseat
loveseats1253213loveseats
lowness1037813lo_wness
loyalest11146723loyalest
luckless14265893luckless
maneless102812343maneless
mateless102711293mateless
modelers1138463modelers
moneyless1444653moneyless
moonless10278043moonless
moreness10911573moreness
motiveless1542963motiveless
movelessly1883103movelessly
nameless10248373nameless
nerveless1243933nerveless
noiseless945553noiseless
normless10235923normless
nounless837253nounless
novelise1137953novelise
novelises1247373novelises
novelist1149453novelist
novelists1245933novelists
novellas1176343novellas
novels95512503novel__s
oarless73913373_oarless
omelets938333_omelets
oneness7512143_oneness
orbless937493_orbless
ovalness1134673_ovalness
overlets112312363_overlets
ovules938223_ovule_s
paneless102611763paneless
pileless1088623pileless
pipeless12107663pipeless
placeless1335613placeless
plotless10256793plo_tless
poetess938933po_etess
poetless1038723poetless
portless10310643portless
powerless1444293powerless
ravelers113310863ravelers
revelers113414133revelers
riverless1244943riverless
roadless937703roadless
rockless14297293rockless
rodless8310073ro_dless
roofless11316733roofless
rootless83910443rootless
ruleless836633ruleless
scoreless1155603scoreless
shoeless1137803shoeless
shoreless1236633shoreless
shovelers15174943shovelers
sleeveless1341973sleeveless
smokeless1543553smokeless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soilless8279033soilless
soleness8814263soleness
songless9218823songless
sonless72612613so_nless
soreness8914793soreness
soulless8218763soulless
soupless10268463soupless
tameless10259903tameless
tapeless10218643tapeless
tideless9269083tideless
tieless72512563_tieless
timeless10239543timeless
tireless82510263tireless
toadless936313toadless
tombless1236783tombless
toolless836343toolless
topless92511123to_pless
townless1135653townless
toyless10268713to_yless
treeless839283treeless
tubeless1037023tubeless
tuneless837913tuneless
useless7188423_useless
valveless1543163valveless
viceless1337983viceless
voiceless1444223voiceless
vowless13246603vo_wless
wageless1237173wageless
wakeless1536473wakeless
wavelets1436153wavelets
wifeless14277483wifeless
wineless112711173wineless
wireless11249633wireless
woeness1020211543wo_eness
woodless12278453woodless
wordless12258843wordless
workless15276803workless
yodelers1235673yodelers

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622837.32619951.1
3Display Results2832830.1262246.0
 (SQL Overall)1786912837.87522690.9
 
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.