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

Here are the results of your fuzzy-string dictionary search for “clabber” with Change Limit: [1] [2] [3]

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.

67 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
clabber	13	42	1011	(None)
blabber	10	41	892	1	blabber
clabbers	14	35	990	1	clabbers
clamber	13	33	1174	1	clamber
clobber	13	37	816	1	clobber
clubber	13	31	959	1	clubber
crabber	13	38	1073	1	crabber
slabber	11	33	1139	1	slabber
blabbed	11	35	781	2	blabbed
blabbers	11	30	815	2	blabbers
blubber	10	39	929	2	blubber
cabbed	13	54	1626	2	c_abbed
caber	9	51	2683	2	c_a_ber
cabler	10	45	1917	2	c_abler
caliber	11	3	973	2	caliber
camber	12	44	1848	2	c_amber
chamber	16	40	1106	2	chamber
clabbered	16	18	476	2	clabbered
clacker	15	38	1377	2	clacker
claimer	11	27	988	2	claimer
clambers	14	42	1129	2	clambers
clammer	13	42	1179	2	clammer
clamper	13	40	1299	2	clamper
clanger	10	41	1349	2	clanger
clapper	13	40	1186	2	clapper
claquer	18	28	735	2	claquer
clasher	12	46	1551	2	clasher
clasper	11	38	1186	2	clasper
classer	9	36	1461	2	classer
clatter	9	40	1497	2	clatter
claver	11	38	1697	2	cla_ver
clavier	12	3	917	2	clavier
clawer	11	45	1278	2	cla_wer
clayier	12	4	832	2	clayier
climber	13	44	913	2	climber
clobbers	14	39	751	2	clobbers
clubbed	14	30	745	2	clubbed
clubbers	14	37	858	2	clubbers
clubbier	14	3	483	2	clubbier
clumber	13	40	1144	2	clumber
cobber	12	41	1684	2	c_obber
crabbed	14	38	887	2	crabbed
crabbers	14	35	875	2	crabbers
crabbier	14	32	680	2	crabbier
cribber	13	36	766	2	cribber
dabber	11	48	1696	2	_dabber
drabber	12	43	859	2	drabber
fabber	13	48	1411	2	_fabber
flabbier	15	3	409	2	flabbier
flubber	14	28	771	2	flubber
gabber	11	49	1660	2	_gabber
glibber	12	3	516	2	glibber
grabber	12	38	976	2	grabber
jabber	17	37	1364	2	_jabber
lamber	10	44	1849	2	_lamber
libber	10	44	1401	2	_libber
lobber	10	40	1660	2	_lobber
lubber	10	42	1462	2	_lubber
nabber	10	49	1354	2	_nabber
slabbed	12	40	950	2	slabbed
slabbers	12	36	1012	2	slabbers
slabbery	15	37	577	2	slabbery
slobber	11	38	890	2	slobber
slubber	11	30	1076	2	slubber
stabber	11	36	1015	2	stabber
swabber	14	29	796	2	swabber
yabber	13	61	1183	2	_yabber

Search took 4 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	107671	0.126	1418182.5
2	DLD Change Limit	107671	67	3.563	30219.2
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	3.719	48048.1