History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loss"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1071 | 2024-04-27 12:22:15 | loss | 1 | 13983 | 24 | 0.360 | 38841.7 |
| 1070 | 2024-04-12 19:17:53 | loss | 1 | 13983 | 24 | 0.563 | 24836.6 |
| 1069 | 2024-04-12 06:14:41 | loss | 1 | 13983 | 24 | 0.750 | 18644.0 |
| 1068 | 2024-04-12 06:13:03 | loss | 1 | 13983 | 24 | 1.280 | 10924.2 |
| 1067 | 2024-04-09 22:32:58 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1066 | 2024-04-05 01:36:45 | loss | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 1065 | 2024-04-02 23:45:11 | loss | 1 | 13983 | 24 | 0.860 | 16259.3 |
| 1064 | 2024-03-26 21:31:06 | loss | 1 | 13983 | 24 | 0.596 | 23461.4 |
| 1063 | 2024-03-12 19:31:04 | loss | 1 | 13983 | 24 | 0.326 | 42892.6 |
| 1062 | 2024-03-12 19:30:40 | loss | 2 | 29872 | 458 | 1.983 | 15064.0 |
| 1061 | 2024-03-12 19:30:31 | loss | 1 | 13983 | 24 | 0.283 | 49409.9 |
| 1060 | 2024-03-05 20:59:04 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1059 | 2024-03-03 20:40:44 | loss | 1 | 13983 | 24 | 0.263 | 53167.3 |
| 1058 | 2024-02-25 16:12:50 | loss | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 1057 | 2024-02-13 15:00:33 | loss | 2 | 29872 | 458 | 3.030 | 9858.7 |
| 1056 | 2024-02-11 18:17:44 | loss | 1 | 13983 | 24 | 0.280 | 49939.3 |
| 1055 | 2024-02-03 01:33:34 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1054 | 2024-02-02 17:25:19 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1053 | 2024-01-30 01:46:42 | loss | 2 | 29872 | 458 | 0.983 | 30388.6 |
| 1052 | 2024-01-25 19:42:45 | loss | 1 | 13983 | 24 | 0.263 | 53167.3 |
| 1051 | 2024-01-20 10:12:12 | loss | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 1050 | 2024-01-08 04:10:57 | loss | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 1049 | 2024-01-08 00:46:14 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1048 | 2023-12-31 19:40:48 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1047 | 2023-12-20 09:01:55 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1046 | 2023-12-04 05:38:54 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1045 | 2023-12-04 05:38:53 | loss | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 1044 | 2023-12-01 14:21:16 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1043 | 2023-11-23 00:56:48 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1042 | 2023-11-15 02:40:10 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1041 | 2023-11-14 13:23:27 | loss | 2 | 29872 | 458 | 0.766 | 38997.4 |
| 1040 | 2023-11-14 04:21:35 | loss | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 1039 | 2023-11-13 14:24:58 | loss | 2 | 29872 | 458 | 0.750 | 39829.3 |
| 1038 | 2023-11-09 11:27:30 | loss | 2 | 29872 | 458 | 1.030 | 29001.9 |
| 1037 | 2023-11-09 06:01:00 | loss | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 1036 | 2023-11-07 22:01:52 | loss | 2 | 29872 | 458 | 0.920 | 32469.6 |
| 1035 | 2023-10-27 08:46:14 | loss | 2 | 29872 | 458 | 0.750 | 39829.3 |
| 1034 | 2023-10-26 18:47:22 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1033 | 2023-10-20 05:06:16 | loss | 1 | 13983 | 24 | 0.563 | 24836.6 |
| 1032 | 2023-10-19 20:12:54 | loss | 1 | 13983 | 24 | 0.436 | 32071.1 |
| 1031 | 2023-10-17 07:07:13 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1030 | 2023-10-13 08:56:07 | loss | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 1029 | 2023-10-04 00:40:31 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1028 | 2023-09-22 18:57:50 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1027 | 2023-08-14 06:59:52 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1026 | 2023-08-11 23:59:05 | loss | 2 | 29872 | 458 | 0.843 | 35435.3 |
| 1025 | 2023-08-09 00:40:33 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1024 | 2023-05-16 09:48:28 | loss | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 1023 | 2023-04-24 02:47:35 | loss | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 1022 | 2023-04-23 13:40:42 | loss | 2 | 29872 | 458 | 0.750 | 39829.3 |
| 1021 | 2023-03-10 01:16:43 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1020 | 2023-01-28 10:02:56 | loss | 2 | 29872 | 458 | 0.736 | 40587.0 |
| 1019 | 2023-01-19 04:11:10 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1018 | 2023-01-03 08:49:17 | loss | 2 | 29872 | 458 | 0.733 | 40753.1 |
| 1017 | 2022-12-31 10:28:45 | loss | 1 | 13983 | 24 | 0.253 | 55268.8 |
| 1016 | 2022-12-09 20:23:07 | loss | 2 | 29872 | 458 | 0.766 | 38997.4 |
| 1015 | 2022-11-10 10:14:43 | loss | 2 | 29872 | 458 | 0.830 | 35990.4 |
| 1014 | 2022-10-05 01:19:26 | loss | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 1013 | 2022-09-21 22:36:07 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1012 | 2022-09-19 22:18:46 | loss | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 1011 | 2022-09-18 16:27:56 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1010 | 2022-08-14 06:14:07 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1009 | 2022-08-05 22:43:41 | loss | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 1008 | 2022-07-30 06:15:31 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1007 | 2022-07-17 22:40:29 | loss | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 1006 | 2022-07-10 05:19:16 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1005 | 2022-06-18 04:16:24 | loss | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 1004 | 2022-06-09 08:10:26 | loss | 2 | 29872 | 458 | 0.750 | 39829.3 |
| 1003 | 2022-05-03 06:26:05 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1002 | 2022-04-08 04:20:16 | loss | 1 | 13983 | 24 | 0.343 | 40766.8 |
| 1001 | 2022-04-07 15:50:36 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1000 | 2022-04-06 06:51:46 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 999 | 2022-04-05 19:45:34 | loss | 1 | 13983 | 24 | 0.313 | 44674.1 |
| 998 | 2022-04-05 00:08:06 | loss | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 997 | 2022-04-04 11:40:45 | loss | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 996 | 2022-04-03 13:29:19 | loss | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 995 | 2022-04-02 17:35:47 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 994 | 2022-04-01 17:49:59 | loss | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 993 | 2022-04-01 02:13:51 | loss | 1 | 13983 | 24 | 0.283 | 49409.9 |
| 992 | 2022-03-25 11:15:42 | loss | 1 | 13983 | 24 | 0.266 | 52567.7 |
| 991 | 2022-03-24 14:45:19 | loss | 1 | 13983 | 24 | 0.296 | 47239.9 |
| 990 | 2022-03-23 14:52:47 | loss | 1 | 13983 | 24 | 0.280 | 49939.3 |
| 989 | 2022-03-23 02:18:02 | loss | 1 | 13983 | 24 | 0.266 | 52567.7 |
| 988 | 2022-03-02 16:24:31 | loss | 1 | 13983 | 24 | 0.263 | 53167.3 |
| 987 | 2022-01-28 21:56:12 | loss | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 986 | 2022-01-28 08:22:33 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 985 | 2022-01-27 14:43:44 | loss | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 984 | 2022-01-26 23:33:42 | loss | 1 | 13983 | 24 | 0.263 | 53167.3 |
| 983 | 2022-01-26 13:30:56 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 982 | 2022-01-26 01:30:55 | loss | 1 | 13983 | 24 | 0.283 | 49409.9 |
| 981 | 2022-01-25 09:34:37 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 980 | 2022-01-24 18:57:38 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 979 | 2022-01-24 10:01:59 | loss | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 978 | 2022-01-23 23:37:51 | loss | 1 | 13983 | 24 | 0.266 | 52567.7 |
| 977 | 2022-01-22 06:16:13 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 976 | 2022-01-01 03:10:52 | loss | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 975 | 2021-12-31 16:27:40 | loss | 1 | 13983 | 24 | 0.266 | 52567.7 |
| 974 | 2021-12-30 22:29:46 | loss | 1 | 13983 | 24 | 0.266 | 52567.7 |
| 973 | 2021-12-30 04:20:02 | loss | 1 | 13983 | 24 | 0.266 | 52567.7 |
| 972 | 2021-12-29 18:47:27 | loss | 1 | 13983 | 24 | 0.263 | 53167.3 |