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

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

47 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
gittern	8	33	750	(None)
bittern	9	48	1068	1	bittern
cittern	9	33	914	1	cittern
gitterns	9	32	657	1	gitterns
bitten	8	47	1512	2	bitte_n
bitter	8	46	2267	2	bitter_
bitterns	10	42	895	2	bitterns
bitters	9	49	2036	2	bitters
cistern	9	33	1070	2	cistern
cithern	12	48	991	2	cithern
citterns	10	31	812	2	citterns
fitter	9	41	2003	2	fitter_
fitters	10	45	1775	2	fitters
getter	7	41	1761	2	getter_
getters	8	42	1610	2	getters
gitted	8	40	1505	2	gitte_d
gittin	7	29	1055	2	gitt_in
glitter	8	42	1180	2	glitter_
glitters	9	37	1054	2	glitters
glittery	12	37	561	2	glittery
gotten	7	34	1011	2	gotte_n
gritter	8	39	1335	2	gritter_
gritters	9	42	1063	2	gritters
gutter	7	38	1771	2	gutter_
gutters	8	37	1551	2	gutters
guttery	11	42	776	2	guttery
hitter	9	44	1986	2	hitter_
hitters	10	47	1759	2	hitters
intern	6	40	1654	2	_intern
jitter	13	33	1499	2	jitter_
jitters	14	43	1447	2	jitters
jittery	17	34	644	2	jittery
kitten	10	46	1148	2	kitte_n
litten	6	40	1487	2	litte_n
litter	6	43	2485	2	litter_
litters	7	34	2257	2	litters
littery	10	37	1049	2	littery
mitten	8	39	1409	2	mitte_n
pattern	9	37	1205	2	pattern
ritter	6	38	2242	2	ritter_
ritters	7	40	2062	2	ritters
sitten	6	41	1382	2	sitte_n
sitter	6	33	2338	2	sitter_
sitters	7	42	2155	2	sitters
titter	6	34	2116	2	titter_
titters	7	42	1962	2	titters
zithern	19	44	702	2	zithern

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.420	425454.8
2	DLD Change Limit	107671	47	3.343	32207.9
3	Display Results	47	47	0.016	2937.5
	(SQL Overall)	178691	47	3.779	47285.3