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

61 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
consolidations175474(None) 
consolidation1655151consolidation_
consociations1747512consoci_ations
consolations1449742consol__ations
consolidating1753282consolidati_ng
consolidators1653292consolidat_ors
conciliations1747203concili_ations
consociation1648193consoci_ation_
consolation13410983consol__ation_
consolidates1563863consolidat__es
consolidator1553283consolidat_o_r
conspirations1747723cons_pirations
constipations1747683cons_tipations
consultations1546933consul_tations
podsolizations26164373podsolizations
canalizations24410434can_alizations
canonizations2447244can_onizations
colligations1556844co__lligations
collimations1656874co__llimations
colonisations15216174co_lonisations
colonizations24229424co_lonizations
colorizations241410354co_lorizations
complications2147434co_mplications
conciliation1648234concili_ation_
condonations1548004condo__nations
conflations16411144con_fl__ations
conflictions1945224con_fli_ctions
conformations2046724confo_rmations
congelations1549734congel__ations
conglobations1853944con_globations
connotations1447284conno__tations
conscriptions1955004conscri_ptions
consecrations1749214cons_ecrations
conservations1849094cons_ervations
considerations1764844considerations
consignations16105934cons_ignations
consociating1755574consoci_ati_ng
consociational1853554consoci_ational
consolidate1463794consolidat___e
consolidated1663314consolidat__ed
conspiration1648384cons_piration_
constellations1654404constellations
consternations16116044consternations
constipation1648564cons_tipation_
constitutions1554864cons_titutions
constrictions1747784constri_ctions
consultation1447474consul_tation_
consummations1955154cons_ummations
contaminations1886104contaminations
convocations1947364convo__cations
convolutions1745194convol__utions
creolizations2457884c_reolizations
cuspidations1743344c_us_pidations
fossilizations2654684fossilizations
insolations1149184_insol__ations
invalidations1745624_invalidations
monopolizations2893394monopolizations
nonsolutions1254174nonsol__utions
podsolization25165004podsolization_
podzolizations25153874podzolizations
reconsolidating1962014reconsolidati_ng

Search took 5 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 Limit65874613.73317646.4
3Display Results61610.0302033.3
 (SQL Overall)178691614.09343657.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.