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

397 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
fetched16371047(None) 
etched123613701_etched
fetcher153510391fetcher
fetches153413891fetches
fletched17306691fletched
letched133912051letched
retched133814271retched
tetched133010771tetched
batched154114242batched
beached154516552beached
belched154011842belched
benched154713942benched
bitched153212922bitched
botched153611902botched
detached1537732detached
ditched143711902ditched
eched116919222_e_ched
etcher113912942_etcher
etches114217762_etches
fenced124412712fenc_ed
fetch134913472fetch__
fetchers16328862fetchers
feted94420932fet__ed
fetiches1636952fetiches
fetted104817892fet_ted
fettled11378932fettled
filched16307422filched
fitchee152710782fitchee
fitches153516192fitches
fitchet153113562fitchet
fitchew18276802fitchew
fleeched17345822fleeched
flenched17267962flenched
fletcher16306662fletcher
fletches16308852fletches
flitched17256292flitched
frenched17299432frenched
hatched163414462hatched
hitched163312252hitched
hotched163610922hotched
hutched16359882hutched
itched123812022_itched
ketches164012192ketches
kvetched2142782kvetched
latched133914072latched
leached133715042leached
leched123716002le_ched
leeched13369502leeched
letches124015482letches
matched153513962matched
notched134210302notched
patched153514622patched
peached154315882peached
peched144915342pe_ched
perched154713242perched
pitched153512922pitched
reached134619082reached
retches123318512retches
sketched1835392sketched
teched124014432te_ched
vetches153411262vetches
watched163012822watched
welched16298832welched
wenched163910912wenched
witched163012192witched
wretched17276532wretched
ached119227833__ached
aether94213673aet_her
aitches123014363aitches
arched125717323_arched
attached14165703attached
bached145519893_bached
batcher144414853batcher
batches144019613batches
bathed125518743bat_hed
beaches144120653beaches
becked155417763be_cked
beechen14367703beechen
beeches143413883beeches
belcher143511493belcher
belches143514343belches
bencher144113483bencher
benches143918603benches
berthed13259123berthed
betaxed17307023betaxed
bethel1169643bet_hel
betided114810203betided
betted94721163bet_ted
bewitched2043233bewitched
birched15349913birched
bitchen14349733bitchen
bitches144117063bitches
bleached16378563bleached
blenched16358053blenched
blotched1635653blotched
botcher143613223botcher
botches143716023botches
breached163411643breached
breeched16337383breeched
bunched154312413bunched
butcher143411163butcher
butches144315363butches
cached145419203_cached
catcher143115823catcher
catches144320773catches
cinched153910863cinched
clenched16257763clenched
cliched153711023cliched
clutched16356033clutched
coached153313843coached
couched154115793couched
crotched16428593crotched
crutched16307463crutched
cutches143216463cutches
deashed123411303deashed
decked145217623de_cked
deiced104214483deic_ed
detacher1437543detacher
detaches1439653detaches
detected12289733detected
deticked1635693deticked
detoxed1636103detoxed
deuced104112123deuc_ed
ditcher134012003ditcher
ditches133215713ditches
douched144012113douched
drenched15247913drenched
eche97520283_e_che_
eches106322163_e_ches
echoed125211153_e_choed
emceed1136283_emceed
eschew1436333_eschew
etch95419143_etch__
etchers123411293_etchers
ether84518773_et_her
euchred13106163_euchred
exceed1636173_exceed
faced117727653f_ac_ed
faithed1437163faithed
fancied133310603fancied
farced125216533farc_ed
fashed136720253f_ashed
fated95632133fat__ed
fathead1437863fat_head
father125116713fat_her
fatted105419843fat_ted
feared106320433fe_ared
feased105718713fe_ased
feasted11310843feasted
feather133613503feather
featured1237683featured
feazed195112633fe_azed
feces105625363fe_c_es
fecund1235433fe_cund
fedexed1934083fedexed
feed84538903fe___ed
feezed19439993fe_ezed
feigned1245353feigned
feinted11379623feinted
felled103720303fe_lled
felted103714653fe_lted
fence105319913fenc_e_
fencer114613533fenc_er
fences114617113fenc_es
fended114216913fe_nded
feoffed1332813feoffed
ferried113411523ferried
feruled11318423feruled
fescue1137493fescue_
fescues1236783fescues
fessed104515063fe_ssed
festered122512113festered
fetching17298413fetching
fete75734923fet__e_
fetes85630143fet__es
fetich1479693fetich__
feticide1447503feticide
fetid93715983fet__id
fetishes1437153fetishes
fetter94120383fet_ter
fettered12259493fettered
fettle93713123fettle_
fettles103912733fettles
fetuses10310243fetuses
feuded114010003fe_uded
feued94715663fe__ued
fevered14339723fevered
fezzed18398243fe_zzed
fiche134616743f_iche_
fiches145219533f_iches
filcher15377793filcher
filches153410723filches
finches153914193finches
fished134316313f_ished
fitch134816873fitch__
fitchets16307413fitchets
fitchews19274773fitchews
fitchy17437623fitch_y
fitted104716663fit_ted
flacked173711583flacked
flashed144112183flashed
fleche14299303fleche_
fleches153411443fleches
flecked17358073flecked
fleeced13358153fleec_ed
fleeches16287083fleeches
flenches163410533flenches
fleshed143210263fleshed
fletch14388193fletch__
fletchers17335533fletchers
flicked174610673flicked
flinched17316703flinched
flitches16388463flitches
flocced15365483flocced
flocked174510253flocked
flushed143310973flushed
forced126316523forc_ed
fracted1339373fracted
frenches163311633frenches
frescoed1436053frescoed
freshed143312593freshed
fretted113411853fret_ted
frocked17439333frocked
frothed14288783frothed
fucked164114483f_ucked
futzed19418983fut_zed
gecked146911933ge_cked
grutched15284673grutched
hatchel153510753hatchel
hatcher153314723hatcher
hatches153420273hatches
hatchet153317563hatchet
hitcher153712003hitcher
hitches153616273hitches
hotches153814363hotches
hunched163710493hunched
hutches153613523hutches
inched124514483_inched
itches114916213_itches
jetted143915083jet_ted
jettied15366973jettied
kecked125113173ke_cked
kenches163912273kenches
ketch144912023ketch__
ketchup1842783ketchup
kitchen16287683kitchen
kithed144613013kit_hed
kvetcher2052813kvetcher
kvetches2053583kvetches
kythed17407313kyt_hed
latches123320133latches
latchet123117913latchet
lathed104718463lat_hed
leacher124014843leacher
leaches123319343leaches
leashed113211163leashed
lecher113415853le_cher
leches115421313le_ches
leeches123911933leeches
letch105215803letch__
lethe85717303let_he_
lethes94818083let_hes
letted74118543let_ted
lunched133911823lunched
lurched13358033lurched
lynched16376753lynched
marched153813403marched
matcher143214283matcher
matches143219783matches
merches144013763merches
meshed124415933me_shed
metaled102913883metaled
meted85424433met__ed
metered103514013metered
method1239033met_hod
metred95315143met_red
mettled103510543mettled
miched143913393_miched
mooched153910533mooched
mouched153612593mouched
mulched15307763mulched
munched153411073munched
mutches143314283mutches
necked134715063ne_cked
neighed12135893neighed
nether94014163net_her
netted74118713net_ted
nettled8339943nettled
niched125514063_niched
notcher123610933notcher
notches123513653notches
ouched124316933_ouched
outchid1338723outchid
parched154013693parched
patcher143515143patcher
patches143320383patches
peaced115818913peac_ed
peacher144216073peacher
peaches144120053peaches
pecked155019103pe_cked
percher143313423percher
perches143717953perches
petaled103614153petaled
petered103314973petered
petted94121523pet_ted
pettled103611513pettled
pinched153812453pinched
pitcher143813713pitcher
pitches143617753pitches
pithed124615613pit_hed
pleached16338063pleached
poached154212403poached
pooched152810083pooched
pouched153612773pouched
preached163412063preached
psyched1843913psyched
punched153512173punched
quenched2334103quenched
ranched133113603ranched
ratches123620463ratches
ratchet124218333ratchet
reacher123718293reacher
reaches123423203reaches
reacted103015713reacted
rechew14310213re_chew
recked134821803re_cked
reechoed1436083reechoed
rematched1745223rematched
repatched1745313repatched
rescued10410043rescued
retacked15169273retacked
retaped103814283retaped
retaxed153512233retaxed
retch104818303retch__
retied75924983ret_ied
retiled84420513retiled
retimed104714653retimed
retired84620143retired
retouched1545113retouched
retried84419153retried
retted74826313ret_ted
retuned86613973retuned
retyped13367303retyped
roached133211833roached
rotche114311983rotche_
rotches123515703rotches
ruched124314633_ruched
satchel123310303satchel
scotched16187933scotched
scutched16186893scutched
searched14209253searched
seethed113410193seethed
seiche11811833seiche_
seiches12513813seiches
settled83210873settled
sketcher1735433sketcher
sketches1746823sketches
smutched16165923smutched
snatched14157633snatched
snitched14166863snitched
stitched14148203stitched
stretched1546213stretched
switched17157133switched
synched16277213synched
teacher123714833teacher
teaches122718353teaches
teethed11318623teethed
tenches123515523tenches
tetchier1336453tetchier
tetchy1436003tetch_y
tether93716103tet_her
thatched1735433thatched
tithed104115593tit_hed
torched133511363torched
touched134914963touched
trenched14289853trenched
twitched17155033twitched
tythed13457503tyt_hed
vetch134411843vetch__
vetoed10359823vet_oed
vetted104316323vet_ted
vouched163910563vouched
watcher153113403watcher
watches153017373watches
weighed15135933weighed
welcher15319393welcher
welches153710313welches
welshed14277203welshed
wencher153811133wencher
wenches152914133wenches
wether123315393wet_her
wetted103717023wet_ted
winched163110593winched
witches152715793witches
withed134416233wit_hed
wrenched17748133wrenched
wretches16257283wretches

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.423422437.4
2DLD Change Limit1340273976.12621878.4
3Display Results3973970.1402835.7
 (SQL Overall)1786913976.68926714.2
 
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.