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

168 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
gummous123626(None) 
gammons1237972gammons
grumous1086612grumous
gumbos114610872gumbo_s
gummas114810512gumm_as
gummatous1442732gummatous
gummers123712202gummers
gummose1235332gummose
gummoses1344742gummoses
gummosis1343712gummosis
hummus1336242humm_us
summons1158002summons
agamous1037943agamous
ammos94815823_ammo_s
aurous64119263au_rous
awmous1157713_awmous
brumous11107443brumous
bulbous1138293bulbous
bullous9311663bullous
bummers133712443bummers
burnous938823burnous
chymous1775703chymous
commons13311043commons
comous10816503_comous
cormous11312353cormous
cumbrous1446173cumbrous
cummers133713483cummers
cummins1358963cummins
cumulous1245273cumulous
cumulus1135453cumulus
cuprous1149743cuprous
curious93813563curious
cymous1388403_cymous
dubious1036893dubious
dumbos114111083dumbo_s
dummies123012133dummies
duomos936823duomo_s
duteous838453duteous
emulous937343emulous
famous11412393_famous
fucous11399863fu_cous
fulvous1334543fulvous
fumulus1234443fumulus
fungous11367433fungous
furious103110633furious
fuscous1256673fuscous
gallous82813953gallous
gambols1238593gambols
gammas115714693gamm_as
gammers123214563gammers
gammon1138903gammo_n
gaseous839503gaseous
gemots93712153g_emots
gibbous1265333gibbous
gimmals12225823gimmals
gimmes113010903gimm_es
gimmies123010113gimmies
gismos957183gismo_s
gizmos1844133gizmo_s
glamors1068123glamors
glamour1065143glamour
glamours1184743glamours
globous1036503globous
glomus9468093glom_us
gnomons1035753gnomons
gombos114311093gombo_s
grampus12356313grampus
grummets13275033grummets
guacos94410313guaco_s
guanos73811993guano_s
guenons836563guenons
guidons936623guidons
guimpes1245073guimpes
guiros7389093guiro_s
gumbo104413583gumbo__
gumboil1244373gumboil
gumboils1343893gumboils
gumboot1246493gumboot
gumboots1344253gumboots
gumdrops1442823gumdrops
gumless10228273gumless
gumma105313103gumm__a
gummata1244613gummata
gummed123811663gumm_ed
gummer114615453gumm_er
gummier12349473gummier
gummiest13269033gummiest
gumming133810193gumming
gummite1236133gummite
gummites1346173gummites
gummy135413653gumm__y
gumptious1443053gumptious
gums75030943gu_m__s
gumshoes1444123gumshoes
gumwood14114043gumwood
gumwoods15123923gumwoods
gundogs1034603gundogs
gurus64318193gu__rus
gustoes879873gustoes
guyots1036003gu_yots
hommos13128503hommo_s
hugeous1137133hugeous
humerus1236913humerus
hummers143813063hummers
hummock2063793hummock
hummocks2163453hummocks
humorous1346443humorous
humors11129633hu_mors
humour11116753hu_mour
humours1286433hu_mours
humus106215073hu_m_us
jumbos17379123jumbo_s
kummels15234793kummels
luminous1037113luminous
lummox1733053lummo_x
lummoxes1942553lummoxes
lupous849433lu_pous
luteous739273luteous
mammons1048513mammons
meous76120063__meous
momus96116113__momus
mucous104411653mu_cous
mummers103712843mummers
mummies103812843mummies
mumms85513153mumm__s
mumus95517283mu_m_us
muumuus1141763muumuus
nimious937663nimious
numerous1047843numerous
numinous1046293numinous
osmious936003osmious
osmous8138183_osmous
plumbous1444283plumbous
pompous1338063pompous
pulpous1177013pulpous
pummels13236543pummels
ramous8417113_ramous
rimous8311913_rimous
rubious938283rubious
rufous948273ru_fous
rugous739653ru_gous
ruinous739763ruinous
rummers113513653rummers
rummies113212793rummies
rumors81110403ru_mors
rumour8127383ru_mour
rumours976373ru_mours
rumpus10458893ru_mpus
simious939803simious
spumous1135853spumous
squamous1944673squamous
summas104313163summ_as
summers113616503summers
summits1137983summits
summon1037623summo_n
sumos75720093su_mo_s
timeous938403timeous
tummies113012033tummies
tumorous1046603tumorous
tumors8810613tu_mors
tumour8137403tu_mour
tumours976753tu_mours
tumulous1045303tumulous
tumulus935033tumulus
umbos94613073_umbo_s
uveous936603_uveous
wammus13426733wamm_us
yummies14359533yummies

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271686.57620381.2
3Display Results1681680.0632666.7
 (SQL Overall)1786911687.04525364.2
 
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.