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

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

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.

60 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
droshky	18	4	197	(None)
drosky	14	48	616	1	dros_ky
drossy	10	52	847	2	dros_sy
bosky	14	56	1239	3	_bos_ky
brashly	15	42	761	3	brashly
brashy	14	52	1059	3	brash_y
brosy	10	61	1538	3	bros__y
brothy	14	51	962	3	broth_y
brushy	14	46	826	3	brush_y
croaky	15	52	848	3	cro_aky
crossly	12	7	727	3	crossly
dashy	12	56	1238	3	d_ash_y
dishy	12	57	1235	3	d_ish_y
dorky	13	55	1874	3	d_o_rky
drecky	16	48	633	3	dr_ecky
dressy	10	51	814	3	dres_sy
drolly	10	54	1167	3	dro_lly
drooly	10	49	1107	3	dro_oly
droopy	12	45	824	3	dro_opy
dropshot	14	4	507	3	dropshot
dropsy	12	49	747	3	dro_psy
drosera	8	3	620	3	drosera
droshkies	17	6	256	3	droshkies
dross	6	54	1809	3	dros__s
drosses	8	45	1382	3	drosses
droughty	16	30	447	3	droughty
drouk	10	3	943	3	dro_uk_
drouks	11	3	712	3	dro_uks
drouthy	14	39	517	3	drouthy
drowsily	15	8	372	3	drowsily
drowsy	13	48	790	3	dro_wsy
dusky	13	52	1304	3	d_us_ky
erosely	10	3	808	3	erosely
freshly	16	28	683	3	freshly
frisky	16	40	667	3	fris_ky
frosh	11	57	1340	3	frosh__
frosty	12	47	1063	3	fros_ty
frothy	15	57	837	3	froth_y
grossly	11	7	598	3	grossly
groszy	19	39	570	3	gros_zy
piroshki	17	4	171	3	piroshki
poshly	14	3	772	3	_poshly
prosily	12	6	1163	3	prosily
prosody	13	3	643	3	prosody
prosy	10	63	1925	3	pros__y
rashly	12	34	1021	3	_rashly
risky	12	63	1152	3	_ris_ky
rocky	14	45	1385	3	_ro_cky
rooky	12	61	1762	3	_ro_oky
rosary	9	28	1035	3	_rosary
rosery	9	38	1328	3	_rosery
roshi	8	3	1075	3	_rosh_i
roshis	9	3	1179	3	_roshis
rosily	9	39	1471	3	_rosily
rosiny	9	44	1453	3	_rosiny
rosy	7	60	2487	3	_ros__y
rushy	11	54	1481	3	_rush_y
sloshy	12	36	662	3	slosh_y
trashy	12	50	905	3	trash_y
trophy	14	3	828	3	troph_y

Search took 7 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	134027	0.500	357382.0
2	DLD Change Limit	134027	60	6.266	21389.6
3	Display Results	60	60	0.013	4615.4
	(SQL Overall)	178691	60	6.779	26359.5