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

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

65 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
fantailed	13	4	556	(None)
entailed	9	8	952	2	_entailed
fantail	10	3	1023	2	fantail__
fantails	11	3	969	2	fantail_s
fantasied	13	9	561	2	fantasied
fantasised	14	10	434	2	fantasised
fantasized	23	8	512	2	fantasized
pantiled	11	31	1159	2	pant_iled
pintailed	12	4	555	2	pintailed
rattailed	10	8	421	2	rattailed
antired	8	23	1619	3	_ant_ired
anviled	11	3	895	3	_an_viled
assailed	9	4	532	3	_assailed
attained	9	9	735	3	_attained
availed	11	3	597	3	_a_vailed
bobtailed	14	4	319	3	bobtailed
camailed	13	3	655	3	ca_mailed
canaled	10	36	1556	3	can_a_led
canalled	11	3	958	3	can_alled
cantabile	13	4	689	3	cantabile_
cantabiles	14	4	576	3	cantabiles
captained	14	4	619	3	captained
contained	12	3	1089	3	contained
curtailed	12	4	411	3	curtailed
dentiled	10	3	974	3	dent_iled
detailed	10	31	987	3	_detailed
entailer	8	7	783	3	_entailer
entoiled	9	6	828	3	_entoiled
failed	10	54	2160	3	f___ailed
fancied	13	33	1060	3	fan_ci_ed
fantasie	11	11	774	3	fantasie_
fantasies	12	9	885	3	fantasies
fantasise	12	9	624	3	fantasise_
fantasises	13	9	588	3	fantasises
fantasize	21	9	605	3	fantasize_
fantasizer	22	9	416	3	fantasizer
fantasizes	22	9	546	3	fantasizes
fenagled	13	18	485	3	fen_agled
finagled	13	20	529	3	fin_agled
finialed	12	5	550	3	finia_led
fishtailed	17	4	186	3	fishtailed
flailed	11	3	730	3	f__lailed
fountained	14	4	333	3	fountained
maintained	13	4	385	3	maintained
manacled	13	3	645	3	man_acled
mantled	10	41	1339	3	mant__led
nailed	7	40	2149	3	__n_ailed
pantalet	10	4	1590	3	panta_let
pantile	9	39	1848	3	pant_ile_
pantiles	10	36	1715	3	pant_iles
pigtailed	13	5	349	3	pigtailed
ponytailed	16	5	228	3	ponytailed
renailed	9	25	1280	3	ren_ailed
retailed	9	41	1396	3	_retailed
sandaled	10	3	924	3	sanda_led
sandalled	11	4	590	3	sandalled
snailed	8	38	1192	3	_sn_ailed
tailed	7	44	2466	3	___tailed
tantalised	11	12	698	3	tantalised
tantalized	20	11	892	3	tantalized
tentacled	12	4	495	3	tentacled
unhailed	12	21	996	3	_unhailed
unmailed	11	22	976	3	_unmailed
unnailed	9	22	944	3	_unnailed
wassailed	13	4	315	3	wassailed

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	148641	0.423	422437.4
2	DLD Change Limit	148641	65	6.310	23556.4
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	6.749	26476.7