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

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

71 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
cliches	14	42	1374	(None)
caliches	15	38	1227	1	caliches
cliche	13	37	1245	1	cliche_
cliched	15	37	1102	1	cliched
clinches	15	39	1036	1	clinches
cloches	14	41	1371	1	cloches
liches	11	47	2429	1	_liches
caches	13	79	2691	2	c_aches
caleches	15	26	994	2	caleches
calices	11	43	2169	2	calic_es
caliche	14	32	996	2	caliche_
calicles	12	38	1143	2	calicles
calicoes	12	39	1160	2	calicoes
catches	14	43	2077	2	catches
ceviches	18	3	484	2	ceviches
chichis	17	3	707	2	chichis
chicles	14	35	1250	2	chicles
chinches	18	36	936	2	chinches
cilices	11	38	1402	2	cilic_es
cinches	14	42	1577	2	cinches
clachs	13	35	1132	2	clach_s
clashes	12	40	1728	2	clashes
clenches	15	29	1095	2	clenches
clicked	16	41	1245	2	clicked
clicker	15	41	1188	2	clicker
clickers	16	39	1020	2	clickers
clicks	14	53	1511	2	clic_ks
climes	10	47	2000	2	cli_mes
clinched	16	34	738	2	clinched
clincher	15	34	766	2	clincher
clinchers	16	33	626	2	clinchers
clines	8	49	2604	2	cli_nes
cliques	18	30	920	2	cliques
cloche	13	43	1237	2	cloche_
clothes	12	45	1381	2	clothes
clutches	15	30	792	2	clutches
coaches	14	40	1869	2	coaches
conches	14	40	1981	2	conches
cooches	14	35	1583	2	cooches
couches	14	40	2047	2	couches
creches	14	3	1309	2	creches
cuishes	12	28	1082	2	cuishes
culches	14	37	1074	2	culches
culices	11	37	1312	2	culic_es
cultches	15	31	653	2	cultches
curches	14	35	1274	2	curches
cutches	14	32	1646	2	cutches
cylices	14	35	928	2	cylic_es
fiches	14	52	1953	2	_fiches
filches	15	34	1072	2	filches
fleches	15	34	1144	2	fleches
flinches	16	35	895	2	flinches
flitches	16	38	846	2	flitches
glitches	14	29	666	2	glitches
laches	11	65	2835	2	_laches
leches	11	54	2131	2	_leches
lichee	11	40	1797	2	_lichee
lichees	12	35	1278	2	_lichees
lichen	11	40	1274	2	_lichen
lichens	12	35	1068	2	_lichens
lichis	11	52	1259	2	_lichis
lichts	11	37	1238	2	_lichts
lyches	14	42	1361	2	_lyches
miches	13	43	2073	2	_miches
niches	11	44	1914	2	_niches
quiches	21	3	933	2	quiches
riches	11	50	2208	2	_riches
seiches	12	5	1381	2	seiches
slices	8	40	2285	2	slic_es
wiches	14	44	1875	2	_wiches
zilches	21	32	630	2	zilches

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.390	458182.1
2	DLD Change Limit	107671	71	3.173	33933.5
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	3.593	49733.1