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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

108 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
stemmery	15	33	469	(None)
stemmer	11	32	1018	1	stemmer_
stemmers	12	37	844	1	stemmers
shimmery	18	26	525	2	shimmery
stammer	11	60	1334	2	stammer_
stammers	12	36	1152	2	stammers
steamer	9	33	1309	2	steamer_
steamers	10	34	1087	2	steamers
stemmed	12	27	815	2	stemme_d
stemmier	12	4	525	2	stemmier_
stemmy	13	41	703	2	stemm__y
summery	14	32	941	2	s_ummery
creamery	15	38	598	3	creamery
emery	10	48	1433	3	__e_mery
emmer	9	43	1446	3	__emmer_
emmers	10	40	1322	3	__emmers
empery	13	4	868	3	__empery
flummery	18	3	305	3	flummery
hemmer	13	41	1264	3	_hemmer_
hemmers	14	33	1084	3	_hemmers
mummery	13	33	666	3	_mummery
scammer	13	36	1197	3	scammer_
scammers	14	33	977	3	scammers
scenery	12	3	656	3	sce_nery
scummer	13	39	875	3	scummer_
scummers	14	27	778	3	scummers
sealery	10	40	1105	3	s_ealery
seamer	8	42	2361	3	s_eamer_
seamers	9	47	1943	3	s_eamers
seemer	8	44	1804	3	s_eemer_
seemers	9	38	1433	3	s_eemers
semidry	13	4	520	3	s_emidry
shammer	14	46	1314	3	shammer_
shammers	15	37	1084	3	shammers
shimmer	14	33	1087	3	shimmer_
shimmers	15	26	941	3	shimmers
simmer	10	41	1535	3	s_immer_
simmers	11	33	1461	3	s_immers
skimmer	15	32	753	3	skimmer_
skimmers	16	29	646	3	skimmers
slammer	11	39	1303	3	slammer_
slammers	12	35	1122	3	slammers
slimmer	11	42	1134	3	slimmer_
slimmers	12	36	963	3	slimmers
slumbery	15	29	604	3	slumbery
slummer	11	37	1120	3	slummer_
slummers	12	35	893	3	slummers
smeltery	13	27	496	3	smeltery
sneery	9	36	1041	3	sne__ery
spammer	13	34	1043	3	spammer_
spammers	14	37	869	3	spammers
spermary	15	4	504	3	spermary
staggery	13	34	624	3	staggery
stammel	11	60	753	3	stamme_l
stammels	12	49	556	3	stammels
stammered	14	4	464	3	stammered
stammerer	13	4	406	3	stammerer
stamper	11	37	1440	3	stamper_
stampers	12	42	1160	3	stampers
stealer	7	29	1397	3	stealer_
stealers	8	34	1220	3	stealers
steamed	10	37	1214	3	steame_d
steamered	12	4	491	3	steamered
steamier	10	4	830	3	steamier_
steamily	13	3	580	3	steamily
steamy	11	51	1237	3	steam__y
steely	9	36	1257	3	ste__ely
steeper	9	38	1277	3	steeper_
steepers	10	30	1137	3	steepers
steer	5	54	2386	3	ste__er_
steerer	7	31	1363	3	steerer_
steerers	8	25	1135	3	steerers
steers	6	38	2098	3	ste__ers
stemless	10	3	665	3	stemless
stemma	10	32	813	3	stemm__a
stemmas	11	25	697	3	stemm_as
stemmata	12	4	421	3	stemmata
stemmeries	14	4	517	3	stemmeries
stemmiest	13	3	514	3	stemmiest
stemming	13	40	820	3	stemming
stemware	13	4	488	3	stemware
stepper	11	30	1085	3	stepper_
steppers	12	28	928	3	steppers
sterner	7	4	1191	3	sterner_
stomper	11	41	1123	3	stomper_
stompers	12	36	1004	3	stompers
streamer	10	23	951	3	streamer_
streamers	11	22	807	3	streamers
strummer	12	3	478	3	strummer_
strummers	13	3	369	3	strummers
stummed	12	34	855	3	stumme_d
stumper	11	36	1009	3	stumper_
stumpers	12	31	831	3	stumpers
summary	14	29	735	3	s_ummary
summer	10	40	1771	3	s_ummer_
summerly	15	27	510	3	s_ummerly
summers	11	36	1650	3	s_ummers
swimmer	14	29	765	3	swimmer_
swimmers	15	27	669	3	swimmers
symmetry	18	4	355	3	s_ymmetry
teemer	8	55	1574	3	_teemer_
teemers	9	50	1290	3	_teemers
temper	10	39	1409	3	_temper_
tempera	11	32	904	3	_tempera
tempers	11	35	1301	3	_tempers
termer	8	57	1725	3	_termer_
termers	9	54	1450	3	_termers
timbery	14	25	689	3	_timbery

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.423	422437.4
2	DLD Change Limit	146162	108	7.326	19951.1
3	Display Results	108	108	0.046	2347.8
	(SQL Overall)	178691	108	7.795	22923.8