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

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

59 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
piebalds	13	4	434	(None)
piebald	12	4	550	1	piebald_
pibals	10	38	1308	2	pi_bal_s
pinballs	12	4	693	2	pinballs
ribalds	10	23	667	2	ri_balds
balds	8	55	2464	3	___balds
bields	9	41	1000	3	bie__lds
diebacks	17	4	596	3	diebacks
diehards	13	4	621	3	diehards
disbands	12	3	735	3	disbands
emeralds	11	4	459	3	emeralds
eyeballs	13	4	421	3	eyeballs
fields	10	42	1104	3	fie__lds
fireballs	14	12	649	3	fireballs
gimbals	12	25	782	3	gimbal_s
heralds	11	3	771	3	_heralds
imbalms	13	3	455	3	_imbalms
peals	7	52	3549	3	p_e_al_s
pebbles	13	3	757	3	p_ebbles
pedalos	10	32	970	3	p_edalos
pedals	9	43	1603	3	p_edal_s
petals	8	47	1981	3	p_etal_s
petards	10	43	1115	3	p_etards
pibal	9	52	1732	3	pi_bal__
pieholes	13	16	891	3	pieholes
pietas	8	45	1650	3	pieta__s
pinball	11	3	793	3	pinbal_l
pineals	9	32	1285	3	pineal_s
pinelands	12	4	494	3	pinelands
pinfolds	14	4	514	3	pinfolds
pinwales	13	6	796	3	pinwales
pipals	10	42	1364	3	pi_pal_s
pitfalls	13	4	537	3	pitfalls
pleads	9	46	1395	3	ple_a_ds
pleiads	10	4	522	3	pleia_ds
prebade	12	3	1028	3	preba_de
prebakes	16	3	901	3	prebakes
prebends	13	34	788	3	prebends
prebids	12	39	988	3	preb_ids
prebills	12	3	729	3	prebills
prebinds	13	35	773	3	prebinds
preboards	14	4	642	3	preboards
prebuilds	14	4	263	3	prebuilds
premolds	13	4	584	3	premolds
presales	10	3	1526	3	presales
probands	13	22	839	3	probands
pueblos	11	3	484	3	pueb_los
ribald	9	20	929	3	ri_bald_
ribands	10	20	839	3	ri_bands
ribbands	13	4	456	3	ribbands
sidebands	13	4	444	3	sidebands
skewbalds	19	4	184	3	skewbalds
spitballs	13	4	407	3	spitballs
tiebacks	16	4	633	3	tiebacks
timbales	12	22	784	3	timbales
timbals	11	23	953	3	timbal_s
wealds	10	45	910	3	_we_alds
wields	10	46	962	3	wie__lds
yields	10	46	684	3	yie__lds

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.423	422437.4
2	DLD Change Limit	146162	59	7.720	18932.9
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	8.173	21863.6