History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pizza"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
772 | 2024-04-16 00:38:17 | pizza | 2 | 53800 | 29 | 1.423 | 37807.4 |
771 | 2024-04-06 06:01:40 | pizza | 1 | 28756 | 4 | 1.080 | 26625.9 |
770 | 2024-03-31 15:41:54 | pizza | 1 | 28756 | 4 | 1.000 | 28756.0 |
769 | 2024-03-28 20:51:15 | pizza | 1 | 28756 | 4 | 0.530 | 54256.6 |
768 | 2024-03-07 04:33:40 | pizza | 1 | 28756 | 4 | 0.563 | 51076.4 |
767 | 2024-03-01 23:19:28 | pizza | 1 | 28756 | 4 | 0.500 | 57512.0 |
766 | 2024-03-01 13:07:52 | pizza | 1 | 28756 | 4 | 0.500 | 57512.0 |
765 | 2024-02-25 19:07:56 | pizza | 1 | 28756 | 4 | 0.436 | 65954.1 |
764 | 2024-02-21 21:02:31 | pizza | 1 | 28756 | 4 | 0.453 | 63479.0 |
763 | 2024-02-03 20:43:07 | pizza | 1 | 28756 | 4 | 1.000 | 28756.0 |
762 | 2024-01-29 09:51:55 | pizza | 1 | 28756 | 4 | 0.500 | 57512.0 |
761 | 2024-01-26 01:19:37 | pizza | 1 | 28756 | 4 | 0.516 | 55728.7 |
760 | 2023-12-30 22:50:44 | pizza | 2 | 53800 | 29 | 1.660 | 32409.6 |
759 | 2023-12-12 05:22:58 | pizza | 2 | 53800 | 29 | 1.623 | 33148.5 |
758 | 2023-12-10 01:49:36 | pizza | 1 | 28756 | 4 | 0.483 | 59536.2 |
757 | 2023-12-01 06:00:50 | pizza | 3 | 83667 | 369 | 4.190 | 19968.3 |
756 | 2023-11-13 13:44:50 | pizza | 1 | 28756 | 4 | 0.436 | 65954.1 |
755 | 2023-11-10 00:37:38 | pizza | 3 | 83667 | 369 | 8.296 | 10085.2 |
754 | 2023-11-10 00:25:34 | pizza | 2 | 53800 | 29 | 1.513 | 35558.5 |
753 | 2023-11-08 19:19:42 | pizza | 1 | 28756 | 4 | 0.483 | 59536.2 |
752 | 2023-11-03 07:13:56 | pizza | 2 | 53800 | 29 | 1.376 | 39098.8 |
751 | 2023-10-27 02:35:15 | pizza | 1 | 28756 | 4 | 0.436 | 65954.1 |
750 | 2023-10-26 03:36:11 | pizza | 3 | 83667 | 369 | 4.156 | 20131.6 |
749 | 2023-10-25 02:49:52 | pizza | 3 | 83667 | 369 | 3.923 | 21327.3 |
748 | 2023-10-20 18:37:28 | pizza | 2 | 53800 | 29 | 3.656 | 14715.5 |
747 | 2023-10-20 18:29:08 | pizza | 1 | 28756 | 4 | 0.563 | 51076.4 |
746 | 2023-10-20 07:38:06 | pizza | 3 | 83667 | 369 | 4.563 | 18336.0 |
745 | 2023-10-17 14:13:03 | pizza | 2 | 53800 | 29 | 2.593 | 20748.2 |
744 | 2023-10-17 14:08:30 | pizza | 1 | 28756 | 4 | 0.890 | 32310.1 |
743 | 2023-10-17 06:39:08 | pizza | 3 | 83667 | 369 | 4.203 | 19906.5 |
742 | 2023-10-13 12:04:34 | pizza | 2 | 53800 | 29 | 1.640 | 32804.9 |
741 | 2023-10-13 11:59:24 | pizza | 3 | 83667 | 369 | 3.780 | 22134.1 |
740 | 2023-10-13 05:29:47 | pizza | 1 | 28756 | 4 | 0.436 | 65954.1 |
739 | 2023-10-11 09:26:16 | pizza | 1 | 28756 | 4 | 0.486 | 59168.7 |
738 | 2023-10-09 17:37:18 | pizza | 1 | 28756 | 4 | 0.516 | 55728.7 |
737 | 2023-10-03 10:06:32 | pizza | 3 | 83667 | 369 | 4.673 | 17904.3 |
736 | 2023-10-03 10:06:25 | pizza | 2 | 53800 | 29 | 1.810 | 29723.8 |
735 | 2023-10-03 09:53:23 | pizza | 1 | 28756 | 4 | 0.483 | 59536.2 |
734 | 2023-09-24 02:41:41 | pizza | 1 | 28756 | 4 | 0.453 | 63479.0 |
733 | 2023-09-21 08:27:40 | pizza | 2 | 53800 | 29 | 2.343 | 22962.0 |
732 | 2023-09-21 07:46:44 | pizza | 3 | 83667 | 369 | 4.123 | 20292.7 |
731 | 2023-09-21 07:39:34 | pizza | 1 | 28756 | 4 | 0.436 | 65954.1 |
730 | 2023-09-12 19:24:51 | pizza | 3 | 83667 | 369 | 3.640 | 22985.4 |
729 | 2023-09-12 19:24:51 | pizza | 2 | 53800 | 29 | 1.640 | 32804.9 |
728 | 2023-09-11 22:25:29 | pizza | 2 | 53800 | 29 | 1.580 | 34050.6 |
727 | 2023-09-10 13:17:56 | pizza | 1 | 28756 | 4 | 0.436 | 65954.1 |
726 | 2023-07-16 23:21:14 | pizza | 1 | 28756 | 4 | 0.500 | 57512.0 |
725 | 2023-06-12 23:31:21 | pizza | 1 | 28756 | 4 | 0.436 | 65954.1 |
724 | 2023-06-03 12:04:56 | pizza | 2 | 53800 | 29 | 1.343 | 40059.6 |
723 | 2023-04-19 08:16:31 | pizza | 1 | 28756 | 4 | 0.453 | 63479.0 |
722 | 2023-03-11 08:40:43 | pizza | 2 | 53800 | 29 | 1.343 | 40059.6 |
721 | 2023-02-11 10:33:50 | pizza | 1 | 28756 | 4 | 0.500 | 57512.0 |
720 | 2023-02-07 18:53:58 | pizza | 1 | 28756 | 4 | 0.436 | 65954.1 |
719 | 2023-01-02 09:27:12 | pizza | 1 | 28756 | 4 | 0.470 | 61183.0 |
718 | 2022-12-15 00:36:44 | pizza | 2 | 53800 | 29 | 1.326 | 40573.2 |
717 | 2022-12-08 14:19:19 | pizza | 1 | 28756 | 4 | 0.423 | 67981.1 |
716 | 2022-11-21 02:56:48 | pizza | 1 | 28756 | 4 | 0.530 | 54256.6 |
715 | 2022-10-06 16:25:22 | pizza | 1 | 28756 | 4 | 0.486 | 59168.7 |
714 | 2022-10-03 02:13:02 | pizza | 1 | 28756 | 4 | 0.500 | 57512.0 |
713 | 2022-09-07 04:39:27 | pizza | 1 | 28756 | 4 | 0.516 | 55728.7 |
712 | 2022-09-02 04:17:08 | pizza | 1 | 28756 | 4 | 0.436 | 65954.1 |
711 | 2022-08-08 03:00:54 | pizza | 1 | 28756 | 4 | 0.440 | 65354.5 |
710 | 2022-07-15 05:07:20 | pizza | 3 | 83667 | 369 | 3.250 | 25743.7 |
709 | 2022-07-02 12:54:46 | pizza | 2 | 53800 | 29 | 1.360 | 39558.8 |
708 | 2022-06-30 08:45:12 | pizza | 2 | 53800 | 29 | 1.373 | 39184.3 |
707 | 2022-06-01 23:56:46 | pizza | 1 | 28756 | 4 | 0.440 | 65354.5 |
706 | 2022-05-29 19:33:16 | pizza | 1 | 28756 | 4 | 0.453 | 63479.0 |
705 | 2022-03-30 17:40:29 | pizza | 1 | 28756 | 4 | 0.483 | 59536.2 |
704 | 2022-02-09 11:53:52 | pizza | 2 | 53800 | 29 | 1.360 | 39558.8 |
703 | 2022-02-01 01:45:06 | pizza | 1 | 28756 | 4 | 0.530 | 54256.6 |
702 | 2022-01-03 12:41:52 | pizza | 1 | 28756 | 4 | 0.640 | 44931.3 |
701 | 2021-11-27 00:27:36 | pizza | 2 | 53800 | 29 | 1.983 | 27130.6 |
700 | 2021-11-05 22:56:57 | pizza | 1 | 28756 | 4 | 0.436 | 65954.1 |
699 | 2021-11-03 21:35:07 | pizza | 1 | 28756 | 4 | 1.046 | 27491.4 |
698 | 2021-10-11 21:26:10 | pizza | 1 | 28756 | 4 | 0.493 | 58328.6 |
697 | 2021-09-23 09:43:06 | pizza | 1 | 28756 | 4 | 0.483 | 59536.2 |
696 | 2021-09-03 23:23:21 | pizza | 1 | 28756 | 4 | 0.500 | 57512.0 |
695 | 2021-08-15 05:04:44 | pizza | 1 | 28756 | 4 | 0.466 | 61708.2 |
694 | 2021-07-28 03:53:43 | pizza | 1 | 28756 | 4 | 0.453 | 63479.0 |
693 | 2021-07-10 11:15:02 | pizza | 1 | 28756 | 4 | 0.436 | 65954.1 |
692 | 2021-05-18 22:51:48 | pizza | 1 | 28756 | 4 | 0.563 | 51076.4 |
691 | 2021-04-18 20:57:06 | pizza | 1 | 28756 | 4 | 0.516 | 55728.7 |
690 | 2021-04-06 15:38:10 | pizza | 1 | 28756 | 4 | 0.516 | 55728.7 |
689 | 2021-04-02 11:40:16 | pizza | 1 | 28756 | 4 | 0.486 | 59168.7 |
688 | 2021-03-21 17:17:05 | pizza | 1 | 28756 | 4 | 0.500 | 57512.0 |
687 | 2021-01-03 15:08:56 | pizza | 1 | 28756 | 4 | 0.486 | 59168.7 |
686 | 2020-12-17 16:56:03 | pizza | 1 | 28756 | 4 | 0.623 | 46157.3 |
685 | 2020-11-13 02:03:14 | pizza | 1 | 28756 | 4 | 0.576 | 49923.6 |
684 | 2020-10-26 23:34:59 | pizza | 1 | 28756 | 4 | 0.440 | 65354.5 |
683 | 2020-10-16 08:34:42 | pizza | 1 | 28756 | 4 | 0.453 | 63479.0 |
682 | 2020-10-08 06:37:08 | pizza | 1 | 28756 | 4 | 0.453 | 63479.0 |
681 | 2020-09-13 19:16:15 | pizza | 1 | 28756 | 4 | 0.500 | 57512.0 |
680 | 2020-06-21 07:14:41 | pizza | 1 | 28756 | 4 | 0.470 | 61183.0 |
679 | 2020-05-29 15:10:12 | pizza | 1 | 28756 | 4 | 0.466 | 61708.2 |
678 | 2020-03-28 06:25:36 | pizza | 1 | 28756 | 4 | 0.483 | 59536.2 |
677 | 2020-03-27 18:42:08 | pizza | 1 | 28756 | 4 | 0.440 | 65354.5 |
676 | 2020-03-27 01:21:12 | pizza | 1 | 28756 | 4 | 0.546 | 52666.7 |
675 | 2020-03-26 01:52:48 | pizza | 1 | 28756 | 4 | 0.516 | 55728.7 |
674 | 2020-03-25 16:41:18 | pizza | 1 | 28756 | 4 | 1.033 | 27837.4 |
673 | 2020-03-24 08:21:29 | pizza | 1 | 28756 | 4 | 0.486 | 59168.7 |