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

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

86 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
fragment	14	4	837	(None)
fragments	15	4	621	1	fragments
figment	13	7	974	2	f_igment
flagmen	13	22	691	2	flagmen_
fragmental	16	5	364	2	fragmental
fragmented	17	4	303	2	fragmented
fragrant	12	4	711	2	fragrant
frogmen	13	3	589	2	frogmen_
ragmen	9	37	1218	2	_ragmen_
raiment	9	3	1541	2	_raiment
agent	6	58	2964	3	__ag_ent
ament	7	60	3654	3	__a_ment
argent	7	40	2366	3	ar_g_ent
argument	11	5	890	3	argument
armament	12	4	963	3	armament
augment	10	9	1020	3	_augment
bagmen	11	54	1253	3	_bagmen_
braggest	12	9	653	3	braggest
coagent	10	3	1398	3	coag_ent
crabmeat	14	4	548	3	crabmeat
cragsmen	13	4	476	3	cragsmen_
dragnet	9	12	1143	3	dragne_t
dragomen	12	4	501	3	dragomen_
dragonet	10	13	895	3	dragonet
draymen	13	3	523	3	draymen_
ferment	12	3	1557	3	f_erment
figments	14	4	694	3	f_igments
filament	13	4	1003	3	filament
firmament	16	4	540	3	firmament
fitment	12	7	1030	3	f_itment
flagman	13	18	617	3	flagman_
flagrant	12	4	763	3	flagrant
flamen	11	52	1599	3	fla_men_
flamens	12	46	1106	3	fla_mens
foment	11	37	1830	3	f__oment
foramen	12	3	1053	3	fora_men_
foramens	13	3	782	3	fora_mens
fraena	9	3	806	3	fra__ena
fragged	13	40	1016	3	fragge_d
fragging	14	32	942	3	fragging
fragmentary	20	7	259	3	fragment~~ary~~
fragmentate	17	5	268	3	fragmentate
fragmenting	18	4	324	3	fragment~~ing~~
fragmentize	26	5	241	3	fragment~~ize~~
frailest	11	3	949	3	frailest
frame	10	58	2180	3	fra_me__
framed	12	51	1652	3	fra_me_d
framer	11	48	1744	3	fra_me_r
framers	12	51	1382	3	fra_mers
frames	11	51	1986	3	fra_me_s
framing	13	30	1479	3	fra_ming
frankest	15	3	696	3	frankest
freemen	12	3	846	3	freemen_
frequent	20	4	642	3	frequent
froglet	11	3	1006	3	frogle_t
frogman	13	3	587	3	frogman_
fromenty	16	4	524	3	fr_omenty
frumenty	16	4	457	3	fr_umenty
fulgent	11	3	890	3	fulg_ent
gagmen	10	39	1041	3	_gagmen_
garment	10	3	1523	3	_garment
gradient	10	3	1037	3	gradient
judgment	19	4	403	3	judgment
lament	8	50	2494	3	_la_ment
ligament	11	4	931	3	ligament
lodgment	12	4	598	3	lodgment
margent	10	3	1669	3	marg_ent
ornament	10	4	913	3	ornament
orpiment	12	4	797	3	orpiment
parament	12	4	1539	3	parament
payment	14	3	1070	3	_payment
pigment	12	5	1073	3	_pigment
ragman	9	40	1371	3	_ragman_
raiments	10	3	990	3	_raiments
ramen	7	56	2519	3	_ra_men_
ramenta	9	3	1118	3	_ra_menta
ramet	7	57	4314	3	_ra_me_t
reagent	8	7	1660	3	reag_ent
regent	7	41	2767	3	_reg_ent
regiment	11	44	1405	3	_regiment
sarment	9	3	1876	3	_sarment
segment	10	3	1256	3	_segment
swagmen	13	3	497	3	swagmen_
treatment	11	4	818	3	treatment
urgent	7	38	1604	3	ur_g_ent
varment	12	3	1324	3	_varment

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	86	7.250	20160.3
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	7.703	23197.6