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

191 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
lovelies113989(None) 
lovelier1136431lovelier
loveliest1246971loveliest
dovekies16115002dovekies
livelier1136872livelier
liveliest1247092liveliest
liveries11314372liveries
lobelias1047202lobelias
lobelines1138562lobelines
lollies73116922lo_llies
lonelier838002lonelier
loneliest949442loneliest
loveless1168572loveless
lovelily1444332lovelily
loveliness1345302loveliness
lovevines1544002lovevines
novelise1137952novelise
novelises1247372novelises
novelizes2146222novelizes
novelties1245982novelties
overlies112417042_overlies
belies84631053__belies
blowflies1742893blowflies
botflies1336733botflies
boweries13312293boweries
cicelies1269753cicelies
colies84837053co__lies
collies94326583co_llies
comedies13311843comedies
comelier12310653comelier
comeliest13410033comeliest
complies14314523complies
coolies93824963co_olies
coteries10422703coteries
covaries13413253covaries
covellines1545303covellines
covellites1554713covellites
coverlids1544753coverlids
doilies84017363do_ilies
dollies83620983do_llies
doolies83920713do_olies
dovekie15134313dovekie_
dovelike16157133dovelike
doweries12411933doweries
doylies114512573do_ylies
follies103618943fo_llies
foveoles1496643foveoles
glowflies1642893glowflies
goalies8316023go_alies
googlies1086763googlies
holies94630033ho__lies
hollies103420813ho_llies
homelier1338983homelier
homeliest1448553homeliest
homilies132710113homilies
hotelier1137633hotelier
hoteliers1245803hoteliers
hourlies1138343hourlies
hoveled14209293hovel_ed
hoveling15189593hoveling
hovelled15146843hovelled
hovels125413333hovel__s
hoverflies1943113hoverflies
javelins18277733javelins
jollies143516273jo_llies
lavalier1146043lavalier
lavaliers1254283lavaliers
levees93714523leve__es
leveled114010383level_ed
leveler10399903level_er
levelers11259323levelers
leveling122910433leveling
levelled12327453levelled
leveller11317603leveller
levellers12286053levellers
levelness1245453levelness
levels94113283level__s
levies93919863l__evies
levities11310713levities
levulins1144803levulins
libelees10227213libelees
lifelines12147053lifelines
likelier1235283likelier
likeliest1346123likeliest
lilies63021413l__ilies
livelily1444103livelily
liveliness1345633liveliness
liveried1238733liveried
lobbies113612463lo_bbies
lobefins1344823lobefins
lobelia947213lobeli_a
lobeline1039963lobeline
lobules92510813lobul_es
locales93715093local_es
localise101511853localise
localises111411463localises
localites111210433localites
localizes201510543localizes
locules92812603locul_es
loesses7310033lo_esses
lomeins969483lome_ins
lonelily1144973lonelily
loneliness1046083loneliness
longies82916553lo_ngies
longlines1047983longlines
loobies93814103lo_obies
looies65025833lo__oies
loonies73919543lo_onies
lordlier935363lordlier
lordliest1036103lordliest
lories64933043lo__ries
lorries74518353lo_rries
losels64714583losel__s
lotteries9311073lotteries
loudlier934953loudlier
loudliest1035773loudliest
louies64525103lo__uies
lovages1138033lov_ages
lovebird1442643lovebird
lovebirds1542263lovebirds
lovebugs1441873lovebugs
lovefest1444893love_fest
lovelock1743253lovelock
lovelocks1842873lovelocks
lovelorn1144353lovelorn
lovely12339713lovel__y
lovers94223433love__rs
loves85332013lov___es
lovesick1742853lovesick
lovevine1444113lovevine
lowlier10338903lo_wlier
lowliest11229473lo_wliest
lowlifes1434333lo_wlifes
lowlives1434573lo_wlives
loyalties1244483loyalties
lozenges1843053lozenges
moieties10311263moieties
molies84429513mo__lies
mollies93420233mo_llies
moperies12313873moperies
morelles10710493morelles
moveless1367753moveless
movies115118453mov__ies
nouvelles1244453nouvelles
novelised1344983novelised
novelist1149453novelist
novelists1245933novelists
novelize2046843novelize
novelized2245313novelized
novelizer2144703novelizer
novelizers2243773novelizers
novellas1176343novellas
novelle1058233novelle_
novels95512503novel__s
obelias9279033_obelias
obelise9310173_obelise
obelises1039103_obelises
obelizes1937513_obelizes
oogenies9311583oogenies
outlies72421993_outlies
ovaries10312653_ovaries
overflies1539103_overflies
overlie102615013_overlie_
overlives152210143_overlives
overplies14310463_overplies
ovules938223_ovul_es
poesies93217403po_esies
polies84034583po__lies
poperies12316793poperies
poverties1439513poverties
ravelins113011603ravelins
relies65036423__relies
revelries1246923revelries
reveries112518513reveries
roperies10315763roperies
roselles8310713roselles
roseries8317313roseries
slaveries1249693slaveries
slovenlier1351643slovenlier
slovenliest1452003slovenliest
steelies8312553steelies
unlovelier1352153unlovelier
unloveliest1452843unloveliest
vegies104314273__vegies
velites103417303__velites
voleries11313233voleries
vowelizes2443933vowelizes
wheelies1437863wheelies
wobblies15297233wobblies
woolies104117363wo_olies
woollies1147413woollies

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 Limit1461621917.32619951.1
3Display Results1911910.0802387.5
 (SQL Overall)1786911917.82922824.2
 
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.