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

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

61 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
sighers	11	37	1218	(None)
sigher	10	38	1370	1	sigher_
sighters	12	25	1060	1	sighters
signers	8	47	1444	1	signers
ciphers	14	37	999	2	ciphers
cithers	12	43	1577	2	cithers
diggers	10	44	1339	2	diggers
dithers	11	40	1615	2	dithers
fighters	15	26	940	2	fighters
fishers	13	47	1472	2	fishers
higher	13	46	1089	2	higher_
jiggers	16	40	1018	2	jiggers
ligers	7	50	2204	2	lig_ers
lighters	12	31	1139	2	lighters
mithers	12	35	1673	2	mithers
niggers	9	31	1132	2	niggers
nigher	10	36	1275	2	nigher_
pishers	12	38	1575	2	pishers
riggers	9	36	1384	2	riggers
righters	12	26	1071	2	righters
saggers	9	40	1708	2	saggers
sidlers	8	34	1423	2	sidlers
sifters	10	37	1479	2	sifters
sighed	11	37	1205	2	sighe_d
sighless	12	7	655	2	sighless
sighs	9	54	1674	2	sigh__s
sighter	11	34	1211	2	sighter_
sights	10	38	1801	2	sigh_ts
signees	8	35	1080	2	signees
signer	7	40	1563	2	signer_
signets	8	33	1150	2	signets
signors	8	34	1091	2	signors
sillers	7	38	2210	2	sillers
silvers	10	47	1404	2	silvers
simmers	11	33	1461	2	simmers
simpers	11	30	1412	2	simpers
singers	8	38	2470	2	singers
sinkers	11	36	1854	2	sinkers
sinners	7	40	1902	2	sinners
sinters	7	40	2408	2	sinters
sippers	11	31	1775	2	sippers
sisters	7	37	2159	2	sisters
sithens	10	3	938	2	sithens
sitters	7	42	2155	2	sitters
sivers	9	53	2415	2	si_vers
sizers	15	52	1581	2	si_zers
sleighers	13	4	370	2	sleighers
slighters	13	4	671	2	slighters
slithers	11	42	1295	2	slithers
smithers	13	36	979	2	smithers
sniggers	10	31	709	2	sniggers
swiggers	13	33	712	2	swiggers
swishers	14	32	805	2	swishers
swithers	14	43	1053	2	swithers
syphers	15	31	727	2	syphers
tigers	7	56	1651	2	tig_ers
tithers	10	42	1673	2	tithers
weighers	15	13	567	2	weighers
wishers	13	32	1521	2	wishers
withers	13	44	1775	2	withers
zithers	19	39	1197	2	zithers

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.373	479064.3
2	DLD Change Limit	107671	61	3.110	34620.9
3	Display Results	61	61	0.016	3812.5
	(SQL Overall)	178691	61	3.499	51069.2