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

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

83 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
aplombs	13	4	326	(None)
aplomb	12	3	620	1	aplomb_
plumbs	12	45	933	2	_plumbs
abomas	10	11	1358	3	a_bomas
absorbs	11	3	561	3	absorbs
adsorbs	10	4	471	3	adsorbs
alamos	8	4	1500	3	a_lamos
albs	6	86	2857	3	a_l__bs
allods	7	36	1508	3	allo_ds
allots	6	40	1917	3	allo_ts
allows	9	45	1768	3	allo_ws
alloys	9	40	1456	3	allo_ys
almas	7	66	2977	3	a_l_mas
almes	7	51	2654	3	a_l_mes
alms	6	58	3492	3	a_l_m_s
aloes	5	49	3367	3	a_lo_es
alohas	9	4	1170	3	a_lohas
aloins	6	50	2220	3	a_loins
alums	7	57	2060	3	a_lum_s
aplites	9	3	1493	3	aplites
apnoeas	9	4	635	3	apnoeas
apods	8	63	1634	3	ap_o_ds
apollos	9	4	679	3	apollos
apologs	10	3	859	3	apologs
apos	6	54	3382	3	ap_o__s
apposes	11	5	1147	3	apposes
aprons	8	3	1699	3	apro_ns
apropos	11	3	884	3	apropos
aromas	8	10	1861	3	a_romas
atoms	7	68	1756	3	a_tom_s
axioms	15	40	805	3	axiom_s
azlons	15	41	1042	3	azlo_ns
blobs	9	56	2003	3	_blo_bs
bombs	11	58	1882	3	__bombs
celoms	10	4	1212	3	celom_s
climbs	12	49	872	3	_climbs
clomb	11	57	1470	3	_clomb_
clomps	12	52	1223	3	_clomps
combs	11	61	2296	3	__combs
coombs	12	42	1019	3	_coombs
coulombs	14	4	309	3	coulombs
diplomas	13	8	599	3	diplomas
entombs	11	3	561	3	entombs
enwombs	14	4	363	3	enwombs
globs	8	56	1640	3	_glo_bs
gloms	8	52	1978	3	_glom_s
glomus	9	46	809	3	_glomus
haploids	14	3	736	3	haploids
haplonts	13	4	577	3	haplonts
haploses	13	3	885	3	haploses
haplosis	13	4	709	3	haplosis
intombs	11	4	415	3	intombs
lambs	9	59	2141	3	__lambs
limbs	9	61	1894	3	__limbs
lobs	6	64	4108	3	__lo_bs
palms	9	49	2175	3	pal_m_s
plebs	9	58	1458	3	_pl_ebs
plods	8	57	1929	3	_plo_ds
plonks	12	42	1042	3	_plonks
plops	9	59	2033	3	_plo_ps
plots	7	50	2567	3	_plo_ts
plows	10	54	1990	3	_plo_ws
ploys	10	58	1659	3	_plo_ys
plumb	11	45	1407	3	_plumb_
plumes	10	43	1813	3	_plumes
plumps	12	46	1261	3	_plumps
plums	9	46	1995	3	_plum_s
pomes	9	48	3393	3	_p_omes
pomos	9	53	2158	3	_p_omos
pomps	11	53	1619	3	_p_omps
poms	8	70	3774	3	_p_om_s
promos	10	51	1642	3	_promos
proms	9	54	2641	3	_prom_s
recombs	13	3	675	3	recombs
replumbs	14	4	218	3	replumbs
rhombs	13	33	649	3	_rhombs
slobs	7	44	1987	3	_slo_bs
splores	9	19	1095	3	splores
telomes	9	3	1053	3	telomes
tombs	9	78	1873	3	__tombs
upclimbs	16	4	136	3	upclimbs
uploads	10	26	650	3	uploads
wombs	12	58	1334	3	__wombs

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	134027	0.390	458182.1
2	DLD Change Limit	134027	83	6.033	22215.6
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	6.453	27691.2