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

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

346 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
gharry	13	54	627	(None)
charry	14	50	1211	1	charry
gharri	10	38	616	1	gharri
harry	11	53	2295	1	_harry
carry	10	58	2378	2	_carry
charr	10	48	2178	2	charr_
charro	11	42	1295	2	charro
charrs	11	52	1918	2	charrs
chary	13	50	2313	2	cha_ry
cherry	14	48	1076	2	cherry
gharris	11	30	643	2	gharris
glairy	10	44	827	2	glairy
glary	9	60	1854	2	gla_ry
gnarly	10	46	1038	2	gnarly
gnarr	6	48	1069	2	gnarr_
gnarrs	7	40	766	2	gnarrs
gurry	9	45	1541	2	g_urry
hairy	11	53	1683	2	_hairy
hardy	12	56	2206	2	_hardy
harpy	13	64	1820	2	_harpy
herry	11	49	2247	2	_herry
hurry	11	49	1718	2	_hurry
knarry	13	3	461	2	knarry
marry	10	48	2169	2	_marry
parry	10	53	2375	2	_parry
quarry	18	3	746	2	quarry
scarry	11	63	1118	2	scarry
sharny	12	47	1183	2	sharny
sharpy	14	52	1103	2	sharpy
sherry	12	45	1041	2	sherry
sparry	11	51	1130	2	sparry
starry	9	49	1167	2	starry
tarry	8	54	2251	2	_tarry
wherry	15	47	733	2	wherry
whirry	15	47	706	2	whirry
aery	7	72	3168	3	__aery
airy	7	57	3415	3	__airy
alary	8	61	2344	3	ala_ry
army	9	66	2418	3	__army
array	8	63	1714	3	__array
arty	7	75	3131	3	__arty
awry	10	76	1968	3	__awry
barky	14	57	2161	3	_barky
barmy	12	52	1876	3	_barmy
barny	10	58	2173	3	_barny
barre	7	59	2954	3	_barre
berry	10	45	2176	3	_berry
bharal	11	3	889	3	bharal
blurry	11	43	767	3	blurry
burry	10	52	2156	3	_burry
carny	10	58	2292	3	_carny
carr	6	54	3470	3	_carr_
carrs	7	57	3085	3	_carrs
chadri	12	3	813	3	chadri
chaffy	20	45	647	3	chaffy
chair	10	55	1963	3	chair_
chairs	11	49	1617	3	chairs
chakra	15	43	753	3	chakra
chalky	18	46	877	3	chalky
chally	14	43	1429	3	chally
chammy	18	48	895	3	chammy
champy	18	50	961	3	champy
chancy	16	40	1086	3	chancy
chantry	15	38	821	3	chantry
chanty	14	52	1582	3	chanty
char	9	51	3215	3	cha_r_
charas	11	42	2359	3	charas
chard	11	61	2474	3	cha_rd
chards	12	51	1972	3	chards
chare	10	52	3198	3	cha_re
chared	12	54	2369	3	chared
chares	11	56	3180	3	chares
charge	12	51	1421	3	charge
charily	15	3	1028	3	charily
charity	15	3	1102	3	charity
chark	14	42	2271	3	cha_rk
charka	15	40	1170	3	charka
charks	15	52	1970	3	charks
charley	15	11	827	3	charley
charm	12	61	2466	3	cha_rm
charms	13	52	1883	3	charms
charpoy	17	3	571	3	charpoy
charred	13	46	1448	3	charred
charros	12	43	1214	3	charros
chars	10	59	3663	3	cha_rs
chart	10	50	3828	3	cha_rt
charts	11	58	2309	3	charts
chasmy	16	46	854	3	chasmy
chatty	14	41	936	3	chatty
chay	12	49	2487	3	cha__y
cheery	14	49	1315	3	cheery
cherty	14	46	1247	3	cherty
chirpy	16	49	891	3	chirpy
chirr	10	50	1590	3	chirr_
chirre	11	41	1185	3	chirre
chirrs	11	45	1498	3	chirrs
churr	10	45	1285	3	churr_
churro	11	44	835	3	churro
churrs	11	51	1151	3	churrs
clary	10	57	1961	3	cla_ry
curry	10	59	2034	3	_curry
dairy	9	70	1630	3	_dairy
darky	13	60	1883	3	_darky
dearly	10	46	1532	3	dearly
deary	9	58	2684	3	dea_ry
derry	9	47	2137	3	_derry
dharma	12	7	610	3	dharma
dharna	10	5	526	3	dharna
diary	9	50	1697	3	dia_ry
early	8	53	2412	3	_early
faery	11	60	1548	3	_faery
fairy	11	53	1828	3	_fairy
farcy	13	52	1709	3	_farcy
ferry	11	60	2080	3	_ferry
firry	11	57	1353	3	_firry
flurry	12	39	711	3	flurry
furry	11	67	1928	3	_furry
gabby	13	55	1294	3	g_abby
gaby	10	71	2319	3	g_a_by
gaily	9	50	2097	3	g_aily
gally	9	50	2617	3	g_ally
gamay	11	64	1910	3	g_amay
gamey	11	53	2055	3	g_amey
gammy	13	55	1489	3	g_ammy
gamy	10	54	2753	3	g_a_my
gantry	10	38	1011	3	gantry
gappy	13	62	1203	3	g_appy
gapy	10	63	2091	3	g_a_py
gar	4	72	5990	3	g_a_r_
garb	7	53	3267	3	g_a_rb
garbs	8	63	2141	3	g_arbs
garda	7	3	1676	3	g_arda
garni	6	3	1570	3	g_arni
garred	8	52	1740	3	g_arred
garret	7	44	2655	3	g_arret
garron	7	31	1349	3	g_arron
gars	5	57	5074	3	g_a_rs
garth	9	47	2022	3	g_arth
garvey	13	12	787	3	g_arvey
gassy	9	55	1402	3	g_assy
gaudy	10	66	1146	3	g_audy
gaur	5	67	2335	3	g_aur_
gaurs	6	63	1799	3	g_aurs
gauzy	18	48	921	3	g_auzy
gawky	16	56	999	3	g_awky
gawsy	12	45	909	3	g_awsy
gay	7	68	5649	3	g_a__y
gayly	12	45	1309	3	g_ayly
gear	5	59	3497	3	gea_r_
geared	8	53	1774	3	geared
gears	6	46	2869	3	gea_rs
gentry	10	34	1044	3	gentry
germy	11	51	1366	3	g_ermy
gharial	11	3	734	3	gharial
gharries	12	31	820	3	gharries
ghast	9	56	2122	3	gha_st
ghastly	14	35	456	3	ghastly
ghat	8	64	3528	3	gha__t
ghats	9	58	1861	3	gha_ts
ghaut	9	59	1943	3	gha_ut
ghauts	10	44	778	3	ghauts
ghazi	18	3	743	3	gha_zi
ghazis	19	3	519	3	ghazis
gherao	10	3	675	3	gherao
ghosty	13	46	721	3	ghosty
girly	9	44	1529	3	g_irly
gladly	11	49	793	3	gladly
glady	10	54	1394	3	gla_dy
glair	6	53	1355	3	glair_
glaire	7	44	1129	3	glaire
glairs	7	52	1133	3	glairs
glare	6	52	2295	3	gla_re
glared	8	47	1519	3	glared
glares	7	55	1886	3	glares
glassy	10	52	775	3	glassy
glazy	18	74	1098	3	gla_zy
glory	9	64	1329	3	g_lory
gnar	5	60	2138	3	gna_r_
gnarl	6	51	1557	3	gna_rl
gnarls	7	42	1077	3	gnarls
gnarred	9	32	700	3	gnarred
gnars	6	67	1885	3	gna_rs
gnatty	10	33	648	3	gnatty
gorsy	9	59	1578	3	g_orsy
gory	8	61	2966	3	g__ory
grabby	14	33	618	3	grabby
grainy	10	39	1421	3	grainy
gramary	13	5	590	3	gramary
granary	11	5	779	3	granary
granny	10	43	1116	3	granny
grapery	13	45	795	3	grapery
grapey	12	60	1230	3	grapey
grapy	11	54	1643	3	gra_py
grassy	10	61	909	3	grassy
gravy	12	55	1211	3	gra_vy
gray	8	53	2989	3	g__ray
grayly	13	28	796	3	grayly
grey	8	56	2404	3	g__rey
guanay	10	3	791	3	guanay
guar	5	69	2329	3	gua_r_
guard	7	44	1554	3	gua_rd
guards	8	46	1156	3	guards
guars	6	50	2104	3	gua_rs
haar	7	73	2349	3	_haar_
haars	8	56	2047	3	_haars
hair	7	63	3014	3	_hair_
hairs	8	62	2517	3	_hairs
hammy	15	51	1343	3	_hammy
handy	12	55	2087	3	_handy
hanky	15	54	1829	3	_hanky
haply	13	59	1506	3	_haply
happy	15	58	1353	3	_happy
hard	8	54	4350	3	_ha_rd
hardly	13	51	1283	3	_hardly
hards	9	64	3565	3	_hards
hare	7	62	5573	3	_ha_re
hared	9	57	4218	3	_hared
harem	10	49	2445	3	_harem
hares	8	62	5554	3	_hares
hark	11	52	3739	3	_ha_rk
harks	12	63	3343	3	_harks
harl	7	57	4000	3	_ha_rl
harls	8	56	3450	3	_harls
harm	9	56	3779	3	_ha_rm
harms	10	68	2901	3	_harms
harp	9	61	3428	3	_ha_rp
harps	10	59	2686	3	_harps
harrow	12	26	1077	3	_harrow
harsh	11	64	1805	3	_harsh
hart	7	68	6577	3	_ha_rt
harts	8	84	4159	3	_harts
hasty	11	57	1876	3	_hasty
hay	9	73	5877	3	_ha__y
hayey	14	48	1253	3	_hayey
hazy	19	181	1919	3	_ha_zy
hearty	12	63	1363	3	hearty
henry	11	40	1447	3	_henry
herby	13	47	1531	3	_herby
hoary	11	45	1676	3	_hoary
horary	12	3	1038	3	_horary
horny	11	56	1962	3	_horny
horsy	11	63	1839	3	_horsy
hurly	11	58	1929	3	_hurly
hurray	12	45	991	3	_hurray
jerry	15	50	1618	3	_jerry
kaury	12	42	976	3	_kaury
kerry	12	49	1609	3	_kerry
lardy	9	61	1927	3	_lardy
larky	12	52	1887	3	_larky
leary	8	59	2738	3	lea_ry
lorry	8	63	1566	3	_lorry
marly	10	69	2561	3	_marly
marvy	13	50	1403	3	_marvy
merry	10	47	2148	3	_merry
murry	10	51	2023	3	_murry
narky	12	60	1780	3	_narky
nary	7	69	3122	3	_na_ry
nearby	11	35	605	3	nearby
nearly	9	48	1373	3	nearly
ovary	11	4	911	3	ova_ry
pardy	11	55	2395	3	_pardy
parr	6	57	3115	3	_parr_
parrs	7	59	2867	3	_parrs
party	10	66	3061	3	_party
pearly	11	64	1484	3	pearly
perry	10	52	2271	3	_perry
pharos	11	3	1206	3	pharos
phratry	15	4	374	3	phratry
recarry	12	4	506	3	recarry
remarry	12	3	519	3	remarry
sarky	12	55	2178	3	_sarky
saury	8	43	1722	3	_saury
scarey	11	50	1698	3	scarey
scary	10	52	2259	3	sca_ry
scurry	11	41	958	3	scurry
serry	8	48	2412	3	_serry
shabby	16	3	580	3	shabby
shady	12	54	1651	3	sha_dy
shaggy	14	47	804	3	shaggy
shaird	10	28	870	3	shaird
shairn	9	26	906	3	shairn
shaky	15	46	1684	3	sha_ky
shaley	12	37	1499	3	shaley
shaly	11	43	2286	3	sha_ly
shammy	16	38	850	3	shammy
shamoy	14	37	991	3	shamoy
shandy	13	47	1003	3	shandy
shanny	12	41	1009	3	shanny
shanty	12	47	1511	3	shanty
shard	9	61	2596	3	sha_rd
shards	10	43	1917	3	shards
share	8	64	3708	3	sha_re
shared	10	58	2906	3	shared
sharer	9	50	2548	3	sharer
sharers	10	47	2062	3	sharers
shares	9	52	3641	3	shares
sharia	9	31	1672	3	sharia
sharif	12	29	1711	3	sharif
shark	12	62	2502	3	sha_rk
sharks	13	50	1972	3	sharks
sharn	8	48	2370	3	sha_rn
sharns	9	55	1698	3	sharns
sharp	10	49	2253	3	sha_rp
sharply	15	40	683	3	sharply
sharps	11	55	1608	3	sharps
shay	10	71	3334	3	sha__y
shirr	8	47	1692	3	shirr_
shirrs	9	44	1317	3	shirrs
shirty	12	43	1255	3	shirty
shorty	12	43	1319	3	shorty
skerry	13	35	610	3	skerry
slurry	9	37	859	3	slurry
smarmy	13	62	935	3	smarmy
smarty	11	50	1379	3	smarty
snarky	13	42	1084	3	snarky
snarly	9	38	1500	3	snarly
sorry	8	46	1825	3	_sorry
sparky	15	45	1152	3	sparky
spurry	11	42	911	3	spurry
swarty	12	58	1238	3	swarty
tardy	9	47	2046	3	_tardy
tarre	5	58	2563	3	_tarre
tarty	8	63	2818	3	_tarty
teary	8	51	2405	3	tea_ry
terry	8	47	2187	3	_terry
thairm	11	5	696	3	thairm
tharm	10	59	1664	3	tha_rm
tharms	11	57	1224	3	tharms
theory	12	109	835	3	theory
thirty	12	37	840	3	thirty
thorny	12	50	984	3	thorny
unary	8	3	1599	3	una_ry
vary	10	52	2606	3	_va_ry
warty	11	93	2382	3	_warty
wary	10	67	4001	3	_wa_ry
weary	11	56	2061	3	wea_ry
whacky	21	55	649	3	whacky
whammy	19	37	529	3	whammy
wharf	14	3	1582	3	wha_rf
wharfs	15	4	637	3	wharfs
wharve	15	45	620	3	wharve
whirly	15	44	886	3	whirly
whirr	11	46	1119	3	whirr_
whirrs	12	40	859	3	whirrs
worry	11	61	1433	3	_worry
yearly	12	52	1027	3	yearly

Search took 7 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.140	1276364.3
2	DLD Change Limit	112716	346	5.940	18975.8
3	Display Results	346	346	0.110	3145.5
	(SQL Overall)	178691	346	6.190	28867.7