History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bylaw"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
394 | 2024-03-28 01:36:13 | bylaw | 1 | 28756 | 4 | 0.436 | 65954.1 |
393 | 2024-03-06 11:50:33 | bylaw | 1 | 28756 | 4 | 1.106 | 26000.0 |
392 | 2024-03-02 23:38:48 | bylaw | 3 | 83667 | 505 | 4.080 | 20506.6 |
391 | 2024-03-02 23:38:48 | bylaw | 2 | 53800 | 35 | 1.686 | 31909.8 |
390 | 2024-03-01 12:22:13 | bylaw | 1 | 28756 | 4 | 0.483 | 59536.2 |
389 | 2024-03-01 07:42:12 | bylaw | 2 | 53800 | 35 | 1.623 | 33148.5 |
388 | 2024-03-01 07:42:07 | bylaw | 3 | 83667 | 505 | 3.643 | 22966.5 |
387 | 2024-03-01 07:42:03 | bylaw | 1 | 28756 | 4 | 0.436 | 65954.1 |
386 | 2024-01-31 10:45:27 | bylaw | 2 | 53800 | 35 | 1.703 | 31591.3 |
385 | 2024-01-31 10:45:23 | bylaw | 3 | 83667 | 505 | 4.173 | 20049.6 |
384 | 2024-01-31 00:41:07 | bylaw | 2 | 53800 | 35 | 2.923 | 18405.7 |
383 | 2024-01-31 00:40:51 | bylaw | 3 | 83667 | 505 | 3.296 | 25384.4 |
382 | 2024-01-30 16:27:35 | bylaw | 3 | 83667 | 505 | 3.626 | 23074.2 |
381 | 2024-01-30 16:27:27 | bylaw | 1 | 28756 | 4 | 0.456 | 63061.4 |
380 | 2024-01-25 18:43:50 | bylaw | 2 | 53800 | 35 | 1.623 | 33148.5 |
379 | 2024-01-13 02:01:40 | bylaw | 3 | 83667 | 505 | 3.156 | 26510.5 |
378 | 2023-12-31 02:29:05 | bylaw | 3 | 83667 | 505 | 3.296 | 25384.4 |
377 | 2023-12-31 02:29:03 | bylaw | 2 | 53800 | 35 | 1.500 | 35866.7 |
376 | 2023-12-27 22:01:57 | bylaw | 1 | 28756 | 4 | 0.516 | 55728.7 |
375 | 2023-12-26 17:08:01 | bylaw | 1 | 28756 | 4 | 0.423 | 67981.1 |
374 | 2023-12-18 19:56:47 | bylaw | 2 | 53800 | 35 | 1.406 | 38264.6 |
373 | 2023-12-18 19:56:44 | bylaw | 3 | 83667 | 505 | 3.376 | 24782.9 |
372 | 2023-11-13 22:52:53 | bylaw | 1 | 28756 | 4 | 0.466 | 61708.2 |
371 | 2023-11-12 07:32:58 | bylaw | 1 | 28756 | 4 | 0.516 | 55728.7 |
370 | 2023-11-06 00:10:08 | bylaw | 2 | 53800 | 35 | 1.393 | 38621.7 |
369 | 2023-11-03 08:51:53 | bylaw | 1 | 28756 | 4 | 0.516 | 55728.7 |
368 | 2023-11-03 03:39:14 | bylaw | 1 | 28756 | 4 | 0.970 | 29645.4 |
367 | 2023-10-27 02:55:30 | bylaw | 3 | 83667 | 505 | 8.783 | 9526.0 |
366 | 2023-10-24 14:11:12 | bylaw | 3 | 83667 | 505 | 7.233 | 11567.4 |
365 | 2023-10-22 22:32:09 | bylaw | 3 | 83667 | 505 | 3.110 | 26902.6 |
364 | 2023-10-20 14:20:41 | bylaw | 1 | 28756 | 4 | 0.486 | 59168.7 |
363 | 2023-10-18 05:49:54 | bylaw | 1 | 28756 | 4 | 0.436 | 65954.1 |
362 | 2023-10-15 13:55:03 | bylaw | 1 | 28756 | 4 | 0.530 | 54256.6 |
361 | 2023-10-12 16:17:00 | bylaw | 1 | 28756 | 4 | 0.483 | 59536.2 |
360 | 2023-10-05 19:12:39 | bylaw | 1 | 28756 | 4 | 0.453 | 63479.0 |
359 | 2023-09-24 02:27:34 | bylaw | 1 | 28756 | 4 | 0.486 | 59168.7 |
358 | 2023-09-23 17:31:20 | bylaw | 1 | 28756 | 4 | 0.970 | 29645.4 |
357 | 2023-08-14 00:28:25 | bylaw | 1 | 28756 | 4 | 0.453 | 63479.0 |
356 | 2023-08-10 05:00:15 | bylaw | 2 | 53800 | 35 | 1.516 | 35488.1 |
355 | 2023-08-02 09:22:41 | bylaw | 3 | 83667 | 505 | 3.250 | 25743.7 |
354 | 2023-06-18 23:23:20 | bylaw | 1 | 28756 | 4 | 0.440 | 65354.5 |
353 | 2023-05-15 19:04:40 | bylaw | 1 | 28756 | 4 | 0.470 | 61183.0 |
352 | 2023-04-25 05:25:24 | bylaw | 2 | 53800 | 35 | 1.313 | 40974.9 |
351 | 2023-04-09 17:59:42 | bylaw | 3 | 83667 | 505 | 3.080 | 27164.6 |
350 | 2023-03-11 11:56:15 | bylaw | 1 | 28756 | 4 | 0.466 | 61708.2 |
349 | 2023-02-24 11:12:19 | bylaw | 1 | 28756 | 4 | 0.423 | 67981.1 |
348 | 2023-01-29 15:45:36 | bylaw | 2 | 53800 | 35 | 1.360 | 39558.8 |
347 | 2023-01-15 06:12:34 | bylaw | 3 | 83667 | 505 | 3.530 | 23701.7 |
346 | 2022-12-30 11:53:58 | bylaw | 1 | 28756 | 4 | 0.486 | 59168.7 |
345 | 2022-11-11 19:45:21 | bylaw | 2 | 53800 | 35 | 1.500 | 35866.7 |
344 | 2022-10-24 08:00:21 | bylaw | 1 | 28756 | 4 | 0.440 | 65354.5 |
343 | 2022-10-20 17:57:42 | bylaw | 1 | 28756 | 4 | 0.423 | 67981.1 |
342 | 2022-10-20 16:10:17 | bylaw | 3 | 83667 | 505 | 4.720 | 17726.1 |
341 | 2022-09-20 17:56:50 | bylaw | 1 | 28756 | 4 | 0.936 | 30722.2 |
340 | 2022-06-26 20:37:02 | bylaw | 1 | 28756 | 4 | 0.420 | 68466.7 |
339 | 2022-06-14 10:55:08 | bylaw | 1 | 28756 | 4 | 0.470 | 61183.0 |
338 | 2022-06-13 08:29:33 | bylaw | 2 | 53800 | 35 | 1.546 | 34799.5 |
337 | 2022-05-21 12:53:22 | bylaw | 3 | 83667 | 505 | 3.143 | 26620.1 |
336 | 2022-05-19 08:16:45 | bylaw | 3 | 83667 | 505 | 3.220 | 25983.5 |
335 | 2022-04-30 03:29:54 | bylaw | 1 | 28756 | 4 | 0.420 | 68466.7 |
334 | 2022-03-07 02:48:33 | bylaw | 1 | 28756 | 4 | 0.500 | 57512.0 |
333 | 2022-02-01 10:42:10 | bylaw | 2 | 53800 | 35 | 1.406 | 38264.6 |
332 | 2022-01-30 07:25:01 | bylaw | 2 | 53800 | 35 | 1.466 | 36698.5 |
331 | 2022-01-25 15:22:43 | bylaw | 1 | 28756 | 4 | 0.453 | 63479.0 |
330 | 2022-01-14 10:51:25 | bylaw | 3 | 83667 | 505 | 3.923 | 21327.3 |
329 | 2021-11-23 11:32:40 | bylaw | 1 | 28756 | 4 | 0.516 | 55728.7 |
328 | 2021-11-21 01:35:18 | bylaw | 1 | 28756 | 4 | 0.483 | 59536.2 |
327 | 2021-11-17 03:46:25 | bylaw | 2 | 53800 | 35 | 1.533 | 35094.6 |
326 | 2021-10-08 21:11:19 | bylaw | 1 | 28756 | 4 | 0.423 | 67981.1 |
325 | 2021-09-09 01:37:31 | bylaw | 1 | 28756 | 4 | 0.436 | 65954.1 |
324 | 2021-08-22 10:13:31 | bylaw | 1 | 28756 | 4 | 0.486 | 59168.7 |
323 | 2021-08-13 20:04:46 | bylaw | 1 | 28756 | 4 | 0.436 | 65954.1 |
322 | 2021-06-07 05:07:46 | bylaw | 1 | 28756 | 4 | 0.530 | 54256.6 |
321 | 2021-05-13 01:53:47 | bylaw | 1 | 28756 | 4 | 0.440 | 65354.5 |
320 | 2021-05-09 13:41:21 | bylaw | 1 | 28756 | 4 | 1.420 | 20250.7 |
319 | 2021-04-11 22:21:57 | bylaw | 1 | 28756 | 4 | 0.533 | 53951.2 |
318 | 2021-03-15 20:56:39 | bylaw | 1 | 28756 | 4 | 0.500 | 57512.0 |
317 | 2021-02-04 00:47:48 | bylaw | 1 | 28756 | 4 | 0.420 | 68466.7 |
316 | 2021-01-26 01:12:15 | bylaw | 1 | 28756 | 4 | 0.470 | 61183.0 |
315 | 2020-11-02 10:47:15 | bylaw | 1 | 28756 | 4 | 0.516 | 55728.7 |
314 | 2020-10-30 07:35:02 | bylaw | 1 | 28756 | 4 | 1.046 | 27491.4 |
313 | 2020-10-21 08:05:08 | bylaw | 1 | 28756 | 4 | 0.436 | 65954.1 |
312 | 2020-10-19 08:01:51 | bylaw | 1 | 28756 | 4 | 0.436 | 65954.1 |
311 | 2020-10-16 18:57:22 | bylaw | 1 | 28756 | 4 | 0.436 | 65954.1 |
310 | 2020-10-14 06:27:16 | bylaw | 1 | 28756 | 4 | 0.436 | 65954.1 |
309 | 2020-08-30 18:09:44 | bylaw | 1 | 28756 | 4 | 0.423 | 67981.1 |
308 | 2020-08-13 20:55:45 | bylaw | 1 | 28756 | 4 | 0.483 | 59536.2 |
307 | 2020-07-17 10:29:45 | bylaw | 1 | 28756 | 4 | 0.453 | 63479.0 |
306 | 2020-06-10 23:51:10 | bylaw | 1 | 28756 | 4 | 0.436 | 65954.1 |
305 | 2020-05-06 13:00:28 | bylaw | 1 | 28756 | 4 | 0.456 | 63061.4 |
304 | 2020-04-09 15:18:49 | bylaw | 1 | 28756 | 4 | 0.453 | 63479.0 |
303 | 2020-03-29 23:18:03 | bylaw | 3 | 83667 | 505 | 3.360 | 24900.9 |
302 | 2020-03-29 02:09:04 | bylaw | 3 | 83667 | 505 | 3.920 | 21343.6 |
301 | 2020-03-26 23:38:58 | bylaw | 3 | 83667 | 505 | 4.030 | 20761.0 |
300 | 2020-03-26 02:44:25 | bylaw | 1 | 28756 | 4 | 1.000 | 28756.0 |
299 | 2020-03-25 07:30:58 | bylaw | 1 | 28756 | 4 | 0.483 | 59536.2 |
298 | 2020-03-24 13:06:41 | bylaw | 3 | 83667 | 505 | 8.516 | 9824.7 |
297 | 2020-03-23 20:19:46 | bylaw | 1 | 28756 | 4 | 0.500 | 57512.0 |
296 | 2020-03-22 22:30:49 | bylaw | 3 | 83667 | 505 | 3.406 | 24564.6 |
295 | 2020-03-22 19:47:21 | bylaw | 3 | 83667 | 505 | 3.766 | 22216.4 |