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

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

82 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
ingather	12	4	478	(None)
ingathers	13	4	445	1	ingathers
gather	10	41	1586	2	__gather
ingate	7	30	1824	2	ingat_e_
ingates	8	27	1691	2	ingat_es
ingathered	15	4	296	2	ingathered
regather	12	3	673	2	regather
upgather	14	15	275	2	upgather
another	10	28	915	3	an_other
anther	9	37	1506	3	an__ther
aweather	14	3	426	3	aweather
bather	11	53	2251	3	__bather
blather	12	53	1421	3	_blather
breather	13	36	1059	3	breather
engager	9	27	860	3	enga_ger
father	12	51	1671	3	__father
feather	13	36	1350	3	_feather
forgather	16	4	366	3	forgather
gasher	10	43	2037	3	__gasher
gater	6	45	3365	3	__gat_er
gathers	11	43	1507	3	__gathers
heather	13	39	1485	3	_heather
igniter	8	14	767	3	ignit_er
inaner	6	22	1354	3	in_a_ner
incher	11	41	1403	3	in__cher
inciter	9	31	1377	3	incit_er
inditer	8	35	1423	3	indit_er
inearthed	13	4	362	3	inearthed
inflater	11	4	989	3	inflat_er
ingathering	16	10	301	3	ingather~~ing~~
ingoted	9	3	918	3	ingot_ed
ingrate	8	7	1512	3	ingrat_e_
ingrates	9	5	1417	3	ingrat_es
inhaler	10	6	805	3	inha_ler
inhauler	11	6	394	3	inhauler
inlander	9	3	722	3	inlander
inlayer	10	3	693	3	inla_yer
inmate	8	29	1736	3	inmat_e_
inmates	9	27	1578	3	inmat_es
innate	6	39	1731	3	innat_e_
inputter	10	3	420	3	inputter
insaner	7	3	1044	3	insa_ner
insetter	8	21	859	3	insetter
inswathe	14	4	369	3	inswathe_
inswathed	16	4	296	3	inswathed
inswathes	15	4	395	3	inswathes
inter	5	50	2849	3	in__t_er
invader	11	14	645	3	inva_der
inviter	10	41	1231	3	invit_er
irater	6	52	1835	3	i_rat_er
ither	8	46	1760	3	i___ther
lather	9	51	2436	3	__lather
leather	10	38	1578	3	_leather
loather	10	37	1100	3	_loather
megathere	15	4	473	3	megathere
natter	6	44	2074	3	_n_atter
neater	6	44	2431	3	_neat_er
neatherd	12	10	719	3	_neatherd
negater	8	37	1196	3	negat_er
neither	10	3	757	3	_neither
nether	9	40	1416	3	_n_ether
nigher	10	36	1275	3	nig__her
norther	10	3	973	3	_norther
nother	9	38	1596	3	_n_other
pinfeather	18	5	184	3	pinfeather
pleather	13	5	665	3	pleather
rather	9	43	1974	3	__rather
regathers	13	3	635	3	regathers
sheather	14	5	823	3	sheather
slather	10	38	1608	3	_slather
snatcher	13	16	776	3	sn_atcher
snathe	9	44	1511	3	sn_athe_
snathes	10	48	1649	3	sn_athes
sunbather	14	4	302	3	sunbather
swather	13	42	1360	3	_swather
together	12	4	374	3	together
unbathed	14	3	722	3	unbathed
ungated	9	27	1721	3	ungat_ed
untether	11	4	516	3	untether
upgathers	15	8	253	3	upgathers
weather	13	35	1322	3	_weather
wreather	14	26	860	3	wreather

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.423	422437.4
2	DLD Change Limit	146162	82	7.016	20832.7
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	7.469	23924.4