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

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
thresher145582(None) 
thrasher1455741thrasher
threshed1535641threshed
threshers1545421threshers
threshes1437381threshes
fresher132612642_fresher
thrashed1555362thrashed
thrashers1565312thrashers
thrashes1487652thrashes
threader1256732threader
threaper1345142threaper
thresh12276862thresh__
thrushes1436522thrushes
thruster1135792thruster
trasher104416132t_rasher
arrester839253arrester
brasher124515243_brasher
brusher123813003_brusher
caresser1038813caresser
cheesier1335963cheesier
cherisher1765233cherisher
crasher124616163_crasher
crusher124412323_crusher
dresser83611953_dresser
flesher133610923_flesher
foreseer1139013foreseer
forester11313673forester
freshed143312593_freshed
freshen133010883_freshen
freshes133515823_freshes
freshet133416643_freshet
harsher13310363_harsher
phreaker1735053phreaker
presser93717623_presser
prester93519623_prester
rasher95024123__rasher
refresher15104653refresher
reshes94124363__reshes
rester63832433__rester
rusher94019653__rusher
shredder1334403shredder
shrewder1534403shrewder
shusher13288113sh_usher
tarsier74119253tar_sier
teether10349693t_eether
terser67317823ter_s_er
tester64227153t__ester
tether93716103t__ether
thatcher1635663thatcher
theater104014253th_eater
these86519013th_es_e_
theses96517973th_es_es
thewier1336063th_ewier
thirster1135673thirster
thither13328103th_ither
thrash12258363thrash__
threaded1366323threaded
threaders1365743threaders
threadier1354473threadier
threaped1454863threaped
threapers1444773threapers
threated1259203threated
threaten1146303threaten
three87526913thre__e_
threep115910113thre__ep
threeped1454373threeped
threes97117323thre__es
threshing1645663threshing
threshold1642913threshold
thriller1165553thriller
thriver13479123thr_iver
throbber1543203throbber
thrower1387003thr_ower
throwster1542953throwster
thrummer1542933thrummer
thrush12257483thrush__
thrusted1265223thrusted
thrusters1245333thrusters
thrustor1144123thrustor
tireder837703tire_der
together1243743together
trashed113514703t_rashed
trashers113013643t_rashers
trashes104119263t_rashes
trashier113210103t_rashier
treader84113833t_reader
treater74219833t_reater
trekker1034733t_rekker
trencher13279313t_rencher
tressed83714263t_ressed
tressel73010893t_ressel
tresses73719543t_resses
tressier847963t_ressier
trusser74010263t_russer
truster73114313t_ruster
tryster10369513t_ryster
whether16346623wh_ether
wrester102812413_wrester

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 Filter1786911461620.423422437.4
2DLD Change Limit146162987.21620255.3
3Display Results98980.0501960.0
 (SQL Overall)178691987.68923239.8
 
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.