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

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

83 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
ironicalnesses166258(None) 
ironicalness1463082ironicalne_s_s
criticalnesses1853153criticalnesses
finicalnesses1853833_finicalnesses
identicalnesses1882423identicalnesses
illogicalnesses1871663illogicalnesses
logicalnesses1653193_logicalnesses
radicalnesses16124143_radicalnesses
colonialnesses1653054coloni_alnesses
cordialnesses1654574cordi_alnesses
ethicalnesses1853204_ethicalnesses
initialnesses1395614i__nitialnesses
ironnesses1047834iron____nesses
localnesses1345854_lo__calnesses
lyricalnesses1853104_lyricalnesses
physicalnesses2461944physicalnesses
poeticalnesses1853104poeticalnesses
practicalnesses2162954practicalnesses
typicalnesses2062544_typicalnesses
venialnesses1555704_veni_alnesses
verticalnesses1953674verticalnesses
vocalnesses1645094_vo__calnesses
wrongfulnesses2153174wrongfulnesses
airsicknesses1952225air_sic_knesses
boninesses121111455_boni___nesses
brininesses1338985brini___nesses
broadnesses1446195bro___adnesses
choicenesses1944675cho_ic_enesses
concisenesses1746595_concisenesses
corninesses13410595corni___nesses
criticalness1653505criticalne_s_s
crunchinesses2052865crun_chinesses
drollnesses1244365dro___llnesses
erosivenesses1648315erosi_venesses
exoticnesses2142685exotic__nesses
fanaticalnesses2082315fanaticalnesses
finicalness1653615_finicalne_s_s
finickinesses2272065_finickinesses
formalnesses1744485_fo_rmalnesses
frailnesses1447595fr_ai__lnesses
franticnesses1843675frantic__nesses
gradualnesses1552885gr_adualnesses
grouchinesses1942655gro_uchinesses
horninesses1459005horni___nesses
identicalness1662665identicalne_s_s
illogicalness1662145illogicalne_s_s
implicitnesses2061815implicitnesses
inanimatenesses1762745inanimatenesses
intactnesses1444575i__ntactnesses
intricatenesses1763315intricatenesses
irasciblenesses1962605irasciblenesses
irritablenesses1755055ir_ritablenesses
logicalness1453245_logicalne_s_s
looninesses1197995looni___nesses
mooninesses13127945mooni___nesses
nicenesses12310355___nic_enesses
ovalnesses1346055__o__valnesses
phoninesses1636455phoni___nesses
pictorialnesses1962145pictori_alnesses
pricklinesses2143625pr__icklinesses
princelinesses1892725prin_celinesses
prolificnesses2151165prolificnesses
pronenesses1379265pron___enesses
pronucleuses1652015pronuc_l_euses
prosinesses13310855prosi___nesses
proximatenesses2662145proximatenesses
radicalness1454585_radicalne_s_s
rancidnesses1544885_ran_cidnesses
rationalnesses1452635_rationalnesses
realnesses10310855_r___ealnesses
regalnesses1246195_r__egalnesses
richnesses1537805_r__ic_hnesses
rockinesses1737365_ro__ckinesses
ropinesses121311025_ropi___nesses
rosinesses101213145_rosi___nesses
songfulnesses1754675_songfulnesses
specialnesses1753865speci_alnesses
stoninesses1138255stoni___nesses
tranquilnesses2352165tranquilnesses
trickinesses1845225tr__ickinesses
vitalnesses1456275___vitalnesses
whimsicalnesses2561335whimsicalnesses
wrongnesses1544925wron___gnesses

Search took 7 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.356501941.0
2DLD Change Limit95024836.28315124.0
3Display Results83830.0461804.3
 (SQL Overall)178691836.68526730.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.