History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ingate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
733 | 2024-04-27 13:09:23 | ingate | 1 | 48755 | 5 | 0.983 | 49598.2 |
732 | 2024-04-06 00:00:13 | ingate | 1 | 48755 | 5 | 3.123 | 15611.6 |
731 | 2024-03-31 13:48:16 | ingate | 1 | 48755 | 5 | 1.610 | 30282.6 |
730 | 2024-03-28 21:46:30 | ingate | 1 | 48755 | 5 | 0.970 | 50262.9 |
729 | 2024-03-06 23:53:17 | ingate | 1 | 48755 | 5 | 0.936 | 52088.7 |
728 | 2024-03-06 23:37:56 | ingate | 3 | 112716 | 566 | 10.550 | 10684.0 |
727 | 2024-03-06 03:11:25 | ingate | 3 | 112716 | 566 | 5.390 | 20912.1 |
726 | 2024-03-06 00:03:14 | ingate | 3 | 112716 | 566 | 15.360 | 7338.3 |
725 | 2024-02-28 21:35:45 | ingate | 1 | 48755 | 5 | 0.876 | 55656.4 |
724 | 2024-02-28 07:38:48 | ingate | 2 | 82551 | 55 | 2.516 | 32810.4 |
723 | 2024-02-28 07:38:28 | ingate | 3 | 112716 | 566 | 6.330 | 17806.6 |
722 | 2024-02-28 07:30:31 | ingate | 2 | 82551 | 55 | 2.500 | 33020.4 |
721 | 2024-02-28 07:30:09 | ingate | 3 | 112716 | 566 | 6.780 | 16624.8 |
720 | 2024-02-28 07:22:43 | ingate | 3 | 112716 | 566 | 13.300 | 8474.9 |
719 | 2024-02-28 07:22:41 | ingate | 2 | 82551 | 55 | 8.860 | 9317.3 |
718 | 2024-02-28 07:22:21 | ingate | 1 | 48755 | 5 | 3.766 | 12946.1 |
717 | 2024-01-18 06:35:27 | ingate | 1 | 48755 | 5 | 0.813 | 59969.2 |
716 | 2024-01-17 13:40:33 | ingate | 3 | 112716 | 566 | 5.890 | 19136.8 |
715 | 2024-01-17 13:40:34 | ingate | 2 | 82551 | 55 | 2.626 | 31436.0 |
714 | 2024-01-15 22:44:30 | ingate | 3 | 112716 | 566 | 4.643 | 24276.5 |
713 | 2023-12-26 22:28:14 | ingate | 2 | 82551 | 55 | 2.376 | 34743.7 |
712 | 2023-12-26 22:28:09 | ingate | 3 | 112716 | 566 | 5.250 | 21469.7 |
711 | 2023-12-25 12:45:18 | ingate | 3 | 112716 | 566 | 4.563 | 24702.2 |
710 | 2023-11-25 20:41:47 | ingate | 3 | 112716 | 566 | 5.873 | 19192.2 |
709 | 2023-11-21 09:18:08 | ingate | 1 | 48755 | 5 | 0.830 | 58741.0 |
708 | 2023-11-17 19:10:49 | ingate | 1 | 48755 | 5 | 0.920 | 52994.6 |
707 | 2023-11-13 08:58:45 | ingate | 1 | 48755 | 5 | 0.796 | 61250.0 |
706 | 2023-11-12 18:04:04 | ingate | 1 | 48755 | 5 | 0.750 | 65006.7 |
705 | 2023-11-06 19:39:27 | ingate | 1 | 48755 | 5 | 0.810 | 60191.4 |
704 | 2023-11-03 19:53:22 | ingate | 1 | 48755 | 5 | 0.860 | 56691.9 |
703 | 2023-10-31 13:31:52 | ingate | 1 | 48755 | 5 | 0.923 | 52822.3 |
702 | 2023-10-24 08:54:20 | ingate | 1 | 48755 | 5 | 0.750 | 65006.7 |
701 | 2023-10-22 13:11:37 | ingate | 1 | 48755 | 5 | 0.856 | 56956.8 |
700 | 2023-10-18 13:37:53 | ingate | 1 | 48755 | 5 | 0.796 | 61250.0 |
699 | 2023-10-11 14:55:48 | ingate | 1 | 48755 | 5 | 0.826 | 59025.4 |
698 | 2023-10-02 13:12:34 | ingate | 3 | 112716 | 566 | 4.610 | 24450.3 |
697 | 2023-09-26 07:32:08 | ingate | 1 | 48755 | 5 | 0.733 | 66514.3 |
696 | 2023-09-26 05:35:51 | ingate | 3 | 112716 | 566 | 5.250 | 21469.7 |
695 | 2023-09-12 19:58:55 | ingate | 1 | 48755 | 5 | 0.843 | 57835.1 |
694 | 2023-09-01 07:28:50 | ingate | 1 | 48755 | 5 | 0.796 | 61250.0 |
693 | 2023-08-12 01:51:39 | ingate | 3 | 112716 | 566 | 4.563 | 24702.2 |
692 | 2023-08-11 12:50:36 | ingate | 3 | 112716 | 566 | 4.656 | 24208.8 |
691 | 2023-07-19 13:50:26 | ingate | 1 | 48755 | 5 | 0.813 | 59969.2 |
690 | 2023-07-05 16:12:53 | ingate | 3 | 112716 | 566 | 4.706 | 23951.6 |
689 | 2023-06-05 22:57:48 | ingate | 1 | 48755 | 5 | 0.750 | 65006.7 |
688 | 2023-04-11 16:22:36 | ingate | 1 | 48755 | 5 | 0.856 | 56956.8 |
687 | 2023-03-29 08:20:12 | ingate | 3 | 112716 | 566 | 4.673 | 24120.7 |
686 | 2023-03-26 22:29:11 | ingate | 1 | 48755 | 5 | 0.720 | 67715.3 |
685 | 2023-01-10 23:36:41 | ingate | 1 | 48755 | 5 | 0.796 | 61250.0 |
684 | 2023-01-06 13:44:42 | ingate | 1 | 48755 | 5 | 0.733 | 66514.3 |
683 | 2022-12-28 09:22:27 | ingate | 3 | 112716 | 566 | 4.623 | 24381.6 |
682 | 2022-11-09 19:38:42 | ingate | 3 | 112716 | 566 | 5.360 | 21029.1 |
681 | 2022-11-07 21:48:22 | ingate | 3 | 112716 | 566 | 5.016 | 22471.3 |
680 | 2022-10-14 20:56:59 | ingate | 1 | 48755 | 5 | 0.763 | 63899.1 |
679 | 2022-09-22 20:28:05 | ingate | 1 | 48755 | 5 | 0.750 | 65006.7 |
678 | 2022-09-21 09:26:42 | ingate | 3 | 112716 | 566 | 4.550 | 24772.7 |
677 | 2022-09-19 16:23:04 | ingate | 1 | 48755 | 5 | 1.013 | 48129.3 |
676 | 2022-08-31 14:32:17 | ingate | 3 | 112716 | 566 | 4.750 | 23729.7 |
675 | 2022-08-29 23:38:52 | ingate | 3 | 112716 | 566 | 4.656 | 24208.8 |
674 | 2022-08-14 17:32:01 | ingate | 1 | 48755 | 5 | 0.796 | 61250.0 |
673 | 2022-07-29 01:45:10 | ingate | 1 | 48755 | 5 | 0.736 | 66243.2 |
672 | 2022-07-10 09:51:45 | ingate | 1 | 48755 | 5 | 0.750 | 65006.7 |
671 | 2022-07-02 19:21:04 | ingate | 1 | 48755 | 5 | 0.733 | 66514.3 |
670 | 2022-06-15 21:42:21 | ingate | 1 | 48755 | 5 | 0.763 | 63899.1 |
669 | 2022-06-09 11:21:55 | ingate | 1 | 48755 | 5 | 0.736 | 66243.2 |
668 | 2022-06-05 20:41:55 | ingate | 1 | 48755 | 5 | 0.750 | 65006.7 |
667 | 2022-06-02 19:59:25 | ingate | 1 | 48755 | 5 | 0.733 | 66514.3 |
666 | 2022-05-31 14:18:24 | ingate | 1 | 48755 | 5 | 0.813 | 59969.2 |
665 | 2022-02-19 02:29:00 | ingate | 1 | 48755 | 5 | 0.860 | 56691.9 |
664 | 2022-01-19 22:05:50 | ingate | 1 | 48755 | 5 | 0.873 | 55847.7 |
663 | 2021-11-17 17:55:36 | ingate | 1 | 48755 | 5 | 1.626 | 29984.6 |
662 | 2021-11-17 15:14:24 | ingate | 1 | 48755 | 5 | 0.750 | 65006.7 |
661 | 2021-10-07 12:56:28 | ingate | 1 | 48755 | 5 | 0.720 | 67715.3 |
660 | 2021-09-18 09:59:09 | ingate | 1 | 48755 | 5 | 0.813 | 59969.2 |
659 | 2021-08-18 04:51:31 | ingate | 1 | 48755 | 5 | 0.766 | 63648.8 |
658 | 2021-08-14 21:23:04 | ingate | 1 | 48755 | 5 | 0.733 | 66514.3 |
657 | 2021-05-28 17:25:31 | ingate | 2 | 82551 | 55 | 2.156 | 38289.0 |
656 | 2021-05-14 05:52:31 | ingate | 1 | 48755 | 5 | 0.873 | 55847.7 |
655 | 2021-05-03 00:01:13 | ingate | 2 | 82551 | 55 | 2.533 | 32590.2 |
654 | 2021-04-01 06:14:19 | ingate | 2 | 82551 | 55 | 2.313 | 35690.0 |
653 | 2021-02-13 14:01:43 | ingate | 3 | 112716 | 566 | 5.750 | 19602.8 |
652 | 2021-02-10 22:06:23 | ingate | 1 | 48755 | 5 | 0.736 | 66243.2 |
651 | 2021-02-06 02:58:19 | ingate | 1 | 48755 | 5 | 0.846 | 57630.0 |
650 | 2021-01-30 23:37:16 | ingate | 1 | 48755 | 5 | 0.826 | 59025.4 |
649 | 2021-01-30 05:41:04 | ingate | 1 | 48755 | 5 | 0.750 | 65006.7 |
648 | 2021-01-21 01:11:03 | ingate | 3 | 112716 | 566 | 4.673 | 24120.7 |
647 | 2021-01-16 06:00:51 | ingate | 2 | 82551 | 55 | 2.346 | 35188.0 |
646 | 2020-11-25 19:00:43 | ingate | 3 | 112716 | 566 | 4.716 | 23900.8 |
645 | 2020-11-14 03:11:18 | ingate | 3 | 112716 | 566 | 4.796 | 23502.1 |
644 | 2020-11-08 09:04:16 | ingate | 3 | 112716 | 566 | 4.766 | 23650.0 |
643 | 2020-11-04 02:17:12 | ingate | 1 | 48755 | 5 | 0.843 | 57835.1 |
642 | 2020-11-01 00:57:36 | ingate | 3 | 112716 | 566 | 4.936 | 22835.5 |
641 | 2020-10-30 09:56:38 | ingate | 3 | 112716 | 566 | 5.076 | 22205.7 |
640 | 2020-10-27 20:34:23 | ingate | 2 | 82551 | 55 | 2.390 | 34540.2 |
639 | 2020-10-26 17:09:12 | ingate | 1 | 48755 | 5 | 0.733 | 66514.3 |
638 | 2020-10-25 04:46:02 | ingate | 1 | 48755 | 5 | 0.750 | 65006.7 |
637 | 2020-10-23 07:54:09 | ingate | 1 | 48755 | 5 | 0.733 | 66514.3 |
636 | 2020-10-17 05:57:31 | ingate | 1 | 48755 | 5 | 0.813 | 59969.2 |
635 | 2020-09-10 15:16:05 | ingate | 1 | 48755 | 5 | 0.766 | 63648.8 |
634 | 2020-08-24 14:46:18 | ingate | 3 | 112716 | 566 | 4.860 | 23192.6 |