History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"attend"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
503 | 2024-04-28 17:51:09 | attend | 2 | 82551 | 47 | 5.470 | 15091.6 |
502 | 2024-04-26 03:23:24 | attend | 2 | 82551 | 47 | 2.140 | 38575.2 |
501 | 2024-04-06 08:23:57 | attend | 1 | 48755 | 3 | 1.936 | 25183.4 |
500 | 2024-04-01 01:57:02 | attend | 3 | 112716 | 515 | 13.296 | 8477.4 |
499 | 2024-04-01 01:57:04 | attend | 2 | 82551 | 47 | 2.906 | 28407.1 |
498 | 2024-04-01 01:56:56 | attend | 1 | 48755 | 3 | 2.000 | 24377.5 |
497 | 2024-04-01 01:56:40 | attend | 3 | 112716 | 515 | 12.423 | 9073.2 |
496 | 2024-04-01 01:56:43 | attend | 2 | 82551 | 47 | 4.940 | 16710.7 |
495 | 2024-04-01 01:56:33 | attend | 1 | 48755 | 3 | 1.936 | 25183.4 |
494 | 2024-01-12 10:39:53 | attend | 1 | 48755 | 3 | 0.826 | 59025.4 |
493 | 2024-01-08 11:16:51 | attend | 1 | 48755 | 3 | 0.796 | 61250.0 |
492 | 2024-01-04 18:19:56 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
491 | 2023-12-18 09:40:13 | attend | 2 | 82551 | 47 | 2.593 | 31836.1 |
490 | 2023-11-26 07:44:14 | attend | 3 | 112716 | 515 | 4.890 | 23050.3 |
489 | 2023-11-21 18:33:42 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
488 | 2023-11-20 08:24:34 | attend | 2 | 82551 | 47 | 2.140 | 38575.2 |
487 | 2023-11-20 08:24:28 | attend | 3 | 112716 | 515 | 4.763 | 23664.9 |
486 | 2023-11-09 00:20:51 | attend | 1 | 48755 | 3 | 0.750 | 65006.7 |
485 | 2023-11-06 18:38:42 | attend | 1 | 48755 | 3 | 0.826 | 59025.4 |
484 | 2023-11-06 07:13:52 | attend | 1 | 48755 | 3 | 0.763 | 63899.1 |
483 | 2023-10-31 01:17:38 | attend | 1 | 48755 | 3 | 0.750 | 65006.7 |
482 | 2023-10-19 22:58:11 | attend | 1 | 48755 | 3 | 0.860 | 56691.9 |
481 | 2023-10-15 05:04:35 | attend | 1 | 48755 | 3 | 0.813 | 59969.2 |
480 | 2023-09-27 01:22:05 | attend | 1 | 48755 | 3 | 0.750 | 65006.7 |
479 | 2023-09-25 15:23:04 | attend | 1 | 48755 | 3 | 0.796 | 61250.0 |
478 | 2023-09-25 05:42:29 | attend | 1 | 48755 | 3 | 1.766 | 27607.6 |
477 | 2023-09-24 03:20:47 | attend | 2 | 82551 | 47 | 2.440 | 33832.4 |
476 | 2023-09-19 02:30:09 | attend | 2 | 82551 | 47 | 2.156 | 38289.0 |
475 | 2023-09-12 14:00:57 | attend | 1 | 48755 | 3 | 0.826 | 59025.4 |
474 | 2023-08-27 23:48:26 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
473 | 2023-06-23 08:40:54 | attend | 2 | 82551 | 47 | 2.686 | 30733.8 |
472 | 2023-05-30 23:16:17 | attend | 1 | 48755 | 3 | 0.733 | 66514.3 |
471 | 2023-05-26 14:15:41 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
470 | 2023-03-24 12:29:47 | attend | 1 | 48755 | 3 | 0.750 | 65006.7 |
469 | 2023-03-20 07:06:47 | attend | 2 | 82551 | 47 | 2.530 | 32628.9 |
468 | 2023-02-06 15:23:46 | attend | 1 | 48755 | 3 | 0.906 | 53813.5 |
467 | 2023-01-10 06:41:15 | attend | 1 | 48755 | 3 | 0.810 | 60191.4 |
466 | 2022-12-21 02:15:02 | attend | 2 | 82551 | 47 | 2.110 | 39123.7 |
465 | 2022-10-20 05:07:10 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
464 | 2022-10-19 08:46:13 | attend | 1 | 48755 | 3 | 0.826 | 59025.4 |
463 | 2022-08-17 07:36:44 | attend | 2 | 82551 | 47 | 2.280 | 36206.6 |
462 | 2022-06-26 06:38:35 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
461 | 2022-06-10 21:33:20 | attend | 1 | 48755 | 3 | 0.843 | 57835.1 |
460 | 2022-04-10 20:37:40 | attend | 1 | 48755 | 3 | 0.893 | 54596.9 |
459 | 2022-03-06 14:52:59 | attend | 1 | 48755 | 3 | 0.763 | 63899.1 |
458 | 2022-02-16 07:12:53 | attend | 1 | 48755 | 3 | 0.763 | 63899.1 |
457 | 2021-12-05 15:55:04 | attend | 1 | 48755 | 3 | 0.750 | 65006.7 |
456 | 2021-12-03 13:36:02 | attend | 1 | 48755 | 3 | 1.623 | 30040.0 |
455 | 2021-11-22 23:06:10 | attend | 1 | 48755 | 3 | 0.826 | 59025.4 |
454 | 2021-10-10 22:37:09 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
453 | 2021-09-21 23:04:58 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
452 | 2021-08-13 08:22:39 | attend | 1 | 48755 | 3 | 0.750 | 65006.7 |
451 | 2021-07-28 14:20:49 | attend | 1 | 48755 | 3 | 0.763 | 63899.1 |
450 | 2021-06-05 09:58:54 | attend | 3 | 112716 | 515 | 5.610 | 20092.0 |
449 | 2021-05-20 02:45:34 | attend | 1 | 48755 | 3 | 0.890 | 54780.9 |
448 | 2021-05-12 14:58:38 | attend | 1 | 48755 | 3 | 0.873 | 55847.7 |
447 | 2021-04-20 05:16:17 | attend | 1 | 48755 | 3 | 1.170 | 41670.9 |
446 | 2021-03-23 00:03:19 | attend | 1 | 48755 | 3 | 0.750 | 65006.7 |
445 | 2021-03-19 10:24:56 | attend | 1 | 48755 | 3 | 0.860 | 56691.9 |
444 | 2021-03-18 08:29:52 | attend | 1 | 48755 | 3 | 0.763 | 63899.1 |
443 | 2021-03-17 22:36:25 | attend | 1 | 48755 | 3 | 0.923 | 52822.3 |
442 | 2021-03-17 10:55:44 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
441 | 2021-03-16 16:05:22 | attend | 1 | 48755 | 3 | 0.906 | 53813.5 |
440 | 2021-03-15 21:33:29 | attend | 1 | 48755 | 3 | 0.796 | 61250.0 |
439 | 2021-02-08 15:15:52 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
438 | 2021-01-11 18:30:48 | attend | 1 | 48755 | 3 | 0.750 | 65006.7 |
437 | 2020-12-28 12:30:58 | attend | 3 | 112716 | 515 | 4.766 | 23650.0 |
436 | 2020-12-07 18:34:28 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
435 | 2020-11-06 20:56:52 | attend | 1 | 48755 | 3 | 0.890 | 54780.9 |
434 | 2020-11-03 03:15:46 | attend | 1 | 48755 | 3 | 0.830 | 58741.0 |
433 | 2020-10-30 14:32:58 | attend | 1 | 48755 | 3 | 1.096 | 44484.5 |
432 | 2020-08-30 00:37:54 | attend | 1 | 48755 | 3 | 0.860 | 56691.9 |
431 | 2020-08-24 21:34:14 | attend | 1 | 48755 | 3 | 0.830 | 58741.0 |
430 | 2020-08-19 16:43:01 | attend | 1 | 48755 | 3 | 0.873 | 55847.7 |
429 | 2020-08-05 15:14:34 | attend | 1 | 48755 | 3 | 0.876 | 55656.4 |
428 | 2020-05-04 02:45:57 | attend | 1 | 48755 | 3 | 0.796 | 61250.0 |
427 | 2020-03-28 00:17:38 | attend | 1 | 48755 | 3 | 0.876 | 55656.4 |
426 | 2020-03-26 17:50:35 | attend | 1 | 48755 | 3 | 0.766 | 63648.8 |
425 | 2020-03-23 13:57:47 | attend | 1 | 48755 | 3 | 0.936 | 52088.7 |
424 | 2020-03-22 17:31:43 | attend | 1 | 48755 | 3 | 0.830 | 58741.0 |
423 | 2020-03-19 14:12:30 | attend | 1 | 48755 | 3 | 0.890 | 54780.9 |
422 | 2020-03-01 00:28:55 | attend | 1 | 48755 | 3 | 0.890 | 54780.9 |
421 | 2020-02-25 11:48:37 | attend | 1 | 48755 | 3 | 1.046 | 46610.9 |
420 | 2020-02-25 06:46:47 | attend | 3 | 112716 | 515 | 11.550 | 9759.0 |
419 | 2020-02-22 09:48:44 | attend | 3 | 112716 | 515 | 9.640 | 11692.5 |
418 | 2020-02-21 08:34:10 | attend | 3 | 112716 | 515 | 5.890 | 19136.8 |
417 | 2020-02-18 12:26:44 | attend | 1 | 48755 | 3 | 0.843 | 57835.1 |
416 | 2020-02-14 13:14:55 | attend | 3 | 112716 | 515 | 9.766 | 11541.7 |
415 | 2020-02-14 09:09:29 | attend | 3 | 112716 | 515 | 9.203 | 12247.7 |
414 | 2020-02-09 17:44:29 | attend | 1 | 48755 | 3 | 0.903 | 53992.2 |
413 | 2020-02-08 03:33:33 | attend | 1 | 48755 | 3 | 1.953 | 24964.2 |
412 | 2020-02-07 23:14:05 | attend | 3 | 112716 | 515 | 6.626 | 17011.2 |
411 | 2020-02-07 19:09:36 | attend | 3 | 112716 | 515 | 6.546 | 17219.1 |
410 | 2020-02-05 06:54:03 | attend | 1 | 48755 | 3 | 2.920 | 16696.9 |
409 | 2020-02-04 14:52:17 | attend | 1 | 48755 | 3 | 0.903 | 53992.2 |
408 | 2020-02-02 03:01:55 | attend | 3 | 112716 | 515 | 6.156 | 18309.9 |
407 | 2020-02-01 21:54:05 | attend | 1 | 48755 | 3 | 0.750 | 65006.7 |
406 | 2020-01-29 07:07:57 | attend | 3 | 112716 | 515 | 14.796 | 7618.0 |
405 | 2020-01-28 20:34:02 | attend | 3 | 112716 | 515 | 6.046 | 18643.1 |
404 | 2020-01-28 01:20:16 | attend | 1 | 48755 | 3 | 1.983 | 24586.5 |