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

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

80 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
lapwing	13	30	826	(None)
lapping	12	41	1702	1	lapping
lapsing	10	35	1116	1	lapsing
lapwings	14	27	497	1	lapwings
lawing	10	46	2528	1	la_wing
aping	8	73	2723	2	_ap_ing
awing	9	68	2732	2	_a_wing
batwing	13	50	981	2	batwing
blawing	13	40	1275	2	bla_wing
capping	14	38	1967	2	capping
cawing	12	43	2261	2	ca_wing
clapping	15	38	1060	2	clapping
clawing	13	38	1267	2	cla_wing
dapping	13	37	1479	2	dapping
dawing	11	48	1982	2	da_wing
elapsing	11	4	671	2	elapsing
flapping	16	29	815	2	flapping
flawing	14	38	1256	2	fla_wing
gaping	10	56	1892	2	gap_ing
gapping	13	42	1478	2	gapping
gawping	14	41	846	2	gawping
happing	15	38	1723	2	happing
hawing	13	43	2235	2	ha_wing
japing	16	50	1357	2	jap_ing
jawing	17	44	1496	2	ja_wing
lacewing	14	3	584	2	lacewing
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
larding	9	29	1787	2	larding
larking	12	37	1825	2	larking
lashing	11	44	2289	2	lashing
lasing	7	47	2798	2	la_sing
lasting	8	47	2524	2	lasting
lathing	11	43	1569	2	lathing
lauding	9	32	1190	2	lauding
lauwine	10	3	637	2	lauwine
laving	10	46	2357	2	la_ving
lawine	9	33	1646	2	la_wine
lawings	11	36	1147	2	la_wings
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
lipping	12	30	1607	2	lipping
loping	9	39	2141	2	lop_ing
lopping	12	38	1522	2	lopping
lowing	10	46	2327	2	l_owing
mapping	14	34	1399	2	mapping
mawing	12	40	2080	2	ma_wing
napping	12	35	1418	2	napping
pawing	12	45	1955	2	pa_wing
raping	9	48	2985	2	rap_ing
rapping	12	36	1910	2	rapping
sapling	10	32	1786	2	sapling
sapping	12	35	1931	2	sapping
sawing	10	43	2381	2	sa_wing
slapping	13	35	1083	2	slapping
taping	9	42	2239	2	tap_ing
tapping	12	33	1713	2	tapping
tawing	10	45	2155	2	ta_wing
wapping	15	35	1460	2	wapping
waxwing	21	5	472	2	waxwing
yapping	15	34	1261	2	yapping
yawing	13	42	1561	2	ya_wing
yawping	16	35	733	2	yawping
zapping	21	32	1147	2	zapping

Search took 5 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	80	4.000	26917.8
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	4.423	40400.4