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

136 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
eches10632216(None) 
aches106132291aches
eche97520281eche_
eched116919221eched
echoes114715521echoes
echos105216461echos
etches114217761etches
leches115421311leches
aces67645092ac_es
ache96829822ache_
ached119227832ached
acmes96020652acmes
acnes75922622acnes
acres76327762acres
arches114822042arches
ashes86230612ashes
baches135426942baches
beaches144120652beaches
beeches143413882beeches
belches143514342belches
benches143918602benches
boches134618522boches
caches137926912caches
cedes84927332cedes
cees65941592_cees
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
chef125125622_chef
chefs136214662_chefs
chess105016922_chess
chest104926142_chest
chew126622132_chew
chews135418512_chews
chez184519022_chez
chis95933312_chis
creches14313092creches
cues65438982_cues
eases56041612eases
eaves85231992eaves
echo96615952ech_o
echoed125211152echoed
echoer114011102echoer
echoers12459692echoers
echoey14397852echoey
echt95722902ech_t
ecrus75113862ecrus
ecus65421462ec_us
edges75718742edges
edhs86212102edh_s
ekes86726602e_kes
elves85118742elves
emcees1037812emcees
emes65434662e_mes
epees75219832epees
ephas10311542ephas
ernes55224812ernes
erses55826802erses
eschew1436332eschew
eschews1534552eschews
eses45336102e_ses
esnes54817362esnes
esses56422972esses
etched123613702etched
etcher113912942etcher
etchers123411292etchers
ether84518772ether
ethers94518412ethers
ethos85514192ethos
eths76619522eth_s
euchres1288662euchres
eves76230462e_ves
ewes76328702e_wes
exes116530812e_xes
eyes75837882e_yes
eyres84921772eyres
feces105625362fec_es
fetches153413892fetches
fiches145219532fiches
fleches153411442fleches
hes66654202__hes
ices66129642ic_es
ichs96214712ich_s
inches114419672inches
itches114916212itches
kenches163912272kenches
ketches164012192ketches
laches116528352laches
leaches123319342leaches
leched123716002leched
lecher113415852lecher
lechers123313962lechers
lechwes1535062lechwes
leeches123911932leeches
letches124015482letches
lethes94818082lethes
liches114724292liches
lyches144213612lyches
maches134827232maches
merches144013762merches
meshes115019442meshes
miches134320732miches
muches134718992muches
naches114622412naches
niches114419142niches
ocher104516102ocher
ochers113915302ochers
ochres113510832ochres
ouches114322182ouches
peaches144120052peaches
peched144915342peched
pechs125516202pech_s
perches143717952perches
reaches123423202reaches
recces10614912recces
rechew14310212rechew
rechews1537292rechews
reshes94124362reshes
retches123318512retches
riches115022082riches
ruches114819582ruches
seiches12513812seiches
shes75734352_shes
taches114224172taches
teaches122718352teaches
teched124014432teched
techies12513602techies
techs106915832tech_s
tenches123515522tenches
vetches153411262vetches
wechts1446252wechts
welches153710312welches
wenches152914132wenches
wiches144418752wiches
wyches17387912wyches
yechs136112582yech_s

Search took 5 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 Filter178691538000.673265514.1
2DLD Change Limit538001363.39015870.2
3Display Results1361360.0761789.5
 (SQL Overall)1786911364.13943172.5
 
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.