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

Here are the results of your fuzzy-string dictionary search for “grivet” with Change Limit: [1] [2] [3]

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.

61 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
grivet	10	35	1782	(None)
grivets	11	35	797	1	grivets
privet	11	38	2134	1	privet
rivet	8	56	3636	1	_rivet
trivet	9	37	2188	1	trivet
brevet	11	57	1733	2	brevet
civet	10	58	2873	2	_civet
drive	9	53	1800	2	drive_
drivel	10	51	1038	2	drivel
driven	10	52	1014	2	driven
driver	10	47	1449	2	driver
drives	10	51	1711	2	drives
give	8	58	2935	2	g_ive_
given	9	59	1528	2	g_iven
giver	9	49	2120	2	g_iver
gives	9	53	2487	2	g_ives
grave	9	46	2487	2	grave_
graved	11	48	1881	2	graved
gravel	10	53	1382	2	gravel
graven	10	45	1352	2	graven
graver	10	50	1859	2	graver
graves	10	46	2400	2	graves
gravest	11	40	1163	2	gravest
greet	6	58	3532	2	gr_eet
gride	7	52	2358	2	gride_
grided	9	51	1704	2	grided
grides	8	44	2236	2	grides
grief	9	53	1978	2	gri_ef
grieve	10	4	724	2	grieve
grieved	12	3	528	2	grieved
griever	11	3	603	2	griever
grieves	11	3	732	2	grieves
grift	9	59	2446	2	gri_ft
grime	8	50	2132	2	grime_
grimed	10	47	1409	2	grimed
grimes	9	46	1903	2	grimes
griot	6	53	2841	2	gri_ot
gripe	8	46	2296	2	gripe_
griped	10	41	1471	2	griped
griper	9	41	1461	2	griper
gripes	9	46	1987	2	gripes
gripey	12	41	1120	2	gripey
gript	8	51	2617	2	gri_pt
grist	6	55	2987	2	gri_st
grit	5	52	4724	2	gri__t
grove	9	52	1933	2	grove_
groved	11	44	1370	2	groved
grovel	10	43	1054	2	grovel
groves	10	43	1810	2	groves
privets	12	29	1005	2	privets
revet	8	49	3884	2	_revet
rive	7	55	3772	2	_rive_
rived	9	48	2561	2	_rived
riven	8	51	2162	2	_riven
river	8	57	3169	2	_river
rives	8	53	3600	2	_rives
rivets	9	44	1711	2	_rivets
swivet	12	36	1547	2	swivet
trevet	9	48	1891	2	trevet
trijet	13	39	1655	2	trijet
trivets	10	39	1158	2	trivets

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	61	2.406	34310.5
3	Display Results	61	61	0.016	3812.5
	(SQL Overall)	178691	61	2.765	64626.0