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

Here are the results of your fuzzy-string dictionary search for “broached” 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
broached	16	30	912	(None)
breached	16	34	1164	1	breached
broacher	15	32	926	1	broacher
broaches	15	32	1162	1	broaches
roached	13	32	1183	1	_roached
bached	14	55	1989	2	b__ached
beached	15	45	1655	2	b_eached
bleached	16	37	856	2	bleached
blotched	16	3	565	2	blotched
botched	15	36	1190	2	b_otched
braced	11	54	2060	2	br_ac_ed
braches	14	46	2122	2	br_aches
brachet	14	40	2031	2	br_achet
bracted	12	4	1093	2	br_acted
branched	16	32	1045	2	branched
breacher	15	30	1150	2	breacher
breaches	15	37	1412	2	breaches
breathed	14	46	964	2	breathed
breeched	16	33	738	2	breeched
broach	13	36	1111	2	broach__
broachers	16	32	815	2	broachers
brocaded	14	3	635	2	brocaded
broche	13	36	1210	2	bro_che_
brooches	15	28	819	2	brooches
brunched	16	31	785	2	brunched
coached	15	33	1384	2	_coached
crotched	16	42	859	2	crotched
crouched	16	35	914	2	crouched
grouched	15	35	666	2	grouched
poached	15	42	1240	2	_poached
preached	16	34	1206	2	preached
reached	13	46	1908	2	_reached
roaches	12	36	1621	2	_roaches
abreacted	14	4	429	3	abreacted
abroach	14	4	621	3	abroach__
ached	11	92	2783	3	___ached
approached	20	6	236	3	approached
arched	12	57	1732	3	ar__ched
attached	14	16	570	3	attached
avouched	17	4	358	3	avouched
baches	13	54	2694	3	b__aches
backed	15	57	2572	3	b__acked
barnacled	14	4	400	3	barnacled
barouche	15	4	417	3	barouche_
barouches	16	4	497	3	barouches
barracked	18	4	475	3	barracked
bashed	12	62	2570	3	b__ashed
batched	15	41	1424	3	b_atched
bathed	12	55	1874	3	b__athed
beaches	14	41	2065	3	b_eaches
belaced	12	41	1215	3	belac_ed
belched	15	40	1184	3	b_elched
benched	15	47	1394	3	b_enched
berdache	16	4	403	3	berdache_
berdaches	17	4	505	3	berdaches
birched	15	34	991	3	b_irched
bitched	15	32	1292	3	b_itched
blacked	16	36	1337	3	b_lacked
blanched	16	30	860	3	blanched
bleacher	15	35	888	3	bleacher
bleaches	15	34	1067	3	bleaches
blenched	16	35	805	3	blenched
bloated	10	45	1343	3	bloa_ted
blocked	16	44	998	3	blo_cked
blotches	15	3	743	3	blotches
boarded	11	39	1050	3	b_oarded
boasted	10	41	1374	3	b_oasted
boated	9	42	2197	3	b_oa_ted
boche	12	42	1695	3	b_o_che_
boches	13	46	1852	3	b_o_ches
boraces	11	37	1685	3	borac_es
borated	10	41	1636	3	bora_ted
borsches	15	3	600	3	borsches
botcher	14	36	1322	3	b_otcher
botches	14	37	1602	3	b_otches
bouchee	14	33	1354	3	b_ouchee
boughed	14	38	1026	3	b_oughed
brace	9	56	2927	3	br_ac_e_
bracer	10	46	2058	3	br_ac_er
braces	10	84	2777	3	br_ac_es
brach	12	61	2330	3	br_ach__
brachets	15	43	1198	3	br_achets
brachia	14	19	1042	3	br_achia
brachs	13	44	1575	3	br_ach_s
bracken	15	40	981	3	br_acken
bracket	15	41	1723	3	br_acket
bradded	12	38	871	3	br_added
bragged	12	44	984	3	br_agged
braided	11	40	1321	3	br_aided
brailed	10	39	1401	3	br_ailed
brained	10	38	1610	3	br_ained
braised	10	40	1480	3	br_aised
braked	13	53	1869	3	br_a_ked
branches	15	36	1380	3	branches
branded	11	44	1410	3	br_anded
branned	10	43	1169	3	br_anned
brasher	12	45	1524	3	br_asher
brashes	12	45	1846	3	br_ashes
brassed	10	36	1237	3	br_assed
braved	12	48	1744	3	br_a_ved
bravoed	13	43	611	3	br_avoed
brawled	13	39	1012	3	br_awled
brayed	12	46	1578	3	br_a_yed
brazed	18	47	1708	3	br_a_zed
breach	13	42	1372	3	breach__
breachers	16	36	985	3	breachers
breaded	11	50	1406	3	brea_ded
breamed	12	40	1159	3	brea_med
breasted	11	3	882	3	breasted
breathe	12	37	1184	3	breathe_
breather	13	36	1059	3	breather
breathes	13	42	1290	3	breathes
breeches	15	25	867	3	breeches
bricked	16	43	1206	3	br_icked
brioche	14	27	592	3	brioche_
brioches	15	22	725	3	brioches
britches	15	27	868	3	britches
broaching	17	28	766	3	broaching
broad	8	48	1769	3	broa___d
broaden	10	28	914	3	broa_den
broadened	13	6	433	3	broadened
broader	10	34	1261	3	broa_der
brocade	12	3	853	3	brocade_
brocades	13	5	871	3	brocades
brocatel	12	4	671	3	brocatel
brocket	15	40	1338	3	bro_cket
broiled	10	38	1142	3	bro_iled
brokered	15	3	608	3	brokered
bromated	13	3	917	3	bromated
bromized	22	21	590	3	bromized
bronchi	14	17	631	3	bronch_i
bronchia	15	19	599	3	bronchia
broncho	14	20	646	3	bronch_o
bronchos	15	20	617	3	bronchos
bronchus	15	20	474	3	bronchus
bronzed	19	30	821	3	bro_nzed
brooch	13	36	844	3	brooch__
brooded	11	35	1093	3	bro_oded
brooked	14	36	1003	3	bro_oked
broomed	12	41	1105	3	bro_omed
brothel	12	31	819	3	bro_thel
brother	12	33	1133	3	bro_ther
browed	12	52	1639	3	bro__wed
browned	13	47	1097	3	bro_wned
browsed	13	45	1123	3	bro_wsed
bruncher	15	34	778	3	bruncher
brunches	15	37	1045	3	brunches
brushed	13	38	1121	3	br_ushed
bunched	15	43	1241	3	b_unched
cached	14	54	1920	3	__cached
caroaches	16	3	779	3	caroaches
coacher	14	37	1412	3	_coacher
coaches	14	40	1869	3	_coaches
coacted	12	36	1161	3	_coacted
couched	15	41	1579	3	_couched
cracked	16	35	1474	3	cr_acked
cranched	16	32	1041	3	cranched
crashed	13	42	1420	3	cr_ashed
croaked	14	37	1053	3	croa_ked
crochet	14	36	1666	3	cro_chet
crocked	16	40	1443	3	cro_cked
crotches	15	34	1130	3	crotches
crotchet	15	27	1199	3	crotchet
crouches	15	37	1129	3	crouches
crunched	16	32	816	3	crunched
crutched	16	30	746	3	crutched
detached	15	3	773	3	detached
douched	14	40	1211	3	_douched
drenched	15	24	791	3	drenched
encroached	18	4	268	3	encroached
fracted	13	3	937	3	fr_acted
frenched	17	29	943	3	frenched
frocked	17	43	933	3	fro_cked
frothed	14	28	878	3	fro_thed
graced	10	52	1790	3	gr_ac_ed
graphed	14	9	847	3	gr_aphed
groaned	9	25	997	3	groa_ned
groschen	14	4	297	3	groschen
grouches	14	32	821	3	grouches
grutched	15	28	467	3	grutched
hotched	16	36	1092	3	_hotched
leached	13	37	1504	3	_leached
loaches	12	36	1398	3	_loaches
loathed	11	41	944	3	_loathed
mooched	15	39	1053	3	_mooched
mouched	15	36	1259	3	_mouched
notched	13	42	1030	3	_notched
orache	11	40	1359	3	or_ache_
oraches	12	42	1647	3	or_aches
ouched	12	43	1693	3	__ouched
peached	15	43	1588	3	_peached
pleached	16	33	806	3	pleached
poacher	14	39	1232	3	_poacher
poaches	14	44	1694	3	_poaches
pooched	15	28	1008	3	_pooched
pouched	15	36	1277	3	_pouched
preacher	15	32	1137	3	preacher
preaches	15	32	1489	3	preaches
preacted	13	27	1094	3	preacted
proceed	12	3	1055	3	pro_ceed
raced	8	76	3531	3	_r_ac_ed
rachet	11	50	2897	3	_r_achet
racked	13	45	2608	3	_r_acked
ranched	13	31	1360	3	_ranched
reacher	12	37	1829	3	_reacher
reaches	12	34	2320	3	_reaches
reacted	10	30	1571	3	_reacted
reproached	18	5	471	3	reproached
retched	13	38	1427	3	_retched
roach	10	57	1700	3	_roach__
roadbed	11	3	479	3	_roadbed
roamed	9	52	1509	3	_roa_med
roared	7	50	1539	3	_roa_red
roasted	8	39	1266	3	_roasted
rochet	11	54	2300	3	_ro_chet
rocked	13	50	2232	3	_ro_cked
rotche	11	43	1198	3	_rotche_
rotches	12	35	1570	3	_rotches
rouche	11	47	1431	3	_rouche_
rouches	12	42	1789	3	_rouches
roughed	12	42	1094	3	_roughed
ruched	12	43	1463	3	_r_uched
scooched	16	20	668	3	scooched
scorched	16	18	719	3	scorched
scotched	16	18	793	3	scotched
scrooched	17	6	384	3	scrooched
slouched	14	20	674	3	slouched
smooched	16	18	598	3	smooched
stomached	17	9	401	3	stomached
torched	13	35	1135	3	_torched
touched	13	49	1496	3	_touched
traced	9	48	2158	3	tr_ac_ed
trachea	12	3	1167	3	tr_achea
tracheid	14	3	758	3	tr_acheid
trachled	14	3	831	3	tr_achled
tracked	14	37	1613	3	tr_acked
trashed	11	35	1470	3	tr_ashed
trenched	14	28	985	3	trenched
troaked	12	43	825	3	troa_ked
troche	11	31	1251	3	tro_che_
trochee	12	26	1388	3	tro_chee
troches	12	37	1534	3	tro_ches
trocked	14	43	1224	3	tro_cked
trothed	11	40	1097	3	tro_thed
unreached	15	3	688	3	unreached
upreached	17	6	408	3	upreached
vouched	16	39	1056	3	_vouched
wracked	17	41	1011	3	wr_acked
wrathed	14	29	852	3	wr_athed
wreathed	15	25	746	3	wreathed
wrenched	17	74	813	3	wrenched
wretched	17	27	653	3	wretched

Search took 8 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.453	394461.4
2	DLD Change Limit	146162	252	6.470	22590.7
3	Display Results	252	252	0.106	2377.4
	(SQL Overall)	178691	252	7.029	25422.0