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

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

88 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
rustical	10	4	839	(None)
rusticals	11	4	535	1	rusticals
eristical	11	4	843	2	eristical
gestical	11	3	898	2	gestical
musical	11	3	955	2	mus_ical
mystical	15	4	693	2	mystical
rubrical	12	9	609	2	rubrical
rustic	8	7	1267	2	rustic__
rustically	15	4	897	2	rustically
rusticate	11	4	903	2	rusticate
rusticly	13	4	518	2	rusticly
rustics	9	8	1073	2	rustic_s
acoustical	14	5	403	3	acoustical
acrostical	14	4	583	3	acrostical
aestival	11	4	548	3	aestival
austral	7	34	1151	3	aust_ral
bestial	9	3	1164	3	besti_al
biotical	12	4	886	3	biotical
bustic	10	10	1269	3	bustic__
busticate	13	5	775	3	busticate
bustics	11	8	1088	3	bustic_s
cortical	12	4	1221	3	cortical
cosmical	14	4	801	3	cosmical
critical	12	3	1026	3	critical
crustal	9	3	902	3	crust__al
cryptical	18	4	469	3	cryptical
cubical	13	3	846	3	cu_bical
cuspidal	13	4	347	3	cuspidal
custumal	12	11	359	3	custumal
deistical	12	4	667	3	deistical
distichal	15	4	483	3	distichal
druidical	13	4	301	3	druidical
duncical	13	4	521	3	duncical
ekistical	15	4	480	3	ekistical
erotical	10	19	1198	3	erotical
erratical	11	4	690	3	erratical
estival	10	3	632	3	_estival
eusocial	10	4	546	3	eusocial
festival	14	4	471	3	festival
fustian	10	3	690	3	fusti_an
fustic	11	9	1063	3	fustic__
fustics	12	7	959	3	fustic_s
gnostical	12	4	620	3	gnostical
haptical	15	4	734	3	haptical
hectical	15	4	793	3	hectical
justice	16	3	742	3	justic_e
justices	17	3	752	3	justices
justiciar	18	5	331	3	justiciar
lubrical	12	11	609	3	lubrical
lustral	7	33	965	3	lust_ral
metical	11	3	1536	3	_metical
multicar	12	4	752	3	multicar
musicale	12	4	734	3	mus_icale
musicals	12	4	709	3	mus_icals
nautical	10	5	770	3	nautical
nuptial	9	4	663	3	nupti_al
optical	11	4	986	3	_optical
poetical	12	3	1153	3	poetical
practical	15	4	884	3	practical
prosaical	13	4	697	3	prosaical
radical	10	33	1279	3	r_adical
rascal	8	5	1112	3	ras__cal
restoral	8	8	1098	3	restoral
retial	6	47	2499	3	r_eti_al
retinal	7	53	1835	3	r_etinal
rostral	7	3	1133	3	rost_ral
ruminal	9	28	999	3	ru_minal
rusticated	13	4	699	3	rusticated
rusticates	12	4	805	3	rusticates
rusticator	12	4	532	3	rusticator
rusticity	14	4	596	3	rusticity
rustier	7	44	1636	3	rusti_er
rustiest	8	31	1680	3	rustiest
rustily	10	31	1299	3	rusti_ly
rusting	8	38	2126	3	rusti_ng
septical	12	5	936	3	septical
statical	10	3	942	3	statical
stoical	9	3	1028	3	__stoical
surgical	11	4	625	3	surgical
tactical	12	4	884	3	tactical
thetical	13	4	912	3	thetical
tical	7	60	2149	3	___tical
turrical	10	4	620	3	turrical
vatical	12	3	998	3	_vatical
vertical	13	4	1043	3	vertical
vesical	12	15	981	3	ves_ical
viatical	13	4	706	3	viatical
vortical	13	4	886	3	vortical

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	146162	0.156	1145455.1
2	DLD Change Limit	146162	88	8.076	18098.3
3	Display Results	88	88	0.033	2666.7
	(SQL Overall)	178691	88	8.265	21620.2