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

154 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
spumous113585(None) 
brumous11107442brumous
grumous1086612grumous
soukous1136412soukous
spermous1247932spermous
spinous9310442spinous
spumes1021314882spum_es
spumone1154382spumone
spumones1254952spumones
spumoni1173452spumoni
spumonis1264112spumonis
spurious1036962spurious
squamous1944672squamous
strumous1045732strumous
sumos75720092s_umo_s
agamous1037943agamous
alumnus935223alumnus
anurous7311553anurous
apodous1037403apodous
aqueous1636053aqueous
astomous1047213astomous
aurous64119263_aurous
awmous1157713_awmous
boubous1138693boubous
chymous1775703chymous
comous10816503_comous
cormous11312353cormous
cuprous1149743cuprous
cymous1388403_cymous
emulous937343emulous
famous11412393_famous
fucous11399863_fucous
gummous1236263gummous
hummus1336243_hummus
humors11129633_humors
humour11116753_humour
humours1286433_humours
humus106215073_hum_us
lupous849433_lupous
mucous104411653_mucous
mumus95517283_mum_us
muumuus1141763muumuus
osmous8138183_osmous
parous84024163_parous
pilous84717753_pilous
pious74621273_p_ious
plumbous1444283plumbous
pomos95321583_pomo_s
pompous1338063_pompous
populous1245953populous
porous84419483_porous
poyous112911623_poyous
pulpous1177013_pulpous
pumas95121563_pum_as
pumps115520603_pum_ps
pupus94614043_pu_pus
putons83515153_putons
putout8315113_putout
putouts937083_putouts
ramous8417113_ramous
raucous938303raucous
rimous8311913_rimous
rufous948273_rufous
rugous739653_rugous
rumors81110403_rumors
rumour8127383_rumour
rumours976373_rumours
rumpus10458893_rumpus
sabulous1046123sabulous
sajous13310583s_ajous
salmons93713263salmons
sanious7514103sanious
sapajous1744833sapajous
saporous1039053saporous
sarcous9312933sarcous
schmoes14308543schmoes
schmoos14347513schmoos
schmos13379153schmo_s
scums95017423scum__s
sedulous946133sedulous
sepalous1047523sepalous
serious73616283serious
sermons9311783sermons
serous65023563s_erous
setous64917373s_etous
setulous846913setulous
shamois123210423shamois
shamos114216983shamo_s
shamoys15367283shamoys
shamus114112813sham_us
shmoes114612103s_hmoes
shutout1048533shutout
shutouts1143823shutouts
simious939803simious
sinuous739063sinuous
sixmos1534813sixmo_s
skimos12548803skimo_s
slumbrous1343973slumbrous
slumgum1242733slumgum
slumgums1342093slumgums
slumps104313583slum_ps
slums74623433slum__s
smogs85112163s__mogs
sous46947213s___ous
spacious1237813spacious
spambots1443313spambots
spams94922193spam__s
specious1247483specious
spigots1037793spigots
spinors939423spinors
spinout9311583spinout
spinouts1036023spinouts
spoofs114011813sp_oofs
spooks124312933sp_ooks
spools85115913sp_ools
spoons84116023sp_oons
spoors84014033sp_oors
spots74424113sp__ots
spouse84112513sp__ouse
spout75029633sp__out
spouts85115113sp__outs
sprout8419403sp_rout
sprouts949983sp_routs
spuds85113673spu__ds
spues75025383spu__es
spume95817313spum__e
spumed114711543spum_ed
spumier1137903spumier
spumiest1238203spumiest
spuming1248523spuming
spumy124610363spum__y
spunks12349333spu_nks
spurges104111653spurges
spurns84811383spu_rns
spurs74621523spu__rs
spurts84814973spu_rts
sputum1035943spu_tum
studious9245553studious
stumps104912283stum_ps
stums75320083stum__s
stupors935883stupors
sudors7311103s_udors
sulcus8410493s_ulcus
sulus54821883s_u_lus
sumacs105512103s_umacs
summas104313163s_ummas
summons1158003summons
sumo67326313s_umo__
sumoist9311613s_umoist
sumps95023433s_um_ps
sums65837583s_um__s
tumors8810613_tumors
tumour8137403_tumour
tumours976753_tumours

Search took 7 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 Limit1340271546.42320866.7
3Display Results1541540.0632444.4
 (SQL Overall)1786911546.89225927.3
 
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.