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

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

89 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
yammer	13	37	1318	(None)
dammer	11	43	1793	1	dammer
gammer	11	123	1833	1	gammer
hammer	13	81	2003	1	hammer
jammer	17	40	1413	1	jammer
mammer	9	42	1886	1	mammer
rammer	10	35	1965	1	rammer
yammers	14	34	1032	1	yammers
aimer	7	59	2682	2	_aimer
amber	9	45	2321	2	_amber
ameer	7	56	1898	2	_ameer
armer	7	69	2444	2	_armer
bammed	13	39	1324	2	bammed
bummer	12	40	1410	2	bummer
calmer	10	52	1693	2	calmer
camber	12	44	1848	2	camber
camper	12	47	2221	2	camper
clammer	13	42	1179	2	clammer
crammer	13	40	1096	2	crammer
cummer	12	44	1459	2	cummer
dammar	11	43	890	2	dammar
dammed	12	42	1479	2	dammed
dammers	12	32	1427	2	dammers
damner	9	52	1343	2	damner
damper	11	41	1775	2	damper
dimmer	11	41	1261	2	dimmer
emmer	9	43	1446	2	_emmer
farmer	11	50	1737	2	farmer
gamer	8	49	2894	2	ga_mer
gamier	9	36	1793	2	gamier
gammed	12	42	1616	2	gammed
gammers	12	32	1456	2	gammers
gammier	12	37	1119	2	gammier
gummer	11	46	1545	2	gummer
hammed	14	41	1697	2	hammed
hammers	14	42	1606	2	hammers
hammier	14	35	1065	2	hammier
hamper	13	45	1865	2	hamper
harmer	11	47	1955	2	harmer
hemmer	13	41	1264	2	hemmer
hummer	13	36	1527	2	hummer
jammed	18	38	1150	2	jammed
jammers	18	37	1070	2	jammers
jammier	18	40	802	2	jammier
lamber	10	44	1849	2	lamber
lamer	7	52	3370	2	la_mer
lammed	11	39	1562	2	lammed
limmer	10	43	1479	2	limmer
maimer	10	45	1459	2	maimer
mammee	9	44	1785	2	mammee
mammers	10	46	1569	2	mammers
mammet	9	43	1925	2	mammet
mammey	12	43	1089	2	mammey
mamzer	19	45	983	2	mamzer
mummer	9	36	1454	2	mummer
namer	7	56	2210	2	na_mer
palmer	10	58	1654	2	palmer
pamper	12	43	1666	2	pamper
rammed	11	31	1730	2	rammed
rammers	11	37	1504	2	rammers
rammier	11	28	1102	2	rammier
rimmer	10	35	1603	2	rimmer
rummer	10	47	1548	2	rummer
scammer	13	36	1197	2	scammer
shammer	14	46	1314	2	shammer
simmer	10	41	1535	2	simmer
slammer	11	39	1303	2	slammer
spammer	13	34	1043	2	spammer
stammer	11	60	1334	2	stammer
summer	10	40	1771	2	summer
tamer	7	52	3010	2	ta_mer
tamper	10	46	1851	2	tamper
vamper	13	42	1265	2	vamper
warmer	11	38	1673	2	warmer
yabber	13	61	1183	2	yabber
yager	9	56	1675	2	ya_ger
yakker	12	40	553	2	yakker
yamen	10	41	1518	2	ya_men
yammered	16	22	576	2	yammered
yammerer	15	22	548	2	yammerer
yapper	13	37	1451	2	yapper
yarder	10	38	1397	2	yarder
yarer	8	43	2157	2	ya_rer
yarner	9	33	1306	2	yarner
yatter	9	41	1621	2	yatter
yauper	11	36	854	2	yauper
yawner	12	42	847	2	yawner
yawper	14	43	795	2	yawper
yummier	14	30	684	2	yummier

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	82551	0.346	516448.0
2	DLD Change Limit	82551	89	2.716	30394.3
3	Display Results	89	89	0.033	2697.0
	(SQL Overall)	178691	89	3.095	57735.4