History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bistate"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1070 | 2024-04-27 16:32:46 | bistate | 1 | 69583 | 1 | 3.016 | 23071.3 |
| 1069 | 2024-03-05 23:07:17 | bistate | 3 | 134027 | 292 | 25.016 | 5357.7 |
| 1068 | 2024-03-05 02:43:37 | bistate | 3 | 134027 | 292 | 14.783 | 9066.3 |
| 1067 | 2024-03-04 21:54:51 | bistate | 3 | 134027 | 292 | 12.936 | 10360.8 |
| 1066 | 2024-03-04 12:46:02 | bistate | 3 | 134027 | 292 | 18.720 | 7159.6 |
| 1065 | 2024-03-03 18:59:01 | bistate | 3 | 134027 | 292 | 16.656 | 8046.8 |
| 1064 | 2024-03-03 08:18:18 | bistate | 3 | 134027 | 292 | 14.250 | 9405.4 |
| 1063 | 2024-03-03 08:18:18 | bistate | 2 | 107671 | 29 | 6.156 | 17490.4 |
| 1062 | 2024-03-03 08:10:03 | bistate | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 1061 | 2024-02-28 16:50:30 | bistate | 1 | 69583 | 1 | 3.716 | 18725.2 |
| 1060 | 2024-02-23 14:55:02 | bistate | 1 | 69583 | 1 | 4.050 | 17181.0 |
| 1059 | 2024-02-23 14:53:44 | bistate | 1 | 69583 | 1 | 2.156 | 32274.1 |
| 1058 | 2024-02-17 23:40:17 | bistate | 1 | 69583 | 1 | 4.156 | 16742.8 |
| 1057 | 2024-01-18 19:48:36 | bistate | 2 | 107671 | 29 | 3.263 | 32997.5 |
| 1056 | 2024-01-09 02:49:48 | bistate | 3 | 134027 | 292 | 8.703 | 15400.1 |
| 1055 | 2024-01-09 02:49:46 | bistate | 2 | 107671 | 29 | 3.313 | 32499.5 |
| 1054 | 2023-12-28 01:16:52 | bistate | 2 | 107671 | 29 | 3.453 | 31181.9 |
| 1053 | 2023-12-19 22:23:29 | bistate | 3 | 134027 | 292 | 7.390 | 18136.3 |
| 1052 | 2023-12-16 08:22:41 | bistate | 3 | 134027 | 292 | 6.143 | 21817.8 |
| 1051 | 2023-12-16 08:22:42 | bistate | 2 | 107671 | 29 | 3.156 | 34116.3 |
| 1050 | 2023-12-11 11:38:08 | bistate | 3 | 134027 | 292 | 7.343 | 18252.3 |
| 1049 | 2023-12-07 15:37:31 | bistate | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 1048 | 2023-11-14 20:38:30 | bistate | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 1047 | 2023-11-12 05:12:09 | bistate | 1 | 69583 | 1 | 3.876 | 17952.3 |
| 1046 | 2023-11-07 23:02:38 | bistate | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 1045 | 2023-11-03 08:29:29 | bistate | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 1044 | 2023-10-27 21:50:16 | bistate | 2 | 107671 | 29 | 3.343 | 32207.9 |
| 1043 | 2023-10-27 00:18:30 | bistate | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 1042 | 2023-10-01 18:35:40 | bistate | 3 | 134027 | 292 | 8.123 | 16499.7 |
| 1041 | 2023-09-28 06:38:59 | bistate | 3 | 134027 | 292 | 6.796 | 19721.5 |
| 1040 | 2023-09-26 08:29:29 | bistate | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 1039 | 2023-09-21 06:23:16 | bistate | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 1038 | 2023-09-20 23:38:25 | bistate | 3 | 134027 | 292 | 6.440 | 20811.6 |
| 1037 | 2023-08-06 04:57:32 | bistate | 2 | 107671 | 29 | 2.796 | 38508.9 |
| 1036 | 2023-07-18 03:14:07 | bistate | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 1035 | 2023-07-17 04:01:21 | bistate | 3 | 134027 | 292 | 5.783 | 23176.0 |
| 1034 | 2023-07-17 01:03:32 | bistate | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 1033 | 2023-06-27 15:32:53 | bistate | 3 | 134027 | 292 | 5.703 | 23501.1 |
| 1032 | 2023-06-24 02:46:12 | bistate | 3 | 134027 | 292 | 5.986 | 22390.1 |
| 1031 | 2023-05-25 06:43:24 | bistate | 3 | 134027 | 292 | 5.766 | 23244.4 |
| 1030 | 2023-04-19 14:29:57 | bistate | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 1029 | 2023-04-11 19:30:24 | bistate | 2 | 107671 | 29 | 2.783 | 38688.8 |
| 1028 | 2023-04-10 08:39:15 | bistate | 1 | 69583 | 1 | 1.170 | 59472.6 |
| 1027 | 2023-03-24 12:11:49 | bistate | 3 | 134027 | 292 | 5.703 | 23501.1 |
| 1026 | 2023-02-19 12:52:06 | bistate | 3 | 134027 | 292 | 5.550 | 24149.0 |
| 1025 | 2023-02-10 14:44:16 | bistate | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 1024 | 2023-01-18 11:07:03 | bistate | 2 | 107671 | 29 | 2.733 | 39396.6 |
| 1023 | 2023-01-13 11:40:08 | bistate | 3 | 134027 | 292 | 5.983 | 22401.3 |
| 1022 | 2023-01-01 10:34:11 | bistate | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 1021 | 2022-12-23 05:41:48 | bistate | 3 | 134027 | 292 | 6.906 | 19407.3 |
| 1020 | 2022-12-08 01:30:45 | bistate | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 1019 | 2022-12-01 06:48:40 | bistate | 3 | 134027 | 292 | 5.750 | 23309.0 |
| 1018 | 2022-11-29 08:52:21 | bistate | 3 | 134027 | 292 | 5.623 | 23835.5 |
| 1017 | 2022-10-29 20:30:07 | bistate | 2 | 107671 | 29 | 2.720 | 39584.9 |
| 1016 | 2022-10-29 20:05:30 | bistate | 3 | 134027 | 292 | 6.513 | 20578.4 |
| 1015 | 2022-09-30 19:58:47 | bistate | 3 | 134027 | 292 | 5.986 | 22390.1 |
| 1014 | 2022-09-13 19:49:30 | bistate | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 1013 | 2022-09-10 18:00:21 | bistate | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 1012 | 2022-09-01 15:26:00 | bistate | 1 | 69583 | 1 | 1.143 | 60877.5 |
| 1011 | 2022-08-27 15:19:41 | bistate | 1 | 69583 | 1 | 1.170 | 59472.6 |
| 1010 | 2022-08-23 05:41:53 | bistate | 3 | 134027 | 292 | 5.610 | 23890.7 |
| 1009 | 2022-08-04 21:25:39 | bistate | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 1008 | 2022-07-10 16:38:55 | bistate | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 1007 | 2022-07-06 09:12:49 | bistate | 3 | 134027 | 292 | 5.640 | 23763.7 |
| 1006 | 2022-06-29 09:16:40 | bistate | 3 | 134027 | 292 | 6.453 | 20769.7 |
| 1005 | 2022-06-28 08:23:19 | bistate | 3 | 134027 | 292 | 6.500 | 20619.5 |
| 1004 | 2022-06-27 09:41:39 | bistate | 3 | 134027 | 292 | 6.093 | 21996.9 |
| 1003 | 2022-06-26 18:24:13 | bistate | 3 | 134027 | 292 | 6.580 | 20368.8 |
| 1002 | 2022-06-25 11:14:05 | bistate | 3 | 134027 | 292 | 6.546 | 20474.6 |
| 1001 | 2022-06-24 13:33:22 | bistate | 3 | 134027 | 292 | 6.283 | 21331.7 |
| 1000 | 2022-06-23 08:30:47 | bistate | 3 | 134027 | 292 | 11.393 | 11764.0 |
| 999 | 2022-06-22 08:28:50 | bistate | 3 | 134027 | 292 | 11.406 | 11750.6 |
| 998 | 2022-06-21 12:53:54 | bistate | 3 | 134027 | 292 | 6.203 | 21606.8 |
| 997 | 2022-06-20 23:50:18 | bistate | 3 | 134027 | 292 | 5.703 | 23501.1 |
| 996 | 2022-06-19 08:43:07 | bistate | 3 | 134027 | 292 | 5.656 | 23696.4 |
| 995 | 2022-06-18 13:00:34 | bistate | 3 | 134027 | 292 | 6.313 | 21230.3 |
| 994 | 2022-06-17 15:17:54 | bistate | 3 | 134027 | 292 | 5.893 | 22743.4 |
| 993 | 2022-06-16 23:08:32 | bistate | 3 | 134027 | 292 | 6.530 | 20524.8 |
| 992 | 2022-06-15 15:38:23 | bistate | 3 | 134027 | 292 | 6.390 | 20974.5 |
| 991 | 2022-06-14 05:25:48 | bistate | 3 | 134027 | 292 | 13.063 | 10260.0 |
| 990 | 2022-06-03 03:42:29 | bistate | 3 | 134027 | 292 | 5.626 | 23822.8 |
| 989 | 2022-05-29 04:03:41 | bistate | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 988 | 2022-05-27 16:35:22 | bistate | 3 | 134027 | 292 | 6.420 | 20876.5 |
| 987 | 2022-05-24 08:21:03 | bistate | 2 | 107671 | 29 | 4.983 | 21607.7 |
| 986 | 2022-05-18 09:36:30 | bistate | 3 | 134027 | 292 | 5.656 | 23696.4 |
| 985 | 2022-05-17 14:59:49 | bistate | 3 | 134027 | 292 | 7.016 | 19103.1 |
| 984 | 2022-05-16 19:12:59 | bistate | 3 | 134027 | 292 | 6.063 | 22105.7 |
| 983 | 2022-05-16 00:33:02 | bistate | 3 | 134027 | 292 | 6.173 | 21711.8 |
| 982 | 2022-05-14 17:31:23 | bistate | 3 | 134027 | 292 | 6.873 | 19500.5 |
| 981 | 2022-05-13 23:40:21 | bistate | 3 | 134027 | 292 | 6.860 | 19537.5 |
| 980 | 2022-05-11 15:02:41 | bistate | 3 | 134027 | 292 | 6.216 | 21561.6 |
| 979 | 2022-05-11 03:57:07 | bistate | 3 | 134027 | 292 | 6.670 | 20094.0 |
| 978 | 2022-05-10 22:54:39 | bistate | 3 | 134027 | 292 | 6.580 | 20368.8 |
| 977 | 2022-05-10 16:52:33 | bistate | 3 | 134027 | 292 | 7.513 | 17839.3 |
| 976 | 2022-05-10 11:09:31 | bistate | 3 | 134027 | 292 | 6.893 | 19443.9 |
| 975 | 2022-05-08 15:43:15 | bistate | 3 | 134027 | 292 | 6.610 | 20276.4 |
| 974 | 2022-05-08 01:37:26 | bistate | 3 | 134027 | 292 | 6.343 | 21129.9 |
| 973 | 2022-05-01 11:51:21 | bistate | 3 | 134027 | 292 | 9.826 | 13640.0 |
| 972 | 2022-04-30 18:25:31 | bistate | 3 | 134027 | 292 | 6.470 | 20715.1 |
| 971 | 2022-04-30 03:26:06 | bistate | 3 | 134027 | 292 | 5.690 | 23554.8 |