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

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

87 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
alining	8	19	1704	(None)
aliening	9	15	1089	1	aliening
aligning	10	15	853	1	aligning
lining	7	45	2680	1	_lining
abiding	11	5	1050	2	abiding
aiding	8	44	2361	2	a_iding
ailing	7	43	3101	2	a_iling
aiming	9	43	2084	2	a_iming
airing	7	49	2750	2	a_iring
alanin	6	3	1727	2	alanin_
alanine	7	3	1686	2	alanine
alanins	7	3	1580	2	alanins
aliasing	9	3	1007	2	aliasing
alibiing	11	3	532	2	alibiing
allying	11	30	1166	2	allying
arising	8	36	1997	2	arising
asinine	7	3	1072	2	asinine
atoning	8	35	1487	2	atoning
awning	10	50	1339	2	a_wning
blinding	12	32	1016	2	blinding
blinking	15	35	1062	2	blinking
brining	10	32	1647	2	brining
bylining	14	4	601	2	bylining
cabining	13	3	864	2	cabining
calcining	14	4	781	2	calcining
chining	13	33	1684	2	chining
clinging	12	29	1091	2	clinging
clinking	15	36	1166	2	clinking
cloning	10	32	1547	2	cloning
coining	10	39	2055	2	coining
dining	8	45	2513	2	_dining
dwining	12	26	929	2	dwining
eliding	9	34	1434	2	eliding
eloining	9	3	1044	2	eloining
fining	10	42	2321	2	_fining
flinging	13	33	1005	2	flinging
flinting	12	34	1234	2	flinting
fliting	11	35	1461	2	fliting
foining	11	30	1345	2	foining
gaining	9	40	1566	2	gaining
gliding	10	39	1184	2	gliding
gliming	11	33	1013	2	gliming
glinting	10	32	1005	2	glinting
joining	15	30	1148	2	joining
kilning	12	28	902	2	kilning
lairing	8	37	1534	2	lairing
liking	11	43	1958	2	_liking
liming	9	40	2124	2	_liming
limning	10	37	1032	2	_limning
linin	5	80	2552	2	_linin_
linings	8	43	1307	2	_linings
linins	6	59	2214	2	_linins
linking	12	38	1825	2	_linking
linting	8	38	2098	2	_linting
living	10	43	1832	2	_living
maligning	13	14	558	2	maligning
mining	9	42	2545	2	_mining
opining	10	3	1174	2	opining
paining	10	39	2024	2	paining
patining	11	3	1230	2	patining
peining	10	46	1915	2	peining
pining	9	37	2653	2	_pining
plaining	11	39	1155	2	plaining
planing	10	34	1825	2	planing
plinking	15	36	1124	2	plinking
raining	8	39	2269	2	raining
ravining	12	26	969	2	ravining
reining	8	44	2532	2	reining
relining	9	32	1874	2	relining
ruining	8	35	1488	2	ruining
saining	8	36	2139	2	saining
seining	8	40	2077	2	seining
shining	11	38	1652	2	shining
slicing	10	35	1464	2	slicing
sliding	9	31	1455	2	sliding
sliming	10	29	1395	2	sliming
slinging	10	33	1286	2	slinging
slinking	13	34	1298	2	slinking
sliping	10	33	1441	2	sliping
splining	11	3	1077	2	splining
tining	7	49	2754	2	_tining
trining	8	29	1921	2	trining
twining	11	32	1144	2	twining
veining	11	47	1389	2	veining
vining	10	46	1946	2	_vining
whining	14	33	1167	2	whining
wining	10	36	2505	2	_wining

Search took 6 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.360	496363.9
2	DLD Change Limit	107671	87	5.250	20508.8
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	5.640	31682.8