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

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

82 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
champer	16	38	1341	(None)
camper	12	47	2221	1	c_amper
chamber	16	40	1106	1	chamber
chamfer	17	39	986	1	chamfer
champed	17	41	1148	1	champed
champers	17	33	1162	1	champers
chomper	16	38	1007	1	chomper
clamper	13	40	1299	1	clamper
hamper	13	45	1865	1	_hamper
camber	12	44	1848	2	c_amber
camped	13	47	2023	2	c_amped
campers	13	42	2029	2	c_ampers
campier	13	33	1327	2	c_ampier
caper	9	48	3162	2	c_a_per
capper	12	44	2198	2	c_apper
carper	10	49	2363	2	c_arper
chafer	14	47	1457	2	cha_fer
chaffer	18	38	947	2	chaffer
chambers	17	34	1062	2	chambers
chamfers	18	40	922	2	chamfers
champ	14	50	1796	2	champ__
champac	18	3	495	2	champac
champak	20	3	449	2	champak
champerty	21	4	288	2	champerty
champs	15	49	1568	2	champ_s
champy	18	50	961	2	champ_y
chancer	14	42	1563	2	chancer
changer	13	42	1554	2	changer
chanter	12	39	1973	2	chanter
chape	12	52	2114	2	cha_pe_
chapel	13	49	1137	2	cha_pel
chapes	13	54	2187	2	cha_pes
chapmen	16	3	728	2	chapmen
chapped	17	27	1144	2	chapped
chapter	14	42	1385	2	chapter
charger	13	39	1406	2	charger
charier	12	43	1790	2	charier
charmer	14	49	1366	2	charmer
charter	12	39	1830	2	charter
chaser	11	49	1838	2	cha_ser
chaster	12	47	1850	2	chaster
chatter	12	44	1664	2	chatter
chaufer	15	34	794	2	chaufer
chawer	14	43	1441	2	cha_wer
cheaper	14	40	1058	2	cheaper
cheeper	14	36	1074	2	cheeper
chimer	13	55	1720	2	chim_er
chipper	16	39	1258	2	chipper
chirper	14	35	996	2	chirper
chomped	17	32	977	2	chomped
chompers	17	36	959	2	chompers
chopper	16	36	1189	2	chopper
chumped	17	37	949	2	chumped
clamber	13	33	1174	2	clamber
clammer	13	42	1179	2	clammer
clamped	14	40	1204	2	clamped
clampers	14	32	1189	2	clampers
clapper	13	40	1186	2	clapper
clasper	11	38	1186	2	clasper
crammer	13	40	1096	2	crammer
cramped	14	47	1218	2	cramped
crampier	14	28	890	2	crampier
crapper	13	39	1319	2	crapper
crimper	13	65	1042	2	crimper
damper	11	41	1775	2	_damper
hammer	13	81	2003	2	_hammer
hampers	14	36	1695	2	_hampers
harper	11	50	1840	2	_harper
humper	13	41	1588	2	_humper
pamper	12	43	1666	2	_pamper
scamper	13	46	1316	2	scamper
shammer	14	46	1314	2	shammer
shaper	11	41	1993	2	sha_per
sharper	12	43	1270	2	sharper
stamper	11	37	1440	2	stamper
swamper	14	34	931	2	swamper
tamper	10	46	1851	2	_tamper
thumper	14	35	695	2	thumper
tramper	11	38	1216	2	tramper
vamper	13	42	1265	2	_vamper
whapper	17	34	827	2	whapper
whimper	17	29	772	2	whimper

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.750	238254.7
2	DLD Change Limit	107671	82	6.656	16176.5
3	Display Results	82	82	0.063	1301.6
	(SQL Overall)	178691	82	7.469	23924.4