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

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

112 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
showing	14	38	1466	(None)
chowing	16	44	1277	1	chowing
scowing	13	38	1209	1	scowing
shawing	14	35	1488	1	shawing
shewing	14	38	1219	1	shewing
shoeing	11	32	1188	1	shoeing
shooing	11	21	1291	1	shooing
shoring	11	28	2007	1	shoring
shoving	14	29	1064	1	shoving
showings	15	24	688	1	showings
showring	15	4	832	1	showring
slowing	11	28	1474	1	slowing
snowing	11	39	1345	1	snowing
sowing	10	42	2291	1	s_owing
stowing	11	33	1513	1	stowing
avowing	14	6	660	2	avowing
blowing	13	38	1305	2	blowing
bowing	12	47	2306	2	_bowing
chawing	16	48	1303	2	chawing
chewing	16	39	1114	2	chewing
choking	17	39	1194	2	choking
choring	13	36	1766	2	choring
chowsing	17	21	734	2	chowsing
cowing	12	45	2632	2	_cowing
crowing	13	38	1476	2	crowing
dowing	11	42	2151	2	_dowing
flowing	14	34	1176	2	flowing
glowing	12	32	1179	2	glowing
growing	12	35	1247	2	growing
hawing	13	43	2235	2	_hawing
hewing	13	45	1424	2	_hewing
hoeing	10	41	1702	2	_hoeing
hoking	14	44	1951	2	_hoking
holing	10	40	2507	2	_holing
homing	12	37	1838	2	_homing
honing	10	34	2150	2	_honing
hoping	12	37	1974	2	_hoping
hosing	10	34	2110	2	_hosing
howking	18	36	1031	2	_howking
howling	14	34	1316	2	_howling
jowing	17	42	1604	2	_jowing
knowing	15	28	768	2	knowing
lowing	10	46	2327	2	_lowing
meowing	13	6	859	2	meowing
mowing	12	41	1909	2	_mowing
owing	9	62	2272	2	__owing
phoning	13	3	1205	2	phoning
plowing	13	31	1172	2	plowing
pshawing	17	3	352	2	pshawing
reshowing	16	4	663	2	reshowing
rowing	10	36	2330	2	_rowing
sawing	10	43	2381	2	s_awing
scoping	12	35	1382	2	scoping
scoring	10	31	1721	2	scoring
scowling	14	5	829	2	scowling
sewing	10	38	1962	2	s_ewing
shading	12	31	1556	2	shading
shadowing	17	4	426	2	shadowing
shaking	15	33	1725	2	shaking
shaming	13	30	1674	2	shaming
shaping	13	31	1618	2	shaping
sharing	11	37	2324	2	sharing
shaving	14	34	1433	2	shaving
shawling	15	5	822	2	shawling
shining	11	38	1652	2	shining
shoaling	12	31	1175	2	shoaling
shocking	18	43	1154	2	shocking
shogging	14	30	802	2	shogging
shooling	12	30	1256	2	shooling
shooting	12	28	1286	2	shooting
shopping	16	36	1129	2	shopping
shorings	12	26	948	2	shorings
shorting	12	25	1480	2	shorting
shotting	12	30	1238	2	shotting
shouting	12	27	1179	2	shouting
showering	16	4	640	2	showering
showier	13	3	910	2	showier
showily	16	3	622	2	showily
shown	11	52	1648	2	show_n_
showrings	16	4	406	2	showrings
shrewing	15	22	809	2	shrewing
shuting	11	32	1205	2	shuting
shying	13	42	1184	2	sh_ying
skewing	15	31	872	2	skewing
slewing	11	33	1135	2	slewing
sloping	10	41	1407	2	sloping
smoking	14	32	1052	2	smoking
snawing	11	36	1248	2	snawing
snoring	8	39	1720	2	snoring
soling	7	42	2682	2	s_oling
sooting	8	28	2096	2	sooting
soring	7	47	3188	2	s_oring
spewing	13	31	1045	2	spewing
spoking	14	32	1222	2	spoking
sporing	10	43	1941	2	sporing
stewing	11	34	1249	2	stewing
stoking	12	36	1559	2	stoking
stoning	8	37	1744	2	stoning
stoping	10	37	1662	2	stoping
storing	8	39	2112	2	storing
strowing	12	23	1056	2	strowing
swing	9	61	2484	2	s__wing
thawing	14	37	868	2	thawing
tholing	11	28	1233	2	tholing
thouing	11	25	860	2	thouing
throwing	15	3	672	2	throwing
towing	10	38	2319	2	_towing
trowing	11	34	1370	2	trowing
vowing	13	37	1527	2	_vowing
whoring	14	29	1029	2	whoring
wowing	13	39	1539	2	_wowing
yowing	13	37	1554	2	_yowing

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	112	3.720	28943.8
3	Display Results	112	112	0.046	2434.8
	(SQL Overall)	178691	112	4.156	42995.9