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

299 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
uglily103619(None) 
uglify1333911uglify
burlily1237712burlily
curlily1238382curlily
fuggily1534962fuggily
gaily95020972_gaily
gilly94321632_gilly
glibly1236292_glibly
gluily10308292_gluily
gully94020682gul_ly
holily123612952holily
lily76730182__lily
muggily1435102muggily
oilily93111722oilily
slily85820032_slily
surlily10310002surlily
uglier748952uglier
uglies7412322uglies
ugly86012382ug__ly
wilily123310762wilily
aerily93017013aerily
agedly1136463agedly
agile65122263ag_ile
agilely1135123agilely
agility1148653agility
agley96917333agl_ey
agly86821803ag__ly
airily93014823airily
ally76935643_al_ly
angrily1137723angrily
artily92814713artily
baggily1436043baggily
baldly12479833baldly
balkily16266693balkily
bally105530103bal_ly
balmily14216463balmily
belly104625493bel_ly
billy105525363bil_ly
blimy125212823_blimy
bodily12310993bodily
boldly12399423boldly
boxily1877843boxily
bugling113615343bugling
bulkily16227123bulkily
bully105124813bul_ly
bumpily1665653bumpily
bushily15268893bushily
busily112211503busily
cagily12411563cagily
calmly1337613calmly
chilly144113223chilly
coldly12459953coldly
colly104926773col_ly
cosily113613853cosily
cozily20349703cozily
cully105520463cul_ly
cushily15257923cushily
daily95922333_daily
dally95324743dal_ly
daylily1434983daylily
delly96023873del_ly
dewily1338343dewily
dilly94923783dil_ly
doily95321033_doily
dolly96125203dol_ly
dopily123510463dopily
dozily19329103dozily
drily95816523_drily
duality1147963duality
dually103210063dual_ly
dully94921633dul_ly
dumpily1566233dumpily
duskily15236743duskily
dustily113211523dustily
easily9313023easily
edgily1136063edgily
eerily92913563eerily
evilly1236593evilly
family143311703family
felly114922803fel_ly
filly114424903fil_ly
filmily1535733filmily
foggily1535053foggily
folly115022603fol_ly
foxily1947253foxily
frilly124111443frilly
fugally1435603fugally
fugling124212513fugling
fully114820863ful_ly
funkily1736513funkily
funnily1336373funnily
furrily1337613furrily
fussily13267603fussily
fustily133111373fustily
fuzzily2145073fuzzily
gainly1049323_gainly
gally95026173_gally
gamily123712183gamily
gayly124513093_gayly
gelidly1234753gelidly
gild65526513_g_ild
gill56336183_g_ill
gills64728193_gills
gilt56348543_g_ilt
girly94415293_girly
gladly11497933_gladly
glady105413943_glady
glairy10448273_glairy
glary96018543_glary
glazily2035383_glazily
glazy187410983_glazy
glegly1134873_glegly
gley85724653_gl_ey
glia56423153_gli_a
glial66715433_glial
glias64618493_glias
glib79421443_gli_b
glide74521593_glide
gliff124915663_gliff
glim76026353_gli_m
glime85620193_glime
glims87417673_glims
glint66830183_glint
glinty106910693_glinty
glitz154916373_glitz
glitzy19404783_glitzy
glory96413293_glory
gluey95715263_gluey
glumly12356623_glumly
godlily1235343godlily
godly104913293_godly
golly95121103_golly
gorily10612503gorily
grill64617893_grill
grimly12459933_grimly
grimy114312603_grimy
gripy115115253_gripy
grisly104310583_grisly
guild75312753_guild
guile64521133_guile
guilt65125573_guilt
guiltily1243423guiltily
guilty10418233guilty
gulfy124612003gul_fy
gull54828453gul_l_
gulley104213163gulley
gullibly1443473gullibly
gulls65222983gul_ls
gulpy114612763gul_py
gushily14257823gushily
gustily113010903gustily
gutsily11267223gutsily
hazily2179063hazily
hilly114422163hil_ly
hokily16409093hokily
holly114824433hol_ly
homily144712333homily
huffily1934693huffily
hugely1336803hug_ely
hungrily1563053hungrily
huskily17236333huskily
icily101211693_icily
ickily1535753ickily
ignify1334513ignify
illy76925333_il_ly
jelly154218253jel_ly
jokily20306533jokily
jollily1745773jollily
jolly154517513jol_ly
joltily1746323joltily
juicily1935493juicily
jumpily2174983jumpily
kelly124617023kel_ly
lacily11612763lacily
lazily1859713lazily
lilo46731563__lilo
lilt46349943__lilt
limy95727713__limy
liny78141323__liny
logily1039833logily
lolly85120663lol_ly
lowlily1335353lowlily
luckily16297083luckily
lumpily1476563lumpily
lustily103611243lustily
manlily1238743manlily
mazily20610393mazily
mildly12318243mildly
milkily16216553milkily
molly105222493mol_ly
muckily18277743muckily
muddily1435963muddily
murkily16287113murkily
mushily152410093mushily
muskily16289043muskily
mussily12279773mussily
mustily123613633mustily
muzzily2045023muzzily
nelly84618813nel_ly
noily86120993_noily
nosily93712683nosily
nullify1334713nullify
nullity1037363nullity
nuttily10308633nuttily
ogling83211883ogling
oily77932253__oily
oozily18328073oozily
palely11311933palely
pally105727123pal_ly
pily96132733__pily
pokily15309063pokily
policy133211513policy
polity113015863polity
publicly1743313publicly
pudgily1434903pudgily
puffily1834843puffily
pulpily1436103pulpily
punily11311773punily
pursily1238213pursily
pushily15247983pushily
quakily2336693quakily
qualify2235473qualify
quality1938563quality
racily11715173racily
rally84725903ral_ly
roily86121113_roily
ropily113312443ropily
rosily93914713rosily
ruddily1236303ruddily
ruglike1236283ruglike
rustily103112993rustily
ruttily10338613ruttily
salify12311373salify
sally85129713sal_ly
saltily10310543saltily
sexily1638853sexily
shily115222013_shily
silkily14236963silkily
sillily10209783sillily
silly84527623sil_ly
slimly11408903_slimly
slimy105417423_slimy
slyly11489533_slyly
soggily1235953soggily
solely93714213solely
solidly1137353solidly
stilly93714093stilly
sulkily14218113sulkily
sully84622903sul_ly
sunnily1037833sunnily
tally84526863tal_ly
telly84920823tel_ly
tidily102811393tidily
tinily94014433tinily
tuftily1335573tuftily
ugliest8410153ugliest
unduly1037823unduly
unfitly1335573unfitly
ungainly1244423ungainly
ungodly1244473ungodly
unholily1444133unholily
unholy1238163unholy
unify113611113u_nify
unity84918493u_nity
unlay84613703unl_ay
unlike102614063unlike
unlikely1543823unlikely
unlink104011013unlink
unlit55025463unli_t
unlive92712333unlive
unlively1445753unlively
unpile81914323unpile
unruly938083unruly
untidy1059153untidy
until53517743until_
uphill11106173uphill
uplift114610653uplift
uplink12388713uplink
uplit76020803upli_t
uppile10178503uppile
uppity1335103uppity
uptilt8410803uptilt
usably11288983usably
utile54718933u_tile
utility1038703utility
validly1435573validly
verily122616053verily
vilely1239443vilely
vilify1536773vilify
wally114625093wal_ly
warily122915093warily
wavily15219483wavily
waxily19218413waxily
welly114620013wel_ly
wildly13328123wildly
willy115321913wil_ly
wily106428813__wily
wirily123310783wirily
zanily18310183zanily

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162995.47020606.2
3Display Results2992990.0933215.1
 (SQL Overall)1786912995.95330017.0
 
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.