History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spyglass"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
179 | 2024-04-28 21:57:05 | spyglass | 1 | 82945 | 1 | 1.576 | 52630.1 |
178 | 2024-04-27 00:27:14 | spyglass | 1 | 82945 | 1 | 3.236 | 25632.0 |
177 | 2024-04-26 23:38:03 | spyglass | 1 | 82945 | 1 | 1.513 | 54821.5 |
176 | 2024-04-26 23:37:07 | spyglass | 3 | 146162 | 19 | 9.016 | 16211.4 |
175 | 2024-04-26 23:37:04 | spyglass | 2 | 121059 | 3 | 3.643 | 33230.6 |
174 | 2024-04-13 16:46:13 | spyglass | 3 | 146162 | 19 | 14.020 | 10425.2 |
173 | 2024-04-12 17:52:33 | spyglass | 1 | 82945 | 1 | 1.513 | 54821.5 |
172 | 2024-04-12 17:52:20 | spyglass | 3 | 146162 | 19 | 6.703 | 21805.5 |
171 | 2024-04-12 17:52:16 | spyglass | 2 | 121059 | 3 | 3.626 | 33386.4 |
170 | 2024-04-10 21:15:05 | spyglass | 1 | 82945 | 1 | 5.483 | 15127.7 |
169 | 2024-04-10 21:12:49 | spyglass | 3 | 146162 | 19 | 20.753 | 7042.9 |
168 | 2024-04-10 21:12:48 | spyglass | 2 | 121059 | 3 | 4.076 | 29700.4 |
167 | 2024-04-07 10:40:42 | spyglass | 4 | 161609 | 315 | 47.626 | 3393.3 |
166 | 2024-04-06 21:39:29 | spyglass | 4 | 161609 | 315 | 30.530 | 5293.4 |
165 | 2024-04-06 17:27:21 | spyglass | 4 | 161609 | 315 | 22.173 | 7288.5 |
164 | 2024-04-01 18:41:02 | spyglass | 4 | 161609 | 315 | 31.503 | 5130.0 |
163 | 2024-04-01 16:32:37 | spyglass | 1 | 82945 | 1 | 3.216 | 25791.4 |
162 | 2024-03-31 21:18:48 | spyglass | 4 | 161609 | 315 | 33.156 | 4874.2 |
161 | 2024-03-31 15:45:58 | spyglass | 4 | 161609 | 315 | 12.030 | 13433.8 |
160 | 2024-03-31 15:45:58 | spyglass | 3 | 146162 | 19 | 7.250 | 20160.3 |
159 | 2024-03-31 15:46:00 | spyglass | 2 | 121059 | 3 | 3.903 | 31016.9 |
158 | 2024-03-23 07:33:40 | spyglass | 1 | 82945 | 1 | 1.280 | 64800.8 |
157 | 2024-03-20 01:30:49 | spyglass | 2 | 121059 | 3 | 3.843 | 31501.2 |
156 | 2024-03-20 01:30:34 | spyglass | 1 | 82945 | 1 | 1.780 | 46598.3 |
155 | 2024-03-13 02:12:04 | spyglass | 3 | 146162 | 19 | 14.220 | 10278.6 |
154 | 2024-03-13 02:12:02 | spyglass | 2 | 121059 | 3 | 7.406 | 16346.1 |
153 | 2024-03-12 22:30:20 | spyglass | 1 | 82945 | 1 | 1.686 | 49196.3 |
152 | 2024-03-12 22:29:57 | spyglass | 3 | 146162 | 19 | 8.906 | 16411.6 |
151 | 2024-03-12 22:30:00 | spyglass | 2 | 121059 | 3 | 4.346 | 27855.3 |
150 | 2024-03-12 22:29:35 | spyglass | 1 | 82945 | 1 | 1.466 | 56579.1 |
149 | 2024-03-09 06:57:22 | spyglass | 1 | 82945 | 1 | 2.970 | 27927.6 |
148 | 2024-03-07 03:55:34 | spyglass | 4 | 161609 | 315 | 41.893 | 3857.7 |
147 | 2024-03-06 15:48:09 | spyglass | 1 | 82945 | 1 | 3.420 | 24252.9 |
146 | 2024-03-06 12:11:28 | spyglass | 4 | 161609 | 315 | 39.050 | 4138.5 |
145 | 2024-03-01 18:11:04 | spyglass | 4 | 161609 | 315 | 31.530 | 5125.6 |
144 | 2024-02-27 21:33:36 | spyglass | 3 | 146162 | 19 | 11.186 | 13066.5 |
143 | 2024-02-27 21:33:35 | spyglass | 2 | 121059 | 3 | 3.953 | 30624.6 |
142 | 2024-02-27 15:30:27 | spyglass | 4 | 161609 | 315 | 12.470 | 12959.8 |
141 | 2024-02-27 15:30:28 | spyglass | 3 | 146162 | 19 | 7.640 | 19131.2 |
140 | 2024-02-27 15:30:30 | spyglass | 2 | 121059 | 3 | 4.186 | 28920.0 |
139 | 2024-02-22 05:23:21 | spyglass | 1 | 82945 | 1 | 1.420 | 58412.0 |
138 | 2024-02-05 04:30:11 | spyglass | 2 | 121059 | 3 | 3.233 | 37444.8 |
137 | 2024-02-05 04:29:59 | spyglass | 3 | 146162 | 19 | 7.050 | 20732.2 |
136 | 2024-02-04 21:24:07 | spyglass | 4 | 161609 | 315 | 11.983 | 13486.5 |
135 | 2024-02-04 16:53:30 | spyglass | 3 | 146162 | 19 | 11.706 | 12486.1 |
134 | 2024-02-04 16:53:22 | spyglass | 4 | 161609 | 315 | 13.703 | 11793.7 |
133 | 2024-02-04 16:53:26 | spyglass | 2 | 121059 | 3 | 4.110 | 29454.7 |
132 | 2024-01-30 19:57:56 | spyglass | 1 | 82945 | 1 | 3.000 | 27648.3 |
131 | 2024-01-27 05:00:45 | spyglass | 4 | 161609 | 315 | 15.093 | 10707.5 |
130 | 2024-01-26 22:25:03 | spyglass | 4 | 161609 | 315 | 11.956 | 13517.0 |
129 | 2024-01-26 22:24:19 | spyglass | 2 | 121059 | 3 | 3.640 | 33258.0 |
128 | 2024-01-26 22:24:15 | spyglass | 3 | 146162 | 19 | 7.453 | 19611.2 |
127 | 2024-01-26 05:39:33 | spyglass | 3 | 146162 | 19 | 13.003 | 11240.6 |
126 | 2024-01-25 23:12:35 | spyglass | 3 | 146162 | 19 | 7.580 | 19282.6 |
125 | 2024-01-25 23:12:31 | spyglass | 2 | 121059 | 3 | 3.733 | 32429.4 |
124 | 2024-01-18 15:46:15 | spyglass | 1 | 82945 | 1 | 1.453 | 57085.3 |
123 | 2024-01-07 21:47:47 | spyglass | 1 | 82945 | 1 | 1.516 | 54713.1 |
122 | 2023-12-14 06:32:48 | spyglass | 1 | 82945 | 1 | 1.300 | 63803.8 |
121 | 2023-10-01 01:45:47 | spyglass | 1 | 82945 | 1 | 1.390 | 59672.7 |
120 | 2023-09-15 20:36:37 | spyglass | 1 | 82945 | 1 | 1.296 | 64000.8 |
119 | 2023-09-01 01:44:03 | spyglass | 1 | 82945 | 1 | 1.283 | 64649.3 |
118 | 2023-08-28 17:50:26 | spyglass | 1 | 82945 | 1 | 1.343 | 61761.0 |
117 | 2023-07-29 02:54:42 | spyglass | 1 | 82945 | 1 | 1.423 | 58288.8 |
116 | 2023-04-28 05:43:21 | spyglass | 1 | 82945 | 1 | 1.453 | 57085.3 |
115 | 2023-03-14 20:58:18 | spyglass | 1 | 82945 | 1 | 1.263 | 65673.0 |
114 | 2023-02-21 14:38:21 | spyglass | 1 | 82945 | 1 | 1.483 | 55930.5 |
113 | 2022-12-22 00:56:32 | spyglass | 1 | 82945 | 1 | 1.263 | 65673.0 |
112 | 2022-12-05 05:54:26 | spyglass | 1 | 82945 | 1 | 1.266 | 65517.4 |
111 | 2022-12-02 14:14:23 | spyglass | 1 | 82945 | 1 | 1.250 | 66356.0 |
110 | 2022-11-30 19:49:16 | spyglass | 1 | 82945 | 1 | 1.266 | 65517.4 |
109 | 2022-11-28 06:47:27 | spyglass | 1 | 82945 | 1 | 1.283 | 64649.3 |
108 | 2022-10-07 17:02:06 | spyglass | 1 | 82945 | 1 | 1.300 | 63803.8 |
107 | 2022-10-04 04:43:06 | spyglass | 1 | 82945 | 1 | 1.283 | 64649.3 |
106 | 2022-09-06 12:13:36 | spyglass | 1 | 82945 | 1 | 1.266 | 65517.4 |
105 | 2022-09-05 09:15:59 | spyglass | 4 | 161609 | 315 | 11.906 | 13573.7 |
104 | 2022-09-01 17:13:59 | spyglass | 4 | 161609 | 315 | 10.390 | 15554.3 |
103 | 2022-07-14 13:18:17 | spyglass | 4 | 161609 | 315 | 11.626 | 13900.7 |
102 | 2022-05-05 03:07:10 | spyglass | 1 | 82945 | 1 | 1.280 | 64800.8 |
101 | 2022-04-11 23:32:36 | spyglass | 1 | 82945 | 1 | 1.326 | 62552.8 |
100 | 2021-11-01 10:28:33 | spyglass | 1 | 82945 | 1 | 1.483 | 55930.5 |
99 | 2021-06-20 14:43:00 | spyglass | 1 | 82945 | 1 | 1.313 | 63172.1 |
98 | 2021-02-24 20:30:52 | spyglass | 1 | 82945 | 1 | 1.516 | 54713.1 |
97 | 2020-10-15 06:58:37 | spyglass | 1 | 82945 | 1 | 1.296 | 64000.8 |
96 | 2020-07-29 07:24:09 | spyglass | 1 | 82945 | 1 | 1.406 | 58993.6 |
95 | 2020-06-11 14:16:57 | spyglass | 1 | 82945 | 1 | 1.470 | 56425.2 |
94 | 2020-04-06 09:03:29 | spyglass | 1 | 82945 | 1 | 1.436 | 57761.1 |
93 | 2020-03-28 15:52:23 | spyglass | 1 | 82945 | 1 | 1.483 | 55930.5 |
92 | 2020-03-26 11:45:39 | spyglass | 1 | 82945 | 1 | 1.546 | 53651.4 |
91 | 2020-02-09 15:27:56 | spyglass | 1 | 82945 | 1 | 1.530 | 54212.4 |
90 | 2020-02-06 15:34:10 | spyglass | 1 | 82945 | 1 | 1.440 | 57600.7 |
89 | 2020-02-05 16:56:53 | spyglass | 1 | 82945 | 1 | 1.500 | 55296.7 |
88 | 2020-02-04 14:54:27 | spyglass | 1 | 82945 | 1 | 3.266 | 25396.5 |
87 | 2020-01-30 14:02:08 | spyglass | 1 | 82945 | 1 | 1.343 | 61761.0 |
86 | 2020-01-27 23:00:20 | spyglass | 1 | 82945 | 1 | 1.453 | 57085.3 |
85 | 2020-01-25 00:06:31 | spyglass | 1 | 82945 | 1 | 1.670 | 49667.7 |
84 | 2020-01-04 22:47:08 | spyglass | 1 | 82945 | 1 | 2.470 | 33581.0 |
83 | 2020-01-03 07:12:29 | spyglass | 1 | 82945 | 1 | 1.610 | 51518.6 |
82 | 2019-11-21 10:40:08 | spyglass | 1 | 82945 | 1 | 1.436 | 57761.1 |
81 | 2019-10-24 07:11:02 | spyglass | 1 | 82945 | 1 | 1.500 | 55296.7 |
80 | 2019-09-01 12:23:01 | spyglass | 1 | 82945 | 1 | 1.210 | 68549.6 |