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

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

102 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
zygoid	20	4	594	(None)
algoid	8	30	1147	2	algoid
cymoid	14	5	947	2	cymoid
hyoid	12	6	1244	2	hy_oid
myoid	11	5	1299	2	my_oid
myxoid	19	3	688	2	myxoid
pygmoid	16	4	453	2	pygmoid
pyoid	11	5	1376	2	py_oid
xyloid	17	3	819	2	xyloid
zooid	15	3	1210	2	z_ooid
zygoma	21	4	349	2	zygoma
zygose	19	45	555	2	zygose
zygosis	20	40	595	2	zygosis
zygote	19	32	548	2	zygote
zygotic	22	5	466	2	zygotic
algid	7	54	1558	3	alg_id
amyloid	13	4	854	3	amyloid
aroid	6	54	2834	3	_aroid
avoid	9	55	1668	3	_avoid
azygos	19	3	333	3	azygo_s
azygous	20	4	312	3	azygous
bygone	12	5	617	3	bygone
byroad	12	3	662	3	byroad
byword	15	3	505	3	byword
ceboid	11	3	1065	3	ceboid
conoid	9	8	1888	3	conoid
cuboid	11	3	950	3	cuboid
cyanid	12	39	1204	3	cyanid
cycloid	15	3	928	3	cycloid
cystoid	13	30	921	3	cystoid
devoid	11	8	936	3	devoid
droid	7	42	1854	3	_droid
eyelid	10	3	844	3	eyelid
fucoid	12	3	789	3	fucoid
fungoid	12	4	525	3	fungoid
gadoid	9	3	1046	3	gadoid
ganoid	8	3	1444	3	ganoid
geoid	7	42	1576	3	_geoid
gid	5	70	4726	3	__g_id
goad	6	68	3098	3	__goad
god	5	74	4979	3	__go_d
gold	6	54	3016	3	__gold
good	6	65	3180	3	__good
gowd	9	65	1998	3	__gowd
grid	6	58	2961	3	__grid
guid	6	60	2282	3	__guid
haloid	10	43	1776	3	haloid
hemoid	12	3	1351	3	hemoid
hyaloid	14	3	907	3	hyaloid
hybrid	15	23	781	3	hybrid
hydrid	14	24	897	3	hydrid
hydroid	15	3	971	3	hydroid
hyenoid	14	4	861	3	hyenoid
hyoids	13	7	767	3	hy_oids
hypnoid	16	4	788	3	hypnoid
hypoed	15	4	792	3	hypoed
keloid	11	8	1262	3	keloid
lipoid	9	4	1104	3	lipoid
logoi	6	97	1594	3	logoi_
loid	5	55	3149	3	__loid
meloid	9	6	1600	3	meloid
mucoid	11	3	978	3	mucoid
myeloid	13	10	812	3	myeloid
mysid	11	6	1069	3	my_sid
negroid	9	10	889	3	negroid
nevoid	10	9	879	3	nevoid
opioid	9	3	1008	3	opioid
ovoid	9	48	1102	3	_ovoid
pagod	9	50	1368	3	pago_d
phytoid	16	7	875	3	phytoid
rigid	7	9	1389	3	rig_id
sigmoid	11	4	611	3	sigmoid
sloid	6	46	1971	3	_sloid
styloid	11	3	755	3	styloid
synod	9	6	1028	3	syno_d
thyroid	14	3	825	3	thyroid
toroid	7	4	1601	3	toroid
toxoid	14	3	815	3	toxoid
typhoid	16	4	813	3	typhoid
valgoid	12	5	521	3	valgoid
viroid	10	4	1152	3	viroid
void	8	62	2056	3	__void
yid	7	66	4082	3	_y__id
yod	7	75	4550	3	_y_o_d
yogi	8	61	2042	3	_yogi_
yogic	11	61	1493	3	_yogic
yogin	9	83	1774	3	_yogin
yogis	9	56	1774	3	_yogis
yond	8	61	2231	3	_y_ond
zagged	18	36	1251	3	zagged
zebroid	19	3	646	3	zebroid
zeroed	16	40	941	3	zeroed
zigged	18	41	1019	3	zigged
zincoid	19	4	666	3	zincoid
zoic	15	23	1607	3	z__oic
zooids	16	3	709	3	z_ooids
zygomas	22	4	341	3	zygomas
zygoses	20	43	678	3	zygoses
zygosity	24	4	298	3	zygosity
zygotes	20	35	516	3	zygotes
zymosis	21	48	749	3	zymosis
zymotic	23	4	571	3	zymotic

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.123	1452772.4
2	DLD Change Limit	112716	102	6.673	16891.4
3	Display Results	102	102	0.030	3400.0
	(SQL Overall)	178691	102	6.826	26178.0