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

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

72 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
outfooling	14	4	547	(None)
outfooting	14	4	565	1	outfooting
outcooking	17	4	552	2	outcooking
outfabling	16	4	454	2	outfabling
outfeeling	14	4	507	2	outfeeling
outflowing	17	4	471	2	outflowing
outfoxing	20	11	560	2	outf_oxing
outhowling	17	4	518	2	outhowling
outpolling	13	4	621	2	outpolling
outrolling	11	3	753	2	outrolling
outrooting	11	4	793	2	outrooting
batfowling	19	4	244	3	batfowling
befooling	15	3	505	3	_befooling
fooling	11	31	1737	3	___fooling
hotfooting	17	4	254	3	hotfooting
outbawling	16	4	493	3	outbawling
outblooming	16	4	272	3	outblooming
outboxing	19	15	576	3	out_boxing
outcrowing	16	4	599	3	outcrowing
outdodging	14	4	373	3	outdodging
outdoing	10	3	942	3	out_do_ing
outdueling	12	4	459	3	outdueling
outfacing	15	7	811	3	outf_acing
outfasting	14	4	633	3	outfasting
outfawning	17	4	422	3	outfawning
outfencing	16	4	529	3	outfencing
outfinding	15	4	587	3	outfinding
outfiring	13	3	816	3	outf_iring
outfishing	17	6	599	3	outfishing
outfitting	14	6	582	3	outfitting
outfloating	15	4	436	3	outfloating
outflying	16	3	534	3	outf_lying
outfool	10	3	733	3	outfool___
outfooled	13	4	549	3	outfool_ed
outfools	11	3	653	3	outfool__s
outfrowning	18	4	323	3	outfrowning
outfumbling	19	4	176	3	outfumbling
outglowing	15	4	468	3	outglowing
outgoing	10	3	927	3	out_go_ing
outgrowing	15	5	564	3	outgrowing
outkilling	15	4	526	3	outkilling
outloving	13	3	671	3	out_loving
outmoding	13	4	651	3	out_moding
outmoving	15	4	560	3	out_moving
outpeopling	16	5	317	3	outpeopling
outpouring	13	4	604	3	outpouring
outpulling	13	4	482	3	outpulling
outquoting	20	6	474	3	outquoting
outroaring	11	3	883	3	outroaring
outrocking	17	4	705	3	outrocking
outrowing	13	3	903	3	out_rowing
outsailing	11	3	756	3	outsailing
outscolding	15	4	327	3	outscolding
outscooping	16	4	319	3	outscooping
outscoring	13	4	623	3	outscoring
outselling	11	8	802	3	outselling
outshooting	15	10	415	3	outshooting
outsmiling	13	4	574	3	outsmiling
outsmoking	17	4	512	3	outsmoking
outsnoring	11	4	561	3	outsnoring
outsoaring	11	3	770	3	outsoaring
outtelling	11	10	713	3	outtelling
outvoicing	16	4	476	3	outvoicing
outvoting	13	3	682	3	out_voting
outwiling	13	3	746	3	out_wiling
outwilling	14	4	580	3	outwilling
outworking	18	4	549	3	outworking
outyelling	14	11	614	3	outyelling
retooling	10	3	909	3	ret_ooling
stooling	9	31	1313	3	_st_ooling
subcooling	15	4	425	3	subcooling
tooling	8	29	1831	3	__t_ooling

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.420	425454.8
2	DLD Change Limit	140603	72	6.016	23371.5
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	6.466	27635.5