History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"visitor"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 809 | 2024-05-01 02:07:50 | visitor | 4 | 151207 | 1076 | 11.610 | 13023.9 |
| 808 | 2024-04-26 10:45:36 | visitor | 4 | 151207 | 1076 | 14.016 | 10788.2 |
| 807 | 2024-04-25 20:43:27 | visitor | 4 | 151207 | 1076 | 28.656 | 5276.6 |
| 806 | 2024-04-25 16:28:44 | visitor | 4 | 151207 | 1076 | 17.376 | 8702.1 |
| 805 | 2024-04-25 02:50:42 | visitor | 4 | 151207 | 1076 | 23.640 | 6396.2 |
| 804 | 2024-04-24 19:29:11 | visitor | 4 | 151207 | 1076 | 33.533 | 4509.2 |
| 803 | 2024-04-23 12:15:38 | visitor | 4 | 151207 | 1076 | 50.440 | 2997.8 |
| 802 | 2024-04-13 10:45:47 | visitor | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 801 | 2024-04-09 16:50:09 | visitor | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 800 | 2024-03-28 18:41:56 | visitor | 1 | 69583 | 3 | 3.030 | 22964.7 |
| 799 | 2024-03-19 22:44:15 | visitor | 4 | 151207 | 1076 | 20.970 | 7210.6 |
| 798 | 2024-03-06 23:43:59 | visitor | 4 | 151207 | 1076 | 28.236 | 5355.1 |
| 797 | 2024-03-05 19:08:58 | visitor | 4 | 151207 | 1076 | 47.690 | 3170.6 |
| 796 | 2024-03-05 00:39:24 | visitor | 4 | 151207 | 1076 | 26.626 | 5678.9 |
| 795 | 2024-03-04 07:07:11 | visitor | 4 | 151207 | 1076 | 26.063 | 5801.6 |
| 794 | 2024-03-04 01:10:56 | visitor | 2 | 107671 | 12 | 9.593 | 11223.9 |
| 793 | 2024-03-03 09:44:57 | visitor | 4 | 151207 | 1076 | 10.940 | 13821.5 |
| 792 | 2024-03-03 09:44:58 | visitor | 2 | 107671 | 12 | 3.220 | 33438.2 |
| 791 | 2024-03-03 09:44:42 | visitor | 3 | 134027 | 96 | 6.750 | 19855.9 |
| 790 | 2024-03-03 06:28:44 | visitor | 3 | 134027 | 96 | 18.750 | 7148.1 |
| 789 | 2024-02-28 08:32:46 | visitor | 3 | 134027 | 96 | 19.783 | 6774.9 |
| 788 | 2024-02-27 14:27:40 | visitor | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 787 | 2024-02-26 03:41:06 | visitor | 3 | 134027 | 96 | 7.860 | 17051.8 |
| 786 | 2024-02-25 22:56:09 | visitor | 3 | 134027 | 96 | 12.626 | 10615.2 |
| 785 | 2024-02-25 22:55:55 | visitor | 1 | 69583 | 3 | 2.936 | 23699.9 |
| 784 | 2024-02-11 16:44:35 | visitor | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 783 | 2024-02-05 04:54:00 | visitor | 4 | 151207 | 1076 | 14.906 | 10144.0 |
| 782 | 2024-01-30 17:12:27 | visitor | 4 | 151207 | 1076 | 10.890 | 13884.9 |
| 781 | 2024-01-30 15:19:59 | visitor | 4 | 151207 | 1076 | 13.373 | 11306.9 |
| 780 | 2024-01-30 12:56:40 | visitor | 4 | 151207 | 1076 | 23.360 | 6472.9 |
| 779 | 2023-12-29 03:59:44 | visitor | 3 | 134027 | 96 | 6.220 | 21547.7 |
| 778 | 2023-12-14 05:28:34 | visitor | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 777 | 2023-12-04 12:16:56 | visitor | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 776 | 2023-12-02 01:01:55 | visitor | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 775 | 2023-11-26 10:27:29 | visitor | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 774 | 2023-11-21 00:34:38 | visitor | 1 | 69583 | 3 | 1.206 | 57697.3 |
| 773 | 2023-10-18 16:47:34 | visitor | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 772 | 2023-10-15 22:51:12 | visitor | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 771 | 2023-10-09 00:55:50 | visitor | 3 | 134027 | 96 | 8.220 | 16305.0 |
| 770 | 2023-10-04 21:14:04 | visitor | 4 | 151207 | 1076 | 25.516 | 5926.0 |
| 769 | 2023-10-04 07:37:34 | visitor | 4 | 151207 | 1076 | 9.596 | 15757.3 |
| 768 | 2023-10-02 05:19:33 | visitor | 3 | 134027 | 96 | 5.596 | 23950.5 |
| 767 | 2023-10-01 07:29:13 | visitor | 4 | 151207 | 1076 | 14.686 | 10296.0 |
| 766 | 2023-10-01 03:10:15 | visitor | 4 | 151207 | 1076 | 13.640 | 11085.6 |
| 765 | 2023-09-29 09:04:49 | visitor | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 764 | 2023-09-26 08:01:23 | visitor | 4 | 151207 | 1076 | 10.346 | 14615.0 |
| 763 | 2023-09-23 23:17:10 | visitor | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 762 | 2023-09-17 06:57:46 | visitor | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 761 | 2023-07-05 23:48:18 | visitor | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 760 | 2023-06-04 18:00:54 | visitor | 1 | 69583 | 3 | 1.016 | 68487.2 |
| 759 | 2023-04-12 22:06:17 | visitor | 1 | 69583 | 3 | 1.013 | 68690.0 |
| 758 | 2023-04-02 01:58:06 | visitor | 3 | 134027 | 96 | 6.720 | 19944.5 |
| 757 | 2023-02-04 00:19:37 | visitor | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 756 | 2023-02-02 07:39:18 | visitor | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 755 | 2022-12-29 02:53:06 | visitor | 3 | 134027 | 96 | 5.453 | 24578.6 |
| 754 | 2022-12-01 18:09:16 | visitor | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 753 | 2022-09-20 09:41:40 | visitor | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 752 | 2022-09-03 11:28:34 | visitor | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 751 | 2022-08-29 04:03:47 | visitor | 3 | 134027 | 96 | 5.530 | 24236.3 |
| 750 | 2022-08-26 08:42:22 | visitor | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 749 | 2022-07-30 01:02:42 | visitor | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 748 | 2022-07-27 23:25:24 | visitor | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 747 | 2022-07-03 09:27:10 | visitor | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 746 | 2022-06-16 09:24:56 | visitor | 1 | 69583 | 3 | 1.016 | 68487.2 |
| 745 | 2022-05-26 02:02:27 | visitor | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 744 | 2022-04-26 15:20:59 | visitor | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 743 | 2022-04-22 23:32:40 | visitor | 1 | 69583 | 3 | 1.626 | 42794.0 |
| 742 | 2022-04-10 06:48:40 | visitor | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 741 | 2022-04-02 08:03:31 | visitor | 4 | 151207 | 1076 | 9.563 | 15811.7 |
| 740 | 2022-02-16 09:46:10 | visitor | 4 | 151207 | 1076 | 9.783 | 15456.1 |
| 739 | 2022-01-10 04:48:45 | visitor | 4 | 151207 | 1076 | 10.236 | 14772.1 |
| 738 | 2021-12-25 19:18:38 | visitor | 4 | 151207 | 1076 | 11.250 | 13440.6 |
| 737 | 2021-12-18 14:05:04 | visitor | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 736 | 2021-12-02 20:42:19 | visitor | 4 | 151207 | 1076 | 11.440 | 13217.4 |
| 735 | 2021-11-23 18:45:31 | visitor | 4 | 151207 | 1076 | 9.763 | 15487.8 |
| 734 | 2021-11-19 12:45:32 | visitor | 4 | 151207 | 1076 | 9.623 | 15713.1 |
| 733 | 2021-11-18 12:43:35 | visitor | 4 | 151207 | 1076 | 11.593 | 13043.0 |
| 732 | 2021-11-17 12:52:41 | visitor | 4 | 151207 | 1076 | 12.046 | 12552.5 |
| 731 | 2021-11-15 16:14:10 | visitor | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 730 | 2021-11-15 12:33:22 | visitor | 4 | 151207 | 1076 | 11.266 | 13421.5 |
| 729 | 2021-11-15 07:56:07 | visitor | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 728 | 2021-11-14 15:40:55 | visitor | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 727 | 2021-11-14 09:29:24 | visitor | 4 | 151207 | 1076 | 11.530 | 13114.2 |
| 726 | 2021-11-14 07:24:18 | visitor | 1 | 69583 | 3 | 2.893 | 24052.2 |
| 725 | 2021-11-13 17:12:49 | visitor | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 724 | 2021-11-13 09:20:45 | visitor | 4 | 151207 | 1076 | 12.846 | 11770.7 |
| 723 | 2021-11-13 08:54:17 | visitor | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 722 | 2021-11-12 19:48:04 | visitor | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 721 | 2021-11-12 09:22:36 | visitor | 4 | 151207 | 1076 | 12.686 | 11919.2 |
| 720 | 2021-11-12 06:19:15 | visitor | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 719 | 2021-11-11 12:54:39 | visitor | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 718 | 2021-11-08 10:19:31 | visitor | 4 | 151207 | 1076 | 11.140 | 13573.3 |
| 717 | 2021-10-21 22:23:38 | visitor | 4 | 151207 | 1076 | 11.516 | 13130.2 |
| 716 | 2021-10-20 23:27:43 | visitor | 4 | 151207 | 1076 | 10.140 | 14911.9 |
| 715 | 2021-10-12 23:29:10 | visitor | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 714 | 2021-10-10 23:25:09 | visitor | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 713 | 2021-09-25 04:29:34 | visitor | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 712 | 2021-09-24 14:03:59 | visitor | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 711 | 2021-09-23 15:41:23 | visitor | 4 | 151207 | 1076 | 10.983 | 13767.4 |
| 710 | 2021-09-19 08:35:24 | visitor | 1 | 69583 | 3 | 1.186 | 58670.3 |