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

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

91 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
lifting	11	33	1327	(None)
gifting	12	38	1089	1	gifting
lilting	8	35	1538	1	lilting
linting	8	38	2098	1	linting
listing	8	40	2059	1	listing
lofting	11	33	1131	1	lofting
rifting	11	35	1500	1	rifting
sifting	11	30	1459	1	sifting
airting	8	36	1630	2	airting
biffing	16	35	1001	2	biffing
biting	9	53	2182	2	bi_ting
bitting	10	37	1729	2	bitting
citing	9	42	2018	2	ci_ting
clefting	14	34	758	2	clefting
dieting	9	36	1683	2	dieting
dinting	9	35	2055	2	dinting
drifting	13	33	873	2	drifting
fifing	13	42	1234	2	fif_ing
fisting	11	38	1812	2	fisting
fitting	11	35	1656	2	fitting
flinting	12	34	1234	2	flinting
flirting	12	31	901	2	flirting
fliting	11	35	1461	2	fli_ting
flitting	12	30	1088	2	flitting
girting	9	31	1333	2	girting
gitting	9	32	1570	2	gitting
glinting	10	32	1005	2	glinting
grifting	13	29	926	2	grifting
hafting	14	40	1417	2	hafting
hefting	14	45	1091	2	hefting
hilting	11	33	1689	2	hilting
hinting	11	39	1922	2	hinting
histing	11	37	2037	2	histing
hitting	11	30	1727	2	hitting
jilting	15	32	1174	2	jilting
kilting	12	32	1385	2	kilting
kiting	11	41	1709	2	ki_ting
kitting	12	32	1444	2	kitting
lasting	8	47	2524	2	lasting
leftwing	15	3	297	2	leftwing
letting	8	32	1853	2	letting
lichting	14	26	851	2	lichting
licking	14	41	1828	2	licking
lidding	10	36	1143	2	lidding
ligating	10	22	1228	2	ligating
lighting	13	28	1183	2	lighting
liking	11	43	1958	2	li_king
limbing	12	34	1042	2	limbing
liming	9	40	2124	2	li_ming
limiting	11	3	881	2	limiting
limning	10	37	1032	2	limning
limping	12	46	1411	2	limping
lining	7	45	2680	2	li_ning
linking	12	38	1825	2	linking
lipping	12	30	1607	2	lipping
lisping	10	34	1275	2	lisping
listings	9	33	1004	2	listings
living	10	43	1832	2	li_ving
looting	8	30	1964	2	looting
lotting	8	29	1775	2	lotting
louting	8	37	1938	2	louting
luffing	14	33	1010	2	luffing
lunting	8	38	1774	2	lunting
lusting	8	36	1932	2	lusting
luting	7	52	2175	2	l_uting
miffing	16	29	840	2	miffing
milting	10	36	1912	2	milting
minting	10	30	2081	2	minting
misting	10	36	2338	2	misting
pitting	10	36	1887	2	pitting
rafting	11	38	1575	2	rafting
riffing	14	40	1127	2	riffing
rifling	11	28	1501	2	rifling
rioting	8	27	1639	2	rioting
shifting	15	29	1038	2	shifting
siftings	12	23	658	2	siftings
silting	8	33	2048	2	silting
siting	7	41	2662	2	si_ting
sitting	8	35	1963	2	sitting
slitting	9	30	1258	2	slitting
tiffing	14	33	938	2	tiffing
tilting	8	34	1710	2	tilting
tinting	8	46	2060	2	tinting
tufting	11	28	987	2	tufting
uplifting	15	3	496	2	uplifting
wafting	14	39	1166	2	wafting
wifing	13	35	1339	2	wif_ing
wilting	11	35	1591	2	wilting
wisting	11	35	1974	2	wisting
witing	10	35	2282	2	wi_ting
witting	11	34	1706	2	witting

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.390	458182.1
2	DLD Change Limit	107671	91	4.970	21664.2
3	Display Results	91	91	0.030	3033.3
	(SQL Overall)	178691	91	5.390	33152.3