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

Here are the results of your fuzzy-string dictionary search for “challengers” 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
challengers	17	5	250	(None)
challenger	16	5	269	1	challenger_
challenges	16	4	399	1	challenge_s
challenge	15	4	362	2	challenge__
challenged	17	4	252	2	challenge_d
allegers	9	37	823	3	__alle_gers
calenders	12	3	740	3	c_a_lenders
challenging	18	5	256	3	challenging
changers	14	43	1320	3	cha___ngers
chasteners	15	5	479	3	chasten_ers
collegers	12	25	684	3	c_olle_gers
cullenders	13	4	319	3	c_ullenders
phalangers	16	7	376	3	pha_langers
rechallenges	18	5	167	3	rechallenge_s
alieners	8	8	982	4	__alien_ers
alleger	8	31	963	4	__alle_ger_
alleges	8	42	1257	4	__alle_ge_s
allergens	10	14	517	4	__allergens
allonges	9	3	731	4	__allonge_s
avengers	12	3	558	4	__a_vengers
calendars	12	4	452	4	c_a_lendars
calender	11	3	827	4	c_a_lender_
callees	9	41	1778	4	c_alle__e_s
callers	9	42	2196	4	c_all___ers
callings	11	36	1383	4	c_alling__s
callipers	13	5	649	4	c_all_ipers
careeners	11	3	854	4	c_areen_ers
carpenters	14	4	584	4	c_arpenters
chafferers	21	15	317	4	chaffe_rers
chalcogens	18	5	299	4	cha_lcogens
challies	13	39	1564	4	chall__ie_s
challises	14	35	878	4	chall_ise_s
chalones	13	3	1217	4	cha_lon_e_s
chamferers	20	15	395	4	chamfe_rers
chancers	15	43	1349	4	cha___ncers
chandeliers	17	4	348	4	chandeliers
changeovers	20	5	184	4	changeovers
changer	13	42	1554	4	cha___nger_
changes	13	45	1758	4	cha___nge_s
channelers	15	4	385	4	channe_lers
chanters	13	40	1674	4	cha___nters
chargers	14	40	1132	4	cha___rgers
charminger	18	4	308	4	charminger_
charterers	15	14	605	4	charte_rers
chastener	14	4	570	4	chasten_er_
chasteness	15	4	652	4	chasten_ess
chatterers	15	20	546	4	chatte_rers
chaunters	14	5	582	4	cha__unters
cheapeners	17	4	311	4	cheapen_ers
chillers	13	37	1092	4	chill___ers
chilliness	15	5	531	4	chillin_ess
chillness	14	5	537	4	chill_n_ess
clangers	11	43	1234	4	c___langers
clingers	11	38	1066	4	c___lingers
colleger	11	22	793	4	c_olle_ger_
colleges	11	24	1052	4	c_olle_ge_s
cullender	12	4	355	4	c_ullender_
goaltenders	13	5	180	4	goaltenders
haleness	11	3	1262	4	_ha_len_ess
hallowers	15	13	772	4	_hall_owers
hangers	11	31	2081	4	_ha___ngers
harbingers	16	4	394	4	_harbingers
hardeners	13	3	808	4	_harden_ers
harkeners	16	3	607	4	_harken_ers
hasteners	12	26	781	4	_hasten_ers
hellbenders	17	5	178	4	_hellbenders
malingers	12	8	585	4	_ma_lingers
passengers	13	4	321	4	_passengers
phalanger	15	5	411	4	pha_langer_
phalanges	15	6	536	4	pha_lange_s
rechallenge	17	5	180	4	rechallenge__
rechallenged	19	7	133	4	rechallenge_d
scavengers	16	4	208	4	sca_vengers
sharpeners	15	4	389	4	sharpen_ers
tailenders	11	4	364	4	_tailenders
unchallenged	19	5	169	4	unchallenge_d
wharfingers	21	5	141	4	wharfingers

Search took 10 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.423	422437.4
2	DLD Change Limit	148819	77	8.653	17198.5
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	9.109	19617.0