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

478 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
ketches16401219(None) 
etches114217761_etches
fetches153413891fetches
kenches163912271kenches
kvetches2053581kvetches
letches124015481letches
retches123318511retches
sketches1746821sketches
vetches153411261vetches
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
ketch144912022ketch__
ketchup1842782ketchup
ketchups1941892ketchups
ketenes114813502ketenes
ketones115014502ketones
ketoses114912872ketoses
kettles113411612kettles
kitchen16287682kitchen
kitchens17195782kitchens
kithes135016652kit_hes
kitsches1734072kitsches
klatches17157132klatches
kvetched2142782kvetched
kvetcher2052812kvetcher
kvetchers2142372kvetchers
kythes16499132kyt_hes
latches123320122latches
leaches123319342leaches
leches115421312le_ches
leeches123911932leeches
letched133912052letched
lethes94818082let_hes
matches143219782matches
merches144013762merches
mutches143314282mutches
notches123513652notches
patches143320382patches
peaches144120052peaches
perches143717952perches
pitches143617752pitches
ratches123620462ratches
reaches123423202reaches
retched133814272retched
rotches123515702rotches
seiches12513812seiches
sketched1835392sketched
sketcher1735432sketcher
sketchers1834512sketchers
teaches122718352teaches
tenches123515522tenches
tetched133010772tetched
watches153017372watches
welches153710312welches
wenches152914132wenches
witches152715792witches
wretches16257282wretches
aches106132293__aches
aether94213673aet_her
aethers103614943aet_hers
apaches143411833apaches
arches114822043_arches
attaches13137723attaches
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
glitches14296653glitches
gotchas1334613gotchas
grutches14285853grutches
gulches13398103gulches
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
kebbies1537253kebbies
kecked125113173ke_cked
keckles12318763keckles
kecks105416573ke_c_ks
kedges124812983ke_dges
keeves133711993ke_eves
kellies113516853kellies
kelpies13289903kelpies
kench145513923kench__
kentes105118653ke_ntes
kerchief2043873kerchief
kerchiefs2141763kerchiefs
kerchoo1644973kerchoo
kermes124616133ke_rmes
kernes104717533ke_rnes
kerries113317913kerries
ketene106613003ketene_
ketols104210763ket_ols
ketone105014533ketone_
ketose105711813ketose_
ketosis11429733ketosis
kettle104311613kettle_
kewpies16246923kewpies
kexes166216823ke__xes
kheths16495973khet_h_s
kimchee1845603kimchee
kimchees1942943kimchees
kimchis1843733kimchis
kirsches1743843kirsches
kites95432543kit__es
kithe125917453kit_he_
kithed144613013kit_hed
kiths125814973kit_h_s
kitties113213623kitties
kittles113012493kittles
klatsches1842223klatsches
knishes1438263knishes
kuchen1536653k_uchen
kuchens1634713k_uchens
kvetch1832993kvetch__
kvetchier2141863kvetchier
kvetchiest2241953kvetchiest
kvetchy2241803kvetch_y
kwachas1943063kwachas
kytes125012913kyt__es
kythe15509673kyt_he_
kythed17407313kyt_hed
laches116528343_laches
larches124416443larches
latched133914063latched
latchet123117903latchet
latchets133410013latchets
lathes95127493lat_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
resketches1942963resketches
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
sketch1535363sketch__
sketchier1853413sketchier
sketchiest1943163sketchiest
sketchy1943053sketch_y
slatches131511523slatches
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
torches123715433torches
touches125118343touches
trenches133512603trenches
troches123715343troches
tusches1237903tusches
twitches16156373twitches
tythes12419703tyt_hes
vetch134411843vetch__
vetoes92914083vet_oes
vouches153914113vouches
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 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.406440125.6
2DLD Change Limit1340274786.58020368.8
3Display Results4784780.1862569.9
 (SQL Overall)1786914787.17224915.1
 
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.