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

98 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
expressiveness266412(None) 
excessiveness2554962ex_cessiveness
expensiveness2555582exp_ensiveness
impressiveness2164462impressiveness
oppressiveness2163472oppressiveness
repressiveness1964812repressiveness
aggressiveness1962663aggressiveness
digressiveness1963373digressiveness
expansiveness2554303exp_ansiveness
explosiveness2553683exp_losiveness
expressionless2361923expressionless
extensiveness2355303ex_tensiveness
ingressiveness1864163ingressiveness
regressiveness1864223regressiveness
suppressiveness2162413suppressiveness
erosiveness1447584e__r_osiveness
excessivenesses2675144ex_cessivenesses
exclusiveness2554494ex_clusiveness
excursiveness2554564ex_cursiveness
exhaustiveness2762794exhaustiveness
expensivenesses27105494exp_ensivenesses
expressionism2463364expressi_onism
expressionisms2562604expressi_onisms
expressionist2264044expressi_onist
expressionists2363094expressi_onists
expressions2086364expressi_on__s
expressive2285934expressiv__e__
expressively2753954expressiv__ely
expressivities2662514expressivities
impassiveness2054494imp_assiveness
inexpensiveness2762784inexp_ensiveness
obsessiveness1764504_obsessiveness
passiveness1646264__p_assiveness
pensiveness1648654__p_ensiveness
possessiveness1763234possessiveness
progressiveness2172864progressiveness
recessiveness1865904_recessiveness
restiveness1449664___restiveness
successiveness2072814successiveness
abrasiveness1754935_abr_asiveness
adhesiveness1954385_adhe_siveness
aversiveness1896235__aversiveness
cohesiveness2056055_cohe_siveness
corrosiveness1854365_corrosiveness
creativeness1747765__creativeness
cursiveness1647075_cur__siveness
defensiveness20115815_defensiveness
depressives1745175depressiv__e_s
derisiveness1656965_der_isiveness
dispersiveness20104055dispersiveness
dressiness1145545__dressi__ness
effectiveness2455675e_ffectiveness
effusiveness2154935e__ffusiveness
electiveness1757565e__lectiveness
elusiveness1466605e___lusiveness
empressements1962835empressemen_ts
evasiveness1755745e___vasiveness
expansivenesses2794525exp_ansivenesses
explosivenesses2793925exp_losivenesses
expressages2152105express__age_s
expressers1944435express____ers
expresses1837865express____e_s
expressible2254055expressi_ble__
expressing2046625expressi__n__g
expression1946575expressi_on___
expressional2164215expressi_on_al
expressivity2763055expressiv__ity
expressmen2153355express_men___
exquisiteness2962565ex_quisiteness
extensivenesses2595285ex_tensivenesses
extremeness2052755extre___meness
festiveness1748225___festiveness
imperativeness2155475imperativeness
impreciseness1962705impre_ciseness
impulsiveness2054555imp_ulsiveness
intensiveness1667485_intensiveness
intrusiveness1656315intr_usiveness
massiveness1645265___massiveness
obtrusiveness1874225obtr_usiveness
offensiveness2274245_offensiveness
operativeness1876665_operativeness
percussiveness2193735percussiveness
permissiveness2163175permissiveness
persuasiveness1963465__persuasiveness
pervasiveness2155135_pervasiveness
preciseness1545785__pre_ciseness
pressureless1452155__pressureless
prissiness1266135__prissi__ness
purposiveness2053595_purposiveness
recursiveness1855395recur__siveness
repulsiveness1854705rep_ulsiveness
resistiveness1656025___resistiveness
respectiveness2155365resp_ectiveness
responsiveness1963195resp_onsiveness
secretiveness1865865secre_tiveness
submissiveness2062255submissiveness
subversiveness2263045subversiveness
suggestiveness1962925suggestiveness

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.346516448.0
2DLD Change Limit95024986.25015203.8
3Display Results98980.0631555.6
 (SQL Overall)178691986.65926834.5
 
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.