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

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

335 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
gayety	13	11	638	(None)
gaiety	10	11	937	1	gaiety
gadgety	13	35	616	2	gadgety
gamely	12	47	1191	2	gamely
gamete	9	3	1359	2	gamete
gamey	11	53	2055	2	game_y
gargety	12	38	804	2	gargety
gaseity	11	3	511	2	gaseity
gayer	9	45	1919	2	gaye_r
gayest	10	43	1433	2	gayest
gayly	12	45	1309	2	gay_ly
gleety	10	47	919	2	gleety
hayey	14	48	1253	2	haye_y
safety	12	20	691	2	safety
abet	6	105	4794	3	_abet_
abets	7	56	2167	3	_abets
aceta	7	40	1735	3	_aceta
acetyl	11	39	655	3	_acetyl
aery	7	72	3168	3	_a_ery
agamete	10	3	739	3	agamete
aglet	6	55	3414	3	aglet_
aglets	7	39	1568	3	aglets
agley	9	69	1733	3	agle_y
agouty	10	36	691	3	agouty
amity	10	4	1609	3	_amity
apery	10	65	1790	3	_apery
arete	5	60	3135	3	_arete
arty	7	75	3131	3	_a_rty
aunty	8	59	1981	3	_aunty
aye	6	71	5176	3	_aye__
ayes	7	65	4351	3	_aye_s
bakery	15	59	1100	3	bakery
banty	10	66	2400	3	ba_nty
barely	11	47	1679	3	barely
basely	11	44	1231	3	basely
batty	10	54	2224	3	ba_tty
bawty	13	56	1410	3	ba_wty
bayed	11	54	2302	3	baye_d
cadet	8	53	3933	3	cadet_
cadets	9	63	1650	3	cadets
cagey	11	59	1782	3	cage_y
cakey	14	55	1727	3	cake_y
canty	10	52	2680	3	ca_nty
caret	7	53	6056	3	caret_
carets	8	53	3077	3	carets
casefy	14	3	627	3	casefy
catty	10	45	2041	3	ca_tty
cavity	14	3	1001	3	cavity
clayey	14	40	766	3	claye_y
dainty	10	53	1147	3	dainty
daleth	10	3	863	3	daleth
dayfly	16	3	381	3	dayfly
eatery	9	53	1635	3	eatery
facet	10	60	3852	3	facet_
facete	11	50	1483	3	facete
facets	11	63	1665	3	facets
faery	11	60	1548	3	fa_ery
fakery	16	50	926	3	fakery
fakey	15	55	1542	3	fake_y
fatty	11	51	1741	3	fa_tty
faulty	12	42	936	3	faulty
fayed	12	64	2215	3	faye_d
gabby	13	55	1295	3	ga_bby
gaby	10	71	2319	3	ga__by
gadfly	14	3	466	3	gadfly
gadget	9	36	1617	3	gadget_
gadgetry	14	26	320	3	gadgetry
gadgets	10	34	868	3	gadgets
gae	4	64	5770	3	ga_e__
gaed	6	60	3151	3	ga_e_d
gaen	5	73	2960	3	ga_e_n
gaes	5	63	4803	3	ga_e_s
gage	6	59	3610	3	gage__
gaged	8	55	2231	3	gage_d
gager	7	47	2629	3	gage_r
gagers	8	40	2132	3	gagers
gages	7	45	2997	3	gage_s
gaily	9	50	2097	3	ga_ily
gainly	10	4	932	3	gainly
gait	5	61	5019	3	ga_it_
gaited	8	44	1692	3	gaited
gaiter	7	38	1950	3	gaiter
gaits	6	57	2601	3	ga_its
galaxy	17	47	631	3	galaxy
gale	5	63	4732	3	gale__
galea	6	47	2293	3	gale_a
galeae	7	47	1745	3	galeae
galeas	7	46	1850	3	galeas
galeate	8	39	1678	3	galeate
galena	7	49	1109	3	galena
galere	7	37	1667	3	galere
gales	6	54	4248	3	gale_s
galette	8	42	1269	3	galette
gallery	11	46	874	3	gallery
gallet	7	36	3085	3	gallet_
galleta	8	39	964	3	galleta
gallets	8	35	1740	3	gallets
galley	10	42	1545	3	galley
gally	9	50	2617	3	ga_lly
gamay	11	64	1910	3	ga_may
game	7	66	4432	3	game__
gamed	9	51	2639	3	game_d
gamer	8	49	2894	3	game_r
gamers	9	44	2082	3	gamers
games	8	62	3855	3	game_s
gamest	9	49	1992	3	gamest
gametal	10	3	760	3	gametal
gametes	10	3	1225	3	gametes
gametic	12	3	998	3	gametic
gamily	12	37	1218	3	gamily
gammy	13	55	1489	3	ga_mmy
gamut	8	3	2298	3	gamut_
gamuts	9	5	878	3	gamuts
gamy	10	54	2753	3	ga__my
gane	5	51	4529	3	gane__
ganef	9	63	2246	3	gane_f
ganefs	10	48	920	3	ganefs
ganev	9	55	1386	3	gane_v
ganevs	10	45	691	3	ganevs
gangly	11	39	1158	3	gangly
gannet	7	43	2185	3	gannet_
gannets	8	38	1144	3	gannets
gantry	10	38	1011	3	gantry
gape	7	51	3451	3	gape__
gaped	9	61	2353	3	gape_d
gaper	8	61	2512	3	gape_r
gapers	9	45	2046	3	gapers
gapes	8	60	3082	3	gape_s
gappy	13	62	1203	3	ga_ppy
gapy	10	63	2091	3	ga__py
garget	8	43	2727	3	garget_
gargets	9	46	1457	3	gargets
garnet	7	39	2841	3	garnet_
garnets	8	41	1540	3	garnets
garote	7	7	1794	3	garote
garret	7	44	2655	3	garret_
garrets	8	44	1362	3	garrets
garter	7	44	2051	3	garter
garth	9	47	2022	3	ga_rth
garvey	13	12	787	3	garvey
gases	6	56	3399	3	gase_s
gasify	13	3	633	3	gasify
gasket	11	44	1725	3	gasket_
gaskets	12	34	815	3	gaskets
gassy	9	55	1402	3	ga_ssy
gast	5	60	5256	3	ga_st_
gasted	8	48	2158	3	gasted
gaster	7	50	2735	3	gaster
gasts	6	66	2863	3	ga_sts
gat	4	68	8051	3	ga__t_
gate	5	57	4657	3	ga__te
gateau	7	7	810	3	gateau
gated	7	53	2977	3	gate_d
gater	6	45	3364	3	gate_r
gaters	7	47	2863	3	gaters
gates	6	59	3950	3	gate_s
gateway	14	3	492	3	gateway
gats	5	67	5344	3	ga__ts
gaudery	12	3	474	3	gaudery
gaudy	10	66	1146	3	ga_udy
gault	6	51	2848	3	gault_
gaults	7	41	1278	3	gaults
gaunt	6	54	3040	3	gaunt_
gauntly	11	3	533	3	gauntly
gauntry	11	5	411	3	gauntry
gauzy	18	48	921	3	ga_uzy
gave	8	46	3405	3	gave__
gavel	9	58	1518	3	gave_l
gavels	10	59	1109	3	gavels
gavot	9	3	2111	3	gavot_
gavots	10	3	810	3	gavots
gawky	16	56	999	3	ga_wky
gawsy	12	45	909	3	ga_wsy
gay	7	68	5649	3	ga___y
gayal	9	3	1271	3	gay_al
gayals	10	3	951	3	gayals
gaydar	11	3	550	3	gaydar
gayeties	12	3	688	3	gayeties
gayness	11	3	684	3	gayness
gays	8	73	3802	3	gay__s
gaze	14	50	3241	3	gaze__
gazebo	18	3	367	3	gazebo
gazed	16	55	2033	3	gaze_d
gazer	15	57	2007	3	gaze_r
gazers	16	45	1629	3	gazers
gazes	15	54	2591	3	gaze_s
gazette	17	35	736	3	gazette
geeky	13	47	1073	3	g_eeky
genet	6	60	3868	3	genet_
genets	7	57	1666	3	genets
get	4	74	6746	3	g__et_
geta	5	66	2744	3	g__eta
gets	5	54	4248	3	g__ets
gey	7	57	3830	3	g__e_y
ghosty	13	46	721	3	ghosty
gleet	6	55	3234	3	gleet_
gleets	7	53	1505	3	gleets
gley	8	57	2465	3	g_le_y
glinty	10	69	1069	3	glinty
gluey	9	57	1526	3	glue_y
gnatty	10	33	648	3	gnatty
godet	7	5	3004	3	godet_
godets	8	4	1093	3	godets
gooey	9	55	2286	3	gooe_y
gouty	9	52	1736	3	g_outy
grapery	13	45	795	3	grapery
grapey	12	60	1230	3	grape_y
gravely	14	46	906	3	gravely
gravity	14	3	718	3	gravity
grayed	11	54	1564	3	graye_d
grayer	10	60	1454	3	graye_r
grayest	11	48	936	3	grayest
grayly	13	28	796	3	gray_ly
greedy	11	51	884	3	greedy
greeny	10	48	1145	3	greeny
greet	6	58	3532	3	greet_
greets	7	51	1742	3	greets
grey	8	56	2404	3	g_re_y
greyly	13	31	654	3	greyly
gritty	10	33	840	3	gritty
grotty	10	38	983	3	grotty
grouty	10	47	1098	3	grouty
guilty	10	41	823	3	guilty
gusty	9	51	1957	3	g_usty
gutty	9	45	1699	3	g_utty
guyed	10	4	989	3	guye_d
guyot	9	3	1452	3	guyot_
guyots	10	3	600	3	guyots
gypsy	14	63	699	3	g_ypsy
haet	7	56	5950	3	ha_et_
haets	8	65	2512	3	ha_ets
hasty	11	57	1876	3	ha_sty
hayed	12	58	2201	3	haye_d
hayer	11	46	2024	3	haye_r
hayers	12	44	1594	3	hayers
janty	15	68	1696	3	ja_nty
japery	18	43	914	3	japery
jaunty	16	38	851	3	jaunty
lacey	10	58	2091	3	lace_y
laity	8	53	1890	3	la_ity
lamely	11	40	1322	3	lamely
lanely	9	39	1448	3	lanely
lately	9	34	1384	3	lately
laxity	16	3	727	3	laxity
layed	9	51	2738	3	laye_d
layer	8	46	2647	3	laye_r
layers	9	39	2118	3	layers
layette	10	3	713	3	layette
majesty	19	4	350	3	majesty
malty	10	67	2170	3	ma_lty
mamey	12	54	1883	3	mame_y
matey	10	70	2266	3	mate_y
mayday	15	3	587	3	mayday
mayed	11	55	2240	3	maye_d
mayest	11	46	1479	3	mayest
mayfly	17	3	440	3	mayfly
mayst	10	66	2267	3	mayst_
moiety	11	4	822	3	moiety
naivety	13	4	427	3	naivety
namely	11	37	1132	3	namely
napery	11	48	981	3	napery
nasty	8	57	1728	3	na_sty
natty	8	57	1914	3	na_tty
naysay	12	3	497	3	naysay
nicety	11	3	843	3	nicety
ninety	9	5	1096	3	ninety
pacey	12	67	2028	3	pace_y
painty	11	47	1475	3	painty
palely	11	3	1192	3	palely
palet	7	46	5080	3	palet_
palets	8	51	2231	3	palets
panty	10	59	2930	3	pa_nty
papery	13	48	1274	3	papery
parity	11	47	1987	3	parity
party	10	66	3061	3	pa_rty
pasty	10	57	2505	3	pa_sty
patty	10	47	2361	3	pa_tty
paty	9	52	3456	3	pa__ty
payday	15	3	661	3	payday
payed	11	59	2593	3	paye_d
payee	10	55	2472	3	paye_e
payees	11	48	1290	3	payees
payer	10	51	2572	3	paye_r
payers	11	46	2182	3	payers
piety	10	58	1730	3	_piety
rackety	16	49	911	3	rackety
ramet	7	57	4314	3	ramet_
ramets	8	35	1739	3	ramets
rarefy	12	29	634	3	rarefy
rarely	9	35	1365	3	rarely
rarity	9	36	1549	3	rarity
ratty	8	48	1959	3	ra_tty
rayed	9	51	2750	3	raye_d
safely	12	24	939	3	safely
sagely	10	28	1138	3	sagely
salty	8	55	2438	3	sa_lty
sanely	9	31	1461	3	sanely
sanity	9	3	1620	3	sanity
satiety	10	3	820	3	satiety
sayed	9	61	2714	3	saye_d
sayeds	10	46	925	3	sayeds
sayer	8	49	2655	3	saye_r
sayers	9	42	2159	3	sayers
sayest	9	42	1774	3	sayest
sayst	8	53	2200	3	sayst_
skyey	15	53	722	3	skye_y
sleety	9	41	1265	3	sleety
suety	8	53	1849	3	_suety
surety	9	35	1500	3	surety
tacet	7	58	4002	3	tacet_
tamely	11	37	1195	3	tamely
tapeta	8	3	1069	3	tapeta
tarty	8	63	2818	3	ta_rty
tasty	8	48	2031	3	ta_sty
tatty	8	47	2018	3	ta_tty
ubiety	11	3	591	3	ubiety
valet	8	43	3787	3	valet_
valets	9	37	1562	3	valets
vanity	12	3	1193	3	vanity
variety	13	3	774	3	variety
vasty	11	62	1592	3	va_sty
vaulty	12	38	844	3	vaulty
vaunty	12	40	906	3	vaunty
wafery	15	39	869	3	wafery
waney	11	51	2032	3	wane_y
warty	11	93	2382	3	wa_rty
watery	12	39	1449	3	watery
wavery	15	46	1005	3	wavery
wavey	14	51	1554	3	wave_y
waylay	15	3	545	3	waylay
yarely	12	28	1030	3	yarely
yawey	14	45	827	3	yawe_y
yet	6	69	6069	3	__yet_
yeti	7	58	2321	3	__yeti
yett	7	64	3449	3	__yett

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	112716	0.140	1276364.3
2	DLD Change Limit	112716	335	7.546	14937.2
3	Display Results	335	335	0.110	3045.5
	(SQL Overall)	178691	335	7.796	22920.9