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

46 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
unconsciousness1962271unconsciousness_
consciousness17126593__consciousness_
unconsciouses1761893unconscious_e_s_
consciousnesses1855814__consciousnesses
consciouses1554565__conscious_e_s_
incongruousness1861775incongruousness_
subconsciouses2071265subconscious_e_s_
unconscious1552895unconsciou____s_
unconsciously2083015unconsciou___sly
ungraciousness1753855un_graciousness_
anonymousness1862856an_on_ymousness_
atrociousness1555576atro__ciousness_
capaciousness1955996__capaciousness_
censoriousness1654346__censoriousness_
congruousness1654226__congruousness_
conspicuousness2162146__conspicuousness_
contagiousness1784016__contagiousness_
copiousness1547806__co__piousness_
euphoniousness1962706euphon__iousness_
feloniousness1655596felon__iousness_
ferociousness1856746fero__ciousness_
incautiousness1654076inc_autiousness_
incestuousness1693096inc_estuousness_
incuriousness1556296inc__uriousness_
ingeniousness1456036ingen__iousness_
injudiciousness2572156injudiciousness_
innocuousness1553886in__nocuousness_
licentiousness1654236licen_tiousness_
lusciousness1456316___lusciousness_
monstrousness1584866__monstrousness_
noxiousness1846776_n_o__xiousness_
perniciousness1855316_perniciousness_
precociousness2054216preco__ciousness_
preconsciouses2061746preconscious_e_s_
pugnaciousness1963186_pugnaciousness_
punctiliousness1972236punc_tiliousness_
saponaceousness1971576saponaceousness_
tenaciousness1556566__tenaciousness_
unconscionable2082696unconscio__nable
unconscionably2382366unconscio__nably
unctuousness1455336unc___tuousness_
unmelodiousness1891716unmelodiousness_
unseriousness1356426un__seriousness_
uproariousness1653746upro_ariousness_
uxoriousness1956326u_xo__riousness_
voraciousness18116746__voraciousness_

Search took 5 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.313570897.8
2DLD Change Limit65874464.29615333.8
3Display Results46460.0461000.0
 (SQL Overall)178691464.65538386.9
 
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.