History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lighted"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 932 | 2024-04-19 11:05:54 | lighted | 3 | 134027 | 359 | 13.673 | 9802.3 |
| 931 | 2024-04-10 04:15:53 | lighted | 1 | 69583 | 15 | 1.233 | 56433.9 |
| 930 | 2024-04-08 21:22:09 | lighted | 3 | 134027 | 359 | 6.296 | 21287.6 |
| 929 | 2024-04-06 16:00:34 | lighted | 1 | 69583 | 15 | 1.250 | 55666.4 |
| 928 | 2024-03-21 22:36:23 | lighted | 2 | 107671 | 51 | 7.110 | 15143.6 |
| 927 | 2024-03-21 22:35:57 | lighted | 3 | 134027 | 359 | 7.220 | 18563.3 |
| 926 | 2024-03-20 18:05:50 | lighted | 1 | 69583 | 15 | 2.656 | 26198.4 |
| 925 | 2024-03-18 20:16:45 | lighted | 2 | 107671 | 51 | 3.560 | 30244.7 |
| 924 | 2024-03-18 04:31:11 | lighted | 3 | 134027 | 359 | 15.360 | 8725.7 |
| 923 | 2024-03-16 18:58:27 | lighted | 2 | 107671 | 51 | 7.173 | 15010.6 |
| 922 | 2024-03-16 18:54:18 | lighted | 3 | 134027 | 359 | 14.626 | 9163.6 |
| 921 | 2024-03-16 18:54:20 | lighted | 2 | 107671 | 51 | 3.390 | 31761.4 |
| 920 | 2024-03-16 18:54:14 | lighted | 1 | 69583 | 15 | 1.173 | 59320.5 |
| 919 | 2024-03-16 18:53:57 | lighted | 3 | 134027 | 359 | 6.233 | 21502.8 |
| 918 | 2024-03-16 12:59:09 | lighted | 3 | 134027 | 359 | 12.516 | 10708.5 |
| 917 | 2024-03-15 16:11:43 | lighted | 3 | 134027 | 359 | 12.253 | 10938.3 |
| 916 | 2024-03-15 09:27:11 | lighted | 3 | 134027 | 359 | 16.173 | 8287.1 |
| 915 | 2024-03-15 09:26:07 | lighted | 3 | 134027 | 359 | 16.170 | 8288.6 |
| 914 | 2024-03-06 11:03:13 | lighted | 1 | 69583 | 15 | 2.283 | 30478.8 |
| 913 | 2024-02-04 02:52:03 | lighted | 3 | 134027 | 359 | 7.203 | 18607.1 |
| 912 | 2024-01-31 16:05:56 | lighted | 2 | 107671 | 51 | 3.203 | 33615.7 |
| 911 | 2024-01-27 15:27:17 | lighted | 3 | 134027 | 359 | 7.016 | 19103.1 |
| 910 | 2024-01-27 08:13:51 | lighted | 2 | 107671 | 51 | 4.080 | 26390.0 |
| 909 | 2024-01-27 08:13:31 | lighted | 3 | 134027 | 359 | 6.766 | 19808.9 |
| 908 | 2023-12-30 04:20:20 | lighted | 3 | 134027 | 359 | 6.220 | 21547.7 |
| 907 | 2023-12-30 04:20:23 | lighted | 2 | 107671 | 51 | 3.160 | 34073.1 |
| 906 | 2023-12-26 05:53:44 | lighted | 2 | 107671 | 51 | 2.876 | 37437.8 |
| 905 | 2023-12-25 20:09:42 | lighted | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 904 | 2023-12-17 19:30:16 | lighted | 3 | 134027 | 359 | 6.390 | 20974.5 |
| 903 | 2023-12-13 11:45:49 | lighted | 1 | 69583 | 15 | 1.156 | 60192.9 |
| 902 | 2023-12-06 06:33:20 | lighted | 1 | 69583 | 15 | 1.186 | 58670.3 |
| 901 | 2023-12-02 22:15:46 | lighted | 1 | 69583 | 15 | 1.220 | 57035.2 |
| 900 | 2023-11-28 14:05:50 | lighted | 3 | 134027 | 359 | 6.466 | 20728.0 |
| 899 | 2023-11-18 20:27:51 | lighted | 1 | 69583 | 15 | 1.203 | 57841.2 |
| 898 | 2023-11-14 00:47:04 | lighted | 1 | 69583 | 15 | 1.236 | 56296.9 |
| 897 | 2023-11-08 17:03:37 | lighted | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 896 | 2023-11-04 04:17:40 | lighted | 1 | 69583 | 15 | 1.080 | 64428.7 |
| 895 | 2023-10-26 12:40:27 | lighted | 1 | 69583 | 15 | 1.080 | 64428.7 |
| 894 | 2023-10-12 14:37:00 | lighted | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 893 | 2023-09-28 03:28:03 | lighted | 2 | 107671 | 51 | 3.156 | 34116.3 |
| 892 | 2023-09-16 08:33:43 | lighted | 1 | 69583 | 15 | 2.546 | 27330.3 |
| 891 | 2023-08-27 06:52:58 | lighted | 3 | 134027 | 359 | 5.533 | 24223.2 |
| 890 | 2023-08-17 16:58:55 | lighted | 3 | 134027 | 359 | 5.563 | 24092.6 |
| 889 | 2023-08-17 04:26:42 | lighted | 1 | 69583 | 15 | 1.173 | 59320.5 |
| 888 | 2023-08-13 20:57:00 | lighted | 1 | 69583 | 15 | 1.153 | 60349.5 |
| 887 | 2023-08-08 22:51:09 | lighted | 1 | 69583 | 15 | 1.060 | 65644.3 |
| 886 | 2023-07-23 18:16:30 | lighted | 3 | 134027 | 359 | 5.470 | 24502.2 |
| 885 | 2023-07-10 17:13:15 | lighted | 2 | 107671 | 51 | 2.750 | 39153.1 |
| 884 | 2023-05-13 13:24:59 | lighted | 3 | 134027 | 359 | 5.673 | 23625.4 |
| 883 | 2023-05-08 22:48:56 | lighted | 1 | 69583 | 15 | 1.140 | 61037.7 |
| 882 | 2023-05-06 15:35:28 | lighted | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 881 | 2023-03-27 11:30:31 | lighted | 2 | 107671 | 51 | 4.690 | 22957.6 |
| 880 | 2023-03-08 02:25:18 | lighted | 3 | 134027 | 359 | 5.500 | 24368.5 |
| 879 | 2023-03-05 14:37:28 | lighted | 1 | 69583 | 15 | 1.050 | 66269.5 |
| 878 | 2023-03-04 19:18:15 | lighted | 3 | 134027 | 359 | 5.550 | 24149.0 |
| 877 | 2023-02-19 16:36:40 | lighted | 3 | 134027 | 359 | 5.436 | 24655.4 |
| 876 | 2023-01-20 14:51:11 | lighted | 1 | 69583 | 15 | 1.143 | 60877.5 |
| 875 | 2022-12-27 15:22:30 | lighted | 1 | 69583 | 15 | 1.030 | 67556.3 |
| 874 | 2022-12-24 01:50:36 | lighted | 2 | 107671 | 51 | 3.126 | 34443.7 |
| 873 | 2022-11-30 12:26:10 | lighted | 3 | 134027 | 359 | 5.483 | 24444.1 |
| 872 | 2022-09-30 09:25:27 | lighted | 3 | 134027 | 359 | 5.516 | 24297.9 |
| 871 | 2022-09-29 04:33:03 | lighted | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 870 | 2022-09-26 18:40:40 | lighted | 3 | 134027 | 359 | 5.580 | 24019.2 |
| 869 | 2022-09-19 21:34:10 | lighted | 1 | 69583 | 15 | 1.156 | 60192.9 |
| 868 | 2022-09-15 12:48:50 | lighted | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 867 | 2022-08-31 22:01:14 | lighted | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 866 | 2022-08-23 18:11:11 | lighted | 2 | 107671 | 51 | 2.780 | 38730.6 |
| 865 | 2022-08-14 19:49:51 | lighted | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 864 | 2022-07-29 04:00:55 | lighted | 1 | 69583 | 15 | 1.123 | 61961.7 |
| 863 | 2022-07-10 10:12:54 | lighted | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 862 | 2022-07-08 00:04:19 | lighted | 3 | 134027 | 359 | 5.500 | 24368.5 |
| 861 | 2022-07-03 03:27:05 | lighted | 1 | 69583 | 15 | 1.080 | 64428.7 |
| 860 | 2022-07-02 19:35:34 | lighted | 1 | 69583 | 15 | 1.153 | 60349.5 |
| 859 | 2022-06-15 21:48:10 | lighted | 1 | 69583 | 15 | 1.186 | 58670.3 |
| 858 | 2022-06-12 05:06:13 | lighted | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 857 | 2022-04-25 18:03:50 | lighted | 3 | 134027 | 359 | 6.796 | 19721.5 |
| 856 | 2022-03-08 00:14:34 | lighted | 1 | 69583 | 15 | 1.343 | 51811.6 |
| 855 | 2022-02-25 03:18:14 | lighted | 1 | 69583 | 15 | 1.330 | 52318.0 |
| 854 | 2022-02-16 01:50:38 | lighted | 3 | 134027 | 359 | 6.296 | 21287.6 |
| 853 | 2022-02-15 18:19:50 | lighted | 3 | 134027 | 359 | 5.780 | 23188.1 |
| 852 | 2022-02-13 05:30:49 | lighted | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 851 | 2022-02-08 19:58:21 | lighted | 3 | 134027 | 359 | 5.763 | 23256.5 |
| 850 | 2022-02-06 21:38:08 | lighted | 1 | 69583 | 15 | 1.296 | 53690.6 |
| 849 | 2022-02-06 10:26:04 | lighted | 1 | 69583 | 15 | 1.076 | 64668.2 |
| 848 | 2022-02-05 21:32:30 | lighted | 1 | 69583 | 15 | 1.250 | 55666.4 |
| 847 | 2022-02-05 14:57:33 | lighted | 1 | 69583 | 15 | 1.250 | 55666.4 |
| 846 | 2022-02-04 22:56:11 | lighted | 1 | 69583 | 15 | 1.203 | 57841.2 |
| 845 | 2022-02-04 22:32:38 | lighted | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 844 | 2022-02-04 11:14:44 | lighted | 1 | 69583 | 15 | 1.296 | 53690.6 |
| 843 | 2022-02-03 21:01:53 | lighted | 1 | 69583 | 15 | 1.250 | 55666.4 |
| 842 | 2022-02-03 18:41:30 | lighted | 1 | 69583 | 15 | 1.090 | 63837.6 |
| 841 | 2022-02-03 10:53:56 | lighted | 1 | 69583 | 15 | 1.156 | 60192.9 |
| 840 | 2022-02-03 02:19:56 | lighted | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 839 | 2022-02-02 19:14:25 | lighted | 1 | 69583 | 15 | 1.186 | 58670.3 |
| 838 | 2022-02-02 18:48:43 | lighted | 1 | 69583 | 15 | 1.043 | 66714.3 |
| 837 | 2022-02-02 03:06:54 | lighted | 1 | 69583 | 15 | 1.220 | 57035.2 |
| 836 | 2022-02-01 17:22:37 | lighted | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 835 | 2022-02-01 14:20:01 | lighted | 1 | 69583 | 15 | 1.233 | 56433.9 |
| 834 | 2022-02-01 03:18:37 | lighted | 1 | 69583 | 15 | 1.283 | 54234.6 |
| 833 | 2022-01-31 17:35:32 | lighted | 1 | 69583 | 15 | 1.220 | 57035.2 |