Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “stanched” with Change Limit: [1] [2] [3]

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

252 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
stanched	14	20	890	(None)
stancher	13	19	881	1	stancher
stanches	13	23	1279	1	stanches
starched	14	19	931	1	starched
staunched	15	5	347	1	staunched
blanched	16	30	860	2	blanched
branched	16	32	1045	2	branched
cranched	16	32	1041	2	cranched
ranched	13	31	1360	2	_ranched
searched	14	20	925	2	searched
snatched	14	15	763	2	snatched
stacked	14	34	1612	2	sta_cked
stance	8	43	1691	2	stanc_e_
stances	9	37	1596	2	stanc_es
stanch	11	38	1237	2	stanch__
stanchers	14	20	681	2	stanchers
stanchest	14	21	821	2	stanchest
stanchly	16	4	444	2	stanchly
staned	7	48	2464	2	stan__ed
stanged	9	41	1384	2	stan_ged
stanzaed	18	4	387	2	stanzaed
starches	13	19	1291	2	starches
stashed	11	38	1249	2	sta_shed
stauncher	14	4	351	2	stauncher
staunches	14	4	460	2	staunches
stenches	13	21	1029	2	stenches
stitched	14	14	820	2	stitched
synched	16	27	721	2	s_ynched
ached	11	92	2783	3	__a_ched
arched	12	57	1732	3	__arched
attached	14	16	570	3	attached
bached	14	55	1989	3	_ba_ched
batched	15	41	1424	3	_batched
beached	15	45	1655	3	bea_ched
benched	15	47	1394	3	_benched
blancher	15	33	863	3	blancher
blanches	15	33	1160	3	blanches
blenched	16	35	805	3	blenched
branches	15	36	1380	3	branches
brunched	16	31	785	3	brunched
bunched	15	43	1241	3	_bunched
cached	14	54	1920	3	_ca_ched
chanced	15	41	1321	3	chanc_ed
cinched	15	39	1086	3	_cinched
clenched	16	25	776	3	clenched
clinched	16	34	738	3	clinched
coached	15	33	1384	3	coa_ched
cranches	15	31	1454	3	cranches
craunched	17	6	402	3	craunched
crunched	16	32	816	3	crunched
danced	10	53	1525	3	_danc_ed
detached	15	3	773	3	deta_ched
distanced	13	4	857	3	distanc_ed
drenched	15	24	791	3	drenched
etched	12	36	1370	3	et__ched
fancied	13	33	1060	3	_fancied
flenched	17	26	796	3	flenched
flinched	17	31	670	3	flinched
frenched	17	29	943	3	frenched
glanced	11	43	923	3	glanc_ed
glunched	15	4	426	3	glunched
hatched	16	34	1446	3	_hatched
haunched	17	4	481	3	haunched
hunched	16	37	1049	3	_hunched
inarched	14	8	611	3	inarched
inched	12	45	1448	3	__inched
instanced	12	4	570	3	instanc_ed
itched	12	38	1202	3	it__ched
lanced	9	37	1772	3	_lanc_ed
latched	13	39	1406	3	_latched
launched	14	7	540	3	launched
leached	13	37	1504	3	lea_ched
lunched	13	39	1182	3	_lunched
lynched	16	37	675	3	_lynched
manche	13	35	1510	3	_manche_
manches	14	38	1862	3	_manches
manchet	14	33	1778	3	_manchet
marched	15	38	1340	3	_marched
matched	15	35	1396	3	_matched
munched	15	34	1107	3	_munched
mustached	17	16	483	3	musta_ched
nuanced	10	3	620	3	nuanc_ed
parched	15	40	1369	3	_parched
patched	15	35	1462	3	_patched
paunched	16	4	552	3	paunched
peached	15	43	1588	3	pea_ched
pinched	15	38	1245	3	_pinched
planche	14	29	975	3	planche_
planches	15	31	1186	3	planches
planchet	15	25	1196	3	planchet
poached	15	42	1240	3	poa_ched
pranced	12	37	1404	3	pranc_ed
punched	15	35	1217	3	_punched
quenched	23	3	410	3	quenched
rancher	12	30	1363	3	_rancher
ranches	12	36	2011	3	_ranches
reached	13	46	1908	3	rea_ched
roached	13	32	1183	3	roa_ched
sachem	13	40	1222	3	s_a_chem
sachet	11	47	2577	3	s_a_chet
sacked	13	55	2521	3	s_a_cked
sacred	9	49	1710	3	s_a_cred
sanded	8	49	2061	3	s_an_ded
saned	6	56	3627	3	s_an__ed
sashed	10	56	2294	3	s_a_shed
satchel	12	33	1030	3	s_atchel
sauced	9	39	1330	3	s_auc_ed
scanned	10	41	1089	3	scan_ned
scanted	10	41	1439	3	scan_ted
scarphed	16	3	544	3	scarphed
scathed	13	40	1264	3	sca_thed
sconced	12	35	917	3	sconc_ed
scooched	16	20	668	3	scooched
scorched	16	18	719	3	scorched
scotched	16	18	793	3	scotched
scraiched	17	4	420	3	scraiched
scratched	17	3	539	3	scratched
scrunched	17	4	403	3	scrunched
scutched	16	18	689	3	scutched
seance	8	37	1669	3	seanc_e_
seances	9	30	1534	3	seanc_es
searcher	13	20	910	3	searcher
searches	13	21	1290	3	searches
shacked	17	40	1539	3	sha_cked
shanked	15	32	1212	3	shan_ked
skanked	11	33	810	3	skan_ked
sketched	18	3	539	3	sketched
slacked	14	38	1545	3	sla_cked
slanged	9	41	1285	3	slan_ged
slanted	8	35	1474	3	slan_ted
slashed	11	41	1485	3	sla_shed
slatches	13	15	1152	3	slatches
slouched	14	20	674	3	slouched
smacked	16	37	1099	3	sma_cked
smashed	13	37	1122	3	sma_shed
smirched	16	3	467	3	smirched
smooched	16	18	598	3	smooched
smutched	16	16	592	3	smutched
snacked	14	40	1311	3	sna_cked
snatcher	13	16	776	3	snatcher
snatches	13	14	1071	3	snatches
snitched	14	16	686	3	snitched
spaced	11	45	1725	3	spa_c_ed
spancel	11	4	736	3	spanc_el
spanceled	14	4	369	3	spanceled
spangled	12	3	615	3	spangled
spanked	14	31	1173	3	span_ked
spanned	10	41	1122	3	span_ned
spathed	13	40	1318	3	spa_thed
squinched	24	4	308	3	squinched
stabbed	12	35	1037	3	sta_bbed
stabled	10	35	1495	3	sta_bled
stacker	13	44	1626	3	sta_cker
stacte	8	21	1391	3	sta_cte_
stactes	9	19	1463	3	sta_ctes
staffed	14	29	828	3	sta_ffed
staged	8	45	2156	3	sta__ged
stagged	10	42	1208	3	sta_gged
stagnated	11	4	514	3	stagnated
stained	8	42	1534	3	sta_ined
stairhead	13	4	332	3	stairhead
staithe	10	3	772	3	staithe_
staithes	11	3	895	3	staithes
staked	11	46	2194	3	sta__ked
staled	7	47	2810	3	sta__led
stalked	12	38	1117	3	sta_lked
stalled	8	35	1568	3	sta_lled
stamened	11	3	763	3	stamened
stamped	12	48	1281	3	sta_mped
stanching	15	3	808	3	stanching
stanchion	14	4	464	3	stanchion
stanchioned	17	5	223	3	stanch~~ion~~ed
stand	6	59	2328	3	stan___d
standard	10	4	625	3	standard
standee	8	35	1451	3	stan_dee
standees	9	33	1014	3	standees
stander	8	43	1616	3	stan_der
stane	5	59	3300	3	stan__e_
stanes	6	49	3340	3	stan__es
stanine	7	34	1707	3	stanine_
stanines	8	51	1567	3	stanines
stapled	10	36	1370	3	sta_pled
starch	11	30	1320	3	starch__
starchier	14	3	664	3	starchier
starchy	15	28	674	3	starch_y
stared	7	54	2987	3	sta__red
starred	8	50	1345	3	sta_rred
started	8	42	1732	3	sta_rted
startled	9	20	856	3	startled
starved	11	49	1157	3	sta_rved
stashes	10	39	1617	3	sta_shes
stated	7	54	2783	3	sta__ted
statued	8	45	989	3	sta_tued
staunch	12	4	427	3	staunch__
staunchest	15	4	312	3	staunchest
staunchly	17	4	203	3	staunchly
staved	10	39	1805	3	sta__ved
stayed	10	48	1727	3	sta__yed
stench	11	41	1116	3	stench__
stenchier	14	4	533	3	stenchier
stenchy	15	25	621	3	stench_y
stenciled	12	4	396	3	stenciled
stenosed	9	4	634	3	stenosed
sticked	14	41	1463	3	st_icked
stinted	8	29	1419	3	stin_ted
stitcher	13	16	839	3	stitcher
stitches	13	14	1059	3	stitches
stocked	14	43	1287	3	st_ocked
stomached	17	9	401	3	stomached
stoned	7	59	2314	3	ston__ed
stonished	13	4	559	3	stonished
stranded	10	27	1081	3	stran_ded
strangled	11	26	898	3	strangled
stretched	15	4	621	3	stretched
stuccoed	13	5	285	3	stuccoed
stunned	8	35	889	3	stun_ned
stunted	8	30	1040	3	stun_ted
swacked	17	31	1052	3	swa_cked
swanherd	15	3	348	3	swan_herd
swanked	15	35	954	3	swan_ked
swanned	11	35	817	3	swan_ned
swashed	14	43	1136	3	swa_shed
swatches	16	16	996	3	swatches
swathed	14	46	1193	3	swa_thed
switched	17	15	713	3	switched
synced	12	26	696	3	s_ync_ed
tache	10	62	2237	3	_ta_che_
taches	11	42	2417	3	_ta_ches
tacked	13	47	2394	3	_ta_cked
talced	9	38	1100	3	_talc_ed
talcked	14	4	634	3	_talcked
tanged	8	46	2249	3	_tan_ged
tangled	9	42	1463	3	_tangled
tangoed	9	31	883	3	_tangoed
tanked	11	39	1929	3	_tan_ked
tanned	7	52	1995	3	_tan_ned
teched	12	40	1443	3	_t_eched
tenches	12	35	1552	3	_tenches
tetched	13	30	1077	3	_tetched
thatched	17	3	543	3	thatched
tincted	10	3	727	3	_tincted
torched	13	35	1135	3	_torched
touched	13	49	1496	3	_touched
tranced	10	44	1417	3	tranc_ed
tranche	12	33	1222	3	tranche_
tranches	13	29	1551	3	tranches
trenched	14	28	985	3	trenched
unarched	14	12	855	3	unarched
watched	16	30	1282	3	_watched
wenched	16	39	1091	3	_wenched
winched	16	31	1059	3	_winched
wrenched	17	74	813	3	wrenched

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	146162	0.420	425454.8
2	DLD Change Limit	146162	252	7.876	18557.9
3	Display Results	252	252	0.110	2290.9
	(SQL Overall)	178691	252	8.406	21257.6