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

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

74 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
threshers154542(None) 
thrashers1565311thrashers
thresher1455821thresher_
threshes1437381threshe_s
thrasher1455742thrasher_
thrashes1487652thrashe_s
threaders1365742threaders
threapers1444772threapers
threshed1535642threshe_d
thrushes1436522thrushe_s
thrusters1245332thrusters
trashers113013642t_rashers
arresters948203arresters
brushers134210573_brushers
caressers1137443caressers
cherishers1854553cherishers
crashers134013233_crashers
crushers134010093_crushers
dressers9359863_dressers
fleshers14339443_fleshers
foreseers1237403foreseers
foresters12312543foresters
freshens14298313_freshens
fresher132612643_fresher_
freshes133515823_freshe_s
freshets14298673_freshets
phreakers1834673phreakers
pressers103215023_pressers
presters103419003_presters
rashers104020913__rashers
refreshers16103673refreshers
reshes94124363__reshe_s
resters74130403__resters
rushers103816103__rushers
shredders1463713shredders
shushers14267053sh_ushers
tarsiers8298533tar_siers
teethers11328713t_eethers
testers74124543t__esters
tethers103815313t__ethers
thatchers1744583thatchers
theaters114211903th_eaters
theses96517973th_es_e_s
thirsters1235233thirsters
thrashed1555363thrashe_d
threader1256733threader_
threaper1345143threaper_
threatens1254673threatens
threeps12687043thre__eps
threes97117323thre__e_s
thresh12276863thresh___
threshing1645663threshing
threshold1642913threshold
thresholds1752223thresholds
thrillers1244473thrillers
thrivers14456823thr_ivers
throbbers1643173throbbers
throwers14106033thr_owers
throwsters1642713throwsters
thrummers1642413thrummers
thruster1135793thruster_
thrustors1244303thrustors
trasher104416133t_rasher_
trashes104119263t_rashe_s
treaders93311843t_readers
treaters83615853t_reaters
trekkers1133803t_rekkers
trenchers14288073t_renchers
tressels8367653t_ressels
tresses73719543t_resse_s
trussers8348283t_russers
trusters83112263t_rusters
trysters11298373t_rysters
wresters112711733_wresters

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 Filter1786911486410.450397091.1
2DLD Change Limit148641747.84618944.8
3Display Results74740.0302466.7
 (SQL Overall)178691748.32621461.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.