History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"parishes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
700 | 2024-04-27 08:42:24 | parishes | 1 | 82945 | 4 | 1.813 | 45750.1 |
699 | 2024-04-26 01:13:55 | parishes | 2 | 121059 | 40 | 4.783 | 25310.3 |
698 | 2024-04-25 23:52:34 | parishes | 2 | 121059 | 40 | 8.266 | 14645.4 |
697 | 2024-04-22 22:52:07 | parishes | 3 | 146162 | 378 | 6.970 | 20970.2 |
696 | 2024-04-22 22:50:33 | parishes | 3 | 146162 | 378 | 7.530 | 19410.6 |
695 | 2024-04-22 22:50:04 | parishes | 1 | 82945 | 4 | 1.483 | 55930.5 |
694 | 2024-04-22 22:49:08 | parishes | 1 | 82945 | 4 | 2.283 | 36331.6 |
693 | 2024-04-16 07:19:41 | parishes | 1 | 82945 | 4 | 1.343 | 61761.0 |
692 | 2024-04-10 21:56:19 | parishes | 2 | 121059 | 40 | 13.000 | 9312.2 |
691 | 2024-04-10 07:31:33 | parishes | 2 | 121059 | 40 | 5.563 | 21761.5 |
690 | 2024-04-08 22:08:58 | parishes | 3 | 146162 | 378 | 22.706 | 6437.2 |
689 | 2024-04-08 09:06:00 | parishes | 1 | 82945 | 4 | 5.030 | 16490.1 |
688 | 2024-04-08 05:32:06 | parishes | 2 | 121059 | 40 | 16.406 | 7378.9 |
687 | 2024-04-08 03:46:50 | parishes | 3 | 146162 | 378 | 9.063 | 16127.3 |
686 | 2024-04-07 22:32:01 | parishes | 3 | 146162 | 378 | 16.466 | 8876.6 |
685 | 2024-04-06 19:26:22 | parishes | 3 | 146162 | 378 | 39.503 | 3700.0 |
684 | 2024-04-06 10:55:57 | parishes | 3 | 146162 | 378 | 9.406 | 15539.2 |
683 | 2024-04-06 10:55:54 | parishes | 1 | 82945 | 4 | 3.313 | 25036.2 |
682 | 2024-03-11 03:53:31 | parishes | 2 | 121059 | 40 | 4.220 | 28687.0 |
681 | 2024-03-08 22:34:48 | parishes | 2 | 121059 | 40 | 4.330 | 27958.2 |
680 | 2024-03-08 22:34:44 | parishes | 1 | 82945 | 4 | 1.610 | 51518.6 |
679 | 2024-03-08 22:34:04 | parishes | 3 | 146162 | 378 | 8.796 | 16616.9 |
678 | 2024-03-07 11:34:08 | parishes | 3 | 146162 | 378 | 16.406 | 8909.1 |
677 | 2024-03-07 03:46:48 | parishes | 3 | 146162 | 378 | 30.376 | 4811.8 |
676 | 2024-03-05 18:38:54 | parishes | 3 | 146162 | 378 | 13.000 | 11243.2 |
675 | 2024-03-05 18:38:51 | parishes | 2 | 121059 | 40 | 13.750 | 8804.3 |
674 | 2024-03-05 16:56:28 | parishes | 1 | 82945 | 4 | 3.626 | 22875.1 |
673 | 2024-02-15 07:04:11 | parishes | 1 | 82945 | 4 | 1.436 | 57761.1 |
672 | 2024-01-31 12:31:36 | parishes | 1 | 82945 | 4 | 1.436 | 57761.1 |
671 | 2024-01-10 13:19:14 | parishes | 1 | 82945 | 4 | 1.530 | 54212.4 |
670 | 2024-01-03 03:57:19 | parishes | 3 | 146162 | 378 | 6.766 | 21602.4 |
669 | 2023-12-22 02:36:51 | parishes | 3 | 146162 | 378 | 10.250 | 14259.7 |
668 | 2023-12-22 02:36:49 | parishes | 2 | 121059 | 40 | 6.436 | 18809.7 |
667 | 2023-12-02 15:18:20 | parishes | 1 | 82945 | 4 | 1.466 | 56579.1 |
666 | 2023-12-01 09:47:58 | parishes | 1 | 82945 | 4 | 1.500 | 55296.7 |
665 | 2023-11-21 14:04:06 | parishes | 1 | 82945 | 4 | 1.313 | 63172.1 |
664 | 2023-10-31 21:48:26 | parishes | 1 | 82945 | 4 | 1.470 | 56425.2 |
663 | 2023-10-29 17:31:37 | parishes | 1 | 82945 | 4 | 1.486 | 55817.6 |
662 | 2023-10-25 09:50:27 | parishes | 1 | 82945 | 4 | 1.360 | 60989.0 |
661 | 2023-10-16 16:29:52 | parishes | 1 | 82945 | 4 | 1.390 | 59672.7 |
660 | 2023-09-29 21:12:37 | parishes | 1 | 82945 | 4 | 1.313 | 63172.1 |
659 | 2023-09-17 20:14:30 | parishes | 1 | 82945 | 4 | 1.406 | 58993.6 |
658 | 2023-09-16 00:27:08 | parishes | 1 | 82945 | 4 | 1.486 | 55817.6 |
657 | 2023-09-15 01:37:11 | parishes | 1 | 82945 | 4 | 1.346 | 61623.3 |
656 | 2023-07-06 02:02:50 | parishes | 1 | 82945 | 4 | 1.373 | 60411.5 |
655 | 2023-06-03 23:43:37 | parishes | 1 | 82945 | 4 | 1.283 | 64649.3 |
654 | 2023-04-13 02:31:02 | parishes | 1 | 82945 | 4 | 1.313 | 63172.1 |
653 | 2023-03-02 22:35:11 | parishes | 1 | 82945 | 4 | 1.436 | 57761.1 |
652 | 2023-02-22 11:44:47 | parishes | 1 | 82945 | 4 | 1.280 | 64800.8 |
651 | 2023-02-04 03:15:17 | parishes | 1 | 82945 | 4 | 1.280 | 64800.8 |
650 | 2023-01-04 12:05:01 | parishes | 1 | 82945 | 4 | 1.453 | 57085.3 |
649 | 2022-12-02 16:23:50 | parishes | 1 | 82945 | 4 | 1.266 | 65517.4 |
648 | 2022-11-18 20:06:49 | parishes | 1 | 82945 | 4 | 1.560 | 53169.9 |
647 | 2022-11-08 22:58:50 | parishes | 1 | 82945 | 4 | 1.373 | 60411.5 |
646 | 2022-07-27 05:30:44 | parishes | 1 | 82945 | 4 | 1.470 | 56425.2 |
645 | 2022-07-24 22:08:19 | parishes | 1 | 82945 | 4 | 1.296 | 64000.8 |
644 | 2022-07-19 15:22:58 | parishes | 1 | 82945 | 4 | 2.873 | 28870.5 |
643 | 2022-03-25 13:12:29 | parishes | 1 | 82945 | 4 | 1.313 | 63172.1 |
642 | 2022-03-17 15:27:50 | parishes | 1 | 82945 | 4 | 1.376 | 60279.8 |
641 | 2021-12-25 18:26:21 | parishes | 1 | 82945 | 4 | 1.466 | 56579.1 |
640 | 2021-12-11 11:16:30 | parishes | 1 | 82945 | 4 | 1.576 | 52630.1 |
639 | 2021-10-28 12:36:30 | parishes | 1 | 82945 | 4 | 1.546 | 53651.4 |
638 | 2021-09-21 01:36:12 | parishes | 1 | 82945 | 4 | 1.453 | 57085.3 |
637 | 2021-09-18 22:44:35 | parishes | 1 | 82945 | 4 | 1.533 | 54106.3 |
636 | 2021-09-17 01:50:00 | parishes | 3 | 146162 | 378 | 7.563 | 19325.9 |
635 | 2021-09-13 20:09:15 | parishes | 3 | 146162 | 378 | 6.670 | 21913.3 |
634 | 2021-09-07 09:40:26 | parishes | 1 | 82945 | 4 | 1.406 | 58993.6 |
633 | 2021-09-01 10:31:30 | parishes | 1 | 82945 | 4 | 1.500 | 55296.7 |
632 | 2021-07-20 13:11:02 | parishes | 2 | 121059 | 40 | 3.856 | 31395.0 |
631 | 2021-06-06 11:29:08 | parishes | 1 | 82945 | 4 | 1.610 | 51518.6 |
630 | 2021-06-03 06:48:06 | parishes | 1 | 82945 | 4 | 1.343 | 61761.0 |
629 | 2021-05-23 18:36:00 | parishes | 1 | 82945 | 4 | 1.486 | 55817.6 |
628 | 2021-05-09 19:58:53 | parishes | 2 | 121059 | 40 | 3.703 | 32692.1 |
627 | 2021-04-30 09:32:02 | parishes | 1 | 82945 | 4 | 1.530 | 54212.4 |
626 | 2021-04-26 16:18:26 | parishes | 1 | 82945 | 4 | 1.500 | 55296.7 |
625 | 2021-04-08 10:48:44 | parishes | 2 | 121059 | 40 | 7.393 | 16374.8 |
624 | 2021-02-28 19:19:44 | parishes | 3 | 146162 | 378 | 6.516 | 22431.2 |
623 | 2021-02-26 17:12:47 | parishes | 3 | 146162 | 378 | 6.533 | 22372.9 |
622 | 2021-02-24 15:08:14 | parishes | 1 | 82945 | 4 | 1.423 | 58288.8 |
621 | 2021-02-22 13:38:17 | parishes | 1 | 82945 | 4 | 1.343 | 61761.0 |
620 | 2021-01-23 09:33:31 | parishes | 2 | 121059 | 40 | 3.373 | 35890.6 |
619 | 2021-01-15 19:51:26 | parishes | 3 | 146162 | 378 | 6.733 | 21708.3 |
618 | 2021-01-10 04:50:38 | parishes | 1 | 82945 | 4 | 1.296 | 64000.8 |
617 | 2020-11-09 19:05:38 | parishes | 1 | 82945 | 4 | 1.313 | 63172.1 |
616 | 2020-11-02 08:24:40 | parishes | 1 | 82945 | 4 | 1.360 | 60989.0 |
615 | 2020-11-01 19:20:39 | parishes | 1 | 82945 | 4 | 1.500 | 55296.7 |
614 | 2020-10-30 13:42:40 | parishes | 1 | 82945 | 4 | 1.530 | 54212.4 |
613 | 2020-10-28 20:41:01 | parishes | 1 | 82945 | 4 | 1.486 | 55817.6 |
612 | 2020-10-23 13:27:27 | parishes | 2 | 121059 | 40 | 3.360 | 36029.5 |
611 | 2020-10-17 08:12:16 | parishes | 3 | 146162 | 378 | 7.610 | 19206.6 |
610 | 2020-10-16 14:19:40 | parishes | 3 | 146162 | 378 | 7.966 | 18348.2 |
609 | 2020-10-15 14:17:17 | parishes | 3 | 146162 | 378 | 6.763 | 21612.0 |
608 | 2020-10-09 00:32:51 | parishes | 2 | 121059 | 40 | 3.280 | 36908.2 |
607 | 2020-09-28 12:48:59 | parishes | 1 | 82945 | 4 | 1.373 | 60411.5 |
606 | 2020-09-14 15:39:36 | parishes | 3 | 146162 | 378 | 7.173 | 20376.7 |
605 | 2020-08-30 06:30:11 | parishes | 2 | 121059 | 40 | 4.986 | 24279.8 |
604 | 2020-08-25 09:51:49 | parishes | 3 | 146162 | 378 | 6.936 | 21073.0 |
603 | 2020-08-21 18:20:57 | parishes | 1 | 82945 | 4 | 1.313 | 63172.1 |
602 | 2020-08-19 09:50:43 | parishes | 1 | 82945 | 4 | 1.440 | 57600.7 |
601 | 2020-08-04 04:41:44 | parishes | 1 | 82945 | 4 | 1.436 | 57761.1 |