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

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

488 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
vetches15341126(None) 
etches114217761_etches
fetches153413891fetches
ketches164012191ketches
kvetches2053581kvetches
letches124015481letches
retches123318511retches
aitches123014362aitches
batches144019612batches
beaches144120652beaches
beeches143413882beeches
belches143514342belches
benches143918602benches
bitches144117062bitches
botches143716022botches
butches144315362butches
catches144320772catches
cutches143216462cutches
detaches1439652detaches
ditches133215712ditches
eches106322162_e_ches
etched123613702_etched
etcher113912942_etcher
etchers123411292_etchers
fetched163710472fetched
fetcher153510392fetcher
fetchers16328862fetchers
fetiches1636952fetiches
fitches153516192fitches
fletches16308852fletches
hatches153420272hatches
hitches153616272hitches
hotches153814362hotches
hutches153613522hutches
itches114916212_itches
kenches163912272kenches
kvetched2142782kvetched
kvetcher2052812kvetcher
kvetchers2142372kvetchers
latches123320132latches
leaches123319342leaches
leches115421312le_ches
leeches123911932leeches
letched133912052letched
lethes94818082let_hes
matches143219782matches
merches144013762merches
mutches143314282mutches
notches123513652notches
patches143320382patches
peaches144120052peaches
perches143717952perches
pitches143617752pitches
ratches123620462ratches
reaches123423202reaches
retched133814272retched
rotches123515702rotches
seiches12513812seiches
sketches1746822sketches
teaches122718352teaches
tenches123515522tenches
tetched133010772tetched
vetch134411842vetch__
vetoes92914082vet_oes
vouches153914112vouches
watches153017372watches
welches153710312welches
wenches152914132wenches
witches152715792witches
wretches16257282wretches
aches106132293__aches
aether94213673aet_her
aethers103614943aet_hers
apaches143411843apaches
arches114822043_arches
attaches13137723attaches
avouches1634823avouches
baches135426943_baches
batched154114243batched
batcher144414853batcher
batchers153613273batchers
bathes116524833bat_hes
beached154516553beached
beechen14367703beechen
belched154011843belched
belcher143511493belcher
belchers153510023belchers
benched154713943benched
bencher144113483bencher
benchers153611013benchers
betakes134212523betakes
bethel1169643bet_hel
bethels1238533bet_hels
beths105519223bet_h_s
betides104915263betides
betimes115114413betimes
betises94816123betises
bewitches1943823bewitches
birches143412323birches
bitched153212923bitched
bitchen14349733bitchen
bleaches153410673bleaches
blenches153310763blenches
blotches1537433blotches
boches134618523_boches
botched153611903botched
botcher143613223botcher
botchers153511543botchers
braches144621223braches
breaches153714123breaches
breeches15258673breeches
britches15278683britches
bunches144116033bunches
butcher143411163butcher
butchers153710183butchers
caches137926913_caches
catcher143115823catcher
catchers153114063catchers
cetanes9315133cetanes
cetes75731103cet__es
ceviches1834843ceviches
cinches144215773cinches
clenches152910953clenches
cliches144213743cliches
cloches144113713cloches
clutches15307923clutches
coaches144018693coaches
conches144019813conches
cooches143515833cooches
couches144020473couches
cratches153012543cratches
creches14313093creches
crotches153411303crotches
crutches15359593crutches
culches143710743culches
cultches15316533cultches
curches143512743curches
datchas1347423datchas
deashes113313903deashes
deices94119373deic_es
detached1537733detached
detacher1437543detacher
detachers1536483detachers
detoxes1538803detoxes
deuces94015513deuc_es
ditched143711903ditched
ditcher134012003ditcher
ditchers143610363ditchers
douches134315233douches
drenches14309803drenches
dunches133312583dunches
eche97520283_e_che_
eched116919223_e_ched
echoes114715523_e_choes
echos105216463_e_chos
emcees1037813_emcees
eschew1436333_eschew
eschews1534553_eschews
etapes85415293_etapes
etch95419143_etch__
ether84518773_et_her
ethers94518413_et_hers
ethos85514193_et_hos
eths76619523_et_h_s
etudes73811603_etudes
etwees9348793_etwees
euchres1288663_euchres
feces105625363fe_c_es
fences114617113fenc_es
fescues1236783fescues
fetch134913473fetch__
fetes85630143fet__es
fetishes1437153fetishes
fettles103912733fettles
fetuses10310243fetuses
fiches145219533_fiches
filches153410723filches
finches153914193finches
fitchee152710783fitchee
fitchet153113563fitchet
fitchets16307413fitchets
fitchew18276803fitchew
fitchews19274773fitchews
fleches153411443fleches
fleeches16287083fleeches
flenches163410533flenches
fletched17306693fletched
fletcher16306663fletcher
fletchers17335533fletchers
flitches16388463flitches
frenches163311633frenches
glitches14296663glitches
gotchas1334613gotchas
grutches14285853grutches
gulches13398113gulches
hatched163414463hatched
hatchel153510753hatchel
hatchels16368673hatchels
hatcher153314723hatcher
hatchers163113173hatchers
hatchet153317563hatchet
hatchets163310383hatchets
heths116317783het_h_s
heuchs14447923heuch_s
hitched163312253hitched
hitcher153712003hitcher
hitchers16379993hitchers
hooches153812523hooches
hootches1656973hootches
hotched163610923hotched
hunches153913463hunches
hutched16359883hutched
inches114419673_inches
itched123812023_itched
jetes124922843jet__es
jetties143613123jetties
ketch144912023ketch__
ketchup1842783ketchup
ketchups1941893ketchups
ketenes114813503ketenes
ketones115014503ketones
ketoses114912873ketoses
kettles113411613kettles
kitchen16287683kitchen
kitchens17195783kitchens
kithes135016653kit_hes
kitsches1734073kitsches
klatches17157143klatches
kvetch1832993kvetch__
kvetchier2141863kvetchier
kvetchiest2241953kvetchiest
kvetchy2241803kvetch_y
kythes16499133kyt_hes
laches116528353_laches
larches124416453larches
latched133914073latched
latchet123117913latchet
latchets133410013latchets
lathes95127503lat_hes
leached133715043leached
leacher124014843leacher
leachers133712813leachers
leashes103514403leashes
leched123716003le_ched
lecher113415853le_cher
lechers123313963le_chers
lechwes1535063le_chwes
leeched13369503leeched
letch105215803letch__
lethe85717303let_he_
liches114724293_liches
litchis1238373litchis
loaches123613983loaches
lunches124115443lunches
lurches123311663lurches
lyches144213613_lyches
lynches15378873lynches
maches134827233_maches
manches143818623manches
marches143921173marches
matched153513963matched
matcher143214283matcher
matchers153012433matchers
mensches1536303mensches
menshes12310453menshes
merces105720743merc_es
mercies113817563mercies
meshes115019443me_shes
metages102714973metages
metates92720013metates
metes74736213met__es
meths105320233met_h_s
metopes11311363metopes
metres85121563met_res
mettles94115023mettles
miches134320733_miches
mooches143714453mooches
mouches143815963mouches
muches134718993_muches
mulches143210673mulches
munches144215793munches
naches114622413_naches
nautches1336083nautches
nether94014163net_her
nettles73214083nettles
niches114419143_niches
nitchies1339073nitchies
notched134210303notched
notcher123610933notcher
notchers13279423notchers
oraches124216473oraches
ouches114322183_ouches
parches143720003parches
patched153514623patched
patcher143515143patcher
patchers153413303patchers
peaces106324083peac_es
peached154315883peached
peacher144216073peacher
peachers153213843peachers
peched144915343pe_ched
pechs125516203pe_ch_s
penoches1538933penoches
penuches1536943penuches
perched154713243perched
percher143313423percher
perchers153611523perchers
petites93820203petites
pettles93916483pettles
pinches144117933pinches
pitched153512923pitched
pitcher143813713pitcher
pitchers153211483pitchers
pleaches153210433pleaches
plenches153110623plenches
poaches144416943poaches
pooches143214163pooches
porches143815673porches
potiches1539203potiches
pouches144116743pouches
preaches153214893preaches
psyches1755803psyches
punches144816133punches
putsches1535313putsches
quenches2236013quenches
quiches2139333quiches
quitches2236193quitches
ranches123620113ranches
ratchet124218333ratchet
ratchets133110263ratchets
reached134619083reached
reacher123718293reacher
reachers133515723reachers
recces10614913re_cces
rechew14310213re_chew
rechews1537293re_chews
reechoes1338413reechoes
rematches1636653rematches
repatches1636713repatches
rescues9312753rescues
reshes94124363re_shes
retakes113718863retakes
retapes93917423retapes
retaxes143615093retaxes
retch104818303retch__
reteaches1437123reteaches
retenes76324623retenes
reticles103912483reticles
reties65436193ret_ies
retiles74426993retiles
retimes95020173retimes
retines75134673retines
retires74726213retires
retouches1445903retouches
retries74129073retries
retunes76918403retunes
retypes12308623retypes
riches115022083_riches
roaches123616213roaches
rotche114311983rotche_
rouches124217893rouches
ruches114819583_ruches
satchel123310303satchel
satchels13328163satchels
scotches15179473scotches
scutches15168883scutches
searches132112903searches
seethes103613743seethes
seiche11811833seiche_
settees73513633settees
settles73916003settles
seviches1635803seviches
sketched1835393sketched
sketcher1735433sketcher
sketchers1834513sketchers
slatches131511533slatches
smutches15177273smutches
snatches131410713snatches
snitches13148983snitches
speeches1537413speeches
stenches132110293stenches
stitches131410593stitches
stretches1438293stretches
swatches16169963swatches
switches16159133switches
taches114224173_taches
teacher123714833teacher
teachers133212393teachers
teched124014433te_ched
techies12513603te_chies
techs106915833te_ch_s
teethes103611653teethes
terces83921413terc_es
tetchier1336453tetchier
tetchiest1445793tetchiest
tetchy1436003tetch_y
tether93716103tet_her
tethers103815313tet_hers
teths85418513tet_h_s
thatches1637513thatches
tithes94720213tit_hes
torches123715443torches
touches125118343touches
trenches133512603trenches
troches123715343troches
tusches1237903tusches
twitches16156373twitches
tythes12419703tyt_hes
vectors123212593vectors
veepees1245813veepees
veeries102916893veeries
vees75439433ve___es
veges94118873ve__ges
veggies1237553veggies
vegies104314273ve_gies
vehicles16204683vehicles
velcros1244033velcros
velites103417303velites
velures1039093velures
vendees114011453vendees
vendues11318623vendues
venenes102712133venenes
venges104015153ve_nges
venines103516613venines
venires103012453venires
ventages12119773ventages
ventures11311493ventures
venues95115203ve_nues
venules104011483venules
venuses103111413venuses
verges104320183ve_rges
verites103822263verites
vermes115019143ve_rmes
verses94223763ve_rses
verstes104014283verstes
vertexes18105633vertexes
vertices13612283vertices
verves124617883ve_rves
vesicles13127073vesicles
vestees103513173vestees
vestiges1238243vestiges
vestries11314053vestries
vestures11311043vestures
vetiver1336103vetiver
vetivers1435163vetivers
vetoed10359823vet_oed
vetoer93410063vet_oer
vetoers10359473vetoers
vets76835093vet___s
vetted104316323vet_ted
vetter93417643vet_ter
vetters104016323vetters
vexes155719123ve__xes
vices105725533v_ic_es
vichies15310623v_ichies
vittles103211113vittles
voces105918053v_oc_es
voices114414013voic_es
votes84627083vot__es
votives13337953votives
vouched163910563vouched
vouchee153411263vouchee
vouchees16337483vouchees
voucher154110263voucher
vouchers16418623vouchers
watched163012823watched
watcher153113403watcher
watchers163511793watchers
wechts1446253we_chts
welched16298833welched
welcher15319393welcher
welchers16338053welchers
welshes13379093welshes
wenched163910913wenched
wencher153811133wencher
wenchers16319213wenchers
wether123315393wet_her
wethers135214693wet_hers
wiches144418753_wiches
winches154714373winches
witched163012193witched
withes124620843wit_hes
wrenches163210233wrenches
wretched17276533wretched
wyches17387913_wyches
yecchs16414953yecch_s
yechs136112583ye_ch_s
zilches21326303zilches

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340274886.36021073.4
3Display Results4884880.1862623.7
 (SQL Overall)1786914886.95225703.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.