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

427 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
tetched13301077(None) 
etched123613701_etched
fetched163710471fetched
letched133912051letched
retched133814271retched
teched124014431te_ched
batched154114242batched
beached154516552beached
belched154011842belched
benched154713942benched
bitched153212922bitched
botched153611902botched
detached1537732detached
ditched143711902ditched
eched116919222_e_ched
etcher113912942_etcher
etches114217762_etches
fetcher153510392fetcher
fetches153413892fetches
fletched17306692fletched
hatched163414462hatched
hitched163312252hitched
hotched163610922hotched
hutched16359882hutched
itched123812022_itched
ketches164012192ketches
kvetched2142782kvetched
latched133914062latched
leached133715042leached
leched123716002le_ched
leeched13369502leeched
letches124015482letches
matched153513962matched
notched134210302notched
patched153514622patched
peached154315882peached
peched144915342pe_ched
perched154713232perched
pitched153512922pitched
reached134619082reached
retches123318512retches
sketched1835392sketched
stitched14148202stitched
stretched1546202stretched
teacher123714832teacher
teaches122718352teaches
teethed11318622teethed
tenches123515522tenches
tetchier1336452tetchier
tetchy1436002tetch_y
tether93716102tet_her
thatched1735432thatched
tithed104115592tit_hed
torched133511352torched
touched134914962touched
trenched14289852trenched
twitched17155032twitched
tythed13457502tyt_hed
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
catches144320763catches
cinched153910863cinched
clenched16257763clenched
cliched153711023cliched
clutched16356033clutched
coached153313843coached
couched154115793couched
crotched16428593crotched
crutched16307463crutched
cutches143216453cutches
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
fenced124412713fenc_ed
fetch134913473fetch__
fetchers16328863fetchers
feted94420933fet__ed
fetiches1636953fetiches
fetted104817893fet_ted
fettled11378933fettled
filched16307423filched
fitchee152710783fitchee
fitches153516193fitches
fitchet153113563fitchet
fitchew18276803fitchew
fleeched17345823fleeched
flenched17267963flenched
fletcher16306663fletcher
fletches16308853fletches
flitched17256293flitched
frenched17299433frenched
gecked146911933ge_cked
grutched15284673grutched
hatchel153510753hatchel
hatcher153314723hatcher
hatches153420273hatches
hatchet153317563hatchet
hitcher153712003hitcher
hitches153616273hitches
hotches153814363hotches
hunched163710493hunched
hutches153613523hutches
inched124514483_inched
itches114916213_itches
jetted143915083jet_ted
jettied15366973jettied
kecked125113163ke_cked
kenches163912273kenches
ketch144912023ketch__
ketchup1842783ketchup
kitchen16287683kitchen
kithed144613013kit_hed
kvetcher2052813kvetcher
kvetches2053583kvetches
kythed17407313kyt_hed
latches123320123latches
latchet123117903latchet
lathed104718453lat_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
metaled102913873metaled
meted85424433met__ed
metered103514013metered
method1239023met_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
petaled103614143petaled
petered103314963petered
petted94121523pet_ted
pettled103611503pettled
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
stanched14208903stanched
starched14199313starched
stenches132110293stenches
stetted82610403stet_ted
stitcher13168383stitcher
stitches131410593stitches
stretcher1446283stretcher
stretches1438283stretches
switched17157133switched
synched16277213synched
tache106222373t_ache_
taches114224173t_aches
tacked134723943t_acked
talced93811003talc_ed
talcked1446343talcked
tatted74920533tat_ted
tattled84311483tattled
teach105221123teach__
teachers133212393teachers
teamed95418593te_amed
teared75722153te_ared
teased74721153te_ased
teated74924023te_ated
teazled17326833teazled
tech95925443te_ch__
techie11511723te_chie
techier1269243te_chier
techies12513603te_chies
techno1135953te_chno
techs106915833te_ch_s
techy135612013te_ch_y
tedded93810893te_dded
teed55439263te___ed
teemed95114873te_emed
teetered9258303teetered
teethe94511313teethe_
teether10349693teether
teethes103611653teethes
telexed1536313telexed
telpher1235563telpher
temped113912893te_mped
templed12278553templed
tempted12317283tempted
tench105620003tench__
tended83819483te_nded
tenoned839363tenoned
tensed74817833te_nsed
tentacled1244953tentacled
tented74221003te_nted
tentered96412103tentered
tenured838363tenured
terce75721843terc_e_
tercel83612993terc_el
terces83921413terc_es
tercet83624913terc_et
termed94816703te_rmed
tested74421523te_sted
tetchiest1445793tetchiest
tetchily1644123tetchily
teth76327883tet_h__
tethered1238493tethered
tethers103815313tet_hers
teths85418513tet_h_s
tetrad73612053tet_rad
tetrode839333tetrode
tetter64322453tet_ter
teuch105214853teuch__
tewed94718533te__wed
textured1695483textured
thacked173810203thacked
thatcher1635653thatcher
thatches1637513thatches
thighed1535263thighed
ticced11438443t_icced
ticked134720523t_icked
tierced10347053tierc_ed
tincted1037273tincted
tithe85319703tit_he_
tither94920283tit_her
tithes94720213tit_hes
titled73815003tit_led
tocher114014913t_ocher
toothed113310243toothed
torches123715433torches
totaled839693totaled
toted64929483tot__ed
tother94117143tot_her
totted74319953tot_ted
touche114916173touche_
toucher124814353toucher
touches125118343touches
toughed123511693toughed
traced94821583trac_ed
trachea12311673trachea
tracheid1437583tracheid
trachled1438313trachled
tracked143716133tracked
trashed113514693trashed
trencher13279313trencher
trenches133512603trenches
triced95518673tric_ed
tricked144016163tricked
troche113112513troche_
trochee122613873trochee
troches123715343troches
trocked144312243trocked
trothed114010973trothed
truced95312053truc_ed
trucked143910813trucked
tucked134017493t_ucked
tusche1136783tusche_
tusches1237903tusches
tushed104615893t_ushed
tutored837553tutored
tutoyed1133943tutoyed
tutted75117443tut_ted
tutued7349413tut_ued
twitcher16135343twitcher
twitches16156373twitches
tythe115210453tyt_he_
tythes12419703tyt_hes
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 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340274277.06318975.9
3Display Results4274270.1562737.2
 (SQL Overall)1786914277.35924282.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.