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

Here are the results of your fuzzy-string dictionary search for “gibbose” 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
gibbose	12	4	408	(None)
gibbon	11	3	532	2	gibbo_n
gibbons	12	3	498	2	gibbons
gibbous	12	6	533	2	gibbous
globose	10	3	554	2	globose
ribose	8	3	989	2	ri_bose
bibbs	8	49	1158	3	bibb_s_
bilboes	11	44	1024	3	bilboes
bilbos	10	50	1120	3	bilbos_
bimboes	13	49	873	3	bimboes
bimbos	12	46	1052	3	bimbos_
brose	7	52	2703	3	__brose
caboose	11	3	827	3	caboose
cirrose	9	3	747	3	cirrose
diabase	10	3	711	3	diabase
dibble	11	40	1384	3	dibb_le
dibbles	12	40	1333	3	dibbles
dispose	10	3	1276	3	dispose
fibroses	13	4	597	3	fibroses
filose	9	61	1250	3	fi_lose
gabble	11	38	1572	3	gabb_le
gabbles	12	44	1541	3	gabbles
gabbros	12	12	465	3	gabbros_
gamboge	13	3	558	3	gamboge
gibbed	12	45	1235	3	gibb_ed
gibber	11	41	1286	3	gibb_er
gibbered	14	4	430	3	gibbered
gibbers	12	47	1098	3	gibbers
gibbet	11	41	1338	3	gibb_et
gibbeted	14	9	278	3	gibbeted
gibbets	12	41	772	3	gibbets
gibbing	13	33	937	3	gibbing
gibbosity	17	5	200	3	gibbosity
gibbously	17	7	292	3	gibbously
gibbsite	13	4	250	3	gibbsite
gibe	7	59	2778	3	gi_b__e
gibers	9	51	1466	3	gibers_
gibes	8	44	2252	3	gi_bes_
gibs	7	55	2927	3	gi_b_s_
gibson	9	3	512	3	gibso_n
gibsons	10	4	504	3	gibsons
ginzoes	17	3	543	3	ginzoes
giros	6	57	2265	3	gi_ros_
gismos	9	5	718	3	gismos_
gizmos	18	4	413	3	gizmos_
glibbest	13	4	368	3	glibbest
glucose	10	4	512	3	glucose
gobble	11	35	1298	3	gobb_le
gobbles	12	35	1258	3	gobbles
goboes	9	59	1444	3	g_oboes
gobos	8	62	1938	3	g_obos_
gombos	11	43	1109	3	gombos_
goose	6	59	2590	3	g__oose
gribble	12	29	727	3	gribb_le
gribbles	13	30	736	3	gribbles
grumose	10	3	572	3	grumose
gumbos	11	46	1087	3	gumbos_
gummose	12	3	533	3	gummose
gyrose	10	53	1025	3	g_yrose
hipbone	14	4	592	3	hipbone
impose	10	31	1305	3	_impose
jibboom	20	9	249	3	jibboom
jibbs	16	60	974	3	jibb_s_
kibbe	13	52	1197	3	kibb__e
kibbes	14	38	1119	3	kibbes_
kibbis	14	39	847	3	kibbis_
kibble	14	39	1095	3	kibb_le
kibbles	15	35	1025	3	kibbles
kibosh	15	3	426	3	ki_bosh
limbos	10	47	1214	3	limbos_
nibble	10	37	1328	3	nibb_le
nibbles	11	40	1169	3	nibbles
pilose	8	45	1424	3	pi_lose
pinbone	11	3	818	3	pinbone
ribbon	10	3	653	3	ribbo_n
ribboned	13	4	397	3	ribboned
ribbons	11	3	625	3	ribbons
ribbony	14	4	354	3	ribbony
riboses	9	3	1044	3	ri_boses
rimose	8	3	1059	3	ri_mose
sibbs	9	62	1190	3	sibb_s_
sorbose	9	3	898	3	sorbose
subbase	11	3	932	3	subbase
verbose	12	3	775	3	verbose
villose	10	3	805	3	villose
viscose	12	3	786	3	viscose
yobboes	14	4	558	3	yobboes
yobbos	13	3	596	3	yobbos_

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.406	440125.6
2	DLD Change Limit	134027	88	6.003	22326.7
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	6.439	27751.4