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

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

60 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
cheaper	14	40	1058	(None)
cheapen	14	40	762	1	cheapen
cheater	12	48	1696	1	cheater
cheeper	14	36	1074	1	cheeper
heaper	11	41	1952	1	_heaper
caper	9	48	3162	2	c__aper
chafer	14	47	1457	2	ch_afer
champer	16	38	1341	2	champer
chape	12	52	2114	2	ch_ape_
chapel	13	49	1137	2	ch_apel
chapes	13	54	2187	2	ch_apes
chapter	14	42	1385	2	ch_apter
chaser	11	49	1838	2	ch_aser
chawer	14	43	1441	2	ch_awer
cheap	12	69	1594	2	cheap__
cheapener	16	4	377	2	cheapener
cheapens	15	30	594	2	cheapens
cheapest	15	3	607	2	cheapest
cheapie	14	3	756	2	cheapie
cheapies	15	3	903	2	cheapies
cheaply	17	3	502	2	cheaply
cheapo	13	48	1008	2	cheap_o
cheapos	14	41	851	2	cheapos
cheaps	13	46	1368	2	cheap_s
cheated	13	44	1634	2	cheated
cheaters	13	36	1351	2	cheaters
checker	18	32	953	2	checker
cheder	12	51	1349	2	che_der
cheeped	15	34	1059	2	cheeped
cheepers	15	32	901	2	cheepers
cheer	10	54	2038	2	che__er
cheerer	12	35	1175	2	cheerer
chequer	21	3	515	2	chequer
chewer	14	55	1262	2	che_wer
chewier	15	3	759	2	chewier
chipper	16	39	1258	2	chipper
chirper	14	35	996	2	chirper
chomper	16	38	1007	2	chomper
chopper	16	36	1189	2	chopper
cleaner	9	37	1230	2	cleaner
clearer	9	37	1082	2	clearer
cleaver	12	41	1080	2	cleaver
creamer	11	37	1409	2	creamer
creaser	9	44	1574	2	creaser
creeper	11	33	998	2	creeper
header	10	44	2254	2	_header
healer	9	42	2180	2	_healer
heaped	12	45	1690	2	_heaped
heapers	12	36	1667	2	_heapers
hearer	9	43	2364	2	_hearer
heater	9	48	2830	2	_heater
heaver	12	48	1967	2	_heaver
helper	11	43	1309	2	_helper
hepper	13	34	1266	2	_hepper
leaper	8	81	1894	2	_leaper
reaper	8	42	2314	2	_reaper
shaper	11	41	1993	2	sh_aper
shearer	10	44	1468	2	shearer
theater	10	40	1425	2	theater
threaper	13	4	514	2	threaper

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	107671	0.373	479064.3
2	DLD Change Limit	107671	60	3.033	35499.8
3	Display Results	60	60	0.030	2000.0
	(SQL Overall)	178691	60	3.436	52005.5