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

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

89 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
gothites	12	4	601	(None)
goethites	13	4	425	1	goethites
gothite	11	4	640	1	gothite_
bothies	12	4	1478	2	bothi_es
gnathites	13	4	423	2	gnathites
gobshites	15	4	293	2	gobshites
goethite	12	4	405	2	goethite_
gothics	13	3	612	2	gothi_cs
ophites	12	3	1010	2	_ophites
anorthites	13	4	483	3	anorthites
attrites	8	3	1156	3	attrites
biotites	10	3	1008	3	biot_ites
bobwhites	19	4	219	3	bobwhites
boehmites	16	6	302	3	boehmites
boites	8	43	2270	3	bo__ites
bornites	10	3	1098	3	bornites
coesites	10	13	1309	3	coesites
cordites	11	3	1462	3	cordites
cowhides	17	3	601	3	cowhides
cowrites	13	30	1159	3	cowrites
esthetes	11	4	774	3	esthetes
fomites	12	36	1320	3	fo_mites
gahnites	12	3	570	3	gahnites
geophytes	18	4	540	3	geophytes
gites	6	56	3018	3	g___ites
glottides	11	6	383	3	glottides
glottises	10	8	495	3	glottises
gnathite	12	4	448	3	gnathite_
goalies	8	3	1602	3	goali_es
gobies	9	54	1806	3	go_bi_es
gobshite	14	4	327	3	gobshite_
godwits	12	3	413	3	godwit_s
goiter	7	41	1620	3	go__iter
goiters	8	40	1444	3	go__iters
goitres	8	38	956	3	go__itres
goodies	9	35	1699	3	goodi_es
goonies	8	36	1833	3	gooni_es
gorditas	10	4	392	3	gorditas
gothic	12	3	779	3	gothi__c
gothicism	17	4	379	3	gothicism
gothicizes	25	4	338	3	gothicizes
goths	9	65	1300	3	goth___s
gotten	7	34	1011	3	got__ten
granites	9	21	1636	3	granites
graphites	15	4	682	3	graphites
gummites	13	4	617	3	gummites
gunites	8	3	1312	3	g_unites
hoplites	13	3	1054	3	hoplites
hotlines	11	8	1164	3	hotlines
hotties	10	30	1696	3	hotti_es
iolites	7	38	1948	3	io_lites
lottes	6	53	2275	3	lot__tes
mothier	12	19	1021	3	mothi_er
mothiest	13	3	1103	3	mothi_est
motiles	9	33	1743	3	mot_iles
motives	12	36	1189	3	mot_ives
mottes	8	55	2369	3	mot__tes
nitrites	8	23	1345	3	nitrites
nonwhites	15	4	539	3	nonwhites
norites	7	40	1880	3	no_rites
notates	7	28	1748	3	not_ates
nothings	12	26	668	3	nothings
notices	9	3	1228	3	not_ices
oolites	7	28	1784	3	_oolites
oophytes	16	4	603	3	oophytes
ophite	11	4	1056	3	_ophite_
otitis	6	36	1234	3	_ot_itis
outhits	10	22	1350	3	outhit_s
petites	9	38	2020	3	pet_ites
phthises	16	4	572	3	phthises
podites	10	30	1473	3	po_dites
potholes	13	3	1293	3	potholes
potlines	10	7	1421	3	potlines
potpies	11	31	1617	3	potpi_es
potsies	9	30	1948	3	potsi_es
potties	9	37	2354	3	potti_es
ratites	7	49	2068	3	rat_ites
rotates	7	28	1977	3	rot_ates
rottes	6	45	2483	3	rot__tes
somites	9	42	1912	3	so_mites
sophies	12	3	1461	3	sophi_es
sopites	9	38	1717	3	so_pites
sorites	7	38	2524	3	so_rites
totemites	11	4	660	3	totemites
votives	13	33	795	3	vot_ives
whites	12	39	1988	3	__whites
withies	13	39	1354	3	withi_es
worthies	14	3	1028	3	worthi_es
zoisites	17	4	497	3	zoisites

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.436	409841.7
2	DLD Change Limit	146162	89	6.923	21112.5
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	7.389	24183.4