History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1334 | 2024-05-07 07:33:57 | fid | 1 | 5146 | 28 | 0.110 | 46781.8 |
1333 | 2024-05-03 20:00:23 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1332 | 2024-04-29 18:39:13 | fid | 1 | 5146 | 28 | 0.096 | 53604.2 |
1331 | 2024-04-29 02:38:20 | fid | 1 | 5146 | 28 | 0.250 | 20584.0 |
1330 | 2024-04-27 05:48:15 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1329 | 2024-04-25 18:32:16 | fid | 2 | 14084 | 397 | 0.390 | 36112.8 |
1328 | 2024-04-21 16:37:29 | fid | 1 | 5146 | 28 | 0.250 | 20584.0 |
1327 | 2024-04-21 16:31:15 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1326 | 2024-04-13 15:05:58 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1325 | 2024-04-02 17:51:21 | fid | 1 | 5146 | 28 | 0.123 | 41837.4 |
1324 | 2024-03-30 18:32:04 | fid | 1 | 5146 | 28 | 0.296 | 17385.1 |
1323 | 2024-03-29 07:22:47 | fid | 1 | 5146 | 28 | 0.233 | 22085.8 |
1322 | 2024-03-26 17:52:39 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1321 | 2024-03-19 19:22:33 | fid | 1 | 5146 | 28 | 0.313 | 16440.9 |
1320 | 2024-03-18 20:42:38 | fid | 1 | 5146 | 28 | 0.173 | 29745.7 |
1319 | 2024-03-04 09:22:03 | fid | 2 | 14084 | 397 | 0.893 | 15771.6 |
1318 | 2024-03-04 08:16:20 | fid | 2 | 14084 | 397 | 0.390 | 36112.8 |
1317 | 2024-03-02 16:32:34 | fid | 1 | 5146 | 28 | 0.156 | 32987.2 |
1316 | 2024-02-29 18:50:44 | fid | 1 | 5146 | 28 | 0.096 | 53604.2 |
1315 | 2024-02-25 15:41:32 | fid | 1 | 5146 | 28 | 0.123 | 41837.4 |
1314 | 2024-02-18 20:43:50 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1313 | 2024-02-04 05:42:25 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1312 | 2024-01-24 17:31:18 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1311 | 2024-01-20 05:35:29 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1310 | 2024-01-04 21:38:09 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1309 | 2023-12-18 09:51:22 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1308 | 2023-12-15 03:23:33 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1307 | 2023-11-27 09:59:41 | fid | 2 | 14084 | 397 | 0.330 | 42678.8 |
1306 | 2023-11-26 10:20:21 | fid | 1 | 5146 | 28 | 0.096 | 53604.2 |
1305 | 2023-11-25 22:46:49 | fid | 2 | 14084 | 397 | 0.390 | 36112.8 |
1304 | 2023-11-25 14:47:09 | fid | 2 | 14084 | 397 | 0.373 | 37758.7 |
1303 | 2023-11-19 06:21:00 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1302 | 2023-11-17 02:21:03 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1301 | 2023-11-10 01:03:45 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1300 | 2023-11-09 15:12:08 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1299 | 2023-11-07 10:29:57 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1298 | 2023-11-05 17:45:10 | fid | 1 | 5146 | 28 | 0.063 | 81682.5 |
1297 | 2023-11-04 07:00:05 | fid | 2 | 14084 | 397 | 0.330 | 42678.8 |
1296 | 2023-10-26 06:49:29 | fid | 1 | 5146 | 28 | 0.140 | 36757.1 |
1295 | 2023-10-23 23:43:36 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1294 | 2023-10-20 04:25:15 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1293 | 2023-10-17 02:45:30 | fid | 2 | 14084 | 397 | 0.653 | 21568.1 |
1292 | 2023-10-16 18:21:04 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1291 | 2023-10-13 15:31:46 | fid | 2 | 14084 | 397 | 0.360 | 39122.2 |
1290 | 2023-10-10 15:27:23 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1289 | 2023-10-03 18:30:55 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1288 | 2023-09-21 08:22:57 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1287 | 2023-09-12 06:53:33 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1286 | 2023-09-10 13:56:06 | fid | 2 | 14084 | 397 | 0.376 | 37457.4 |
1285 | 2023-09-10 11:09:55 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1284 | 2023-09-05 19:19:33 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1283 | 2023-09-04 18:37:47 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1282 | 2023-09-03 06:06:53 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1281 | 2023-08-25 10:01:51 | fid | 2 | 14084 | 397 | 0.313 | 44996.8 |
1280 | 2023-06-04 14:00:06 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1279 | 2023-05-09 14:38:24 | fid | 2 | 14084 | 397 | 0.326 | 43202.5 |
1278 | 2023-03-31 13:07:58 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1277 | 2023-03-18 18:02:34 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1276 | 2023-03-12 11:57:36 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1275 | 2023-03-05 09:49:02 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1274 | 2023-03-01 23:40:50 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1273 | 2023-02-14 21:12:13 | fid | 2 | 14084 | 397 | 0.360 | 39122.2 |
1272 | 2023-02-06 08:41:29 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1271 | 2023-01-24 03:02:53 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1270 | 2023-01-10 17:25:37 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1269 | 2023-01-10 15:57:26 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1268 | 2023-01-06 00:43:18 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1267 | 2022-12-16 00:23:52 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1266 | 2022-12-14 02:11:26 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1265 | 2022-12-09 21:00:42 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1264 | 2022-12-09 20:56:04 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1263 | 2022-11-27 06:53:37 | fid | 2 | 14084 | 397 | 0.373 | 37758.7 |
1262 | 2022-11-23 21:20:19 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1261 | 2022-11-16 01:51:11 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1260 | 2022-11-10 01:52:51 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1259 | 2022-11-07 11:18:38 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1258 | 2022-10-03 20:05:53 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1257 | 2022-09-29 16:57:51 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1256 | 2022-09-11 22:38:06 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1255 | 2022-09-09 18:32:42 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1254 | 2022-09-07 18:29:02 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1253 | 2022-09-05 18:46:08 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1252 | 2022-08-30 12:38:12 | fid | 2 | 14084 | 397 | 0.330 | 42678.8 |
1251 | 2022-08-26 00:10:55 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1250 | 2022-08-17 12:48:24 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1249 | 2022-08-16 13:30:28 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1248 | 2022-08-10 20:12:01 | fid | 2 | 14084 | 397 | 0.343 | 41061.2 |
1247 | 2022-08-10 13:21:00 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1246 | 2022-08-10 11:38:08 | fid | 2 | 14084 | 397 | 0.310 | 45432.3 |
1245 | 2022-08-06 17:04:13 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1244 | 2022-07-29 23:32:57 | fid | 1 | 5146 | 28 | 0.096 | 53604.2 |
1243 | 2022-07-29 22:08:40 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1242 | 2022-07-25 02:42:20 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1241 | 2022-07-03 05:22:40 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1240 | 2022-06-25 23:34:41 | fid | 2 | 14084 | 397 | 0.313 | 44996.8 |
1239 | 2022-06-16 05:28:37 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1238 | 2022-06-15 15:49:41 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1237 | 2022-06-13 12:44:44 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1236 | 2022-06-08 20:00:30 | fid | 1 | 5146 | 28 | 0.096 | 53604.2 |
1235 | 2022-06-08 17:22:43 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |