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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

109 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
tilde	6	50	1734	(None)
tide	5	52	3737	1	ti_de
tildes	7	45	1396	1	tildes
tile	4	54	5144	1	til_e
tiled	6	48	3294	1	tiled
aide	5	60	4499	2	ai_de
ailed	6	62	4028	2	ailed
bide	7	60	4148	2	bi_de
bile	6	61	4718	2	bil_e
bilge	8	76	1891	2	bilge
childe	12	47	1121	2	childe
dildo	7	19	1177	2	dildo
dildoe	8	19	867	2	dildoe
diode	7	47	1611	2	diode
eide	5	58	3223	2	ei_de
elide	6	49	2264	2	elide
file	7	54	4664	2	fil_e
filed	9	53	3190	2	filed
fille	8	43	2740	2	fille
gild	6	55	2651	2	gild_
gilded	9	44	1322	2	gilded
gilder	8	44	1553	2	gilder
gilds	7	54	1752	2	gilds
glide	7	45	2159	2	glide
hide	8	51	3463	2	hi_de
idle	5	54	2376	2	_idle
mild	7	53	3085	2	mild_
milded	10	44	1615	2	milded
milden	9	41	1315	2	milden
milder	9	38	1845	2	milder
mildew	12	31	904	2	mildew
milds	8	64	2205	2	milds
mile	6	63	5257	2	mil_e
mille	7	50	2913	2	mille
nide	5	55	3578	2	ni_de
oiled	6	44	2947	2	oiled
pile	6	56	4969	2	pil_e
piled	8	52	3299	2	piled
ride	5	59	4512	2	ri_de
rile	4	56	5053	2	ril_e
riled	6	58	3325	2	riled
rille	5	57	2873	2	rille
side	5	54	4448	2	si_de
sidle	6	51	2403	2	sidle
sild	5	50	3058	2	sild_
silds	6	55	2052	2	silds
slide	6	47	2541	2	slide
stile	5	49	3157	2	stil_e
tailed	7	44	2466	2	tailed
taille	6	31	1692	2	taille
tale	4	61	5416	2	tal_e
telae	5	43	2329	2	telae
tele	4	50	4087	2	tel_e
tided	7	63	2251	2	ti_ded
tides	6	48	3015	2	ti_des
tidy	8	68	2241	2	ti_dy
tie	3	65	5753	2	ti__e
tied	5	55	3521	2	tied_
tike	8	55	3448	2	ti_ke
til	3	63	5026	2	til__
tilak	9	10	1155	2	tilak
tiler	5	61	3102	2	tiler
tiles	5	55	4210	2	tiles
till	4	59	4120	2	til_l
tilled	7	47	2295	2	tilled
tiller	6	42	2254	2	tiller
tills	5	46	3171	2	tills
tils	4	57	3961	2	til_s
tilt	4	62	5242	2	til_t
tilted	7	46	1686	2	tilted
tilter	6	34	1769	2	tilter
tilth	8	55	1536	2	tilth
tilts	5	53	2561	2	tilts
time	6	62	3501	2	ti_me
timed	8	52	2361	2	timed
tinder	7	38	2180	2	tinder
tine	4	58	5513	2	ti_ne
tined	6	54	3453	2	tined
tinge	6	46	2662	2	tinge
tirade	7	3	1169	2	tirade
tire	4	61	4335	2	ti_re
tired	6	52	2890	2	tired
tirled	7	47	1436	2	tirled
tithe	8	53	1970	2	tithe
title	5	47	2107	2	title
titled	7	38	1500	2	titled
titre	5	46	1939	2	titre
toile	5	46	2649	2	toil_e
toiled	7	44	2032	2	toiled
told	5	61	3220	2	told_
tole	4	60	5290	2	tol_e
toled	6	59	3492	2	toled
trade	6	50	2604	2	trade
triode	7	53	1189	2	triode
trode	6	53	2285	2	trode
tsade	6	43	1112	2	tsade
tuille	6	30	1264	2	tuille
tule	4	57	3587	2	tul_e
tulle	5	40	1993	2	tulle
utile	5	47	1893	2	util_e
vide	8	54	3275	2	vi_de
vile	7	61	3980	2	vil_e
wide	8	52	3540	2	wi_de
wild	8	51	2651	2	wild_
wilded	11	37	1450	2	wilded
wilder	10	36	1647	2	wilder
wilds	9	48	1820	2	wilds
wile	7	59	4437	2	wil_e
wiled	9	52	3155	2	wiled

Search took 2 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	53800	0.313	570897.8
2	DLD Change Limit	53800	109	1.406	38264.6
3	Display Results	109	109	0.016	6812.5
	(SQL Overall)	178691	109	1.735	102991.9