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

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

80 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
pavement	15	4	944	(None)
pavements	16	4	700	1	pavements
averment	13	3	1160	2	_averment
basement	12	3	1149	2	basement
casement	12	3	1195	2	casement
cavemen	14	3	714	2	cavemen_
easement	10	4	1416	2	easement
movement	15	4	943	2	movement
parament	12	4	1539	2	parament
payment	14	3	1070	2	pa_yment
placement	15	4	818	2	placement
ravelment	14	4	720	2	ravelment
abasement	13	4	833	3	abasement
abatement	13	4	818	3	abatement
abetment	12	4	823	3	_abetment
ailment	9	3	1423	3	_ailment
aliment	9	3	1670	3	_aliment
amazement	22	4	647	3	amazement
ament	7	60	3654	3	_a__ment
apartment	13	4	703	3	apartment
appetent	12	4	808	3	appetent
augment	10	9	1020	3	_augment
averments	14	4	909	3	_averments
axemen	15	4	749	3	_axemen_
bailment	12	4	918	3	bailment
bakemeat	16	5	527	3	bakemeat
basemen	11	3	908	3	basemen_
basements	13	4	826	3	basements
battement	13	5	777	3	battement
bodement	13	4	1012	3	bodement
casements	13	4	858	3	casements
caveman	14	3	707	3	caveman_
cement	10	33	2167	3	__cement
cerement	12	3	1513	3	cerement
clement	11	3	1377	3	_clement
dement	9	38	2515	3	__dement
depravement	19	5	500	3	depravement
easements	11	4	1033	3	easements
element	9	3	1780	3	_element
garment	10	3	1523	3	ga_rment
gatemen	10	4	760	3	gatemen_
impalement	16	4	761	3	impalement
lament	8	50	2494	3	la__ment
movements	16	4	751	3	movements
packmen	17	4	631	3	packmen_
pageant	10	3	1278	3	page_ant
paramenta	13	6	886	3	paramenta
paraments	13	5	1155	3	paraments
parchment	18	4	691	3	parchment
parent	8	32	3042	3	pa__rent
patent	8	45	2492	3	pa__tent
patient	9	6	1707	3	pa_tient
patulent	10	4	860	3	patulent
paveed	12	43	889	3	pave_e_d
payments	15	3	694	3	pa_yments
pediment	13	4	1139	3	pediment
pigment	12	5	1073	3	p_igment
pikemen	15	3	533	3	pikemen_
placemen	14	4	578	3	placemen_
placements	16	4	597	3	placements
precent	11	35	2026	3	p_recent
premeet	11	6	1515	3	p_remeet
premen	10	50	1780	3	p_remen_
present	9	40	2273	3	p_resent
prevent	12	40	1655	3	p_revent
raiment	9	3	1541	3	ra_iment
ravagement	16	4	498	3	ravagement
ravelments	15	4	519	3	ravelments
recement	12	3	1565	3	recement
revehent	14	23	908	3	revehent
revelment	14	4	877	3	revelment
reverent	11	26	1509	3	reverent
revetment	14	4	832	3	revetment
sarment	9	3	1876	3	sa_rment
spacemen	14	4	541	3	spacemen_
statement	11	4	879	3	statement
tenement	10	4	1259	3	tenement
varment	12	3	1324	3	va_rment
vehement	16	4	776	3	vehement
wavelet	13	3	1094	3	wavele_t

Search took 9 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.453	394461.4
2	DLD Change Limit	146162	80	7.733	18901.1
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	8.219	21741.2