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

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

88 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
sumptuousnesses188304(None) 
bumptiousnesses2154052bumptiousnesses
sumptuousness1753552sumptuousne_s_s
impetuousnesses1953823_impetuousnesses
unctuousnesses1655523_unctuousnesses
bumptiousness1954644bumptiousne_s_s
captiousnesses1886934_captiousnesses
cumbrousnesses2054854cum_brousnesses
fatuousnesses1686864__fatuousnesses
humorousnesses1955444hum_orousnesses
luminousnesses1665184lum_inousnesses
lustrousnesses1355754lu_strousnesses
numerousnesses1655614num_erousnesses
numinousnesses1665344num_inousnesses
pompousnesses1955464pomp__ousnesses
rapturousnesses1753854_rapturousnesses
seditiousnesses1555664seditiousnesses
sensuousnesses12115604s_ensuousnesses
sinuousnesses1247314s__inuousnesses
strenuousnesses1453734strenuousnesses
sulfurousnesses1753154sulfurousnesses
tortuousnesses1455764_tortuousnesses
virtuousnesses1795294_virtuousnesses
ambiguousnesses20133095ambiguousnesses
ambitiousnesses1964935ambitiousnesses
amorousnesses1547815_am_orousnesses
arduousnesses1456545__arduousnesses
assiduousnesses1473065assiduousnesses
audaciousnesses1855165audaciousnesses
beauteousnesses17124135beauteousnesses
bounteousnesses1753995bounteousnesses
cautiousnesses1687615_cautiousnesses
congruousnesses1884635congruousnesses
copiousnesses1747805_cop_iousnesses
courteousnesses1784135courteousnesses
covetousnesses1955225covet_ousnesses
curiousnesses1549015cu__riousnesses
deciduousnesses1953875deciduousnesses
dubiousnesses1677075du__biousnesses
emulousnesses1556105_em_ulousnesses
exiguousnesses2274475_exiguousnesses
facetiousnesses2055325facetiousnesses
factiousnesses1977515_factiousnesses
famousnesses1745715fam___ousnesses
fractiousnesses2075875fractiousnesses
imperiousnesses1955485_imperiousnesses
impetuousness1754335_impetuousne_s_s
ingenuousnesses1684015ingenuousnesses
innocuousnesses17104095innocuousnesses
judiciousnesses2584765judiciousnesses
ludicrousnesses1853875ludicrousnesses
lusciousnesses1556245lu_sciousnesses
luxuriousnesses2264655luxuriousnesses
momentousnesses1963595momentousnesses
monstrousnesses1654315monstrousnesses
murderousnesses1853615murderousnesses
mutinousnesses1655185mu_tinousnesses
ominousnesses1556185_om_inousnesses
piousnesses1348985___p_iousnesses
piteousnesses1557175__piteousnesses
plenteousnesses1783985plenteousnesses
populousnesses1864745_populousnesses
porousnesses1469285___porousnesses
querulousnesses2463365querulousnesses
righteousnesses1963395righteousnesses
riotousnesses1357305_riot_ousnesses
ruinousnesses1356425ru__inousnesses
sagaciousnesses1765245sagaciousnesses
salaciousnesses1665605salaciousnesses
scabrousnesses1754725s_cabrousnesses
sedulousnesses1455575s_edulousnesses
seriousnesses1249885s__eriousnesses
sonorousnesses1356515s_onorousnesses
spaciousnesses17147185s_paciousnesses
speciousnesses17146905s_peciousnesses
spuriousnesses1557025s_puriousnesses
stoutnesses1146975s___t_outnesses
studiousnesses1475875s_tudiousnesses
tenuousnesses1357055__tenuousnesses
timorousnesses1655695tim_orousnesses
tumultuousness1661945tumultuousne_s_s
unctuousness1455335_unctuousne_s_s
usuriousnesses1356325_usuriousnesses
uxoriousnesses2156305_uxoriousnesses
vacuousnesses1896515__vacuousnesses
vaporousnesses1956005_vaporousnesses
venturousnesses1854865_venturousnesses
vexatiousnesses2555275vexatiousnesses

Search took 6 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 Filter178691658740.310576422.6
2DLD Change Limit65874884.87613509.8
3Display Results88880.0631396.8
 (SQL Overall)178691885.24934042.9
 
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.