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

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

418 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
grotty	10	38	983	(None)
gritty	10	33	840	1	gritty
grotto	7	34	981	1	grotto
grouty	10	47	1098	1	grouty
blotty	11	17	834	2	blotty
bratty	11	5	968	2	bratty
brothy	14	51	962	2	brothy
clotty	11	20	826	2	clotty
dotty	9	45	1610	2	_dotty
fretty	12	4	922	2	fretty
frosty	12	47	1063	2	frosty
frothy	15	57	837	2	frothy
garotte	8	6	870	2	garotte
ghosty	13	46	721	2	ghosty
gnatty	10	33	648	2	gnatty
gouty	9	52	1736	2	g_outy
groat	6	55	3197	2	groat_
groats	7	48	1665	2	groats
grody	10	34	1206	2	gro_dy
groggy	12	3	480	2	groggy
groovy	13	37	540	2	groovy
groszy	19	39	570	2	groszy
grot	5	59	4205	2	gro_t_
grots	6	50	2585	2	gro_ts
grottos	8	33	733	2	grottos
grout	6	53	3042	2	grout_
grouts	7	50	1561	2	grouts
growly	13	49	917	2	growly
growth	13	7	738	2	growth
growthy	17	7	328	2	growthy
gutty	9	45	1699	2	g_utty
jotty	15	50	1260	2	_jotty
knotty	13	31	522	2	knotty
plotty	11	20	885	2	plotty
potty	10	56	2100	2	_potty
pretty	11	5	1087	2	pretty
ratty	8	48	1959	2	_ratty
rooty	8	64	2302	2	_rooty
rotte	5	46	2593	2	_rotte
rutty	8	56	1780	2	_rutty
snotty	9	48	920	2	snotty
spotty	11	44	858	2	spotty
trouty	9	52	1179	2	trouty
agouty	10	36	691	3	agouty
arnotto	7	13	473	3	arnotto
artsy	8	60	1296	3	ar_tsy
arty	7	75	3131	3	ar__ty
batty	10	54	2224	3	_batty
bitty	10	61	1917	3	_bitty
blotto	8	19	844	3	blotto
booty	10	61	2591	3	_booty
borty	10	55	2283	3	_borty
bothy	13	67	1396	3	_bothy
bott	6	65	4857	3	_bott_
botts	7	52	2486	3	_botts
britt	7	57	3223	3	britt_
brittly	12	16	597	3	brittly
britts	8	48	1344	3	britts
brolly	11	45	1085	3	brolly
bronzy	20	30	671	3	bronzy
broody	12	45	1008	3	broody
broomy	13	44	995	3	broomy
brosy	10	61	1538	3	bro_sy
broth	10	65	2109	3	bro_th
broths	11	50	1392	3	broths
browny	14	45	1004	3	browny
butty	10	40	2011	3	_butty
catty	10	45	2041	3	_catty
chatty	14	41	936	3	chatty
chitty	14	32	943	3	chitty
chott	10	39	2393	3	chott_
chotts	11	36	1099	3	chotts
cotta	7	58	1857	3	_cotta
crafty	14	47	891	3	crafty
croaky	15	52	848	3	croaky
croft	10	56	2268	3	croft_
crofts	11	49	1059	3	crofts
crony	10	59	1867	3	cro_ny
crotch	13	34	1008	3	crotch
croton	8	44	1545	3	croton
croupy	13	45	873	3	croupy
croute	8	46	1727	3	croute
crowdy	15	46	717	3	crowdy
crusty	11	49	1134	3	crusty
cutty	10	54	1722	3	_cutty
ditty	9	50	1929	3	_ditty
dorty	9	62	2081	3	_dorty
doty	8	61	2822	3	_do_ty
drafty	13	63	893	3	drafty
drifty	13	41	822	3	drifty
droit	6	51	2712	3	droit_
droits	7	43	1431	3	droits
drolly	10	54	1167	3	drolly
drooly	10	49	1107	3	drooly
droopy	12	45	824	3	droopy
dropsy	12	49	747	3	dropsy
dropt	8	69	2443	3	dropt_
drosky	14	48	616	3	drosky
drossy	10	52	847	3	drossy
drouth	10	44	1010	3	drouth
drouthy	14	39	517	3	drouthy
drowsy	13	48	790	3	drowsy
erotic	8	26	2027	3	erotic
fatty	11	51	1741	3	_fatty
floaty	12	42	1094	3	floaty
footsy	12	58	793	3	footsy
footy	11	58	2053	3	_footy
forty	11	48	2427	3	_forty
fritt	8	61	2941	3	fritt_
fritts	9	46	1319	3	fritts
froggy	14	3	449	3	froggy
front	8	50	2922	3	front_
fronts	9	44	1579	3	fronts
frost	8	47	2783	3	frost_
frosts	9	42	1462	3	frosts
froth	11	59	1928	3	fro_th
froths	12	54	1144	3	froths
frouzy	21	39	528	3	frouzy
frowsty	16	46	498	3	frowsty
frowsy	15	49	827	3	frowsy
frowzy	24	48	579	3	frowzy
fruity	12	42	969	3	fruity
gaiety	10	11	937	3	gaiety
gantry	10	38	1011	3	gantry
gargety	12	38	804	3	gargety
garote	7	7	1795	3	garo_te
garoted	9	7	1013	3	garoted
garotes	8	6	1456	3	garotes
garotted	10	6	619	3	garotted
garotter	9	6	594	3	garotter
garottes	9	7	828	3	garottes
garrotte	9	6	568	3	garrotte
gavotte	11	7	460	3	gavotte
gayety	13	11	638	3	gayety
gently	10	37	1091	3	gently
gentry	10	34	1044	3	gentry
ghetto	10	3	607	3	ghetto
ghost	9	63	1876	3	ghost_
ghostly	14	35	510	3	ghostly
ghosts	10	48	927	3	ghosts
gleety	10	47	919	3	gleety
glinty	10	69	1069	3	glinty
glitzy	19	40	478	3	glitzy
gloat	6	54	2768	3	gloat_
gloats	7	45	1542	3	gloats
globby	14	3	468	3	globby
gloomy	12	52	876	3	gloomy
gloppy	14	5	472	3	gloppy
glory	9	64	1329	3	glo_ry
glossy	10	54	900	3	glossy
glost	6	54	2293	3	glost_
glosts	7	45	1381	3	glosts
glottal	8	3	510	3	glottal
glottic	10	3	665	3	glottic
glottis	8	3	717	3	glottis
glout	6	59	2581	3	glout_
glouts	7	44	1471	3	glouts
goat	5	62	5083	3	g_oat_
goats	6	55	2730	3	g_oats
goby	10	60	2108	3	g_o_by
godly	10	49	1329	3	g_odly
golly	9	51	2110	3	g_olly
goodby	13	40	628	3	goodby
goodly	11	41	930	3	goodly
goody	10	56	2039	3	g_oody
gooey	9	55	2286	3	g_ooey
goofy	12	49	1562	3	g_oofy
googly	11	41	788	3	googly
gooky	13	58	1803	3	g_ooky
gooney	10	66	1231	3	gooney
goony	9	55	1978	3	g_oony
goopy	11	58	1662	3	g_oopy
goosey	10	59	1351	3	goosey
goosy	9	60	1888	3	g_oosy
gorily	10	6	1250	3	gorily
gorsy	9	59	1578	3	g_orsy
gory	8	61	2966	3	g_o_ry
got	4	98	7044	3	g_o_t_
goth	8	68	2508	3	g_o_th
goths	9	65	1300	3	g_oths
gotten	7	34	1011	3	g_otten
gout	5	66	4600	3	g_out_
gouts	6	48	2617	3	g_outs
goy	7	78	4455	3	g_o__y
grabby	14	33	618	3	grabby
graft	9	53	2720	3	graft_
grafts	10	50	1325	3	grafts
grainy	10	39	1421	3	grainy
granny	10	43	1116	3	granny
grant	6	48	4002	3	grant_
grants	7	37	2247	3	grants
grapey	12	60	1230	3	grapey
grapy	11	54	1643	3	gr_apy
grassy	10	61	909	3	grassy
grat	5	56	5128	3	gr_at_
grate	6	49	3288	3	gr_ate
grated	8	45	2392	3	grated
grater	7	46	2544	3	grater
grates	7	54	2989	3	grates
gratify	14	3	611	3	gratify
gratin	7	45	2058	3	gratin
gratis	7	48	1924	3	gratis
gratuity	12	4	428	3	gratuity
gravity	14	3	718	3	gravity
gravy	12	55	1211	3	gr_avy
gray	8	53	2989	3	gr__ay
grayly	13	28	796	3	grayly
greasy	10	41	946	3	greasy
great	6	60	3424	3	great_
greatly	11	3	761	3	greatly
greats	7	63	1839	3	greats
greedy	11	51	885	3	greedy
greeny	10	48	1145	3	greeny
greet	6	58	3532	3	greet_
greets	7	51	1742	3	greets
gremmy	14	5	447	3	gremmy
grey	8	56	2404	3	gr__ey
greyly	13	31	654	3	greyly
grift	9	59	2446	3	grift_
grifts	10	45	1168	3	grifts
grimly	12	45	993	3	grimly
grimy	11	43	1260	3	gr_imy
griot	6	53	2841	3	griot_
griots	7	47	1364	3	griots
gripey	12	41	1120	3	gripey
grippy	14	44	776	3	grippy
gript	8	51	2617	3	gript_
gripy	11	51	1525	3	gr_ipy
grisly	10	43	1058	3	grisly
grist	6	55	2987	3	grist_
gristly	11	18	733	3	gristly
grists	7	47	1648	3	grists
grit	5	52	4724	3	gr_it_
grith	9	55	2037	3	gr_ith
griths	10	52	1165	3	griths
grits	6	55	2958	3	gr_its
gritted	9	41	1090	3	gritted
gritter	8	39	1335	3	gritter
grittily	12	4	418	3	grittily
groan	6	56	1842	3	gro_an
groans	7	48	1506	3	groans
grocer	9	42	1214	3	grocer
grocery	13	33	676	3	grocery
grog	6	59	2334	3	gro__g
grogs	7	63	1941	3	gro_gs
groin	6	55	2108	3	gro_in
groins	7	39	1720	3	groins
grok	9	58	1968	3	gro__k
groks	10	57	1612	3	gro_ks
groom	8	53	1798	3	gro_om
grooms	9	45	1252	3	grooms
groove	10	43	887	3	groove
grope	8	48	2161	3	gro_pe
groped	10	75	1505	3	groped
groper	9	45	1725	3	groper
gropes	9	52	2040	3	gropes
gross	6	54	2169	3	gro_ss
grossly	11	7	598	3	grossly
grosz	15	48	1409	3	gro_sz
grosze	16	45	773	3	grosze
grottier	9	31	667	3	grottier
grottoed	10	23	450	3	grottoed
grottoes	9	27	675	3	grottoes
grouch	12	31	847	3	grouch
grouchy	16	29	424	3	grouchy
ground	8	23	1027	3	ground
group	8	54	1392	3	gro_up
groups	9	42	1051	3	groups
grouse	7	43	1502	3	grouse
grouted	9	41	1150	3	grouted
grouter	8	44	1252	3	grouter
grove	9	52	1933	3	gro_ve
groved	11	44	1370	3	groved
grovel	10	43	1054	3	grovel
groves	10	43	1810	3	groves
grow	8	61	2730	3	gro__w
grower	10	46	1493	3	grower
growl	9	61	1582	3	gro_wl
growls	10	47	1111	3	growls
grown	9	53	1735	3	gro_wn
grows	9	55	2392	3	gro_ws
growths	14	9	442	3	growths
groyne	10	3	721	3	groyne
grubby	14	32	450	3	grubby
gruffy	16	39	601	3	gruffy
grumpy	14	49	815	3	grumpy
grungy	11	34	597	3	grungy
grunt	6	55	2354	3	grunt_
grunts	7	55	1185	3	grunts
grutch	12	28	556	3	grutch
grutten	8	8	528	3	grutten
guilty	10	41	823	3	guilty
gusty	9	51	1957	3	g_usty
gutsy	9	64	1284	3	g_utsy
gutta	6	46	1338	3	g_utta
hooty	11	50	2244	3	_hooty
hotly	11	58	1548	3	_hotly
irony	8	50	1590	3	iro_ny
jetty	15	62	1258	3	_jetty
jolty	15	57	1303	3	_jolty
jutty	15	49	1464	3	_jutty
kitty	12	46	1456	3	_kitty
lofty	11	58	1330	3	_lofty
lotte	5	49	2385	3	_lotte
lotto	5	52	1757	3	_lotto
motey	10	59	2295	3	_motey
mothy	13	62	1455	3	_mothy
mott	6	66	4844	3	_mott_
motte	7	55	2697	3	_motte
motto	7	61	1951	3	_motto
motts	7	65	2700	3	_motts
natty	8	57	1914	3	_natty
netty	8	58	1676	3	_netty
nitty	8	54	1831	3	_nitty
nutty	8	48	1687	3	_nutty
otto	4	52	2064	3	__otto
patty	10	47	2361	3	_patty
petty	10	53	2029	3	_petty
portly	11	47	1340	3	portly
potsy	10	58	1561	3	_potsy
potto	7	53	2094	3	_potto
pouty	10	70	1881	3	_pouty
probity	14	29	968	3	probity
proette	9	3	1236	3	proette
pronto	8	3	1399	3	pronto
prost	7	54	3410	3	prost_
prosy	10	63	1925	3	pro_sy
protea	8	22	1476	3	protea
protei	8	26	1531	3	protei
proton	8	43	1889	3	proton
protyl	11	30	821	3	protyl
proxy	17	50	1101	3	pro_xy
putty	10	47	2140	3	_putty
rattly	9	41	1154	3	_rattly
retry	8	47	1808	3	_retry
ritzy	17	56	1116	3	_ritzy
rocky	14	45	1385	3	_rocky
roily	8	61	2111	3	_roily
rooky	12	61	1762	3	_rooky
roomy	10	71	1806	3	_roomy
root	4	56	5592	3	_root_
roots	5	59	3367	3	_roots
ropey	10	60	2187	3	_ropey
ropy	9	63	2341	3	_ro_py
rosy	7	60	2487	3	_ro_sy
rot	3	72	8295	3	_ro_t_
rota	4	58	3434	3	_ro_ta
rotary	9	24	1130	3	_rotary
rotas	5	48	2772	3	_rotas
rotate	6	33	2034	3	_rotate
rotch	10	58	1593	3	_rotch
rote	4	62	4902	3	_ro_te
rotes	5	61	4390	3	_rotes
roti	4	63	3293	3	_ro_ti
rotis	5	63	2706	3	_rotis
rotl	4	50	2968	3	_ro_tl
rotls	5	56	2016	3	_rotls
roto	4	59	3505	3	_ro_to
rotor	5	55	1973	3	_rotor
rotos	5	60	2788	3	_rotos
rots	4	64	5409	3	_ro_ts
rotted	7	45	2443	3	_rotted
rotten	6	41	1543	3	_rotten
rotter	6	43	2546	3	_rotter
rottes	6	45	2483	3	_rottes
roupy	10	61	1271	3	_roupy
rout	4	61	5328	3	_rout_
route	5	51	3207	3	_route
routh	8	64	2307	3	_routh
routs	5	71	3341	3	_routs
rowdy	12	57	1153	3	_rowdy
rowth	11	57	1323	3	_rowth
runty	8	61	1904	3	_runty
rusty	8	52	2105	3	_rusty
scatty	11	53	1065	3	scatty
shitty	12	41	1006	3	shitty
shorty	12	43	1320	3	shorty
shott	8	53	3219	3	shott_
shotts	9	36	1470	3	shotts
slitty	9	32	916	3	slitty
slutty	9	24	800	3	slutty
smutty	11	26	632	3	smutty
snooty	9	42	1151	3	snooty
snouty	9	41	995	3	snouty
softy	11	54	1448	3	_softy
sooty	8	49	2484	3	_sooty
sporty	11	51	1249	3	sporty
stott	5	69	2979	3	stott_
stotts	6	46	1286	3	stotts
tatty	8	47	2018	3	_tatty
throaty	13	42	848	3	throaty
titty	8	53	1665	3	_titty
toothy	12	52	969	3	toothy
tootsy	9	43	798	3	tootsy
treaty	9	44	1435	3	treaty
trolly	9	40	1236	3	trolly
trophy	14	3	828	3	trophy
trot	4	63	5131	3	tro_t_
troth	8	56	2220	3	tro_th
troths	9	54	1415	3	troths
trots	5	66	2994	3	tro_ts
trotted	8	37	1128	3	trotted
trotter	7	33	1225	3	trotter
trotyl	9	23	667	3	trotyl
trout	5	73	3257	3	trout_
trouts	6	61	1663	3	trouts
trowth	12	7	788	3	trowth
troy	7	74	2968	3	tro__y
trusty	9	47	1011	3	trusty
tutty	8	52	1702	3	_tutty
witty	11	47	1701	3	_witty
worthy	15	59	880	3	worthy
wrathy	15	37	785	3	wrathy
wristy	12	50	970	3	wristy
wrote	8	47	1748	3	wro_te
wroth	11	68	1588	3	wro_th
zloty	17	39	979	3	zlo_ty
zooty	17	54	1535	3	_zooty

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.376	475242.0
2	DLD Change Limit	112716	418	5.093	22131.6
3	Display Results	418	418	0.126	3317.5
	(SQL Overall)	178691	418	5.595	31937.6