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

Here are the results of your fuzzy-string dictionary search for “lapsing” 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
lapsing	10	35	1116	(None)
elapsing	11	4	671	1	elapsing
lapping	12	41	1702	1	lapping
lapwing	13	30	826	1	lapwing
lasing	7	47	2798	1	la_sing
aping	8	73	2723	2	_ap_ing
basing	9	54	2766	2	ba_sing
capping	14	38	1967	2	capping
casing	9	48	2910	2	ca_sing
causing	10	36	1441	2	causing
clapping	15	38	1060	2	clapping
clasping	13	33	1026	2	clasping
classing	11	32	1179	2	classing
dapping	13	37	1479	2	dapping
easing	7	49	2646	2	ea_sing
flapping	16	29	815	2	flapping
gaping	10	56	1892	2	gap_ing
gapping	13	42	1478	2	gapping
gasping	11	37	1436	2	gasping
gassing	9	42	1633	2	gassing
glassing	10	32	997	2	glassing
happing	15	38	1723	2	happing
hasping	13	44	1490	2	hasping
japing	16	50	1357	2	jap_ing
lacing	9	46	2623	2	la_cing
lacking	14	38	2154	2	lacking
lading	8	42	2712	2	la_ding
ladling	9	28	1339	2	ladling
lagging	10	33	1673	2	lagging
lairing	8	37	1534	2	lairing
laking	11	50	2704	2	la_king
lalling	8	35	1962	2	lalling
lambing	12	34	1241	2	lambing
laming	9	45	2836	2	la_ming
lamming	12	30	1458	2	lamming
lamping	12	31	1600	2	lamping
lancing	10	33	1412	2	lancing
landing	9	28	1932	2	landing
lapin	7	52	2292	2	lap_in_
lapins	8	45	2068	2	lap_ins
lapwings	14	27	497	2	lapwings
larding	9	29	1787	2	larding
larking	12	37	1825	2	larking
lashing	11	44	2289	2	lashing
lassoing	9	4	638	2	lassoing
lasting	8	47	2524	2	lasting
lathing	11	43	1569	2	lathing
lauding	9	32	1190	2	lauding
laving	10	46	2357	2	la_ving
lawing	10	46	2528	2	la_wing
laying	10	45	2570	2	la_ying
lazing	16	48	2147	2	la_zing
lazying	20	4	667	2	lazying
leaping	10	32	1599	2	leap_ing
leasing	8	39	2016	2	leasing
lensing	8	40	1510	2	lensing
liaising	9	3	791	2	liaising
lipping	12	30	1607	2	lipping
lisping	10	34	1275	2	lisping
loosing	8	35	1596	2	loosing
loping	9	39	2141	2	lop_ing
lopping	12	38	1522	2	lopping
losing	7	40	2287	2	l_osing
lousing	8	38	1773	2	lousing
lysing	10	47	1044	2	l_ysing
mapping	14	34	1399	2	mapping
massing	10	43	1802	2	massing
napping	12	35	1418	2	napping
parsing	10	38	1955	2	parsing
passing	10	43	1842	2	passing
pausing	10	39	1281	2	pausing
raising	8	32	2053	2	raising
raping	9	48	2985	2	rap_ing
rapping	12	36	1910	2	rapping
rasing	7	43	3083	2	ra_sing
rasping	10	43	1625	2	rasping
relapsing	12	3	684	2	relapsing
sapling	10	32	1786	2	sapling
sapping	12	35	1931	2	sapping
sassing	8	46	1555	2	sassing
slapping	13	35	1083	2	slapping
taping	9	42	2239	2	tap_ing
tapping	12	33	1713	2	tapping
tawsing	11	3	867	2	tawsing
wapping	15	35	1460	2	wapping
yapping	15	34	1261	2	yapping
zapping	21	32	1147	2	zapping

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.376	475242.0
2	DLD Change Limit	107671	87	5.016	21465.5
3	Display Results	87	87	0.046	1891.3
	(SQL Overall)	178691	87	5.438	32859.7