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

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

90 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
abridger	12	4	380	(None)
abridge	11	3	569	1	abridge_
abridged	13	4	390	1	abridged
abridgers	13	4	329	1	abridgers
abridges	12	4	530	1	abridges
abider	9	53	1446	2	ab_id_er
abrader	10	3	864	2	abrad_er
acrider	10	3	862	2	acrid_er
arider	7	47	1774	2	a_rid_er
bridge	10	37	1188	2	_bridge_
bridged	12	33	903	2	_bridged
bridges	11	39	1133	2	_bridges
bridler	10	38	1107	2	_bridler
bringer	10	42	1335	2	_bringer
abide	8	62	2371	3	ab_id_e_
abided	10	53	1331	3	ab_id_ed
abiders	10	40	1108	3	ab_id_ers
abides	9	47	1989	3	ab_id_es
abrade	9	3	1305	3	abrad_e_
abraded	11	3	864	3	abrad_ed
abraders	11	3	734	3	abrad_ers
abrades	10	3	1207	3	abrad_es
abridging	14	4	385	3	abridging
abridgment	16	5	351	3	abridgment
abrupter	12	4	379	3	abrupter
aerier	6	48	2315	3	aeri__er
aider	6	54	3113	3	a__id_er
airier	6	46	1936	3	airi__er
arbiter	9	3	993	3	arbi_ter
armiger	10	3	625	3	a_rmiger
arranger	9	3	688	3	arranger
arriver	10	11	779	3	arri_ver
avoider	11	5	581	3	avoid_er
badger	10	54	1508	3	_b_adger
bidder	10	41	1486	3	_b_idder
bider	8	57	2837	3	_b_id_er
bigger	10	43	1506	3	_b_igger
binger	9	49	2345	3	_b_inger
birder	9	49	1549	3	_bird_er
bludger	11	41	956	3	_bludger
bragger	11	38	1004	3	_bragger
braider	10	51	1299	3	_braid_er
briber	10	47	1405	3	_bri_ber
bride	8	64	2553	3	_brid_e_
brides	9	44	2351	3	_brid_es
bridle	9	41	1546	3	_bridle_
bridled	11	36	1114	3	_bridled
bridlers	11	35	918	3	_bridlers
bridles	10	41	1447	3	_bridles
briefer	12	3	556	3	_briefer
brier	7	45	2740	3	_bri__er
brimmer	13	34	880	3	_brimmer
briner	8	45	1904	3	_bri_ner
bringers	11	28	1107	3	_bringers
brinier	9	36	1347	3	_brinier
brisker	13	42	1029	3	_brisker
broider	10	39	1297	3	_broid_er
budger	10	46	1771	3	_b_udger
cringer	10	35	1424	3	_cringer
derider	9	32	1497	3	derid_er
deringer	10	3	814	3	deringer
dredger	10	34	745	3	_dredger
drudger	10	32	832	3	_drudger
fridge	11	37	925	3	_fridge_
fridges	12	36	948	3	_fridges
gridder	10	36	776	3	_gridder
grudger	10	36	831	3	_grudger
hagrider	13	3	448	3	hagrid_er
harbinger	15	4	412	3	harbinger
obliger	10	3	528	3	obli_ger
parridge	12	5	433	3	parridge_
parridges	13	8	455	3	parridges
ridder	8	40	1514	3	__ridder
rider	6	52	3130	3	__rid_er
ridge	7	50	1867	3	__ridge_
ridged	9	40	1422	3	__ridged
ridgel	8	39	997	3	__ridgel
ridges	8	58	1701	3	__ridges
ridgier	9	3	788	3	__ridgier
rigger	8	56	1671	3	__rigger
ringer	7	45	2606	3	__ringer
sprigger	12	36	650	3	sprigger
springer	11	33	1175	3	springer
strider	8	43	1572	3	strid_er
stringer	9	38	1294	3	stringer
trigger	9	32	916	3	_trigger
trudger	9	33	873	3	_trudger
unabridged	15	4	209	3	unabridged
unbridged	14	5	392	3	unbridged
wringer	11	36	1245	3	_wringer

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	146162	0.406	440125.6
2	DLD Change Limit	146162	90	6.530	22383.2
3	Display Results	90	90	0.033	2727.3
	(SQL Overall)	178691	90	6.969	25640.8