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

35 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
reconsolidating1962011reconsolidating_
consolidating1753283__consolidating_
reconsolidate16122294reconsolidat___e
reconsolidated18132134reconsolidat__ed
reconsolidates17122224reconsolidat__es
consociating1755575__consoci_ating_
consolidation1655155__consolidati_on
consolidations1754745__consolidations
reconsecrating1954195recons_ecrating_
reconsidering1752325recons__idering_
reconsoling1444485reconsol____ing_
reconstituting1763235recons_tituting_
reconsulting1554215reconsul___ting_
recontaminating2062765recontaminating_
conciliating1775626__concili_ating_
consolidate1463796__consolidat___e
consolidated1663316__consolidat__ed
consolidates1563866__consolidat__es
consolidator1553286__consolidat__or
consolidators1653296__consolidat_ors
constipating1775396__cons_tipating_
deconsecrating2053636decons_ecrating_
decontaminating2162766decontaminating_
reconcentrating2063346reconcentrating_
reconciliation1854126reconcili_ati_on
reconciliations1953746reconcili_ations
reconnoitering1761646reconno_itering_
reconnoitring1672106reconno_i_tring_
reconsigning1653446recons__i_gning_
reconstructing1974436recons_tructing_
reconvicting20114626recon__vi_cting_
remonstrating1695556remons__trating_
renominating1546426re__n_ominating_
revalidating1744186re___validating_
unconsolidated1862036unconsolidat__ed

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.326548131.9
2DLD Change Limit65874355.53011912.1
3Display Results35350.0331060.6
 (SQL Overall)178691355.88930343.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.