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

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

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.

86 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
twining	11	32	1144	(None)
dwining	12	26	929	1	dwining
tining	7	49	2754	1	t_ining
trining	8	29	1921	1	trining
twinging	13	27	842	1	twinging
twinning	12	36	704	1	twinning
wining	10	36	2505	1	_wining
alining	8	19	1704	2	alining
awning	10	50	1339	2	aw_ning
brining	10	32	1647	2	brining
chining	13	33	1684	2	chining
coining	10	39	2054	2	coining
dining	8	45	2513	2	_dining
entwining	13	4	542	2	entwining
fining	10	42	2321	2	_fining
foining	11	30	1345	2	foining
gaining	9	40	1566	2	gaining
intwining	13	4	588	2	intwining
joining	15	30	1148	2	joining
lining	7	45	2680	2	_lining
mining	9	42	2545	2	_mining
opining	10	3	1174	2	opining
owning	10	41	1033	2	ow_ning
paining	10	39	2024	2	paining
peining	10	46	1915	2	peining
pining	9	37	2653	2	_pining
raining	8	39	2269	2	raining
reining	8	44	2532	2	reining
ruining	8	35	1488	2	ruining
saining	8	36	2139	2	saining
seining	8	40	2077	2	seining
shining	11	38	1652	2	shining
staining	9	4	1337	2	staining
swinging	13	34	1111	2	swinging
swinking	16	34	1032	2	swinking
swiping	13	31	982	2	swiping
swiving	14	35	895	2	swiving
tailing	8	29	2310	2	tailing
tainting	9	36	1358	2	tainting
tanning	8	36	1825	2	tanning
thinking	16	28	986	2	thinking
thinning	12	31	909	2	thinning
tiding	8	35	2009	2	t_iding
tieing	7	35	1876	2	t_ieing
tiling	7	34	2655	2	t_iling
timing	9	36	1930	2	t_iming
tinging	9	36	1946	2	t_inging
tinning	8	31	1728	2	tinning
tinting	8	46	2060	2	t_inting
tiring	7	40	2309	2	t_iring
toiling	8	32	1902	2	toiling
toiting	8	32	1709	2	toiting
toning	7	40	2579	2	t_oning
training	9	30	1586	2	training
tricing	10	34	1735	2	tricing
tuning	7	40	1684	2	t_uning
tunning	8	35	1445	2	tunning
turning	8	37	1318	2	turning
twanging	13	28	706	2	twanging
twigging	14	30	567	2	twigging
twilling	12	26	867	2	twilling
twingeing	14	14	339	2	twingeing
twinier	10	3	731	2	twinier
twinkling	17	4	364	2	twinkling
twinnings	13	25	366	2	twinnings
twirling	12	24	624	2	twirling
twisting	12	42	781	2	twisting
twitting	12	30	722	2	twitting
tyning	10	55	1041	2	t_yning
untwining	13	4	630	2	untwining
veining	11	47	1389	2	veining
vining	10	46	1946	2	_vining
waning	10	36	2380	2	_waning
whining	14	33	1167	2	whining
wifing	13	35	1339	2	_wifing
wiling	10	30	2429	2	_wiling
wincing	13	34	1390	2	_wincing
winding	12	35	1791	2	_winding
winging	12	37	1871	2	_winging
winking	15	33	1796	2	_winking
winning	11	35	1655	2	_winning
wiping	12	39	1671	2	_wiping
wiring	10	45	2102	2	_wiring
wising	10	33	1822	2	_wising
witing	10	35	2282	2	_witing
wiving	13	33	1660	2	_wiving

Search took 4 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	107671	0.123	1452772.4
2	DLD Change Limit	107671	86	3.080	34958.1
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	3.233	55271.0