History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"transect"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
697 | 2025-08-14 21:43:23 | transect | 3 | 146162 | 70 | 44.393 | 3292.5 |
696 | 2025-08-12 17:16:30 | transect | 1 | 82945 | 5 | 2.830 | 29309.2 |
695 | 2025-08-12 08:41:18 | transect | 3 | 146162 | 70 | 31.173 | 4688.7 |
694 | 2025-08-11 16:47:30 | transect | 2 | 121059 | 15 | 7.890 | 15343.3 |
693 | 2025-08-11 04:06:45 | transect | 3 | 146162 | 70 | 15.216 | 9605.8 |
692 | 2025-08-09 15:47:22 | transect | 1 | 82945 | 5 | 5.093 | 16286.1 |
691 | 2025-08-08 22:39:36 | transect | 1 | 82945 | 5 | 3.876 | 21399.6 |
690 | 2025-08-01 06:16:39 | transect | 1 | 82945 | 5 | 6.203 | 13371.8 |
689 | 2025-07-25 06:50:31 | transect | 1 | 82945 | 5 | 4.483 | 18502.1 |
688 | 2025-07-24 08:45:51 | transect | 1 | 82945 | 5 | 3.873 | 21416.2 |
687 | 2025-07-23 12:39:54 | transect | 1 | 82945 | 5 | 8.640 | 9600.1 |
686 | 2025-07-10 09:39:15 | transect | 2 | 121059 | 15 | 9.436 | 12829.5 |
685 | 2025-07-08 21:57:11 | transect | 1 | 82945 | 5 | 1.466 | 56579.1 |
684 | 2025-07-01 22:16:07 | transect | 3 | 146162 | 70 | 30.970 | 4719.5 |
683 | 2025-06-29 05:38:49 | transect | 3 | 146162 | 70 | 17.766 | 8227.1 |
682 | 2025-06-28 10:12:55 | transect | 2 | 121059 | 15 | 23.673 | 5113.8 |
681 | 2025-06-28 02:09:54 | transect | 3 | 146162 | 70 | 44.330 | 3297.1 |
680 | 2025-06-27 17:37:16 | transect | 3 | 146162 | 70 | 6.643 | 22002.4 |
679 | 2025-06-27 06:00:09 | transect | 1 | 82945 | 5 | 1.453 | 57085.3 |
678 | 2025-06-26 00:33:33 | transect | 3 | 146162 | 70 | 32.906 | 4441.8 |
677 | 2025-06-22 07:31:39 | transect | 1 | 82945 | 5 | 7.096 | 11689.0 |
676 | 2025-06-19 10:37:40 | transect | 1 | 82945 | 5 | 4.360 | 19024.1 |
675 | 2025-06-15 22:38:44 | transect | 1 | 82945 | 5 | 9.953 | 8333.7 |
674 | 2025-06-12 19:41:27 | transect | 1 | 82945 | 5 | 2.623 | 31622.2 |
673 | 2025-06-02 07:24:58 | transect | 1 | 82945 | 5 | 10.390 | 7983.2 |
672 | 2025-05-26 20:41:45 | transect | 1 | 82945 | 5 | 3.610 | 22976.5 |
671 | 2025-05-24 14:58:18 | transect | 3 | 146162 | 70 | 32.926 | 4439.1 |
670 | 2025-05-22 04:28:56 | transect | 2 | 121059 | 15 | 22.046 | 5491.2 |
669 | 2025-05-21 22:05:32 | transect | 3 | 146162 | 70 | 36.456 | 4009.3 |
668 | 2025-05-20 21:37:58 | transect | 1 | 82945 | 5 | 1.390 | 59672.7 |
667 | 2025-05-19 21:20:20 | transect | 3 | 146162 | 70 | 31.046 | 4707.9 |
666 | 2025-05-19 13:09:07 | transect | 1 | 82945 | 5 | 1.346 | 61623.3 |
665 | 2025-05-18 14:33:00 | transect | 3 | 146162 | 70 | 48.096 | 3039.0 |
664 | 2025-05-17 18:00:30 | transect | 1 | 82945 | 5 | 1.470 | 56425.2 |
663 | 2025-05-16 18:30:29 | transect | 1 | 82945 | 5 | 7.406 | 11199.7 |
662 | 2025-05-15 01:56:57 | transect | 3 | 146162 | 70 | 35.796 | 4083.2 |
661 | 2025-05-11 12:04:22 | transect | 3 | 146162 | 70 | 7.453 | 19611.2 |
660 | 2025-05-08 05:17:34 | transect | 1 | 82945 | 5 | 6.970 | 11900.3 |
659 | 2025-05-08 00:50:31 | transect | 1 | 82945 | 5 | 8.250 | 10053.9 |
658 | 2025-04-29 10:34:42 | transect | 1 | 82945 | 5 | 1.516 | 54713.1 |
657 | 2025-04-25 07:56:17 | transect | 1 | 82945 | 5 | 1.420 | 58412.0 |
656 | 2025-04-24 05:43:40 | transect | 3 | 146162 | 70 | 38.076 | 3838.7 |
655 | 2025-04-23 16:01:27 | transect | 3 | 146162 | 70 | 29.600 | 4937.9 |
654 | 2025-04-23 07:28:25 | transect | 3 | 146162 | 70 | 44.926 | 3253.4 |
653 | 2025-04-23 05:34:44 | transect | 2 | 121059 | 15 | 23.330 | 5189.0 |
652 | 2025-04-23 03:57:43 | transect | 4 | 161609 | 672 | 68.693 | 2352.6 |
651 | 2025-04-22 05:47:17 | transect | 1 | 82945 | 5 | 1.906 | 43517.8 |
650 | 2025-04-17 21:18:10 | transect | 3 | 146162 | 70 | 19.576 | 7466.4 |
649 | 2025-04-17 20:36:40 | transect | 1 | 82945 | 5 | 3.466 | 23931.0 |
648 | 2025-04-15 14:05:15 | transect | 3 | 146162 | 70 | 28.783 | 5078.1 |
647 | 2025-04-13 23:07:07 | transect | 1 | 82945 | 5 | 3.640 | 22787.1 |
646 | 2025-04-11 04:16:00 | transect | 3 | 146162 | 70 | 28.563 | 5117.2 |
645 | 2025-04-06 10:12:47 | transect | 2 | 121059 | 15 | 22.203 | 5452.4 |
644 | 2025-04-06 01:27:56 | transect | 3 | 146162 | 70 | 26.270 | 5563.8 |
643 | 2025-04-05 04:52:29 | transect | 1 | 82945 | 5 | 1.453 | 57085.3 |
642 | 2025-03-29 05:55:05 | transect | 4 | 161609 | 672 | 41.003 | 3941.4 |
641 | 2025-03-29 03:53:26 | transect | 4 | 161609 | 672 | 59.676 | 2708.1 |
640 | 2025-03-27 06:48:59 | transect | 4 | 161609 | 672 | 64.400 | 2509.5 |
639 | 2025-03-23 04:46:42 | transect | 3 | 146162 | 70 | 28.753 | 5083.4 |
638 | 2025-03-22 15:58:50 | transect | 3 | 146162 | 70 | 31.500 | 4640.1 |
637 | 2025-03-22 07:06:59 | transect | 1 | 82945 | 5 | 7.393 | 11219.4 |
636 | 2025-03-17 14:17:10 | transect | 3 | 146162 | 70 | 39.500 | 3700.3 |
635 | 2025-03-13 12:35:04 | transect | 1 | 82945 | 5 | 3.330 | 24908.4 |
634 | 2025-03-12 22:20:55 | transect | 1 | 82945 | 5 | 7.110 | 11666.0 |
633 | 2025-03-11 12:43:51 | transect | 1 | 82945 | 5 | 10.126 | 8191.3 |
632 | 2025-03-11 12:11:10 | transect | 3 | 146162 | 70 | 47.640 | 3068.1 |
631 | 2025-03-11 12:11:02 | transect | 3 | 146162 | 70 | 29.860 | 4894.9 |
630 | 2025-03-11 12:10:48 | transect | 2 | 121059 | 15 | 21.860 | 5537.9 |
629 | 2025-03-08 12:48:09 | transect | 3 | 146162 | 70 | 51.300 | 2849.2 |
628 | 2025-03-06 01:06:59 | transect | 2 | 121059 | 15 | 13.126 | 9222.8 |
627 | 2025-03-05 13:58:41 | transect | 2 | 121059 | 15 | 9.903 | 12224.5 |
626 | 2025-03-05 13:58:30 | transect | 1 | 82945 | 5 | 3.610 | 22976.5 |
625 | 2025-03-04 14:16:33 | transect | 1 | 82945 | 5 | 2.593 | 31988.0 |
624 | 2025-03-02 22:29:10 | transect | 3 | 146162 | 70 | 28.690 | 5094.5 |
623 | 2025-03-01 02:18:47 | transect | 3 | 146162 | 70 | 38.286 | 3817.6 |
622 | 2025-03-01 02:19:11 | transect | 1 | 82945 | 5 | 5.953 | 13933.3 |
621 | 2025-03-01 02:18:44 | transect | 2 | 121059 | 15 | 19.236 | 6293.4 |
620 | 2025-02-24 18:43:06 | transect | 4 | 161609 | 672 | 43.936 | 3678.3 |
619 | 2025-02-22 13:27:17 | transect | 4 | 161609 | 672 | 57.876 | 2792.3 |
618 | 2025-02-22 03:06:48 | transect | 4 | 161609 | 672 | 89.463 | 1806.4 |
617 | 2025-02-05 17:58:17 | transect | 2 | 121059 | 15 | 21.326 | 5676.6 |
616 | 2025-02-05 17:58:07 | transect | 1 | 82945 | 5 | 10.453 | 7935.0 |
615 | 2025-01-26 15:51:23 | transect | 4 | 161609 | 672 | 56.690 | 2850.7 |
614 | 2025-01-25 18:35:03 | transect | 4 | 161609 | 672 | 11.720 | 13789.2 |
613 | 2025-01-25 18:34:39 | transect | 3 | 146162 | 70 | 7.733 | 18901.1 |
612 | 2025-01-18 14:50:40 | transect | 1 | 82945 | 5 | 3.580 | 23169.0 |
611 | 2025-01-17 16:31:05 | transect | 3 | 146162 | 70 | 40.203 | 3635.6 |
610 | 2025-01-17 14:03:20 | transect | 3 | 146162 | 70 | 39.536 | 3696.9 |
609 | 2025-01-15 20:32:20 | transect | 2 | 121059 | 15 | 16.720 | 7240.4 |
608 | 2025-01-15 20:31:28 | transect | 3 | 146162 | 70 | 37.423 | 3905.7 |
607 | 2025-01-15 20:31:47 | transect | 1 | 82945 | 5 | 7.063 | 11743.6 |
606 | 2025-01-10 13:56:02 | transect | 3 | 146162 | 70 | 51.736 | 2825.2 |
605 | 2025-01-08 20:37:56 | transect | 3 | 146162 | 70 | 35.643 | 4100.7 |
604 | 2025-01-07 09:37:11 | transect | 3 | 146162 | 70 | 27.486 | 5317.7 |
603 | 2025-01-03 09:11:01 | transect | 2 | 121059 | 15 | 18.656 | 6489.0 |
602 | 2025-01-03 09:11:00 | transect | 1 | 82945 | 5 | 9.936 | 8347.9 |
601 | 2025-01-01 11:28:48 | transect | 2 | 121059 | 15 | 27.000 | 4483.7 |
600 | 2025-01-01 11:27:57 | transect | 1 | 82945 | 5 | 3.500 | 23698.6 |
599 | 2024-12-29 16:50:46 | transect | 2 | 121059 | 15 | 11.460 | 10563.6 |
598 | 2024-12-29 16:50:09 | transect | 1 | 82945 | 5 | 3.186 | 26034.2 |