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

185 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
lowlily133535(None) 
blowsily1643952blowsily
blowzily2542732blowzily
dowdily1534952dowdily
godlily1235342godlily
holily123612952ho_lily
jollily1745772jollily
loftily1336352loftily
logily1039832lo_gily
lolly85120662lo_l_ly
lonelily1144972lonelily
loonily1037072loonily
loopily1236802loopily
lousily1038332lousily
lovelily1444332lovelily
lowlier10338902lowlier
lowlife1335142lowlife
lowly114113332low__ly
oilily93111722_oilily
rowdily1436082rowdily
bawdily1635803bawdily
bloodily1445183bloodily
blousily1345193blousily
blowfly1843243blow_fly
bodily12310993bo_dily
boldly12399423bo_ldly
bonnily1236873bonnily
boozily2135623boozily
bossily1237563bossily
bowlike16349473bowlike
bowline123613113bowline
bowling133916493bowling
boxily1877843bo_xily
burlily1237713burlily
cloggily1543243cloggily
cloudily1444283cloudily
coalify1536683coalify
cockily1838493cockily
coldly12459953co_ldly
colly104926773co_l_ly
comelily1546693comelily
coolly114811393cool_ly
cornily12410853cornily
cosily113613853co_sily
cowedly1635703cowedly
cowlick1835263cowlick
cowling134017423cowling
cozily20349703co_zily
curlily1238383curlily
daylily1434983daylily
dewily1338343dew_ily
doily95321033do__ily
dolly96125203do_l_ly
doomily1336133doomily
dopily123510463do_pily
dottily1147283dottily
dozily19329103do_zily
drowsily1583723drowsily
floppily1843773floppily
flossily1434523flossily
flowerily1842993flowerily
foamily1546543foamily
foggily1535053foggily
folly115022603fo_l_ly
foully1239013foul_ly
fowling143713113fowling
foxily1947253fo_xily
frowzily2642673frowzily
gawkily1834093gawkily
gloomily1443753gloomily
glossily1235093glossily
glowfly1742673glow_fly
golly95121103go_l_ly
goofily14105353goofily
gorily10612503go_rily
goutily1137933goutily
hoarily1338973hoarily
hokily16409093ho_kily
holly114824433ho_l_ly
homily144712333ho_mily
hornily1338283hornily
horsily1338843horsily
howling143413163howling
howlingly1944193howlingly
jokily20306533jo_kily
jollify2044263jollify
jollity1746143jollity
jolly154517513jo_l_ly
joltily1746323joltily
jowlier17327563jowlier
jowly186410903jow__ly
lacily11612763l_acily
lankily1437123lankily
lawlike14137073lawlike
lazily1859713l_azily
leakily1436473leakily
leally94012613leal_ly
leerily1037633leerily
lewdly1334403lew_dly
lily76730183___lily
livelily1444103livelily
loathly1334713loathly
loblolly1342053loblolly
locality13148433locality
locally12179723locally
loll46128383lo_l_l_
lollies73116923lollies
lolling83415773lolling
lollingly1345343lollingly
lollopy12234773lollopy
lolls512121733lo_l_ls
lonely92912473lo_nely
longly10279603lo_ngly
loosely1036713loosely
lordly1038753lo_rdly
loudly1037783lo_udly
lovably15187063lovably
lovely12339713lo_vely
loverly1346973loverly
lowball1275503lowball
lowboy1435903low_boy
lowery124112713low_ery
lowing104623273low_ing
lowish12310533low_ish
lowland1134693lowland
lowliest11229473lowliest
lowlifer1443283lowlifer
lowlifes1434333lowlifes
lowlight1554943lowlight
lowlives1434573lowlives
loyally13126843loyally
luckily16297083luckily
lumpily1476563lumpily
lustily103611243lustily
manlily1238743manlily
mollify1555503mollify
molly105222493mo_l_ly
moodily1358203moodily
moonily1248943moonily
mousily1239393mousily
nobbily1436693nobbily
noily86120993no__ily
noisily1038403noisily
nonoily1049543nonoily
nosily93712683no_sily
oily77932253_o__ily
oozily18328073_oozily
owlish1238703_owlish
owlishly1743593_owlishly
pawkily1934203pawkily
pockily1846233pockily
podgily1435213podgily
pokily15309063po_kily
policy133211513po_licy
polity113015863po_lity
roily86121113ro__ily
roomily1237283roomily
ropily113312443ro_pily
rosily93914713ro_sily
roupily1246653roupily
showily1636223show_ily
sillily10209783sillily
slily85820033__slily
sloppily1544613sloppily
slowly1237153slow__ly
snowily1336883snow_ily
soapily1237963soapily
soggily1235953soggily
solely93714213so_lely
solidly1137353so_lidly
sootily101810523sootily
sorrily1039833sorrily
surlily10310003surlily
tawnily1335443tawnily
towline102911543towline
uglily1036193_uglily
wilily123310763_wilily
willy115321913__willy
wily106428813__w_ily
woollily1443123woollily
woolly12408513wool_ly
woozily2234383woozily
wordily1437853wordily
worldly1433993worldly
yowling143610223yowling

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271856.73619897.1
3Display Results1851850.0632936.5
 (SQL Overall)1786911857.20224811.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.