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

Here are the results of your fuzzy-string dictionary search for “assigners” with Change Limit: [1] [2] [3] [4]

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.

77 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
assigners	10	4	441	(None)
assignees	10	4	350	1	assignees
assigner	9	4	485	1	assigner_
assignors	10	4	324	1	assignors
aligners	9	11	757	2	a_ligners
assignats	10	4	400	2	assignats
assigned	10	4	463	2	assigne_d
assignee	9	4	484	2	assigne_e
assignor	9	4	299	2	assignor_
assigns	8	3	619	2	assign__s
assisters	9	3	635	2	assisters
cosigners	12	4	513	2	cosigners
designers	11	3	600	2	designers
resigners	10	3	686	2	resigners
signers	8	47	1444	2	__signers
actioners	11	4	772	3	actioners
aginners	9	5	462	3	a_ginners
alieners	8	8	982	3	a_lieners
aligner	8	10	831	3	a_ligner_
aliners	7	47	1772	3	a_li_ners
armigers	11	3	570	3	armig_ers
arraigners	11	14	268	3	arraigners
arsines	7	35	1881	3	arsi_ne_s
ashiness	11	3	896	3	ashi_ness
aspirers	10	6	649	3	aspi_rers
assailers	9	4	398	3	assailers
assayers	11	4	484	3	ass_ayers
assenters	9	6	699	3	assenters
asserters	9	5	639	3	asserters
assign	7	3	678	3	assign___
assignat	9	4	568	3	assign_at
assigning	11	4	467	3	assigning
assignment	13	5	389	3	assignment
assignments	14	5	332	3	assignments
assister	8	3	675	3	assister_
assistors	9	4	525	3	assistors
assizes	16	3	845	3	assi_ze_s
assorters	9	6	573	3	assorters
assuagers	10	4	347	3	assuagers
assumers	10	6	496	3	ass_umers
assurers	8	6	631	3	ass_urers
bassinets	11	4	632	3	bassi_nets
cassines	10	31	1661	3	cassi_ne_s
consigners	13	4	641	3	consigners
cosigner	11	3	595	3	cosigner_
designees	11	4	500	3	designees
designer	10	3	654	3	designer_
eloigners	10	4	299	3	eloigners
fashioners	16	12	396	3	fashioners
feigners	12	3	548	3	_feigners
gassiness	10	26	831	3	gassi_ness
maligners	12	10	478	3	maligners
massagers	12	4	551	3	massag_ers
massiness	11	28	1014	3	massi_ness
missioners	12	4	585	3	missioners
nonsigners	11	4	514	3	nonsigners
ossifiers	12	7	488	3	ossifiers
passengers	13	4	321	3	passengers
resigner	9	3	779	3	resigner_
sassiness	8	24	933	3	sassi_ness
seigneurs	10	4	249	3	_seigneurs
seiners	7	42	1927	3	_sei_ners
shiners	10	40	1594	3	_shi_ners
sighers	11	37	1218	3	__sighers
signees	8	35	1080	3	__signees
signer	7	40	1563	3	__signer_
signets	8	33	1150	3	__signets
signors	8	34	1091	3	__signors
singers	8	38	2470	3	__singers
sinners	7	40	1902	3	__sinners
skinners	12	34	729	3	_skinners
slingers	9	37	1268	3	_slingers
sniggers	10	31	709	3	_sniggers
spinners	10	38	1086	3	_spinners
stingers	9	40	1274	3	_stingers
swiggers	13	33	712	3	_swiggers
swingers	12	37	1042	3	_swingers

Search took 8 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	148641	0.423	422437.4
2	DLD Change Limit	148641	77	7.453	19943.8
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	7.906	22601.9