History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bassists"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
690 | 2024-04-30 16:14:41 | bassists | 1 | 82945 | 3 | 1.703 | 48705.2 |
689 | 2024-04-10 10:03:03 | bassists | 3 | 146162 | 148 | 14.126 | 10347.0 |
688 | 2024-04-06 19:07:20 | bassists | 1 | 82945 | 3 | 3.376 | 24569.0 |
687 | 2024-04-06 12:16:52 | bassists | 3 | 146162 | 148 | 9.080 | 16097.1 |
686 | 2024-04-05 02:06:19 | bassists | 3 | 146162 | 148 | 14.063 | 10393.4 |
685 | 2024-04-03 14:53:07 | bassists | 3 | 146162 | 148 | 25.096 | 5824.1 |
684 | 2024-04-01 13:33:30 | bassists | 3 | 146162 | 148 | 10.826 | 13501.0 |
683 | 2024-04-01 13:33:27 | bassists | 2 | 121059 | 14 | 11.533 | 10496.7 |
682 | 2024-04-01 11:47:38 | bassists | 3 | 146162 | 148 | 19.926 | 7335.2 |
681 | 2024-04-01 11:47:36 | bassists | 2 | 121059 | 14 | 13.313 | 9093.3 |
680 | 2024-04-01 11:47:16 | bassists | 3 | 146162 | 148 | 17.333 | 8432.6 |
679 | 2024-04-01 11:47:27 | bassists | 1 | 82945 | 3 | 2.716 | 30539.4 |
678 | 2024-04-01 11:47:15 | bassists | 2 | 121059 | 14 | 5.203 | 23267.2 |
677 | 2024-04-01 11:47:10 | bassists | 1 | 82945 | 3 | 1.593 | 52068.4 |
676 | 2024-03-31 12:49:12 | bassists | 1 | 82945 | 3 | 4.893 | 16951.8 |
675 | 2024-03-02 00:15:56 | bassists | 1 | 82945 | 3 | 2.216 | 37430.1 |
674 | 2024-03-01 01:18:57 | bassists | 1 | 82945 | 3 | 1.360 | 60989.0 |
673 | 2024-02-05 01:02:32 | bassists | 2 | 121059 | 14 | 5.076 | 23849.3 |
672 | 2024-02-05 01:01:54 | bassists | 1 | 82945 | 3 | 3.126 | 26533.9 |
671 | 2024-02-04 14:05:59 | bassists | 3 | 146162 | 148 | 18.716 | 7809.5 |
670 | 2024-01-31 14:20:11 | bassists | 1 | 82945 | 3 | 1.500 | 55296.7 |
669 | 2024-01-29 15:01:43 | bassists | 3 | 146162 | 148 | 12.046 | 12133.7 |
668 | 2024-01-29 11:10:13 | bassists | 2 | 121059 | 14 | 3.750 | 32282.4 |
667 | 2024-01-29 11:10:09 | bassists | 3 | 146162 | 148 | 7.266 | 20115.9 |
666 | 2024-01-16 11:09:29 | bassists | 1 | 82945 | 3 | 3.000 | 27648.3 |
665 | 2023-12-27 06:07:46 | bassists | 1 | 82945 | 3 | 1.296 | 64000.8 |
664 | 2023-12-11 22:54:18 | bassists | 3 | 146162 | 148 | 6.313 | 23152.5 |
663 | 2023-11-28 20:53:14 | bassists | 1 | 82945 | 3 | 1.486 | 55817.6 |
662 | 2023-11-28 03:46:43 | bassists | 1 | 82945 | 3 | 1.310 | 63316.8 |
661 | 2023-11-23 13:58:57 | bassists | 1 | 82945 | 3 | 1.296 | 64000.8 |
660 | 2023-11-12 13:21:16 | bassists | 1 | 82945 | 3 | 1.470 | 56425.2 |
659 | 2023-11-09 20:49:29 | bassists | 1 | 82945 | 3 | 1.343 | 61761.0 |
658 | 2023-11-01 07:48:30 | bassists | 1 | 82945 | 3 | 1.390 | 59672.7 |
657 | 2023-09-11 13:52:36 | bassists | 3 | 146162 | 148 | 6.546 | 22328.4 |
656 | 2023-09-11 13:52:35 | bassists | 2 | 121059 | 14 | 3.500 | 34588.3 |
655 | 2023-09-10 15:48:43 | bassists | 3 | 146162 | 148 | 7.296 | 20033.2 |
654 | 2023-09-10 12:03:52 | bassists | 1 | 82945 | 3 | 1.423 | 58288.8 |
653 | 2023-08-31 14:50:33 | bassists | 1 | 82945 | 3 | 1.406 | 58993.6 |
652 | 2023-08-13 04:59:09 | bassists | 1 | 82945 | 3 | 1.280 | 64800.8 |
651 | 2023-06-04 03:39:04 | bassists | 1 | 82945 | 3 | 1.250 | 66356.0 |
650 | 2023-06-02 10:39:59 | bassists | 3 | 146162 | 148 | 6.123 | 23871.0 |
649 | 2023-05-18 14:23:12 | bassists | 3 | 146162 | 148 | 6.140 | 23804.9 |
648 | 2023-05-06 13:46:33 | bassists | 3 | 146162 | 148 | 7.033 | 20782.3 |
647 | 2023-05-05 20:19:44 | bassists | 1 | 82945 | 3 | 1.500 | 55296.7 |
646 | 2023-04-02 06:56:51 | bassists | 3 | 146162 | 148 | 6.110 | 23921.8 |
645 | 2023-03-28 02:31:07 | bassists | 1 | 82945 | 3 | 1.373 | 60411.5 |
644 | 2023-03-08 02:43:41 | bassists | 3 | 146162 | 148 | 6.140 | 23804.9 |
643 | 2023-01-23 13:26:49 | bassists | 1 | 82945 | 3 | 1.440 | 57600.7 |
642 | 2023-01-11 02:51:34 | bassists | 1 | 82945 | 3 | 1.283 | 64649.3 |
641 | 2022-12-23 05:41:07 | bassists | 3 | 146162 | 148 | 6.766 | 21602.4 |
640 | 2022-12-12 20:55:11 | bassists | 3 | 146162 | 148 | 6.580 | 22213.1 |
639 | 2022-12-07 16:15:17 | bassists | 3 | 146162 | 148 | 7.233 | 20207.7 |
638 | 2022-10-29 22:26:03 | bassists | 3 | 146162 | 148 | 7.156 | 20425.1 |
637 | 2022-10-17 14:23:17 | bassists | 1 | 82945 | 3 | 1.373 | 60411.5 |
636 | 2022-10-09 05:13:34 | bassists | 1 | 82945 | 3 | 1.500 | 55296.7 |
635 | 2022-09-28 17:26:52 | bassists | 3 | 146162 | 148 | 7.156 | 20425.1 |
634 | 2022-09-11 16:59:02 | bassists | 1 | 82945 | 3 | 1.390 | 59672.7 |
633 | 2022-08-31 08:57:02 | bassists | 3 | 146162 | 148 | 7.440 | 19645.4 |
632 | 2022-08-03 02:32:29 | bassists | 3 | 146162 | 148 | 6.360 | 22981.4 |
631 | 2022-07-30 08:09:18 | bassists | 1 | 82945 | 3 | 1.313 | 63172.1 |
630 | 2022-07-29 13:36:48 | bassists | 3 | 146162 | 148 | 6.890 | 21213.6 |
629 | 2022-06-22 13:42:51 | bassists | 1 | 82945 | 3 | 1.280 | 64800.8 |
628 | 2022-06-16 05:42:16 | bassists | 1 | 82945 | 3 | 1.300 | 63803.8 |
627 | 2022-06-07 17:30:32 | bassists | 1 | 82945 | 3 | 1.326 | 62552.8 |
626 | 2022-05-31 22:59:10 | bassists | 3 | 146162 | 148 | 6.266 | 23326.2 |
625 | 2022-04-28 21:51:30 | bassists | 3 | 146162 | 148 | 7.890 | 18525.0 |
624 | 2022-04-25 16:58:52 | bassists | 3 | 146162 | 148 | 6.733 | 21708.3 |
623 | 2022-03-12 01:09:14 | bassists | 3 | 146162 | 148 | 6.296 | 23215.1 |
622 | 2022-03-06 21:29:15 | bassists | 3 | 146162 | 148 | 7.343 | 19904.9 |
621 | 2022-03-03 06:12:37 | bassists | 1 | 82945 | 3 | 1.466 | 56579.1 |
620 | 2022-02-24 01:29:35 | bassists | 1 | 82945 | 3 | 1.466 | 56579.1 |
619 | 2021-12-08 21:54:54 | bassists | 1 | 82945 | 3 | 1.610 | 51518.6 |
618 | 2021-11-23 01:13:39 | bassists | 1 | 82945 | 3 | 1.453 | 57085.3 |
617 | 2021-10-30 13:29:06 | bassists | 1 | 82945 | 3 | 1.470 | 56425.2 |
616 | 2021-08-23 11:07:34 | bassists | 1 | 82945 | 3 | 1.280 | 64800.8 |
615 | 2021-07-28 20:51:59 | bassists | 3 | 146162 | 148 | 7.766 | 18820.8 |
614 | 2021-07-18 20:45:52 | bassists | 3 | 146162 | 148 | 7.126 | 20511.1 |
613 | 2021-07-05 06:18:33 | bassists | 1 | 82945 | 3 | 1.343 | 61761.0 |
612 | 2021-07-04 22:42:05 | bassists | 3 | 146162 | 148 | 7.690 | 19006.8 |
611 | 2021-06-09 08:58:00 | bassists | 3 | 146162 | 148 | 6.220 | 23498.7 |
610 | 2021-05-16 00:43:32 | bassists | 1 | 82945 | 3 | 1.453 | 57085.3 |
609 | 2021-05-12 16:36:31 | bassists | 1 | 82945 | 3 | 1.500 | 55296.7 |
608 | 2021-04-19 08:13:55 | bassists | 1 | 82945 | 3 | 2.720 | 30494.5 |
607 | 2021-04-16 04:41:13 | bassists | 3 | 146162 | 148 | 7.500 | 19488.3 |
606 | 2021-04-12 08:28:17 | bassists | 3 | 146162 | 148 | 6.966 | 20982.2 |
605 | 2021-04-04 18:37:09 | bassists | 1 | 82945 | 3 | 1.610 | 51518.6 |
604 | 2021-03-21 08:51:22 | bassists | 2 | 121059 | 14 | 3.516 | 34430.9 |
603 | 2021-03-18 09:15:55 | bassists | 3 | 146162 | 148 | 6.593 | 22169.3 |
602 | 2021-02-21 06:05:53 | bassists | 3 | 146162 | 148 | 6.283 | 23263.1 |
601 | 2021-02-12 19:28:00 | bassists | 1 | 82945 | 3 | 1.296 | 64000.8 |
600 | 2021-02-08 17:19:06 | bassists | 1 | 82945 | 3 | 1.313 | 63172.1 |
599 | 2021-01-31 08:04:45 | bassists | 3 | 146162 | 148 | 6.296 | 23215.1 |
598 | 2021-01-30 23:56:59 | bassists | 2 | 121059 | 14 | 3.283 | 36874.5 |
597 | 2021-01-04 00:33:51 | bassists | 1 | 82945 | 3 | 1.283 | 64649.3 |
596 | 2020-12-29 09:45:23 | bassists | 3 | 146162 | 148 | 6.376 | 22923.8 |
595 | 2020-12-29 09:45:19 | bassists | 2 | 121059 | 14 | 3.563 | 33976.7 |
594 | 2020-12-29 09:45:17 | bassists | 1 | 82945 | 3 | 1.436 | 57761.1 |
593 | 2020-12-15 02:57:51 | bassists | 3 | 146162 | 148 | 6.236 | 23438.4 |
592 | 2020-11-06 23:23:40 | bassists | 1 | 82945 | 3 | 1.326 | 62552.8 |
591 | 2020-10-31 23:31:30 | bassists | 1 | 82945 | 3 | 1.326 | 62552.8 |