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

Here are the results of your fuzzy-string dictionary search for “romping” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

117 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
romping	12	31	1303	(None)
comping	14	35	1859	1	comping
ramping	12	33	1687	1	ramping
roping	9	40	2302	1	ro_ping
rouping	10	37	1579	1	rouping
tromping	13	31	960	1	tromping
amping	11	43	1757	2	_amping
bombing	14	32	1139	2	bombing
bopping	14	35	1203	2	bopping
bumping	14	38	1249	2	bumping
camping	14	31	1897	2	camping
chomping	18	33	988	2	chomping
clomping	15	32	965	2	clomping
combing	14	37	1473	2	combing
coming	11	42	2545	2	com_ing
compting	15	30	1360	2	compting
cooping	12	39	1893	2	cooping
coping	11	39	2766	2	co_ping
copping	14	39	1859	2	copping
couping	12	43	1702	2	couping
cramping	15	34	1185	2	cramping
crimping	15	29	978	2	crimping
cropping	15	32	1088	2	cropping
crumping	15	31	990	2	crumping
damping	13	34	1400	2	damping
doming	10	42	1839	2	dom_ing
doping	10	39	1946	2	do_ping
drooping	12	26	880	2	drooping
dropping	14	30	928	2	dropping
dumping	13	37	1291	2	dumping
fopping	15	35	1113	2	fopping
gimping	13	37	1076	2	gimping
groping	11	33	1310	2	gro_ping
grouping	12	30	853	2	grouping
grumping	14	26	690	2	grumping
homing	12	37	1838	2	hom_ing
hooping	13	36	1570	2	hooping
hoping	12	37	1974	2	ho_ping
hopping	15	41	1527	2	hopping
humping	15	32	1307	2	humping
imping	11	43	1535	2	_imping
jumping	19	31	980	2	jumping
lamping	12	31	1600	2	lamping
limping	12	46	1411	2	limping
looping	10	36	1528	2	looping
loping	9	39	2141	2	lo_ping
lopping	12	38	1522	2	lopping
louping	10	43	1398	2	louping
lumping	12	33	1464	2	lumping
moping	11	40	1710	2	mo_ping
mopping	14	34	1147	2	mopping
mumping	14	34	1163	2	mumping
oping	8	63	2241	2	_o_ping
pimping	14	38	1212	2	pimping
pooping	12	36	1544	2	pooping
popping	11	37	1541	2	popping
primping	15	33	889	2	primping
promoing	13	3	1046	2	promoing
prompting	16	3	720	2	prompting
propping	12	28	1167	2	propping
pumping	14	42	1355	2	pumping
ramming	12	31	1506	2	ramming
raping	9	48	2985	2	r_aping
rapping	12	36	1910	2	rapping
rasping	10	43	1625	2	rasping
reaping	10	36	2121	2	reaping
repping	12	33	1498	2	repping
riming	9	33	2222	2	rim_ing
rimming	12	34	1107	2	rimming
rimpling	13	21	966	2	rimpling
riping	9	38	2161	2	r_iping
ripping	12	33	1574	2	ripping
roaming	10	32	1579	2	roaming
roaring	8	29	1600	2	roaring
robbing	12	33	1321	2	robbing
robing	9	36	1800	2	ro_bing
rocking	14	36	1963	2	rocking
rodding	10	38	1453	2	rodding
roguing	9	30	956	2	roguing
roiling	8	32	2045	2	roiling
rolfing	11	37	1065	2	rolfing
rolling	8	36	2041	2	rolling
romaine	9	5	1212	2	romaine
rompingly	17	4	503	2	rompingly
rompish	14	3	669	2	rompish
roofing	11	38	1435	2	roofing
rooking	12	35	1736	2	rooking
rooming	10	41	1704	2	rooming
roosing	8	40	1813	2	roosing
rooting	8	35	2243	2	rooting
rosing	7	39	2559	2	ro_sing
rotting	8	29	1968	2	rotting
rouging	9	31	1470	2	rouging
rousing	8	39	2055	2	rousing
routing	8	38	2109	2	routing
roving	10	36	1874	2	ro_ving
rowing	10	36	2330	2	ro_wing
rumpling	13	17	876	2	rumpling
soaping	10	36	1622	2	soaping
sopping	12	39	1720	2	sopping
souping	10	42	1553	2	souping
stomping	13	30	976	2	stomping
tamping	12	28	1581	2	tamping
temping	12	27	1069	2	temping
tombing	12	33	1053	2	tombing
tomming	12	35	924	2	tomming
toping	9	41	2299	2	to_ping
topping	12	35	1462	2	topping
tramping	13	27	1127	2	tramping
trooping	11	27	1028	2	trooping
trouping	11	24	950	2	trouping
trumping	13	30	873	2	trumping
tumping	12	31	1424	2	tumping
umping	11	48	1533	2	_umping
vamping	15	28	1023	2	vamping
whomping	19	28	594	2	whomping
wimping	15	39	1101	2	wimping

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.360	496363.9
2	DLD Change Limit	107671	117	2.906	37051.3
3	Display Results	117	117	0.046	2543.5
	(SQL Overall)	178691	117	3.312	53952.6