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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

170 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
mercurialnesses1981431mercurialnesses_
mercurialness1761673mercurialne_s_s_
materialnesses1653915m_aterialnesses_
mercifulnesses2154275merc_ifulnesses_
merrinesses1358265mer__ri__nesses_
circularnesses1861416circu_larnesses_
cordialnesses1654576cor__dialnesses_
corporealnesses1961886corporealnesses_
enduringnesses1662496_enduringnesses_
eternalnesses1353696_e_ternalnesses_
etherealnesses1762316_etherealnesses_
excursivenesses2794736_excursivenesses_
marchionesses2052366marc_hi_onesses_
mercenarinesses1961776mercenarinesses_
mercilessness1753466merc__i_l_essness
mercilessnesses18104536mercilessnesses_
mercurials1453076mercurial_____s_
naturalnesses1354256_natur_alnesses_
neutralnesses1354356ne__utralnesses_
pictorialnesses1962146pictorialnesses_
recursivenesses2055346re_cursivenesses_
securenesses1445676se_cur__enesses_
serriednesses1454276ser__riednesses_
specialnesses1753866spec__ialnesses_
terriblenesses1694396ter__riblenesses_
venialnesses1555706ve___nialnesses_
verticalnesses1953676ver_ticalnesses_
accuratenesses1853087_accuratenesses_
accursednesses1961777_accursednesses_
acridnesses1445787__ac_ri_dnesses_
bearishnesses1844847be__arishnesses_
beautifulnesses2083457be_autifulnesses_
beerinesses1398927be__eri__nesses_
brutishnesses1844097_br_utishnesses_
casualnesses1443787___casualnesses_
chillnesses1644727___c_hillnesses_
civilnesses1644857___civi_lnesses_
coercivenesses2165657coerc__ivenesses_
colonialnesses1653057_colonialnesses_
crispnesses1545947___c_rispnesses_
criticalnesses1853157_criticalnesses_
cruelnesses1346257___c_ruelnesses_
curablenesses17146997___curablenesses_
curiousnesses1549017___curiousnesses_
curlinesses1338737___cur_linesses_
cursednesses1554977___cursednesses_
cursivenesses1847507___cursivenesses_
cursorinesses1553297cursori__nesses_
curtnesses1238377___cur__tnesses_
decisivenesses2056767de_cisivenesses_
decorousnesses1756567de_corousnesses_
delusivenesses1856547de_lusivenesses_
demurenesses1544757de_mur__enesses_
derisivenesses1857237der_isivenesses_
drearinesses1347447_dreari__nesses_
eerinesses10612607_e__eri__nesses_
effusivenesses2355747_effusivenesses_
elusivenesses1697707_e_lusivenesses_
erosivenesses1648317_er_osivenesses_
essentialnesses1462647essentialnesses_
ethicalnesses1853207_e_thicalnesses_
evilnesses1346007_e___vi_lnesses_
exclusivenesses2764667_exclusivenesses_
excusablenesses2664017_excusablenesses_
factualnesses1853697_fac_tualnesses_
fearfulnesses1945317fe__arfulnesses_
fertilenesses1648037fer__tilenesses_
fervidnesses1943847fer__vi_dnesses_
feverishnesses2382887fe_verishnesses_
forcefulnesses2254177forc_efulnesses_
forciblenesses2154197forc__iblenesses_
formalnesses1744487___formalnesses_
frailnesses1447597_fr__ai_lnesses_
fruitinesses1546447_fr_u_itinesses_
furrinesses1437187fur__ri__nesses_
genericnesses1652747ge_neri_cnesses_
genuinenesses1475307ge_nu_inenesses_
germinesses1437887ger__mi__nesses_
gradualnesses1552887_gr_adualnesses_
herculeses15113017hercu___l_e_ses_
horriblenesses1953907hor__riblenesses_
horridnesses1644467hor__ri_dnesses_
hurriednesses1752877hur__riednesses_
incuriousnesses1756557_incuriousnesses_
initialnesses1395617__initialnesses_
ironicalnesses1662587_ironicalnesses_
jerkinesses2246057jer__ki__nesses_
leerinesses11119487le__eri__nesses_
leisurelinesses1581047leisurelinesses_
liberalnesses1554267_liber_alnesses_
literalnesses1355247_liter_alnesses_
localnesses1345857_loc___alnesses_
luridnesses1246727___luri_dnesses_
lyricalnesses1853107lyr__icalnesses_
manfulnesses1745837manfu___lnesses_
marshinesses1744967mar_shi__nesses_
masterfulnesses2053297masterfulnesses_
materialness1454667m_aterialne_s_s_
meagernesses1544447meager___nesses_
mealinesses13310977me_____alinesses_
meannesses12128167me_____annesses_
meatinesses13311987me__ati__nesses_
memorablenesses2154837me_morablenesses_
memorialises1655547me_morial__ises_
mercerises1446197merceri_____ses_
merchandises2072897merc__ha_ndises_
mercifulness1964417merc_ifulne_s_s_
merciless1344477merc__i_l_e_s_s_
mercilessly1852187merc__i_l_ess_ly
mercurates1446857mercur_a____tes_
mercurial1354737mercurial_______
mercurially1852867mercurial_____ly
mercuries1347277mercuri______es_
merriness1138297mer__ri__ne_s_s_
messinesses1297517me__ssi__nesses_
mirinesses121512317m___iri__nesses_
mirthfulnesses2253647mir_thfulnesses_
morbidnesses1743977mor__bi_dnesses_
mournfulnesses1963427m__ournfulnesses_
mousinesses13129837m__ousi__nesses_
mulishnesses1755097m___ulishnesses_
murderousnesses1853617murderousnesses_
murkinesses17136787m___ur_kinesses_
nerdinesses1249057ner__di__nesses_
nervinesses1437327ner__vi__nesses_
obscurenesses1752737obscur__enesses_
ornerinesses1246577_orneri__nesses_
palatialnesses1653387_palatialnesses_
pastoralnesses1653137pastor_alnesses_
peacefulnesses2154707peac_efulnesses_
penuriousnesses1756657pe_nuriousnesses_
pepperinesses1653277pepperi__nesses_
perkinesses1748927per__ki__nesses_
pervasivenesses2355207pervasivenesses_
perversenesses1952667perver_senesses_
pervertednesses2162767pervertednesses_
practicalnesses2162957practicalnesses_
precisenesses1756287prec__isenesses_
prudishnesses1943677_pr_udishnesses_
radicalnesses16124147__radicalnesses_
reactivenesses1956927reac_tivenesses_
realnesses10310857_____realnesses_
reclusivenesses2055287reclusivenesses_
reductivenesses21145727reductivenesses_
regalnesses1246197__r__egalnesses_
retiringnesses1552487re_tiringnesses_
ruefulnesses1545937__r_uefulnesses_
scarinesses1339907__scari__nesses_
scurvinesses1743937__scur_vinesses_
seclusivenesses1965057seclusivenesses_
secretivenesses2055687secretivenesses_
seductivenesses21145477seductivenesses_
servilenesses1646307ser__vilenesses_
shrillnesses1543507___shrillnesses_
sorrinesses11310097sor__ri__nesses_
tarrinesses11129087tar__ri__nesses_
tearfulnesses1645537te__arfulnesses_
tearinesses11311697te__ari__nesses_
tetchinesses1753557tetc_hi__nesses_
torridnesses1344657tor__ri_dnesses_
universalnesses1881927universalnesses_
unnaturalnesses1561667unnatur_alnesses_
unrulinesses1245807unr_uli__nesses_
unusualnesses1353077__unusualnesses_
usualnesses1144697____usualnesses_
venturousnesses1854867venturousnesses_
versatilenesses1853647versatilenesses_
vocalnesses1645097_voc___alnesses_
wearifulnesses2054657we__arifulnesses_
wearinesses14310217we__ari__nesses_

Search took 10 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 Limit950241709.06310484.8
3Display Results1701700.1261349.2
 (SQL Overall)1786911709.54518720.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.