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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

370 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
igloo	6	4	1049	(None)
igloos	7	3	803	1	igloos
aglow	9	47	1197	2	aglow
diglot	8	30	1433	2	diglot
giglot	8	40	1313	2	giglot
gigolo	8	3	653	2	gigolo
glob	7	66	2339	2	_glob
glom	7	54	2438	2	_glom
gloom	8	71	1652	2	_gloom
glop	7	67	2463	2	_glop
glow	8	52	2252	2	_glow
goo	4	77	5477	2	_g_oo
iglu	5	108	1478	2	igl_u
iglus	6	60	993	2	iglus
loo	3	83	5982	2	__loo
sigloi	7	3	774	2	sigloi
siglos	7	3	1147	2	siglos
tiglon	7	3	792	2	tiglon
abloom	10	3	978	3	abloom
achoo	10	3	1508	3	achoo
aggro	7	3	801	3	aggro
agio	5	78	2845	3	ag_io
agios	6	59	1986	3	agios
aglee	6	57	2849	3	aglee
aglet	6	55	3414	3	aglet
agley	9	69	1733	3	agley
agly	8	68	2180	3	agl_y
ago	4	88	4552	3	ag__o
agog	6	80	1900	3	ag_og
agon	5	65	3188	3	ag_on
aiglet	7	42	2419	3	aiglet
airglow	11	4	367	3	airglow
algor	6	5	1305	3	algor
allod	6	44	1838	3	allod
allot	5	49	3387	3	allot
allow	8	54	2066	3	allow
alloy	8	55	1997	3	alloy
aloe	4	55	4019	3	_aloe
aloof	8	35	2157	3	_aloof
alow	7	53	2859	3	_alow
also	4	64	2344	3	_also
alto	4	78	3126	3	_alto
anglo	6	52	1537	3	angl_o
anglos	7	44	1391	3	anglos
azlon	14	43	1287	3	azlon
baboo	9	43	1950	3	baboo
bazoo	16	38	1567	3	bazoo
begloom	12	5	524	3	begloom
belon	7	39	2411	3	belon
below	10	46	1719	3	below
bigfoot	13	5	599	3	bigfoot
bigly	11	48	1475	3	bigl_y
bigos	8	50	2001	3	big_os
bigot	8	48	2832	3	big_ot
bilbo	9	55	1361	3	bilbo
billon	8	37	1383	3	billon
billow	11	41	1122	3	billow
blob	8	60	2709	3	_blob
bloc	8	50	2327	3	_bloc
blog	7	57	2382	3	_blog
blood	8	53	1952	3	_blood
bloom	9	59	1897	3	_bloom
bloop	9	61	1615	3	_bloop
blot	6	58	4232	3	_blot
blow	9	58	2719	3	_blow
bolo	6	55	3595	3	bol_o
bolos	7	55	3137	3	bolos
boo	5	81	6366	3	__boo
broo	6	51	2982	3	_broo
calo	6	49	3644	3	cal_o
calos	7	44	3190	3	calos
cello	7	49	1958	3	cello
celom	9	5	1568	3	celom
cholo	10	52	1797	3	cholo
clod	7	61	2461	3	_clod
clog	7	61	2324	3	_clog
clon	6	62	3248	3	_clon
cloot	7	61	2705	3	_cloot
clop	8	69	2989	3	_clop
clot	6	65	4242	3	_clot
cloy	9	66	2383	3	_cloy
colog	8	66	1993	3	colog
colon	7	86	3019	3	colon
color	7	61	2374	3	color
coo	5	95	6636	3	__coo
dialog	8	3	797	3	dialog
diglots	9	29	950	3	diglots
dildo	7	19	1177	3	dildo
diploe	9	8	1015	3	diploe
dolor	6	76	1796	3	dolor
ego	4	67	2605	3	eg__o
egos	5	58	2165	3	eg_os
felon	8	46	1929	3	felon
fillo	8	43	1978	3	fillo
fillos	9	44	1508	3	fillos
filo	7	60	3428	3	fil_o
filos	8	61	2538	3	filos
floc	9	59	2212	3	_floc
floe	7	61	2977	3	_floe
flog	8	55	2389	3	_flog
flood	9	52	1560	3	_flood
floor	8	42	1523	3	_floor
flop	9	69	2545	3	_flop
flow	10	59	2492	3	_flow
folio	8	38	2088	3	folio
galoot	7	27	1916	3	galoot
galop	8	47	1622	3	galop
gaol	5	69	2541	3	_gaol
gazoo	15	31	1287	3	gazoo
giglet	8	39	2027	3	giglet
giglots	9	36	786	3	giglots
gigolos	9	3	469	3	gigolos
gigot	7	40	2307	3	gigot
gild	6	55	2651	3	gil_d
gilds	7	54	1752	3	gilds
gill	5	63	3618	3	gil_l
gills	6	47	2819	3	gills
gilly	9	43	2163	3	gilly
gilt	5	63	4854	3	gil_t
gilts	6	49	2426	3	gilts
ginzo	15	3	961	3	ginzo
gipon	8	42	1241	3	gipon
giro	5	58	2863	3	_giro
giron	6	61	1899	3	giron
giros	6	57	2265	3	giros
gismo	8	4	886	3	gismo
gizmo	17	5	601	3	gizmo
glad	6	56	2401	3	_glad
glam	7	65	2934	3	_glam
gled	6	56	3114	3	_gled
glee	5	52	3906	3	_glee
gleg	6	62	1980	3	_gleg
glen	5	60	2720	3	_glen
gley	8	57	2465	3	_gley
glia	5	64	2315	3	_glia
glib	7	94	2144	3	_glib
glim	7	60	2635	3	_glim
gloam	8	60	1594	3	_gloam
gloat	6	54	2768	3	_gloat
globe	8	49	1701	3	_globe
globs	8	56	1640	3	_globs
glogg	8	3	735	3	_glogg
gloms	8	52	1978	3	_gloms
glooms	9	62	1168	3	_glooms
gloomy	12	52	876	3	_gloomy
glops	8	56	1955	3	_glops
glory	9	64	1329	3	_glory
gloss	6	43	1962	3	_gloss
glost	6	54	2293	3	_glost
glout	6	59	2581	3	_glout
glove	9	45	1629	3	_glove
glows	9	55	1803	3	_glows
gloze	15	48	1598	3	_gloze
glue	5	56	2849	3	_glue
glug	6	61	1801	3	_glug
glum	7	58	2510	3	_glum
gluon	6	3	1122	3	_gluon
glut	5	63	3129	3	_glut
go	3	87	4874	3	_g__o
goa	4	73	4380	3	_g_oa
gob	6	89	5089	3	_g_ob
gobo	7	61	2690	3	_gobo
god	5	74	4979	3	_g_od
gogo	6	97	2283	3	_gogo
gold	6	54	3016	3	_gold
golf	8	57	3118	3	_golf
good	6	65	3180	3	_good
goof	8	54	3687	3	_goof
gook	9	64	2960	3	_gook
goon	5	72	3617	3	_goon
goop	7	58	2948	3	_goop
goos	5	76	4491	3	_goos
gor	4	78	4826	3	_g_or
gos	4	71	5513	3	_g_os
got	4	98	7044	3	_g_ot
gox	11	71	3718	3	_g_ox
goy	7	78	4455	3	_g_oy
grog	6	59	2334	3	_grog
grok	9	58	1968	3	_grok
groom	8	53	1798	3	_groom
grot	5	59	4205	3	_grot
grow	8	61	2730	3	_grow
gyro	8	52	1788	3	_gyro
hallo	8	51	2755	3	hallo
halloo	9	51	1897	3	halloo
halo	7	64	3732	3	hal_o
halon	8	61	2486	3	halon
halos	8	52	3025	3	halos
helio	8	53	2119	3	helio
hello	8	65	2298	3	hello
helo	7	53	3285	3	hel_o
helos	8	49	2806	3	helos
helot	8	53	3268	3	helot
hillo	8	47	2165	3	hillo
hilloa	9	47	1303	3	hilloa
hillos	9	46	1889	3	hillos
hollo	8	48	2216	3	hollo
holloo	9	44	1525	3	holloo
hullo	8	44	1745	3	hullo
hulloo	9	45	1173	3	hulloo
ichor	10	3	948	3	ichor
icon	6	69	2204	3	i_con
idiom	8	9	996	3	idiom
idiot	6	7	1886	3	idiot
idle	5	54	2376	3	idl_e
idled	7	49	1521	3	idled
idler	6	50	1566	3	idler
idles	6	67	2012	3	idles
idly	8	56	1732	3	idl_y
idol	5	68	1863	3	i_dol
idols	6	55	1413	3	idols
igg	5	71	1679	3	ig__g
igged	8	60	1276	3	igged
iggs	6	66	1267	3	ig_gs
ignore	7	26	906	3	ignore
ikon	8	58	1495	3	i_kon
ilea	4	59	3146	3	i_lea
ilex	11	58	2203	3	i_lex
ilia	4	60	2682	3	i_lia
ilk	7	83	2530	3	i_l_k
ilka	8	72	1515	3	i_lka
ilks	8	72	1857	3	i_lks
ill	3	74	3709	3	i_l_l
iller	5	48	2129	3	iller
ills	4	70	3042	3	i_lls
illy	7	69	2533	3	i_lly
imago	8	11	869	3	imago
imido	8	58	1224	3	imido
imino	7	43	1523	3	imino
incog	8	3	825	3	incog
indol	6	37	1487	3	indol
indoor	7	3	840	3	indoor
indow	9	50	1166	3	indow
inflow	12	3	529	3	inflow
info	7	56	1735	3	i_nfo
infos	8	43	1167	3	infos
ingle	6	41	2043	3	ingl_e
ingles	7	44	2087	3	ingles
ingot	6	12	2106	3	ingot
inion	5	46	2018	3	inion
inlay	8	52	1432	3	inlay
inlet	5	37	3240	3	inlet
inly	7	56	2221	3	inl_y
inro	4	59	2079	3	i_nro
into	4	50	2615	3	i_nto
intro	5	49	1585	3	intro
ion	3	60	5102	3	i__on
iroko	9	3	966	3	iroko
iron	4	67	2846	3	i_ron
isle	4	51	2170	3	isl_e
isled	6	46	1599	3	isled
isles	5	42	2056	3	isles
islet	5	45	2755	3	islet
isolog	7	3	740	3	isolog
jalop	14	42	1260	3	jalop
jello	12	67	1627	3	jello
jigaboo	17	4	299	3	jigaboo
karoo	9	25	1958	3	karoo
kazoo	18	33	1153	3	kazoo
kilo	8	60	2866	3	kil_o
kilos	9	50	2147	3	kilos
kloof	12	38	1213	3	_kloof
kolo	8	70	2622	3	kol_o
kolos	9	49	2121	3	kolos
lilo	4	67	3156	3	lil_o
lilos	5	58	2187	3	lilos
lo	2	80	5344	3	__l_o
lob	5	71	5446	3	__lob
lobo	6	72	2986	3	__lobo
loco	6	70	3074	3	__loco
log	4	62	5268	3	__log
logo	5	79	3176	3	__logo
loof	7	81	4105	3	__loof
look	8	73	3347	3	__look
loom	6	70	3505	3	__loom
loon	4	73	4479	3	__loon
loop	6	78	3501	3	__loop
loos	4	90	5112	3	__loos
loot	4	69	5582	3	__loot
lop	5	82	5531	3	__lop
lot	3	81	7926	3	__lot
low	6	60	5187	3	__low
lox	10	82	4096	3	__lox
melon	7	39	2208	3	melon
mignon	9	3	795	3	mignon
milo	6	55	3610	3	mil_o
milos	7	54	2801	3	milos
molto	7	56	1960	3	molto
moo	5	84	6051	3	__moo
niello	6	3	660	3	niello
nolo	4	62	2931	3	nol_o
nolos	5	44	2335	3	nolos
noo	3	71	5404	3	__noo
nylon	8	29	1051	3	nylon
ogle	5	63	2505	3	ogl_e
ogled	7	59	1596	3	ogled
ogler	6	59	1744	3	ogler
ogles	6	52	2318	3	ogles
oleo	4	66	3048	3	_oleo
olio	4	68	2967	3	_olio
orlon	5	4	1500	3	orlon
orlop	7	4	1090	3	orlop
ovolo	8	33	917	3	ovolo
pelon	7	44	2321	3	pelon
phlox	17	3	733	3	phlox
pigeon	9	4	941	3	pigeon
piglet	9	34	2092	3	piglet
pillow	11	31	1057	3	pillow
pilot	7	74	3506	3	pilot
plod	7	67	2327	3	_plod
plop	8	66	2574	3	_plop
plot	6	61	4123	3	_plot
plow	9	59	2323	3	_plow
ploy	9	61	2360	3	_ploy
polio	7	57	2255	3	polio
polo	6	62	3663	3	pol_o
polos	7	61	2991	3	polos
poo	5	77	5711	3	__poo
pylon	10	36	1400	3	pylon
reglow	10	33	940	3	reglow
relook	10	48	1374	3	relook
rialto	6	3	860	3	rialto
righto	10	41	1109	3	righto
rigor	6	27	1405	3	rig_or
salol	5	52	2214	3	salol
salon	5	52	2855	3	salon
saloon	6	44	1802	3	saloon
saloop	8	42	1258	3	saloop
salvo	8	44	1564	3	salvo
shoo	7	59	2989	3	_shoo
sigla	6	45	1520	3	sigl_a
siglum	9	3	656	3	siglum
signor	7	35	1035	3	signor
silo	4	60	3791	3	sil_o
silos	5	60	2943	3	silos
slob	6	60	2942	3	_slob
sloe	4	55	3495	3	_sloe
slog	5	67	2827	3	_slog
sloop	7	61	1891	3	_sloop
slop	6	65	3387	3	_slop
slot	4	60	4983	3	_slot
slow	7	77	2949	3	_slow
soldo	6	71	1656	3	soldo
solo	4	55	3894	3	sol_o
solon	5	50	2613	3	solon
solos	5	48	3079	3	solos
sulfo	8	3	1336	3	sulfo
taboo	7	34	1809	3	taboo
talon	5	58	2411	3	talon
telco	7	5	1187	3	telco
teloi	5	42	1738	3	teloi
telos	5	54	2452	3	telos
tiglons	8	3	734	3	tiglons
tigon	6	39	1444	3	tig_on
too	3	89	6542	3	__too
ugly	8	60	1238	3	ugl_y
valor	8	36	1489	3	valor
vigor	9	26	1242	3	vig_or
vulgo	9	3	695	3	vulgo
wahoo	11	24	1308	3	wahoo
wazoo	17	30	1117	3	wazoo
wigeon	10	3	722	3	wigeon
wiglet	10	55	1915	3	wiglet
wilco	10	3	944	3	wilco
willow	12	36	969	3	willow
witloof	13	4	435	3	witloof
woo	6	69	4980	3	__woo
xylol	15	4	613	3	xylol
yahoo	11	29	1154	3	yahoo
zoo	12	62	3891	3	__zoo

Search took 5 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	83667	0.106	1685764.2
2	DLD Change Limit	83667	370	3.893	21491.7
3	Display Results	370	370	0.093	3978.5
	(SQL Overall)	178691	370	4.092	43668.4