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

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

37 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
mountainousness1772011mountainousness_
mutinousness1455654m_u_t_inousness_
bounteousness1554515bount__eousness_
contagiousness1784015co_ntagiousness_
continuousness16103725co_nt_inuousness_
monotonousness1662205mo_notonousness_
mountainous1352835mountainou____s_
mountainously1862295mountainou___sly
mutinousnesses1655185m_u_t_inousnesses
bounteousnesses1753996bount__eousnesses
bountifulness1853156bount_i_fulness_
cautiousness1447936cau_t_i_ousness_
consciousness17126596co_nsci_ousness_
contiguousness1783136co_ntiguousness_
courageousness1762516cou_rageousness_
courteousness1554616court__eousness_
fortuitousness1783106fo_rtuitousness_
gelatinousness1563406gelat_inousness_
gluttonousness1561866glu_ttonousness_
luminousness1455256_lu__minousness_
magnanimousness2071356magnanimousness_
mendaciousness1954256m_endaciousness_
momentousness1754276moment___ousness_
monstrousness1584866mo_n_strousness_
mountaineers14122506mountain___eers_
mountainsides1661306mountain__sides_
numinousness1455276___numinousness_
obnoxiousness22103746_obnoxi_ousness_
oleaginousness1562536_oleaginousness_
ominousness1356086_o___minousness_
outrageousness1562166_outrageousness_
robustiousness1663376robust_i_ousness_
roundaboutness177676rounda_boutness_
ruinousness1156376_ru___inousness_
spontaneousness1771716spontaneousness_
villainousness1761986_villainousness_
voluminousness1962476vo_luminousness_

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.330541487.9
2DLD Change Limit65874375.01313140.6
3Display Results37370.0331121.2
 (SQL Overall)178691375.37633238.7
 
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.