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

Here are the results of your fuzzy-string dictionary search for “maize” with Change Limit: [1] [2]

(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
maize	16	46	1856	(None)
baize	16	47	1739	1	baize
maile	7	52	3222	1	maile
maizes	17	51	1573	1	maizes
maze	15	54	3497	1	ma_ze
adze	14	128	2057	2	_adze
aide	5	60	4499	2	_aide
amaze	16	60	1660	2	amaze
amice	9	61	2287	2	amice
amide	8	61	2848	2	amide
amie	6	63	3985	2	ami_e
amine	7	58	3538	2	amine
baiza	16	48	1322	2	baiza
baizes	17	43	1505	2	baizes
bize	15	59	2629	2	_bize
braize	17	41	1311	2	braize
daze	14	73	2723	2	da_ze
faze	16	56	3004	2	fa_ze
gauze	15	57	1297	2	gauze
gaze	14	50	3241	2	ga_ze
haze	16	48	3339	2	ha_ze
laze	13	62	3505	2	la_ze
mabe	8	57	3335	2	ma_be
mace	8	73	4578	2	ma_ce
mache	12	59	2530	2	mache
macle	9	61	2700	2	macle
made	7	54	4023	2	ma_de
madre	8	57	2017	2	madre
mae	5	76	5910	2	ma__e
mage	7	57	3912	2	ma_ge
mahoe	10	3	1557	2	mahoe
maid	7	55	3764	2	mai_d
maiden	9	35	1228	2	maiden
maids	8	63	2714	2	maids
maigre	9	30	916	2	maigre
maihem	13	6	621	2	maihem
mail	6	55	4344	2	mai_l
mailed	9	53	2675	2	mailed
mailer	8	47	2418	2	mailer
mailes	8	43	2911	2	mailes
maill	7	44	2079	2	maill
mails	7	60	3778	2	mails
maim	8	58	3148	2	mai_m
maimed	11	48	1266	2	maimed
maimer	10	45	1459	2	maimer
maims	9	63	2179	2	maims
main	6	53	4551	2	mai_n
mains	7	56	3510	2	mains
mair	6	61	3377	2	mai_r
mairs	7	62	2830	2	mairs
maist	7	55	3568	2	maist
make	10	55	3788	2	ma_ke
male	6	60	5229	2	ma_le
malice	10	48	1848	2	malice
maline	8	45	2908	2	maline
mamie	9	58	2600	2	mamie
mamzer	19	45	983	2	mamzer
mane	6	50	5201	2	ma_ne
mange	8	49	3018	2	mange
manse	7	55	2822	2	manse
maple	9	55	2114	2	maple
mare	6	47	5932	2	ma_re
marge	8	53	2833	2	marge
marine	8	42	3040	2	marine
marse	7	62	3115	2	marse
masse	7	51	2529	2	masse
mate	6	51	5421	2	ma_te
matte	7	56	2684	2	matte
matza	16	3	1181	2	matza
matzo	16	3	1289	2	matzo
mauve	10	40	1327	2	mauve
mavie	10	47	2256	2	mavie
maxixe	14	3	522	2	maxixe
maybe	12	3	1113	2	maybe
mazed	17	55	2387	2	ma_zed
mazer	16	57	2242	2	ma_zer
mazes	16	56	3217	2	ma_zes
mazier	17	50	1306	2	mazier
mazy	18	64	1969	2	ma_zy
meze	15	44	2090	2	m_eze
mice	8	74	4223	2	m_ice
mike	10	55	3529	2	m_ike
mile	6	63	5257	2	m_ile
mime	8	57	3640	2	m_ime
mine	6	72	5616	2	m_ine
mire	6	67	4823	2	m_ire
mise	6	60	4358	2	m_ise
mite	6	62	4941	2	m_ite
mizen	16	48	1527	2	m_izen
moire	7	10	1732	2	moire
naive	8	51	1621	2	naive
paise	7	50	2833	2	paise
prize	16	47	1894	2	prize
raise	5	48	2805	2	raise
raze	13	52	3543	2	ra_ze
saice	7	54	2405	2	saice
seize	14	38	1950	2	seize
size	13	56	3096	2	_size
smaze	16	50	1293	2	sma_ze
tazze	13	3	957	2	tazze
waive	11	42	1460	2	waive
zaire	14	3	1199	2	zaire

Search took 3 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	102	2.453	21932.3
3	Display Results	102	102	0.063	1619.0
	(SQL Overall)	178691	102	2.609	68490.2