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

Here are the results of your fuzzy-string dictionary search for “challenging” with Change Limit: [1] [2] [3] [4] [5]

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.

77 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
challenging	18	5	256	(None)
challengingly	23	6	92	2	challengingly
rechallenging	20	7	127	2	rechallenging
unchallenging	20	8	112	2	unchallenging
alleging	10	3	847	3	__alle_ging
challenge	15	4	362	3	challeng__e
challenged	17	4	252	3	challeng_ed
challenger	16	5	269	3	challeng_er
challengers	17	5	250	3	challengers
challenges	16	4	399	3	challeng_es
changing	15	32	1151	3	cha___nging
chastening	16	5	652	3	chasten_ing
aliening	9	15	1089	4	__alien_ing
allergin	9	13	630	4	__allergin_
allergins	10	14	638	4	__allergins
avenging	13	4	586	4	__a_venging
cadencing	15	4	496	4	c_a_dencing
calcining	14	4	781	4	c_alcin_ing
calling	10	38	2677	4	c_all___ing
callousing	13	4	427	4	c_allousing
callusing	12	3	617	4	c_all_using
careening	12	3	1001	4	c_areen_ing
chaffering	22	10	464	4	chaffe_ring
chagrining	17	4	344	4	chagrin_ing
chagrinning	18	5	159	4	chagrinning
chaining	14	28	1078	4	cha__in_ing
chalking	18	33	1006	4	cha_l__king
chambering	20	11	604	4	chambe_ring
chamfering	21	12	533	4	chamfe_ring
chancing	16	28	1028	4	cha___ncing
chandelling	18	4	445	4	chandelling
changeling	17	4	567	4	change_ling
channeling	16	4	520	4	channe_ling
channelling	17	4	399	4	channelling
chanting	14	34	1353	4	cha___nting
chaptering	18	10	796	4	chapte_ring
charging	15	29	1077	4	cha___rging
chartering	16	10	925	4	charte_ring
chasseing	15	5	496	4	chasse__ing
chattering	16	10	864	4	chatte_ring
chaunting	15	5	541	4	cha__unting
cheapening	18	8	380	4	cheapen_ing
chickening	22	4	413	4	chicken_ing
chilling	14	35	1218	4	chill___ing
clanging	12	40	1212	4	c___langing
clinging	12	29	1091	4	c___linging
coalescing	15	4	516	4	coa_lescing
coarsening	13	4	554	4	coarsen_ing
coattending	15	4	354	4	coattending
collaging	13	3	793	4	c_oll_aging
collecting	15	4	828	4	c_ollecting
colleting	12	3	1106	4	c_olle_ting
cravening	15	4	755	4	cra_ven_ing
gallanting	12	4	535	4	_gallanting
gallerying	15	4	303	4	_gallerying
galleting	11	3	763	4	_galle_ting
goaltending	14	5	199	4	goaltending
halloaing	13	8	703	4	_hall_oaing
halloing	12	15	1007	4	_hall__oing
hallooing	13	6	634	4	_hall_ooing
hallowing	16	7	694	4	_hall_owing
haltering	13	22	1201	4	_halte_ring
hanging	12	35	1870	4	_ha___nging
happening	17	3	559	4	_happen_ing
hardening	14	3	802	4	_harden_ing
harkening	17	4	692	4	_harken_ing
hastening	13	25	948	4	_hasten_ing
havening	15	25	855	4	_ha_ven_ing
hellenizing	24	5	407	4	_hellenizing
hollering	13	3	774	4	_holle_ring
palleting	12	3	874	4	_palle_ting
pollening	12	3	692	4	_pollen_ing
scavenging	17	4	207	4	sca_venging
shallowing	17	4	411	4	shall_owing
sharpening	16	4	488	4	sharpen_ing
tallaging	11	4	650	4	_tall_aging
whanging	16	26	714	4	wha___nging

Search took 9 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	148819	0.406	440125.6
2	DLD Change Limit	148819	77	8.483	17543.2
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	8.922	20028.1