History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scena"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1063 | 2024-04-25 08:21:26 | scena | 3 | 83667 | 981 | 3.330 | 25125.2 |
| 1062 | 2024-04-18 15:16:12 | scena | 1 | 28756 | 5 | 0.563 | 51076.4 |
| 1061 | 2024-04-05 16:43:00 | scena | 1 | 28756 | 5 | 2.893 | 9939.9 |
| 1060 | 2024-04-04 20:01:55 | scena | 3 | 83667 | 981 | 14.686 | 5697.1 |
| 1059 | 2024-04-04 05:33:36 | scena | 3 | 83667 | 981 | 9.753 | 8578.6 |
| 1058 | 2024-04-03 07:58:11 | scena | 3 | 83667 | 981 | 9.330 | 8967.5 |
| 1057 | 2024-04-03 07:58:11 | scena | 2 | 53800 | 57 | 5.610 | 9590.0 |
| 1056 | 2024-04-03 07:24:47 | scena | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1055 | 2024-03-31 23:57:39 | scena | 2 | 53800 | 57 | 1.890 | 28465.6 |
| 1054 | 2024-03-31 16:10:09 | scena | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1053 | 2024-03-27 06:26:15 | scena | 1 | 28756 | 5 | 1.016 | 28303.1 |
| 1052 | 2024-03-22 04:44:55 | scena | 1 | 28756 | 5 | 0.936 | 30722.2 |
| 1051 | 2024-03-12 23:56:11 | scena | 1 | 28756 | 5 | 1.140 | 25224.6 |
| 1050 | 2024-03-07 01:10:19 | scena | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 1049 | 2024-03-06 12:03:02 | scena | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1048 | 2024-03-06 12:02:58 | scena | 2 | 53800 | 57 | 1.513 | 35558.5 |
| 1047 | 2024-03-06 12:02:57 | scena | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1046 | 2024-03-05 18:30:13 | scena | 3 | 83667 | 981 | 13.423 | 6233.1 |
| 1045 | 2024-03-04 04:23:53 | scena | 3 | 83667 | 981 | 8.126 | 10296.2 |
| 1044 | 2024-03-04 00:35:52 | scena | 2 | 53800 | 57 | 1.346 | 39970.3 |
| 1043 | 2024-03-04 00:35:29 | scena | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1042 | 2024-03-01 12:12:18 | scena | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 1041 | 2024-02-28 05:14:39 | scena | 3 | 83667 | 981 | 11.656 | 7178.0 |
| 1040 | 2024-02-27 16:00:07 | scena | 2 | 53800 | 57 | 1.626 | 33087.3 |
| 1039 | 2024-02-27 15:59:41 | scena | 3 | 83667 | 981 | 4.283 | 19534.7 |
| 1038 | 2024-02-25 22:14:43 | scena | 3 | 83667 | 981 | 9.516 | 8792.2 |
| 1037 | 2024-02-25 22:14:42 | scena | 2 | 53800 | 57 | 2.080 | 25865.4 |
| 1036 | 2024-02-25 19:21:56 | scena | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1035 | 2024-02-03 00:22:47 | scena | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1034 | 2024-01-31 23:01:46 | scena | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 1033 | 2024-01-28 23:32:19 | scena | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 1032 | 2024-01-25 20:42:21 | scena | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 1031 | 2024-01-25 16:41:19 | scena | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1030 | 2023-12-18 17:18:46 | scena | 3 | 83667 | 981 | 3.826 | 21868.0 |
| 1029 | 2023-12-18 17:18:39 | scena | 2 | 53800 | 57 | 1.610 | 33416.1 |
| 1028 | 2023-12-13 23:33:26 | scena | 3 | 83667 | 981 | 3.343 | 25027.5 |
| 1027 | 2023-12-05 23:26:23 | scena | 2 | 53800 | 57 | 1.436 | 37465.2 |
| 1026 | 2023-12-03 16:17:31 | scena | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1025 | 2023-12-03 16:17:30 | scena | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1024 | 2023-11-22 18:39:05 | scena | 2 | 53800 | 57 | 1.483 | 36277.8 |
| 1023 | 2023-11-22 05:06:24 | scena | 1 | 28756 | 5 | 1.123 | 25606.4 |
| 1022 | 2023-11-20 11:34:03 | scena | 3 | 83667 | 981 | 4.203 | 19906.5 |
| 1021 | 2023-11-19 12:44:38 | scena | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1020 | 2023-11-11 22:09:30 | scena | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1019 | 2023-10-30 19:12:57 | scena | 3 | 83667 | 981 | 3.826 | 21868.0 |
| 1018 | 2023-10-30 19:12:56 | scena | 2 | 53800 | 57 | 1.640 | 32804.9 |
| 1017 | 2023-10-25 23:28:15 | scena | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1016 | 2023-10-23 04:27:36 | scena | 1 | 28756 | 5 | 0.720 | 39938.9 |
| 1015 | 2023-10-22 10:00:03 | scena | 1 | 28756 | 5 | 1.190 | 24164.7 |
| 1014 | 2023-10-21 17:22:16 | scena | 3 | 83667 | 981 | 3.690 | 22674.0 |
| 1013 | 2023-10-21 17:22:15 | scena | 2 | 53800 | 57 | 1.703 | 31591.3 |
| 1012 | 2023-10-17 22:28:19 | scena | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 1011 | 2023-10-17 00:04:11 | scena | 1 | 28756 | 5 | 0.983 | 29253.3 |
| 1010 | 2023-10-08 07:32:44 | scena | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1009 | 2023-09-24 12:30:01 | scena | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1008 | 2023-09-14 07:03:17 | scena | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1007 | 2023-09-14 01:24:56 | scena | 3 | 83667 | 981 | 4.126 | 20278.0 |
| 1006 | 2023-09-08 09:18:13 | scena | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1005 | 2023-09-04 02:20:53 | scena | 2 | 53800 | 57 | 1.606 | 33499.4 |
| 1004 | 2023-07-23 21:11:10 | scena | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1003 | 2023-07-12 14:50:52 | scena | 3 | 83667 | 981 | 3.296 | 25384.4 |
| 1002 | 2023-07-09 08:40:18 | scena | 3 | 83667 | 981 | 3.690 | 22674.0 |
| 1001 | 2023-07-08 20:12:27 | scena | 3 | 83667 | 981 | 3.283 | 25484.9 |
| 1000 | 2023-07-08 14:09:53 | scena | 3 | 83667 | 981 | 3.656 | 22884.8 |
| 999 | 2023-07-07 01:02:14 | scena | 3 | 83667 | 981 | 3.546 | 23594.8 |
| 998 | 2023-07-06 07:06:54 | scena | 3 | 83667 | 981 | 4.140 | 20209.4 |
| 997 | 2023-07-04 16:47:13 | scena | 3 | 83667 | 981 | 6.796 | 12311.2 |
| 996 | 2023-07-04 01:54:28 | scena | 3 | 83667 | 981 | 3.330 | 25125.2 |
| 995 | 2023-07-03 03:40:13 | scena | 3 | 83667 | 981 | 3.296 | 25384.4 |
| 994 | 2023-07-02 10:55:17 | scena | 3 | 83667 | 981 | 3.330 | 25125.2 |
| 993 | 2023-07-01 16:27:44 | scena | 3 | 83667 | 981 | 3.796 | 22040.8 |
| 992 | 2023-06-30 23:07:56 | scena | 3 | 83667 | 981 | 4.000 | 20916.8 |
| 991 | 2023-06-30 03:52:05 | scena | 3 | 83667 | 981 | 3.873 | 21602.6 |
| 990 | 2023-06-29 14:09:57 | scena | 3 | 83667 | 981 | 3.796 | 22040.8 |
| 989 | 2023-06-28 21:17:06 | scena | 3 | 83667 | 981 | 3.343 | 25027.5 |
| 988 | 2023-06-28 00:11:44 | scena | 3 | 83667 | 981 | 3.843 | 21771.3 |
| 987 | 2023-06-27 05:10:47 | scena | 3 | 83667 | 981 | 3.830 | 21845.2 |
| 986 | 2023-06-26 15:46:32 | scena | 3 | 83667 | 981 | 3.393 | 24658.7 |
| 985 | 2023-06-26 12:30:43 | scena | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 984 | 2023-06-25 18:41:17 | scena | 3 | 83667 | 981 | 3.343 | 25027.5 |
| 983 | 2023-06-24 23:14:11 | scena | 3 | 83667 | 981 | 3.453 | 24230.2 |
| 982 | 2023-06-24 03:44:46 | scena | 3 | 83667 | 981 | 3.296 | 25384.4 |
| 981 | 2023-06-23 14:46:49 | scena | 3 | 83667 | 981 | 3.300 | 25353.6 |
| 980 | 2023-06-22 15:12:03 | scena | 3 | 83667 | 981 | 3.673 | 22778.9 |
| 979 | 2023-06-21 20:53:55 | scena | 3 | 83667 | 981 | 3.936 | 21256.9 |
| 978 | 2023-06-21 02:47:43 | scena | 3 | 83667 | 981 | 3.623 | 23093.3 |
| 977 | 2023-06-20 15:44:07 | scena | 3 | 83667 | 981 | 3.313 | 25254.2 |
| 976 | 2023-06-20 12:05:11 | scena | 3 | 83667 | 981 | 3.373 | 24804.9 |
| 975 | 2023-06-19 17:36:49 | scena | 3 | 83667 | 981 | 3.440 | 24321.8 |
| 974 | 2023-06-19 02:57:16 | scena | 3 | 83667 | 981 | 3.966 | 21096.1 |
| 973 | 2023-06-18 06:03:20 | scena | 3 | 83667 | 981 | 3.250 | 25743.7 |
| 972 | 2023-06-17 15:50:09 | scena | 3 | 83667 | 981 | 3.390 | 24680.5 |
| 971 | 2023-06-16 20:43:29 | scena | 3 | 83667 | 981 | 4.110 | 20356.9 |
| 970 | 2023-06-16 02:57:52 | scena | 3 | 83667 | 981 | 3.656 | 22884.8 |
| 969 | 2023-06-15 08:09:11 | scena | 3 | 83667 | 981 | 3.326 | 25155.4 |
| 968 | 2023-06-15 05:26:16 | scena | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 967 | 2023-06-14 20:25:36 | scena | 3 | 83667 | 981 | 3.250 | 25743.7 |
| 966 | 2023-06-14 12:34:55 | scena | 3 | 83667 | 981 | 3.233 | 25879.1 |
| 965 | 2023-06-13 04:30:47 | scena | 3 | 83667 | 981 | 3.326 | 25155.4 |
| 964 | 2023-06-12 12:35:15 | scena | 3 | 83667 | 981 | 3.313 | 25254.2 |