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

254 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
glegly113487(None) 
elegy939302eleg_y
gangly113911582gangly
giggly12518702giggly
gladly11497932gladly
gleamy12398112gleamy
gleety10479192gleety
gleg66219802gleg__
gley85724652gle__y
glibly1236292glibly
gluily10308292gluily
glumly12356622glumly
goggly12337052goggly
googly11417882googly
greyly13316542greyly
leggy105210242_leggy
agedly1136463agedly
agilely1135123agile_ly
agley96917333agle__y
agly86821803__agly
alegar739283alegar
alertly1046793alertly
alienly1037503alienly
ally76935643al__ly
belly104625493_belly
bigly114814753_bigly
bleakly1634663bleakly
bleary115112553bleary
blebby1233743blebby
blenny1156203blenny
bluely113310083bluely
cleanly1236323cleanly
clearly1236663clearly
clergy1234993clergy
clerkly1643573clerkly
cloggy1344873cloggy
dangly114212263dangly
deeply1257013deeply
delly96023873_delly
dreggy12364633dreggy
eely77725213__eely
eggy96611853__eggy
elderly1154953elderly
elegit71212893elegit
evenly1236993evenly
feebly1436653feebly
felly114922803_felly
ferly115517353_ferly
feyly14429513_feyly
flaggy14415923flaggy
flatly123110213flatly
flecky18387653flecky
fledgy14414913fledgy
fleecy14266483fleecy
fleetly1336323fleetly
fleshly16346093fleshly
fleshy15406283fleshy
fleury12417353fleury
fley106626853fle__y
freely12310963freely
gadfly1434663gadfly
gaggle93412623gaggle
gaily95020973g_aily
gainly1049323gainly
gallfly1433523gallfly
gally95026173g_ally
gamely124711913gamely
gamily123712183gamily
gargle84215463gargle
gayly124513093g_ayly
geegaw1142853geegaw
geeky134710733g_eeky
gel45642433g_e_l_
geld65828433g_e_ld
gelidly1234753gelidly
gels56836103g_e_ls
gelt56448013g_e_lt
gemmy135211053g_emmy
gently103710913gently
germy115113663g_ermy
gey75738303g_e__y
giggle94313513giggle
gilly94321633g_illy
gingely12378213gingely
girly94415293g_irly
glady105413943gl_ady
glairy10448273glairy
glary96018543gl_ary
glassy10527753glassy
glazily2035383glazily
glazy187410983gl_azy
gleam86916733gle_am
gleams94812253gleams
glean65818203gle_an
gleans75014743gleans
gleba83910243gle_ba
glebae9407613glebae
glebe85016443gle_be
glebes95512243glebes
gled65631143gle__d
glede75517833gle_de
gledes84915133gledes
gleds75417893gle_ds
glee55239063gle__e
gleed75320573gle_ed
gleeds84711623gleeds
gleek105315103gle_ek
gleeks11489673gleeks
glees65027593gle_es
gleet65532343gle_et
gleets75315053gleets
glen56027203gle__n
glens66519853gle_ns
gleyed11478153gleyed
gleys96514853gle_ys
glial66715433glial_
glinty106910693glinty
glitzy19404783glitzy
globby1434683globby
glogg837353glog_g
gloggs935033gloggs
gloomy12528763gloomy
gloppy1454723gloppy
glory96413293gl_ory
glossy10549003glossy
glowfly1742673glowfly
gluey95715263gl_uey
glug66118013glug__
glugs75214283glug_s
glumpy14527193glumpy
glycyl1542793glycyl
gnarly104610383gnarly
godly104913293g_odly
goggle94511573goggle
goldenly1344103goldenly
golly95121103g_olly
goodly11419303goodly
gorily10612503gorily
grayly13287963grayly
greasy10419463greasy
greatly1137613greatly
greedy11518853greedy
greenly11408193greenly
greeny104811453greeny
grego7310523greg_o
gregos847533gregos
gremmy1454473gremmy
grey85624043gre__y
grimly12459933grimly
grisly104310583grisly
groggy1234803groggy
growly13499173growly
guggle94110433guggle
gully94020683g_ully
gurgle83912473gurgle
hugely1336803hugely
ileal56118083ileal_
illy76925333il__ly
jangly174310603jangly
jelly154218253_jelly
jiggly18378713jiggly
jingly174111933jingly
jungly17407693jungly
keenly1336373keenly
kelly124617023_kelly
kingly143511303kingly
kleagle1242933kleagle
laxly15610103_laxly
leady95618603_leady
leafy116316213_leafy
leaky125217723_leaky
leal46043273_leal_
leally94012613_leally
lealty92910603_lealty
leanly93811503_leanly
leary85927383_leary
leavy115715773_leavy
ledgy105712023_ledgy
leery85919133_leery
lefty115613563_lefty
leg46446113_leg__
legacy1256653_legacy
legal65715943_legal
legally1138133_legally
legals73412733_legals
leger65721513_leger
leges64427293_leges
legibly1344623_legibly
legit61323503_legit
legs56133693_leg_s
levy106418503_le_vy
lewdly1334403_lewdly
ley66246813_le__y
lezzy16608083_lezzy
liefly1266363liefly
lily76730183_l_ily
loggy105714193_loggy
logily1039833_logily
logy87025783_log_y
lolly85120663_lolly
longly10279603longly
lowly114113333_lowly
mealy104422183_mealy
meekly1535193meekly
meetly1138673meetly
nelly84618813_nelly
newly114610203_newly
niggly11418913niggly
ology94113113olog_y
openly1137123openly
overly122411363overly
palely11311933pale_ly
phlegmy1841503phlegmy
plaguy12386413plaguy
plenty11311413plenty
redly94217203_redly
refly113914563_refly
rely75428953_re_ly
reply104015853_reply
sagely102811383sagely
seely84522633_seely
seemly1138433seemly
shelly124414473shelly
singly104015853singly
slaggy11438793slaggy
sleazy18267393sleazy
sleekly14325193sleekly
sleeky13398963sleeky
sleepy11479413sleepy
sleety94112653sleety
slily85820033sl_ily
slimly11408903slimly
slowly1237153slowly
slyly11489533sl_yly
smelly114110363smelly
smugly1274833smugly
snugly1055663snugly
solely93714213sole_ly
steely93612573steely
tangly104413913tangly
telly84920823_telly
thegnly1442613thegnly
tingly103815973tingly
trebly1138973trebly
trigly103810943trigly
uglily1036193ugl_ily
ugly86012383__ugly
vealy115817773_vealy
vilely1239443vile_ly
waggly14347293waggly
weekly1635313weekly
welly114620013_welly
wetly114511713_wetly
wiggly14559683wiggly

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.373479064.3
2DLD Change Limit1127162546.12618399.6
3Display Results2542540.1561628.2
 (SQL Overall)1786912546.65526850.6
 
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.