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

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

87 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
spanker	13	36	1235	(None)
skanker	10	26	848	1	skanker
spanked	14	31	1173	1	spanked
spankers	14	36	986	1	spankers
spanner	9	43	1256	1	spanner
sparker	13	39	1436	1	sparker
swanker	14	36	948	1	swanker
banker	12	42	2273	2	_banker
blanker	13	46	1202	2	blanker
canker	12	44	2252	2	_canker
cranker	13	36	1279	2	cranker
danker	11	43	1966	2	_danker
flanker	14	39	1129	2	flanker
franker	14	35	1018	2	franker
hanker	13	46	2209	2	_hanker
lanker	10	41	2300	2	_lanker
packer	14	42	2340	2	_packer
pander	9	37	2552	2	_pander
panier	8	44	2550	2	_panier
panner	8	42	2476	2	_panner
panzer	17	42	1323	2	_panzer
parker	12	41	2137	2	_parker
pinker	12	53	2244	2	_pinker
punker	12	37	1882	2	_punker
ranker	10	50	2190	2	_ranker
sacker	12	51	2484	2	s_acker
saker	9	51	3202	2	s_a_ker
sander	7	48	2853	2	s_ander
saner	5	43	3432	2	s_an_er
sanger	7	45	2457	2	s_anger
scanner	9	44	1181	2	scanner
scanter	9	42	1518	2	scanter
shaker	13	43	1946	2	sha_ker
shanked	15	32	1212	2	shanked
sharker	14	43	1381	2	sharker
sinker	10	36	2090	2	s_inker
skanked	11	33	810	2	skanked
skankers	11	31	648	2	skankers
skankier	11	18	488	2	skankier
skinker	10	31	944	2	skinker
slacker	13	39	1529	2	slacker
slaker	10	42	1927	2	sla_ker
slander	8	40	1544	2	slander
smacker	15	34	1058	2	smacker
snacker	13	31	1260	2	snacker
soaker	10	57	1753	2	soa_ker
spacer	10	49	1779	2	spa_cer
spacier	11	40	1163	2	spacier
spader	9	43	1713	2	spa_der
spake	11	43	2274	2	spa_ke_
spaller	9	27	1347	2	spaller
spammer	13	34	1043	2	spammer
spancel	11	4	736	2	spancel
spandex	17	3	583	2	spandex
spaniel	9	4	892	2	spaniel
spank	11	59	1957	2	spank__
spanks	12	45	1412	2	spank_s
spanned	10	41	1122	2	spanned
spanners	10	37	1077	2	spanners
sparer	8	45	2496	2	spa_rer
sparger	10	36	1308	2	sparger
sparked	14	35	1314	2	sparked
sparkers	14	41	1131	2	sparkers
sparkier	14	29	803	2	sparkier
sparkler	14	31	798	2	sparkler
sparser	9	43	1148	2	sparser
spatter	9	40	1652	2	spatter
spawner	12	34	736	2	spawner
speaker	13	33	1121	2	speaker
spencer	11	36	1097	2	spencer
spender	10	37	1369	2	spender
spiker	12	43	1566	2	sp_iker
spinier	9	37	1516	2	spinier
spinner	9	39	1226	2	spinner
sponger	10	3	852	2	sponger
spunked	14	30	778	2	spunked
spunkier	14	23	582	2	spunkier
stacker	13	44	1626	2	stacker
stalker	11	39	1225	2	stalker
stander	8	43	1616	2	stander
starker	11	41	1469	2	starker
stinker	11	33	1331	2	stinker
swanked	15	35	954	2	swanked
swankier	15	22	550	2	swankier
tanker	10	45	2113	2	_tanker
thanker	14	30	959	2	thanker
wanker	13	42	1997	2	_wanker

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.390	458182.1
2	DLD Change Limit	107671	87	3.050	35302.0
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	3.470	51496.0