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

68 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
conscientiously227138(None) 
conscientious17102262conscientious__
contentiously1854173con__tentiously
consciously1855834consc____iously
compendiously2362215co__mpendiously
consentaneously2071525cons__entaneously
consentingly1854665cons__enti_ngly
conspicuously2292225conspi__cuously
contentious1347015con__tentious__
continuously1754395con_ti_n_uously
contumeliously2171145contume_liously
licentiously1753645__lic_entiously
nonscientist1474145nonscienti__s_t
nonscientists1572675nonscienti__sts
sententiously1663555sen__tentiously
tendentiously1762415ten__dentiously
cancerously1854416can_c_e__rously
censoriously1753836cens___oriously
concentrically2063776con_c_entrically
conceptional1856916con_c_eptional_
conceptions17410596con_c_eptions__
concretionary2062866con_cre_tionary
concretions1549296con_cre_tions__
confidentially2372976confidenti_ally
conscienceless177746conscienceles_s
consciences1447026conscien__ces__
conscious1347596consc____ious__
consciouses1554566consc____iouses
conscriptions1955006conscriptions__
consequentially2971806consequenti_ally
consignations16105936cons_ignations__
consociational1853556consoci_ational_
consociations1747516consoci_ations__
conspirational1853966conspirational_
conspirations1747726conspirations__
constipations1747686constipations__
constitutional1663096constitutional_
constitutionals1761876constitutionals
constitutions1554866constitutions__
constitutively2262296constituti_vely
contagiously1854316con___tagiously
contemptuously2381646con_temptuously
contentions13412096con__tentions__
conterminously2161906con__terminously
contiguously1853456con_ti__guously
contumaciously2361826con_tumaciously
conventional1757166con__ventional_
conventionally2254986con__ventionally
conventions16410536con__ventions__
covetously1854326co___ve_t_ously
facetiously1954586__fac_e_tiously
ignominiously1961916ignomi_n_iously
incautiously1753976_in_c_autiously
incestuously1762836_in_c_estuously
infectiously2054086_in__fectiously
ingeniously1555496_in__gen_iously
insidiously1555046_ins_i__diously
lasciviously2052676_lasci__viously
momentously1853366mo___ment_ously
monstrously1654076mons____trously
nonscientific2071716nonscienti__fic
obsequiously2662146_obs__equiously
ostentatiously1781836_o_s_tentatiously
portentously1753456po__rtent_ously
pretentiously1883786__pretentiously
solicitously1793436solici__t_ously
unconsciously2083016unconsc____iously
unpretentiously2071506unpretentiously

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.360496363.9
2DLD Change Limit95024688.67310956.3
3Display Results68680.0461478.3
 (SQL Overall)178691689.07919681.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.