History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gallon"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
703 | 2025-08-30 13:14:19 | gallon | 1 | 48755 | 6 | 0.846 | 57630.0 |
702 | 2025-08-28 09:36:59 | gallon | 3 | 112716 | 574 | 4.906 | 22975.1 |
701 | 2025-08-27 21:58:42 | gallon | 3 | 112716 | 574 | 5.046 | 22337.7 |
700 | 2025-08-23 03:56:44 | gallon | 1 | 48755 | 6 | 2.796 | 17437.4 |
699 | 2025-08-17 15:15:17 | gallon | 1 | 48755 | 6 | 3.920 | 12437.5 |
698 | 2025-08-17 13:11:27 | gallon | 3 | 112716 | 574 | 13.110 | 8597.7 |
697 | 2025-08-14 01:08:45 | gallon | 3 | 112716 | 574 | 5.623 | 20045.5 |
696 | 2025-08-06 01:22:39 | gallon | 2 | 82551 | 69 | 18.890 | 4370.1 |
695 | 2025-08-05 00:57:41 | gallon | 1 | 48755 | 6 | 3.486 | 13985.9 |
694 | 2025-08-04 05:43:31 | gallon | 1 | 48755 | 6 | 0.876 | 55656.4 |
693 | 2025-08-03 23:09:41 | gallon | 1 | 48755 | 6 | 2.186 | 22303.3 |
692 | 2025-07-28 05:31:46 | gallon | 3 | 112716 | 574 | 14.140 | 7971.4 |
691 | 2025-07-28 03:01:51 | gallon | 3 | 112716 | 574 | 18.610 | 6056.7 |
690 | 2025-07-27 21:54:54 | gallon | 3 | 112716 | 574 | 11.546 | 9762.3 |
689 | 2025-07-27 00:53:13 | gallon | 2 | 82551 | 69 | 13.173 | 6266.7 |
688 | 2025-07-27 00:51:44 | gallon | 3 | 112716 | 574 | 20.280 | 5558.0 |
687 | 2025-07-24 01:04:22 | gallon | 1 | 48755 | 6 | 2.626 | 18566.3 |
686 | 2025-07-23 10:19:54 | gallon | 1 | 48755 | 6 | 4.110 | 11862.5 |
685 | 2025-07-23 02:21:03 | gallon | 1 | 48755 | 6 | 2.203 | 22131.2 |
684 | 2025-07-22 16:34:19 | gallon | 1 | 48755 | 6 | 2.000 | 24377.5 |
683 | 2025-07-22 09:22:14 | gallon | 1 | 48755 | 6 | 0.843 | 57835.1 |
682 | 2025-07-19 14:55:21 | gallon | 1 | 48755 | 6 | 0.906 | 53813.5 |
681 | 2025-07-17 09:34:18 | gallon | 1 | 48755 | 6 | 3.966 | 12293.2 |
680 | 2025-07-16 23:49:03 | gallon | 3 | 112716 | 574 | 15.360 | 7338.3 |
679 | 2025-07-13 15:38:36 | gallon | 1 | 48755 | 6 | 0.953 | 51159.5 |
678 | 2025-07-03 22:43:32 | gallon | 1 | 48755 | 6 | 3.343 | 14584.2 |
677 | 2025-06-20 20:07:00 | gallon | 2 | 82551 | 69 | 11.423 | 7226.7 |
676 | 2025-06-20 03:44:29 | gallon | 1 | 48755 | 6 | 4.236 | 11509.7 |
675 | 2025-06-19 23:21:09 | gallon | 1 | 48755 | 6 | 3.953 | 12333.7 |
674 | 2025-06-19 17:16:49 | gallon | 1 | 48755 | 6 | 0.846 | 57630.0 |
673 | 2025-06-16 08:01:53 | gallon | 1 | 48755 | 6 | 4.876 | 9999.0 |
672 | 2025-06-12 15:22:54 | gallon | 1 | 48755 | 6 | 6.390 | 7629.9 |
671 | 2025-06-04 13:43:37 | gallon | 3 | 112716 | 574 | 32.580 | 3459.7 |
670 | 2025-06-04 07:20:48 | gallon | 2 | 82551 | 69 | 11.986 | 6887.3 |
669 | 2025-06-02 04:54:49 | gallon | 2 | 82551 | 69 | 12.186 | 6774.2 |
668 | 2025-06-01 23:43:47 | gallon | 3 | 112716 | 574 | 33.020 | 3413.6 |
667 | 2025-06-01 02:47:24 | gallon | 1 | 48755 | 6 | 3.846 | 12676.8 |
666 | 2025-05-27 08:59:03 | gallon | 1 | 48755 | 6 | 3.873 | 12588.4 |
665 | 2025-05-25 17:34:25 | gallon | 1 | 48755 | 6 | 0.873 | 55847.7 |
664 | 2025-05-20 03:06:42 | gallon | 1 | 48755 | 6 | 4.063 | 11999.8 |
663 | 2025-05-17 16:07:18 | gallon | 1 | 48755 | 6 | 0.826 | 59025.4 |
662 | 2025-05-16 08:02:50 | gallon | 1 | 48755 | 6 | 4.110 | 11862.5 |
661 | 2025-05-13 22:36:45 | gallon | 3 | 112716 | 574 | 23.856 | 4724.8 |
660 | 2025-05-13 12:16:22 | gallon | 3 | 112716 | 574 | 29.093 | 3874.3 |
659 | 2025-05-12 15:18:29 | gallon | 1 | 48755 | 6 | 6.110 | 7979.5 |
658 | 2025-05-03 22:43:13 | gallon | 1 | 48755 | 6 | 6.406 | 7610.8 |
657 | 2025-05-03 03:34:26 | gallon | 1 | 48755 | 6 | 4.233 | 11517.8 |
656 | 2025-04-27 13:28:45 | gallon | 1 | 48755 | 6 | 0.843 | 57835.1 |
655 | 2025-04-21 04:56:38 | gallon | 2 | 82551 | 69 | 13.030 | 6335.5 |
654 | 2025-04-21 04:04:02 | gallon | 2 | 82551 | 69 | 12.876 | 6411.2 |
653 | 2025-04-20 15:02:34 | gallon | 3 | 112716 | 574 | 21.926 | 5140.7 |
652 | 2025-04-20 14:05:59 | gallon | 2 | 82551 | 69 | 9.796 | 8427.0 |
651 | 2025-04-20 02:08:03 | gallon | 1 | 48755 | 6 | 5.813 | 8387.2 |
650 | 2025-04-18 22:47:48 | gallon | 1 | 48755 | 6 | 5.186 | 9401.3 |
649 | 2025-04-14 07:52:32 | gallon | 1 | 48755 | 6 | 4.233 | 11517.8 |
648 | 2025-04-11 15:26:43 | gallon | 1 | 48755 | 6 | 2.280 | 21383.8 |
647 | 2025-04-01 22:36:45 | gallon | 1 | 48755 | 6 | 2.686 | 18151.5 |
646 | 2025-03-20 19:18:56 | gallon | 2 | 82551 | 69 | 2.436 | 33887.9 |
645 | 2025-03-20 19:08:51 | gallon | 3 | 112716 | 574 | 5.953 | 18934.3 |
644 | 2025-03-20 04:11:36 | gallon | 1 | 48755 | 6 | 2.250 | 21668.9 |
643 | 2025-03-18 23:48:59 | gallon | 1 | 48755 | 6 | 0.813 | 59969.2 |
642 | 2025-03-12 17:39:37 | gallon | 1 | 48755 | 6 | 4.063 | 11999.8 |
641 | 2025-03-12 09:49:21 | gallon | 1 | 48755 | 6 | 3.860 | 12630.8 |
640 | 2025-03-03 16:23:07 | gallon | 3 | 112716 | 574 | 14.720 | 7657.3 |
639 | 2025-03-02 18:34:37 | gallon | 1 | 48755 | 6 | 4.096 | 11903.1 |
638 | 2025-03-02 14:43:47 | gallon | 3 | 112716 | 574 | 34.393 | 3277.3 |
637 | 2025-03-02 14:21:25 | gallon | 3 | 112716 | 574 | 43.223 | 2607.8 |
636 | 2025-03-02 05:35:43 | gallon | 3 | 112716 | 574 | 26.126 | 4314.3 |
635 | 2025-03-02 02:48:01 | gallon | 1 | 48755 | 6 | 2.200 | 22161.4 |
634 | 2025-03-02 02:44:46 | gallon | 3 | 112716 | 574 | 28.066 | 4016.1 |
633 | 2025-03-02 02:44:44 | gallon | 2 | 82551 | 69 | 12.580 | 6562.1 |
632 | 2025-02-13 00:05:35 | gallon | 1 | 48755 | 6 | 4.016 | 12140.2 |
631 | 2025-02-09 08:28:00 | gallon | 2 | 82551 | 69 | 15.970 | 5169.1 |
630 | 2025-02-08 14:37:01 | gallon | 1 | 48755 | 6 | 4.173 | 11683.4 |
629 | 2025-02-08 14:36:48 | gallon | 2 | 82551 | 69 | 10.046 | 8217.3 |
628 | 2025-02-08 08:10:36 | gallon | 1 | 48755 | 6 | 4.843 | 10067.1 |
627 | 2025-01-29 11:36:30 | gallon | 1 | 48755 | 6 | 4.253 | 11463.7 |
626 | 2025-01-28 13:11:17 | gallon | 1 | 48755 | 6 | 2.390 | 20399.6 |
625 | 2025-01-25 22:40:02 | gallon | 1 | 48755 | 6 | 0.860 | 56691.9 |
624 | 2025-01-16 20:12:42 | gallon | 3 | 112716 | 574 | 29.406 | 3833.1 |
623 | 2025-01-10 08:00:34 | gallon | 3 | 112716 | 574 | 23.033 | 4893.7 |
622 | 2025-01-10 03:51:06 | gallon | 3 | 112716 | 574 | 26.210 | 4300.5 |
621 | 2025-01-10 01:34:46 | gallon | 3 | 112716 | 574 | 14.016 | 8042.0 |
620 | 2025-01-09 19:58:38 | gallon | 3 | 112716 | 574 | 19.736 | 5711.2 |
619 | 2025-01-09 07:52:35 | gallon | 1 | 48755 | 6 | 4.706 | 10360.2 |
618 | 2025-01-08 18:19:36 | gallon | 1 | 48755 | 6 | 3.440 | 14173.0 |
617 | 2025-01-02 09:11:04 | gallon | 3 | 112716 | 574 | 24.673 | 4568.4 |
616 | 2024-12-31 15:04:29 | gallon | 3 | 112716 | 574 | 38.766 | 2907.6 |
615 | 2024-12-29 15:19:56 | gallon | 1 | 48755 | 6 | 6.283 | 7759.8 |
614 | 2024-12-28 11:58:51 | gallon | 3 | 112716 | 574 | 22.766 | 4951.1 |
613 | 2024-12-28 03:23:44 | gallon | 1 | 48755 | 6 | 4.360 | 11182.3 |
612 | 2024-12-10 19:11:17 | gallon | 3 | 112716 | 574 | 42.453 | 2655.1 |
611 | 2024-12-10 17:57:03 | gallon | 2 | 82551 | 69 | 6.656 | 12402.5 |
610 | 2024-12-10 15:51:36 | gallon | 3 | 112716 | 574 | 5.640 | 19985.1 |
609 | 2024-12-10 01:17:09 | gallon | 3 | 112716 | 574 | 25.693 | 4387.0 |
608 | 2024-12-10 01:17:05 | gallon | 2 | 82551 | 69 | 12.626 | 6538.2 |
607 | 2024-12-10 01:15:31 | gallon | 3 | 112716 | 574 | 20.890 | 5395.7 |
606 | 2024-12-10 01:15:38 | gallon | 2 | 82551 | 69 | 11.970 | 6896.5 |
605 | 2024-12-10 01:13:10 | gallon | 1 | 48755 | 6 | 4.013 | 12149.3 |
604 | 2024-12-09 06:38:16 | gallon | 1 | 48755 | 6 | 3.940 | 12374.4 |