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

Here are the results of your fuzzy-string dictionary search for “swamper” 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
swamper	14	34	931	(None)
scamper	13	46	1316	1	scamper
stamper	11	37	1440	1	stamper
swamped	15	49	844	1	swamped
swampers	15	31	747	1	swampers
swampier	15	4	459	1	swampier
swapper	14	35	970	1	swapper
camper	12	47	2221	2	_camper
champer	16	38	1341	2	champer
clamper	13	40	1299	2	clamper
damper	11	41	1775	2	_damper
hamper	13	45	1865	2	_hamper
pamper	12	43	1666	2	_pamper
sampler	11	32	1201	2	s_ampler
sapper	10	38	2235	2	s_apper
scalper	11	39	1292	2	scalper
scammer	13	36	1197	2	scammer
scamped	14	47	1196	2	scamped
scampers	14	36	1103	2	scampers
scarper	11	48	1482	2	scarper
scauper	11	37	945	2	scauper
seamer	8	42	2361	2	seam_er
seamier	9	31	1463	2	seamier
shammer	14	46	1314	2	shammer
shaper	11	41	1993	2	sha_per
sharper	12	43	1270	2	sharper
simper	10	36	1629	2	s_imper
slammer	11	39	1303	2	slammer
slapper	11	35	1247	2	slapper
snapper	11	35	1207	2	snapper
soaper	8	45	1787	2	soa_per
spammer	13	34	1043	2	spammer
stammer	11	60	1334	2	stammer
stamped	12	48	1281	2	stamped
stampers	12	42	1160	2	stampers
stomper	11	41	1123	2	stomper
stumper	11	36	1009	2	stumper
swabber	14	29	796	2	swabber
swager	10	40	1361	2	swa_ger
swagger	12	38	933	2	swagger
swamies	12	37	1206	2	swamies
swamp	12	50	1532	2	swamp__
swamps	13	59	1026	2	swamp_s
swampy	16	43	723	2	swamp_y
swanker	14	36	948	2	swanker
swapped	15	42	914	2	swapped
swappers	15	35	808	2	swappers
swarmer	12	4	780	2	swarmer
swasher	13	40	1151	2	swasher
swather	13	42	1360	2	swather
swatter	10	41	1332	2	swatter
swayer	12	52	1097	2	swa_yer
sweeper	12	32	937	2	sweeper
swimmer	14	29	765	2	swimmer
swooper	12	38	917	2	swooper
tamper	10	46	1851	2	_tamper
tramper	11	38	1216	2	tramper
vamper	13	42	1265	2	_vamper
warper	11	40	1558	2	_warper

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	107671	0.843	211970.3
2	DLD Change Limit	107671	59	7.050	15272.5
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	7.923	22553.5