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

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

91 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
hammada	15	4	508	(None)
hamada	12	3	991	1	ha_mada
hammadas	16	4	478	1	hammadas
armada	9	3	878	2	_armada
gammadia	14	4	391	2	gammadia
haggada	13	5	362	2	haggada
hamadas	13	3	966	2	ha_madas
hammal	13	45	1206	2	hamma_l
hammals	14	40	921	2	hammals
hammam	12	41	933	2	hamma_m
hammams	13	38	643	2	hammams
hammed	14	41	1697	2	hammed_
lambada	12	4	564	2	lambada
ramada	9	3	1018	2	ra_mada
aggada	9	5	520	3	_aggada
armadas	10	3	817	3	_armadas
bammed	13	39	1324	3	bammed_
chamade	15	13	843	3	cha_made
champaca	19	4	320	3	champaca
commata	13	3	848	3	commata
damiana	10	4	656	3	damiana
dammar	11	43	890	3	damma_r
dammars	12	30	819	3	dammars
dammed	12	42	1479	3	dammed_
gambade	13	3	638	3	gambade
gambado	13	4	497	3	gambado
gamma	10	61	1610	3	gamm__a
gammas	11	57	1469	3	gamma_s
gammed	12	42	1616	3	gammed_
gummata	12	4	461	3	gummata
haemal	11	38	1164	3	haema_l
haematal	13	4	514	3	haematal
haftara	13	13	609	3	haftara
haggadah	17	6	257	3	haggadah
haggadas	14	6	361	3	haggadas
halala	9	47	1509	3	ha_lala
halma	10	82	1925	3	halm__a
halmas	11	70	1789	3	halma_s
hamal	10	46	2310	3	ha_ma_l
hamals	11	48	1681	3	ha_mals
hamate	11	33	1982	3	ha_mate
hamaul	11	42	1086	3	ha_maul
hammer	13	81	2003	3	hamm_er
hammers	14	42	1605	3	hammers
hammier	14	35	1065	3	hammier
hammily	17	3	606	3	hammily
hamming	15	30	1409	3	hamming
hammock	20	6	463	3	hammock
hammy	15	51	1343	3	hamm__y
hamza	19	13	977	3	ha_m_za
hamzah	23	13	555	3	hamza_h
hamzahs	24	13	437	3	hamzahs
hamzas	20	11	901	3	hamza_s
handmade	15	4	595	3	handmade
hariana	10	3	1024	3	hariana
harmed	12	52	1883	3	harmed_
hawala	12	36	891	3	ha_wala
hazmat	20	3	1226	3	hazma_t
hazmats	21	3	660	3	hazmats
hemmed	14	42	1146	3	hemmed_
homemade	16	4	513	3	homemade
hummed	14	48	1267	3	hummed_
jammed	18	38	1150	3	jammed_
kamala	12	33	996	3	ka_mala
lambadas	13	5	487	3	lambadas
lambda	11	4	611	3	la_mbda
lammed	11	39	1562	3	lammed_
lampad	11	45	1003	3	lampad_
lampads	12	47	762	3	lampads
lemmata	11	4	467	3	lemmata
magmata	12	3	746	3	magmata
mamma	8	63	1791	3	mamm__a
mammae	9	46	1321	3	mamma_e
mammal	9	51	1275	3	mamma_l
mammals	10	38	927	3	mammals
mammary	13	3	599	3	mammary
mammas	9	46	1640	3	mamma_s
mammate	10	44	1127	3	mammate
mammati	10	39	837	3	mammati
manmade	12	3	796	3	manmade
panada	9	41	1305	3	pa_nada
ramadas	10	3	930	3	ra_madas
rammed	11	31	1730	3	rammed_
samara	8	3	1385	3	sa_mara
samsara	9	3	691	3	samsara
shammas	14	35	871	3	shamma_s
shammash	18	29	374	3	shammash
shammed	15	39	1142	3	shammed_
tambala	11	3	802	3	tambala
tampala	11	3	661	3	tampala
whammed	18	34	513	3	whammed_

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	134027	0.236	757165.3
2	DLD Change Limit	134027	91	7.483	17910.9
3	Display Results	91	91	0.046	1978.3
	(SQL Overall)	178691	91	7.765	23012.4