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

Here are the results of your fuzzy-string dictionary search for “trowth” 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.

315 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
trowth	12	7	788	(None)
growth	13	7	738	1	growth
rowth	11	57	1323	1	_rowth
troth	8	56	2220	1	tro_th
trowths	13	6	502	1	trowths
broth	10	65	2109	2	bro_th
crwth	13	3	748	2	cr_wth
drouth	10	44	1010	2	drouth
froth	11	59	1928	2	fro_th
growths	14	9	442	2	growths
growthy	17	7	328	2	growthy
routh	8	64	2307	2	_routh
rowths	12	45	817	2	_rowths
tooth	8	80	2018	2	t_ooth
toroth	9	55	1296	2	toroth
trot	4	63	5131	2	tro_t_
troths	9	54	1415	2	tro_ths
trots	5	66	2994	2	tro_ts
trough	10	85	1203	2	trough
trout	5	73	3257	2	trout_
trouts	6	61	1663	2	trouts
trouty	9	52	1179	2	trouty
trow	7	80	3142	2	trow__
trowed	10	47	1465	2	trowed
trowel	9	42	1146	2	trowel
trows	8	88	2618	2	trow_s
truth	8	52	1415	2	tr_uth
wroth	11	68	1588	2	wro_th
azoth	17	38	990	3	azo_th
betroth	12	4	754	3	betro_th
booth	10	55	2201	3	_booth
both	9	65	3343	3	_bo_th
breath	11	39	1626	3	breath
brith	10	49	2437	3	br_ith
broach	13	36	1111	3	broach
brooch	13	36	844	3	brooch
broths	11	50	1392	3	bro_ths
brothy	14	51	962	3	bro_thy
brow	9	72	2844	3	brow__
browed	12	52	1639	3	browed
brown	10	56	1953	3	brow_n
browns	11	64	1563	3	browns
browny	14	45	1004	3	browny
brows	10	54	2598	3	brow_s
browse	11	57	1385	3	browse
cloth	10	58	1754	3	clo_th
coolth	11	3	951	3	coolth
couth	10	61	2249	3	_couth
croft	10	56	2268	3	croft_
crofts	11	49	1059	3	crofts
crotch	13	34	1008	3	crotch
crouch	13	39	1020	3	crouch
croute	8	46	1727	3	croute
crow	9	64	2813	3	crow__
crowd	11	58	1562	3	crow_d
crowds	12	49	1076	3	crowds
crowdy	15	46	717	3	crowdy
crowed	12	47	1730	3	crowed
crower	11	41	1756	3	crower
crown	10	56	2008	3	crow_n
crowns	11	56	1511	3	crowns
crows	10	57	2731	3	crow_s
crwths	14	3	343	3	cr_wths
doeth	9	4	1198	3	_doeth
doth	8	62	2571	3	_do_th
droit	6	51	2712	3	droit_
droits	7	43	1431	3	droits
dropt	8	69	2443	3	dropt_
drouths	11	43	648	3	drouths
drouthy	14	39	517	3	drouthy
drown	9	55	1582	3	drow_n
drownd	11	47	831	3	drownd
drowns	10	56	1233	3	drowns
drowse	10	50	1055	3	drowse
drowsy	13	48	790	3	drowsy
forth	11	62	2267	3	_forth
frith	11	59	2203	3	fr_ith
front	8	50	2922	3	front_
fronts	9	44	1579	3	fronts
frosh	11	57	1340	3	fro_sh
frost	8	47	2783	3	frost_
frosts	9	42	1462	3	frosts
frosty	12	47	1063	3	frosty
froths	12	54	1144	3	fro_ths
frothy	15	57	837	3	fro_thy
frow	10	64	2505	3	frow__
frown	11	54	1597	3	frow_n
frowns	12	60	1139	3	frowns
frows	11	66	2310	3	frow_s
frowst	12	55	1207	3	frowst
frowsts	13	42	610	3	frowsts
frowsty	16	46	498	3	frowsty
frowsy	15	49	827	3	frowsy
frowzy	24	48	579	3	frowzy
goth	8	68	2508	3	_go_th
grith	9	55	2037	3	gr_ith
groat	6	55	3197	3	groat_
groats	7	48	1665	3	groats
grot	5	59	4205	3	gro_t_
grots	6	50	2585	3	gro_ts
grotto	7	34	981	3	grotto
grotty	10	38	983	3	grotty
grouch	12	31	847	3	grouch
grout	6	53	3042	3	grout_
grouts	7	50	1561	3	grouts
grouty	10	47	1098	3	grouty
grow	8	61	2730	3	grow__
grower	10	46	1493	3	grower
growl	9	61	1582	3	grow_l
growls	10	47	1111	3	growls
growly	13	49	917	3	growly
grown	9	53	1735	3	grow_n
grows	9	55	2392	3	grow_s
ingrowth	15	5	302	3	ingrowth
liroth	9	3	838	3	liro_th
loath	8	49	1860	3	_loath
loth	7	61	3213	3	_lo_th
month	10	48	1842	3	_month
moth	9	67	3133	3	_mo_th
mouth	10	54	2029	3	_mouth
north	8	60	1827	3	_north
nowt	7	88	3375	3	_nowt_
nowts	8	69	1586	3	_nowts
oath	7	61	3215	3	__oath
outgrowth	16	6	310	3	outgrowth
pronto	8	3	1399	3	pronto
prost	7	54	3410	3	prost_
prow	9	70	3038	3	prow__
prowar	11	41	1094	3	prowar
prower	11	42	1812	3	prower
prowl	10	56	1512	3	prow_l
prowls	11	55	1108	3	prowls
prows	10	63	2701	3	prow_s
quoth	17	33	1035	3	quo_th
rath	7	60	3766	3	_r_ath
regrowth	15	4	403	3	regrowth
roach	10	57	1700	3	_roach
root	4	56	5592	3	_root_
roots	5	59	3367	3	_roots
rooty	8	64	2302	3	_rooty
rot	3	72	8295	3	_ro_t_
rota	4	58	3434	3	_ro_ta
rotch	10	58	1593	3	_rotch
rote	4	62	4902	3	_ro_te
roti	4	63	3293	3	_ro_ti
rotl	4	50	2968	3	_ro_tl
roto	4	59	3505	3	_ro_to
rots	4	64	5409	3	_ro_ts
rotte	5	46	2593	3	_rotte
rough	9	78	1944	3	_rough
rout	4	61	5328	3	_rout_
route	5	51	3207	3	_route
rouths	9	54	1682	3	_rouths
routs	5	71	3341	3	_routs
row	6	74	5367	3	_row__
rowan	8	54	1873	3	_rowan
rowdy	12	57	1153	3	_rowdy
rowed	9	40	3432	3	_rowed
rowel	8	47	2141	3	_rowel
rowen	8	49	2115	3	_rowen
rower	8	54	3049	3	_rower
rows	7	59	4175	3	_row_s
ruth	7	68	2599	3	_r_uth
scouth	11	50	1115	3	scouth
sloth	8	50	1945	3	slo_th
smooth	11	25	920	3	smooth
sooth	8	59	2406	3	_sooth
soth	7	59	3252	3	_so_th
south	8	52	2357	3	_south
strath	9	32	1637	3	str_ath
strow	8	89	2057	3	strow__
strowed	11	53	1214	3	strowed
strown	9	68	1209	3	strow_n
strows	9	67	1827	3	strow_s
tarot	5	59	4393	3	taro_t_
tarots	6	64	2299	3	taro_ts
teeth	8	73	1585	3	t_eeth
tenth	8	54	2183	3	t_enth
teth	7	63	2789	3	t__eth
though	13	94	1078	3	though
throat	9	48	1975	3	throat_
throats	10	46	1219	3	throats
throaty	13	42	848	3	throaty
through	14	164	752	3	through
throw	11	87	1973	3	throw__
thrower	13	8	699	3	thrower
thrown	12	149	1144	3	throw_n
throws	12	97	1523	3	throw_s
tilth	8	55	1536	3	t_ilth
toft	7	74	4165	3	t_oft_
tofts	8	49	1924	3	t_ofts
toit	4	63	5306	3	t_oit_
toits	5	53	2747	3	t_oits
toot	4	59	5888	3	t_oot_
tooths	9	60	1380	3	t_ooths
toothy	12	52	969	3	t_oothy
toots	5	53	3187	3	t_oots
toph	9	63	2687	3	t_o_ph
torah	8	71	2527	3	t_orah
torch	10	74	2093	3	t_orch
torot	5	61	3994	3	torot_
tort	4	69	6746	3	t_ort_
torta	5	59	2535	3	t_orta
torte	5	54	3170	3	t_orte
torts	5	61	3812	3	t_orts
tosh	7	48	2681	3	t_o_sh
tost	4	83	5192	3	t_ost_
tot	3	88	8477	3	t_o_t_
tote	4	66	4367	3	t_o_te
tots	4	66	5412	3	t_o_ts
touch	10	65	1939	3	t_ouch
tough	9	73	2199	3	t_ough
tout	4	67	5382	3	t_out_
touts	5	48	3039	3	t_outs
tow	6	105	5736	3	t_ow__
towed	9	51	3458	3	t_owed
towel	8	49	2052	3	t_owel
tower	8	57	2920	3	t_ower
towie	8	58	2187	3	t_owie
town	7	69	2870	3	t_ow_n
towns	8	60	1888	3	t_owns
towny	11	61	1449	3	t_owny
towpath	15	4	404	3	t_owpath
tows	7	85	4555	3	t_ow_s
towy	10	53	2547	3	t_ow_y
tract	7	56	3571	3	tract_
tracts	8	50	1907	3	tracts
trait	5	69	4084	3	trait_
traits	6	51	2198	3	traits
trapt	7	64	3339	3	trapt_
trash	8	61	1976	3	tr_ash
trawl	8	49	1587	3	traw_l
trawls	9	44	1239	3	trawls
treat	5	62	4035	3	treat_
treats	6	48	2169	3	treats
treaty	9	44	1435	3	treaty
trefah	12	3	509	3	trefah
trench	11	42	1161	3	trench
tret	4	66	5353	3	tr_et_
trets	5	59	2802	3	tr_ets
trews	8	61	1889	3	trew_s
trilith	10	3	1051	3	trilith
triste	6	38	1864	3	triste
trite	5	47	3003	3	tr_ite
troak	9	52	1357	3	tro_ak
troaks	10	44	1060	3	troaks
trocar	8	4	877	3	trocar
troche	11	31	1251	3	troche
trock	11	48	1760	3	tro_ck
trocks	12	36	1463	3	trocks
trod	5	76	2795	3	tro__d
trode	6	53	2285	3	tro_de
trog	5	76	2821	3	tro__g
trogon	7	36	1175	3	trogon
trogs	6	70	2260	3	tro_gs
troika	10	3	549	3	troika
trois	5	72	2609	3	tro_is
troke	9	48	2105	3	tro_ke
troked	11	41	1458	3	troked
trokes	10	40	1926	3	trokes
troll	5	44	1653	3	tro_ll
trolls	6	46	1394	3	trolls
trolly	9	40	1236	3	trolly
tromp	9	58	1580	3	tro_mp
trompe	10	56	1126	3	trompe
tromps	10	49	1170	3	tromps
trona	5	41	1895	3	tro_na
tronas	6	38	1690	3	tronas
trone	5	51	3186	3	tro_ne
trones	6	56	2928	3	trones
troop	7	64	1753	3	tro_op
troops	8	57	1278	3	troops
trooz	14	50	1615	3	tro_oz
trop	6	68	3330	3	tro__p
trope	7	57	2580	3	tro_pe
tropes	8	48	2435	3	tropes
trophy	14	3	828	3	trophy
tropic	10	30	1419	3	tropic
tropin	8	33	1675	3	tropin
trothed	11	40	1097	3	tro_thed
trotted	8	37	1128	3	trotted
trotter	7	33	1225	3	trotter
trotyl	9	23	667	3	trotyl
troughs	11	69	869	3	troughs
troupe	8	48	1243	3	troupe
trove	8	52	2192	3	tro_ve
trover	9	50	1466	3	trover
troves	9	47	1911	3	troves
trowels	10	35	836	3	trowels
trowing	11	34	1370	3	trowing
troy	7	74	2968	3	tro__y
troys	8	64	1861	3	tro_ys
trust	5	54	2685	3	trust_
trusts	6	47	1443	3	trusts
trusty	9	47	1011	3	trusty
truths	9	44	950	3	tr_uths
tryout	9	4	1076	3	tryout_
tryouts	10	3	531	3	tryouts
tryst	8	47	1622	3	tryst_
tryste	9	39	958	3	tryste
trysts	9	44	879	3	trysts
turbeth	12	7	471	3	turbeth
turbith	12	6	711	3	turbith
turpeth	12	8	481	3	turpeth
upgrowth	17	4	195	3	upgrowth
urolith	10	4	878	3	urolith
vrow	10	58	1747	3	vrow__
vrows	11	61	1526	3	vrow_s
worth	11	71	2052	3	_worth
wraith	12	5	860	3	wraith
wrath	11	57	1587	3	wr_ath
wreath	12	41	1119	3	wreath
wrote	8	47	1748	3	wro_te
youth	11	53	1504	3	_youth
zeroth	18	3	796	3	zero_th

Search took 6 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	112716	0.406	440125.6
2	DLD Change Limit	112716	315	5.013	22484.7
3	Display Results	315	315	0.096	3281.3
	(SQL Overall)	178691	315	5.515	32400.9