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

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

80 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
commonnesses1810318(None) 
commonness1644362commonne_s_s
uncommonnesses2061282uncommonnesses
comelinesses1666403comelinesses
comfinesses1846913co_mfinesses
commonsense1752523commonsense_
coolnesses1237193co__olnesses
womannesses1644393wo_mannesses
callownesses1752454callownesses
calmnesses1436844calm__nesses
campinesses1737114c_ampinesses
canonesses1238414c_ano_nesses
chumminesses2142864chumminesses
clamminesses1873794clamminesses
cleannesses13135824c_leannesses
clumsinesses1644774clumsinesses
coarsenesses1447244coarsenesses
cockinesses1947564co_ckinesses
cohostesses1652544co_hostesses
coldnesses1338424co__ldnesses
commanderies1953384commanderies
commonages1745914commo_n_ages
commonalties1854244commonalties
commoners15339784commo_ne__rs
commonest1549254commo_ne_s_t
commonplaces2251744commonplaces
commonweals20112284commonwe_als
communises1646564comm_un_ises
compactnesses2153004compactnesses
complexnesses26112724complexnesses
composednesses2152284composednesses
compresses1647774co_m_presses
confesses1438624c___onfesses
copiousnesses1747804copiousnesses
corkinesses1749214co_rkinesses
corninesses13410594co_rninesses
cosinesses121012824co__sinesses
costlinesses1446254costlinesses
countesses1248844co__untesses
covertnesses1746334covertnesses
coynesses1437574c___oynesses
cozinesses21179504co__zinesses
cravennesses1744114cravennesses
crumminesses1843654crumminesses
demonesses1346704_demo_nesses
foaminesses1658074foam_inesses
forlornnesses1652574forlornnesses
formalnesses1744484formalnesses
gemminesses1634974gemm_inesses
goldennesses1443794goldennesses
goodnesses1236434go__odnesses
gumminesses1634934gumm_inesses
hamminesses1835774hamm_inesses
hollownesses1852284hollownesses
homelinesses1765364homelinesses
homeynesses1984814ho_meynesses
hominesses15510864ho_m_inesses
humannesses1643864_humannesses
ironnesses1047834__ironnesses
loaminesses1358454loam_inesses
looninesses1197994lo__oninesses
lornnesses1037824lo__rnnesses
meannesses12128164__meannesses
modernnesses1543864modernnesses
mooninesses13127944__mooninesses
mootnesses1237154__mootnesses
opennesses1246314_o_pennesses
pompousnesses1955464pompousnesses
poornesses1236804po__ornesses
roominesses1337434room_inesses
rottennesses1244424rottennesses
soddennesses1443204soddennesses
solemnnesses1443634solemnnesses
sombernesses1643614sombernesses
uncommonness1861704uncommonne_s_s
wantonnesses1542894wantonnesses
woodennesses1643654woodennesses
worminesses16127994worm_inesses
wornnesses1337134wo__rnnesses
yumminesses1843874yumm_inesses

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790806.75018487.4
3Display Results80800.0501600.0
 (SQL Overall)178691806.94025748.0
 
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.