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

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

67 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
isothere	11	4	579	(None)
isotheres	12	4	633	1	isotheres
isotherm	13	4	428	1	isotherm
dinothere	13	4	411	2	dinothere
isochore	13	5	586	2	isochore
isotheral	12	5	410	2	isotheral
isotherms	14	4	408	2	isotherms
another	10	28	915	3	another_
apothece	15	4	377	3	apothece
biosphere	16	6	478	3	biosphere
bother	11	52	1806	3	_bother_
bothered	14	21	1039	3	_bothered
bothers	12	43	1775	3	_bothers
brother	12	33	1133	3	brother_
brothered	15	4	600	3	brothered
brothers	13	34	1083	3	brothers
cohere	11	27	1699	3	_co_here
dinotheres	14	4	460	3	dinotheres
esthete	10	4	743	3	es_thete
frother	13	31	1015	3	frother_
frothers	14	27	981	3	frothers
inhere	9	3	1371	3	i__nhere
insphere	13	5	597	3	insphere
isobare	9	4	634	3	iso_bare
isocheim	15	4	333	3	isocheim
isochime	15	11	384	3	isochime
isochor	12	4	474	3	isochor_
isochores	14	5	609	3	isochores
isochors	13	5	567	3	isochors
isohel	9	3	548	3	iso_he_l
isohels	10	3	539	3	iso_hels
isomer	8	3	1015	3	iso_mer_
isomers	9	3	1004	3	iso_mers
isophote	13	7	657	3	isophote
isoprene	10	4	561	3	isoprene
isothermal	15	5	276	3	isothermal
isotone	7	23	998	3	isot_one
isotope	9	22	778	3	isot_ope
isotype	12	22	495	3	isot_ype
ither	8	46	1760	3	i__ther_
mother	11	37	1864	3	_mother_
mothered	14	23	1010	3	_mothered
mothers	12	37	1762	3	_mothers
mothery	15	37	1051	3	_mothery
nother	9	38	1596	3	_nother_
nowhere	13	3	721	3	_nowhere
oosphere	13	5	599	3	oosphere
other	8	42	1910	3	__other_
others	9	39	1800	3	__others
pother	11	38	1885	3	_pother_
potherb	14	35	868	3	_potherb
pothered	14	23	1104	3	_pothered
pothers	12	38	1862	3	_pothers
smother	12	35	1021	3	smother_
smothered	15	4	568	3	smothered
smotherer	14	4	463	3	smotherer
smothers	13	34	993	3	smothers
smothery	16	29	606	3	smothery
soother	10	42	1504	3	soother_
soothers	11	39	1343	3	soothers
souther	10	41	1630	3	_souther_
southern	11	43	891	3	_southern
southers	11	42	1445	3	_southers
sphere	11	33	1366	3	_s_phere
stere	5	53	2854	3	_s_t_ere
there	8	75	2739	3	___there
tother	9	41	1714	3	_tother_

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	67	6.843	21359.3
3	Display Results	67	67	0.016	4187.5
	(SQL Overall)	178691	67	7.295	24495.0