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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

111 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
flysches	19	3	312	(None)
flashes	13	39	1610	2	flas_hes
fleches	15	34	1144	2	fl_eches
fleeches	16	28	708	2	fleeches
flenches	16	34	1053	2	flenches
fleshes	13	39	1327	2	fles_hes
fletches	16	30	885	2	fletches
flinches	16	35	895	2	flinches
flitches	16	38	846	2	flitches
flushes	13	41	1414	2	flus_hes
flysch	17	3	289	2	flysch__
lyches	14	42	1361	2	_ly_ches
lynches	15	37	887	2	_lynches
blanches	15	33	1160	3	blanches
bleaches	15	34	1067	3	bleaches
blenches	15	33	1076	3	blenches
blotches	15	3	743	3	blotches
blushes	12	43	1482	3	blus_hes
borsches	15	3	600	3	borsches
clashes	12	40	1728	3	clas_hes
clenches	15	29	1095	3	clenches
cliches	14	42	1374	3	cl_iches
clinches	15	39	1036	3	clinches
cloches	14	41	1371	3	cl_oches
clutches	15	30	792	3	clutches
fasces	11	49	1454	3	f_asc_es
fashes	12	45	2402	3	f_as_hes
feldscher	18	4	202	3	feldscher
feldschers	19	4	176	3	feldschers
fescues	12	3	678	3	f_escues
fetches	15	34	1389	3	f_etches
fetiches	16	3	695	3	fetiches
fiascoes	13	13	492	3	fiascoes
fiches	14	52	1953	3	f__iches
filches	15	34	1072	3	f_ilches
finches	15	39	1419	3	f_inches
fishes	12	52	2134	3	f_is_hes
fitches	15	35	1619	3	f_itches
flashed	14	41	1218	3	flas_hed
flasher	13	39	1406	3	flas_her
flashers	14	39	1265	3	flas_hers
fleche	14	29	930	3	fl_eche_
fleeces	12	39	964	3	fleec_es
fleeched	17	34	582	3	fleeched
flenched	17	26	796	3	flenched
fleshed	14	32	1026	3	fles_hed
flesher	13	36	1092	3	fles_her
fleshers	14	33	944	3	fles_hers
fletched	17	30	669	3	fletched
fletcher	16	30	666	3	fletcher
fletchers	17	33	553	3	fletchers
flinched	17	31	670	3	flinched
flincher	16	25	658	3	flincher
flinchers	17	29	547	3	flinchers
flitched	17	25	629	3	flitched
flosses	10	34	1197	3	flos_ses
flossies	11	28	1012	3	flossies
flushed	14	33	1097	3	flus_hed
flusher	13	30	1227	3	flus_her
flushers	14	27	973	3	flus_hers
flushest	14	33	855	3	flus_hest
flysheet	17	4	511	3	flysheet
flysheets	18	4	234	3	flysheets
flytes	12	39	1156	3	fly__tes
frenches	16	33	1163	3	frenches
frescoes	13	5	783	3	frescoes
freshes	13	35	1582	3	fres_hes
fyces	13	98	1364	3	f_y_c_es
glitches	14	29	666	3	glitches
glunches	14	3	626	3	glunches
kirsches	17	4	384	3	kirsches
kitsches	17	3	407	3	kitsches
klatches	17	15	714	3	klatches
klatsches	18	4	223	3	klatsches
laches	11	65	2835	3	_l_aches
larches	12	44	1645	3	_larches
lashes	9	48	3100	3	_las_hes
latches	12	33	2013	3	_latches
leaches	12	33	1934	3	_leaches
leches	11	54	2131	3	_l_eches
leeches	12	39	1193	3	_leeches
letches	12	40	1548	3	_letches
liches	11	47	2429	3	_l_iches
loaches	12	36	1398	3	_loaches
lunches	12	41	1544	3	_lunches
lurches	12	33	1166	3	_lurches
lushes	9	40	2274	3	_lus_hes
lycees	11	42	886	3	_ly_cees
lychee	14	37	1089	3	_ly_chee
lychees	15	51	678	3	_ly_chees
lynched	16	37	675	3	_lynched
lyncher	15	36	655	3	_lyncher
lynchers	16	28	545	3	_lynchers
lysates	10	31	747	3	_lysates
lyses	8	45	1825	3	_lys__es
lysines	10	36	909	3	_lysines
mensches	15	3	630	3	mensches
planches	15	31	1186	3	planches
plashes	12	44	1739	3	plas_hes
pleaches	15	32	1043	3	pleaches
plenches	15	31	1062	3	plenches
plushes	12	43	1367	3	plus_hes
psyches	17	5	580	3	psy_ches
putsches	15	3	531	3	putsches
slashes	10	36	1911	3	slas_hes
slatches	13	15	1153	3	slatches
sloshes	10	38	1180	3	slos_hes
slouches	13	20	807	3	slouches
slushes	10	35	1441	3	slus_hes
tusches	12	3	790	3	_tusches
wyches	17	38	791	3	_wy_ches

Search took 8 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	146162	0.406	440125.6
2	DLD Change Limit	146162	111	6.873	21266.1
3	Display Results	111	111	0.046	2413.0
	(SQL Overall)	178691	111	7.325	24394.7