History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"site"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1367 | 2024-04-29 03:10:23 | site | 1 | 13983 | 29 | 1.280 | 10924.2 |
1366 | 2024-04-27 17:56:43 | site | 1 | 13983 | 29 | 0.263 | 53167.3 |
1365 | 2024-04-19 14:35:24 | site | 1 | 13983 | 29 | 0.280 | 49939.3 |
1364 | 2024-04-12 16:22:01 | site | 1 | 13983 | 29 | 0.576 | 24276.0 |
1363 | 2024-04-12 14:50:27 | site | 1 | 13983 | 29 | 0.560 | 24969.6 |
1362 | 2024-04-12 14:38:31 | site | 1 | 13983 | 29 | 0.296 | 47239.9 |
1361 | 2024-04-05 00:50:32 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1360 | 2024-04-02 20:22:33 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1359 | 2024-03-31 00:45:43 | site | 2 | 29872 | 455 | 1.533 | 19486.0 |
1358 | 2024-03-30 23:46:12 | site | 1 | 13983 | 29 | 0.283 | 49409.9 |
1357 | 2024-03-27 05:28:59 | site | 1 | 13983 | 29 | 0.266 | 52567.7 |
1356 | 2024-03-22 07:31:24 | site | 1 | 13983 | 29 | 0.780 | 17926.9 |
1355 | 2024-03-05 20:43:07 | site | 1 | 13983 | 29 | 0.576 | 24276.0 |
1354 | 2024-03-02 18:12:28 | site | 2 | 29872 | 455 | 1.076 | 27762.1 |
1353 | 2024-03-02 17:32:58 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1352 | 2024-02-29 19:47:40 | site | 1 | 13983 | 29 | 0.296 | 47239.9 |
1351 | 2024-02-28 00:08:56 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1350 | 2024-02-25 20:53:06 | site | 1 | 13983 | 29 | 0.563 | 24836.6 |
1349 | 2024-02-20 09:11:35 | site | 1 | 13983 | 29 | 0.250 | 55932.0 |
1348 | 2024-01-28 16:37:07 | site | 1 | 13983 | 29 | 0.216 | 64736.1 |
1347 | 2024-01-26 19:58:45 | site | 1 | 13983 | 29 | 0.266 | 52567.7 |
1346 | 2024-01-26 19:05:53 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1345 | 2024-01-22 14:00:10 | site | 1 | 13983 | 29 | 0.216 | 64736.1 |
1344 | 2024-01-17 12:54:43 | site | 2 | 29872 | 455 | 0.873 | 34217.6 |
1343 | 2024-01-15 19:22:11 | site | 1 | 13983 | 29 | 0.233 | 60012.9 |
1342 | 2023-12-29 06:03:27 | site | 1 | 13983 | 29 | 0.216 | 64736.1 |
1341 | 2023-12-18 19:59:44 | site | 2 | 29872 | 455 | 0.890 | 33564.0 |
1340 | 2023-12-13 09:15:50 | site | 1 | 13983 | 29 | 0.266 | 52567.7 |
1339 | 2023-12-04 23:24:33 | site | 1 | 13983 | 29 | 0.236 | 59250.0 |
1338 | 2023-12-03 22:09:07 | site | 2 | 29872 | 455 | 0.873 | 34217.6 |
1337 | 2023-11-21 11:06:54 | site | 2 | 29872 | 455 | 0.780 | 38297.4 |
1336 | 2023-11-14 22:02:12 | site | 2 | 29872 | 455 | 0.750 | 39829.3 |
1335 | 2023-11-11 22:06:55 | site | 2 | 29872 | 455 | 0.906 | 32971.3 |
1334 | 2023-11-10 09:48:47 | site | 1 | 13983 | 29 | 0.233 | 60012.9 |
1333 | 2023-11-08 04:01:58 | site | 1 | 13983 | 29 | 0.236 | 59250.0 |
1332 | 2023-11-07 23:45:10 | site | 1 | 13983 | 29 | 0.236 | 59250.0 |
1331 | 2023-11-02 06:20:17 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1330 | 2023-10-27 04:20:10 | site | 1 | 13983 | 29 | 0.216 | 64736.1 |
1329 | 2023-10-23 09:14:29 | site | 1 | 13983 | 29 | 0.250 | 55932.0 |
1328 | 2023-10-19 18:25:33 | site | 2 | 29872 | 455 | 0.966 | 30923.4 |
1327 | 2023-10-19 16:23:25 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1326 | 2023-10-19 03:11:35 | site | 2 | 29872 | 455 | 0.856 | 34897.2 |
1325 | 2023-10-16 20:01:38 | site | 1 | 13983 | 29 | 0.250 | 55932.0 |
1324 | 2023-10-15 03:56:27 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1323 | 2023-10-13 06:04:22 | site | 1 | 13983 | 29 | 0.233 | 60012.9 |
1322 | 2023-10-04 07:06:49 | site | 1 | 13983 | 29 | 0.233 | 60012.9 |
1321 | 2023-09-28 04:31:27 | site | 1 | 13983 | 29 | 0.250 | 55932.0 |
1320 | 2023-09-26 18:33:14 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1319 | 2023-09-23 20:40:00 | site | 1 | 13983 | 29 | 0.250 | 55932.0 |
1318 | 2023-09-23 15:42:44 | site | 1 | 13983 | 29 | 0.233 | 60012.9 |
1317 | 2023-09-22 05:17:41 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1316 | 2023-09-21 03:39:49 | site | 1 | 13983 | 29 | 0.250 | 55932.0 |
1315 | 2023-09-06 02:26:51 | site | 2 | 29872 | 455 | 0.876 | 34100.5 |
1314 | 2023-09-01 11:51:24 | site | 2 | 29872 | 455 | 0.856 | 34897.2 |
1313 | 2023-08-29 13:21:45 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1312 | 2023-08-29 00:41:20 | site | 1 | 13983 | 29 | 0.216 | 64736.1 |
1311 | 2023-08-15 22:25:59 | site | 2 | 29872 | 455 | 0.830 | 35990.4 |
1310 | 2023-06-17 23:19:49 | site | 1 | 13983 | 29 | 0.250 | 55932.0 |
1309 | 2023-06-14 17:40:16 | site | 1 | 13983 | 29 | 0.233 | 60012.9 |
1308 | 2023-06-01 23:50:12 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1307 | 2023-03-26 08:17:37 | site | 1 | 13983 | 29 | 0.436 | 32071.1 |
1306 | 2023-03-02 08:38:55 | site | 1 | 13983 | 29 | 0.216 | 64736.1 |
1305 | 2023-01-25 21:51:14 | site | 2 | 29872 | 455 | 0.766 | 38997.4 |
1304 | 2023-01-10 02:40:09 | site | 1 | 13983 | 29 | 0.250 | 55932.0 |
1303 | 2022-12-25 07:03:05 | site | 2 | 29872 | 455 | 0.750 | 39829.3 |
1302 | 2022-11-25 09:00:59 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |
1301 | 2022-11-13 13:22:14 | site | 1 | 13983 | 29 | 0.250 | 55932.0 |
1300 | 2022-11-05 09:15:11 | site | 2 | 29872 | 455 | 0.970 | 30795.9 |
1299 | 2022-11-04 04:35:24 | site | 2 | 29872 | 455 | 0.860 | 34734.9 |
1298 | 2022-11-03 14:30:01 | site | 2 | 29872 | 455 | 0.890 | 33564.0 |
1297 | 2022-11-02 14:42:58 | site | 2 | 29872 | 455 | 0.890 | 33564.0 |
1296 | 2022-11-01 17:03:33 | site | 2 | 29872 | 455 | 0.873 | 34217.6 |
1295 | 2022-10-31 12:50:58 | site | 2 | 29872 | 455 | 0.783 | 38150.7 |
1294 | 2022-10-30 06:41:49 | site | 2 | 29872 | 455 | 0.983 | 30388.6 |
1293 | 2022-10-29 05:10:08 | site | 2 | 29872 | 455 | 0.890 | 33564.0 |
1292 | 2022-10-28 04:03:22 | site | 2 | 29872 | 455 | 0.950 | 31444.2 |
1291 | 2022-10-27 07:22:36 | site | 2 | 29872 | 455 | 0.910 | 32826.4 |
1290 | 2022-10-26 14:50:52 | site | 2 | 29872 | 455 | 0.970 | 30795.9 |
1289 | 2022-10-25 04:36:46 | site | 2 | 29872 | 455 | 1.406 | 21246.1 |
1288 | 2022-10-24 09:11:24 | site | 2 | 29872 | 455 | 1.093 | 27330.3 |
1287 | 2022-10-23 04:50:42 | site | 2 | 29872 | 455 | 0.906 | 32971.3 |
1286 | 2022-10-22 04:20:27 | site | 2 | 29872 | 455 | 0.860 | 34734.9 |
1285 | 2022-10-21 09:47:24 | site | 2 | 29872 | 455 | 1.063 | 28101.6 |
1284 | 2022-10-20 08:39:50 | site | 2 | 29872 | 455 | 0.843 | 35435.3 |
1283 | 2022-10-19 08:15:22 | site | 2 | 29872 | 455 | 0.906 | 32971.3 |
1282 | 2022-10-18 12:35:24 | site | 2 | 29872 | 455 | 1.766 | 16915.1 |
1281 | 2022-10-17 18:17:16 | site | 2 | 29872 | 455 | 0.860 | 34734.9 |
1280 | 2022-10-16 12:28:15 | site | 2 | 29872 | 455 | 0.890 | 33564.0 |
1279 | 2022-10-15 12:31:58 | site | 2 | 29872 | 455 | 0.893 | 33451.3 |
1278 | 2022-10-14 15:12:59 | site | 2 | 29872 | 455 | 0.843 | 35435.3 |
1277 | 2022-10-13 05:55:38 | site | 2 | 29872 | 455 | 0.903 | 33080.8 |
1276 | 2022-10-13 05:53:20 | site | 2 | 29872 | 455 | 0.920 | 32469.6 |
1275 | 2022-10-12 12:55:51 | site | 2 | 29872 | 455 | 0.860 | 34734.9 |
1274 | 2022-10-12 10:33:30 | site | 1 | 13983 | 29 | 0.263 | 53167.3 |
1273 | 2022-10-11 09:21:39 | site | 2 | 29872 | 455 | 0.950 | 31444.2 |
1272 | 2022-10-10 13:56:31 | site | 2 | 29872 | 455 | 0.950 | 31444.2 |
1271 | 2022-10-09 11:58:38 | site | 2 | 29872 | 455 | 0.856 | 34897.2 |
1270 | 2022-10-08 08:45:54 | site | 2 | 29872 | 455 | 1.000 | 29872.0 |
1269 | 2022-10-07 12:15:16 | site | 2 | 29872 | 455 | 0.920 | 32469.6 |
1268 | 2022-09-19 12:59:07 | site | 1 | 13983 | 29 | 0.220 | 63559.1 |