History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"three"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1426 | 2024-03-05 10:27:50 | three | 1 | 28756 | 8 | 0.593 | 48492.4 |
1425 | 2024-03-01 10:00:05 | three | 2 | 53800 | 102 | 4.283 | 12561.3 |
1424 | 2024-03-01 09:03:25 | three | 1 | 28756 | 8 | 0.513 | 56054.6 |
1423 | 2024-02-26 00:45:52 | three | 2 | 53800 | 102 | 1.826 | 29463.3 |
1422 | 2024-02-25 18:50:13 | three | 2 | 53800 | 102 | 14.266 | 3771.2 |
1421 | 2024-02-25 18:49:00 | three | 1 | 28756 | 8 | 1.063 | 27051.7 |
1420 | 2024-02-25 16:23:40 | three | 1 | 28756 | 8 | 0.450 | 63902.2 |
1419 | 2024-02-04 09:23:36 | three | 1 | 28756 | 8 | 0.516 | 55728.7 |
1418 | 2024-01-29 03:22:44 | three | 1 | 28756 | 8 | 0.500 | 57512.0 |
1417 | 2024-01-28 19:04:36 | three | 1 | 28756 | 8 | 0.486 | 59168.7 |
1416 | 2024-01-26 14:31:48 | three | 1 | 28756 | 8 | 0.533 | 53951.2 |
1415 | 2024-01-25 23:04:09 | three | 1 | 28756 | 8 | 0.516 | 55728.7 |
1414 | 2024-01-24 01:21:01 | three | 1 | 28756 | 8 | 0.440 | 65354.5 |
1413 | 2024-01-08 14:41:29 | three | 2 | 53800 | 102 | 1.513 | 35558.5 |
1412 | 2023-12-29 05:34:48 | three | 1 | 28756 | 8 | 0.483 | 59536.2 |
1411 | 2023-12-15 10:51:44 | three | 1 | 28756 | 8 | 1.093 | 26309.2 |
1410 | 2023-12-09 16:14:52 | three | 1 | 28756 | 8 | 0.436 | 65954.1 |
1409 | 2023-12-03 12:18:30 | three | 1 | 28756 | 8 | 0.500 | 57512.0 |
1408 | 2023-12-03 12:18:29 | three | 1 | 28756 | 8 | 0.500 | 57512.0 |
1407 | 2023-11-27 12:58:25 | three | 1 | 28756 | 8 | 0.453 | 63479.0 |
1406 | 2023-11-11 04:12:17 | three | 2 | 53800 | 102 | 1.453 | 37026.8 |
1405 | 2023-11-10 22:59:04 | three | 2 | 53800 | 102 | 1.580 | 34050.6 |
1404 | 2023-11-08 11:44:34 | three | 1 | 28756 | 8 | 0.453 | 63479.0 |
1403 | 2023-11-08 02:41:51 | three | 1 | 28756 | 8 | 0.420 | 68466.7 |
1402 | 2023-11-07 10:27:26 | three | 1 | 28756 | 8 | 0.500 | 57512.0 |
1401 | 2023-11-06 15:49:09 | three | 1 | 28756 | 8 | 0.436 | 65954.1 |
1400 | 2023-11-05 19:04:07 | three | 1 | 28756 | 8 | 0.483 | 59536.2 |
1399 | 2023-10-27 02:48:17 | three | 2 | 53800 | 102 | 1.346 | 39970.3 |
1398 | 2023-10-25 20:01:44 | three | 1 | 28756 | 8 | 0.486 | 59168.7 |
1397 | 2023-10-20 16:51:04 | three | 2 | 53800 | 102 | 1.903 | 28271.2 |
1396 | 2023-10-19 14:56:21 | three | 1 | 28756 | 8 | 0.483 | 59536.2 |
1395 | 2023-10-17 19:38:44 | three | 2 | 53800 | 102 | 1.516 | 35488.1 |
1394 | 2023-10-16 19:09:51 | three | 1 | 28756 | 8 | 0.563 | 51076.4 |
1393 | 2023-10-15 10:05:43 | three | 2 | 53800 | 102 | 1.326 | 40573.2 |
1392 | 2023-10-11 05:18:49 | three | 2 | 53800 | 102 | 1.406 | 38264.6 |
1391 | 2023-10-09 22:31:50 | three | 1 | 28756 | 8 | 0.843 | 34111.5 |
1390 | 2023-10-04 09:34:15 | three | 2 | 53800 | 102 | 1.373 | 39184.3 |
1389 | 2023-10-03 08:54:44 | three | 1 | 28756 | 8 | 0.500 | 57512.0 |
1388 | 2023-09-25 13:29:05 | three | 1 | 28756 | 8 | 0.500 | 57512.0 |
1387 | 2023-09-23 21:03:42 | three | 2 | 53800 | 102 | 1.373 | 39184.3 |
1386 | 2023-09-21 01:21:12 | three | 1 | 28756 | 8 | 0.420 | 68466.7 |
1385 | 2023-09-18 23:47:22 | three | 1 | 28756 | 8 | 0.440 | 65354.5 |
1384 | 2023-09-15 20:10:15 | three | 1 | 28756 | 8 | 0.486 | 59168.7 |
1383 | 2023-09-13 07:46:59 | three | 1 | 28756 | 8 | 0.420 | 68466.7 |
1382 | 2023-09-10 14:18:43 | three | 2 | 53800 | 102 | 1.343 | 40059.6 |
1381 | 2023-09-10 11:10:33 | three | 1 | 28756 | 8 | 0.483 | 59536.2 |
1380 | 2023-07-26 11:31:00 | three | 1 | 28756 | 8 | 0.436 | 65954.1 |
1379 | 2023-07-25 19:57:16 | three | 2 | 53800 | 102 | 1.673 | 32157.8 |
1378 | 2023-07-23 16:44:40 | three | 1 | 28756 | 8 | 0.576 | 49923.6 |
1377 | 2023-07-23 10:07:25 | three | 1 | 28756 | 8 | 0.440 | 65354.5 |
1376 | 2023-07-16 19:44:50 | three | 1 | 28756 | 8 | 0.483 | 59536.2 |
1375 | 2023-06-28 10:19:47 | three | 1 | 28756 | 8 | 0.453 | 63479.0 |
1374 | 2023-06-10 12:59:29 | three | 1 | 28756 | 8 | 0.420 | 68466.7 |
1373 | 2023-05-28 08:54:53 | three | 1 | 28756 | 8 | 0.420 | 68466.7 |
1372 | 2023-04-07 10:13:31 | three | 1 | 28756 | 8 | 0.436 | 65954.1 |
1371 | 2023-04-05 02:55:18 | three | 2 | 53800 | 102 | 1.313 | 40974.9 |
1370 | 2023-03-27 14:08:59 | three | 1 | 28756 | 8 | 0.436 | 65954.1 |
1369 | 2023-03-14 17:06:41 | three | 1 | 28756 | 8 | 0.466 | 61708.2 |
1368 | 2023-03-12 12:08:50 | three | 1 | 28756 | 8 | 0.436 | 65954.1 |
1367 | 2023-03-10 07:50:32 | three | 1 | 28756 | 8 | 0.423 | 67981.1 |
1366 | 2023-02-01 12:37:02 | three | 1 | 28756 | 8 | 0.423 | 67981.1 |
1365 | 2023-01-30 07:28:08 | three | 1 | 28756 | 8 | 0.470 | 61183.0 |
1364 | 2023-01-29 08:08:40 | three | 1 | 28756 | 8 | 0.483 | 59536.2 |
1363 | 2023-01-26 18:08:06 | three | 1 | 28756 | 8 | 0.420 | 68466.7 |
1362 | 2023-01-17 08:33:59 | three | 1 | 28756 | 8 | 0.466 | 61708.2 |
1361 | 2023-01-03 20:15:35 | three | 2 | 53800 | 102 | 1.500 | 35866.7 |
1360 | 2022-12-29 17:28:46 | three | 1 | 28756 | 8 | 0.483 | 59536.2 |
1359 | 2022-12-14 08:51:24 | three | 1 | 28756 | 8 | 0.483 | 59536.2 |
1358 | 2022-11-26 02:37:56 | three | 1 | 28756 | 8 | 0.436 | 65954.1 |
1357 | 2022-11-24 17:42:11 | three | 1 | 28756 | 8 | 0.420 | 68466.7 |
1356 | 2022-10-26 17:00:44 | three | 1 | 28756 | 8 | 0.440 | 65354.5 |
1355 | 2022-10-11 03:45:26 | three | 1 | 28756 | 8 | 0.436 | 65954.1 |
1354 | 2022-09-10 21:10:53 | three | 1 | 28756 | 8 | 0.440 | 65354.5 |
1353 | 2022-09-09 04:20:04 | three | 2 | 53800 | 102 | 1.313 | 40974.9 |
1352 | 2022-09-02 09:32:18 | three | 1 | 28756 | 8 | 0.546 | 52666.7 |
1351 | 2022-09-01 21:56:46 | three | 1 | 28756 | 8 | 0.563 | 51076.4 |
1350 | 2022-09-01 05:34:10 | three | 1 | 28756 | 8 | 0.470 | 61183.0 |
1349 | 2022-08-31 12:08:53 | three | 1 | 28756 | 8 | 0.530 | 54256.6 |
1348 | 2022-08-29 08:14:44 | three | 1 | 28756 | 8 | 0.546 | 52666.7 |
1347 | 2022-08-22 03:01:29 | three | 2 | 53800 | 102 | 1.360 | 39558.8 |
1346 | 2022-08-15 02:56:09 | three | 1 | 28756 | 8 | 0.436 | 65954.1 |
1345 | 2022-07-29 10:24:37 | three | 1 | 28756 | 8 | 0.500 | 57512.0 |
1344 | 2022-07-25 12:56:36 | three | 1 | 28756 | 8 | 0.436 | 65954.1 |
1343 | 2022-07-21 01:22:17 | three | 1 | 28756 | 8 | 0.420 | 68466.7 |
1342 | 2022-07-18 18:59:29 | three | 1 | 28756 | 8 | 0.440 | 65354.5 |
1341 | 2022-06-02 17:31:34 | three | 1 | 28756 | 8 | 0.440 | 65354.5 |
1340 | 2022-05-18 10:48:20 | three | 1 | 28756 | 8 | 0.436 | 65954.1 |
1339 | 2022-05-11 05:03:27 | three | 1 | 28756 | 8 | 0.453 | 63479.0 |
1338 | 2022-03-11 22:12:43 | three | 1 | 28756 | 8 | 0.440 | 65354.5 |
1337 | 2022-02-23 09:17:53 | three | 1 | 28756 | 8 | 0.483 | 59536.2 |
1336 | 2022-01-29 09:34:35 | three | 1 | 28756 | 8 | 0.440 | 65354.5 |
1335 | 2021-12-30 17:38:28 | three | 1 | 28756 | 8 | 0.576 | 49923.6 |
1334 | 2021-12-02 06:37:40 | three | 1 | 28756 | 8 | 0.440 | 65354.5 |
1333 | 2021-11-10 17:57:41 | three | 1 | 28756 | 8 | 0.423 | 67981.1 |
1332 | 2021-11-05 03:49:30 | three | 1 | 28756 | 8 | 0.500 | 57512.0 |
1331 | 2021-10-31 08:39:52 | three | 1 | 28756 | 8 | 0.500 | 57512.0 |
1330 | 2021-10-29 05:57:26 | three | 1 | 28756 | 8 | 0.483 | 59536.2 |
1329 | 2021-10-12 15:00:30 | three | 1 | 28756 | 8 | 0.453 | 63479.0 |
1328 | 2021-10-07 13:06:12 | three | 1 | 28756 | 8 | 0.516 | 55728.7 |
1327 | 2021-09-30 06:50:38 | three | 1 | 28756 | 8 | 0.423 | 67981.1 |