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

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

120 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
shiners	10	40	1594	(None)
seiners	7	42	1927	1	seiners
shiers	9	49	2175	1	shi_ers
shiner	9	38	2087	1	shiner_
shines	9	50	2891	1	shine_s
shivers	13	37	1483	1	shivers
whiners	13	40	1157	1	whiners
aliners	7	47	1772	2	aliners
ashiness	11	3	896	2	ashiness
biners	8	50	2363	2	_biners
briners	9	43	1563	2	briners
chiders	13	53	1294	2	chiders
chimers	14	45	1514	2	chimers
chines	11	50	2917	2	chine_s
coiners	9	36	2075	2	coiners
diners	7	55	2595	2	_diners
gainers	8	42	1459	2	gainers
hiders	10	49	1965	2	_hiders
hikers	13	50	1435	2	_hikers
hinders	11	37	1850	2	_hinders
hingers	11	34	2021	2	_hingers
hinters	10	37	1958	2	_hinters
hirers	9	45	1806	2	_hirers
honers	9	43	2497	2	_honers
joiners	14	42	1157	2	joiners
liners	6	54	2885	2	_liners
miners	8	41	2663	2	_miners
ruiners	7	42	1302	2	ruiners
sailers	7	38	2232	2	sailers
seiner	6	46	2248	2	seiner_
seines	6	50	2990	2	seine_s
seisers	7	38	1639	2	seisers
seizers	16	41	1250	2	seizers
shaders	11	59	1555	2	shaders
shakers	14	40	1556	2	shakers
shapers	12	40	1689	2	shapers
sharers	10	47	2062	2	sharers
shavers	13	41	1509	2	shavers
sheers	9	43	2240	2	sh_eers
shewers	13	43	1205	2	shewers
shickers	17	30	1282	2	shickers
shiels	9	54	1892	2	shi_els
shier	8	54	2894	2	shi_er_
shies	8	61	3655	2	shi_e_s
shifters	14	31	986	2	shifters
shikars	14	3	618	2	shikars
shikkers	14	32	652	2	shikkers
shimmers	15	26	941	2	shimmers
shindys	14	31	413	2	shindys
shine	8	55	3309	2	shine__
shined	10	46	2078	2	shine_d
shinglers	13	24	644	2	shinglers
shinier	10	41	1314	2	shinier_
shinnery	14	30	567	2	shinnery
shinneys	14	27	509	2	shinneys
shins	8	51	3104	2	shin__s
shippers	15	30	1231	2	shippers
shires	9	52	2557	2	shire_s
shirkers	15	31	958	2	shirkers
shirrs	9	44	1317	2	shi_rrs
shiver	12	45	1737	2	shiver_
shivery	16	31	702	2	shivery
shives	12	49	2141	2	shive_s
shoers	9	45	1833	2	sh_oers
shovers	13	46	1300	2	shovers
showers	13	46	1268	2	showers
shrines	10	46	1869	2	shrine_s
shrinkers	16	20	538	2	shrinkers
shrivers	14	41	910	2	shrivers
shunners	11	31	774	2	shunners
shunters	11	32	1075	2	shunters
shyers	12	47	1220	2	sh_yers
shyness	13	4	499	2	shyness
signers	8	47	1444	2	signers
sines	5	59	5482	2	s_ine_s
sinews	9	42	1062	2	s_inews
singers	8	38	2470	2	s_ingers
sinkers	11	36	1854	2	s_inkers
sinners	7	40	1902	2	sinners
sinters	7	40	2408	2	s_inters
sivers	9	53	2415	2	s_ivers
sizers	15	52	1581	2	s_izers
skiers	10	47	1370	2	ski_ers
skinkers	11	29	818	2	skinkers
skinners	12	34	729	2	skinners
skivers	14	40	970	2	skivers
slicers	9	41	1492	2	slicers
sliders	8	35	1522	2	sliders
slingers	9	37	1268	2	slingers
slivers	10	41	1525	2	slivers
smilers	9	41	1385	2	smilers
smiters	9	34	1436	2	smiters
snipers	9	33	1177	2	snipers
sooners	7	39	1664	2	sooners
sorners	7	34	1687	2	sorners
spicers	11	38	1555	2	spicers
spiders	10	39	1441	2	spiders
spiers	8	44	2174	2	spi_ers
spikers	13	53	1199	2	spikers
spinels	9	45	1244	2	spinels
spines	8	51	3203	2	spine_s
spinets	9	47	1481	2	spinets
spinners	10	38	1086	2	spinners
spinors	9	3	942	2	spinors
stainers	8	32	1217	2	stainers
stingers	9	40	1274	2	stingers
stinkers	12	31	1113	2	stinkers
stinters	8	33	1275	2	stinters
stivers	10	36	1354	2	stivers
stoners	7	48	1795	2	stoners
suiters	7	36	1888	2	suiters
swingers	12	37	1042	2	swingers
thinkers	15	30	870	2	thinkers
thinners	11	32	775	2	thinners
twiners	10	45	963	2	twiners
veiners	10	41	1252	2	veiners
weiners	10	39	1306	2	weiners
whiner	12	45	1663	2	whiner_
whines	12	51	2010	2	whine_s
whingers	15	35	872	2	whingers

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	120	3.233	33303.7
3	Display Results	120	120	0.046	2608.7
	(SQL Overall)	178691	120	3.639	49104.4