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

76 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
prosperousness186279(None) 
ponderousness16105333p_onderousness
boisterousness1662844boisterousness
onerousness1148264__o_nerousness
pompousness1755034p_omp__ousness
populousness1654234p_o_pulousness
porousness1248444p_o___rousness
prodigiousness1883614prodigiousness
properness1445924pro_per___ness
propitiousness1864644propitiousness
prospectuses1852484prospectus_e_s
prosperous1445474prosperou____s
prosperously1953034prosperous__ly
amorousness1347285amo___rousness
amorphousness2052855amorp_housness
blasphemousness247975blasphemousness
copiousness1547805_co_p_iousness
covetousness1775225_co_vetousness
dangerousness1554435_dangerousness
desirousness1356875_des_irousness
dexterousness2154625_dexterousness
dolorousness1355355_do_lorousness
erroneousness1353715errone_ousness
fissiparousness1981065fissiparousness
floriferousness2191525floriferousness
gaseousness1246055_gas_e_ousness
generousness1356975__generousness
gorgeousness1454895_gorge_ousness
grievousness1654675gr__ievousness
idolatrousness1562215idolatrousness
imperiousness1756465__imperiousness
lecherousness1864075_lecherousness
lustrousness1255895_lus_trousness
monstrousness1584865_monstrousness
murderousness1653935_murderousness
mysteriousness1953435_mysteriousness
nauseousness1254755naus_e_ousness
numerousness1495695__numerousness
odoriferousness1961525odoriferousness
odorousness1245895__o_dorousness
operoseness1354835__o_peroseness
perspicuousness2162255perspicuousness
pestiferousness2081935pestiferousness
phosphoruses2253845phosphorus_e_s
piteousness1347265p__ite_ousness
plenteousness1554555plente_ousness
ponderousnesses1854615p_onderousnesses
portentousness1673535portentousness
posthumousness2162105p_osthumousness
prayerfulness2162685pr_ayerfulness
precariousness1854415precariousness
preciousness1648475pr__eciousness
precipitousness2192865precipitousness
precociousness2054215precociousness
predaceousness1963095predaceousness
prestigiousness1872835prestigiousness
previousness1757055pr__eviousness
promiscuousness2161545promiscuousness
propernesses1645015pro_pernesse_s
propertyless195985pro_per_tyless
prosperities1655485prosper_itie_s
rapturousness1554285_rapturousness
ravenousness15115235_r_avenousness
rigorousness1355745_r_igorousness
seriousness11410165___s_eriousness
slanderousness1563025slanderousness
sonorousness1256275_so_norousness
speciousness1647555___speciousness
spuriousness1467235___spuriousness
treacherousness20111625treacherousness
troublousness1553405tro_ublousness
unseriousness1356425_uns_eriousness
uproariousness1653745upro_ariousness
vaporousness1755535__vaporousness
vociferousness2272355vociferousness
wondrousness1655305_wo_ndrousness

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 Filter178691950240.360496363.9
2DLD Change Limit95024765.86016215.7
3Display Results76760.0461652.2
 (SQL Overall)178691766.26628517.6
 
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.