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

69 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
conscientiously2271381conscientiously_
conscientious17102263conscientious___
contentiously1854174con__tentiously_
consciously1855835consc____iously_
compendiously2362216co__mpendiously_
consentaneously2071526cons__entaneously_
consentingly1854666cons__enti_ngly_
conspicuously2292226conspi__cuously_
contentious1347016con__tentious___
continuously1754396con_ti_n_uously_
contumeliously2171146contume_liously_
licentiously1753646__lic_entiously_
nonscientist1474146nonscienti__s__t
nonscientists1572676nonscienti__s_ts
sententiously1663556sen__tentiously_
tendentiously1762416ten__dentiously_
cancerously1854417can_c_e__rously_
censoriously1753837cens___oriously_
concentrically2063777con_c_entrically_
conceptional1856917con_c_eptional__
conceptions17410597con_c_eptions___
concretionary2062867con_cre_tionary_
concretions1549297con_cre_tions___
confidentially2372977confidenti_ally_
conscienceless177747conscienceles__s
consciences1447027conscien__ces___
conscious1347597consc____ious___
consciouses1554567consc____ious_es
conscriptions1955007conscriptions___
consequentially2971807consequenti_ally_
consignations16105937cons_ignations___
consociational1853557consoci_ational__
consociations1747517consoci_ations___
conspirational1853967conspirational__
conspirations1747727conspirations___
constipations1747687constipations___
constitutional1663097constitutional__
constitutionals1761877constitutional_s
constitutions1554867constitutions___
constitutively2262297constituti_vely_
contagiously1854317con___tagiously_
contemptuously2381647con_temptuously_
contentions13412097con__tentions___
contentiousness1763557con__tentiousness
conterminously2161907con__terminously_
contiguously1853457con_ti__guously_
contumaciously2361827con_tumaciously_
conventional1757167con__ventional__
conventionally2254987con__ventionally
conventions16410537con__ventions___
covetously1854327co___ve_t_ously_
facetiously1954587__fac_e_tiously_
ignominiously1961917ignomi_n_iously_
incautiously1753977_in_c_autiously_
incestuously1762837_in_c_estuously_
infectiously2054087_in__fectiously_
ingeniously1555497_in__gen_iously_
insidiously1555047_ins_i__diously_
lasciviously2052677_lasci__viously_
momentously1853367mo___ment_ously_
monstrously1654077mons____trously_
nonscientific2071717nonscienti___fic
obsequiously2662147_obs__equiously_
ostentatiously1781837_o_s_tentatiously_
portentously1753457po__rtent_ously_
pretentiously1883787__pretentiously_
solicitously1793437solici__t_ously_
unconsciously2083017unconsc____iously_
unpretentiously2071507unpretentiously_

Search took 9 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 Limit95024698.28311472.2
3Display Results69690.0461500.0
 (SQL Overall)178691698.68920565.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.