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

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

106 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
learnednesses144364(None) 
beardednesses1744142beardednesses
learnedness1243862learnedne_s_s
earnestnesses1353663_earnestnesses
elatednesses1346113ela_tednesses
guardednesses1653233guardednesses
hornednesses1645513_hornednesses
largenesses1247553l_arge_nesses
leadennesses1354573lea_dennesses
leannesses10108343lea_n__nesses
markednesses1944183_markednesses
peakednesses1945043pea_kednesses
serriednesses1454273serriednesses
adaptednesses1772624adaptednesses
agednesses1237414__a_gednesses
aridnesses1139944__ar_idnesses
awarenesses1447254awar_e_nesses
barenesses12311704_bar_e_nesses
barrennesses1443434_barrennesses
beardedness1544594beardedne_s_s
bearishnesses1844844bearishnesses
belatednesses1644334belatednesses
blandnesses1446624bla_n_dnesses
blearinesses1446544blear__inesses
blessednesses1552854ble_ssednesses
cleanlinesses1553884clea_nlinesses
cleannesses13135824clea_n__nesses
clearnesses13106154clear___nesses
coarsenesses1447244coarse_nesses
crabbednesses2072944crabbednesses
cursednesses1554974_cursednesses
datednesses1357904_da_tednesses
dazednesses2245154_da_zednesses
deadnesses1238944dea___dnesses
dearnesses1139584dear___nesses
decidednesses1853894decidednesses
dementednesses1853814dementednesses
depravednesses2152374depravednesses
deservednesses19163484deservednesses
detachednesses2152014detachednesses
detailednesses1653204detailednesses
devotednesses1853274devotednesses
eagernesses1246984_ea_gernesses
earlinesses11311054_ear_linesses
earthinesses1545824_earthinesses
earwitnesses1543784_earwitnesses
eyednesses1445814_e__yednesses
fadednesses16126564_fa_dednesses
fearfulnesses1945314fearfulnesses
fearlessnesses1666744fearlessnesses
fervidnesses1943844fe_rvidnesses
grandnesses1348114gra_n_dnesses
handednesses1765644_handednesses
hardnesses141810544_har__dnesses
heartinesses1548004hear_tinesses
hoarsenesses1545604hoarse_nesses
hurriednesses1752874hurriednesses
inanenesses1149524ina_ne_nesses
jadednesses20145774_ja_dednesses
jaggednesses2242794_jaggednesses
jejunenesses1852624jejune_nesses
lamenesses12610564l_a_me_nesses
lankinesses1539014l_a_nkinesses
lanknesses1437504l_a_n_knesses
larkinesses1539004l_ar_kinesses
latenesses10413364l_a_te_nesses
laundresses1243114l_aun_dresses
leafinesses1437874lea__finesses
leakinesses1538474lea__kinesses
leerinesses11119484leer__inesses
levelnesses1445554le__velnesses
lewdnesses1435394le___wdnesses
limitednesses1654014limitednesses
lonenesses10311344l__one_nesses
lornnesses1037824l_orn__nesses
luridnesses1246724l_ur_idnesses
mazednesses2345404_ma_zednesses
meagernesses1544444mea_gernesses
meannesses12128164mea_n__nesses
nakednesses1645844_na_kednesses
nearnesses1039114near___nesses
peartnesses1338744pear__tnesses
planenesses1349034pla_ne_nesses
preparednesses1963094prepar_ednesses
raggednesses1543864_raggednesses
rarenesses10313114_rar_e_nesses
rednesses10312314___r_ednesses
relatednesses1445004relatednesses
relaxednesses2152944relaxednesses
reservednesses18163324reservednesses
resignednesses1652134resignednesses
retirednesses1454584retirednesses
sacrednesses1544874_sacrednesses
sanenesses10412694_sa_ne_nesses
scarcenesses1644494scarce_nesses
serenenesses12117114se_renenesses
sparenesses1339174spar_e_nesses
sparsenesses1345804sparse_nesses
strandednesses1652824strandednesses
tearfulnesses1645534tearfulnesses
tearinesses11311694tear__inesses
tersenesses1149044te_rse_nesses
tirednesses1247744_tir_ednesses
vexednesses2244604ve__xednesses
wearinesses14310214wear__inesses
weirdnesses1545214weir__dnesses

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.360496363.9
2DLD Change Limit950241065.72016612.6
3Display Results1061060.0601766.7
 (SQL Overall)1786911066.14029102.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.