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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

181 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
inker	9	44	2109	(None)
icker	11	40	1844	1	icker
infer	8	42	1503	1	infer
inked	10	42	1852	1	inked
inkers	10	40	1883	1	inkers
inkier	10	40	1378	1	inkier
inner	5	49	2063	1	inner
inter	5	50	2849	1	inter
jinker	17	40	1354	1	jinker
linker	10	43	2147	1	linker
pinker	12	53	2244	1	pinker
sinker	10	36	2090	1	sinker
tinker	10	36	1992	1	tinker
winker	13	42	2029	1	winker
anger	6	62	2588	2	anger
asker	9	64	1878	2	asker
baker	11	56	2954	2	baker
banker	12	42	2273	2	banker
bicker	14	48	1917	2	bicker
biker	11	60	2256	2	biker
bilker	12	49	1344	2	bilker
binder	9	44	2287	2	binder
biner	7	59	3069	2	bin_er
binger	9	49	2345	2	binger
blinker	13	41	1021	2	blinker
bunker	12	45	1937	2	bunker
canker	12	44	2252	2	canker
cinder	9	41	1912	2	cinder
clinker	13	38	1166	2	clinker
conker	12	47	2155	2	conker
danker	11	43	1966	2	danker
dicker	13	45	2140	2	dicker
diker	10	55	2455	2	diker
diner	6	56	3290	2	din_er
dinger	8	53	2367	2	dinger
dinked	12	48	1835	2	dinked
dinkey	14	48	1276	2	dinkey
dinkier	12	34	1150	2	dinkier
dinner	7	42	1716	2	dinner
drinker	12	34	948	2	drinker
dunker	11	36	1646	2	dunker
ender	6	43	2586	2	ender
enter	5	47	2638	2	enter
esker	9	44	1298	2	esker
faker	12	48	2459	2	faker
finder	10	40	2023	2	finder
finer	8	54	3156	2	fin_er
finger	10	49	2033	2	finger
finked	14	42	1462	2	finked
funker	13	39	1576	2	funker
ginger	8	49	2003	2	ginger
ginner	7	39	1582	2	ginner
hanker	13	46	2209	2	hanker
hiker	12	51	1939	2	hiker
hinder	10	41	2006	2	hinder
hinger	10	47	2333	2	hinger
hinkier	14	36	1079	2	hinkier
hinter	9	40	2130	2	hinter
honker	13	41	1746	2	honker
hunker	13	39	1767	2	hunker
icier	7	43	1375	2	icier
ickers	12	39	1418	2	ickers
ickier	12	43	992	2	ickier
idler	6	50	1566	2	idler
iller	5	48	2129	2	iller
inaner	6	22	1354	2	inaner
incher	11	41	1403	2	incher
incur	7	22	1225	2	incur
index	13	3	1098	2	index
inert	5	32	3437	2	in_ert
infers	9	36	1544	2	infers
inhere	9	3	1371	2	inhere
ink	7	64	3364	2	ink__
inkjet	17	3	745	2	inkjet
inkle	9	45	1583	2	inkle
inkles	10	35	1565	2	inkles
inks	8	69	2650	2	ink_s
inky	11	53	2158	2	ink_y
inlet	5	37	3240	2	inlet
inlier	6	36	1536	2	inlier
inned	6	41	1842	2	inned
inners	6	39	1935	2	inners
insert	6	43	2525	2	insert
inset	5	44	3086	2	inset
intern	6	40	1654	2	intern
inters	6	43	2805	2	inters
inure	5	41	1905	2	inure
invar	8	3	951	2	invar
invert	9	41	2008	2	invert
invoker	14	3	536	2	invoker
irked	10	45	1092	2	irked
ither	8	46	1760	2	ither
jinked	18	40	1314	2	jinked
jinkers	18	35	1181	2	jinkers
joker	16	57	1589	2	joker
junker	17	42	1365	2	junker
kicker	11	41	1618	2	kicker
kinder	11	37	1685	2	kinder
kinked	10	40	1475	2	kinked
kinkier	10	31	943	2	kinkier
laker	9	54	3287	2	laker
lanker	10	41	2300	2	lanker
licker	12	52	2204	2	licker
liker	9	56	2706	2	liker
liner	5	59	3892	2	lin_er
linger	7	52	2600	2	linger
linier	6	44	2379	2	linier
linked	11	45	1821	2	linked
linkers	11	43	1771	2	linkers
linter	6	46	2534	2	linter
lunker	10	47	1834	2	lunker
maker	11	41	2781	2	maker
milker	12	48	1432	2	milker
mincer	10	40	1736	2	mincer
minder	9	48	2250	2	minder
miner	7	69	3354	2	min_er
minke	11	54	2176	2	minke_
minkes	12	46	1878	2	minkes
minter	8	44	2510	2	minter
mirker	12	37	1269	2	mirker
nicer	7	46	1829	2	nicer
nicker	12	38	1870	2	nicker
niter	5	50	2897	2	niter
ocker	11	39	1575	2	ocker
oinked	11	42	1328	2	oinked
picker	14	44	2217	2	picker
piker	11	56	2284	2	piker
pincer	10	40	1917	2	pincer
pinder	9	45	2345	2	pinder
pinger	9	43	2409	2	pinger
pinier	8	40	2469	2	pinier
pinked	13	48	1988	2	pinked
pinken	12	45	1328	2	pinken
pinkers	13	41	1860	2	pinkers
pinkey	15	43	1467	2	pinkey
pinner	8	45	2150	2	pinner
plinker	13	40	1096	2	plinker
poker	11	51	2288	2	poker
prinker	13	34	1274	2	prinker
punker	12	37	1882	2	punker
raker	9	45	2979	2	raker
ranker	10	50	2190	2	ranker
ringer	7	45	2606	2	ringer
rinser	6	43	1721	2	rinser
risker	10	54	1449	2	risker
saker	9	51	3202	2	saker
sicker	12	40	2390	2	sicker
siker	9	53	2603	2	siker
singer	7	42	2731	2	singer
sinkers	11	36	1854	2	sinkers
sinner	6	43	2060	2	sinner
sinter	6	36	2592	2	sinter
skinker	10	31	944	2	skinker
sneer	5	49	1995	2	sneer
stinker	11	33	1331	2	stinker
taker	9	52	2900	2	taker
tanker	10	45	2113	2	tanker
thinker	14	36	1068	2	thinker
ticker	12	43	2150	2	ticker
tinder	7	38	2180	2	tinder
tinier	6	36	2223	2	tinier
tinkers	11	35	1714	2	tinkers
tinkler	11	36	1054	2	tinkler
tinner	6	41	1996	2	tinner
tinter	6	39	2364	2	tinter
toker	9	59	2491	2	toker
under	6	46	2421	2	under
vinier	9	37	1674	2	vinier
waker	12	55	2660	2	waker
wanker	13	42	1997	2	wanker
wicker	15	45	1867	2	wicker
wincer	11	50	1819	2	wincer
winder	10	40	2526	2	winder
winger	10	41	2544	2	winger
winier	9	45	2245	2	winier
winked	14	40	1860	2	winked
winkers	14	35	1711	2	winkers
winner	9	42	1993	2	winner
winter	9	42	2280	2	winter
yonker	13	41	1085	2	yonker
zinger	16	38	1670	2	zinger

Search took 3 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	53800	0.766	233278.1
2	DLD Change Limit	53800	181	1.670	32215.6
3	Display Results	181	181	0.046	3934.8
	(SQL Overall)	178691	181	2.482	71994.8