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

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

80 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
suppliers	13	5	448	(None)
supplier	12	4	660	1	supplier_
supplies	12	6	882	1	supplie_s
appliers	12	3	557	2	_appliers
suppers	11	33	1469	2	supp__ers
suppler	11	4	843	2	suppl_er_
supples	11	5	1128	2	suppl_e_s
supplied	13	4	598	2	supplie_d
supposers	13	4	453	2	supposers
applier	11	3	790	3	_applier_
applies	11	3	1121	3	_applie_s
buppies	13	30	1106	3	bupp_ie_s
compliers	15	3	829	3	compliers
cupelers	12	6	673	3	cupel_ers
cupellers	13	7	486	3	cupellers
cuppers	13	37	1219	3	cupp__ers
cuppier	13	6	832	3	cupp_ier_
espaliers	11	4	412	3	espaliers
fusiliers	12	4	370	3	fusiliers
guppies	12	33	1052	3	gupp_ie_s
outliers	8	26	1067	3	ou_tliers
pliers	8	47	1515	3	___pliers
puppies	10	32	1261	3	pupp_ie_s
repliers	10	37	1016	3	_repliers
resupplies	14	4	241	3	resupplie_s
ripplers	12	33	711	3	rippl_ers
ripplier	12	3	446	3	ripplier_
rumplier	12	3	530	3	rumplier_
salliers	8	36	1333	3	s_alliers
samplers	12	29	940	3	sampl_ers
sappers	11	35	1889	3	sapp__ers
sapphires	16	4	403	3	sapphires
sappier	11	36	1311	3	sapp_ier_
scuppers	14	4	653	3	scupp__ers
sippers	11	31	1774	3	sipp__ers
soppier	11	27	1158	3	sopp_ier_
spallers	10	29	1072	3	s_pallers
spellers	10	28	1274	3	s_pellers
spelters	10	39	1224	3	s_pelters
spiers	8	44	2174	3	s__p_iers
spillers	10	33	1169	3	s_pillers
splicers	12	33	811	3	s__plicers
spoilers	10	23	863	3	s_poilers
spurriers	11	24	506	3	spurriers
staplers	10	31	1118	3	stapl_ers
stipplers	13	3	443	3	stippl_ers
stupefiers	15	5	200	3	stupefiers
sublimers	13	4	577	3	su_blimers
sucklers	14	37	996	3	suckl_ers
sulkers	11	36	1334	3	su__lkers
sullies	7	41	2222	3	su_llie_s
sumpters	12	3	802	3	sump_ters
superiors	11	4	1095	3	superiors
superlies	11	3	1455	3	superlie_s
superliners	13	4	738	3	superliners
supers	8	46	2240	3	su_p__ers
supper	10	41	1543	3	supp__er_
supplanters	15	11	304	3	supplanters
supplants	13	4	487	3	supplants
supple	10	4	1020	3	suppl_e__
suppled	12	4	846	3	suppl_e_d
supplely	15	4	304	3	suppl_ely
suppleness	14	4	445	3	suppleness
supplest	12	4	893	3	suppl_est
suppliant	13	4	518	3	suppliant
suppliants	14	4	330	3	suppliants
suppling	13	5	904	3	suppli_ng
supporters	14	4	409	3	supporters
supposer	12	4	559	3	supposer_
supposes	12	3	820	3	suppose_s
suppress	12	3	644	3	supp_ress
surlier	7	29	1544	3	su_rlier_
surplices	13	4	604	3	surplices
surprisers	12	4	363	3	surprisers
suspires	10	3	820	3	susp_ires
sutlers	7	31	1697	3	su_tl_ers
tipplers	12	33	635	3	tippl_ers
uppers	10	29	1228	3	_upp__ers
uppiles	11	20	826	3	_uppile_s
yuppies	14	33	926	3	yupp_ie_s

Search took 9 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.173	1032896.0
2	DLD Change Limit	148641	80	8.156	18224.7
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	8.359	21377.1