History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gallica"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
261 | 2024-04-10 10:21:14 | gallica | 1 | 69583 | 4 | 3.296 | 21111.3 |
260 | 2024-03-31 19:36:41 | gallica | 1 | 69583 | 4 | 1.326 | 52475.9 |
259 | 2024-03-09 04:43:54 | gallica | 1 | 69583 | 4 | 1.046 | 66522.9 |
258 | 2024-03-01 20:56:59 | gallica | 1 | 69583 | 4 | 1.373 | 50679.5 |
257 | 2024-02-28 17:38:33 | gallica | 1 | 69583 | 4 | 1.110 | 62687.4 |
256 | 2024-02-04 19:46:01 | gallica | 2 | 107671 | 13 | 3.546 | 30364.1 |
255 | 2024-02-04 19:45:41 | gallica | 3 | 134027 | 150 | 8.936 | 14998.5 |
254 | 2024-02-04 11:59:54 | gallica | 3 | 134027 | 150 | 10.406 | 12879.8 |
253 | 2024-02-03 06:34:59 | gallica | 3 | 134027 | 150 | 8.033 | 16684.6 |
252 | 2024-01-31 23:10:04 | gallica | 2 | 107671 | 13 | 3.580 | 30075.7 |
251 | 2024-01-31 23:09:52 | gallica | 3 | 134027 | 150 | 6.813 | 19672.2 |
250 | 2024-01-31 23:09:03 | gallica | 2 | 107671 | 13 | 3.563 | 30219.2 |
249 | 2024-01-31 23:04:23 | gallica | 3 | 134027 | 150 | 7.220 | 18563.3 |
248 | 2024-01-31 10:37:14 | gallica | 3 | 134027 | 150 | 13.360 | 10032.0 |
247 | 2024-01-04 04:56:40 | gallica | 2 | 107671 | 13 | 2.830 | 38046.3 |
246 | 2023-12-23 01:42:42 | gallica | 1 | 69583 | 4 | 1.266 | 54962.9 |
245 | 2023-12-21 19:21:44 | gallica | 1 | 69583 | 4 | 1.156 | 60192.9 |
244 | 2023-12-15 21:08:21 | gallica | 3 | 134027 | 150 | 7.720 | 17361.0 |
243 | 2023-12-09 09:58:21 | gallica | 3 | 134027 | 150 | 16.080 | 8335.0 |
242 | 2023-11-29 09:49:45 | gallica | 1 | 69583 | 4 | 1.093 | 63662.4 |
241 | 2023-11-18 18:07:58 | gallica | 1 | 69583 | 4 | 1.186 | 58670.3 |
240 | 2023-11-11 03:33:19 | gallica | 3 | 134027 | 150 | 8.016 | 16719.9 |
239 | 2023-11-03 18:13:00 | gallica | 1 | 69583 | 4 | 1.216 | 57222.9 |
238 | 2023-10-08 15:19:05 | gallica | 1 | 69583 | 4 | 1.110 | 62687.4 |
237 | 2023-10-08 02:46:59 | gallica | 2 | 107671 | 13 | 2.843 | 37872.3 |
236 | 2023-09-15 17:26:12 | gallica | 1 | 69583 | 4 | 1.110 | 62687.4 |
235 | 2023-08-13 09:00:47 | gallica | 3 | 134027 | 150 | 5.873 | 22820.9 |
234 | 2023-08-04 08:17:36 | gallica | 1 | 69583 | 4 | 1.140 | 61037.7 |
233 | 2023-08-02 17:48:57 | gallica | 1 | 69583 | 4 | 1.046 | 66522.9 |
232 | 2023-07-19 12:16:01 | gallica | 2 | 107671 | 13 | 3.186 | 33795.0 |
231 | 2023-04-29 22:20:03 | gallica | 1 | 69583 | 4 | 1.186 | 58670.3 |
230 | 2023-04-29 00:58:19 | gallica | 3 | 134027 | 150 | 5.860 | 22871.5 |
229 | 2023-04-21 14:42:54 | gallica | 1 | 69583 | 4 | 1.063 | 65459.1 |
228 | 2023-04-02 22:59:57 | gallica | 2 | 107671 | 13 | 2.830 | 38046.3 |
227 | 2023-02-19 18:14:24 | gallica | 1 | 69583 | 4 | 1.063 | 65459.1 |
226 | 2023-02-03 07:36:03 | gallica | 3 | 134027 | 150 | 5.673 | 23625.4 |
225 | 2023-01-01 17:39:48 | gallica | 1 | 69583 | 4 | 1.076 | 64668.2 |
224 | 2022-12-29 21:50:49 | gallica | 2 | 107671 | 13 | 2.796 | 38508.9 |
223 | 2022-12-16 07:50:32 | gallica | 1 | 69583 | 4 | 1.076 | 64668.2 |
222 | 2022-11-15 10:33:58 | gallica | 3 | 134027 | 150 | 5.876 | 22809.2 |
221 | 2022-09-19 12:25:16 | gallica | 1 | 69583 | 4 | 1.266 | 54962.9 |
220 | 2022-09-07 10:30:58 | gallica | 1 | 69583 | 4 | 1.080 | 64428.7 |
219 | 2022-09-01 10:42:40 | gallica | 2 | 107671 | 13 | 2.936 | 36672.7 |
218 | 2022-08-24 00:13:48 | gallica | 1 | 69583 | 4 | 1.046 | 66522.9 |
217 | 2022-08-21 15:11:21 | gallica | 1 | 69583 | 4 | 1.076 | 64668.2 |
216 | 2022-08-14 15:46:25 | gallica | 1 | 69583 | 4 | 1.233 | 56433.9 |
215 | 2022-07-28 23:58:55 | gallica | 1 | 69583 | 4 | 1.250 | 55666.4 |
214 | 2022-07-10 09:39:05 | gallica | 1 | 69583 | 4 | 1.110 | 62687.4 |
213 | 2022-07-02 19:10:55 | gallica | 1 | 69583 | 4 | 1.046 | 66522.9 |
212 | 2022-06-18 13:00:24 | gallica | 3 | 134027 | 150 | 5.673 | 23625.4 |
211 | 2022-05-12 09:29:48 | gallica | 1 | 69583 | 4 | 1.453 | 47889.2 |
210 | 2022-04-12 12:33:21 | gallica | 1 | 69583 | 4 | 1.576 | 44151.6 |
209 | 2022-04-11 05:44:21 | gallica | 1 | 69583 | 4 | 1.190 | 58473.1 |
208 | 2022-01-22 03:12:22 | gallica | 1 | 69583 | 4 | 1.063 | 65459.1 |
207 | 2022-01-21 02:00:28 | gallica | 1 | 69583 | 4 | 1.203 | 57841.2 |
206 | 2022-01-17 19:34:23 | gallica | 1 | 69583 | 4 | 1.343 | 51811.6 |
205 | 2022-01-14 12:47:10 | gallica | 1 | 69583 | 4 | 1.300 | 53525.4 |
204 | 2021-11-15 16:42:00 | gallica | 1 | 69583 | 4 | 1.093 | 63662.4 |
203 | 2021-10-11 11:06:08 | gallica | 1 | 69583 | 4 | 1.060 | 65644.3 |
202 | 2021-07-09 22:34:40 | gallica | 1 | 69583 | 4 | 1.153 | 60349.5 |
201 | 2021-05-26 04:18:52 | gallica | 1 | 69583 | 4 | 1.326 | 52475.9 |
200 | 2021-05-22 06:43:12 | gallica | 2 | 107671 | 13 | 2.890 | 37256.4 |
199 | 2021-04-30 03:58:19 | gallica | 1 | 69583 | 4 | 1.360 | 51164.0 |
198 | 2021-04-23 02:45:56 | gallica | 2 | 107671 | 13 | 3.313 | 32499.5 |
197 | 2021-04-06 02:08:55 | gallica | 1 | 69583 | 4 | 2.470 | 28171.3 |
196 | 2021-04-01 22:17:45 | gallica | 1 | 69583 | 4 | 1.313 | 52995.4 |
195 | 2021-03-25 07:22:00 | gallica | 2 | 107671 | 13 | 3.216 | 33479.8 |
194 | 2021-03-03 13:11:06 | gallica | 1 | 69583 | 4 | 1.140 | 61037.7 |
193 | 2021-02-27 12:03:55 | gallica | 2 | 107671 | 13 | 2.953 | 36461.6 |
192 | 2021-02-07 10:47:13 | gallica | 1 | 69583 | 4 | 1.173 | 59320.5 |
191 | 2021-02-03 14:06:02 | gallica | 2 | 107671 | 13 | 3.580 | 30075.7 |
190 | 2020-12-24 16:12:24 | gallica | 1 | 69583 | 4 | 1.076 | 64668.2 |
189 | 2020-10-30 11:35:09 | gallica | 1 | 69583 | 4 | 1.110 | 62687.4 |
188 | 2020-10-03 18:18:12 | gallica | 1 | 69583 | 4 | 1.093 | 63662.4 |
187 | 2020-09-30 17:12:22 | gallica | 1 | 69583 | 4 | 1.110 | 62687.4 |
186 | 2020-09-20 19:40:54 | gallica | 1 | 69583 | 4 | 1.060 | 65644.3 |
185 | 2020-08-29 11:49:15 | gallica | 1 | 69583 | 4 | 1.140 | 61037.7 |
184 | 2020-06-04 10:54:21 | gallica | 1 | 69583 | 4 | 1.170 | 59472.6 |
183 | 2020-03-27 01:12:53 | gallica | 1 | 69583 | 4 | 1.346 | 51696.1 |
182 | 2020-03-24 16:23:49 | gallica | 1 | 69583 | 4 | 2.563 | 27149.0 |
181 | 2020-03-22 01:26:13 | gallica | 1 | 69583 | 4 | 1.310 | 53116.8 |
180 | 2020-03-02 22:33:17 | gallica | 1 | 69583 | 4 | 1.280 | 54361.7 |
179 | 2020-02-29 00:47:43 | gallica | 1 | 69583 | 4 | 1.233 | 56433.9 |
178 | 2020-02-25 02:21:21 | gallica | 1 | 69583 | 4 | 1.186 | 58670.3 |
177 | 2020-02-21 06:33:33 | gallica | 1 | 69583 | 4 | 1.266 | 54962.9 |
176 | 2020-02-18 01:57:34 | gallica | 1 | 69583 | 4 | 2.623 | 26528.0 |
175 | 2020-02-12 19:31:02 | gallica | 1 | 69583 | 4 | 1.360 | 51164.0 |
174 | 2020-02-12 10:56:48 | gallica | 3 | 134027 | 150 | 15.576 | 8604.7 |
173 | 2020-02-12 00:44:23 | gallica | 3 | 134027 | 150 | 9.546 | 14040.1 |
172 | 2020-02-11 10:18:30 | gallica | 1 | 69583 | 4 | 1.313 | 52995.4 |
171 | 2020-02-07 04:32:30 | gallica | 1 | 69583 | 4 | 2.470 | 28171.3 |
170 | 2020-02-07 02:38:17 | gallica | 1 | 69583 | 4 | 2.843 | 24475.2 |
169 | 2020-01-27 03:09:45 | gallica | 1 | 69583 | 4 | 1.390 | 50059.7 |
168 | 2020-01-27 00:14:13 | gallica | 1 | 69583 | 4 | 2.080 | 33453.4 |
167 | 2020-01-24 02:05:37 | gallica | 1 | 69583 | 4 | 1.236 | 56296.9 |
166 | 2020-01-20 20:10:46 | gallica | 3 | 134027 | 150 | 13.156 | 10187.5 |
165 | 2020-01-20 19:37:43 | gallica | 3 | 134027 | 150 | 15.893 | 8433.1 |
164 | 2020-01-20 15:27:17 | gallica | 3 | 134027 | 150 | 7.686 | 17437.8 |
163 | 2020-01-20 15:24:57 | gallica | 2 | 107671 | 13 | 11.203 | 9610.9 |
162 | 2020-01-20 10:30:19 | gallica | 1 | 69583 | 4 | 1.330 | 52318.0 |