History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"limit"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1205 | 2024-04-03 08:47:24 | limit | 3 | 83667 | 859 | 14.030 | 5963.4 |
| 1204 | 2024-04-03 07:14:31 | limit | 3 | 83667 | 859 | 8.050 | 10393.4 |
| 1203 | 2024-04-03 07:14:31 | limit | 2 | 53800 | 72 | 1.843 | 29191.5 |
| 1202 | 2024-04-03 07:02:33 | limit | 1 | 28756 | 3 | 1.360 | 21144.1 |
| 1201 | 2024-04-01 17:45:08 | limit | 2 | 53800 | 72 | 5.753 | 9351.6 |
| 1200 | 2024-03-31 14:25:24 | limit | 3 | 83667 | 859 | 4.970 | 16834.4 |
| 1199 | 2024-03-31 14:25:24 | limit | 2 | 53800 | 72 | 3.686 | 14595.8 |
| 1198 | 2024-03-31 14:15:28 | limit | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1197 | 2024-03-31 00:07:43 | limit | 3 | 83667 | 859 | 12.890 | 6490.8 |
| 1196 | 2024-03-28 20:29:13 | limit | 2 | 53800 | 72 | 2.360 | 22796.6 |
| 1195 | 2024-03-28 20:29:11 | limit | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 1194 | 2024-03-28 20:29:02 | limit | 2 | 53800 | 72 | 2.080 | 25865.4 |
| 1193 | 2024-03-28 20:28:35 | limit | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 1192 | 2024-03-28 02:13:39 | limit | 3 | 83667 | 859 | 4.000 | 20916.8 |
| 1191 | 2024-03-07 17:51:58 | limit | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1190 | 2024-03-06 00:19:02 | limit | 3 | 83667 | 859 | 9.373 | 8926.4 |
| 1189 | 2024-03-04 04:06:17 | limit | 3 | 83667 | 859 | 12.126 | 6899.8 |
| 1188 | 2024-03-04 00:24:20 | limit | 3 | 83667 | 859 | 9.470 | 8835.0 |
| 1187 | 2024-03-04 00:24:20 | limit | 2 | 53800 | 72 | 5.233 | 10280.9 |
| 1186 | 2024-03-04 00:09:56 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1185 | 2024-03-01 12:52:19 | limit | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1184 | 2024-02-25 19:09:21 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1183 | 2024-02-06 19:35:01 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1182 | 2024-02-02 21:57:59 | limit | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1181 | 2024-01-29 03:39:48 | limit | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 1180 | 2024-01-26 11:13:13 | limit | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1179 | 2024-01-25 23:59:53 | limit | 3 | 83667 | 859 | 4.250 | 19686.4 |
| 1178 | 2024-01-25 23:59:49 | limit | 2 | 53800 | 72 | 1.656 | 32487.9 |
| 1177 | 2024-01-25 22:08:44 | limit | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 1176 | 2024-01-15 19:40:01 | limit | 2 | 53800 | 72 | 1.390 | 38705.0 |
| 1175 | 2023-12-24 07:13:59 | limit | 3 | 83667 | 859 | 3.576 | 23396.8 |
| 1174 | 2023-12-24 07:13:58 | limit | 2 | 53800 | 72 | 1.436 | 37465.2 |
| 1173 | 2023-12-22 13:38:10 | limit | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1172 | 2023-12-16 14:47:51 | limit | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1171 | 2023-12-05 08:13:02 | limit | 3 | 83667 | 859 | 3.250 | 25743.7 |
| 1170 | 2023-11-28 06:48:35 | limit | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1169 | 2023-11-28 00:50:42 | limit | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1168 | 2023-11-27 01:17:41 | limit | 3 | 83667 | 859 | 3.550 | 23568.2 |
| 1167 | 2023-11-27 01:17:30 | limit | 2 | 53800 | 72 | 1.373 | 39184.3 |
| 1166 | 2023-11-22 15:13:52 | limit | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 1165 | 2023-11-21 04:06:48 | limit | 1 | 28756 | 3 | 0.560 | 51350.0 |
| 1164 | 2023-11-12 16:16:16 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1163 | 2023-11-09 21:33:49 | limit | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1162 | 2023-10-26 13:57:27 | limit | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1161 | 2023-10-26 07:59:35 | limit | 2 | 53800 | 72 | 1.643 | 32745.0 |
| 1160 | 2023-10-26 06:21:42 | limit | 3 | 83667 | 859 | 4.106 | 20376.8 |
| 1159 | 2023-10-25 15:09:20 | limit | 3 | 83667 | 859 | 3.733 | 22412.8 |
| 1158 | 2023-10-25 14:25:11 | limit | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1157 | 2023-10-25 09:03:35 | limit | 2 | 53800 | 72 | 1.420 | 37887.3 |
| 1156 | 2023-10-24 17:07:40 | limit | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1155 | 2023-10-22 08:34:52 | limit | 3 | 83667 | 859 | 3.326 | 25155.4 |
| 1154 | 2023-10-22 08:34:51 | limit | 2 | 53800 | 72 | 1.436 | 37465.2 |
| 1153 | 2023-10-20 12:37:58 | limit | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1152 | 2023-10-17 00:35:04 | limit | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1151 | 2023-10-11 23:54:20 | limit | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1150 | 2023-10-03 22:37:32 | limit | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1149 | 2023-09-22 22:34:57 | limit | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1148 | 2023-09-11 01:56:44 | limit | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1147 | 2023-09-08 22:25:20 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1146 | 2023-09-07 22:11:47 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1145 | 2023-08-23 17:39:09 | limit | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 1144 | 2023-08-05 05:28:06 | limit | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 1143 | 2023-08-04 10:32:55 | limit | 2 | 53800 | 72 | 1.500 | 35866.7 |
| 1142 | 2023-06-14 09:27:53 | limit | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1141 | 2023-05-13 16:19:50 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1140 | 2023-04-13 10:15:03 | limit | 2 | 53800 | 72 | 1.563 | 34421.0 |
| 1139 | 2023-04-02 18:42:55 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1138 | 2023-01-31 07:55:48 | limit | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1137 | 2023-01-19 15:01:56 | limit | 2 | 53800 | 72 | 1.346 | 39970.3 |
| 1136 | 2023-01-17 08:34:26 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1135 | 2022-11-12 20:31:19 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1134 | 2022-10-29 23:28:47 | limit | 2 | 53800 | 72 | 1.420 | 37887.3 |
| 1133 | 2022-10-13 13:23:16 | limit | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1132 | 2022-08-14 03:40:08 | limit | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1131 | 2022-08-07 01:51:45 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1130 | 2022-07-30 02:59:34 | limit | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1129 | 2022-07-04 17:52:22 | limit | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1128 | 2022-07-03 10:34:32 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1127 | 2022-06-30 21:06:09 | limit | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1126 | 2022-06-16 10:32:24 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1125 | 2022-05-26 02:48:05 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1124 | 2022-05-25 12:34:36 | limit | 2 | 53800 | 72 | 1.483 | 36277.8 |
| 1123 | 2022-03-14 00:55:44 | limit | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1122 | 2022-03-07 08:52:45 | limit | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 1121 | 2022-03-06 06:04:52 | limit | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1120 | 2022-02-10 05:38:45 | limit | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1119 | 2022-02-09 10:28:35 | limit | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1118 | 2022-02-08 10:22:02 | limit | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1117 | 2022-01-18 07:36:19 | limit | 2 | 53800 | 72 | 1.390 | 38705.0 |
| 1116 | 2021-12-17 19:50:42 | limit | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 1115 | 2021-12-10 19:24:39 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1114 | 2021-11-30 07:19:44 | limit | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1113 | 2021-10-24 22:19:43 | limit | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1112 | 2021-09-25 19:08:59 | limit | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1111 | 2021-09-21 07:15:42 | limit | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1110 | 2021-09-20 18:33:48 | limit | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1109 | 2021-09-14 01:56:59 | limit | 1 | 28756 | 3 | 0.456 | 63061.4 |
| 1108 | 2021-08-30 15:08:31 | limit | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1107 | 2021-07-19 04:07:05 | limit | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1106 | 2021-05-30 07:39:06 | limit | 2 | 53800 | 72 | 1.576 | 34137.1 |