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

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

71 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
candlers	11	42	1410	(None)
candler	10	35	1659	1	candler_
candles	10	44	2234	1	candle_s
chandlers	15	38	767	1	chandlers
dandlers	10	39	1205	1	dandlers
handlers	12	40	1414	1	handlers
landlers	9	43	1283	1	landlers
anglers	8	40	1482	2	_anglers
antlers	7	40	1474	2	_antlers
banders	10	43	2456	2	band_ers
bundlers	11	39	918	2	bundlers
cablers	11	44	1671	2	ca_blers
cacklers	16	37	1070	2	cacklers
cadgers	11	47	1200	2	ca_dgers
cajolers	17	26	713	2	cajolers
callers	9	42	2196	2	ca_llers
canallers	11	3	721	2	canallers
cancelers	13	24	786	2	cancelers
cancers	11	40	1858	2	can_cers
candelas	11	3	953	2	candelas
candies	10	41	2561	2	candie_s
candle	9	43	2148	2	candle__
candled	11	38	1574	2	candle_d
candors	10	42	1676	2	cand_ors
candours	11	40	864	2	candours
caners	8	46	2920	2	can__ers
cankers	13	44	1875	2	can_kers
canners	9	38	2266	2	can_ners
canoers	9	43	1837	2	can_oers
canters	9	48	2773	2	can_ters
cantles	9	47	2141	2	cantle_s
carders	10	48	2035	2	card_ers
carolers	10	33	1417	2	carolers
caudles	10	39	1281	2	caudle_s
cavilers	13	4	811	2	cavilers
chandler	14	35	837	2	chandler_
chandlery	18	38	442	2	chandlery
cinders	10	46	1776	2	cind_ers
coddlers	12	35	917	2	coddlers
condolers	12	27	1057	2	condolers
cradlers	11	30	920	2	cradlers
cuddlers	12	38	838	2	cuddlers
curdlers	11	36	849	2	curdlers
danders	9	39	2118	2	dand_ers
dandler	9	44	1427	2	dandler_
dandles	9	42	1853	2	dandle_s
danglers	10	36	1059	2	danglers
dawdlers	13	37	567	2	dawdlers
fondlers	12	33	802	2	fondlers
ganders	9	35	2170	2	gand_ers
handers	11	42	2433	2	hand_ers
handler	11	35	1616	2	handler_
handles	11	40	2065	2	handle_s
handless	12	35	1206	2	handless
janglers	16	31	937	2	janglers
kindlers	13	31	848	2	kindlers
ladlers	8	46	1357	2	la_dlers
landers	8	40	2621	2	land_ers
landler	8	41	1320	2	landler_
landless	9	40	1117	2	landless
manglers	11	33	1190	2	manglers
paddlers	12	32	915	2	paddlers
panders	10	34	2373	2	pand_ers
saddlers	10	28	975	2	saddlers
sanders	8	40	2594	2	sand_ers
sandless	9	32	1234	2	sandless
tanglers	9	29	1197	2	tanglers
waddlers	13	29	833	2	waddlers
wanders	11	42	2133	2	wand_ers
wanglers	12	33	1003	2	wanglers
zanders	17	30	1579	2	zand_ers

Search took 5 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	121059	0.390	458182.1
2	DLD Change Limit	121059	71	3.686	32842.9
3	Display Results	71	71	0.033	2151.5
	(SQL Overall)	178691	71	4.109	43487.7