History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"halls"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1399 | 2024-04-23 07:53:51 | halls | 1 | 28756 | 25 | 1.796 | 16011.1 |
1398 | 2024-04-23 07:46:32 | halls | 1 | 28756 | 25 | 1.343 | 21411.8 |
1397 | 2024-04-23 00:49:21 | halls | 1 | 28756 | 25 | 0.470 | 61183.0 |
1396 | 2024-04-22 08:25:33 | halls | 1 | 28756 | 25 | 1.310 | 21951.1 |
1395 | 2024-04-22 05:13:20 | halls | 1 | 28756 | 25 | 0.623 | 46157.3 |
1394 | 2024-04-03 05:27:35 | halls | 1 | 28756 | 25 | 1.123 | 25606.4 |
1393 | 2024-03-31 03:11:55 | halls | 1 | 28756 | 25 | 1.326 | 21686.3 |
1392 | 2024-03-27 03:15:01 | halls | 1 | 28756 | 25 | 1.153 | 24940.2 |
1391 | 2024-03-23 09:48:26 | halls | 2 | 53800 | 324 | 1.513 | 35558.5 |
1390 | 2024-03-22 11:34:23 | halls | 2 | 53800 | 324 | 3.623 | 14849.6 |
1389 | 2024-03-20 19:08:52 | halls | 2 | 53800 | 324 | 3.846 | 13988.6 |
1388 | 2024-03-19 21:57:36 | halls | 2 | 53800 | 324 | 3.486 | 15433.2 |
1387 | 2024-03-03 21:13:40 | halls | 1 | 28756 | 25 | 0.563 | 51076.4 |
1386 | 2024-03-03 20:50:55 | halls | 1 | 28756 | 25 | 0.576 | 49923.6 |
1385 | 2024-02-26 04:25:48 | halls | 1 | 28756 | 25 | 1.140 | 25224.6 |
1384 | 2024-02-25 17:24:52 | halls | 1 | 28756 | 25 | 0.656 | 43835.4 |
1383 | 2024-01-31 21:08:50 | halls | 1 | 28756 | 25 | 0.453 | 63479.0 |
1382 | 2024-01-26 10:51:24 | halls | 1 | 28756 | 25 | 0.516 | 55728.7 |
1381 | 2024-01-25 22:42:01 | halls | 1 | 28756 | 25 | 0.513 | 56054.6 |
1380 | 2024-01-06 22:37:40 | halls | 1 | 28756 | 25 | 0.513 | 56054.6 |
1379 | 2023-12-13 00:09:42 | halls | 1 | 28756 | 25 | 0.486 | 59168.7 |
1378 | 2023-12-10 06:49:30 | halls | 2 | 53800 | 324 | 1.593 | 33772.8 |
1377 | 2023-12-08 12:03:13 | halls | 1 | 28756 | 25 | 0.546 | 52666.7 |
1376 | 2023-12-08 12:03:12 | halls | 1 | 28756 | 25 | 0.596 | 48248.3 |
1375 | 2023-12-08 01:21:38 | halls | 1 | 28756 | 25 | 0.500 | 57512.0 |
1374 | 2023-12-08 01:21:37 | halls | 1 | 28756 | 25 | 0.530 | 54256.6 |
1373 | 2023-12-07 05:25:41 | halls | 1 | 28756 | 25 | 0.436 | 65954.1 |
1372 | 2023-11-27 19:34:11 | halls | 2 | 53800 | 324 | 1.423 | 37807.4 |
1371 | 2023-11-22 04:47:59 | halls | 1 | 28756 | 25 | 0.440 | 65354.5 |
1370 | 2023-11-21 14:00:43 | halls | 2 | 53800 | 324 | 1.410 | 38156.0 |
1369 | 2023-11-21 06:07:41 | halls | 1 | 28756 | 25 | 0.530 | 54256.6 |
1368 | 2023-11-18 12:46:25 | halls | 1 | 28756 | 25 | 0.530 | 54256.6 |
1367 | 2023-11-13 22:37:15 | halls | 1 | 28756 | 25 | 0.500 | 57512.0 |
1366 | 2023-11-09 04:42:11 | halls | 1 | 28756 | 25 | 0.440 | 65354.5 |
1365 | 2023-11-04 22:01:22 | halls | 2 | 53800 | 324 | 1.796 | 29955.5 |
1364 | 2023-10-26 17:02:32 | halls | 1 | 28756 | 25 | 0.440 | 65354.5 |
1363 | 2023-10-26 05:39:28 | halls | 2 | 53800 | 324 | 1.390 | 38705.0 |
1362 | 2023-10-23 12:27:29 | halls | 1 | 28756 | 25 | 0.486 | 59168.7 |
1361 | 2023-10-22 23:33:08 | halls | 1 | 28756 | 25 | 0.516 | 55728.7 |
1360 | 2023-10-20 13:31:57 | halls | 1 | 28756 | 25 | 1.170 | 24577.8 |
1359 | 2023-10-11 02:21:21 | halls | 1 | 28756 | 25 | 0.453 | 63479.0 |
1358 | 2023-10-07 09:21:26 | halls | 1 | 28756 | 25 | 0.453 | 63479.0 |
1357 | 2023-10-03 16:32:11 | halls | 1 | 28756 | 25 | 0.450 | 63902.2 |
1356 | 2023-09-28 11:21:58 | halls | 2 | 53800 | 324 | 1.470 | 36598.6 |
1355 | 2023-09-26 14:07:35 | halls | 1 | 28756 | 25 | 0.486 | 59168.7 |
1354 | 2023-09-22 11:18:44 | halls | 1 | 28756 | 25 | 0.440 | 65354.5 |
1353 | 2023-09-21 17:32:27 | halls | 1 | 28756 | 25 | 0.453 | 63479.0 |
1352 | 2023-08-26 23:01:51 | halls | 2 | 53800 | 324 | 1.673 | 32157.8 |
1351 | 2023-08-06 12:56:54 | halls | 2 | 53800 | 324 | 1.626 | 33087.3 |
1350 | 2023-08-03 06:18:39 | halls | 2 | 53800 | 324 | 1.530 | 35163.4 |
1349 | 2023-07-19 09:58:25 | halls | 1 | 28756 | 25 | 0.483 | 59536.2 |
1348 | 2023-07-18 05:03:55 | halls | 2 | 53800 | 324 | 1.656 | 32487.9 |
1347 | 2023-07-17 04:13:29 | halls | 2 | 53800 | 324 | 1.626 | 33087.3 |
1346 | 2023-07-15 02:38:27 | halls | 2 | 53800 | 324 | 1.420 | 37887.3 |
1345 | 2023-07-14 02:31:49 | halls | 2 | 53800 | 324 | 1.470 | 36598.6 |
1344 | 2023-07-13 00:19:03 | halls | 1 | 28756 | 25 | 0.486 | 59168.7 |
1343 | 2023-07-11 09:47:14 | halls | 2 | 53800 | 324 | 1.593 | 33772.8 |
1342 | 2023-07-01 01:04:10 | halls | 1 | 28756 | 25 | 0.640 | 44931.3 |
1341 | 2023-06-09 10:07:55 | halls | 2 | 53800 | 324 | 1.373 | 39184.3 |
1340 | 2023-06-08 05:07:02 | halls | 2 | 53800 | 324 | 1.373 | 39184.3 |
1339 | 2023-05-08 12:51:05 | halls | 2 | 53800 | 324 | 1.423 | 37807.4 |
1338 | 2023-04-18 00:55:49 | halls | 1 | 28756 | 25 | 0.483 | 59536.2 |
1337 | 2023-04-17 01:22:19 | halls | 1 | 28756 | 25 | 0.436 | 65954.1 |
1336 | 2023-04-11 07:38:51 | halls | 2 | 53800 | 324 | 1.546 | 34799.5 |
1335 | 2023-03-31 13:42:34 | halls | 1 | 28756 | 25 | 0.436 | 65954.1 |
1334 | 2023-03-28 07:07:55 | halls | 1 | 28756 | 25 | 0.453 | 63479.0 |
1333 | 2023-03-18 10:54:54 | halls | 1 | 28756 | 25 | 0.500 | 57512.0 |
1332 | 2023-02-10 06:54:30 | halls | 2 | 53800 | 324 | 1.376 | 39098.8 |
1331 | 2023-02-09 11:19:24 | halls | 1 | 28756 | 25 | 0.500 | 57512.0 |
1330 | 2023-02-07 22:40:25 | halls | 2 | 53800 | 324 | 1.373 | 39184.3 |
1329 | 2022-12-23 03:33:48 | halls | 1 | 28756 | 25 | 0.483 | 59536.2 |
1328 | 2022-12-07 10:07:36 | halls | 1 | 28756 | 25 | 0.500 | 57512.0 |
1327 | 2022-12-01 22:55:45 | halls | 2 | 53800 | 324 | 1.706 | 31535.8 |
1326 | 2022-11-29 23:43:41 | halls | 2 | 53800 | 324 | 1.716 | 31352.0 |
1325 | 2022-11-27 23:38:19 | halls | 2 | 53800 | 324 | 1.640 | 32804.9 |
1324 | 2022-11-25 19:17:43 | halls | 1 | 28756 | 25 | 0.500 | 57512.0 |
1323 | 2022-11-22 12:22:31 | halls | 2 | 53800 | 324 | 1.436 | 37465.2 |
1322 | 2022-11-21 10:07:47 | halls | 2 | 53800 | 324 | 1.640 | 32804.9 |
1321 | 2022-10-24 23:23:36 | halls | 2 | 53800 | 324 | 1.376 | 39098.8 |
1320 | 2022-09-22 10:03:57 | halls | 2 | 53800 | 324 | 1.656 | 32487.9 |
1319 | 2022-09-19 04:42:03 | halls | 1 | 28756 | 25 | 0.440 | 65354.5 |
1318 | 2022-09-16 02:25:55 | halls | 1 | 28756 | 25 | 0.440 | 65354.5 |
1317 | 2022-09-14 09:23:20 | halls | 2 | 53800 | 324 | 1.390 | 38705.0 |
1316 | 2022-09-12 05:43:34 | halls | 1 | 28756 | 25 | 0.453 | 63479.0 |
1315 | 2022-09-03 07:26:21 | halls | 2 | 53800 | 324 | 1.406 | 38264.6 |
1314 | 2022-08-29 08:09:00 | halls | 1 | 28756 | 25 | 0.486 | 59168.7 |
1313 | 2022-08-23 03:27:42 | halls | 1 | 28756 | 25 | 0.530 | 54256.6 |
1312 | 2022-08-14 13:15:25 | halls | 1 | 28756 | 25 | 0.440 | 65354.5 |
1311 | 2022-08-07 23:58:30 | halls | 2 | 53800 | 324 | 1.376 | 39098.8 |
1310 | 2022-08-07 17:02:23 | halls | 1 | 28756 | 25 | 0.436 | 65954.1 |
1309 | 2022-08-06 22:10:42 | halls | 1 | 28756 | 25 | 0.470 | 61183.0 |
1308 | 2022-08-05 09:55:52 | halls | 1 | 28756 | 25 | 0.453 | 63479.0 |
1307 | 2022-07-28 20:21:06 | halls | 1 | 28756 | 25 | 0.436 | 65954.1 |
1306 | 2022-07-28 14:09:00 | halls | 1 | 28756 | 25 | 0.500 | 57512.0 |
1305 | 2022-07-10 08:48:29 | halls | 1 | 28756 | 25 | 0.436 | 65954.1 |
1304 | 2022-07-04 04:19:29 | halls | 2 | 53800 | 324 | 1.420 | 37887.3 |
1303 | 2022-07-03 08:46:47 | halls | 1 | 28756 | 25 | 0.470 | 61183.0 |
1302 | 2022-07-02 18:32:04 | halls | 1 | 28756 | 25 | 0.500 | 57512.0 |
1301 | 2022-07-01 04:21:43 | halls | 1 | 28756 | 25 | 0.440 | 65354.5 |
1300 | 2022-06-30 11:33:28 | halls | 1 | 28756 | 25 | 0.500 | 57512.0 |