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

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
delightedness195338(None) 
benightedness2063182benightedness
delightednesses2162532delightednesses
delightfulness2261893delightfulness
belatedness1444864bel__atedness
benightednesses2262414benightednesses
decidedness16103794deci__dedness
definiteness16105044definite_ness
dejectedness2353564de_jectedness
delighted1546204delighted____
delightedly2062214delighted__ly
delighters1544364delight___ers
dementedness1654674de_mentedness
detachedness1952524detach_edness
devotedness1653704de__votedness
elatedness1146034_el__atedness
farsightedness2262064farsightedness
flightiness1843894_flight_iness
foresightedness2391914foresightedness
lighteners1444984__lighte_ners
lightness13107434__light__ness
limitedness1453894__limitedness
nearsightedness2091344nearsightedness
relatedness1245604rel__atedness
resignedness1452594resig_nedness
slightness1454804_slight__ness
weightiness1843264we_ight_iness
almightiness1851915almight_iness
brighteners1752865_brighte_ners
brightness1644575_bright__ness
celebratedness1962175celebratedness
collectedness1863705collectedness
datedness1187755d____atedness
daughterless176945d_aughterless
decisiveness1855925decisive_ness
delegatees1244275delegate__e_s
deliberateness1792685deliberate_ness
delicatessens1616775delicatessens
deliciousness16116635deliciousness
delighter1445585delight___e_r
delighting1644995delight_in__g
delights1347335delight_____s
delightsome186905delightsome__
deliriousness1496715deliriousness
delusiveness1655755delusive_ness
demigoddess175645demig__oddess
depravedness1952795de_pravedness
derisiveness1656965derisive_ness
deservedness1753485de_servedness
desolateness1354595desolate_ness
destituteness1462925destitute_ness
detailedness1453195de_tailedness
diluteness1145195d__ilute_ness
directedness1654265d_irectedness
dispiritedness1862415dispiritedness
dissipatedness1862645dissipatedness
dividedness1753315d__ividedness
doggedness1443515d__og_gedness
doughtiness1642705d_ought_iness
droughtiness1751915drought_iness
educatedness1652995_educatedness
eighteens1344885_e_ighte__ens
eighteenths1851425_e_ighteenths
enlightened1652325enlighte_ne_d
enlightens1443745enlighte_n__s
expectedness2453325_expectedness
flightless1773395_flight__less
gelidness1144475geli____dness
giftedness1543685__gi_ftedness
heightened1843015he_ighte_ne_d
heightens1644715he_ighte_n__s
indelicateness1763425indelicate_ness
jointedness1954065_joi_ntedness
knightliness2052735_knightliness
lightened1446025__lighte_ne_d
lightener1345695__lighte_ne_r
lightens122510005__lighte_n__s
lightless1386075__light__less
liteness82213215__li__te_ness
litheness1247365__lith_e_ness
longsightedness2181445longsightedness
mightiness1645095__might_iness
nightdress1552985__night_dress
pervertedness1963275pervertedness
petiteness1248495peti__te_ness
pointedness1445095_poi_ntedness
politeness1247985poli__te_ness
relaxedness1953285rel__axedness
reliableness1457135reliable_ness
relighted1436865relighted____
religiousness1486375religiousness
retightened1652435retighte_ne_d
retightens1453685retighte_n__s
retiredness1244175reti__redness
rightness13117355__right__ness
sightliness1574565__sightliness
spiritedness1553785_spiritedness
sprightliness1962095sprightliness
stiltedness1253795_sti_ltedness
tighteners1444045__tighte_ners
tightness1386605__tight__ness
unsightliness1762515unsightliness
uprightness1752855upright__ness
uptightness1752145uptight__ness
weightless1742715we_ight__less
weightlessness2162425we_ightlessness

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901068.22015181.3
3Display Results1061060.0601766.7
 (SQL Overall)1786911068.67020610.3
 
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.