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
effetenesses185448(None) 
effeteness1643672effetene_s_s
affectednesses2382583affectednesses
effectivenesses2665063effectivenesses
fleetnesses1445483_fleetnesses
freenesses1339863_fre_enesses
repletenesses1554473repletenesses
acutenesses13126954_acutenesses
astutenesses1245584astutenesses
chastenesses1746304chastenesses
cutenesses12910874__cutenesses
daftnesses1436384daf_t_nesses
definitenesses1864224definitenesses
deftnesses1436814def_t_nesses
diffusenesses2052824diffusenesses
dilutenesses1346104dilutenesses
eagernesses1246974eage_rnesses
ediblenesses1545784ediblenesses
eerinesses10612574e__erinesses
effectualnesses2391804effectualnesses
effervesces2261734effe_rvesces
effusivenesses2355684effusivenesses
elatednesses1346094elatednesses
emptinesses1545984e_mptinesses
entirenesses1249604entirenesses
erectnesses1347444e_rectnesses
evennesses1345924e_ve_nnesses
exactnesses2044324exact_nesses
expectednesses2662914expectednesses
expertnesses2144814expertnesses
extremenesses2252844extremenesses
eyednesses1445804e_ye_dnesses
falsenesses1446744_falsenesses
fastnesses1389074_fast_nesses
fatnesses121710464__fat_nesses
fattinesses14118974_fattinesses
feeblenesses1745524feeblenesses
feistinesses1555884feistinesses
fellnesses1346084__fellnesses
femalenesses1746844femalenesses
fetidnesses1546644__fetidnesses
fewnesses1534954__fe_wnesses
feynesses1535224__fe_ynesses
fiercenesses1744294_fiercenesses
fierinesses1439224_fierinesses
finenesses13310714__finenesses
finitenesses1557694finitenesses
fitnesses12219374__fit_nesses
flatnesses1337764_flat_nesses
freshnesses1746104_freshnesses
fustinesses14129764_fustinesses
giftednesses1754004giftednesses
heftinesses1737134hef_tinesses
iffinesses1635574iff__inesses
innatenesses1247174innatenesses
iratenesses11411404_iratenesses
latenesses10413354__latenesses
litenesses10513004__litenesses
loftinesses1437914lof_tinesses
meetnesses1237444_meet_nesses
minutenesses1476164minutenesses
mutenesses1289934__mutenesses
niftinesses1437234nif_tinesses
obesenesses1346744_obesenesses
oblatenesses1475764oblatenesses
offishnesses2143814offishnesses
ornatenesses1257284ornatenesses
perfectnesses2053324perfectnesses
petitenesses14169314petitenesses
politenesses1448554politenesses
quietnesses2045564quiet_nesses
remotenesses1446794remotenesses
rifenesses1339934rif__enesses
safenesses1349374saf__enesses
sedatenesses1346944sedatenesses
serenenesses12117094serenenesses
severenesses1545584severenesses
softnesses1337604sof_t_nesses
sveltenesses1545214sveltenesses
sweetnesses1445724sweet_nesses
tritenesses11710354_tritenesses
tweenesses1345804_twe_enesses
unfitnesses1446124unfit_nesses
wetnesses12208214__wet_nesses
whitenesses1746634_whitenesses
wifelinesses1844814wifelinesses

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.1561145455.1
2DLD Change Limit124790868.42314815.4
3Display Results86860.0631365.1
 (SQL Overall)178691868.64220677.0
 
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.