History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canonist"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
306 | 2024-05-02 02:14:23 | canonist | 1 | 82945 | 4 | 1.686 | 49196.3 |
305 | 2024-04-30 08:59:31 | canonist | 2 | 121059 | 15 | 13.690 | 8842.9 |
304 | 2024-04-30 08:19:49 | canonist | 1 | 82945 | 4 | 2.623 | 31622.2 |
303 | 2024-04-23 03:21:36 | canonist | 2 | 121059 | 15 | 5.550 | 21812.4 |
302 | 2024-04-23 03:21:25 | canonist | 1 | 82945 | 4 | 2.233 | 37145.1 |
301 | 2024-04-08 03:34:01 | canonist | 3 | 146162 | 115 | 17.360 | 8419.5 |
300 | 2024-04-07 11:51:28 | canonist | 3 | 146162 | 115 | 19.640 | 7442.1 |
299 | 2024-04-06 17:28:46 | canonist | 3 | 146162 | 115 | 12.783 | 11434.1 |
298 | 2024-04-06 15:53:24 | canonist | 2 | 121059 | 15 | 3.936 | 30756.9 |
297 | 2024-04-05 18:24:06 | canonist | 1 | 82945 | 4 | 5.110 | 16231.9 |
296 | 2024-04-05 18:20:47 | canonist | 2 | 121059 | 15 | 12.686 | 9542.7 |
295 | 2024-04-05 18:20:45 | canonist | 3 | 146162 | 115 | 13.173 | 11095.6 |
294 | 2024-03-30 06:12:04 | canonist | 2 | 121059 | 15 | 13.643 | 8873.3 |
293 | 2024-03-30 05:28:39 | canonist | 1 | 82945 | 4 | 3.110 | 26670.4 |
292 | 2024-03-23 18:06:23 | canonist | 1 | 82945 | 4 | 4.296 | 19307.5 |
291 | 2024-03-07 18:30:57 | canonist | 3 | 146162 | 115 | 14.360 | 10178.4 |
290 | 2024-03-07 09:45:14 | canonist | 3 | 146162 | 115 | 24.860 | 5879.4 |
289 | 2024-03-06 14:28:05 | canonist | 3 | 146162 | 115 | 6.986 | 20922.1 |
288 | 2024-03-06 13:35:28 | canonist | 3 | 146162 | 115 | 10.266 | 14237.5 |
287 | 2024-03-06 13:35:31 | canonist | 1 | 82945 | 4 | 2.560 | 32400.4 |
286 | 2024-03-06 13:35:27 | canonist | 2 | 121059 | 15 | 4.580 | 26432.1 |
285 | 2024-03-06 13:35:22 | canonist | 2 | 121059 | 15 | 4.873 | 24842.8 |
284 | 2024-03-06 13:35:16 | canonist | 1 | 82945 | 4 | 1.640 | 50576.2 |
283 | 2024-02-28 21:36:12 | canonist | 1 | 82945 | 4 | 1.610 | 51518.6 |
282 | 2024-02-22 12:34:58 | canonist | 1 | 82945 | 4 | 1.720 | 48223.8 |
281 | 2024-02-05 23:55:34 | canonist | 3 | 146162 | 115 | 11.673 | 12521.4 |
280 | 2024-02-05 08:25:26 | canonist | 3 | 146162 | 115 | 8.813 | 16584.8 |
279 | 2024-02-04 20:09:27 | canonist | 3 | 146162 | 115 | 8.436 | 17326.0 |
278 | 2024-02-02 12:57:16 | canonist | 2 | 121059 | 15 | 3.563 | 33976.7 |
277 | 2024-01-31 22:30:36 | canonist | 3 | 146162 | 115 | 16.766 | 8717.8 |
276 | 2024-01-31 02:08:50 | canonist | 3 | 146162 | 115 | 10.063 | 14524.7 |
275 | 2024-01-26 07:08:01 | canonist | 1 | 82945 | 4 | 1.546 | 53651.4 |
274 | 2024-01-11 04:09:18 | canonist | 1 | 82945 | 4 | 1.330 | 62364.7 |
273 | 2024-01-09 17:25:34 | canonist | 1 | 82945 | 4 | 2.983 | 27805.9 |
272 | 2024-01-06 15:54:17 | canonist | 3 | 146162 | 115 | 7.186 | 20339.8 |
271 | 2024-01-06 15:54:15 | canonist | 2 | 121059 | 15 | 3.733 | 32429.4 |
270 | 2023-12-11 21:35:10 | canonist | 1 | 82945 | 4 | 1.466 | 56579.1 |
269 | 2023-12-10 14:12:44 | canonist | 3 | 146162 | 115 | 8.106 | 18031.3 |
268 | 2023-11-23 14:54:09 | canonist | 1 | 82945 | 4 | 1.500 | 55296.7 |
267 | 2023-11-23 07:51:17 | canonist | 1 | 82945 | 4 | 2.640 | 31418.6 |
266 | 2023-11-21 14:39:33 | canonist | 3 | 146162 | 115 | 6.750 | 21653.6 |
265 | 2023-11-21 14:39:26 | canonist | 2 | 121059 | 15 | 3.233 | 37444.8 |
264 | 2023-11-18 12:30:44 | canonist | 3 | 146162 | 115 | 8.830 | 16552.9 |
263 | 2023-11-08 10:29:53 | canonist | 3 | 146162 | 115 | 6.766 | 21602.4 |
262 | 2023-10-31 14:20:06 | canonist | 1 | 82945 | 4 | 1.643 | 50483.9 |
261 | 2023-10-21 16:46:06 | canonist | 1 | 82945 | 4 | 1.423 | 58288.8 |
260 | 2023-10-19 19:05:27 | canonist | 1 | 82945 | 4 | 2.390 | 34705.0 |
259 | 2023-10-11 11:42:30 | canonist | 1 | 82945 | 4 | 1.296 | 64000.8 |
258 | 2023-09-28 12:22:26 | canonist | 1 | 82945 | 4 | 1.750 | 47397.1 |
257 | 2023-09-15 01:24:05 | canonist | 1 | 82945 | 4 | 1.390 | 59672.7 |
256 | 2023-09-09 23:56:20 | canonist | 1 | 82945 | 4 | 1.296 | 64000.8 |
255 | 2023-08-12 10:24:10 | canonist | 3 | 146162 | 115 | 6.656 | 21959.4 |
254 | 2023-06-16 02:20:30 | canonist | 1 | 82945 | 4 | 1.326 | 62552.8 |
253 | 2023-06-01 05:48:31 | canonist | 1 | 82945 | 4 | 1.296 | 64000.8 |
252 | 2023-04-25 10:36:04 | canonist | 3 | 146162 | 115 | 6.330 | 23090.4 |
251 | 2023-03-30 16:58:49 | canonist | 1 | 82945 | 4 | 1.483 | 55930.5 |
250 | 2023-02-16 05:33:36 | canonist | 1 | 82945 | 4 | 1.436 | 57761.1 |
249 | 2023-01-29 20:00:43 | canonist | 3 | 146162 | 115 | 6.373 | 22934.6 |
248 | 2023-01-13 05:44:58 | canonist | 1 | 82945 | 4 | 1.296 | 64000.8 |
247 | 2022-11-10 11:13:55 | canonist | 3 | 146162 | 115 | 6.826 | 21412.5 |
246 | 2022-10-22 20:08:15 | canonist | 1 | 82945 | 4 | 1.296 | 64000.8 |
245 | 2022-10-20 07:52:37 | canonist | 1 | 82945 | 4 | 1.516 | 54713.1 |
244 | 2022-08-05 05:23:10 | canonist | 1 | 82945 | 4 | 1.360 | 60989.0 |
243 | 2022-07-16 22:13:20 | canonist | 2 | 121059 | 15 | 3.263 | 37100.5 |
242 | 2022-07-02 23:16:12 | canonist | 1 | 82945 | 4 | 1.296 | 64000.8 |
241 | 2022-06-17 03:39:16 | canonist | 1 | 82945 | 4 | 1.436 | 57761.1 |
240 | 2022-06-09 18:40:27 | canonist | 3 | 146162 | 115 | 7.220 | 20244.0 |
239 | 2022-06-09 14:37:31 | canonist | 1 | 82945 | 4 | 1.516 | 54713.1 |
238 | 2022-03-19 06:47:07 | canonist | 1 | 82945 | 4 | 1.486 | 55817.6 |
237 | 2022-03-15 20:17:49 | canonist | 1 | 82945 | 4 | 1.530 | 54212.4 |
236 | 2022-02-17 05:00:15 | canonist | 1 | 82945 | 4 | 1.343 | 61761.0 |
235 | 2022-02-02 07:33:07 | canonist | 3 | 146162 | 115 | 7.923 | 18447.8 |
234 | 2021-12-02 09:09:00 | canonist | 1 | 82945 | 4 | 1.640 | 50576.2 |
233 | 2021-11-28 17:10:56 | canonist | 1 | 82945 | 4 | 1.483 | 55930.5 |
232 | 2021-11-15 17:44:08 | canonist | 1 | 82945 | 4 | 1.343 | 61761.0 |
231 | 2021-11-15 04:28:38 | canonist | 1 | 82945 | 4 | 1.720 | 48223.8 |
230 | 2021-11-14 17:53:51 | canonist | 1 | 82945 | 4 | 1.483 | 55930.5 |
229 | 2021-11-14 03:18:21 | canonist | 1 | 82945 | 4 | 1.563 | 53067.8 |
228 | 2021-11-13 18:40:02 | canonist | 1 | 82945 | 4 | 1.356 | 61168.9 |
227 | 2021-11-13 04:40:14 | canonist | 1 | 82945 | 4 | 1.500 | 55296.7 |
226 | 2021-11-12 18:37:12 | canonist | 1 | 82945 | 4 | 1.920 | 43200.5 |
225 | 2021-11-11 21:30:48 | canonist | 1 | 82945 | 4 | 1.296 | 64000.8 |
224 | 2021-11-11 10:36:52 | canonist | 1 | 82945 | 4 | 1.563 | 53067.8 |
223 | 2021-11-11 00:40:19 | canonist | 1 | 82945 | 4 | 1.576 | 52630.1 |
222 | 2021-10-26 04:32:30 | canonist | 1 | 82945 | 4 | 1.516 | 54713.1 |
221 | 2021-10-14 17:15:10 | canonist | 1 | 82945 | 4 | 1.546 | 53651.4 |
220 | 2021-10-13 20:28:46 | canonist | 1 | 82945 | 4 | 1.500 | 55296.7 |
219 | 2021-10-12 13:01:47 | canonist | 1 | 82945 | 4 | 1.343 | 61761.0 |
218 | 2021-10-11 15:53:27 | canonist | 1 | 82945 | 4 | 1.483 | 55930.5 |
217 | 2021-10-10 12:53:36 | canonist | 1 | 82945 | 4 | 1.563 | 53067.8 |
216 | 2021-09-20 11:52:13 | canonist | 1 | 82945 | 4 | 1.516 | 54713.1 |
215 | 2021-09-19 10:59:14 | canonist | 1 | 82945 | 4 | 1.500 | 55296.7 |
214 | 2021-09-13 07:41:12 | canonist | 1 | 82945 | 4 | 1.343 | 61761.0 |
213 | 2021-08-19 02:00:22 | canonist | 1 | 82945 | 4 | 1.313 | 63172.1 |
212 | 2021-08-03 07:57:28 | canonist | 3 | 146162 | 115 | 6.440 | 22696.0 |
211 | 2021-06-03 23:42:52 | canonist | 1 | 82945 | 4 | 1.466 | 56579.1 |
210 | 2021-05-15 03:04:10 | canonist | 1 | 82945 | 4 | 1.483 | 55930.5 |
209 | 2021-04-08 09:48:38 | canonist | 1 | 82945 | 4 | 1.376 | 60279.8 |
208 | 2021-03-27 16:13:53 | canonist | 2 | 121059 | 15 | 3.690 | 32807.3 |
207 | 2021-03-12 15:22:27 | canonist | 1 | 82945 | 4 | 1.516 | 54713.1 |