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 “gums” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

336 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
gums7503094(None) 
bums85934591bums
gams76648881gams
gaums86217071gaums
gems75329111gems
geums85414111geums
glums84621421glums
guls55930851guls
gum67439531gum_
guns55533481guns
guts56637251guts
guvs85816811guvs
guys85019641guys
gyms107514591gyms
hums96831421hums
lums65734241lums
mums85732771mums
rums64833471rums
sums65837581sums
agues64919052agues
aims67738182aims
algums9208042algums
alms65834922alms
alums75720602alums
amus65529612amus
arms66137492arms
arums75517832arums
auks85525262auks
bams87044452bams
begums11429492begums
bubs86235492bubs
buds75235172buds
bugs76035912bugs
bum75342692bum_
bumf116126502bumf
bumfs125414052bumfs
bump106228242bump
bumps115921142bumps
buns66243722buns
burs65847422burs
bus56950972bu_s
buss65134912buss
buts67247692buts
buys95726792buys
cams87047282cams
chums125015832chums
cubs85832382cubs
cuds76730472cuds
cues65438982cues
culms95314192culms
cum76440162cum_
cups85430822cups
curs65645542curs
cuss65430612cuss
cuts65841152cuts
cwms11439572cwms
dams77444372dams
degums10438622degums
dims75435022dims
doms76239572doms
doums85417642doums
drums85415872drums
dubs78432192dubs
duds65530142duds
dues56045502dues
dugs614832282dugs
duma75524452duma
dumas85420432dumas
dumb97124102dumb
dumbs105915752dumbs
dump95927092dump
dumps105220102dumps
duns55140432duns
duos56728132duos
dups75929512dups
elms67322702elms
ems56435492_ems
emus66821682emus
fems96428702fems
fubs96328792fubs
fuds86528562fuds
fugs85730692fugs
fume96727632fume
fumes105224702fumes
fumy127118582fumy
funs75235732funs
furs76735042furs
fuss76027932fuss
gabs76740422gabs
gads67843382gads
gaes56348032gaes
gags66441062gags
gals57946502gals
gam67060062gam_
gama77035512gama
gamas85431352gamas
gamb96331842gamb
gambs105721122gambs
game76644322game
games86238552games
gamp98833212gamp
gamps105323712gamps
gamy105427532gamy
gaps76042972gaps
gars55750742gars
gas48870252g_as
gats56753442gats
gauds75717722gauds
gaum75726422gaum_
gaurs66317992gaurs
gauss65613452gauss
gays87338022gays
geds66730812geds
gees55647882gees
gels56836102gels
gem66840222gem_
gens55740072gens
germs85118872germs
gets55442482gets
geum75424552geum_
ghis85020162ghis
gibs75529262gibs
gids65933732gids
gies55641422gies
gigs66631182gigs
gimp96124042gimp
gimps105915202gimps
gins55543952gins
gips75632922gips
gits55744592gits
glams85822932glams
glims87417672glims
gloms85219782gloms
glues65125682glues
glugs75214282glugs
glum75825102glum_
glume85120462glume
glumes94516812glumes
gluts66120132gluts
gnus56518002gnus
goas55239942goas
gobs76935572gobs
gods65438042gods
goes55644092goes
goos57644912goos
gorms85619592gorms
gos47155132g_os
gouts64826172gouts
goys86328412goys
grams85327312grams
grubs86312602grubs
grues65721962grues
grum75625082grum_
grume86218162grume
grumes94415552grumes
grump105115312grump
grumps114510572grumps
guan55325582guan
guans64419442guans
guar56923292guar
guars65021042guars
guck114922532guck
gucks123917302gucks
gude65423332gude
gudes74520812gudes
guess64213362guess
guest65225922guest
guff114624932guff
guffs124414822guffs
guid66022822guid
guids75516152guids
guise64717712guise
gul45832792gu_l
gules64831042gules
gulf84929422gulf
gulfs94915302gulfs
gull54828452gull
gulls65222982gulls
gulp75521362gulp
gulps84715072gulps
gumbo104413582gumbo
gumbos114610872gumbos
gumma105313102gumma
gummas114810512gummas
gummy135413652gummy
gun47240802gu_n
gunk95423572gunk
gunks104517722gunks
gursh94512332gursh
guru54623912guru
gurus64318192gurus
gush85424002gush
gussy95314322gussy
gust55240702gust
gusts65722792gusts
gut46753852gu_t
gutsy96412842gutsy
guv74523172gu_v
guy75728942gu_y
gym95719062gym_
gyps105115022gyps
hams96446132hams
hems95534942hems
hims95230972hims
hubs96027142hubs
hues75235232hues
hugs86129752hugs
hum85542932hum_
hump116228722hump
humps126322802humps
humus106215072humus
huns76136932huns
huts76737442huts
isms66213472isms
jams135231072jams
jugs125525602jugs
jugums16104672jugums
jump156621722jump
jumps165116492jumps
jus106930222ju_s
juts115930162juts
kues86426772kues
kumys1435932kumys
lams66552262lams
lues45943552lues
lugs55233522lugs
lum55542932lum_
luma65527522luma
lumas75622912lumas
lump86531702lump
lumps95624982lumps
luvs75818502luvs
mems85931502mems
moms86539482moms
muds75530652muds
mugs76232042mugs
mum76643612mum_
mumm75718862mumm
mumms85513152mumms
mump105425722mump
mumps115619102mumps
mumu86022062mumu
mumus95517282mumus
muns65535912muns
mus55946752mu_s
muss64933762muss
muts64839982muts
neums75414252neums
nims66226882nims
noms65636402noms
nubs65927142nubs
numb85520612numb
numbs94913092numbs
nuns45228232nuns
nus37939392nu_s
nuts45032672nuts
ogams84112682ogams
ohms95514032ohms
oms56337512_oms
ouds56430102ouds
ours47237562ours
outs45746962outs
pams85641762pams
plums94619952plums
poms87037742poms
pubs85029212pubs
puds75630512puds
pugs76332772pugs
puls65437562puls
puma85424122puma
pumas95121562pumas
pump105726852pump
pumps115520602pumps
puns66641482puns
pups86032232pups
purs65641042purs
pus55547842pu_s
puss64830132puss
puts65641752puts
rams65950772rams
rems66237722rems
rims65936302rims
roms67038962roms
rubs66133492rubs
rues46044482rues
rugs56033682rugs
rum56644642rum_
rump86729082rump
rumps95922292rumps
runs46438072runs
ruts44541492ruts
scums95017422scums
sims65737172sims
slums74623432slums
soms66239372soms
stums75320082stums
subs66037122subs
suds56135292suds
sues46247652sues
suks85927122suks
sum56346012sum_
sumo67326312sumo
sumos75720092sumos
sump86331532sump
sumps95023432sumps
suns45841902suns
sups64834432sups
suqs134319652suqs
suss45229302suss
tams67247932tams
toms68343492toms
tubs65430062tubs
tugs56231672tugs
tuis44829642tuis
tump85927032tump
tumps95420792tumps
tuns45138662tuns
tups65628762tups
tuts45838452tuts
ughs85410972ughs
um47338832_um_
umm711921262_umm
ump76130442_ump
umps85721942_umps
uns35936752_uns
ups55629052_ups
us26937432_u_s
uts35534372_uts
vims95423312vims
vugs87022872vugs
vum85428652vum_
wuss75219332wuss
yams95330732yams
yuks116418022yuks
yum86132822yum_
yups96121602yups

Search took 2 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 Filter178691298720.0632836365.1
2DLD Change Limit298723360.93631914.5
3Display Results3363360.0804200.0
 (SQL Overall)1786913361.079165608.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.