History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drift"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
674 | 2024-03-28 20:28:28 | drift | 1 | 28756 | 8 | 0.453 | 63479.0 |
673 | 2024-02-29 04:52:56 | drift | 2 | 53800 | 78 | 1.656 | 32487.9 |
672 | 2024-02-29 04:52:36 | drift | 3 | 83667 | 861 | 4.313 | 19398.8 |
671 | 2024-02-27 08:32:11 | drift | 2 | 53800 | 78 | 1.686 | 31909.8 |
670 | 2024-02-27 08:31:48 | drift | 3 | 83667 | 861 | 6.843 | 12226.7 |
669 | 2024-02-26 19:35:20 | drift | 3 | 83667 | 861 | 4.000 | 20916.8 |
668 | 2024-02-26 19:35:21 | drift | 2 | 53800 | 78 | 1.623 | 33148.5 |
667 | 2024-02-26 19:35:16 | drift | 1 | 28756 | 8 | 0.436 | 65954.1 |
666 | 2024-01-27 16:02:21 | drift | 1 | 28756 | 8 | 0.436 | 65954.1 |
665 | 2024-01-11 09:46:20 | drift | 1 | 28756 | 8 | 0.483 | 59536.2 |
664 | 2024-01-07 05:36:41 | drift | 2 | 53800 | 78 | 1.376 | 39098.8 |
663 | 2024-01-06 15:15:52 | drift | 2 | 53800 | 78 | 1.360 | 39558.8 |
662 | 2024-01-04 09:58:53 | drift | 2 | 53800 | 78 | 1.576 | 34137.1 |
661 | 2024-01-04 09:58:50 | drift | 3 | 83667 | 861 | 4.063 | 20592.4 |
660 | 2023-12-19 12:02:06 | drift | 3 | 83667 | 861 | 3.233 | 25879.1 |
659 | 2023-12-09 05:45:51 | drift | 2 | 53800 | 78 | 1.546 | 34799.5 |
658 | 2023-12-01 09:09:19 | drift | 3 | 83667 | 861 | 3.513 | 23816.4 |
657 | 2023-11-24 09:38:30 | drift | 1 | 28756 | 8 | 0.500 | 57512.0 |
656 | 2023-11-15 08:48:25 | drift | 2 | 53800 | 78 | 1.733 | 31044.4 |
655 | 2023-11-15 08:48:19 | drift | 3 | 83667 | 861 | 3.280 | 25508.2 |
654 | 2023-11-14 15:28:33 | drift | 1 | 28756 | 8 | 0.436 | 65954.1 |
653 | 2023-11-08 16:00:30 | drift | 1 | 28756 | 8 | 0.423 | 67981.1 |
652 | 2023-11-03 18:58:30 | drift | 1 | 28756 | 8 | 0.513 | 56054.6 |
651 | 2023-10-28 10:15:22 | drift | 1 | 28756 | 8 | 0.563 | 51076.4 |
650 | 2023-10-27 18:03:05 | drift | 3 | 83667 | 861 | 8.016 | 10437.5 |
649 | 2023-10-22 06:48:35 | drift | 1 | 28756 | 8 | 0.440 | 65354.5 |
648 | 2023-10-20 10:57:34 | drift | 1 | 28756 | 8 | 0.466 | 61708.2 |
647 | 2023-10-20 10:43:01 | drift | 3 | 83667 | 861 | 4.046 | 20678.9 |
646 | 2023-10-17 17:24:05 | drift | 3 | 83667 | 861 | 3.903 | 21436.6 |
645 | 2023-10-17 17:24:06 | drift | 2 | 53800 | 78 | 2.470 | 21781.4 |
644 | 2023-10-17 04:46:43 | drift | 2 | 53800 | 78 | 3.170 | 16971.6 |
643 | 2023-10-15 03:43:04 | drift | 2 | 53800 | 78 | 1.563 | 34421.0 |
642 | 2023-10-11 00:37:54 | drift | 1 | 28756 | 8 | 0.440 | 65354.5 |
641 | 2023-10-04 23:27:04 | drift | 1 | 28756 | 8 | 0.423 | 67981.1 |
640 | 2023-10-03 21:59:34 | drift | 3 | 83667 | 861 | 4.126 | 20278.0 |
639 | 2023-10-03 11:30:27 | drift | 3 | 83667 | 861 | 3.750 | 22311.2 |
638 | 2023-10-01 05:41:32 | drift | 3 | 83667 | 861 | 4.296 | 19475.6 |
637 | 2023-09-29 02:13:46 | drift | 1 | 28756 | 8 | 0.686 | 41918.4 |
636 | 2023-09-28 00:09:04 | drift | 3 | 83667 | 861 | 4.186 | 19987.3 |
635 | 2023-09-22 05:55:13 | drift | 1 | 28756 | 8 | 0.470 | 61183.0 |
634 | 2023-09-20 08:40:29 | drift | 3 | 83667 | 861 | 3.360 | 24900.9 |
633 | 2023-08-27 13:35:25 | drift | 1 | 28756 | 8 | 0.453 | 63479.0 |
632 | 2023-08-04 12:48:14 | drift | 1 | 28756 | 8 | 0.423 | 67981.1 |
631 | 2023-07-26 06:25:24 | drift | 2 | 53800 | 78 | 1.360 | 39558.8 |
630 | 2023-06-29 23:42:32 | drift | 3 | 83667 | 861 | 3.750 | 22311.2 |
629 | 2023-05-29 14:51:22 | drift | 1 | 28756 | 8 | 0.483 | 59536.2 |
628 | 2023-04-27 01:17:42 | drift | 1 | 28756 | 8 | 0.436 | 65954.1 |
627 | 2023-04-08 00:31:18 | drift | 2 | 53800 | 78 | 1.373 | 39184.3 |
626 | 2023-03-25 22:06:07 | drift | 1 | 28756 | 8 | 0.423 | 67981.1 |
625 | 2023-03-24 16:39:17 | drift | 3 | 83667 | 861 | 3.200 | 26145.9 |
624 | 2023-01-29 15:24:19 | drift | 1 | 28756 | 8 | 0.470 | 61183.0 |
623 | 2023-01-22 04:56:10 | drift | 1 | 28756 | 8 | 0.500 | 57512.0 |
622 | 2023-01-14 06:09:52 | drift | 2 | 53800 | 78 | 1.343 | 40059.6 |
621 | 2023-01-09 18:23:28 | drift | 1 | 28756 | 8 | 0.420 | 68466.7 |
620 | 2023-01-06 07:52:19 | drift | 3 | 83667 | 861 | 3.233 | 25879.1 |
619 | 2022-12-27 13:45:14 | drift | 3 | 83667 | 861 | 3.173 | 26368.4 |
618 | 2022-12-23 03:45:18 | drift | 3 | 83667 | 861 | 3.423 | 24442.6 |
617 | 2022-12-14 20:52:45 | drift | 1 | 28756 | 8 | 0.436 | 65954.1 |
616 | 2022-11-23 01:16:56 | drift | 1 | 28756 | 8 | 0.516 | 55728.7 |
615 | 2022-11-13 22:59:07 | drift | 1 | 28756 | 8 | 0.953 | 30174.2 |
614 | 2022-11-11 04:05:05 | drift | 3 | 83667 | 861 | 3.313 | 25254.2 |
613 | 2022-11-06 23:33:11 | drift | 3 | 83667 | 861 | 3.546 | 23594.8 |
612 | 2022-11-06 20:19:52 | drift | 3 | 83667 | 861 | 3.560 | 23502.0 |
611 | 2022-11-06 20:19:50 | drift | 3 | 83667 | 861 | 3.376 | 24782.9 |
610 | 2022-10-29 10:41:47 | drift | 3 | 83667 | 861 | 6.373 | 13128.4 |
609 | 2022-10-28 12:08:40 | drift | 3 | 83667 | 861 | 3.186 | 26260.8 |
608 | 2022-10-20 11:20:03 | drift | 2 | 53800 | 78 | 1.783 | 30173.9 |
607 | 2022-10-07 20:47:34 | drift | 1 | 28756 | 8 | 0.423 | 67981.1 |
606 | 2022-10-07 18:40:06 | drift | 1 | 28756 | 8 | 0.436 | 65954.1 |
605 | 2022-09-29 05:52:52 | drift | 3 | 83667 | 861 | 3.296 | 25384.4 |
604 | 2022-09-19 08:29:34 | drift | 1 | 28756 | 8 | 0.483 | 59536.2 |
603 | 2022-08-23 05:52:14 | drift | 1 | 28756 | 8 | 0.440 | 65354.5 |
602 | 2022-08-19 10:33:53 | drift | 3 | 83667 | 861 | 3.953 | 21165.4 |
601 | 2022-08-15 09:10:19 | drift | 1 | 28756 | 8 | 0.423 | 67981.1 |
600 | 2022-08-14 14:34:12 | drift | 1 | 28756 | 8 | 0.436 | 65954.1 |
599 | 2022-08-14 01:55:42 | drift | 1 | 28756 | 8 | 0.466 | 61708.2 |
598 | 2022-07-28 21:33:38 | drift | 1 | 28756 | 8 | 0.440 | 65354.5 |
597 | 2022-06-24 22:31:48 | drift | 1 | 28756 | 8 | 0.440 | 65354.5 |
596 | 2022-06-16 20:41:07 | drift | 2 | 53800 | 78 | 1.436 | 37465.2 |
595 | 2022-05-26 07:06:56 | drift | 1 | 28756 | 8 | 0.436 | 65954.1 |
594 | 2022-05-21 23:04:20 | drift | 2 | 53800 | 78 | 1.373 | 39184.3 |
593 | 2022-03-12 03:34:34 | drift | 1 | 28756 | 8 | 0.436 | 65954.1 |
592 | 2022-02-11 20:57:35 | drift | 1 | 28756 | 8 | 0.513 | 56054.6 |
591 | 2022-01-17 00:27:01 | drift | 2 | 53800 | 78 | 1.483 | 36277.8 |
590 | 2021-12-22 23:43:49 | drift | 1 | 28756 | 8 | 0.483 | 59536.2 |
589 | 2021-12-09 18:25:48 | drift | 1 | 28756 | 8 | 0.500 | 57512.0 |
588 | 2021-12-07 15:18:41 | drift | 1 | 28756 | 8 | 0.486 | 59168.7 |
587 | 2021-12-05 06:11:36 | drift | 1 | 28756 | 8 | 0.466 | 61708.2 |
586 | 2021-11-24 03:18:03 | drift | 1 | 28756 | 8 | 0.453 | 63479.0 |
585 | 2021-10-25 07:16:15 | drift | 2 | 53800 | 78 | 1.593 | 33772.8 |
584 | 2021-10-15 04:04:56 | drift | 1 | 28756 | 8 | 0.516 | 55728.7 |
583 | 2021-10-14 22:53:32 | drift | 1 | 28756 | 8 | 0.483 | 59536.2 |
582 | 2021-10-12 22:16:08 | drift | 1 | 28756 | 8 | 0.420 | 68466.7 |
581 | 2021-09-12 10:24:53 | drift | 1 | 28756 | 8 | 0.436 | 65954.1 |
580 | 2021-09-04 12:52:02 | drift | 1 | 28756 | 8 | 0.436 | 65954.1 |
579 | 2021-09-01 03:19:58 | drift | 1 | 28756 | 8 | 0.453 | 63479.0 |
578 | 2021-08-26 19:22:06 | drift | 2 | 53800 | 78 | 1.640 | 32804.9 |
577 | 2021-08-20 03:38:02 | drift | 1 | 28756 | 8 | 0.500 | 57512.0 |
576 | 2021-05-31 09:11:36 | drift | 1 | 28756 | 8 | 0.533 | 53951.2 |
575 | 2021-02-25 00:04:26 | drift | 1 | 28756 | 8 | 0.500 | 57512.0 |