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

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

160 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
cooping	12	39	1893	(None)
comping	14	35	1859	1	comping
cooing	9	40	2492	1	coo_ing
cooking	14	38	1897	1	cooking
cooling	10	34	2257	1	cooling
coopting	13	34	1131	1	coopting
coping	11	39	2766	1	c_oping
copping	14	39	1859	1	copping
couping	12	43	1702	1	couping
hooping	13	36	1570	1	hooping
looping	10	36	1528	1	looping
pooping	12	36	1544	1	pooping
scooping	13	36	1063	1	scooping
blooping	13	24	884	2	blooping
boobing	12	36	1391	2	boobing
booing	9	45	2164	2	boo_ing
booking	14	36	1838	2	booking
booming	12	37	1622	2	booming
booting	10	38	2136	2	booting
boozing	19	40	1216	2	boozing
bopping	14	35	1203	2	bopping
camping	14	31	1897	2	camping
capping	14	38	1967	2	capping
carping	12	35	2108	2	carping
choking	17	39	1194	2	choking
chomping	18	33	988	2	chomping
choosing	14	20	1013	2	choosing
chopin	13	27	1218	2	chopin_
chopine	14	35	1226	2	chopine
chopins	14	23	1224	2	chopins
chopping	18	37	1026	2	chopping
choring	13	36	1766	2	choring
chowing	16	44	1277	2	chowing
cleping	12	33	1042	2	cleping
clomping	15	32	965	2	clomping
cloning	10	32	1547	2	cloning
clopping	15	35	1108	2	clopping
closing	10	31	1484	2	closing
cloying	13	35	1175	2	cloying
coaling	10	37	2282	2	coaling
coaming	12	38	1832	2	coaming
coapting	13	35	1160	2	coapting
coating	10	35	2530	2	coating
coaxing	17	35	1170	2	coaxing
cocking	16	36	1998	2	cocking
codding	12	40	1469	2	codding
coding	10	40	2479	2	c_oding
codling	11	44	1895	2	codling
coffing	16	38	1125	2	coffing
cogging	12	35	1371	2	cogging
coifing	13	32	1389	2	coifing
coiling	10	37	2345	2	coiling
coining	10	39	2054	2	coining
coking	13	45	2388	2	c_oking
coloring	11	4	1484	2	coloring
combing	14	37	1473	2	combing
coming	11	42	2545	2	c_oming
compting	15	30	1360	2	compting
coning	9	43	3182	2	c_oning
conking	14	36	1845	2	conking
conning	10	37	1875	2	conning
cooeeing	11	3	745	2	cooeeing
cooeying	14	3	814	2	cooeying
cookings	15	35	860	2	cookings
coopering	14	26	1132	2	coopering
copings	12	41	1184	2	c_opings
copying	15	34	1198	2	copying
cording	11	36	2082	2	cording
coring	9	44	3396	2	c_oring
corking	14	30	1882	2	corking
corning	10	37	2012	2	corning
coshing	13	43	1643	2	coshing
costing	10	43	2302	2	costing
cosying	13	45	1313	2	cosying
coting	9	46	2925	2	c_oting
coupling	13	3	1078	2	coupling
coving	12	43	2152	2	c_oving
cowing	12	45	2632	2	c_owing
cowling	13	40	1741	2	cowling
coxing	16	42	1886	2	c_oxing
coying	12	40	2148	2	c_oying
cozying	22	30	806	2	cozying
craping	12	40	1871	2	craping
creping	12	29	1365	2	creping
crooking	15	36	1134	2	crooking
crooning	11	31	1211	2	crooning
cropping	15	32	1088	2	cropping
crowing	13	38	1476	2	crowing
cupping	14	43	1238	2	cupping
dooming	11	31	1253	2	dooming
doping	10	39	1946	2	_doping
drooping	12	26	880	2	drooping
eloping	10	35	1283	2	eloping
fooling	11	31	1737	2	fooling
footing	11	50	1759	2	footing
fopping	15	35	1113	2	fopping
goofing	12	35	1063	2	goofing
goosing	9	33	1408	2	goosing
groping	11	33	1310	2	groping
hooding	12	38	1520	2	hooding
hoofing	14	39	1255	2	hoofing
hooking	15	37	1669	2	hooking
hooting	11	39	1987	2	hooting
hoping	12	37	1974	2	_hoping
hopping	15	41	1527	2	hopping
looing	7	36	2104	2	loo_ing
looking	12	34	1504	2	looking
looming	10	28	1485	2	looming
loosing	8	35	1596	2	loosing
looting	8	30	1964	2	looting
loping	9	39	2141	2	_loping
lopping	12	38	1522	2	lopping
louping	10	43	1398	2	louping
mooing	9	37	1837	2	moo_ing
mooning	10	34	1555	2	mooning
mooring	10	25	1444	2	mooring
mooting	10	30	1936	2	mooting
moping	11	40	1710	2	_moping
mopping	14	34	1147	2	mopping
nooning	8	30	1485	2	nooning
noosing	8	33	1505	2	noosing
oohing	10	44	1293	2	_oohing
oozing	16	38	1220	2	_oozing
oping	8	63	2241	2	__oping
poohing	13	31	1232	2	poohing
pooing	9	38	2068	2	poo_ing
pooling	10	32	1909	2	pooling
popping	11	37	1541	2	popping
romping	12	31	1303	2	romping
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
roping	9	40	2302	2	_roping
rouping	10	37	1579	2	rouping
scooting	11	30	1263	2	scooting
scoping	12	35	1382	2	scoping
scrooping	14	4	659	2	scrooping
sloping	10	41	1407	2	sloping
snooping	11	38	1132	2	snooping
soaping	10	36	1622	2	soaping
sooting	8	28	2095	2	sooting
sopping	12	39	1720	2	sopping
souping	10	42	1553	2	souping
stooping	11	30	1236	2	stooping
stoping	10	37	1662	2	stoping
swooping	14	33	840	2	swooping
tooling	8	29	1831	2	tooling
tooting	8	30	1942	2	tooting
toping	9	41	2299	2	_toping
topping	12	35	1462	2	topping
trooping	11	27	1027	2	trooping
whooping	17	28	663	2	whooping
wooding	12	30	1202	2	wooding
woofing	14	34	989	2	woofing
wooing	10	42	1466	2	woo_ing
woopsing	14	3	563	2	woopsing
zooming	19	26	965	2	zooming
zooning	17	29	1070	2	zooning

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.140	1276364.3
2	DLD Change Limit	107671	160	5.546	19414.2
3	Display Results	160	160	0.063	2539.7
	(SQL Overall)	178691	160	5.749	31082.1