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

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

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
slicking	15	37	1259	(None)
clicking	17	36	1098	1	clicking
flicking	18	41	1004	1	flicking
licking	14	41	1828	1	_licking
sicking	14	37	2017	1	s_icking
slacking	15	39	1413	1	slacking
slicing	10	35	1464	1	slic_ing
slinking	13	34	1298	1	slinking
snicking	15	36	1023	1	snicking
sticking	15	35	1346	1	sticking
blacking	17	42	1360	2	blacking
blinking	15	35	1062	2	blinking
blocking	17	45	1057	2	blocking
bricking	17	39	1140	2	bricking
clacking	17	33	1349	2	clacking
clinking	15	36	1166	2	clinking
clocking	17	43	1241	2	clocking
clucking	17	42	999	2	clucking
cricking	17	34	1265	2	cricking
dicking	15	36	1761	2	_dicking
flacking	18	43	1179	2	flacking
flecking	18	40	823	2	flecking
flocking	18	34	1087	2	flocking
hoicking	18	3	605	2	hoicking
kicking	13	33	1402	2	_kicking
lacking	14	38	2154	2	_lacking
lickings	15	29	814	2	_lickings
liking	11	43	1958	2	_li_king
linking	12	38	1825	2	_linking
locking	14	37	1815	2	_locking
lucking	14	36	1583	2	_lucking
nicking	14	35	1632	2	_nicking
picking	16	34	1833	2	_picking
plinking	15	36	1124	2	plinking
plucking	17	35	772	2	plucking
pricking	17	32	1260	2	pricking
ricking	14	39	2023	2	_ricking
sacking	14	41	2270	2	s_acking
shacking	18	40	1408	2	shacking
shirking	16	32	1047	2	shirking
shocking	18	43	1154	2	shocking
shucking	18	33	943	2	shucking
siccing	12	31	951	2	s_iccing
sickling	15	29	1033	2	s_ickling
silking	12	37	1559	2	s_ilking
sinking	12	33	2054	2	s_inking
skinking	12	29	977	2	skinking
slaking	12	37	1747	2	sl_aking
sleeking	13	34	1096	2	sleeking
slicken	13	30	929	2	slicken_
slickening	17	4	390	2	slickening
slickens	14	31	726	2	slickens
sliding	9	31	1455	2	sli_ding
sliming	10	29	1395	2	sli_ming
slimming	13	28	809	2	slimming
slinging	10	33	1286	2	slinging
sliping	10	33	1441	2	sli_ping
slipping	13	35	1066	2	slipping
slitting	9	30	1258	2	slitting
sluicing	11	3	706	2	sluic_ing
smacking	17	35	1076	2	smacking
smirking	15	27	723	2	smirking
smocking	17	34	910	2	smocking
snacking	15	34	1170	2	snacking
socking	14	35	1860	2	s_ocking
specking	17	35	973	2	specking
spicing	12	39	1453	2	spic_ing
spiking	14	43	1288	2	spi_king
splicing	13	3	896	2	splic_ing
stacking	15	42	1508	2	stacking
stickling	16	4	700	2	stickling
stinking	13	31	1354	2	stinking
stocking	15	29	1250	2	stocking
sucking	14	32	1741	2	s_ucking
swinking	16	34	1032	2	swinking
ticking	14	32	1875	2	_ticking
tricking	15	27	1451	2	tricking
wicking	17	34	1477	2	_wicking
wricking	18	34	949	2	wricking

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	121059	0.373	479064.3
2	DLD Change Limit	121059	79	3.440	35191.6
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	3.843	46497.8