History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"inserts"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1093 | 2024-05-05 16:46:19 | inserts | 1 | 69583 | 6 | 1.296 | 53690.6 |
| 1092 | 2024-05-05 11:48:53 | inserts | 3 | 134027 | 355 | 10.673 | 12557.6 |
| 1091 | 2024-05-04 17:40:12 | inserts | 2 | 107671 | 49 | 3.406 | 31612.2 |
| 1090 | 2024-05-04 16:10:22 | inserts | 2 | 107671 | 49 | 10.250 | 10504.5 |
| 1089 | 2024-05-04 15:41:27 | inserts | 3 | 134027 | 355 | 7.000 | 19146.7 |
| 1088 | 2024-05-04 15:35:42 | inserts | 3 | 134027 | 355 | 7.110 | 18850.5 |
| 1087 | 2024-05-02 10:31:19 | inserts | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 1086 | 2024-05-01 19:02:26 | inserts | 3 | 134027 | 355 | 10.530 | 12728.1 |
| 1085 | 2024-05-01 14:50:29 | inserts | 3 | 134027 | 355 | 20.110 | 6664.7 |
| 1084 | 2024-04-28 10:52:41 | inserts | 2 | 107671 | 49 | 7.503 | 14350.4 |
| 1083 | 2024-04-28 10:44:45 | inserts | 3 | 134027 | 355 | 7.783 | 17220.5 |
| 1082 | 2024-04-28 04:19:41 | inserts | 3 | 134027 | 355 | 7.233 | 18529.9 |
| 1081 | 2024-04-19 07:58:24 | inserts | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 1080 | 2024-03-31 22:54:05 | inserts | 2 | 107671 | 49 | 5.486 | 19626.5 |
| 1079 | 2024-03-31 21:01:18 | inserts | 2 | 107671 | 49 | 7.860 | 13698.6 |
| 1078 | 2024-03-30 04:55:55 | inserts | 1 | 69583 | 6 | 2.423 | 28717.7 |
| 1077 | 2024-03-29 02:17:01 | inserts | 1 | 69583 | 6 | 2.173 | 32021.6 |
| 1076 | 2024-03-22 16:31:37 | inserts | 1 | 69583 | 6 | 2.733 | 25460.3 |
| 1075 | 2024-03-10 13:01:39 | inserts | 3 | 134027 | 355 | 22.720 | 5899.1 |
| 1074 | 2024-03-09 20:49:46 | inserts | 2 | 107671 | 49 | 8.390 | 12833.3 |
| 1073 | 2024-03-09 20:37:33 | inserts | 1 | 69583 | 6 | 1.283 | 54234.6 |
| 1072 | 2024-03-09 20:37:11 | inserts | 3 | 134027 | 355 | 6.343 | 21129.9 |
| 1071 | 2024-03-09 19:13:24 | inserts | 3 | 134027 | 355 | 8.220 | 16305.0 |
| 1070 | 2024-03-02 06:06:09 | inserts | 3 | 134027 | 355 | 10.890 | 12307.3 |
| 1069 | 2024-02-27 21:13:48 | inserts | 1 | 69583 | 6 | 1.200 | 57985.8 |
| 1068 | 2024-02-25 22:56:35 | inserts | 3 | 134027 | 355 | 7.500 | 17870.3 |
| 1067 | 2024-02-24 19:15:48 | inserts | 2 | 107671 | 49 | 3.470 | 31029.1 |
| 1066 | 2024-02-24 19:08:01 | inserts | 3 | 134027 | 355 | 7.470 | 17942.0 |
| 1065 | 2024-02-21 06:41:23 | inserts | 1 | 69583 | 6 | 2.843 | 24475.2 |
| 1064 | 2024-02-19 00:41:42 | inserts | 3 | 134027 | 355 | 14.703 | 9115.6 |
| 1063 | 2024-02-07 16:49:35 | inserts | 2 | 107671 | 49 | 3.516 | 30623.2 |
| 1062 | 2024-02-07 09:44:58 | inserts | 2 | 107671 | 49 | 6.563 | 16405.8 |
| 1061 | 2024-02-07 09:25:02 | inserts | 3 | 134027 | 355 | 7.126 | 18808.2 |
| 1060 | 2024-01-30 04:22:27 | inserts | 3 | 134027 | 355 | 7.936 | 16888.5 |
| 1059 | 2024-01-26 22:52:01 | inserts | 3 | 134027 | 355 | 12.313 | 10885.0 |
| 1058 | 2024-01-21 01:52:55 | inserts | 3 | 134027 | 355 | 6.216 | 21561.6 |
| 1057 | 2024-01-21 01:52:56 | inserts | 2 | 107671 | 49 | 3.080 | 34958.1 |
| 1056 | 2024-01-18 16:21:37 | inserts | 3 | 134027 | 355 | 6.126 | 21878.4 |
| 1055 | 2024-01-01 16:47:32 | inserts | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 1054 | 2023-12-28 17:35:58 | inserts | 3 | 134027 | 355 | 7.046 | 19021.7 |
| 1053 | 2023-12-28 02:37:25 | inserts | 3 | 134027 | 355 | 5.796 | 23124.1 |
| 1052 | 2023-12-27 23:22:50 | inserts | 3 | 134027 | 355 | 6.406 | 20922.1 |
| 1051 | 2023-12-27 23:22:51 | inserts | 2 | 107671 | 49 | 3.216 | 33479.8 |
| 1050 | 2023-12-04 15:27:12 | inserts | 1 | 69583 | 6 | 1.033 | 67360.1 |
| 1049 | 2023-12-03 02:26:12 | inserts | 2 | 107671 | 49 | 2.780 | 38730.6 |
| 1048 | 2023-11-28 03:25:09 | inserts | 3 | 134027 | 355 | 5.953 | 22514.2 |
| 1047 | 2023-11-21 13:40:55 | inserts | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 1046 | 2023-11-21 04:50:01 | inserts | 1 | 69583 | 6 | 1.123 | 61961.7 |
| 1045 | 2023-11-17 17:35:01 | inserts | 1 | 69583 | 6 | 1.170 | 59472.6 |
| 1044 | 2023-11-13 05:33:25 | inserts | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 1043 | 2023-10-25 12:56:50 | inserts | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 1042 | 2023-10-22 11:32:07 | inserts | 1 | 69583 | 6 | 1.030 | 67556.3 |
| 1041 | 2023-10-06 00:38:57 | inserts | 3 | 134027 | 355 | 5.873 | 22820.9 |
| 1040 | 2023-10-01 02:08:10 | inserts | 3 | 134027 | 355 | 5.766 | 23244.4 |
| 1039 | 2023-09-27 18:11:58 | inserts | 3 | 134027 | 355 | 7.093 | 18895.7 |
| 1038 | 2023-09-24 00:25:40 | inserts | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 1037 | 2023-09-23 22:54:57 | inserts | 1 | 69583 | 6 | 1.016 | 68487.2 |
| 1036 | 2023-09-14 13:11:14 | inserts | 3 | 134027 | 355 | 5.653 | 23709.0 |
| 1035 | 2023-09-13 02:37:33 | inserts | 3 | 134027 | 355 | 6.076 | 22058.4 |
| 1034 | 2023-09-11 19:13:44 | inserts | 3 | 134027 | 355 | 6.860 | 19537.5 |
| 1033 | 2023-09-03 18:13:03 | inserts | 3 | 134027 | 355 | 5.610 | 23890.7 |
| 1032 | 2023-09-02 22:50:42 | inserts | 3 | 134027 | 355 | 5.640 | 23763.7 |
| 1031 | 2023-09-02 06:27:05 | inserts | 2 | 107671 | 49 | 3.110 | 34620.9 |
| 1030 | 2023-09-01 00:14:18 | inserts | 3 | 134027 | 355 | 6.453 | 20769.7 |
| 1029 | 2023-08-28 15:27:52 | inserts | 3 | 134027 | 355 | 5.953 | 22514.2 |
| 1028 | 2023-08-20 08:04:03 | inserts | 3 | 134027 | 355 | 6.393 | 20964.6 |
| 1027 | 2023-08-18 02:17:24 | inserts | 3 | 134027 | 355 | 6.233 | 21502.8 |
| 1026 | 2023-08-17 05:03:41 | inserts | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 1025 | 2023-08-16 18:34:30 | inserts | 3 | 134027 | 355 | 6.813 | 19672.2 |
| 1024 | 2023-08-15 14:00:45 | inserts | 3 | 134027 | 355 | 6.233 | 21502.8 |
| 1023 | 2023-08-15 13:03:18 | inserts | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 1022 | 2023-08-09 00:07:44 | inserts | 3 | 134027 | 355 | 6.470 | 20715.1 |
| 1021 | 2023-08-06 23:56:57 | inserts | 3 | 134027 | 355 | 6.703 | 19995.1 |
| 1020 | 2023-08-05 04:44:32 | inserts | 3 | 134027 | 355 | 5.843 | 22938.0 |
| 1019 | 2023-08-03 03:00:22 | inserts | 3 | 134027 | 355 | 12.346 | 10855.9 |
| 1018 | 2023-07-28 14:54:52 | inserts | 3 | 134027 | 355 | 6.576 | 20381.2 |
| 1017 | 2023-07-26 21:18:09 | inserts | 3 | 134027 | 355 | 6.986 | 19185.1 |
| 1016 | 2023-07-25 21:13:33 | inserts | 3 | 134027 | 355 | 6.640 | 20184.8 |
| 1015 | 2023-07-24 16:23:35 | inserts | 3 | 134027 | 355 | 6.266 | 21389.6 |
| 1014 | 2023-07-22 23:19:57 | inserts | 3 | 134027 | 355 | 5.860 | 22871.5 |
| 1013 | 2023-07-21 12:06:03 | inserts | 3 | 134027 | 355 | 7.000 | 19146.7 |
| 1012 | 2023-07-20 08:12:53 | inserts | 3 | 134027 | 355 | 6.486 | 20664.0 |
| 1011 | 2023-07-19 04:23:55 | inserts | 3 | 134027 | 355 | 5.970 | 22450.1 |
| 1010 | 2023-07-17 15:10:55 | inserts | 3 | 134027 | 355 | 5.796 | 23124.1 |
| 1009 | 2023-07-16 15:33:10 | inserts | 3 | 134027 | 355 | 5.830 | 22989.2 |
| 1008 | 2023-07-15 09:43:42 | inserts | 3 | 134027 | 355 | 6.500 | 20619.5 |
| 1007 | 2023-07-14 01:55:21 | inserts | 3 | 134027 | 355 | 5.686 | 23571.4 |
| 1006 | 2023-07-12 13:57:34 | inserts | 3 | 134027 | 355 | 5.796 | 23124.1 |
| 1005 | 2023-06-23 06:00:07 | inserts | 3 | 134027 | 355 | 5.843 | 22938.0 |
| 1004 | 2023-06-19 01:50:19 | inserts | 3 | 134027 | 355 | 6.453 | 20769.7 |
| 1003 | 2023-06-06 20:20:08 | inserts | 3 | 134027 | 355 | 5.580 | 24019.2 |
| 1002 | 2023-06-05 23:15:56 | inserts | 3 | 134027 | 355 | 5.610 | 23890.7 |
| 1001 | 2023-06-05 08:40:59 | inserts | 3 | 134027 | 355 | 5.703 | 23501.1 |
| 1000 | 2023-06-04 19:38:26 | inserts | 3 | 134027 | 355 | 5.796 | 23124.1 |
| 999 | 2023-06-02 19:43:09 | inserts | 3 | 134027 | 355 | 5.673 | 23625.4 |
| 998 | 2023-06-01 19:50:52 | inserts | 3 | 134027 | 355 | 5.826 | 23005.0 |
| 997 | 2023-06-01 02:19:42 | inserts | 3 | 134027 | 355 | 5.563 | 24092.6 |
| 996 | 2023-05-31 10:39:20 | inserts | 3 | 134027 | 355 | 5.970 | 22450.1 |
| 995 | 2023-05-30 18:41:01 | inserts | 3 | 134027 | 355 | 6.656 | 20136.3 |
| 994 | 2023-05-29 18:36:53 | inserts | 3 | 134027 | 355 | 6.280 | 21341.9 |