History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"holdings"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
711 | 2024-04-20 07:18:24 | holdings | 3 | 146162 | 341 | 14.093 | 10371.2 |
710 | 2024-04-13 07:34:03 | holdings | 1 | 82945 | 4 | 1.453 | 57085.3 |
709 | 2024-04-12 20:59:26 | holdings | 3 | 146162 | 341 | 11.296 | 12939.3 |
708 | 2024-04-11 07:57:02 | holdings | 1 | 82945 | 4 | 1.406 | 58993.6 |
707 | 2024-04-10 22:36:28 | holdings | 2 | 121059 | 35 | 6.390 | 18945.1 |
706 | 2024-04-10 19:39:52 | holdings | 3 | 146162 | 341 | 9.156 | 15963.5 |
705 | 2024-04-10 07:41:12 | holdings | 3 | 146162 | 341 | 37.080 | 3941.8 |
704 | 2024-04-09 17:23:07 | holdings | 2 | 121059 | 35 | 9.906 | 12220.8 |
703 | 2024-04-09 17:23:07 | holdings | 1 | 82945 | 4 | 3.766 | 22024.7 |
702 | 2024-04-09 17:13:06 | holdings | 3 | 146162 | 341 | 8.920 | 16385.9 |
701 | 2024-04-09 01:09:12 | holdings | 1 | 82945 | 4 | 1.470 | 56425.2 |
700 | 2024-04-09 01:09:02 | holdings | 2 | 121059 | 35 | 3.983 | 30393.9 |
699 | 2024-04-09 01:08:57 | holdings | 1 | 82945 | 4 | 1.576 | 52630.1 |
698 | 2024-04-08 23:47:40 | holdings | 3 | 146162 | 341 | 9.563 | 15284.1 |
697 | 2024-04-08 16:16:02 | holdings | 3 | 146162 | 341 | 31.046 | 4707.9 |
696 | 2024-04-08 14:09:08 | holdings | 3 | 146162 | 341 | 9.453 | 15462.0 |
695 | 2024-03-10 07:10:56 | holdings | 2 | 121059 | 35 | 9.643 | 12554.1 |
694 | 2024-03-10 06:35:31 | holdings | 3 | 146162 | 341 | 8.750 | 16704.2 |
693 | 2024-03-09 21:39:58 | holdings | 3 | 146162 | 341 | 23.970 | 6097.7 |
692 | 2024-03-09 00:19:05 | holdings | 3 | 146162 | 341 | 24.860 | 5879.4 |
691 | 2024-03-09 00:17:10 | holdings | 2 | 121059 | 35 | 7.673 | 15777.3 |
690 | 2024-03-08 23:38:12 | holdings | 1 | 82945 | 4 | 1.560 | 53169.9 |
689 | 2024-03-08 23:37:57 | holdings | 3 | 146162 | 341 | 7.906 | 18487.5 |
688 | 2024-03-08 23:37:59 | holdings | 2 | 121059 | 35 | 3.923 | 30858.8 |
687 | 2024-03-08 23:37:54 | holdings | 1 | 82945 | 4 | 1.596 | 51970.6 |
686 | 2024-03-01 10:46:18 | holdings | 1 | 82945 | 4 | 1.280 | 64800.8 |
685 | 2024-02-10 07:01:20 | holdings | 2 | 121059 | 35 | 16.126 | 7507.1 |
684 | 2024-02-06 00:49:42 | holdings | 1 | 82945 | 4 | 2.686 | 30880.5 |
683 | 2024-02-05 22:44:34 | holdings | 2 | 121059 | 35 | 5.970 | 20277.9 |
682 | 2024-02-05 22:44:05 | holdings | 3 | 146162 | 341 | 7.483 | 19532.5 |
681 | 2024-02-05 14:54:21 | holdings | 3 | 146162 | 341 | 14.173 | 10312.7 |
680 | 2024-02-04 07:39:21 | holdings | 3 | 146162 | 341 | 9.923 | 14729.6 |
679 | 2024-02-03 04:36:50 | holdings | 3 | 146162 | 341 | 12.283 | 11899.5 |
678 | 2024-02-03 03:38:26 | holdings | 3 | 146162 | 341 | 7.470 | 19566.5 |
677 | 2024-02-03 03:38:02 | holdings | 2 | 121059 | 35 | 7.923 | 15279.4 |
676 | 2024-01-31 11:28:47 | holdings | 2 | 121059 | 35 | 3.203 | 37795.5 |
675 | 2024-01-14 15:38:42 | holdings | 1 | 82945 | 4 | 2.876 | 28840.4 |
674 | 2024-01-06 23:26:46 | holdings | 1 | 82945 | 4 | 1.423 | 58288.8 |
673 | 2023-12-30 07:31:09 | holdings | 1 | 82945 | 4 | 1.280 | 64800.8 |
672 | 2023-12-11 03:20:24 | holdings | 1 | 82945 | 4 | 1.500 | 55296.7 |
671 | 2023-12-10 11:00:23 | holdings | 3 | 146162 | 341 | 7.910 | 18478.1 |
670 | 2023-12-07 17:51:52 | holdings | 2 | 121059 | 35 | 4.266 | 28377.6 |
669 | 2023-11-21 21:26:44 | holdings | 3 | 146162 | 341 | 7.470 | 19566.5 |
668 | 2023-11-18 15:30:31 | holdings | 2 | 121059 | 35 | 3.440 | 35191.6 |
667 | 2023-11-18 01:57:13 | holdings | 1 | 82945 | 4 | 1.720 | 48223.8 |
666 | 2023-11-10 21:09:40 | holdings | 1 | 82945 | 4 | 1.266 | 65517.4 |
665 | 2023-11-07 19:26:42 | holdings | 2 | 121059 | 35 | 3.660 | 33076.2 |
664 | 2023-11-05 21:14:13 | holdings | 1 | 82945 | 4 | 1.313 | 63172.1 |
663 | 2023-10-19 17:31:30 | holdings | 1 | 82945 | 4 | 1.470 | 56425.2 |
662 | 2023-10-11 17:25:30 | holdings | 1 | 82945 | 4 | 1.390 | 59672.7 |
661 | 2023-10-07 03:42:09 | holdings | 1 | 82945 | 4 | 1.420 | 58412.0 |
660 | 2023-09-14 19:34:48 | holdings | 1 | 82945 | 4 | 1.236 | 67107.6 |
659 | 2023-09-11 17:54:09 | holdings | 1 | 82945 | 4 | 1.266 | 65517.4 |
658 | 2023-09-11 12:38:51 | holdings | 3 | 146162 | 341 | 13.550 | 10786.9 |
657 | 2023-09-08 05:00:29 | holdings | 3 | 146162 | 341 | 6.080 | 24039.8 |
656 | 2023-08-15 15:28:22 | holdings | 1 | 82945 | 4 | 1.360 | 60989.0 |
655 | 2023-08-12 21:27:10 | holdings | 2 | 121059 | 35 | 3.093 | 39139.7 |
654 | 2023-06-05 01:25:37 | holdings | 3 | 146162 | 341 | 6.126 | 23859.3 |
653 | 2023-06-01 00:27:49 | holdings | 1 | 82945 | 4 | 1.250 | 66356.0 |
652 | 2023-05-29 13:18:32 | holdings | 3 | 146162 | 341 | 7.093 | 20606.5 |
651 | 2023-05-13 20:38:40 | holdings | 1 | 82945 | 4 | 1.233 | 67270.9 |
650 | 2023-04-27 01:59:49 | holdings | 2 | 121059 | 35 | 3.046 | 39743.6 |
649 | 2023-03-09 12:35:08 | holdings | 3 | 146162 | 341 | 6.156 | 23743.0 |
648 | 2023-03-08 14:55:07 | holdings | 1 | 82945 | 4 | 1.406 | 58993.6 |
647 | 2023-02-19 11:17:56 | holdings | 1 | 82945 | 4 | 1.453 | 57085.3 |
646 | 2023-01-30 20:02:17 | holdings | 2 | 121059 | 35 | 3.123 | 38763.7 |
645 | 2023-01-25 22:59:11 | holdings | 3 | 146162 | 341 | 7.110 | 20557.2 |
644 | 2023-01-04 09:52:27 | holdings | 3 | 146162 | 341 | 6.016 | 24295.5 |
643 | 2022-12-31 15:45:45 | holdings | 3 | 146162 | 341 | 6.096 | 23976.7 |
642 | 2022-12-29 14:22:26 | holdings | 1 | 82945 | 4 | 1.220 | 67987.7 |
641 | 2022-12-13 17:16:50 | holdings | 3 | 146162 | 341 | 6.093 | 23988.5 |
640 | 2022-12-11 19:10:09 | holdings | 3 | 146162 | 341 | 6.470 | 22590.7 |
639 | 2022-11-28 01:13:48 | holdings | 3 | 146162 | 341 | 6.140 | 23804.9 |
638 | 2022-11-18 02:11:22 | holdings | 3 | 146162 | 341 | 6.326 | 23105.0 |
637 | 2022-11-12 21:46:01 | holdings | 3 | 146162 | 341 | 6.203 | 23563.1 |
636 | 2022-11-12 05:43:51 | holdings | 2 | 121059 | 35 | 3.093 | 39139.7 |
635 | 2022-11-06 17:28:29 | holdings | 3 | 146162 | 341 | 6.046 | 24175.0 |
634 | 2022-11-02 09:18:07 | holdings | 1 | 82945 | 4 | 1.406 | 58993.6 |
633 | 2022-10-22 08:42:11 | holdings | 3 | 146162 | 341 | 6.000 | 24360.3 |
632 | 2022-10-02 15:36:08 | holdings | 3 | 146162 | 341 | 6.530 | 22383.2 |
631 | 2022-09-19 14:50:53 | holdings | 1 | 82945 | 4 | 1.326 | 62552.8 |
630 | 2022-09-18 13:47:00 | holdings | 1 | 82945 | 4 | 1.266 | 65517.4 |
629 | 2022-09-08 21:20:58 | holdings | 3 | 146162 | 341 | 6.733 | 21708.3 |
628 | 2022-09-06 10:42:44 | holdings | 3 | 146162 | 341 | 6.530 | 22383.2 |
627 | 2022-08-19 14:19:21 | holdings | 3 | 146162 | 341 | 7.470 | 19566.5 |
626 | 2022-08-14 16:51:26 | holdings | 1 | 82945 | 4 | 1.233 | 67270.9 |
625 | 2022-08-07 02:43:14 | holdings | 1 | 82945 | 4 | 1.296 | 64000.8 |
624 | 2022-08-01 13:35:09 | holdings | 3 | 146162 | 341 | 6.203 | 23563.1 |
623 | 2022-07-30 03:40:58 | holdings | 1 | 82945 | 4 | 1.263 | 65673.0 |
622 | 2022-07-29 01:04:20 | holdings | 1 | 82945 | 4 | 1.406 | 58993.6 |
621 | 2022-07-20 14:02:06 | holdings | 3 | 146162 | 341 | 6.186 | 23627.9 |
620 | 2022-07-20 00:09:04 | holdings | 1 | 82945 | 4 | 1.250 | 66356.0 |
619 | 2022-07-03 11:00:41 | holdings | 1 | 82945 | 4 | 1.406 | 58993.6 |
618 | 2022-06-29 00:10:10 | holdings | 3 | 146162 | 341 | 6.406 | 22816.4 |
617 | 2022-06-25 22:39:23 | holdings | 1 | 82945 | 4 | 1.376 | 60279.8 |
616 | 2022-06-16 10:59:17 | holdings | 1 | 82945 | 4 | 1.250 | 66356.0 |
615 | 2022-06-08 22:44:05 | holdings | 1 | 82945 | 4 | 1.263 | 65673.0 |
614 | 2022-06-08 19:50:22 | holdings | 1 | 82945 | 4 | 1.280 | 64800.8 |
613 | 2022-06-01 21:38:59 | holdings | 1 | 82945 | 4 | 1.250 | 66356.0 |
612 | 2022-06-01 18:59:42 | holdings | 3 | 146162 | 341 | 6.423 | 22756.0 |