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

Here are the results of your fuzzy-string dictionary search for “distanced” 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
distanced	13	4	857	(None)
distance	11	3	1185	1	distance_
distances	12	3	1165	1	distances
disbanded	14	4	564	2	disbanded
discalced	15	4	565	2	discalced
discanted	13	3	933	2	discanted
distained	11	3	960	2	distained
distasted	11	3	796	2	distasted
distended	12	15	792	2	distended
instanced	12	4	570	2	instanced
danced	10	53	1525	3	d___anced
desanded	11	22	745	3	des_anded
descanted	13	3	667	3	descanted
desistance	13	4	458	3	desistance_
desistances	14	4	419	3	desistances
destained	11	5	825	3	destained
destined	10	33	1245	3	destin_ed
dictated	12	3	920	3	dicta_ted
disabled	12	4	871	3	dis_abled
disarmed	12	3	864	3	dis_armed
disband	11	3	824	3	disban__d
disbarred	13	4	527	3	disbarred
disbranched	20	5	280	3	disbranched
discarded	14	3	708	3	discarded
discased	12	25	1085	3	disca_sed
disced	10	49	1465	3	dis___ced
disdained	12	4	602	3	disdained
diseased	10	30	1171	3	disea_sed
disgraced	14	4	674	3	disgraced
dismantled	14	4	369	3	dismantled
dismasted	13	4	683	3	dismasted
dismayed	15	3	574	3	disma_yed
disowned	13	3	643	3	disown_ed
disparted	13	3	885	3	disparted
dispatched	19	9	388	3	dispatched
dispended	14	14	782	3	dispended
dispensed	13	15	877	3	dispensed
displaced	15	4	679	3	displaced
displanted	14	12	663	3	displanted
disrated	10	9	1557	3	disra_ted
dissaved	13	3	731	3	dissa_ved
dissented	11	9	972	3	dissented
distancing	14	4	708	3	distancing
distant	8	35	1995	3	distan__t
distantly	13	4	639	3	distantly
distaste	9	3	994	3	distaste_
distastes	10	3	963	3	distastes
distaves	12	3	1140	3	dista_ves
distend	9	33	1207	3	disten__d
distender	11	16	774	3	distender
distilled	11	4	718	3	distilled
distinct	11	4	1076	3	distinc_t
distincter	13	4	530	3	distincter
distorted	11	3	937	3	distorted
distracted	14	4	887	3	distracted
distrained	12	5	767	3	distrained
districted	14	4	822	3	districted
disturbed	13	19	558	3	disturbed
disvalued	14	4	419	3	disvalued
dittanies	10	4	573	3	dittanies
financed	14	3	511	3	fi_nanced
instance	10	4	988	3	instance_
instances	11	4	875	3	instances
islanded	10	3	551	3	_islanded
listened	9	16	881	3	listen_ed
mistended	13	13	733	3	mistended
mistraced	14	3	945	3	mistraced
mistuned	11	5	772	3	mistun_ed
outdistanced	16	5	126	3	~~out~~distanced
pittance	12	4	611	3	pittance_
pittances	13	4	570	3	pittances
stance	8	43	1691	3	__stance_
stances	9	37	1596	3	__stances
stanched	14	20	890	3	__stanched
staned	7	48	2464	3	__stan_ed
stanged	9	41	1384	3	__stanged
vistaed	11	3	802	3	vista__ed

Search took 7 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.406	440125.6
2	DLD Change Limit	148641	77	6.423	23142.0
3	Display Results	77	77	0.046	1673.9
	(SQL Overall)	178691	77	6.875	25991.4