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

245 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
globby143468(None) 
lobby125113921_lobby
slobby1334801slobby
blabby1234812blabby
blebby1233742blebby
blowby16467512blowby
bobby114814662_bobby
clubby1534682clubby
cobby145516412_cobby
dobby136013632_dobby
flabby1634572flabby
gabby135512952g_abby
glibly1236292glibly
glob76623392glo_b_
global937662global
globe84917012glo_be
globed104811762globed
globes94314542globes
globin9309722globin
globs85616402glo_bs
gloomy12528762gloomy
gloppy1454722gloppy
glory96413292glo_ry
glossy10549002glossy
goby106021082g_o_by
goodby13406282goodby
grabby14336182grabby
grubby14324502grubby
hobby155913732_hobby
knobby1732712knobby
looby108115622_looby
nobby125513462_nobby
snobby1334402snobby
blob86027093blo_b_
blobbed11366563blobbed
blobs95620033blo_bs
blocky17388353blocky
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
blotty11178343blotty
blousy11459123blousy
blowbys17353813blowbys
blowsy14579453blowsy
blowy134315323blo_wy
blowzy23516673blowzy
booby125319513_booby
bubby115013933_bubby
cabby145314563_cabby
chubby1844123chubby
clobber13378163clobber
cloddy13405233cloddy
cloggy1344873cloggy
clomb115714703clomb_
clotty11208263clotty
cloudy12517803cloudy
cloy96623833clo__y
cobb106422003_cobb_
cobbs115013993_cobbs
colby124415063_colby
corby125018533_corby
crabby15346753crabby
cubby145212123_cubby
doby106022163_do_by
floaty124210943floaty
flocky18468423flocky
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
floppy1654873floppy
flossy12517703flossy
floury12449573floury
flyboy17113913flyboy
flyby1676003fl_yby
forby135317673_forby
gaby107123193g__aby
ghosty13467213ghosty
gladly11497933gladly
glady105413943gl_ady
glairy10448273glairy
glary96018543gl_ary
glassy10527753glassy
glazy187410983gl_azy
gleamy12398113gleamy
gleba83910243gl_eba
glebae9407613glebae
glebe85016443gl_ebe
glebes95512243glebes
gleety10479193gleety
glegly1134873glegly
gley85724653gl__ey
glib79421443gl_ib_
glibber1235163glibber
glinty106910693glinty
glitzy19404783glitzy
gloam86015943glo_am
gloams95210663gloams
gloat65427683glo_at
gloats74515423gloats
globally1444613globally
globate1057823globate
globbier1334243globbier
globing113210003globing
globins10278953globins
globoid1145973globoid
globose1035543globose
globous1036503globous
globule1034383globule
glogg837353glo_gg
gloggs935033gloggs
glom75424383glo__m
gloms85219783glo_ms
glomus9468093glomus
gloom87116523glo_om
glooms96211683glooms
glop76724633glo__p
glops85619553glo_ps
gloria71910553gloria
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
glumpy14527193glumpy
gob68950893g_o_b_
goban84414073g_oban
gobbed124613883g_obbed
gobbet114214443g_obbet
gobble113512983g_obble
gobo76126903g_o_bo
gobony1236913g_obony
gobos86219383g_obos
gobs76935573g_o_bs
godly104913293g_odly
golly95121103g_olly
gombo105814043g_ombo
goober93911743goober
goodbye14364193goodbye
goodbys14354173goodbys
goodly11419303goodly
goody105620393g_oody
gooey95522863g_ooey
goofy124915623g_oofy
googly11417883googly
gooky135818033g_ooky
goombay1543553goombay
gooney106612313gooney
goony95519783g_oony
goopy115816623g_oopy
goosey105913513goosey
goosy96018883g_oosy
gorsy95915783g_orsy
gory86129663g_o_ry
gouty95217363g_outy
goy77844553g_o__y
grody103412063gro_dy
groggy1234803groggy
groovy13375403groovy
groszy19395703groszy
grotty10389833grotty
grouty104710983grouty
growly13499173growly
hubby155011403_hubby
ignobly1342873ignobly
knobbly1842873knobbly
knubby1742783knubby
lamby125114843_lamby
limby125714073_limby
loamy105913343_loamy
lob57154463_lo_b_
lobar7313013_lobar
lobbed113114613_lobbed
lobber104016603_lobber
lobbyer1433913_lobbyer
lobe65535363_lo_be
lobed86022133_lobed
lobes75331003_lobes
lobo67229863_lo_bo
lobos75921843_lobos
lobs66441083_lo_bs
lofty115813303_lofty
loggy105714193_loggy
logy87025783_lo_gy
lolly85120663_lolly
looey84822913_looey
loony86918963_loony
loopy105316643_loopy
loppy125911663_loppy
lorry86315673_lorry
lory75931713_lo_ry
lossy85214643_lossy
loury85716753_loury
lousy84617083_lousy
lowboy1435903_lowboy
lowly114113333_lowly
nobly105314403_nobly
nubby125011033_nubby
obey96521303__obey
ology94113113olo_gy
orby97519603__orby
ploidy1237483ploidy
plotty11208853plotty
plowboy1743183plowboy
ploy96123603plo__y
poboy121612223_poboy
ribby12419683_ribby
rubby124413863_rubby
scabby1535503scabby
shabby1635803shabby
slob66029423slo_b_
slobber11388903slobber
slobbery15375663slobbery
slobs74419873slo_bs
sloppy1395303sloppy
sloshy12366623sloshy
slowly1237153slowly
snubby1344533snubby
stubby1345043stubby
swabby1634353swabby
tabby125213893_tabby
toby96322293_to_by
tubby124511403_tubby
webby1537153_webby
wobbly16347093_wobbly
womby155910093_womby
yabby15389753_yabby
yobbo1237873_yobbo
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 Limit1127162455.28021347.7
3Display Results2452450.0803062.5
 (SQL Overall)1786912455.75331060.5
 
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.