History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"schlubs"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 640 | 2024-04-27 11:45:11 | schlubs | 1 | 69583 | 3 | 1.610 | 43219.3 |
| 639 | 2024-04-26 11:13:24 | schlubs | 3 | 134027 | 111 | 7.140 | 18771.3 |
| 638 | 2024-04-24 17:28:18 | schlubs | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 637 | 2024-04-13 17:10:10 | schlubs | 2 | 107671 | 14 | 3.673 | 29314.2 |
| 636 | 2024-04-11 14:30:42 | schlubs | 3 | 134027 | 111 | 7.686 | 17437.8 |
| 635 | 2024-04-11 14:30:40 | schlubs | 2 | 107671 | 14 | 4.140 | 26007.5 |
| 634 | 2024-04-11 14:30:38 | schlubs | 1 | 69583 | 3 | 2.123 | 32775.8 |
| 633 | 2024-03-31 14:29:12 | schlubs | 1 | 69583 | 3 | 2.783 | 25002.9 |
| 632 | 2024-03-29 11:39:54 | schlubs | 1 | 69583 | 3 | 4.280 | 16257.7 |
| 631 | 2024-03-10 09:04:33 | schlubs | 1 | 69583 | 3 | 3.326 | 20920.9 |
| 630 | 2024-03-04 12:24:44 | schlubs | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 629 | 2024-02-28 04:56:46 | schlubs | 1 | 69583 | 3 | 3.560 | 19545.8 |
| 628 | 2024-01-03 00:51:56 | schlubs | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 627 | 2023-12-20 00:49:20 | schlubs | 3 | 134027 | 111 | 7.656 | 17506.1 |
| 626 | 2023-12-13 21:31:45 | schlubs | 2 | 107671 | 14 | 3.466 | 31064.9 |
| 625 | 2023-12-13 21:31:41 | schlubs | 3 | 134027 | 111 | 7.160 | 18718.9 |
| 624 | 2023-12-12 12:38:57 | schlubs | 2 | 107671 | 14 | 3.080 | 34958.1 |
| 623 | 2023-11-22 07:44:14 | schlubs | 1 | 69583 | 3 | 2.576 | 27012.0 |
| 622 | 2023-11-11 09:52:24 | schlubs | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 621 | 2023-11-04 00:33:11 | schlubs | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 620 | 2023-11-02 06:15:50 | schlubs | 1 | 69583 | 3 | 2.470 | 28171.3 |
| 619 | 2023-10-24 02:06:32 | schlubs | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 618 | 2023-10-01 19:45:27 | schlubs | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 617 | 2023-09-29 13:53:44 | schlubs | 1 | 69583 | 3 | 1.486 | 46825.7 |
| 616 | 2023-09-26 08:52:33 | schlubs | 3 | 134027 | 111 | 6.360 | 21073.4 |
| 615 | 2023-09-20 20:37:41 | schlubs | 3 | 134027 | 111 | 6.143 | 21817.8 |
| 614 | 2023-09-12 01:56:54 | schlubs | 2 | 107671 | 14 | 5.003 | 21521.3 |
| 613 | 2023-08-18 22:37:55 | schlubs | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 612 | 2023-08-17 03:33:04 | schlubs | 3 | 134027 | 111 | 6.283 | 21331.7 |
| 611 | 2023-08-12 17:21:03 | schlubs | 2 | 107671 | 14 | 2.810 | 38317.1 |
| 610 | 2023-06-28 05:54:44 | schlubs | 3 | 134027 | 111 | 5.643 | 23751.0 |
| 609 | 2023-06-04 10:10:09 | schlubs | 2 | 107671 | 14 | 2.703 | 39833.9 |
| 608 | 2023-05-20 06:43:09 | schlubs | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 607 | 2023-05-20 01:52:42 | schlubs | 2 | 107671 | 14 | 3.126 | 34443.7 |
| 606 | 2023-05-08 22:51:15 | schlubs | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 605 | 2023-05-05 07:12:13 | schlubs | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 604 | 2023-04-09 07:17:05 | schlubs | 2 | 107671 | 14 | 3.203 | 33615.7 |
| 603 | 2023-04-03 07:44:21 | schlubs | 3 | 134027 | 111 | 6.346 | 21119.9 |
| 602 | 2023-03-23 16:03:54 | schlubs | 3 | 134027 | 111 | 6.046 | 22167.9 |
| 601 | 2023-03-18 11:08:07 | schlubs | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 600 | 2023-03-12 12:11:11 | schlubs | 2 | 107671 | 14 | 2.783 | 38688.8 |
| 599 | 2023-01-26 21:10:00 | schlubs | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 598 | 2023-01-17 22:09:12 | schlubs | 3 | 134027 | 111 | 5.813 | 23056.4 |
| 597 | 2023-01-07 18:58:47 | schlubs | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 596 | 2022-12-24 04:28:52 | schlubs | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 595 | 2022-12-22 09:27:26 | schlubs | 3 | 134027 | 111 | 5.846 | 22926.3 |
| 594 | 2022-12-17 01:46:20 | schlubs | 2 | 107671 | 14 | 3.110 | 34620.9 |
| 593 | 2022-12-16 10:41:24 | schlubs | 3 | 134027 | 111 | 6.670 | 20094.0 |
| 592 | 2022-12-12 16:16:44 | schlubs | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 591 | 2022-12-11 13:12:39 | schlubs | 3 | 134027 | 111 | 5.500 | 24368.5 |
| 590 | 2022-11-16 07:53:17 | schlubs | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 589 | 2022-11-09 00:31:27 | schlubs | 3 | 134027 | 111 | 5.660 | 23679.7 |
| 588 | 2022-10-06 06:42:21 | schlubs | 3 | 134027 | 111 | 5.763 | 23256.5 |
| 587 | 2022-10-02 16:58:01 | schlubs | 3 | 134027 | 111 | 6.623 | 20236.6 |
| 586 | 2022-09-29 21:19:11 | schlubs | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 585 | 2022-09-28 02:26:38 | schlubs | 3 | 134027 | 111 | 5.580 | 24019.2 |
| 584 | 2022-08-18 21:25:56 | schlubs | 3 | 134027 | 111 | 5.656 | 23696.4 |
| 583 | 2022-08-09 00:18:30 | schlubs | 2 | 107671 | 14 | 3.080 | 34958.1 |
| 582 | 2022-08-06 16:04:33 | schlubs | 2 | 107671 | 14 | 2.873 | 37476.9 |
| 581 | 2022-07-31 12:21:23 | schlubs | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 580 | 2022-05-11 20:05:21 | schlubs | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 579 | 2022-03-25 03:26:32 | schlubs | 2 | 107671 | 14 | 3.550 | 30329.9 |
| 578 | 2022-03-14 18:27:19 | schlubs | 3 | 134027 | 111 | 6.673 | 20085.0 |
| 577 | 2022-03-12 14:07:01 | schlubs | 3 | 134027 | 111 | 6.936 | 19323.4 |
| 576 | 2022-02-23 21:45:36 | schlubs | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 575 | 2022-02-03 14:12:33 | schlubs | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 574 | 2022-01-30 20:58:37 | schlubs | 1 | 69583 | 3 | 2.466 | 28217.0 |
| 573 | 2021-12-30 12:15:55 | schlubs | 1 | 69583 | 3 | 1.453 | 47889.2 |
| 572 | 2021-12-09 16:24:13 | schlubs | 3 | 134027 | 111 | 6.330 | 21173.3 |
| 571 | 2021-12-01 23:50:01 | schlubs | 3 | 134027 | 111 | 8.470 | 15823.7 |
| 570 | 2021-11-23 22:19:02 | schlubs | 1 | 69583 | 3 | 2.470 | 28171.3 |
| 569 | 2021-11-10 04:59:33 | schlubs | 3 | 134027 | 111 | 7.343 | 18252.3 |
| 568 | 2021-11-06 20:39:46 | schlubs | 3 | 134027 | 111 | 8.266 | 16214.3 |
| 567 | 2021-10-30 16:48:45 | schlubs | 3 | 134027 | 111 | 6.656 | 20136.3 |
| 566 | 2021-10-29 15:28:37 | schlubs | 3 | 134027 | 111 | 6.656 | 20136.3 |
| 565 | 2021-10-10 11:22:57 | schlubs | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 564 | 2021-10-07 14:25:39 | schlubs | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 563 | 2021-09-05 11:50:44 | schlubs | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 562 | 2021-08-18 22:07:13 | schlubs | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 561 | 2021-07-03 06:19:16 | schlubs | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 560 | 2021-06-16 21:58:38 | schlubs | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 559 | 2021-06-08 21:33:57 | schlubs | 3 | 134027 | 111 | 5.813 | 23056.4 |
| 558 | 2021-06-06 17:49:15 | schlubs | 3 | 134027 | 111 | 15.203 | 8815.8 |
| 557 | 2021-06-06 14:52:05 | schlubs | 3 | 134027 | 111 | 6.076 | 22058.4 |
| 556 | 2021-06-06 00:27:02 | schlubs | 3 | 134027 | 111 | 5.766 | 23244.4 |
| 555 | 2021-06-05 15:07:27 | schlubs | 3 | 134027 | 111 | 6.690 | 20033.9 |
| 554 | 2021-06-05 06:06:53 | schlubs | 3 | 134027 | 111 | 6.450 | 20779.4 |
| 553 | 2021-06-04 08:14:38 | schlubs | 3 | 134027 | 111 | 6.860 | 19537.5 |
| 552 | 2021-06-04 01:40:16 | schlubs | 3 | 134027 | 111 | 6.343 | 21129.9 |
| 551 | 2021-06-03 17:09:35 | schlubs | 3 | 134027 | 111 | 5.690 | 23554.8 |
| 550 | 2021-06-02 20:34:50 | schlubs | 3 | 134027 | 111 | 5.936 | 22578.7 |
| 549 | 2021-06-02 06:38:54 | schlubs | 3 | 134027 | 111 | 5.623 | 23835.5 |
| 548 | 2021-06-01 16:20:59 | schlubs | 3 | 134027 | 111 | 6.703 | 19995.1 |
| 547 | 2021-06-01 06:21:27 | schlubs | 3 | 134027 | 111 | 6.466 | 20728.0 |
| 546 | 2021-05-31 14:59:14 | schlubs | 3 | 134027 | 111 | 6.953 | 19276.1 |
| 545 | 2021-05-30 22:58:18 | schlubs | 3 | 134027 | 111 | 6.283 | 21331.7 |
| 544 | 2021-05-30 03:56:18 | schlubs | 3 | 134027 | 111 | 6.470 | 20715.1 |
| 543 | 2021-05-29 17:49:00 | schlubs | 2 | 107671 | 14 | 3.356 | 32083.1 |
| 542 | 2021-05-29 17:44:13 | schlubs | 3 | 134027 | 111 | 6.610 | 20276.4 |
| 541 | 2021-05-29 05:37:52 | schlubs | 3 | 134027 | 111 | 5.783 | 23176.0 |