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

62 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
collectivists206366(None) 
collectivises2063731collectivises
collectivisms2263241collectivisms
collectivist1964621collectivist_
collectivise1953902collectivis_e
collectivised2162762collectivised
collectivism2163742collectivis_m
collectivistic2082442collectivistic
collectivity2254232collectivi_ty
collectivizes2963312collectivizes
collectives1846033collectiv__es
collectivising2271903collectivising
collectivities2174163collectivities
collectivize2863293collectivi_ze
collectivized3062613collectivized
objectivists2663383_objectivists
collectibles1883614collecti_bles
collections1547934collect__ions
collective1747124collectiv___e
collectively22114624collectiv_ely
collectivizing3182034collectivizing
connectivity2254554connectivi_ty
objectivisms2863184_objectivisms
objectivist2553874_objectivist_
subjectivists27193374subjectivists
activists1497045____activists
belletrists1352825belle_t_rists
coalitionists1583945coal_itionists
colectomies1756765co_lectomi_es
coleopterists1762385coleopterists
collagists1345265coll___agists
collectables18103355collect_ables
collectedness1863705collectedness
collectible17104515collect__ible
collecting1548285collect__i_ng
collection1448205collect__i_on
collectors1446595collect___ors
collects12279785collec_____ts
colloquists2253005coll__oquists
comparativists2361795comparativists
conductivity2353785conductivi_ty
connectives1847505connectiv__es
connectivities2164475connectivities
constructivists22223075constructivists
cornetists1245955corne_t__ists
cornettists1353095corne_t_tists
correctives1845575correctiv__es
eclecticisms1753115_eclecticisms
nonobjectivists2971825nonobjectivists
objectivism2753445_objectivis_m
objectivistic2962545_objectivistic
objectivity2853945_objectivi_ty
polemicists1774225po_le_micists
positivists1654195po__sitivists
reflectivity2353815reflectivi_ty
relativists1464555_rel_ativists
selectionists1556025_selectionists
selectivity1954785_selectivi_ty
solecists1187075so_lec___ists
subjectivises27184025subjectivises
subjectivisms29193125subjectivisms
subjectivist26174155subjectivist_

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.406440125.6
2DLD Change Limit124790629.25013490.8
3Display Results62620.0461347.8
 (SQL Overall)178691629.70218418.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.