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

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

57 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
dreamed	11	43	1063	(None)
breamed	12	40	1159	1	breamed
creamed	12	39	1371	1	creamed
dreaded	10	36	1202	1	dreaded
dreamer	10	41	1084	1	dreamer
reamed	9	43	2612	1	_reamed
beamed	11	57	2073	2	_beamed
breaded	11	50	1406	2	breaded
creaked	14	34	1323	2	creaked
creamer	11	37	1408	2	creamer
creased	10	43	1558	2	creased
created	10	43	2345	2	created
deaned	8	46	2045	2	d_eaned
deaved	11	49	1655	2	d_eaved
deemed	10	47	1306	2	d_eemed
defamed	14	30	983	2	defamed
derated	9	36	2350	2	derated
dramedy	14	3	324	2	dr_amedy
drammed	13	37	807	2	drammed
draped	10	53	1436	2	dr_aped
drayed	11	59	1139	2	dr_ayed
dread	7	44	1902	2	drea__d
dream	8	51	2039	2	dream__
dreamers	11	36	900	2	dreamers
dreamier	11	28	729	2	dreamier
dreams	9	45	1398	2	dream_s
dreamt	9	46	1571	2	dream_t
dreamy	12	50	999	2	dream_y
dredged	11	34	688	2	dredged
dreed	7	52	2284	2	dre__ed
dressed	9	35	1187	2	dressed
drummed	13	30	632	2	drummed
framed	12	51	1652	2	fr_amed
freaked	15	39	970	2	freaked
gleamed	11	32	793	2	gleamed
greased	9	38	1239	2	greased
greaved	12	40	891	2	greaved
preaged	11	6	1233	2	preaged
prearmed	13	9	799	2	prearmed
premed	11	46	1775	2	pre_med
reamer	8	43	2521	2	_reamer
reaped	9	41	2245	2	_reaped
reared	7	59	3001	2	_reared
rearmed	10	39	1282	2	_rearmed
reaved	10	45	2392	2	_reaved
redreamed	13	4	502	2	redreamed
renamed	10	31	1452	2	_renamed
roamed	9	52	1509	2	_roamed
screamed	13	27	759	2	screamed
seamed	9	48	2388	2	_seamed
steamed	10	37	1214	2	steamed
streamed	11	25	890	2	streamed
teamed	9	54	1859	2	_teamed
treaded	9	50	1428	2	treaded
treated	8	36	1870	2	treated
undreamed	13	3	697	2	undreamed
wreaked	15	36	902	2	wreaked

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.140	1276364.3
2	DLD Change Limit	107671	57	3.580	30075.7
3	Display Results	57	57	0.016	3562.5
	(SQL Overall)	178691	57	3.736	47829.5