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

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

82 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
trifling	12	24	1150	1	trifling
rifling	11	28	1501	2	_rifling
triflings	13	23	597	2	triflings
trilith	10	3	1051	2	tri_lith
trilling	9	28	1596	2	trilling
tripling	11	27	1255	2	tripling
bridling	12	26	1058	3	bridling
brisling	11	24	1084	3	brisling
drifting	13	33	873	3	drifting
drilling	10	33	1198	3	drilling
frilling	12	30	1149	3	frilling
griffin	14	3	451	3	griffin_
griffins	15	4	478	3	griffins
grifting	13	29	926	3	grifting
grilling	10	38	1153	3	grilling
prilling	11	34	1341	3	prilling
riffing	14	40	1127	3	_riffing
riffling	15	5	611	3	_riffling
riflings	12	22	730	3	_riflings
riflip	11	3	472	3	_rifli_p
riflips	12	3	416	3	_riflips
rifting	11	35	1500	3	_rifting
riling	7	42	2797	3	_ri_ling
rilling	8	40	2362	3	_rilling
stifling	12	21	1091	3	stifling
stripling	12	5	778	3	stripling
tailfin	10	3	569	3	tailfin_
tailfins	11	3	544	3	tailfins
tailing	8	29	2310	3	tai_ling
tariffing	16	4	411	3	tariffing
thirling	12	24	858	3	thirling
thrilling	13	27	669	3	thrilling
tiffin	12	32	793	3	t_iffin_
tiffing	14	33	938	3	t_iffing
tiffins	13	32	798	3	t_iffins
tiling	7	34	2655	3	t_i_ling
tilling	8	35	2278	3	t_illing
tirling	8	33	1573	3	t_irling
titling	8	37	1579	3	t_itling
toiling	8	32	1902	3	toi_ling
trailing	9	29	1609	3	trailing
tramline	10	3	1138	3	tramline
trapline	10	4	1186	3	trapline
trawling	12	27	1078	3	trawling
trebling	11	3	987	3	trebling
triaging	10	26	1054	3	triaging
triazin	16	3	820	3	triazin_
triazine	17	3	850	3	triazine
triazins	17	3	835	3	triazins
trichina	13	4	809	3	trichina
tricing	10	34	1735	3	tri_cing
tricking	15	27	1451	3	tricking
trickish	17	4	679	3	trickish
trickling	16	4	772	3	trickling
triclinia	11	5	416	3	triclinia
triclinic	13	5	422	3	triclinic
trifid	10	3	906	3	trif_i_d
trifle	9	40	1288	3	trifl__e
trifled	11	37	1196	3	trifl_ed
trifler	10	39	1215	3	trifl_er
triflers	11	31	1021	3	triflers
trifles	10	38	1482	3	trifl_es
trifolium	14	4	324	3	trifolium
trigging	11	29	958	3	trigging
triglyph	17	4	167	3	triglyph
triliths	11	4	595	3	tri_liths
trillion	8	4	797	3	trillion
trillions	9	4	718	3	trillions
trillionth	13	6	297	3	trillionth
trillium	10	4	620	3	trillium
trimming	13	31	865	3	trimming
trindling	11	3	713	3	trindling
trining	8	29	1921	3	tri_ning
triplane	10	3	911	3	triplane
triplite	10	3	910	3	triplite
tripping	13	32	1092	3	tripping
tristich	13	4	842	3	tristich
trithing	12	28	1177	3	trithing
trolling	9	32	1249	3	trolling
trotline	8	3	1002	3	trotline
twilling	12	26	867	3	twilling
twirling	12	24	624	3	twirling

Search took 8 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.420	425454.8
2	DLD Change Limit	146162	82	7.440	19645.4
3	Display Results	82	82	0.063	1301.6
	(SQL Overall)	178691	82	7.923	22553.5