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

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

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.

79 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
compeller	15	4	629	(None)
compelled	16	4	613	1	compelled
compellers	16	4	519	1	compellers
comelier	12	3	1065	2	com_elier
compeer	13	38	1155	2	compe__er
compiler	14	3	837	2	comp_iler
completer	15	33	1041	2	completer
complexer	22	31	621	2	complexer
complier	14	3	1025	2	comp_lier
cupeller	12	5	610	2	c_upeller
gospeller	12	6	375	2	gospeller
impeller	12	3	608	2	_impeller
cameleer	12	4	603	3	cam_eleer
canceller	13	6	668	3	canceller
chiseller	14	4	397	3	chiseller
comember	16	4	416	3	com_ember
comether	15	3	725	3	com_ether
commencer	17	14	780	3	commencer
commender	16	16	792	3	commender
commenter	15	14	1069	3	commenter
compacter	17	25	788	3	compacter
comparer	14	36	1136	3	comp_arer
compeered	16	4	630	3	compeered
compeers	14	34	1001	3	compe__ers
compel	12	44	1289	3	compe_l__
compelling	17	4	655	3	compelling
compels	13	32	1089	3	compe_l_s
compere	13	46	1662	3	compe_re_
compered	15	34	1492	3	compe_red
comperes	14	32	1797	3	compe_res
compete	13	47	1655	3	compe_te_
competed	15	41	1359	3	compe_ted
competes	14	41	1724	3	compe_tes
compile	13	3	1244	3	comp_ile_
compiled	15	3	781	3	comp_iled
compilers	15	3	705	3	comp_ilers
compiles	14	3	1198	3	comp_iles
complete	14	34	1205	3	complete_
completed	16	28	1027	3	completed
completers	16	29	832	3	completers
completes	15	32	1292	3	completes
complex	20	3	724	3	comp__lex
complexed	23	29	598	3	complexed
complexes	22	30	811	3	complexes
complied	15	3	968	3	comp_lied
compliers	15	3	829	3	comp_liers
complies	14	3	1452	3	comp_lies
composer	14	50	1295	3	comp_oser
composter	15	36	957	3	composter
comptroller	17	5	173	3	comptroller
computer	14	45	1151	3	comp_uter
concealer	13	6	822	3	concealer
congealer	12	5	670	3	congealer
corbelled	14	4	661	3	corbelled
cordelle	11	4	843	3	cordelle_
cordelled	13	4	640	3	cordelled
cordelles	12	4	823	3	cordelles
coupler	11	47	1301	3	coup__ler
crueller	10	5	645	3	c_rueller
cupeler	11	7	748	3	c_upe_ler
cupelled	13	6	574	3	c_upelled
cupellers	13	7	486	3	c_upellers
dispeller	12	14	698	3	dispeller
expeller	17	10	579	3	_expeller
gospeler	11	7	396	3	gospe_ler
gospellers	13	6	302	3	gospellers
homelier	13	3	898	3	hom_elier
hosteller	12	4	586	3	hosteller
impelled	13	3	607	3	_impelled
impellers	13	4	510	3	_impellers
impellor	12	4	274	3	_impellor
modeller	11	3	661	3	mo_deller
pommelled	16	4	308	3	pommelled
propeller	13	4	662	3	propeller
repeller	10	30	1040	3	_repeller
smeller	9	42	1279	3	_sm_eller
sommelier	13	4	364	3	sommelier
speller	9	54	1515	3	__speller
yodeller	12	4	485	3	yo_deller

Search took 7 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	148641	0.406	440125.6
2	DLD Change Limit	148641	79	6.250	23782.6
3	Display Results	79	79	0.033	2393.9
	(SQL Overall)	178691	79	6.689	26714.2