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

93 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
illogicalnesses1871661illogicalnesses_
illogicalness1662143illogicalne_s_s_
logicalnesses1653193__logicalnesses_
ironicalnesses1662584i_ronicalnesses_
colonialnesses1653055coloni_alnesses_
identicalnesses1882425identicalnesses_
illiberalnesses1791555illiberalnesses_
illogicalities17132525illogical_ities_
localnesses1345855__lo__calnesses_
logicalness1453245__logicalne_s_s_
lyricalnesses1853105__lyricalnesses_
criticalnesses1853156_criticalnesses_
ethicalnesses1853206__ethicalnesses_
fanaticalnesses2082316fanaticalnesses_
finicalnesses1853836__finicalnesses_
illusivenesses1755786illusi_venesses_
initialnesses1395616i_niti_alnesses_
ironicalness1463086i_ronicalne_s_s_
loginesses11410326__logi___nesses_
palatialnesses1653386palati_alnesses_
physicalnesses2461946_physicalnesses_
pictorialnesses1962146pictori_alnesses_
poeticalnesses1853106_poeticalnesses_
practicalnesses2162956practicalnesses_
radicalnesses16124146__radicalnesses_
typicalnesses2062546__typicalnesses_
verticalnesses1953676_verticalnesses_
vocalnesses1645096__vo__calnesses_
whimsicalnesses2561336whimsicalnesses_
algidnesses1345167_al_gi__dnesses_
allegoricalness1871097allegoricalne_s_s_
allusivenesses1755197allusi_venesses_
belongingnesses1961457belongi_ngnesses_
bloodinesses1544277bloodi___nesses_
blowinesses1635987_blowi___nesses_
bulginesses1466137bul_gi___nesses_
choicenesses1944677_cho_ic_enesses_
colonialness1453467coloni_alne_s_s_
colorfulnesses1993837colo_rfulnesses_
cordialnesses1654577__cordialnesses_
diabolicalness1971297diabolicalne_s_s_
equivocalnesses2971217equivocalnesses_
exoticnesses2142687_exotic__nesses_
feloniousnesses1855157feloniousnesses_
floridnesses1654137_flori__dnesses_
formalnesses1744487__fo_rmalnesses_
gloominesses1544127gloomi___nesses_
gloriousnesses1556917_gloriousnesses_
hillinesses1458507hill__i___nesses_
historicalness1962137historicalne_s_s_
identicalness1662667identicalne_s_s_
illiberalness1561897illiberalne_s_s_
illnesses937287i_l_____lnesses_
illogical1245417illogical_______
illogicality1862177illogical____ity
illogically1746387illogical_____ly
illusorinesses1461657ill_usorinesses_
imaginarinesses1861677i_maginarinesses_
implicitnesses2061817i_mplicitnesses_
impolitenesses1853957impoli_tenesses_
intricatenesses1763317i_ntricatenesses_
legginesses1345297_leggi___nesses_
liberalnesses1554267__liberalnesses_
licitnesses1346417__l__icitnesses_
liltingnesses1453577lil_ti_ngnesses_
literalnesses1355247__literalnesses_
litigiousnesses1684117litigiousnesses_
localness1145237__lo__calne_s_s_
logicalities1555057__logical_ities_
logicless1242527__logic_l_e_s_s_
looninesses1197997_looni___nesses_
loopinesses13116737_loopi___nesses_
lovingnesses1643677__lovi_ngnesses_
lyricalness1653017__lyricalne_s_s_
materialnesses1653917materi_alnesses_
melodiousnesses1855057melodiousnesses_
obligingnesses1872017obligi_ngnesses_
ovalnesses1346057___o__valnesses_
plentifulnesses2093177plentifulnesses_
regalnesses1246197__reg__alnesses_
religiousnesses1655567religiousnesses_
sillinesses1169847sill__i___nesses_
slanginesses1346967slangi___nesses_
slicknesses1745197_sl__ic_knesses_
slothfulnesses2053467_slothfulnesses_
slouchinesses1842807_slo_uchinesses_
sluggishnesses1852147sluggi_shnesses_
specialnesses1753867_speci_alnesses_
venialnesses1555707__veni_alnesses_
villainesses1543517vill____ainesses_
vitalnesses1456277____vitalnesses_
willfulnesses1953887will___fulnesses_
willingnesses1753177will__i_ngnesses_

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 Filter178691950240.360496363.9
2DLD Change Limit95024937.18613223.5
3Display Results93930.0761223.7
 (SQL Overall)178691937.62223444.1
 
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.