History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"awarder"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 538 | 2024-04-19 14:23:29 | awarder | 1 | 69583 | 5 | 2.250 | 30925.8 |
| 537 | 2024-03-31 02:52:24 | awarder | 2 | 107671 | 34 | 4.330 | 24866.3 |
| 536 | 2024-03-29 04:10:52 | awarder | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 535 | 2024-03-07 03:57:35 | awarder | 3 | 134027 | 342 | 9.343 | 14345.2 |
| 534 | 2024-03-06 04:39:39 | awarder | 3 | 134027 | 342 | 15.766 | 8501.0 |
| 533 | 2024-03-02 12:51:01 | awarder | 3 | 134027 | 342 | 16.860 | 7949.4 |
| 532 | 2024-02-28 01:39:53 | awarder | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 531 | 2024-02-26 09:40:23 | awarder | 3 | 134027 | 342 | 6.796 | 19721.5 |
| 530 | 2024-02-26 07:47:52 | awarder | 3 | 134027 | 342 | 7.216 | 18573.6 |
| 529 | 2024-02-05 05:06:19 | awarder | 3 | 134027 | 342 | 7.093 | 18895.7 |
| 528 | 2024-02-05 02:12:46 | awarder | 3 | 134027 | 342 | 6.936 | 19323.4 |
| 527 | 2024-01-26 08:24:55 | awarder | 3 | 134027 | 342 | 6.626 | 20227.4 |
| 526 | 2024-01-25 05:49:02 | awarder | 3 | 134027 | 342 | 5.623 | 23835.5 |
| 525 | 2024-01-01 06:15:46 | awarder | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 524 | 2023-12-14 04:05:09 | awarder | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 523 | 2023-12-02 21:11:44 | awarder | 2 | 107671 | 34 | 5.563 | 19354.8 |
| 522 | 2023-11-28 09:35:21 | awarder | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 521 | 2023-11-28 02:50:26 | awarder | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 520 | 2023-11-20 19:55:45 | awarder | 3 | 134027 | 342 | 6.486 | 20664.0 |
| 519 | 2023-11-15 17:16:38 | awarder | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 518 | 2023-11-13 19:05:47 | awarder | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 517 | 2023-11-06 14:06:36 | awarder | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 516 | 2023-10-22 23:18:40 | awarder | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 515 | 2023-10-21 19:22:20 | awarder | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 514 | 2023-10-14 08:55:32 | awarder | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 513 | 2023-10-08 07:17:16 | awarder | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 512 | 2023-09-28 09:19:26 | awarder | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 511 | 2023-09-26 00:16:53 | awarder | 1 | 69583 | 5 | 2.343 | 29698.3 |
| 510 | 2023-09-01 09:03:29 | awarder | 2 | 107671 | 34 | 2.783 | 38688.8 |
| 509 | 2023-08-21 22:45:26 | awarder | 3 | 134027 | 342 | 6.393 | 20964.6 |
| 508 | 2023-08-16 17:58:10 | awarder | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 507 | 2023-07-15 15:42:17 | awarder | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 506 | 2023-07-04 10:20:18 | awarder | 3 | 134027 | 342 | 5.753 | 23296.9 |
| 505 | 2023-05-19 16:54:17 | awarder | 2 | 107671 | 34 | 2.733 | 39396.6 |
| 504 | 2023-05-16 05:48:08 | awarder | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 503 | 2023-05-05 19:11:03 | awarder | 3 | 134027 | 342 | 6.766 | 19808.9 |
| 502 | 2023-03-24 06:02:18 | awarder | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 501 | 2023-03-09 12:31:47 | awarder | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 500 | 2023-02-26 19:31:19 | awarder | 2 | 107671 | 34 | 2.763 | 38968.9 |
| 499 | 2023-02-13 22:08:56 | awarder | 3 | 134027 | 342 | 5.656 | 23696.4 |
| 498 | 2023-02-01 08:20:13 | awarder | 3 | 134027 | 342 | 6.186 | 21666.2 |
| 497 | 2022-12-29 00:45:33 | awarder | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 496 | 2022-12-09 00:03:48 | awarder | 2 | 107671 | 34 | 5.500 | 19576.5 |
| 495 | 2022-12-06 02:58:40 | awarder | 1 | 69583 | 5 | 1.030 | 67556.3 |
| 494 | 2022-11-25 09:39:16 | awarder | 3 | 134027 | 342 | 6.360 | 21073.4 |
| 493 | 2022-09-15 16:19:48 | awarder | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 492 | 2022-09-14 06:47:41 | awarder | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 491 | 2022-08-28 04:27:20 | awarder | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 490 | 2022-08-05 22:33:30 | awarder | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 489 | 2022-07-21 21:04:28 | awarder | 2 | 107671 | 34 | 2.953 | 36461.6 |
| 488 | 2022-07-05 21:06:58 | awarder | 3 | 134027 | 342 | 6.156 | 21771.8 |
| 487 | 2022-07-04 00:11:16 | awarder | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 486 | 2022-04-28 22:36:48 | awarder | 3 | 134027 | 342 | 7.906 | 16952.6 |
| 485 | 2022-04-26 18:24:05 | awarder | 3 | 134027 | 342 | 8.920 | 15025.4 |
| 484 | 2022-04-23 04:18:40 | awarder | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 483 | 2022-04-01 02:42:28 | awarder | 1 | 69583 | 5 | 1.673 | 41591.8 |
| 482 | 2022-01-10 08:06:17 | awarder | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 481 | 2022-01-09 00:23:40 | awarder | 3 | 134027 | 342 | 8.750 | 15317.4 |
| 480 | 2022-01-08 03:39:22 | awarder | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 479 | 2022-01-05 18:40:47 | awarder | 3 | 134027 | 342 | 6.703 | 19995.1 |
| 478 | 2021-12-29 19:00:52 | awarder | 3 | 134027 | 342 | 6.720 | 19944.5 |
| 477 | 2021-12-17 13:33:11 | awarder | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 476 | 2021-10-31 03:56:30 | awarder | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 475 | 2021-09-30 05:04:08 | awarder | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 474 | 2021-09-07 02:11:58 | awarder | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 473 | 2021-06-25 10:28:06 | awarder | 2 | 107671 | 34 | 2.873 | 37476.9 |
| 472 | 2021-06-24 15:15:51 | awarder | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 471 | 2021-06-06 02:52:42 | awarder | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 470 | 2021-06-02 22:14:32 | awarder | 1 | 69583 | 5 | 1.720 | 40455.2 |
| 469 | 2021-05-31 09:46:08 | awarder | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 468 | 2021-05-06 03:41:55 | awarder | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 467 | 2021-04-26 19:52:55 | awarder | 3 | 134027 | 342 | 7.110 | 18850.5 |
| 466 | 2021-04-06 14:44:24 | awarder | 2 | 107671 | 34 | 3.280 | 32826.5 |
| 465 | 2021-03-10 21:18:54 | awarder | 2 | 107671 | 34 | 2.966 | 36301.8 |
| 464 | 2021-02-28 09:58:20 | awarder | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 463 | 2021-02-24 14:55:51 | awarder | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 462 | 2021-02-20 10:46:14 | awarder | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 461 | 2021-02-14 14:08:51 | awarder | 2 | 107671 | 34 | 3.423 | 31455.2 |
| 460 | 2021-01-19 17:13:06 | awarder | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 459 | 2020-11-28 13:37:54 | awarder | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 458 | 2020-11-24 18:51:00 | awarder | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 457 | 2020-10-30 03:17:30 | awarder | 3 | 134027 | 342 | 6.360 | 21073.4 |
| 456 | 2020-10-05 01:02:30 | awarder | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 455 | 2020-08-25 10:43:06 | awarder | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 454 | 2020-07-28 01:41:27 | awarder | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 453 | 2020-06-02 12:05:39 | awarder | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 452 | 2020-05-29 08:40:06 | awarder | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 451 | 2020-05-28 08:53:45 | awarder | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 450 | 2020-05-24 12:07:05 | awarder | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 449 | 2020-05-24 01:09:55 | awarder | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 448 | 2020-05-23 12:39:30 | awarder | 1 | 69583 | 5 | 1.033 | 67360.1 |
| 447 | 2020-05-16 04:29:53 | awarder | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 446 | 2020-05-14 01:54:44 | awarder | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 445 | 2020-05-13 11:26:48 | awarder | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 444 | 2020-05-12 12:09:47 | awarder | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 443 | 2020-05-11 12:52:57 | awarder | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 442 | 2020-05-10 12:09:31 | awarder | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 441 | 2020-05-09 12:07:00 | awarder | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 440 | 2020-05-08 12:06:54 | awarder | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 439 | 2020-05-06 12:08:36 | awarder | 1 | 69583 | 5 | 1.110 | 62687.4 |