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

527 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
patched15351462(None) 
batched154114241batched
hatched163414461hatched
latched133914061latched
matched153513961matched
parched154013691parched
patcher143515141patcher
patches143320381patches
pitched153512921pitched
watched163012821watched
ached119227832_a_ched
arched125717322_arched
bached145519892ba_ched
batcher144414852batcher
batches144019612batches
bathed125518742bat_hed
bitched153212922bitched
botched153611902botched
cached145419202ca_ched
catcher143115822catcher
catches144320772catches
ditched143711902ditched
etched123613702_etched
fetched163710472fetched
hatchel153510752hatchel
hatcher153314722hatcher
hatches153420272hatches
hatchet153317562hatchet
hitched163312252hitched
hotched163610922hotched
hutched16359882hutched
itched123812022_itched
latches123320122latches
latchet123117902latchet
lathed104718452lat_hed
letched133912052letched
marched153813402marched
matcher143214282matcher
matches143219782matches
notched134210302notched
paced106931682pa_c_ed
packed154822602pa_cked
parches143720002parches
pashed125923142pa_shed
patch125221222patch__
patchers153413302patchers
patchier15319662patchier
patchy16509572patch_y
pated85237842pat__ed
patined105114782patined
patted94724682pat_ted
paunched1645522paunched
peached154315882peached
peched144915342p_eched
perched154713232perched
pinched153812452pinched
pitcher143813712pitcher
pitches143617752pitches
pithed124615612pit_hed
poached154212402poached
pooched152810082pooched
pouched153612772pouched
psyched1843912psyched
punched153512172punched
ranched133113602ranched
ratches123620462ratches
ratchet124218332ratchet
repatched1745312repatched
retched133814272retched
satchel123310302satchel
snatched14157632snatched
spathed134013182spat_hed
tetched133010772tetched
thatched1735432thatched
unpatched1744052unpatched
watcher153113402watcher
watches153017372watches
witched163012192witched
aahed917816443_a_ahed
aced79540883_a_c_ed
ache96829823_a_che_
aches106132293_a_ches
acned87520673_a_cned
acred87126353_a_cred
acted88521733_a_cted
ahed89536253_a__hed
aitches123014363aitches
apache134210773apache_
apaches143411833apaches
arced88224163_arc_ed
archer115016243_archer
arches114822043_arches
arcked136211943_arcked
ashed97829773_a_shed
atoned75417543_atoned
attached14165703attached
baches135426943ba_ches
backed155725723ba_cked
bashed126225703ba_shed
batch124620103batch__
batchers153613273batchers
bated85935533bat__ed
bathe105822883bat_he_
bather115322513bat_her
bathes116524833bat_hes
batiked1435963batiked
batted95623653bat_ted
battled104213123battled
beached154516553beached
belched154011843belched
benched154713943benched
birched15349913birched
bitchen14349733bitchen
bitches144117063bitches
blanched16308603blanched
blotched1635653blotched
botcher143613223botcher
botches143716023botches
branched163210453branched
bunched154312413bunched
butcher143411163butcher
butches144315363butches
caboched1844043caboched
cache125122483ca_che_
caches137926913ca_ches
cachet134526413ca_chet
capuched1843743capuched
cashed125124353ca_shed
catch125120373catch__
catchers153114063catchers
catchier15329863catchier
catchup1644793catchup
catchy16559583catch_y
catered103117773catered
cathead1338753cat_head
catted95422473cat_ted
cinched153910863cinched
cliched153711023cliched
clutched16356033clutched
coached153313843coached
couched154115793couched
cranched163210413cranched
cratches153012543cratches
crotched16428593crotched
crutched16307463crutched
cutches143216463cutches
danced105315253danc_ed
dashed115920563da_shed
datcha1266563datch_a
datchas1347423datchas
dated75530993dat__ed
despatched1953233despatched
detached1537733detached
dispatched1993883dispatched
ditcher134012003ditcher
ditches133215713ditches
douched144012113douched
earthed1139923earthed
eched116919223__eched
etcher113912943_etcher
etches114217763_etches
faced117727653fa_c_ed
faithed1437163faithed
fancied133310603fancied
farced125216533farc_ed
fashed136720253fa_shed
fated95632133fat__ed
fathead1437863fat_head
father125116713fat_her
fatted105419843fat_ted
fetcher153510393fetcher
fetches153413893fetches
filched16307423filched
fitchee152710783fitchee
fitches153516193fitches
fitchet153113563fitchet
fitchew18276803fitchew
fletched17306693fletched
flitched17256293flitched
gashed116321973ga_shed
gated75329773gat__ed
gather104115853gat_her
gauche1238553gauche_
gaucher1337233gaucher
grutched15284673grutched
hacked164923513ha_cked
hashed136021943ha_shed
hatch135719593hatch__
hatcheck2244013hatcheck
hatcheled1844223hatcheled
hatchels16368673hatchels
hatchers163113173hatchers
hatchery19326383hatchery
hatchets163310383hatchets
hated95734023hat__ed
hatred104814333hat_red
hatted104921513hat_ted
haunched1744813haunched
hitcher153712003hitcher
hitches153616273hitches
hotches153814363hotches
hunched163710493hunched
hutches153613523hutches
inarched1486113inarched
inched124514483_inched
itches114916213_itches
jacked204817523ja_cked
ketches164012193ketches
kitchen16287683kitchen
kithed144613013kit_hed
klatches17157133klatches
kvetched2142783kvetched
kythed17407313kyt_hed
laced87132643la_c_ed
laches116528343la_ches
lacked135324653la_cked
lanced93717723lanc_ed
larchen12479623larchen
larches124416443larches
lashed105625213la_shed
latch104620463latch__
latchets133410013latchets
latchkey2042913latchkey
lated65240673lat__ed
latened8711923latened
lathe85626713lat_he_
lather95124353lat_her
lathes95127493lat_hes
laughed1235893laughed
launched1475403launched
leached133715043leached
leched123716003_leched
leeched13369503leeched
letches124015483letches
loathed11419443loat_hed
lunched133911823lunched
lurched13358033lurched
lynched16376753lynched
maced108528693ma_c_ed
mache125925303ma_che_
maches134827233ma_ches
macled116718113ma_cled
manche133515103manche_
manches143818623manches
manchet143317773manchet
marchen143312073marchen
marcher143912973marcher
marches143921173marches
mashed125325043ma_shed
match125621103match__
matchers153012433matchers
matchup1643513matchup
mated85537783mat__ed
matted94521413mat_ted
matured10310033matured
miched143913393_miched
mispatched2053833mispatched
mooched153910533mooched
mouched153612593mouched
mulched15307763mulched
munched153411073munched
mutches143314283mutches
naches114622413na_ches
nacred95212493na_cred
natch105018223natch__
natured838963natured
nautches1336083nautches
niched125514063_niched
notcher123610933notcher
notches123513653notches
ouched124316933_ouched
outchid1338723outchid
pace86345773pa_c_e_
pacer96131613pa_c_er
paces96741113pa_c_es
pacey126720283pa_c_ey
pacha126518063pa_ch_a
pachas135017143pa_chas
pacier105018683pa_cier
packer144223403pa_cker
packet144726503pa_cket
padded114113503pa_dded
paddled123612023paddled
paged95926783pa__ged
paiked135113433pa_iked
painches1588913painches
pained95622853pa_ined
painted104214633painted
paired95017523pa_ired
palaced124110773palaced
paled85538723pa__led
palled94625163pa_lled
palmed114314643pa_lmed
palped114513643pa_lped
palsied102911303palsied
paltered113012483paltered
panache1458423panache_
panaches15310283panaches
pancaked1734893pancaked
panchax2134983panchax
pandied113913443pandied
paned85437183pa__ned
paneled10612573paneled
panged104722333pa_nged
panicked1785173panicked
panicled13106783panicled
panned94123433pa_nned
panoche1456383panoche_
panoches1548123panoches
panted95024823pa_nted
panther12611443panther
pantiled113111593pantiled
papered122513163papered
paraded114014263paraded
parcel103915473parc_el
parceled1338333parceled
parch125123003parch__
parchesi15358213parchesi
pared86946763pa__red
parged104922043pa_rged
parked134425143pa_rked
parled94626283pa_rled
paroled104217623paroled
parred95024073pa_rred
parried103615723parried
parsed96323893pa_rsed
parted94228683pa_rted
partied103516553partied
paschal14157243paschal
pashes115828393pa_shes
passed94320943pa_ssed
pasted94426903pa_sted
pastiche1546933pastiche_
pastiches1637453pastiches
pastored1139963pastored
pastured1138233pastured
patchiest1638353patchiest
patchily1885813patchily
patching163212753patching
pate65350463pat__e_
paten74827343pat__en
patented1188893patented
pater74740723pat__er
pates76047893pat__es
path99134913pat_h__
pathos115516693pat_hos
paths105521383pat_h_s
patinaed11407833patinaed
patine85328123patine_
patines95225763patines
patsies93919483patsies
pattee84323383pat_tee
patten84418193pat_ten
pattened11299393pattened
patter84628263pat_ter
pattered112714203pattered
pattie84020963pattie_
patties93425143patties
patzer173111643pat_zer
paunches1568173paunches
paused95114963pa_used
paved115525263pa__ved
paveed12438893pa_veed
pawed115725613pa__wed
pawned124513283pa_wned
paycheck2442553paycheck
payed115925933pa__yed
peaced115818913peac_ed
peacher144216073peacher
peaches144120053peaches
pecked155019103p_ecked
percher143313423percher
perches143717953perches
petaled103614143petaled
petered103314963petered
petted94121523pet_ted
pettled103611503pettled
picked154421313p_icked
pieced113912103piec_ed
pincher143812713pincher
pinches144117933pinches
pished124817063p_ished
pitch125018413pitch__
pitchers153211483pitchers
pitchier15368273pitchier
pitchmen1744333pitchmen
pitchy16479673pitch_y
pithead13419593pit_head
pitied94017253pit_ied
pitted94319593pit_ted
placed114318003plac_ed
planche14299753planche_
planches153111863planches
planchet152511963planchet
plashed133712643plashed
plated95225773plat__ed
platted103614263plat_ted
pleached16338063pleached
plucked16367963plucked
poacher143912323poacher
poaches144416943poaches
pocked154818983p_ocked
ponced114314813ponc_ed
ponchoed1646133ponchoed
pooches143214163pooches
poohed123912523p_oohed
porches143815673porches
pothead133810393pot_head
pother113818853pot_her
potiche1438043potiche_
potiches1539203potiches
potlatched18112453potlatched
potsherd1434813potsherd
potted94624013pot_ted
pouches144116743pouches
pranced123714043pranc_ed
prated94924923prat__ed
prattled11246533prattled
preached163412063preached
priced115018883pric_ed
pricked164613833pricked
proceed12310543proceed
psyche1674293psyche_
psyches1755803psyches
puncher143311673puncher
punches144816133punches
pushed125017463p_ushed
putsches1535313putsches
putted94220253put_ted
puttied103811163puttied
putzed18409113put_zed
raced87635313ra_c_ed
rachet115028973ra_chet
racked134526083ra_cked
ralphed1334363ralphed
rancher123013633rancher
ranches123620113ranches
ratch104221363ratch__
ratcheted1554783ratcheted
ratchets133110263ratchets
rated65441383rat__ed
rathe85821923rat_he_
rather94319743rat_her
ratted74923343rat_ted
rattled84012953rattled
reached134619083reached
rematched1745223rematched
repatches1636713repatches
retches123318513retches
roached133211833roached
rotche114311983rotche_
rotches123515703rotches
ruched124314633_ruched
sachem134012223sa_chem
sachet114725773sa_chet
sacked135525213sa_cked
sacred94917103sa_cred
sashed105622943sa_shed
satcheled1544423satcheled
satchels13328163satchels
sated66238533sat__ed
sauced93913303sauc_ed
scathed134012643scat_hed
scotched16187933scotched
scratched1735393scratched
scutched16186893scutched
searched14209253searched
sketched1835393sketched
slatches131511523slatches
smutched16165923smutched
snatcher13167763snatcher
snatches131410713snatches
snitched14166863snitched
spaced114517253spa_c_ed
spathe115115693spat_he_
spathes125116533spat_hes
spatted104014143spat_ted
splotched1742823splotched
stacked143416123stacked
stanched14208903stanched
starched14199313starched
stashed113812493stashed
stitched14148203stitched
swatches16169963swatches
swathed144611933swat_hed
switched17157133switched
synched16277213synched
tache106222373ta_che_
taches114224173ta_ches
tacked134723943ta_cked
talced93811003talc_ed
talcked1446343talcked
tatted74920533tat_ted
tattled84311483tattled
teched124014433_teched
thatcher1635663thatcher
thatches1637513thatches
tithed104115593tit_hed
torched133511353torched
touched134914963touched
twitched17155033twitched
tythed13457503tyt_hed
unarched14128553unarched
unhatched1844133unhatched
unlatched1544213unlatched
unmatched1744203unmatched
unwatched1844083unwatched
vatted104214733vat_ted
vetches153411263vetches
vouched163910563vouched
washed135521503wa_shed
watch135617063watch__
watchers163511793watchers
watcheye19104273watcheye
watchmen1844753watchmen
watered113014953watered
wattled113610503wattled
wauchted1753373wauchted
welched16298833welched
wenched163910913wenched
winched163110593winched
witches152715793witches
withed134416233wit_hed
wrathed14298523wrat_hed
wretched17276533wretched
yachted1634853ya_chted
yacked164516793ya_cked

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.1561145455.1
2DLD Change Limit1340275277.44018014.4
3Display Results5275270.1862833.3
 (SQL Overall)1786915277.78222962.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.