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

49 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
newsletters1414169(None) 
newsletter13152131newsletter_
besetters11136633be_s_etters
neglecters1362933ne_glecters
newscasters1651603newscasters
newsdealers1551393newsdealers
newsreaders1571963newsreaders
reletters9138783re__letters
resetters9129463re_s_etters
bedwetters1642274be_dwetters
begetters12135044be__getters
besetter10137974be_s_etter_
bespatters1442784be_spatters
bonesetters1352634bone_s_etters
depleters12327534de_ple_ters
deserters10129984de_s_erters
enfetters1244464_e_nfetters
insetters9187134_ins_etters
leafleteers1461254leafleteers
leafleters1342434leafle_ters
letters73819854____letters
neglecter1263634ne_glecter_
neglectors1363534ne_glectors
nesters74422794ne_s___ters
nestlers8359224ne_s__tlers
netters73618584n____etters
newsbeats1442664newsbeat__s
newscaster1551834newscaster_
newsdealer1451634newsdealer_
newsless1134534newsl___ess
newsmakers1943334news_makers
newsmongers1751724newsmongers
newspapers1742664news_papers
newsreader1472314newsreader_
newsreels1242354newsre__els
noisettes946534nois_ette_s
novelettes1343874novelette_s
pinsetters1244104pins_etters
regretters1144094re_gretters
reletter81311024re__letter_
resetter81511834re_s_etter_
respecters1445864re_specters
setters73822064___s_etters
slitters84014134___slitters
slotters84012404___slotters
towelettes1342744towelette_s
upsetters1143654_ups_etters
wetters103817754__w__etters
whetters14246654__w_hetters

Search took 10 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 Filter1786911488190.236757165.3
2DLD Change Limit148819499.07616397.0
3Display Results49490.0331484.8
 (SQL Overall)178691499.34519121.6
 
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.