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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
strumous104573(None) 
brumous11107442_brumous
grumous1086612_grumous
spumous1135852s_pumous
stratous8410702stratous
strumas9419832strum_as
strumose1044302strumose
strums84716452strum__s
astomous1047213ast_omous
biramous1266073biramous
chromous15258343chromous
cormous11312353cor_mous
estrous7712533estr__ous
estrums9208603estrum__s
posthumous1752383posthumous
ramous8417113__ramous
rimous8311913__rimous
rufous948273__rufous
rugous739653__rugous
rumors81110403__rumors
rumour8127383__rumour
rumours976373__rumours
rumpus10458893__rumpus
sabulous1046123sabulous
sarcous9312933sar_cous
scrums104614253scrum__s
sedulous946133sedulous
serious73616283ser_ious
sermons9311783ser_mons
serous65023563ser__ous
serums83916303serum__s
setulous846913setulous
sinuous739063sinu_ous
soukous1136413s_oukous
spermous1247933spermous
spurious1036963spurious
squamous1944673squamous
stannous846443stannous
stimulus1044333stimulus
stramony1344933stramony
stratus73011733str_atus
strenuous944863strenuous
stridors9367323stridors
stridulous1152713stridulous
strops86220383str__ops
stroud7310383str__oud
strouds837803str__ouds
strows96718273str__ows
stroys95914603str__oys
strudels934123strudels
strum75619453strum___
struma84313273strum__a
strumae9368093strum_ae
strummed1344473strummed
strummer1234783strummer
strummers1333693strummers
strumpet1256033strumpet
strumpets1362893strumpets
strunts7429543stru_nts
struthious1352173struthious
struts65616803stru__ts
studious9245553studious
stumps104912283st_um_ps
stums75320083st_um__s
stupors935883st_upors
sumos75720093s__umo_s
tremors93711233_tremors
trumps104611883_trum_ps
tumors8810613_t_umors
tumour8137403_t_umour
tumours976753_t_umours

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 Filter1786911461620.423422437.4
2DLD Change Limit146162717.23320207.7
3Display Results71710.0332151.5
 (SQL Overall)178691717.68923239.8
 
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.