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

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

113 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
tamal	7	35	2262	(None)
hamal	10	46	2311	1	hamal
ramal	7	46	2224	1	ramal
tamale	8	37	1740	1	tamale
tamals	8	41	1663	1	tamals
aal	3	90	5867	2	_a_al
ama	5	108	5330	2	_ama_
amah	9	89	2749	2	_amah
amas	6	77	4629	2	_amas
amyl	9	55	1510	2	_amyl
anal	4	80	3752	2	_anal
atabal	8	3	974	2	atabal
ataman	8	10	1306	2	ataman
atma	6	81	2177	2	atma_
atman	7	55	2014	2	atman
atmas	7	57	2101	2	atmas
axal	11	65	2049	2	_axal
baal	6	70	3311	2	ba_al
banal	7	59	2599	2	banal
basal	7	57	2228	2	basal
cabal	9	52	2215	2	cabal
camail	10	3	1483	2	camail
camas	9	63	3352	2	camas
camel	9	68	2280	2	camel
canal	7	54	2804	2	canal
comal	9	51	2513	2	comal
daman	8	48	2116	2	daman
damar	8	41	1773	2	damar
domal	8	56	1920	2	domal
fatal	8	48	1937	2	fatal
gama	7	70	3552	2	gama_
gamas	8	54	3136	2	gamas
gamay	11	64	1911	2	gamay
gayal	9	3	1271	2	gayal
hadal	9	55	1812	2	hadal
haemal	11	38	1164	2	haemal
halal	8	56	2359	2	halal
hamals	11	48	1682	2	hamals
hamaul	11	42	1087	2	hamaul
hammal	13	45	1206	2	hammal
hemal	10	44	1980	2	hemal
jacal	14	3	1370	2	jacal
kamala	12	33	996	2	kamala
lama	6	66	3529	2	lama_
lamas	7	55	3279	2	lamas
mama	8	62	3159	2	mama_
mamas	9	59	3077	2	mamas
mammal	9	51	1275	2	mammal
nasal	5	62	1759	2	nasal
natal	5	39	2149	2	natal
naval	8	53	1583	2	naval
papal	9	58	2067	2	papal
ratal	5	50	2511	2	ratal
sabal	7	54	2248	2	sabal
salal	5	54	2570	2	salal
sambal	10	52	1518	2	sambal
statal	6	16	1322	2	statal
stomal	8	52	1331	2	stomal
tabla	7	33	1836	2	tabla
tael	4	60	3071	2	ta_el
tail	4	54	4365	2	ta_il
taka	8	76	2359	2	taka_
takas	9	55	2068	2	takas
tala	4	59	3805	2	tala_
talar	5	62	2538	2	talar
talas	5	59	3589	2	talas
tall	4	72	4021	2	ta_ll
tam	5	86	6342	2	tam__
tamable	11	3	1285	2	tamable
tamales	9	32	1615	2	tamales
tamari	8	3	1340	2	tamari
tambac	12	22	1024	2	tambac
tambak	14	24	926	2	tambak
tambala	11	3	802	2	tambala
tame	6	63	4366	2	tam_e
tamed	8	55	2851	2	tamed
tamely	11	37	1195	2	tamely
tamer	7	52	3010	2	tamer
tames	7	52	4201	2	tames
tamis	7	67	2873	2	tamis
tammy	12	40	1322	2	tammy
tamp	8	61	3300	2	tam_p
tampala	11	3	661	2	tampala
tampan	10	25	1232	2	tampan
tamps	9	55	2408	2	tamps
tams	6	72	4793	2	tam_s
tapa	6	51	2914	2	tapa_
tapalo	8	3	979	2	tapalo
tapas	7	46	2771	2	tapas
tarmac	10	3	1033	2	tarmac
tarnal	6	37	1650	2	tarnal
tarsal	6	33	1527	2	tarsal
tatar	5	61	2206	2	tatar
taxa	11	68	2009	2	taxa_
taxman	15	32	861	2	taxman
taxol	12	40	1136	2	taxol
teal	4	55	4650	2	t_eal
tepal	7	63	1958	2	tepal
tical	7	60	2149	2	tical
tidal	6	45	1644	2	tidal
timbal	10	25	1075	2	timbal
toman	7	57	2405	2	toman
tombal	10	23	1102	2	tombal
tonal	5	37	2430	2	tonal
total	5	53	2182	2	total
tramel	8	41	1371	2	tramel
trial	5	49	2635	2	trial
tubal	7	55	1720	2	tubal
tymbal	13	23	682	2	tymbal
typal	10	53	1115	2	typal
vagal	9	46	1363	2	vagal
vasal	8	55	1629	2	vasal
wadmal	12	3	728	2	wadmal

Search took 4 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.453	394461.4
2	DLD Change Limit	53800	113	3.376	15936.0
3	Display Results	113	113	0.063	1793.7
	(SQL Overall)	178691	113	3.892	45912.4