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

173 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
gaums8621707(None) 
gams76648881ga_ms
gauds75717721gauds
gaum75726421gaum_
gaurs66317991gaurs
gauss65613451gauss
geums85414111geums
glums84621421glums
gums75030941g_ums
agues64919052agues
aims67738192_aims
alms65834922_alms
alums75720602alums
amus65529612_amus
arms66137492_arms
arums75517832arums
auks85525262_auks
balms95723922balms
bams87044452ba_ms
barms96128462barms
bauds85821042bauds
bums85934592_bums
calms95222352calms
cams87047282ca_ms
cauls75727772cauls
chums125015832chums
dams77444372da_ms
datums936352datums
daubs85014562daubs
dauts67822242dauts
doums85417642doums
drums85415872drums
fanums1137262fanums
farms106324952farms
fauns84516752fauns
gabs76740422ga_bs
gadis74825292gadis
gads67843392ga_ds
gaes56348032ga_es
gaffs124914652gaffs
gages74529972gages
gags66441062ga_gs
gains65729512gains
gaits65726012gaits
galas65731642galas
gales65442482gales
galls64729322galls
gals57946502ga_ls
gam67060062ga_m_
gama77035522ga_ma
gamas85431362gamas
gamb96331842ga_mb
gambs105721122gambs
game76644322ga_me
games86238552games
gamma106116102gamma
gammas115714692gammas
gammy135514892gammy
gamp98833212ga_mp
gamps105323712gamps
gamut8322982gamut
gamuts958782gamuts
gamy105427532ga_my
gangs76222582gangs
gaols66717572gaols
gapes86030822gapes
gaps76042972ga_ps
garbs86321412garbs
gars55750742ga_rs
gas48870252ga__s
gases65633992gases
gasps85415482gasps
gasts66628632gasts
gates65939512gates
gats56753442ga_ts
gaud67025432gau_d
gaudy106611462gaudy
gauge76117902gauge
gauges85915992gauges
gault65128482gault
gaults74112782gaults
gaumed104610322gaumed
gaun56427712gau_n
gaunt65430402gaunt
gaur56723352gau_r
gauze155712972gauze
gauzes164710632gauzes
gauzy18489212gauzy
gawks136811632gawks
gawps115911012gawps
gays87338022ga_ys
gazes155425912gazes
gazump2032452gazump
gazumps2131872gazumps
gems75329112g_ems
germs85118872germs
geum75424552geum_
ghauts10447782ghauts
glams85822932glams
glims87417672glims
gloms85219782gloms
glues65125682glues
glugs75214282glugs
glum75825102glum_
glume85120462glume
glumes94516812glumes
gluts66120132gluts
gnus56518002gnu_s
gorms85619592gorms
gouts64826172gouts
grams85327312grams
grubs86312602grubs
grues65721962grues
grum75625082grum_
grume86218162grume
grumes94415552grumes
grump105115312grump
grumps114510572grumps
guans64419442guans
guars65021052guars
guls55930852g_uls
gum67439532g_um_
guns55533482g_uns
guts56637252g_uts
guvs85816812g_uvs
guys85019642g_uys
gyms107514592g_yms
haems105517012haems
halms105225212halms
hams96446132ha_ms
harms106829012harms
haulms11558502haulms
hauls86123732hauls
hums96831422_hums
imaums10106302imaums
jams135231072ja_ms
jauks165412462jauks
jaups144810532jaups
lams66552262la_ms
larums83610532larums
lauds65618482lauds
lums65734242_lums
maims96321792maims
malms95021552malms
mauds85519272mauds
mauls76524952mauls
mauts75927192mauts
mums85732772_mums
neums75414252neums
oakums1264152oakums
ogams84112682oga_ms
palms94921752palms
pams85641762pa_ms
plums94619952plums
rams65950772ra_ms
ramus76418282ramus
rums64833472_rums
sauls55128122sauls
scums95017422scums
slums74623432slums
stums75320082stums
sums65837582_sums
tams67247932ta_ms
taus46342732tau_s
tauts56125512tauts
vaus75928922vau_s
wamus105514682wamus
warms107726852warms
wauks125515162wauks
wauls86120552wauls
yams95330732ya_ms
yauds95013222yauds
yaups105910742yaups

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 Filter178691538000.296603685.8
2DLD Change Limit538001731.59633709.3
3Display Results1731730.0463760.9
 (SQL Overall)1786911731.93892203.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.