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

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

64 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
fritters	11	38	1078	(None)
critters	10	35	1132	1	critters
fitters	10	45	1775	1	f_itters
flitters	11	43	1217	1	flitters
fretters	11	34	1030	1	fretters
fritter	10	39	1277	1	fritter_
gritters	9	42	1063	1	gritters
ritters	7	40	2062	1	_ritters
bitters	9	49	2036	2	_bitters
chitters	13	37	1117	2	chitters
critter	9	41	1303	2	critter_
critturs	10	37	459	2	critturs
drifters	12	41	791	2	drifters
emitters	10	34	964	2	emitters
fainters	11	34	969	2	fainters
fetters	10	35	1790	2	f_etters
filters	10	38	1655	2	f_ilters
fitter	9	41	2003	2	f_itter_
flatters	11	38	1420	2	flatters
flirters	11	33	793	2	flirters
flitter	10	34	1390	2	flitter_
flutters	11	40	1082	2	flutters
fraters	10	35	1721	2	fr_aters
fretter	10	34	1275	2	fretter_
friers	9	47	1893	2	fri__ers
frillers	11	34	987	2	frillers
friskers	15	33	737	2	friskers
frites	9	49	2248	2	fri_te_s
fritted	11	36	1133	2	fritte_d
frittered	13	20	516	2	frittered
fritterer	12	23	440	2	fritterer
fritterers	13	20	339	2	fritterers
fritts	9	46	1319	2	fritt__s
fritzes	19	32	945	2	fritze_s
frizers	19	32	955	2	fri_zers
frizzers	19	33	510	2	frizzers
frothers	14	27	981	2	frothers
frotteurs	12	4	222	2	frotteurs
fruiters	11	32	818	2	fruiters
glitters	9	37	1054	2	glitters
grifters	12	38	923	2	grifters
gristers	9	40	1340	2	gristers
gritter	8	39	1335	2	gritter_
hitters	10	47	1759	2	_hitters
jitters	14	43	1447	2	_jitters
knitters	12	33	662	2	knitters
litters	7	34	2257	2	_litters
omitters	10	27	765	2	omitters
printers	10	32	1490	2	printers
quitters	17	23	852	2	quitters
ratters	7	44	2247	2	_ratters
rioters	7	36	1551	2	_rioters
ritter	6	38	2242	2	_ritter_
rotters	7	44	2139	2	_rotters
sitters	7	42	2155	2	_sitters
skitters	12	34	955	2	skitters
slitters	8	40	1413	2	slitters
spitters	10	41	1338	2	spitters
titters	7	42	1962	2	_titters
trotters	8	33	1024	2	trotters
twitters	11	29	677	2	twitters
whitters	14	35	940	2	whitters
writers	10	55	1349	2	wri_ters
writhers	14	39	898	2	writhers

Search took 5 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	121059	0.376	475242.0
2	DLD Change Limit	121059	64	3.796	31891.2
3	Display Results	64	64	0.016	4000.0
	(SQL Overall)	178691	64	4.188	42667.4