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

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

90 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
jammer	17	40	1413	(None)
dammer	11	43	1793	1	dammer
gammer	11	123	1833	1	gammer
hammer	13	81	2003	1	hammer
jammed	18	38	1150	1	jammed
jammers	18	37	1070	1	jammers
jammier	18	40	802	1	jammier
mammer	9	42	1886	1	mammer
rammer	10	35	1965	1	rammer
yammer	13	37	1318	1	yammer
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
jabber	17	37	1364	2	jabber
jacker	19	44	1758	2	jacker
jaeger	14	39	719	2	jaeger
jager	13	43	1813	2	ja_ger
jagger	15	40	1600	2	jagger
jailer	13	43	1668	2	jailer
jambe	16	53	1475	2	jambe_
jambed	18	48	1140	2	jambed
jambes	17	59	1405	2	jambes
jammies	18	36	1129	2	jammies
jammy	19	48	1019	2	jamm_y
japer	14	62	1888	2	ja_per
jasper	15	46	1038	2	jasper
jazzer	21	37	650	2	jazzer
jimper	17	38	986	2	jimper
jumper	17	36	1237	2	jumper
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
yammers	14	34	1032	2	yammers

Search took 3 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.360	496363.9
2	DLD Change Limit	82551	90	2.140	38575.2
3	Display Results	90	90	0.033	2727.3
	(SQL Overall)	178691	90	2.533	70545.2