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

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

89 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
swinger	11	38	1256	(None)
singer	7	42	2731	1	s_inger
slinger	8	34	1383	1	slinger
stinger	8	43	1468	1	stinger
swigger	12	33	845	1	swigger
swinge	10	56	1438	1	swinge_
swinged	12	38	1079	1	swinged
swingers	12	37	1042	1	swingers
swinges	11	34	1342	1	swinges
swingier	12	26	700	1	swingier
winger	10	41	2544	1	_winger
binger	9	49	2345	2	_binger
bringer	10	42	1335	2	bringer
clinger	10	38	1215	2	clinger
cringer	10	35	1424	2	cringer
dinger	8	53	2367	2	_dinger
finger	10	49	2033	2	_finger
flinger	11	37	1051	2	flinger
ginger	8	49	2003	2	_ginger
hinger	10	47	2333	2	_hinger
linger	7	52	2600	2	_linger
pinger	9	43	2409	2	_pinger
ringer	7	45	2606	2	_ringer
sanger	7	45	2456	2	s_anger
seiner	6	46	2248	2	sein_er
shiner	9	38	2087	2	shin_er
shingler	12	26	863	2	shingler
shinier	10	41	1314	2	shinier
signer	7	40	1563	2	s_igner
singe	6	57	3113	2	s_inge_
singed	8	54	2229	2	s_inged
singers	8	38	2470	2	s_ingers
singes	7	43	2685	2	s_inges
sinker	10	36	2090	2	s_inker
sinner	6	43	2060	2	s_inner
sinter	6	36	2592	2	s_inter
skinker	10	31	944	2	skinker
skinner	11	34	809	2	skinner
slingers	9	37	1268	2	slingers
snigger	9	32	837	2	snigger
spinier	9	37	1516	2	spinier
spinner	9	39	1226	2	spinner
sponger	10	3	852	2	sponger
springer	11	33	1175	2	springer
stingers	9	40	1274	2	stingers
stingier	9	27	912	2	stingier
stinker	11	33	1331	2	stinker
stinter	7	36	1451	2	stinter
stringer	9	38	1294	2	stringer
swager	10	40	1361	2	sw_ager
swagger	12	38	933	2	swagger
swanker	14	36	948	2	swanker
swifter	13	31	805	2	swifter
swigged	13	32	718	2	swigged
swiggers	13	33	712	2	swiggers
swiller	10	32	1166	2	swiller
swimmer	14	29	765	2	swimmer
swindler	12	25	772	2	swindler
swine	8	56	2530	2	swin_e_
swing	9	61	2484	2	swing__
swingby	16	34	389	2	swingby
swingle	11	35	1056	2	swingle
swingled	13	33	743	2	swingled
swingles	12	31	954	2	swingles
swingmen	14	4	349	2	swingmen
swings	10	47	1445	2	swing_s
swingy	13	48	987	2	swing_y
swinked	15	34	903	2	swinked
swinney	13	36	597	2	swinney
swisher	13	36	952	2	swisher
swither	13	37	1099	2	swither
twanger	11	32	743	2	twanger
twiner	9	40	1259	2	twin_er
twinge	10	42	1040	2	twinge_
twinged	12	39	836	2	twinged
twinges	11	40	945	2	twinges
twinier	10	3	731	2	twinier
whinger	14	108	1091	2	whinger
wincer	11	50	1819	2	_wincer
winder	10	40	2526	2	_winder
winged	11	46	2083	2	_winged
wingers	11	39	2148	2	_wingers
wingier	11	34	1328	2	_wingier
winier	9	45	2245	2	_winier
winker	13	42	2029	2	_winker
winner	9	42	1993	2	_winner
winter	9	42	2280	2	_winter
wringer	11	36	1245	2	wringer
zinger	16	38	1670	2	_zinger

Search took 10 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.470	380193.6
2	DLD Change Limit	107671	89	7.530	14298.9
3	Display Results	89	89	0.063	1412.7
	(SQL Overall)	178691	89	8.063	22161.9