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

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

39 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
conscious134759(None) 
consciouses1554562consciouses
consciously1855832consciously
couscous1246682cousc_ous
monecious1376342monecious
unconscious1552892unconscious
bodacious1443993bodacious
capacious1546603capacious
censorious1243673censorious
coccous1039003co__ccous
coercions1346203coercions
conations111318903conations
conchos144313963con_cho_s
concours1239473con_c_ours
congius103210073con_gi_us
congous103615083con__gous
congruous1244343congruous
conscribes1645193conscribes
conscripts1644593conscripts
consensus1144923consensus
consigns1137533cons_igns
consists10310593cons_ists
consols92914073cons__ols
conspicuous1752673conspicuous
conspires1358483conspires
contagious1345353contagious
copious11311963co__pious
luscious1044853_luscious
minacious1346183minacious
monoecious1444773monoecious
monoicous1345973monoicous
monstrous1187353monstrous
nonconscious1663733nonconscious
nonserious1046623nonserious
osmious936003_o_smious
preconscious1852903preconscious
subconscious1862063subconscious
tenacious1146423tenacious
voracious1445503voracious

Search took 8 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 Filter1786911486410.1561145455.1
2DLD Change Limit148641397.59319576.1
3Display Results39390.0162437.5
 (SQL Overall)178691397.76523012.4
 
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.