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

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

88 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
dyking	15	45	801	(None)
deking	12	56	1455	1	deking
diking	12	43	2024	1	diking
duking	12	47	1513	1	duking
dyeing	11	42	821	1	dyeing
dying	10	53	1603	1	dy_ing
ryking	14	34	811	1	ryking
asking	11	60	1723	2	asking
baking	13	56	2662	2	baking
biking	13	50	1817	2	biking
caking	13	46	2467	2	caking
coking	13	45	2388	2	coking
daring	8	49	2868	2	daring
darking	13	42	1734	2	darking
dating	8	53	2648	2	dating
dawing	11	48	1982	2	dawing
dazing	17	55	1651	2	dazing
decking	15	39	1559	2	decking
dekeing	13	35	835	2	dekeing
dewing	11	41	1570	2	dewing
dicing	10	57	1876	2	dicing
dicking	15	36	1761	2	dicking
dieing	8	40	1865	2	dieing
ding	6	69	4095	2	d__ing
dining	8	45	2513	2	dining
dinking	13	36	1828	2	dinking
dirking	13	38	1260	2	dirking
disking	13	46	1549	2	disking
diving	11	37	1795	2	diving
docking	15	36	1501	2	docking
doing	7	49	2358	2	d_oing
doling	8	49	2313	2	doling
doming	10	42	1839	2	doming
doping	10	39	1946	2	doping
dosing	8	39	2027	2	dosing
doting	8	48	2191	2	doting
dowing	11	42	2151	2	dowing
dozing	17	42	1419	2	dozing
drying	11	34	1160	2	drying
ducking	15	43	1505	2	ducking
duding	9	39	1332	2	duding
dunking	13	38	1326	2	dunking
duping	10	41	1363	2	duping
during	8	44	1940	2	during
dusking	13	39	1205	2	dusking
dyeings	12	37	464	2	dyeings
dyings	11	47	813	2	dy_ings
eking	10	66	1498	2	_eking
eyeing	10	42	936	2	eyeing
eying	9	61	1792	2	ey_ing
faking	14	55	2098	2	faking
gybing	13	35	593	2	gybing
gyring	11	39	1036	2	gyring
gyving	14	41	571	2	gyving
hiking	14	36	1710	2	hiking
hoking	14	44	1951	2	hoking
hying	12	65	1474	2	hy_ing
hyping	15	40	848	2	hyping
inking	11	51	1905	2	inking
irking	11	46	1175	2	irking
joking	18	41	1302	2	joking
juking	18	38	1047	2	juking
king	9	59	3366	2	__king
laking	11	50	2704	2	laking
liking	11	43	1958	2	liking
lying	9	57	1745	2	ly_ing
lysing	10	47	1044	2	lysing
making	13	48	2385	2	making
miking	13	42	1846	2	miking
nuking	11	34	1125	2	nuking
piking	13	37	1964	2	piking
poking	13	38	1930	2	poking
puking	13	39	1306	2	puking
raking	11	47	2842	2	raking
skying	14	39	998	2	skying
taking	11	47	2595	2	taking
toking	11	44	2072	2	toking
tsking	11	42	1042	2	tsking
tying	9	60	1984	2	ty_ing
tyning	10	55	1041	2	tyning
typing	12	41	1058	2	typing
tyring	10	46	1302	2	tyring
viking	14	34	1461	2	viking
vying	12	51	1181	2	vy_ing
waking	14	48	2138	2	waking
wyling	13	36	855	2	wyling
wyting	13	27	724	2	wyting
yoking	14	39	1228	2	yoking

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	82551	0.343	520965.0
2	DLD Change Limit	82551	88	2.296	35954.3
3	Display Results	88	88	0.033	2666.7
	(SQL Overall)	178691	88	2.672	66875.4