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

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

47 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
nonconsolidated1981521nonconsolidated_
unconsolidated1862033_unconsolidated_
consolidated1663314___consolidated_
reconsolidated18132134_reconsolidated_
consolidate1463795___consolidate__
consolidates1563865___consolidate_s
noncomplicated2362615nonco_mplicated_
reconsolidate16122295_reconsolidate__
reconsolidates17122225_reconsolidate_s
consociated1645216___consoci_ated_
consolidating1753286___consolidating
consolidation1655156___consolidation
consolidator1553286___consolidat_or
consolidators1653296___consolidators
nonassociated1662226non_associ_ated_
noncandidate1662706noncan__didate__
noncandidates1762606noncan__didate_s
nonconjugated2462126noncon__jugated_
reconsolidating1962016_reconsolidating
conciliated1645647___concili_ated_
consociate1446857___consoci_ate__
consociates1546547___consoci_ate_s
consolidations1754747___consolidations
constipated1645467___cons_tipated_
disconsolate1563167disconsol__ate__
disconsolately2071547disconsol__ately
mononucleated1862197mon_onucl_eated_
nonaffiliated2062007non_affili_ated_
noncertificated2381257noncertificated_
noncollegiate1662077noncollegi_ate__
noncommitted1962847nonco__mmi_tted_
nonconditioned1862687nonconditi_oned_
nonconflicting2261927noncon_fli_cting
nonconformed2093557nonconfo___rmed_
nonconservation2063097noncons_ervation
nonconservative2372847noncons_ervative
noncontrolled1662057noncontrol___led_
noncorporate1664567noncorpo__rate__
noncultivated1962927nonc__ultivated_
nonmyelinated1961307non__myelinated_
nonnucleated1552667non__nucl_eated_
uncomplicated2253767_unco_mplicated_
unconsecrated1853307_uncons_ecrated_
unconsidered1651977_uncons__idered_
unconstricted1853367_unconstri_cted_
unconsummated2062007_uncons_ummated_
uncontaminated1972837_uncontaminated_

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 Filter178691950240.343520965.0
2DLD Change Limit95024478.89010688.9
3Display Results47470.0461021.7
 (SQL Overall)178691479.27919257.6
 
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.