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

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

50 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
gallanting	12	4	535	(None)
ballasting	13	4	530	2	ballasting
galantine	10	4	733	2	ga_lantine
galavanting	16	5	234	2	galavanting
galivanting	16	4	252	2	galivanting
galleting	11	3	763	2	gall_eting
gallivanting	17	5	161	2	gallivanting
garlanding	13	4	443	2	garlanding
ablating	11	3	1200	3	_abla_ting
allantoin	9	8	453	3	_allantoin_
allantoins	10	8	372	3	_allantoins
allaying	12	33	931	3	_alla_ying
allotting	10	4	650	3	_allotting
balancing	14	3	578	3	ba_lancing
balloting	12	3	839	3	ball_oting
collating	12	3	1278	3	colla_ting
explanting	20	4	522	3	explanting
fellating	13	3	925	3	fella_ting
galantines	11	4	574	3	ga_lantines
gallamine	12	4	612	3	galla_mine
gallant	8	35	1711	3	gallant___
gallanted	11	4	590	3	gallant_ed
gallantly	13	4	425	3	gallant_ly
gallantries	12	5	413	3	gallantries
gallantry	13	4	336	3	gallant_ry
gallants	9	33	1037	3	gallant__s
gallerying	15	4	303	3	gallerying
galling	9	39	2196	3	gall___ing
galloping	13	5	625	3	gall_oping
gallying	13	32	893	3	gall__ying
galvanising	16	12	334	3	galvanising
galvanizing	25	9	434	3	galvanizing
garmenting	14	4	548	3	garmenting
gelating	10	30	1573	3	g_ela_ting
glancing	12	4	706	3	g__lancing
gleaning	10	26	932	3	g_lean_ing
glinting	10	32	1005	3	g__linting
gloating	10	26	1146	3	g_loa_ting
granting	10	35	1452	3	g__ranting
implanting	15	4	532	3	implanting
palleting	12	3	874	3	pall_eting
palliating	13	4	789	3	palliating
palpating	14	3	854	3	palpa_ting
planting	11	35	1538	3	__planting
replanting	13	3	852	3	replanting
slanting	9	41	1509	3	__slanting
tallaging	11	4	650	3	talla_ging
valancing	15	4	474	3	va_lancing
valuating	13	3	865	3	valua_ting
warranting	14	4	474	3	warranting

Search took 7 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	140603	0.406	440125.6
2	DLD Change Limit	140603	50	6.250	22496.5
3	Display Results	50	50	0.033	1515.2
	(SQL Overall)	178691	50	6.689	26714.2