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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
etches11421776(None) 
eches106322161e_ches
etched123613701etched
etcher113912941etcher
etchers123411291etchers
fetches153413891fetches
itches114916211itches
ketches164012191ketches
letches124015481letches
retches123318511retches
vetches153411261vetches
aches106132292_aches
aitches123014362aitches
arches114822042arches
baches135426942baches
batches144019612batches
beaches144120652beaches
beeches143413882beeches
belches143514342belches
benches143918602benches
bitches144117062bitches
boches134618522boches
botches143716022botches
butches144315362butches
caches137926912caches
catches144320772catches
cutches143216462cutches
detaches1439652detaches
ditches133215712ditches
eche97520282e_che_
eched116919222e_ched
echoes114715522e_choes
echos105216462e_chos
emcees1037812emcees
eschew1436332eschew
eschews1534552eschews
etapes85415292etapes
etch95419142etch__
ether84518772et_her
ethers94518412et_hers
ethos85514192et_hos
eths76619522et_h_s
etudes73811602etudes
etwees9348792etwees
euchres1288662euchres
fetched163710472fetched
fetcher153510392fetcher
fetchers16328862fetchers
fetiches1636952fetiches
fiches145219532fiches
fitches153516192fitches
fletches16308852fletches
hatches153420272hatches
hitches153616272hitches
hotches153814362hotches
hutches153613522hutches
inches114419672inches
itched123812022itched
kenches163912272kenches
kvetches2053582kvetches
laches116528352laches
latches123320132latches
leaches123319342leaches
leches115421312leches
leeches123911932leeches
letched133912052letched
lethes94818082let_hes
liches114724292liches
lyches144213612lyches
maches134827232maches
matches143219782matches
merches144013762merches
miches134320732miches
muches134718992muches
mutches143314282mutches
naches114622412naches
niches114419142niches
notches123513652notches
ouches114322182ouches
patches143320382patches
peaches144120052peaches
perches143717952perches
pitches143617752pitches
ratches123620462ratches
reaches123423202reaches
retched133814272retched
riches115022082riches
rotches123515702rotches
ruches114819582ruches
seiches12513812seiches
sketches1746822sketches
taches114224172taches
teaches122718352teaches
teched124014432teched
techies12513602techies
techs106915832tech_s
tenches123515522tenches
tetched133010772tetched
watches153017372watches
welches153710312welches
wenches152914132wenches
wiches144418752wiches
witches152715792witches
wretches16257282wretches
wyches17387912wyches

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit825511052.56032246.5
3Display Results1051050.0333181.8
 (SQL Overall)1786911052.95360511.7
 
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.