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

83 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
collectedness186370(None) 
collectednesses2062592collectednesses
connectedness1884452connectedness
conceitedness1875163conceitedness
concertedness1855833concertedness
contentedness1655383contentedness
affectedness2153204_affectedness
cockeyedness2461834cocke_yedness
coldheartedness2273124coldheartedness
collectables18103354collectable_s
collectanea1552794collect_ane_a
collected1447974collected____
collectedly1983014collected__ly
collectibles1883614collectible_s
collections1547934collection__s
collectives1846034collect_ive_s
collectivises2063734collectivises
completeness1854634comple_te_ness
complicatedness24102074complicatedness
connectednesses2063354connectednesses
correctness1553814correct__ness
dejectedness2353564_dejectedness
directedness1654264_directedness
expectedness2453324_expectedness
belatedness1444865_bel_atedness
blessedness1452365__blessedness
bullheadedness2172555bullheadedness
calculatedness1961525calculatedness
celebratedness1962175celebratedness
centeredness1554255cente_redness
cleverness1543225c__le_verness
coldness1137955co_l____dness
colectomies1756775co_lectomie_s
collectable17104905collectable__
collectible17104515collectible__
collecting1548285collect_in__g
collection1448205collection___
collective1747125collect_ive__
collectively22114625collect_ively
collectivise1953905collect_ivise
collectivised2162765collectivised
collectivism2163745collect_ivism
collectivisms2263245collectivisms
collectivist1964625collect_ivist
collectivists2063665collectivists
collectivizes2963315collectivizes
collectors1446595collect___ors
collects12279785collect_____s
colleens1036845colle__e_n__s
colleted113011665colle_ted____
compactness1953305compact__ness
composedness1952395co_mposedness
conceitednesses2063695conceitednesses
concertednesses2064215concertednesses
concreteness1655055concrete_ness
confectioners2073375confectioners
confirmedness2162495confirmedness
confusedness1852475co_nfusedness
contentednesses1863745contentednesses
contriteness1456455contrite_ness
covertness1545505co_vert__ness
delightedness1953385delightedness
dementedness1654675_dementedness
elatedness1146035__el_atedness
hotheadedness2163685hotheadedness
indebtedness1654525_indebtedness
jointedness1954065jo__intedness
limitedness1453895__limitedness
notedness1047325no____tedness
oblateness1244895_obl_ate_ness
outdatedness1453755_outdatedness
pervertedness1963275pervertedness
pointedness1445095po__intedness
politeness1247985po_l_ite_ness
possessedness1461805possessedness
relatedness1245605_rel_atedness
repleteness1354175reple_te_ness
rootedness1144905ro___otedness
selectness1245455_select__ness
stiltedness1253795stil__tedness
unaffectedness2372085unaffectedness
unexpectedness2672315unexpectedness
wontedness1445505wo___ntedness

Search took 10 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.423422437.4
2DLD Change Limit124790838.75014261.7
3Display Results83830.0631317.5
 (SQL Overall)178691839.23619347.2
 
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.