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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

51 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
emeralds	11	4	459	(None)
emerald	10	4	692	1	emerald_
emerods	10	13	765	2	emer_ods
emeroids	11	14	772	2	emeroids
heralds	11	3	771	2	_heralds
demeraras	12	4	373	3	demeraras
embalms	13	3	533	3	em_balms
embraces	14	12	887	3	embraces
emeerates	11	4	937	3	emeerates
emends	9	57	1143	3	eme__nds
emerged	11	15	821	3	emerged_
emerges	10	13	1088	3	emer_ges
emeries	9	16	2002	3	emer_ies
emeritas	10	4	643	3	emeritas
emeritus	10	4	517	3	emeritus
emerod	9	13	921	3	emer_od_
emeroid	10	15	1118	3	emeroid_
emersed	10	13	851	3	emersed_
emirates	10	12	1485	3	emirates
empales	11	24	1143	3	em_pales
energids	10	4	558	3	energids
errands	8	4	760	3	e_rrands
eternals	8	23	895	3	eternal_s
eyeballs	13	4	421	3	eyeballs
eyefolds	15	4	262	3	eyefolds
federals	12	4	730	3	federal_s
ferals	9	42	1664	3	_feral_s
generals	9	10	933	3	general_s
gomerals	11	4	744	3	gomeral_s
herald	10	3	1134	3	_herald_
humerals	13	4	717	3	humeral_s
marauds	10	3	755	3	_marauds
meads	8	54	2532	3	_me_a_ds
meals	7	59	3337	3	_me_al_s
medals	9	42	1805	3	_medal_s
melds	8	48	2238	3	_me__lds
menads	9	55	1438	3	_mena_ds
merles	8	53	2276	3	_mer_les
merls	7	74	2390	3	_mer_l_s
mermaids	13	5	575	3	_mermaids
metals	8	45	2088	3	_metal_s
morales	9	36	1940	3	_morales
morals	8	53	2463	3	_moral_s
murals	8	40	1676	3	_mural_s
numerals	10	4	733	3	numeral_s
operands	11	4	681	3	operands
overalls	11	4	1039	3	overalls
piebalds	13	4	434	3	piebalds
severals	11	3	759	3	several_s
smaragds	12	4	330	3	smaragds
wealds	10	45	910	3	_we_alds

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	146162	0.406	440125.6
2	DLD Change Limit	146162	51	6.970	20970.2
3	Display Results	51	51	0.013	3923.1
	(SQL Overall)	178691	51	7.389	24183.4