History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"indexing"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 899 | 2024-05-29 11:57:11 | indexing | 3 | 146162 | 186 | 16.190 | 9027.9 |
| 898 | 2024-05-26 10:47:19 | indexing | 3 | 146162 | 186 | 18.733 | 7802.4 |
| 897 | 2024-05-26 10:47:19 | indexing | 2 | 121059 | 18 | 13.360 | 9061.3 |
| 896 | 2024-05-26 10:47:12 | indexing | 1 | 82945 | 2 | 3.063 | 27079.7 |
| 895 | 2024-05-15 08:42:29 | indexing | 2 | 121059 | 18 | 3.673 | 32959.2 |
| 894 | 2024-05-15 08:42:16 | indexing | 3 | 146162 | 186 | 7.813 | 18707.5 |
| 893 | 2024-05-15 05:07:13 | indexing | 2 | 121059 | 18 | 3.673 | 32959.2 |
| 892 | 2024-05-15 05:05:53 | indexing | 3 | 146162 | 186 | 7.376 | 19815.9 |
| 891 | 2024-05-15 00:13:25 | indexing | 3 | 146162 | 186 | 8.173 | 17883.5 |
| 890 | 2024-05-15 00:13:23 | indexing | 2 | 121059 | 18 | 3.936 | 30756.9 |
| 889 | 2024-05-15 00:13:22 | indexing | 1 | 82945 | 2 | 1.486 | 55817.6 |
| 888 | 2024-05-05 23:34:02 | indexing | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 887 | 2024-04-29 10:49:27 | indexing | 1 | 82945 | 2 | 3.220 | 25759.3 |
| 886 | 2024-04-27 03:36:22 | indexing | 3 | 146162 | 186 | 19.983 | 7314.3 |
| 885 | 2024-04-23 02:14:21 | indexing | 1 | 82945 | 2 | 1.486 | 55817.6 |
| 884 | 2024-04-06 18:34:58 | indexing | 1 | 82945 | 2 | 1.780 | 46598.3 |
| 883 | 2024-04-06 16:37:04 | indexing | 2 | 121059 | 18 | 4.046 | 29920.7 |
| 882 | 2024-04-05 20:10:57 | indexing | 1 | 82945 | 2 | 1.266 | 65517.4 |
| 881 | 2024-04-05 12:23:46 | indexing | 3 | 146162 | 186 | 8.016 | 18233.8 |
| 880 | 2024-04-05 12:23:47 | indexing | 2 | 121059 | 18 | 3.796 | 31891.2 |
| 879 | 2024-04-05 12:23:38 | indexing | 3 | 146162 | 186 | 6.800 | 21494.4 |
| 878 | 2024-04-05 12:23:41 | indexing | 1 | 82945 | 2 | 1.750 | 47397.1 |
| 877 | 2024-04-05 12:23:34 | indexing | 2 | 121059 | 18 | 4.843 | 24996.7 |
| 876 | 2024-03-31 22:36:25 | indexing | 1 | 82945 | 2 | 1.560 | 53169.9 |
| 875 | 2024-03-29 23:43:32 | indexing | 1 | 82945 | 2 | 4.890 | 16962.2 |
| 874 | 2024-03-23 18:01:59 | indexing | 1 | 82945 | 2 | 1.830 | 45325.1 |
| 873 | 2024-03-13 16:17:08 | indexing | 3 | 146162 | 186 | 12.953 | 11284.0 |
| 872 | 2024-03-13 16:17:08 | indexing | 2 | 121059 | 18 | 3.893 | 31096.6 |
| 871 | 2024-03-13 16:17:02 | indexing | 1 | 82945 | 2 | 2.513 | 33006.4 |
| 870 | 2024-03-06 10:04:15 | indexing | 1 | 82945 | 2 | 3.376 | 24569.0 |
| 869 | 2024-03-05 02:53:12 | indexing | 1 | 82945 | 2 | 3.203 | 25896.0 |
| 868 | 2024-03-05 02:52:57 | indexing | 2 | 121059 | 18 | 5.533 | 21879.5 |
| 867 | 2024-03-02 15:38:56 | indexing | 1 | 82945 | 2 | 3.390 | 24467.6 |
| 866 | 2024-02-29 19:30:44 | indexing | 2 | 121059 | 18 | 3.766 | 32145.2 |
| 865 | 2024-02-29 19:30:33 | indexing | 3 | 146162 | 186 | 7.626 | 19166.3 |
| 864 | 2024-02-26 16:11:45 | indexing | 3 | 146162 | 186 | 19.860 | 7359.6 |
| 863 | 2024-02-25 22:59:41 | indexing | 3 | 146162 | 186 | 26.483 | 5519.1 |
| 862 | 2024-02-22 19:01:16 | indexing | 3 | 146162 | 186 | 6.656 | 21959.4 |
| 861 | 2024-02-22 19:01:14 | indexing | 2 | 121059 | 18 | 3.250 | 37248.9 |
| 860 | 2024-02-22 07:52:55 | indexing | 1 | 82945 | 2 | 1.406 | 58993.6 |
| 859 | 2024-02-12 12:09:50 | indexing | 3 | 146162 | 186 | 16.656 | 8775.3 |
| 858 | 2024-02-12 12:09:50 | indexing | 2 | 121059 | 18 | 4.250 | 28484.5 |
| 857 | 2024-02-12 10:56:21 | indexing | 1 | 82945 | 2 | 1.360 | 60989.0 |
| 856 | 2024-01-10 05:12:52 | indexing | 1 | 82945 | 2 | 1.326 | 62552.8 |
| 855 | 2023-12-21 09:59:54 | indexing | 3 | 146162 | 186 | 6.186 | 23627.9 |
| 854 | 2023-12-21 09:35:28 | indexing | 1 | 82945 | 2 | 1.390 | 59672.7 |
| 853 | 2023-12-16 07:33:53 | indexing | 1 | 82945 | 2 | 1.266 | 65517.4 |
| 852 | 2023-11-28 04:57:44 | indexing | 1 | 82945 | 2 | 1.250 | 66356.0 |
| 851 | 2023-10-25 14:12:17 | indexing | 1 | 82945 | 2 | 1.356 | 61168.9 |
| 850 | 2023-10-13 04:09:00 | indexing | 1 | 82945 | 2 | 2.923 | 28376.7 |
| 849 | 2023-10-09 09:35:30 | indexing | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 848 | 2023-10-06 19:12:27 | indexing | 1 | 82945 | 2 | 1.266 | 65517.4 |
| 847 | 2023-10-06 16:33:42 | indexing | 3 | 146162 | 186 | 17.376 | 8411.7 |
| 846 | 2023-09-22 05:54:01 | indexing | 1 | 82945 | 2 | 1.280 | 64800.8 |
| 845 | 2023-09-21 15:35:45 | indexing | 3 | 146162 | 186 | 10.703 | 13656.2 |
| 844 | 2023-08-04 18:30:16 | indexing | 1 | 82945 | 2 | 1.266 | 65517.4 |
| 843 | 2023-06-28 11:45:59 | indexing | 3 | 146162 | 186 | 6.080 | 24039.8 |
| 842 | 2023-06-26 04:31:05 | indexing | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 841 | 2023-06-23 00:55:17 | indexing | 3 | 146162 | 186 | 7.766 | 18820.8 |
| 840 | 2023-05-04 03:11:17 | indexing | 1 | 82945 | 2 | 1.250 | 66356.0 |
| 839 | 2023-04-27 14:48:49 | indexing | 1 | 82945 | 2 | 1.250 | 66356.0 |
| 838 | 2023-03-28 08:29:11 | indexing | 1 | 82945 | 2 | 1.346 | 61623.3 |
| 837 | 2023-03-20 16:01:42 | indexing | 3 | 146162 | 186 | 7.236 | 20199.3 |
| 836 | 2023-03-07 04:55:43 | indexing | 1 | 82945 | 2 | 2.700 | 30720.4 |
| 835 | 2023-02-26 08:06:16 | indexing | 1 | 82945 | 2 | 1.390 | 59672.7 |
| 834 | 2023-02-08 23:06:21 | indexing | 3 | 146162 | 186 | 6.016 | 24295.5 |
| 833 | 2023-02-07 23:40:50 | indexing | 3 | 146162 | 186 | 5.970 | 24482.7 |
| 832 | 2023-02-01 10:40:32 | indexing | 3 | 146162 | 186 | 7.626 | 19166.3 |
| 831 | 2023-01-31 04:01:45 | indexing | 3 | 146162 | 186 | 6.893 | 21204.4 |
| 830 | 2023-01-30 05:48:59 | indexing | 3 | 146162 | 186 | 7.236 | 20199.3 |
| 829 | 2023-01-29 08:34:41 | indexing | 3 | 146162 | 186 | 7.673 | 19048.9 |
| 828 | 2023-01-28 10:13:57 | indexing | 3 | 146162 | 186 | 7.830 | 18666.9 |
| 827 | 2023-01-03 20:00:16 | indexing | 3 | 146162 | 186 | 7.233 | 20207.7 |
| 826 | 2023-01-02 22:45:07 | indexing | 3 | 146162 | 186 | 7.906 | 18487.5 |
| 825 | 2023-01-01 15:31:27 | indexing | 3 | 146162 | 186 | 7.360 | 19859.0 |
| 824 | 2022-12-27 22:00:02 | indexing | 3 | 146162 | 186 | 7.403 | 19743.6 |
| 823 | 2022-12-24 20:27:04 | indexing | 3 | 146162 | 186 | 7.296 | 20033.2 |
| 822 | 2022-12-21 08:04:02 | indexing | 3 | 146162 | 186 | 5.983 | 24429.6 |
| 821 | 2022-11-11 11:53:05 | indexing | 1 | 82945 | 2 | 1.346 | 61623.3 |
| 820 | 2022-11-08 01:21:19 | indexing | 1 | 82945 | 2 | 1.376 | 60279.8 |
| 819 | 2022-08-18 12:19:42 | indexing | 3 | 146162 | 186 | 6.110 | 23921.8 |
| 818 | 2022-08-16 02:25:49 | indexing | 1 | 82945 | 2 | 1.233 | 67270.9 |
| 817 | 2022-08-06 08:43:38 | indexing | 1 | 82945 | 2 | 1.250 | 66356.0 |
| 816 | 2022-07-28 23:48:03 | indexing | 1 | 82945 | 2 | 1.280 | 64800.8 |
| 815 | 2022-07-22 08:33:24 | indexing | 1 | 82945 | 2 | 1.233 | 67270.9 |
| 814 | 2022-07-18 15:40:05 | indexing | 1 | 82945 | 2 | 1.266 | 65517.4 |
| 813 | 2022-07-17 20:17:48 | indexing | 1 | 82945 | 2 | 1.250 | 66356.0 |
| 812 | 2022-06-26 05:57:14 | indexing | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 811 | 2022-06-17 00:24:38 | indexing | 1 | 82945 | 2 | 1.250 | 66356.0 |
| 810 | 2022-06-09 23:41:12 | indexing | 3 | 146162 | 186 | 6.296 | 23215.1 |
| 809 | 2022-06-08 23:58:33 | indexing | 1 | 82945 | 2 | 1.313 | 63172.1 |
| 808 | 2022-06-08 21:57:12 | indexing | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 807 | 2022-06-08 17:05:25 | indexing | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 806 | 2022-06-07 15:59:45 | indexing | 3 | 146162 | 186 | 7.390 | 19778.3 |
| 805 | 2022-06-06 06:48:04 | indexing | 3 | 146162 | 186 | 7.890 | 18525.0 |
| 804 | 2022-06-05 09:52:53 | indexing | 3 | 146162 | 186 | 7.096 | 20597.8 |
| 803 | 2022-06-04 06:18:34 | indexing | 3 | 146162 | 186 | 7.360 | 19859.0 |
| 802 | 2022-06-03 04:49:26 | indexing | 3 | 146162 | 186 | 6.780 | 21557.8 |
| 801 | 2022-06-02 13:41:17 | indexing | 3 | 146162 | 186 | 8.013 | 18240.6 |
| 800 | 2022-06-01 13:24:15 | indexing | 1 | 82945 | 2 | 1.250 | 66356.0 |