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

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

84 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
temping	12	27	1069	(None)
tamping	12	28	1581	1	tamping
tempting	13	5	734	1	tempting
tumping	12	31	1424	1	tumping
amping	11	43	1757	2	_amping
beeping	12	40	1391	2	beeping
bumping	14	38	1249	2	bumping
camping	14	31	1897	2	camping
comping	14	35	1859	2	comping
damping	13	34	1400	2	damping
demoing	11	3	1175	2	demoing
dumping	13	37	1291	2	dumping
gemming	13	28	915	2	gemming
gimping	13	37	1076	2	gimping
heaping	13	30	1585	2	heaping
helping	13	35	1222	2	helping
hemming	15	26	997	2	hemming
humping	15	32	1307	2	humping
imping	11	43	1535	2	_imping
iteming	10	3	775	2	item_ing
jeeping	17	40	1033	2	jeeping
jumping	19	31	980	2	jumping
keeping	14	40	1254	2	keeping
kelping	14	31	919	2	kelping
kepping	16	26	859	2	kepping
lamping	12	31	1600	2	lamping
leaping	10	32	1599	2	leaping
lemming	12	26	939	2	lemming
limping	12	46	1411	2	limping
lumping	12	33	1464	2	lumping
mumping	14	34	1163	2	mumping
peeping	12	36	1521	2	peeping
pepping	11	35	1162	2	pepping
pimping	14	38	1212	2	pimping
pumping	14	42	1355	2	pumping
ramping	12	33	1687	2	ramping
reaping	10	36	2121	2	reaping
repping	12	33	1498	2	repping
romping	12	31	1303	2	romping
seeping	10	38	1791	2	seeping
stamping	13	33	1096	2	stamping
steeping	11	34	1258	2	steeping
stemming	13	40	820	2	stemming
stepping	13	32	907	2	stepping
stomping	13	30	976	2	stomping
stumping	13	28	908	2	stumping
taming	9	40	2343	2	tam_ing
taping	9	42	2239	2	t_aping
tapping	12	33	1713	2	tapping
teaming	10	39	1759	2	teaming
tearing	8	40	2149	2	tearing
teasing	8	39	1851	2	teasing
tedding	10	32	1088	2	tedding
teeing	7	39	1697	2	te_eing
teeming	10	35	1309	2	teeming
telling	8	33	2108	2	telling
tempering	14	3	873	2	tempering
tempi	9	49	1220	2	tempi__
tending	9	44	1916	2	tending
tenpin	8	3	1058	2	tenpin_
tenpins	9	4	1007	2	tenpins
tensing	8	46	1665	2	tensing
tenting	8	46	2115	2	tenting
terming	10	40	1600	2	terming
testing	8	60	2105	2	testing
tewing	10	39	1482	2	te_wing
theming	13	36	1047	2	them_ing
thumping	16	29	671	2	thumping
timing	9	36	1930	2	tim_ing
tipping	12	28	1497	2	tipping
tombing	12	33	1053	2	tombing
tomming	12	35	924	2	tomming
toping	9	41	2299	2	t_oping
topping	12	35	1462	2	topping
tramping	13	27	1127	2	tramping
tromping	13	31	960	2	tromping
trumping	13	30	873	2	trumping
tupping	12	34	1166	2	tupping
typing	12	41	1058	2	t_yping
umping	11	48	1533	2	_umping
vamping	15	28	1023	2	vamping
weeping	13	36	1367	2	weeping
wimping	15	39	1101	2	wimping
yelping	13	31	787	2	yelping

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.376	475242.0
2	DLD Change Limit	107671	84	3.046	35348.3
3	Display Results	84	84	0.030	2800.0
	(SQL Overall)	178691	84	3.452	51764.5