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

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

82 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
dinkier	12	34	1150	(None)
dickier	14	35	1245	1	dickier
dingier	9	35	1367	1	dingier
dinkies	12	37	1603	1	dinkies
hinkier	14	36	1079	1	hinkier
inkier	10	40	1378	1	_inkier
kinkier	10	31	943	1	kinkier
chinkier	17	37	736	2	chinkier
daintier	9	3	740	2	daintier
dandier	9	37	1457	2	dandier
danker	11	43	1966	2	dank_er
denier	7	44	2069	2	den_ier
dicier	9	44	1623	2	di_cier
dicker	13	45	2140	2	dick_er
dickie	13	39	1311	2	dickie_
dickies	14	34	1634	2	dickies
dictier	10	34	1186	2	dictier
diker	10	55	2455	2	di_k_er
diner	6	56	3290	2	din__er
dinger	8	53	2367	2	din_ger
dingies	9	36	1824	2	dingies
dinked	12	48	1835	2	dink_ed
dinkey	14	48	1276	2	dink_ey
dinkiest	13	38	1287	2	dinkiest
dinking	13	36	1828	2	dinking
dinner	7	42	1716	2	din_ner
dippier	12	31	1139	2	dippier
dirtier	8	33	1209	2	dirtier
dishier	11	36	1340	2	dishier
ditsier	8	30	1029	2	ditsier
ditzier	17	30	796	2	ditzier
dizzier	16	31	754	2	dizzier
dorkier	12	28	1002	2	dorkier
drinker	12	34	948	2	drink_er
duckier	14	39	1179	2	duckier
dungier	9	36	858	2	dungier
dunker	11	36	1646	2	dunk_er
duskier	12	40	943	2	duskier
finnier	10	31	995	2	finnier
funkier	14	34	998	2	funkier
ginnier	8	29	898	2	ginnier
gunkier	12	36	955	2	gunkier
hunkier	14	45	1214	2	hunkier
ickier	12	43	992	2	_ickier
inker	9	44	2109	2	_ink_er
inlier	6	36	1536	2	_inlier
jinker	17	40	1354	2	jink_er
junkier	18	33	949	2	junkier
kickier	12	34	905	2	kickier
lankier	11	37	1163	2	lankier
lingier	8	41	1338	2	lingier
linier	6	44	2379	2	lin_ier
linker	10	43	2147	2	link_er
lintier	7	36	1380	2	lintier
milkier	13	34	1116	2	milkier
mincier	11	35	1247	2	mincier
mingier	10	38	1529	2	mingier
mintier	9	36	1599	2	mintier
mirkier	13	31	905	2	mirkier
pickier	15	39	1297	2	pickier
pinier	8	40	2469	2	pin_ier
pinker	12	53	2244	2	pink_er
pinkie	12	44	1427	2	pinkie_
pinkies	13	38	1826	2	pinkies
punkier	13	35	1279	2	punkier
riskier	11	3	842	2	riskier
silkier	11	44	1164	2	silkier
sinker	10	36	2090	2	sink_er
slinkier	12	20	693	2	slinkier
stinkier	12	27	854	2	stinkier
tinier	6	36	2223	2	tin_ier
tinker	10	36	1992	2	tink_er
tinkler	11	36	1054	2	tinkler
tinklier	12	5	544	2	tinklier
tinnier	7	29	1014	2	tinnier
vinier	9	37	1674	2	vin_ier
windier	11	34	1216	2	windier
wingier	11	34	1328	2	wingier
winier	9	45	2245	2	win_ier
winker	13	42	2029	2	wink_er
wonkier	14	3	742	2	wonkier
zingier	17	36	949	2	zingier

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.373	479064.3
2	DLD Change Limit	107671	82	2.936	36672.7
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	3.342	53468.3