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

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

80 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
snicker	13	30	1267	(None)
nicker	12	38	1870	1	_nicker
shicker	16	39	1482	1	shicker
sicker	12	40	2390	1	s_icker
slicker	13	33	1453	1	slicker
snacker	13	31	1260	1	snacker
snicked	14	38	1163	1	snicked
snickers	14	30	1096	1	snickers
snickery	17	29	554	1	snickery
sticker	13	35	1588	1	sticker
bicker	14	48	1917	2	_bicker
clicker	15	41	1188	2	clicker
dicker	13	45	2140	2	_dicker
flicker	16	36	1062	2	flicker
icker	11	40	1844	2	__icker
kicker	11	41	1618	2	_kicker
knacker	12	30	791	2	knacker
knickers	13	30	672	2	knickers
knocker	12	29	639	2	knocker
licker	12	52	2204	2	_licker
monicker	16	3	573	2	monicker
necker	12	40	1279	2	_necker
nicer	7	46	1829	2	_nic_er
nicked	13	50	1968	2	_nicked
nickel	12	38	1134	2	_nickel
nickers	13	44	1509	2	_nickers
picker	14	44	2217	2	_picker
pricker	15	40	1341	2	pricker
quicker	22	4	702	2	quicker
sacker	12	51	2484	2	s_acker
shickers	17	30	1282	2	shickers
shikker	13	27	702	2	shikker
shirker	14	37	1134	2	shirker
shocker	16	34	1143	2	shocker
shucker	16	37	1010	2	shucker
sicked	13	45	2440	2	s_icked
sickee	12	46	2222	2	s_ickee
sicken	12	46	1525	2	s_icken
siker	9	53	2603	2	s_i_ker
sinker	10	36	2090	2	s_inker
skinker	10	31	944	2	skinker
slacker	13	39	1529	2	slacker
slicer	8	41	1760	2	slic_er
slicked	14	44	1384	2	slicked
slicken	13	30	929	2	slicken
slickers	14	31	1255	2	slickers
smacker	15	34	1058	2	smacker
smirker	13	32	742	2	smirker
snacked	14	40	1311	2	snacked
snackers	14	30	1022	2	snackers
sneaker	11	29	1045	2	sneaker
snick	11	44	1601	2	snick__
snickered	16	11	534	2	snickered
snickerer	15	13	456	2	snickerer
snicks	12	43	1247	2	snick_s
snider	7	44	1391	2	sni_der
sniffer	13	31	890	2	sniffer
snifter	10	34	962	2	snifter
snigger	9	32	837	2	snigger
sniper	8	44	1364	2	sni_per
snipper	11	39	1133	2	snipper
snitcher	13	15	737	2	snitcher
snooker	11	39	1030	2	snooker
spicer	10	47	1931	2	spic_er
spicier	11	51	1246	2	spicier
spiker	12	43	1566	2	spi_ker
stacker	13	44	1626	2	stacker
sticked	14	41	1463	2	sticked
stickers	14	29	1303	2	stickers
stickier	14	22	976	2	stickier
stickler	14	25	957	2	stickler
stinker	11	33	1331	2	stinker
stocker	13	37	1308	2	stocker
sucker	12	41	2066	2	s_ucker
thicker	16	36	1102	2	thicker
ticker	12	43	2150	2	_ticker
tricker	13	46	1552	2	tricker
unsicker	14	3	530	2	unsicker
whicker	19	35	977	2	whicker
wicker	15	45	1867	2	_wicker

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.123	1452772.4
2	DLD Change Limit	107671	80	3.266	32967.2
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	3.419	52264.1