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

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

84 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
kimchee	18	4	560	(None)
kimchees	19	4	294	1	kimchees
fitchee	15	27	1078	2	fitchee
imphee	13	3	1035	2	_imphee
kimchi	17	4	380	2	kimch_i
kimchis	18	4	373	2	kimchis
kitchen	16	28	768	2	kitchen
lichee	11	40	1797	2	li_chee
aitches	12	30	1436	3	aitches
birched	15	34	991	3	birched
birchen	14	34	788	3	birchen
birches	14	34	1232	3	birches
bitched	15	32	1292	3	bitched
bitchen	14	34	973	3	bitchen
bitches	14	41	1706	3	bitches
bouchee	14	33	1354	3	bouchee
cinched	15	39	1086	3	cinched
cinches	14	42	1577	3	cinches
ditched	14	37	1190	3	ditched
ditcher	13	40	1200	3	ditcher
ditches	13	32	1571	3	ditches
emcee	9	3	1594	3	_emc_ee
fiche	13	46	1674	3	fi_ch_e
fiches	14	52	1953	3	fi_ches
filched	16	30	742	3	filched
filcher	15	37	779	3	filcher
filches	15	34	1072	3	filches
finches	15	39	1419	3	finches
fitches	15	35	1619	3	fitches
fitchet	15	31	1356	3	fitchet
fitchew	18	27	680	3	fitchew
hitched	16	33	1225	3	hitched
hitcher	15	37	1200	3	hitcher
hitches	15	36	1627	3	hitches
imphees	14	3	669	3	_imphees
inched	12	45	1448	3	_inched
incher	11	41	1403	3	_incher
inches	11	44	1967	3	_inches
itched	12	38	1202	3	_itched
itches	11	49	1621	3	_itches
kenches	16	39	1227	3	kenches
ketches	16	40	1219	3	ketches
kicked	12	44	1594	3	ki_cked
kicker	11	41	1618	3	ki_cker
killdee	12	6	622	3	killdee
kirsches	17	4	384	3	kirsches
kishke	12	5	427	3	ki_shke
kitchenet	18	4	498	3	kitchenet
kitchens	17	19	578	3	kitchens
kithe	12	59	1745	3	ki_th_e
kithed	14	46	1301	3	ki_thed
kithes	13	50	1665	3	ki_thes
kitsches	17	3	407	3	kitsches
kuchen	15	3	665	3	k_uchen
lichees	12	35	1278	3	li_chees
lichen	11	40	1274	3	li_chen
liches	11	47	2429	3	li_ches
lychee	14	37	1089	3	_lychee
miche	12	62	1924	3	mi_ch_e
miched	14	39	1339	3	mi_ched
miches	13	43	2073	3	mi_ches
niche	10	50	1679	3	ni_ch_e
niched	12	55	1406	3	ni_ched
niches	11	44	1914	3	ni_ches
nitchie	12	4	723	3	nitchie
pinched	15	38	1245	3	pinched
pincher	14	38	1271	3	pincher
pinches	14	41	1793	3	pinches
pitched	15	35	1292	3	pitched
pitcher	14	38	1371	3	pitcher
pitches	14	36	1775	3	pitches
richen	11	38	1251	3	ri_chen
richer	11	40	1504	3	ri_cher
riches	11	50	2208	3	ri_ches
sickee	12	46	2222	3	si_ckee
trochee	12	26	1388	3	trochee
vouchee	15	34	1126	3	vouchee
wiches	14	44	1875	3	wi_ches
winched	16	31	1059	3	winched
wincher	15	34	1065	3	wincher
winches	15	47	1437	3	winches
witched	16	30	1219	3	witched
witches	15	27	1579	3	witches
zilches	21	32	630	3	zilches

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.410	435831.7
2	DLD Change Limit	134027	84	6.250	21444.3
3	Display Results	84	84	0.030	2800.0
	(SQL Overall)	178691	84	6.690	26710.2