History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"selects"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1053 | 2025-04-20 04:42:43 | selects | 1 | 69583 | 3 | 9.173 | 7585.6 |
| 1052 | 2025-04-10 23:10:07 | selects | 1 | 69583 | 3 | 6.716 | 10360.8 |
| 1051 | 2025-04-06 03:23:22 | selects | 1 | 69583 | 3 | 9.390 | 7410.3 |
| 1050 | 2025-03-29 18:00:02 | selects | 1 | 69583 | 3 | 8.906 | 7813.0 |
| 1049 | 2025-03-29 13:10:56 | selects | 1 | 69583 | 3 | 8.890 | 7827.1 |
| 1048 | 2025-03-21 17:34:41 | selects | 3 | 134027 | 403 | 35.016 | 3827.6 |
| 1047 | 2025-03-21 17:03:45 | selects | 2 | 107671 | 36 | 21.596 | 4985.7 |
| 1046 | 2025-03-10 19:18:02 | selects | 1 | 69583 | 3 | 5.423 | 12831.1 |
| 1045 | 2025-03-06 20:04:37 | selects | 1 | 69583 | 3 | 3.326 | 20920.9 |
| 1044 | 2025-02-27 19:39:59 | selects | 3 | 134027 | 403 | 51.643 | 2595.3 |
| 1043 | 2025-02-27 09:31:10 | selects | 3 | 134027 | 403 | 6.626 | 20227.4 |
| 1042 | 2025-02-26 11:46:03 | selects | 1 | 69583 | 3 | 4.830 | 14406.4 |
| 1041 | 2025-02-26 07:27:27 | selects | 3 | 134027 | 403 | 42.860 | 3127.1 |
| 1040 | 2025-02-26 02:03:49 | selects | 3 | 134027 | 403 | 31.326 | 4278.5 |
| 1039 | 2025-02-25 22:36:02 | selects | 3 | 134027 | 403 | 18.236 | 7349.6 |
| 1038 | 2025-02-25 22:35:59 | selects | 2 | 107671 | 36 | 12.156 | 8857.4 |
| 1037 | 2025-02-25 20:41:14 | selects | 1 | 69583 | 3 | 3.000 | 23194.3 |
| 1036 | 2025-02-15 23:36:12 | selects | 1 | 69583 | 3 | 6.593 | 10554.1 |
| 1035 | 2025-02-07 13:20:22 | selects | 1 | 69583 | 3 | 3.623 | 19205.9 |
| 1034 | 2025-01-27 11:38:43 | selects | 1 | 69583 | 3 | 5.653 | 12309.0 |
| 1033 | 2025-01-25 19:54:38 | selects | 1 | 69583 | 3 | 6.123 | 11364.2 |
| 1032 | 2025-01-19 10:06:35 | selects | 1 | 69583 | 3 | 3.190 | 21812.9 |
| 1031 | 2025-01-15 17:38:24 | selects | 1 | 69583 | 3 | 6.080 | 11444.6 |
| 1030 | 2025-01-13 07:24:04 | selects | 3 | 134027 | 403 | 44.830 | 2989.7 |
| 1029 | 2025-01-10 03:56:40 | selects | 3 | 134027 | 403 | 29.173 | 4594.2 |
| 1028 | 2025-01-10 02:45:19 | selects | 3 | 134027 | 403 | 39.283 | 3411.8 |
| 1027 | 2025-01-09 20:44:19 | selects | 3 | 134027 | 403 | 17.283 | 7754.8 |
| 1026 | 2025-01-09 20:02:54 | selects | 3 | 134027 | 403 | 6.593 | 20328.7 |
| 1025 | 2024-12-26 13:13:04 | selects | 1 | 69583 | 3 | 4.690 | 14836.5 |
| 1024 | 2024-12-25 02:28:48 | selects | 3 | 134027 | 403 | 20.813 | 6439.6 |
| 1023 | 2024-12-18 21:13:04 | selects | 1 | 69583 | 3 | 8.906 | 7813.0 |
| 1022 | 2024-12-13 19:05:50 | selects | 1 | 69583 | 3 | 5.966 | 11663.3 |
| 1021 | 2024-12-07 00:51:38 | selects | 3 | 134027 | 403 | 40.406 | 3317.0 |
| 1020 | 2024-12-06 21:33:37 | selects | 3 | 134027 | 403 | 10.640 | 12596.5 |
| 1019 | 2024-12-06 16:54:53 | selects | 3 | 134027 | 403 | 6.063 | 22105.7 |
| 1018 | 2024-11-25 15:24:11 | selects | 1 | 69583 | 3 | 6.516 | 10678.8 |
| 1017 | 2024-11-18 01:57:28 | selects | 1 | 69583 | 3 | 6.546 | 10629.9 |
| 1016 | 2024-11-11 04:27:33 | selects | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 1015 | 2024-10-27 08:10:28 | selects | 3 | 134027 | 403 | 33.893 | 3954.4 |
| 1014 | 2024-10-27 03:36:59 | selects | 3 | 134027 | 403 | 29.483 | 4545.9 |
| 1013 | 2024-10-26 23:31:57 | selects | 3 | 134027 | 403 | 39.456 | 3396.9 |
| 1012 | 2024-10-26 22:19:39 | selects | 3 | 134027 | 403 | 50.550 | 2651.4 |
| 1011 | 2024-10-26 22:18:51 | selects | 2 | 107671 | 36 | 8.296 | 12978.7 |
| 1010 | 2024-10-22 19:44:20 | selects | 2 | 107671 | 36 | 10.610 | 10148.1 |
| 1009 | 2024-10-20 22:06:26 | selects | 1 | 69583 | 3 | 4.033 | 17253.4 |
| 1008 | 2024-10-20 19:55:37 | selects | 1 | 69583 | 3 | 3.063 | 22717.3 |
| 1007 | 2024-10-18 19:01:54 | selects | 1 | 69583 | 3 | 3.013 | 23094.3 |
| 1006 | 2024-10-15 18:35:15 | selects | 2 | 107671 | 36 | 4.250 | 25334.4 |
| 1005 | 2024-10-15 18:35:04 | selects | 1 | 69583 | 3 | 4.890 | 14229.7 |
| 1004 | 2024-10-15 04:30:11 | selects | 3 | 134027 | 403 | 22.486 | 5960.5 |
| 1003 | 2024-09-25 23:51:56 | selects | 3 | 134027 | 403 | 67.503 | 1985.5 |
| 1002 | 2024-09-25 03:56:31 | selects | 2 | 107671 | 36 | 27.253 | 3950.8 |
| 1001 | 2024-09-23 21:31:59 | selects | 3 | 134027 | 403 | 9.983 | 13425.5 |
| 1000 | 2024-09-23 21:28:21 | selects | 3 | 134027 | 403 | 28.986 | 4623.9 |
| 999 | 2024-09-23 17:54:28 | selects | 3 | 134027 | 403 | 66.146 | 2026.2 |
| 998 | 2024-09-23 17:54:27 | selects | 2 | 107671 | 36 | 25.393 | 4240.2 |
| 997 | 2024-09-19 21:15:11 | selects | 1 | 69583 | 3 | 12.873 | 5405.3 |
| 996 | 2024-09-13 18:24:34 | selects | 1 | 69583 | 3 | 9.783 | 7112.6 |
| 995 | 2024-09-09 18:49:17 | selects | 1 | 69583 | 3 | 5.826 | 11943.5 |
| 994 | 2024-09-09 16:18:44 | selects | 1 | 69583 | 3 | 8.086 | 8605.4 |
| 993 | 2024-09-04 13:54:54 | selects | 1 | 69583 | 3 | 17.410 | 3996.7 |
| 992 | 2024-08-23 20:43:13 | selects | 3 | 134027 | 403 | 57.286 | 2339.6 |
| 991 | 2024-08-22 07:19:04 | selects | 1 | 69583 | 3 | 11.626 | 5985.1 |
| 990 | 2024-08-21 06:27:27 | selects | 3 | 134027 | 403 | 45.686 | 2933.7 |
| 989 | 2024-08-18 03:10:50 | selects | 3 | 134027 | 403 | 35.953 | 3727.8 |
| 988 | 2024-08-17 04:48:26 | selects | 3 | 134027 | 403 | 52.600 | 2548.0 |
| 987 | 2024-08-17 03:43:00 | selects | 1 | 69583 | 3 | 12.500 | 5566.6 |
| 986 | 2024-08-17 01:41:13 | selects | 3 | 134027 | 403 | 38.830 | 3451.6 |
| 985 | 2024-08-16 02:43:31 | selects | 3 | 134027 | 403 | 32.740 | 4093.7 |
| 984 | 2024-08-15 19:52:33 | selects | 3 | 134027 | 403 | 41.876 | 3200.6 |
| 983 | 2024-08-12 15:01:41 | selects | 1 | 69583 | 3 | 10.580 | 6576.8 |
| 982 | 2024-08-09 23:04:09 | selects | 1 | 69583 | 3 | 4.533 | 15350.3 |
| 981 | 2024-08-01 00:32:15 | selects | 1 | 69583 | 3 | 2.313 | 30083.4 |
| 980 | 2024-07-30 10:31:49 | selects | 1 | 69583 | 3 | 1.920 | 36241.1 |
| 979 | 2024-07-29 00:48:33 | selects | 1 | 69583 | 3 | 6.360 | 10940.7 |
| 978 | 2024-07-13 20:16:03 | selects | 2 | 107671 | 36 | 6.343 | 16974.8 |
| 977 | 2024-07-13 13:05:07 | selects | 2 | 107671 | 36 | 19.173 | 5615.8 |
| 976 | 2024-07-13 12:17:22 | selects | 2 | 107671 | 36 | 11.736 | 9174.4 |
| 975 | 2024-07-13 12:17:17 | selects | 1 | 69583 | 3 | 1.940 | 35867.5 |
| 974 | 2024-07-11 21:00:00 | selects | 3 | 134027 | 403 | 25.660 | 5223.2 |
| 973 | 2024-07-11 08:39:33 | selects | 3 | 134027 | 403 | 30.546 | 4387.7 |
| 972 | 2024-07-10 08:39:55 | selects | 3 | 134027 | 403 | 26.126 | 5130.0 |
| 971 | 2024-07-10 01:47:22 | selects | 3 | 134027 | 403 | 26.266 | 5102.7 |
| 970 | 2024-07-10 00:58:32 | selects | 3 | 134027 | 403 | 35.173 | 3810.5 |
| 969 | 2024-07-07 10:50:14 | selects | 3 | 134027 | 403 | 19.013 | 7049.2 |
| 968 | 2024-07-07 10:36:51 | selects | 1 | 69583 | 3 | 6.453 | 10783.0 |
| 967 | 2024-07-05 18:20:16 | selects | 3 | 134027 | 403 | 37.580 | 3566.4 |
| 966 | 2024-07-02 02:51:19 | selects | 1 | 69583 | 3 | 4.046 | 17198.0 |
| 965 | 2024-07-01 16:36:42 | selects | 1 | 69583 | 3 | 5.000 | 13916.6 |
| 964 | 2024-06-29 16:28:23 | selects | 1 | 69583 | 3 | 2.280 | 30518.9 |
| 963 | 2024-06-28 23:30:57 | selects | 1 | 69583 | 3 | 5.173 | 13451.2 |
| 962 | 2024-06-26 18:43:27 | selects | 1 | 69583 | 3 | 6.336 | 10982.2 |
| 961 | 2024-06-23 17:07:58 | selects | 1 | 69583 | 3 | 4.670 | 14900.0 |
| 960 | 2024-06-17 23:52:26 | selects | 3 | 134027 | 403 | 27.393 | 4892.7 |
| 959 | 2024-06-04 22:13:28 | selects | 3 | 134027 | 403 | 36.050 | 3717.8 |
| 958 | 2024-05-31 12:19:43 | selects | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 957 | 2024-05-30 04:38:53 | selects | 3 | 134027 | 403 | 26.520 | 5053.8 |
| 956 | 2024-05-30 04:05:31 | selects | 3 | 134027 | 403 | 8.046 | 16657.6 |
| 955 | 2024-05-30 01:29:15 | selects | 1 | 69583 | 3 | 6.716 | 10360.8 |
| 954 | 2024-05-29 02:54:26 | selects | 3 | 134027 | 403 | 25.563 | 5243.0 |