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

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

333 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
ghylls	13	3	514	(None)
ghyll	12	4	632	1	ghyll_
chills	11	47	1770	2	chills
chyles	14	48	1328	2	chyles
galls	6	47	2932	2	g_alls
gayals	10	3	951	2	gayals
ghouls	10	3	604	2	ghouls
gills	6	47	2819	2	g_ills
grills	7	43	1480	2	grills
gulls	6	52	2298	2	g_ulls
halls	8	56	3378	2	_halls
hells	8	50	3204	2	_hells
hills	8	54	3135	2	_hills
hulls	8	49	2356	2	_hulls
hylas	11	48	1590	2	_hylas
idylls	10	42	525	2	idylls
phyllo	14	3	587	2	phyllo
phyllos	15	3	558	2	phyllos
shells	9	43	1952	2	shells
shills	9	45	1961	2	shills
thills	9	55	1538	2	thills
acyls	10	42	1152	3	acy_ls
aholds	10	46	948	3	aholds
ahull	8	40	1031	3	ahull_
alls	4	67	4092	3	__alls
allyls	9	43	727	3	allyls
amyls	10	45	1269	3	amy_ls
aphylly	18	4	335	3	aphylly
argylls	11	4	346	3	argylls
aryls	8	70	1581	3	ary_ls
atolls	6	55	1135	3	atolls
balls	7	62	3641	3	_balls
bells	7	64	3216	3	_bells
bills	7	56	3286	3	_bills
bolls	7	55	3131	3	_bolls
boylas	11	30	1172	3	boylas
brills	8	49	1629	3	brills
bulls	7	56	2957	3	_bulls
byrls	10	57	1123	3	_byrls
calls	7	56	3473	3	_calls
cells	7	54	2806	3	_cells
chalks	15	54	1214	3	chalks
challa	11	40	1419	3	challa
challas	12	44	1412	3	challas
challis	12	46	1346	3	challis
chally	14	43	1429	3	chally
chelas	11	38	1720	3	chelas
chiels	11	51	1593	3	chiels
chiles	11	54	2530	3	chiles
chilis	11	55	1787	3	chilis
chill	10	56	1987	3	chill_
chilli	11	43	1277	3	chilli
chillis	12	44	1160	3	chillis
chilly	14	41	1322	3	chilly
cholas	11	48	1800	3	cholas
cholla	11	39	1102	3	cholla
chollas	12	38	1135	3	chollas
cholos	11	47	1685	3	cholos
churls	11	54	1107	3	churls
chyle	13	49	1348	3	chy_le
chylous	15	10	727	3	chylous
chymes	16	59	1215	3	chymes
culls	7	54	2581	3	_culls
dells	6	66	3094	3	_dells
dhals	9	54	1544	3	dh_als
dholes	10	49	1479	3	dholes
dills	6	55	3097	3	_dills
dolls	6	61	2692	3	_dolls
drills	7	44	1420	3	drills
drolls	7	53	1239	3	drolls
dulls	6	45	2374	3	_dulls
dwells	10	41	771	3	dwells
ells	4	64	3135	3	__ells
ethyls	12	3	590	3	ethy_ls
falls	8	57	2765	3	_falls
fells	8	53	2738	3	_fells
fills	8	46	3237	3	_fills
frills	9	44	1422	3	frills
fulls	8	46	2352	3	_fulls
gables	9	42	2233	3	gables
galas	6	57	3164	3	g_alas
gales	6	54	4248	3	g_ales
gall	5	63	3599	3	g_all_
gallus	7	43	1320	3	gallus
gally	9	50	2617	3	g_ally
gals	5	79	4650	3	g__als
gaols	6	67	1757	3	g_aols
gaults	7	41	1278	3	gaults
gavels	10	59	1109	3	gavels
gayal	9	3	1271	3	gayal_
gayly	12	45	1309	3	gay_ly
gays	8	73	3802	3	gay__s
gelds	7	51	1834	3	g_elds
gels	5	68	3610	3	g__els
gelts	6	59	2461	3	g_elts
ghats	9	58	1861	3	gh_ats
ghauts	10	44	778	3	ghauts
ghazis	19	3	520	3	ghazis
ghees	9	52	1555	3	gh_ees
ghibli	12	4	349	3	ghibli
ghiblis	13	5	334	3	ghiblis
ghillie	11	32	635	3	ghillie
ghillies	12	40	866	3	ghillies
ghis	8	50	2016	3	gh__is
ghosts	10	48	927	3	ghosts
ghoul	9	5	905	3	ghoul_
gilds	7	54	1752	3	g_ilds
gill	5	63	3618	3	g_ill_
gilly	9	43	2163	3	g_illy
gilts	6	49	2426	3	g_ilts
gimels	9	3	889	3	gimels
girls	6	45	1839	3	g_irls
glycols	13	4	413	3	glycols
glycyls	16	4	206	3	glycyls
glyphs	15	3	430	3	glyphs
gnarls	7	42	1077	3	gnarls
goals	6	55	2129	3	g_oals
golds	7	54	2131	3	g_olds
golfs	9	56	1610	3	g_olfs
golly	9	51	2110	3	g_olly
gorals	7	69	1765	3	gorals
goys	8	63	2841	3	goy__s
graals	7	41	1291	3	graals
grails	7	75	1878	3	grails
grill	6	46	1789	3	grill_
grille	7	43	1574	3	grille
grilles	8	37	1502	3	grilles
growls	10	47	1111	3	growls
gruels	7	39	1015	3	gruels
guilds	8	38	835	3	guilds
guiles	7	39	1928	3	guiles
guilts	7	41	1123	3	guilts
gules	6	48	3104	3	g_ules
gulfs	9	49	1530	3	g_ulfs
gull	5	48	2845	3	g_ull_
gully	9	40	2068	3	g_ully
gulps	8	47	1507	3	g_ulps
guls	5	59	3085	3	g__uls
guyots	10	3	600	3	guyots
guys	8	50	1964	3	guy__s
gybes	11	50	1272	3	g_ybes
gyms	10	75	1459	3	g_y_ms
gyps	10	51	1502	3	g_y_ps
gyres	9	48	2032	3	g_yres
gyros	9	56	1648	3	g_yros
gyrus	9	53	1080	3	g_yrus
gyves	12	57	1155	3	g_yves
hails	8	52	3164	3	_hails
halals	9	50	1831	3	_halals
hales	8	54	4984	3	_hales
hall	7	57	4116	3	_hall_
hallo	8	51	2755	3	_hallo
hallos	9	54	2510	3	_hallos
halms	10	52	2521	3	_halms
halos	8	52	3025	3	_halos
halts	8	52	3010	3	_halts
harls	8	56	3450	3	_harls
hauls	8	61	2373	3	_hauls
heals	8	57	3346	3	_heals
heels	8	56	2553	3	_heels
heils	8	52	2219	3	_heils
hell	7	56	3789	3	_hell_
hello	8	65	2298	3	_hello
hellos	9	53	2168	3	_hellos
helms	10	56	1946	3	_helms
helos	8	49	2806	3	_helos
helps	10	52	1934	3	_helps
herls	8	52	2643	3	_herls
hill	7	64	3949	3	_hill_
hillo	8	47	2165	3	_hillo
hillos	9	46	1889	3	_hillos
hilly	11	44	2216	3	_hilly
hilts	8	69	2441	3	_hilts
hilus	8	48	1764	3	_hilus
holds	9	46	2324	3	_holds
holes	8	47	4865	3	_holes
holks	12	47	2056	3	_holks
holla	8	49	1849	3	_holla
hollas	9	46	1690	3	_hollas
hollo	8	48	2216	3	_hollo
hollos	9	53	2063	3	_hollos
holly	11	48	2443	3	_holly
holms	10	51	1780	3	_holms
hols	7	69	4629	3	_h_ols
holts	8	56	2791	3	_holts
howls	11	62	1922	3	_howls
hoyles	12	3	1501	3	hoyles
hulas	8	49	2088	3	_hulas
hulks	12	57	1548	3	_hulks
hull	7	54	2878	3	_hull_
hullo	8	44	1745	3	_hullo
hullos	9	49	1629	3	_hullos
hurls	8	65	2271	3	_hurls
hyla	10	67	1651	3	_hy_la
hymns	13	3	752	3	_hymns
hypes	13	58	1867	3	_hypes
hypos	13	120	1474	3	_hypos
hyps	12	54	1841	3	_hy_ps
idyll	9	43	671	3	idyll_
idyls	9	49	880	3	idy_ls
ills	4	70	3042	3	__ills
jells	12	55	2216	3	_jells
jills	12	51	2282	3	_jills
kayles	13	47	1200	3	kayles
kills	9	45	2617	3	_kills
knells	10	43	925	3	knells
knolls	10	36	741	3	knolls
krills	10	42	1128	3	krills
kvells	13	34	661	3	kvells
lalls	5	53	2413	3	_lalls
lolls	5	121	2173	3	_lolls
lulls	5	41	1965	3	_lulls
maills	8	42	1528	3	maills
malls	7	62	3343	3	_malls
mells	7	50	3133	3	_mells
mills	7	54	3505	3	_mills
molls	7	51	2978	3	_molls
mulls	7	51	2415	3	_mulls
nills	5	49	2667	3	_nills
nulls	5	50	1998	3	_nulls
odyles	10	34	856	3	odyles
odyls	9	42	865	3	ody_ls
palls	7	43	3256	3	_palls
phalli	11	4	826	3	phalli
phallus	12	3	606	3	phallus
phials	11	5	887	3	phials
phyla	13	46	918	3	phy_la
phylae	14	45	873	3	phylae
phylar	14	43	737	3	phylar
phyle	13	41	1115	3	phy_le
phylic	16	27	955	3	phylic
phylon	14	31	803	3	phylon
phylum	16	5	515	3	phylum
physes	14	39	978	3	physes
physis	14	35	966	3	physis
phytols	15	27	655	3	phytols
pills	7	41	3097	3	_pills
polls	7	46	2772	3	_polls
prills	8	40	1561	3	prills
psylla	11	3	395	3	psylla
psyllas	12	4	488	3	psyllas
pulls	7	44	2505	3	_pulls
quells	15	35	970	3	quells
quills	15	38	1185	3	quills
quolls	15	32	730	3	quolls
rhymes	14	41	982	3	rhymes
rills	5	50	3271	3	_rills
riyals	9	41	1108	3	riyals
rolls	5	53	2623	3	_rolls
royals	9	37	1126	3	royals
scalls	8	42	1820	3	scalls
sculls	8	46	1388	3	sculls
sells	5	51	3443	3	_sells
shales	9	47	3125	3	shales
shall	8	50	2405	3	shall_
shauls	9	49	1311	3	shauls
shawls	12	54	1197	3	shawls
sheals	9	44	2064	3	sheals
shell	8	44	2412	3	shell_
shelly	12	44	1447	3	shelly
sheols	9	46	1416	3	sheols
shiels	9	54	1892	3	shiels
shill	8	53	2533	3	shill_
shoals	9	42	1579	3	shoals
shools	9	49	1901	3	shools
shorls	9	45	1620	3	shorls
shrills	10	38	993	3	shrills
shuls	8	53	1971	3	sh_uls
shyers	12	47	1220	3	shyers
shyly	14	48	1157	3	shy_ly
sills	5	51	3599	3	_sills
skells	10	50	1378	3	skells
skills	10	43	1392	3	skills
skulls	10	42	964	3	skulls
smalls	8	45	1412	3	smalls
smells	8	39	1474	3	smells
snells	6	46	1420	3	snells
spalls	8	42	1734	3	spalls
spells	8	46	1768	3	spells
spills	8	47	1746	3	spills
stalls	6	40	1993	3	stalls
stills	6	41	1857	3	stills
stulls	6	39	1298	3	stulls
styles	9	44	1865	3	styles
stylus	9	39	746	3	stylus
swells	9	39	1398	3	swells
swills	9	42	1336	3	swills
sylis	8	43	1602	3	_sylis
talls	5	51	3343	3	_talls
tells	5	58	2894	3	_tells
thalli	9	5	892	3	thalli
thallus	10	3	560	3	thallus
thill	8	59	1873	3	thill_
thiols	9	51	1276	3	thiols
thirls	9	50	1206	3	thirls
tholes	9	49	1978	3	tholes
tholos	9	42	1300	3	tholos
thralls	10	29	904	3	thralls
thrills	10	39	878	3	thrills
thurls	9	41	871	3	thurls
thymes	14	48	1074	3	thymes
thymols	15	3	384	3	thymols
thymus	14	32	474	3	thymus
tills	5	46	3171	3	_tills
tolls	5	47	2843	3	_tolls
tolyls	9	43	696	3	tolyls
trills	6	43	1985	3	trills
trolls	6	46	1394	3	trolls
trulls	6	41	1028	3	trulls
twills	9	48	979	3	twills
uphills	12	9	523	3	uphills
vills	8	64	2932	3	_vills
walls	8	55	2938	3	_walls
wells	8	54	2619	3	_wells
whales	12	47	1694	3	whales
wheals	12	45	1252	3	wheals
wheels	12	38	1172	3	wheels
whelks	16	36	732	3	whelks
whelms	14	37	757	3	whelms
whelps	14	43	784	3	whelps
whiles	12	44	1801	3	whiles
whirls	12	47	1053	3	whirls
wholes	12	46	1677	3	wholes
wholly	15	36	657	3	wholly
whorls	12	44	1016	3	whorls
whys	13	70	1166	3	why__s
wills	8	45	2896	3	_wills
wyles	11	46	1532	3	_wyles
xylols	16	3	417	3	_xylols
xylyls	19	3	183	3	_xylyls
yells	8	58	2194	3	_yells
yills	8	39	2155	3	_yills
zills	14	40	2078	3	_zills

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.390	458182.1
2	DLD Change Limit	112716	333	6.093	18499.3
3	Display Results	333	333	0.110	3027.3
	(SQL Overall)	178691	333	6.593	27103.1