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

277 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
gloppy145472(None) 
floppy1654871floppy
loppy125911661_loppy
sloppy1395301sloppy
choppy18376292choppy
flappy1654482flappy
flippy1654612flippy
gappy136212032g_appy
globby1434682globby
gloomy12528762gloomy
glop76724632glo_p_
glopped13347612glopped
glops85619552glo_ps
glory96413292glo_ry
glossy10549002glossy
glumpy14527192glumpy
goopy115816622g_oopy
grippy14447762grippy
guppy135211272g_uppy
hoppy154912352_hoppy
jaloppy21302482jaloppy
lippy124511902_lippy
loopy105316642_loopy
poppy114813192_poppy
slippy1375842slippy
soppy125113522_soppy
atopy106813393ato_py
biopsy1334533biopsy
blocky17388353blocky
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
bloop96116153bloop_
bloops106611343bloops
blotty11178343blotty
blousy11459123blousy
blowby16467513blowby
blowsy14579453blowsy
blowy134315323blo_wy
blowzy23516673blowzy
buppy144810073_buppy
chippy18437613chippy
cloddy13405233cloddy
cloggy1344873cloggy
clomp115615703clomp_
clomps125212233clomps
clop86929893clo_p_
clopped143611523clopped
clops95924853clo_ps
clotty11208263clotty
cloudy12517803cloudy
cloy96623833clo__y
clumpy15409573clumpy
copay126516313_copay
copy116229803_co_py
crappy15446803crappy
croupy13458733croupy
cuppy144710383_cuppy
dippy135111543_dippy
dopey116020353_dopey
dopy106224153_do_py
drippy14445653drippy
droopy12458243droopy
dropsy12497473dropsy
elope75219343elo_pe
eloped95914143eloped
eloper85414153eloper
elopes85918163elopes
floaty124210943floaty
flocky18468423flocky
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
flop96925453flo_p_
flopped15338763flopped
flopper14328473flopper
floppily1843773floppily
flops105920143flo_ps
flossy12517703flossy
floury12449573floury
galop84716223galo_p_
galoped11138073galoped
galops94712623galo_ps
gapy106320913g__apy
ghosty13467213ghosty
gimpy135212233g_impy
gipsy11579543g_ipsy
gladly11497933gladly
glady105413943gl_ady
glairy10448273glairy
glary96018543gl_ary
glassy10527753glassy
glazy187410983gl_azy
gleamy12398113gleamy
gleety10479193gleety
glegly1134873glegly
gley85724653gl__ey
glibly1236293glibly
glinty106910693glinty
glitzy19404783glitzy
gloam86015943glo_am
gloams95210663gloams
gloat65427683glo_at
gloats74515423gloats
glob76623393glo__b
global937663global
globe84917013glo_be
globed104811763globed
globes94314543globes
globin9309723globin
globs85616403glo_bs
glogg837353glo_gg
gloggs935033gloggs
glom75424383glo__m
gloms85219783glo_ms
glomus9468093glomus
gloom87116523glo_om
glooms96211683glooms
gloppier1354673gloppier
glopping14307753glopping
gloria71910543gloria
glorify1444583glorify
gloss64319623glo_ss
glossa7529163glossa
glost65422933glo_st
glosts74513813glosts
glout65925813glo_ut
glouts74414713glouts
glove94516293glo_ve
gloved114811873gloved
glover104513533glover
gloves104115183gloves
glow85222523glo__w
glowed114913833glowed
glower105114933glower
glowfly1742673glowfly
glows95518033glo_ws
gloze154815983glo_ze
glozed173711223glozed
glozes164313353glozes
gluey95715263gl_uey
gluily10308293gluily
glumly12356623glumly
glyph1456473gl_yph
glyphs1534303glyphs
goby106021083g_o_by
godly104913293g_odly
golly95121103g_olly
goodby13406283goodby
goodly11419303goodly
goody105620393g_oody
gooey95522863g_ooey
goofy124915623g_oofy
googly11417883googly
gooky135818033g_ooky
gooney106612313gooney
goony95519783g_oony
goop75829483g_oop_
goops86620963g_oops
goosey105913513goosey
goosy96018883g_oosy
gopik1257533g_opik
gorp75625903g_orp_
gorps85316993g_orps
gorsy95915783g_orsy
gory86129663g_o_ry
gouty95217363g_outy
goy77844553g_o__y
grapey126012303grapey
grappa11396443grappa
grapy115416433g_rapy
gripey124111203gripey
grippe115310323grippe
gripy115115253g_ripy
grody103412063gro_dy
groggy1234803groggy
groovy13375403groovy
grope84821613gro_pe
groped107515053groped
groper94517253groper
gropes95220403gropes
groszy19395703groszy
grotty10389833grotty
group85413923group_
groups94210513groups
grouty104710983grouty
growly13499173growly
grumpy14498153grumpy
gulpy114612763g_ulpy
gypsy14636993g_ypsy
happy155813533_happy
hippy155112793_hippy
jalopy18325863jalo_py
koppa13397293_koppa
loamy105913343_loamy
lobby125113923_lobby
lofty115813303_lofty
loggy105714193_loggy
logy87025783_lo_gy
lolly85120663_lolly
looby108115623_looby
looey84822913_looey
loony86918963_loony
loop67835013_loop_
loops75723963_loops
lop58255313_lo_p_
lope65941923_lo_pe
loped85128333_loped
loper75129233_loper
lopes76437343_lopes
lopped114218623_lopped
lopper103717203_lopper
lops66043353_lo_ps
lorry86315673_lorry
lory75931713_lo_ry
lossy85214643_lossy
loup66028433_loup_
loupe75319513_loupe
loups75319623_loups
loury85716753_loury
lousy84617083_lousy
lowly114113333_lowly
lumpy126615913_lumpy
mopey124821823_mopey
mopy115721973_mo_py
myopy15457353myo_py
nappy126312333_nappy
nippy124911113_nippy
ology94113113olo_gy
pappy114713803_pappy
peppy114310363_peppy
ploidy1237483ploidy
plop86625743plo_p_
plopped11288773plopped
plops95920333plo_ps
plotty11208853plotty
ploy96123603plo__y
poppa8409893_poppa
popsy125713403_popsy
preppy1235523preppy
puppy114912413_puppy
quippy22384263quippy
ropey106021873_ropey
ropy96323413_ro_py
roupy106112713_roupy
sappy125413473_sappy
shoppe133110323shoppe
sleepy11479413sleepy
slobby1334803slobby
sloop76118913sloop_
sloops85513623sloops
slop66533873slo_p_
slope75823563slo_pe
sloped94216853sloped
sloper84615913sloper
slopes84820453slopes
slopped123511443slopped
sloppily1544613sloppily
slops75026013slo_ps
sloshy12366623sloshy
slowly1237153slowly
snappy1366103snappy
snippy1374843snippy
snoopy11449473snoopy
soapy106114783_soapy
sophy136611763_sophy
soupy106115403_soupy
stroppy14205093stroppy
swoopy14487283swoopy
tippy125411793_tippy
trippy13457803trippy
trophy1438283trophy
whippy19385843whippy
yuppy15487913_yuppy
zappy21548943_zappy
zippy21518743_zippy
zloty17399793zlo_ty

Search took 6 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.393454684.5
2DLD Change Limit1127162774.56024718.4
3Display Results2772770.0803462.5
 (SQL Overall)1786912775.03335503.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.