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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
effetenesses185452(None) 
effeteness1643672effetene_s_s
affectednesses2382603affectednesses
effectivenesses2665103effectivenesses
fleetnesses1445483_fleetnesses
freenesses1339873_fre_enesses
repletenesses1554493repletenesses
acutenesses13126974_acutenesses
astutenesses1245594astutenesses
chastenesses1746314chastenesses
cutenesses12910904__cutenesses
daftnesses1436384daf_t_nesses
definitenesses1864254definitenesses
deftnesses1436814def_t_nesses
diffusenesses2052824diffusenesses
dilutenesses1346114dilutenesses
eagernesses1246984eage_rnesses
ediblenesses1545834ediblenesses
eerinesses10612604e__erinesses
effectualnesses2391814effectualnesses
effervesces2261734effe_rvesces
effusivenesses2355744effusivenesses
elatednesses1346114elatednesses
emptinesses1545994e_mptinesses
entirenesses1249664entirenesses
erectnesses1347474e_rectnesses
evennesses1345944e_ve_nnesses
exactnesses2044344exact_nesses
expectednesses2662954expectednesses
expertnesses2144844expertnesses
extremenesses2252884extremenesses
eyednesses1445814e_ye_dnesses
falsenesses1446744_falsenesses
fastnesses1389084_fast_nesses
fatnesses121710464__fat_nesses
fattinesses14118974_fattinesses
feeblenesses1745544feeblenesses
feistinesses1555894feistinesses
fellnesses1346084__fellnesses
femalenesses1746864femalenesses
fetidnesses1546654__fetidnesses
fewnesses1534954__fe_wnesses
feynesses1535224__fe_ynesses
fiercenesses1744314_fiercenesses
fierinesses1439234_fierinesses
finenesses13310714__finenesses
finitenesses1557724finitenesses
fitnesses12219374__fit_nesses
flatnesses1337764_flat_nesses
freshnesses1746104_freshnesses
fustinesses14129784_fustinesses
giftednesses1754014giftednesses
heftinesses1737134hef_tinesses
iffinesses1635584iff__inesses
innatenesses1247184innatenesses
iratenesses11411444_iratenesses
latenesses10413364__latenesses
litenesses10513024__litenesses
loftinesses1437924lof_tinesses
meetnesses1237454_meet_nesses
minutenesses1476174minutenesses
mutenesses1289974__mutenesses
niftinesses1437244nif_tinesses
obesenesses1346764_obesenesses
oblatenesses1475774oblatenesses
offishnesses2143814offishnesses
ornatenesses1257304ornatenesses
perfectnesses2053354perfectnesses
petitenesses14169364petitenesses
politenesses1448594politenesses
quietnesses2045604quiet_nesses
remotenesses1446814remotenesses
rifenesses1339944rif__enesses
safenesses1349374saf__enesses
sedatenesses1346964sedatenesses
serenenesses12117114serenenesses
severenesses1545614severenesses
softnesses1337604sof_t_nesses
sveltenesses1545234sveltenesses
sweetnesses1445724sweet_nesses
tritenesses11710394_tritenesses
tweenesses1345804_twe_enesses
unfitnesses1446134unfit_nesses
wetnesses12208214__wet_nesses
whitenesses1746654_whitenesses
wifelinesses1844814wifelinesses

Search took 8 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.406440125.6
2DLD Change Limit124790866.75018487.4
3Display Results86860.0461869.6
 (SQL Overall)178691867.20224811.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.