History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"burgh"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
721 | 2024-04-26 18:17:24 | burgh | 1 | 28756 | 5 | 0.563 | 51076.4 |
720 | 2024-04-05 15:13:01 | burgh | 3 | 83667 | 829 | 10.423 | 8027.2 |
719 | 2024-04-05 06:49:09 | burgh | 3 | 83667 | 829 | 5.140 | 16277.6 |
718 | 2024-04-05 06:49:08 | burgh | 2 | 53800 | 80 | 2.453 | 21932.3 |
717 | 2024-04-05 06:48:59 | burgh | 1 | 28756 | 5 | 0.546 | 52666.7 |
716 | 2024-04-05 06:48:51 | burgh | 3 | 83667 | 829 | 5.610 | 14913.9 |
715 | 2024-04-05 06:48:50 | burgh | 2 | 53800 | 80 | 1.733 | 31044.4 |
714 | 2024-04-05 06:48:48 | burgh | 1 | 28756 | 5 | 0.500 | 57512.0 |
713 | 2024-04-03 05:56:30 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
712 | 2024-03-31 07:51:53 | burgh | 1 | 28756 | 5 | 1.703 | 16885.5 |
711 | 2024-03-29 00:55:52 | burgh | 1 | 28756 | 5 | 1.736 | 16564.5 |
710 | 2024-03-28 20:08:03 | burgh | 1 | 28756 | 5 | 0.546 | 52666.7 |
709 | 2024-03-13 02:34:30 | burgh | 3 | 83667 | 829 | 5.750 | 14550.8 |
708 | 2024-03-05 22:29:55 | burgh | 1 | 28756 | 5 | 1.063 | 27051.7 |
707 | 2024-03-01 02:04:34 | burgh | 1 | 28756 | 5 | 0.623 | 46157.3 |
706 | 2024-02-27 09:16:06 | burgh | 2 | 53800 | 80 | 1.890 | 28465.6 |
705 | 2024-02-27 09:15:34 | burgh | 3 | 83667 | 829 | 7.703 | 10861.6 |
704 | 2024-02-26 19:12:39 | burgh | 1 | 28756 | 5 | 1.966 | 14626.7 |
703 | 2024-02-26 07:52:16 | burgh | 3 | 83667 | 829 | 4.000 | 20916.8 |
702 | 2024-01-29 08:49:03 | burgh | 1 | 28756 | 5 | 0.516 | 55728.7 |
701 | 2024-01-26 10:23:49 | burgh | 3 | 83667 | 829 | 4.110 | 20356.9 |
700 | 2024-01-22 18:28:15 | burgh | 3 | 83667 | 829 | 5.220 | 16028.2 |
699 | 2024-01-17 21:45:38 | burgh | 3 | 83667 | 829 | 4.093 | 20441.5 |
698 | 2024-01-17 21:45:37 | burgh | 2 | 53800 | 80 | 1.703 | 31591.3 |
697 | 2024-01-04 14:24:34 | burgh | 1 | 28756 | 5 | 0.530 | 54256.6 |
696 | 2024-01-03 00:42:12 | burgh | 3 | 83667 | 829 | 3.390 | 24680.5 |
695 | 2023-12-29 00:06:32 | burgh | 3 | 83667 | 829 | 3.500 | 23904.9 |
694 | 2023-12-29 00:06:30 | burgh | 2 | 53800 | 80 | 1.453 | 37026.8 |
693 | 2023-12-01 14:40:36 | burgh | 2 | 53800 | 80 | 1.576 | 34137.1 |
692 | 2023-11-19 20:34:00 | burgh | 3 | 83667 | 829 | 3.720 | 22491.1 |
691 | 2023-11-19 07:41:15 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
690 | 2023-11-17 13:26:09 | burgh | 1 | 28756 | 5 | 0.516 | 55728.7 |
689 | 2023-11-13 00:45:14 | burgh | 1 | 28756 | 5 | 0.440 | 65354.5 |
688 | 2023-11-08 11:37:24 | burgh | 1 | 28756 | 5 | 0.450 | 63902.2 |
687 | 2023-11-03 15:32:55 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
686 | 2023-10-27 05:54:49 | burgh | 1 | 28756 | 5 | 0.623 | 46157.3 |
685 | 2023-10-22 12:58:49 | burgh | 1 | 28756 | 5 | 0.983 | 29253.3 |
684 | 2023-10-22 01:10:47 | burgh | 2 | 53800 | 80 | 1.593 | 33772.8 |
683 | 2023-10-19 10:41:45 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
682 | 2023-10-17 05:38:25 | burgh | 3 | 83667 | 829 | 5.453 | 15343.3 |
681 | 2023-10-16 02:44:56 | burgh | 2 | 53800 | 80 | 1.533 | 35094.6 |
680 | 2023-10-16 02:44:48 | burgh | 3 | 83667 | 829 | 3.440 | 24321.8 |
679 | 2023-10-13 02:31:42 | burgh | 1 | 28756 | 5 | 0.470 | 61183.0 |
678 | 2023-10-03 23:39:39 | burgh | 1 | 28756 | 5 | 0.470 | 61183.0 |
677 | 2023-09-27 02:49:25 | burgh | 1 | 28756 | 5 | 0.483 | 59536.2 |
676 | 2023-09-20 17:10:33 | burgh | 1 | 28756 | 5 | 0.500 | 57512.0 |
675 | 2023-09-15 16:25:15 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
674 | 2023-09-13 16:24:15 | burgh | 2 | 53800 | 80 | 1.656 | 32487.9 |
673 | 2023-09-10 13:28:04 | burgh | 3 | 83667 | 829 | 7.703 | 10861.6 |
672 | 2023-09-10 10:04:30 | burgh | 3 | 83667 | 829 | 3.453 | 24230.2 |
671 | 2023-08-21 17:11:29 | burgh | 1 | 28756 | 5 | 0.516 | 55728.7 |
670 | 2023-08-20 02:05:19 | burgh | 3 | 83667 | 829 | 3.796 | 22040.8 |
669 | 2023-08-19 08:09:36 | burgh | 1 | 28756 | 5 | 0.530 | 54256.6 |
668 | 2023-08-02 11:34:40 | burgh | 1 | 28756 | 5 | 0.486 | 59168.7 |
667 | 2023-07-29 17:24:57 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
666 | 2023-05-23 09:11:00 | burgh | 1 | 28756 | 5 | 0.500 | 57512.0 |
665 | 2023-05-11 03:24:15 | burgh | 3 | 83667 | 829 | 3.250 | 25743.7 |
664 | 2023-05-07 08:33:17 | burgh | 3 | 83667 | 829 | 3.233 | 25879.1 |
663 | 2023-04-21 09:24:31 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
662 | 2023-03-05 00:35:42 | burgh | 1 | 28756 | 5 | 0.483 | 59536.2 |
661 | 2023-02-11 11:29:28 | burgh | 3 | 83667 | 829 | 3.156 | 26510.5 |
660 | 2023-01-07 15:18:43 | burgh | 1 | 28756 | 5 | 0.483 | 59536.2 |
659 | 2023-01-01 11:56:21 | burgh | 1 | 28756 | 5 | 0.453 | 63479.0 |
658 | 2022-12-28 19:08:40 | burgh | 1 | 28756 | 5 | 0.500 | 57512.0 |
657 | 2022-11-25 06:23:10 | burgh | 1 | 28756 | 5 | 0.500 | 57512.0 |
656 | 2022-11-23 04:44:02 | burgh | 1 | 28756 | 5 | 0.453 | 63479.0 |
655 | 2022-11-22 18:16:21 | burgh | 3 | 83667 | 829 | 3.703 | 22594.4 |
654 | 2022-10-02 14:17:48 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
653 | 2022-09-10 19:42:26 | burgh | 1 | 28756 | 5 | 0.453 | 63479.0 |
652 | 2022-08-06 02:46:53 | burgh | 3 | 83667 | 829 | 3.216 | 26015.9 |
651 | 2022-05-29 05:27:35 | burgh | 1 | 28756 | 5 | 0.423 | 67981.1 |
650 | 2022-05-18 08:28:40 | burgh | 1 | 28756 | 5 | 0.466 | 61708.2 |
649 | 2022-05-16 07:39:01 | burgh | 3 | 83667 | 829 | 3.220 | 25983.5 |
648 | 2022-05-16 04:22:10 | burgh | 1 | 28756 | 5 | 0.500 | 57512.0 |
647 | 2022-05-16 02:21:40 | burgh | 1 | 28756 | 5 | 0.890 | 32310.1 |
646 | 2022-04-24 07:11:52 | burgh | 3 | 83667 | 829 | 3.220 | 25983.5 |
645 | 2022-04-22 01:33:21 | burgh | 3 | 83667 | 829 | 3.220 | 25983.5 |
644 | 2022-02-17 23:54:57 | burgh | 1 | 28756 | 5 | 0.453 | 63479.0 |
643 | 2022-01-28 15:16:24 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
642 | 2022-01-08 19:08:07 | burgh | 1 | 28756 | 5 | 0.516 | 55728.7 |
641 | 2021-12-27 10:10:18 | burgh | 3 | 83667 | 829 | 3.826 | 21868.0 |
640 | 2021-12-14 13:59:24 | burgh | 3 | 83667 | 829 | 4.063 | 20592.4 |
639 | 2021-12-13 19:56:41 | burgh | 3 | 83667 | 829 | 3.720 | 22491.1 |
638 | 2021-12-12 15:20:27 | burgh | 3 | 83667 | 829 | 3.813 | 21942.6 |
637 | 2021-11-26 01:05:49 | burgh | 1 | 28756 | 5 | 0.483 | 59536.2 |
636 | 2021-11-23 21:21:17 | burgh | 1 | 28756 | 5 | 0.500 | 57512.0 |
635 | 2021-11-16 15:11:00 | burgh | 1 | 28756 | 5 | 0.466 | 61708.2 |
634 | 2021-10-14 18:00:30 | burgh | 1 | 28756 | 5 | 0.500 | 57512.0 |
633 | 2021-10-13 21:58:45 | burgh | 1 | 28756 | 5 | 0.516 | 55728.7 |
632 | 2021-10-12 13:47:18 | burgh | 1 | 28756 | 5 | 0.500 | 57512.0 |
631 | 2021-10-11 16:43:04 | burgh | 1 | 28756 | 5 | 0.483 | 59536.2 |
630 | 2021-10-10 13:38:25 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
629 | 2021-10-07 14:06:04 | burgh | 3 | 83667 | 829 | 3.656 | 22884.8 |
628 | 2021-10-06 03:06:35 | burgh | 3 | 83667 | 829 | 3.266 | 25617.6 |
627 | 2021-10-03 09:39:46 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
626 | 2021-10-01 16:23:23 | burgh | 3 | 83667 | 829 | 4.263 | 19626.3 |
625 | 2021-10-01 06:27:14 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
624 | 2021-09-20 09:38:35 | burgh | 1 | 28756 | 5 | 0.436 | 65954.1 |
623 | 2021-09-19 19:12:45 | burgh | 1 | 28756 | 5 | 1.016 | 28303.1 |
622 | 2021-09-18 18:54:52 | burgh | 3 | 83667 | 829 | 3.203 | 26121.4 |