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

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

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.

59 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
flammed	15	37	741	(None)
clammed	14	36	996	1	clammed
flamed	12	46	1897	1	fla_med
lammed	11	39	1562	1	_lammed
slammed	12	35	1110	1	slammed
alarmed	10	3	773	2	alarmed
bammed	13	39	1324	2	_bammed
blamed	11	60	1795	2	bla_med
claimed	12	29	883	2	claimed
clammer	13	42	1179	2	clammer
clamped	14	40	1204	2	clamped
crammed	14	37	1012	2	crammed
dammed	12	42	1479	2	_dammed
drammed	13	37	807	2	drammed
famed	11	59	2834	2	f_a_med
farmed	12	51	1765	2	f_armed
flacked	17	37	1158	2	flacked
flagged	13	45	963	2	flagged
flagmen	13	22	691	2	flagmen
flailed	11	3	730	2	flailed
flaked	14	47	1565	2	fla_ked
flambe	13	48	915	2	flambe_
flambee	14	42	1001	2	flambee
flambeed	16	32	438	2	flambeed
flambes	14	41	950	2	flambes
flame	10	51	2444	2	fla_me_
flamen	11	52	1599	2	fla_men
flamer	11	49	1912	2	fla_mer
flames	11	47	2369	2	fla_mes
flamier	12	31	1214	2	flamier
flanged	12	38	1084	2	flanged
flanked	15	37	1064	2	flanked
flapped	15	32	825	2	flapped
flared	10	53	1760	2	fla_red
flashed	14	41	1218	2	flashed
flatbed	13	39	798	2	flatbed
flatted	11	40	1294	2	flatted
flawed	13	47	1272	2	fla_wed
flayed	13	44	1405	2	fla_yed
flumed	12	49	1526	2	fl_umed
flumped	15	37	771	2	flumped
foamed	12	60	1440	2	foa_med
framed	12	51	1652	2	fra_med
gammed	12	42	1616	2	_gammed
glommed	13	26	544	2	glommed
hammed	14	41	1697	2	_hammed
jammed	18	38	1150	2	_jammed
lambed	11	56	1478	2	_lambed
lamed	8	52	3529	2	_la_med
lamped	11	40	1754	2	_lamped
rammed	11	31	1730	2	_rammed
scammed	14	47	954	2	scammed
shammed	15	39	1142	2	shammed
slammer	11	39	1303	2	slammer
slimmed	12	36	847	2	slimmed
slummed	12	35	927	2	slummed
spammed	14	34	852	2	spammed
trammed	12	38	1071	2	trammed
whammed	18	34	513	2	whammed

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	107671	0.173	1032896.0
2	DLD Change Limit	107671	59	3.720	28943.8
3	Display Results	59	59	0.013	4538.5
	(SQL Overall)	178691	59	3.906	45747.8