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

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

139 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
dementednesses185378(None) 
dejectednesses2553042dejectednesses
dementedness1654662dementedne_s_s
deservednesses19163453deservednesses
devotednesses1853233de_votednesses
directednesses1863353directednesses
affectednesses2382584affectednesses
belatednesses1644314be_latednesses
contentednesses1863724contentednesses
datednesses1357894d___atednesses
decidednesses1853884de_cidednesses
definitenesses1864224definite_nesses
dejectedness2353554dejectedne_s_s
delightednesses2162514delightednesses
demurenesses1544744dem_ure_nesses
densenesses1247354d__ense_nesses
depravednesses2152364depravednesses
detachednesses2152004detachednesses
detailednesses1653184detailednesses
educatednesses1852784educatednesses
elatednesses1346094_e_latednesses
expectednesses2662914expectednesses
extendednesses2362614extendednesses
immensenesses1762984immense_nesses
indebtednesses1853384indebtednesses
jointednesses2174014_jointednesses
learnednesses1443624learn_ednesses
limitednesses1653994lim_itednesses
mindednesses16105384__mindednesses
pervertednesses2162734pervertednesses
pointednesses1654954_pointednesses
recentnesses1465364recent__nesses
relatednesses1444984re_latednesses
remotenesses1446794rem_ote_nesses
reservednesses18163294reservednesses
serenenesses12117094seren_e_nesses
stuntednesses1453924_stuntednesses
unwontednesses1852994unwontednesses
wontednesses1645984__wontednesses
adaptednesses1772615_adaptednesses
adequatenesses2462615adequate_nesses
beardednesses1744125be_ardednesses
benightednesses2262395benightednesses
blessednesses1552845_blessednesses
boundednesses1753935_boundednesses
centerednesses1753815centerednesses
collectednesses2062575collectednesses
composednesses2152285composednesses
conceitednesses2063675conceitednesses
concertednesses2064185concertednesses
connectednesses2063335connectednesses
daintinesses1346245d_aint_inesses
dazednesses2245155d___azednesses
deadnesses1238945d__e__adnesses
debonairnesses1771445debonairnesses
deceitfulnesses2173015deceitfulnesses
deceptivenesses23125875deceptivenesses
deepnesses1366675d__e__epnesses
defectivenesses2496055defectivenesses
defensivenesses2255745defensivenesses
deftnesses1436815d__eft__nesses
demandingnesses2061745demandingnesses
demigoddesses196545dem_igoddesses
demonesses1346705dem____onesses
deservedness1753475deservedne_s_s
desolatenesses1553965desolate_nesses
desperatenesses1863725desperate_nesses
devotedness1653695de_votedne_s_s
devoutnesses1683915devout__nesses
dilutenesses1346105d_ilute_nesses
directedness1654245directedne_s_s
directnesses1595265direct__nesses
diversenesses1754075diverse_nesses
dividednesses1952905d_ividednesses
doggednesses1643705d__oggednesses
donenesses11310565d__on_e_nesses
drunkennesses1861855d_runkennesses
effetenesses1854485_effete_nesses
emptinesses1545985_em_pt_inesses
erectnesses1347445_erect__nesses
evennesses1345925_even___nesses
eventfulnesses2054245_eventfulnesses
eyednesses1445805___e_yednesses
feeblenesses1745525fe_eble_nesses
femalenesses1746845fem_ale_nesses
femininenesses1952975femininenesses
fetidnesses1546645__fe_tidnesses
genteelnesses1453525__genteelnesses
gentlenesses1366005__gentlenesses
giftednesses1754005__giftednesses
handednesses1765645__handednesses
hornednesses1645505_horn_ednesses
humanenesses1744235human_e_nesses
intensenesses1356035intense_nesses
intentnesses1277125intent__nesses
jejunenesses1852625jejun_e_nesses
keennesses1445325ke_en___nesses
markednesses1944175__markednesses
mateynesses1645165__m_ateynesses
mazednesses2345405__m_azednesses
meagernesses1544435__meagernesses
meatinesses13311975__meat_inesses
meeknesses1644805__me__eknesses
meetnesses1237445__me__etnesses
minutenesses1476165__minute_nesses
momentarinesses1972345momentarinesses
momentousnesses1963595momentousnesses
mutenesses1289935__m_ute_nesses
notednesses1247775___notednesses
outdatednesses1652945outdatednesses
peakednesses1945025__peakednesses
petitenesses14169315pe_tite_nesses
presentnesses1554405present__nesses
relaxednesses2152935re_laxednesses
repletenesses1554475replete_nesses
resentfulnesses1883735resentfulnesses
resignednesses1652125resignednesses
retentivenesses1896365retentivenesses
retirednesses1454555re_tirednesses
rootednesses1345315__rootednesses
roundednesses1554285_roundednesses
secludednesses1882025secludednesses
sedatenesses1346945se_date_nesses
selectnesses1446105select__nesses
serriednesses1454245se_rriednesses
severenesses1545585seve_re_nesses
silentnesses1275445silent__nesses
slendernesses1453135_slendernesses
spiritednesses1753195spiritednesses
splendidnesses1871715splendidnesses
stiltednesses1454005_stiltednesses
strandednesses1652815strandednesses
sveltenesses1545215_svelte_nesses
temperatenesses19113135temperate_nesses
tendernesses1345065__tendernesses
tensenesses1147595__tense_nesses
unsettlednesses16102195unsettlednesses
uprootednesses1752325uprootednesses
vexednesses2244585__ve_xednesses

Search took 9 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.1261418182.5
2DLD Change Limit950241398.45011245.4
3Display Results1391390.156891.0
 (SQL Overall)1786911398.73220463.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.