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

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

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
fragments	15	4	621	(None)
fragment	14	4	837	1	fragment_
figments	14	4	694	2	f_igments
fragmental	16	5	364	2	fragmental
fragmented	17	4	303	2	fragmented
raiments	10	3	990	2	_raiments
agents	7	48	1629	3	__ag_ents
aments	8	52	1980	3	__a_ments
argents	8	40	1485	3	ar_g_ents
arguments	12	5	657	3	arguments
armaments	13	4	747	3	armaments
augments	11	3	783	3	_augments
coagents	11	3	845	3	coag_ents
crabmeats	15	4	299	3	crabmeats
dragnets	10	13	656	3	dragne_ts
dragonets	11	13	450	3	dragonets
ferments	13	3	1147	3	f_erments
figment	13	7	974	3	f_igment_
filaments	14	4	665	3	filaments
firmaments	17	4	429	3	firmaments
fitments	13	7	679	3	f_itments
flagmen	13	22	691	3	flagmen__
flamens	12	46	1106	3	fla_men_s
foments	12	29	1205	3	f__oments
foramens	13	3	782	3	fora_men_s
fraggings	15	32	424	3	fraggings
fragmentary	20	7	259	3	fragmentary
fragmentate	17	5	268	3	fragmentate
fragmentates	18	5	258	3	fragmentates
fragmenting	18	4	324	3	fragmenting
fragmentize	26	5	241	3	fragmentize
fragmentizes	27	5	231	3	fragment~~ize~~s
fragrant	12	4	711	3	fragrant_
framers	12	51	1382	3	fra_me_rs
frames	11	51	1986	3	fra_me__s
framings	14	33	813	3	fra_mings
frequents	21	4	444	3	frequents
froglets	12	3	526	3	frogle_ts
frogmen	13	3	589	3	frogmen__
fromenty	16	4	524	3	fr_omenty
frumenty	16	4	457	3	fr_umenty
garments	11	3	996	3	_garments
gradients	11	4	527	3	gradients
judgments	20	4	325	3	judgments
laments	9	43	1485	3	_la_ments
ligaments	12	4	620	3	ligaments
lodgments	13	4	418	3	lodgments
margents	11	4	1013	3	marg_ents
ornaments	11	4	663	3	ornaments
orpiments	13	4	600	3	orpiments
paraments	13	5	1155	3	paraments
payments	15	3	694	3	_payments
pigments	13	3	734	3	_pigments
ragmen	9	37	1218	3	_ragmen__
raiment	9	3	1541	3	_raiment_
ramenta	9	3	1118	3	_ra_menta
ramets	8	35	1739	3	_ra_me_ts
reagents	9	5	962	3	reag_ents
regents	8	34	1654	3	_reg_ents
regiments	12	39	1032	3	_regiments
sarments	10	3	1196	3	_sarments
segments	11	3	890	3	_segments
treatments	12	4	628	3	treatments
varments	13	3	906	3	_varments

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	148641	0.420	425454.8
2	DLD Change Limit	148641	64	7.110	20905.9
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	7.563	23627.0