History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shotts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
664 | 2024-04-04 23:21:49 | shotts | 1 | 48755 | 10 | 2.546 | 19149.6 |
663 | 2024-04-04 23:20:58 | shotts | 3 | 112716 | 896 | 7.546 | 14937.2 |
662 | 2024-04-03 19:25:09 | shotts | 3 | 112716 | 896 | 13.500 | 8349.3 |
661 | 2024-04-03 09:44:30 | shotts | 2 | 82551 | 87 | 8.576 | 9625.8 |
660 | 2024-04-03 08:26:46 | shotts | 2 | 82551 | 87 | 2.610 | 31628.7 |
659 | 2024-04-03 08:26:17 | shotts | 3 | 112716 | 896 | 6.940 | 16241.5 |
658 | 2024-04-03 05:46:38 | shotts | 3 | 112716 | 896 | 16.470 | 6843.7 |
657 | 2024-04-02 15:08:42 | shotts | 3 | 112716 | 896 | 4.673 | 24120.7 |
656 | 2024-03-07 21:09:22 | shotts | 1 | 48755 | 10 | 0.923 | 52822.3 |
655 | 2024-03-07 01:25:09 | shotts | 2 | 82551 | 87 | 3.076 | 26837.1 |
654 | 2024-03-05 10:03:51 | shotts | 3 | 112716 | 896 | 6.220 | 18121.5 |
653 | 2024-03-04 16:45:34 | shotts | 3 | 112716 | 896 | 18.373 | 6134.9 |
652 | 2024-03-04 14:25:46 | shotts | 1 | 48755 | 10 | 1.950 | 25002.6 |
651 | 2024-03-04 14:17:15 | shotts | 3 | 112716 | 896 | 13.956 | 8076.5 |
650 | 2024-03-04 14:17:09 | shotts | 2 | 82551 | 87 | 2.923 | 28241.9 |
649 | 2024-03-04 07:00:34 | shotts | 3 | 112716 | 896 | 10.970 | 10274.9 |
648 | 2024-03-04 03:39:36 | shotts | 3 | 112716 | 896 | 5.720 | 19705.6 |
647 | 2024-03-04 03:39:38 | shotts | 2 | 82551 | 87 | 2.610 | 31628.7 |
646 | 2024-03-04 03:39:35 | shotts | 1 | 48755 | 10 | 0.860 | 56691.9 |
645 | 2024-02-26 02:01:25 | shotts | 1 | 48755 | 10 | 1.920 | 25393.2 |
644 | 2024-01-26 03:07:28 | shotts | 2 | 82551 | 87 | 2.736 | 30172.1 |
643 | 2024-01-22 16:57:34 | shotts | 1 | 48755 | 10 | 0.890 | 54780.9 |
642 | 2023-12-12 08:37:54 | shotts | 3 | 112716 | 896 | 5.016 | 22471.3 |
641 | 2023-12-12 08:37:37 | shotts | 2 | 82551 | 87 | 2.110 | 39123.7 |
640 | 2023-12-08 12:07:22 | shotts | 3 | 112716 | 896 | 5.123 | 22002.0 |
639 | 2023-12-08 12:07:17 | shotts | 3 | 112716 | 896 | 4.626 | 24365.8 |
638 | 2023-12-08 00:01:28 | shotts | 3 | 112716 | 896 | 5.076 | 22205.7 |
637 | 2023-12-08 00:01:22 | shotts | 3 | 112716 | 896 | 5.186 | 21734.7 |
636 | 2023-12-07 07:49:06 | shotts | 3 | 112716 | 896 | 5.266 | 21404.5 |
635 | 2023-12-07 07:49:03 | shotts | 2 | 82551 | 87 | 2.420 | 34112.0 |
634 | 2023-12-06 11:03:43 | shotts | 3 | 112716 | 896 | 4.626 | 24365.8 |
633 | 2023-12-04 23:03:41 | shotts | 1 | 48755 | 10 | 0.826 | 59025.4 |
632 | 2023-12-03 19:59:43 | shotts | 1 | 48755 | 10 | 0.890 | 54780.9 |
631 | 2023-12-03 19:59:42 | shotts | 1 | 48755 | 10 | 0.876 | 55656.4 |
630 | 2023-11-23 22:12:27 | shotts | 3 | 112716 | 896 | 5.640 | 19985.1 |
629 | 2023-11-23 22:12:24 | shotts | 2 | 82551 | 87 | 2.623 | 31472.0 |
628 | 2023-11-17 06:56:51 | shotts | 1 | 48755 | 10 | 0.830 | 58741.0 |
627 | 2023-11-10 16:48:43 | shotts | 1 | 48755 | 10 | 0.876 | 55656.4 |
626 | 2023-11-09 09:14:18 | shotts | 1 | 48755 | 10 | 0.750 | 65006.7 |
625 | 2023-11-05 12:30:49 | shotts | 2 | 82551 | 87 | 2.390 | 34540.2 |
624 | 2023-11-03 02:54:23 | shotts | 1 | 48755 | 10 | 0.830 | 58741.0 |
623 | 2023-10-28 14:47:21 | shotts | 1 | 48755 | 10 | 0.843 | 57835.1 |
622 | 2023-10-28 04:42:11 | shotts | 1 | 48755 | 10 | 0.843 | 57835.1 |
621 | 2023-10-13 13:36:26 | shotts | 1 | 48755 | 10 | 0.736 | 66243.2 |
620 | 2023-10-09 07:05:28 | shotts | 1 | 48755 | 10 | 0.780 | 62506.4 |
619 | 2023-09-24 01:20:57 | shotts | 1 | 48755 | 10 | 0.750 | 65006.7 |
618 | 2023-09-22 07:29:32 | shotts | 1 | 48755 | 10 | 0.736 | 66243.2 |
617 | 2023-09-04 03:43:25 | shotts | 1 | 48755 | 10 | 0.750 | 65006.7 |
616 | 2023-09-02 21:10:38 | shotts | 3 | 112716 | 896 | 5.436 | 20735.1 |
615 | 2023-08-11 00:50:43 | shotts | 2 | 82551 | 87 | 2.423 | 34069.7 |
614 | 2023-08-01 09:02:02 | shotts | 1 | 48755 | 10 | 0.783 | 62266.9 |
613 | 2023-05-20 23:11:50 | shotts | 3 | 112716 | 896 | 4.673 | 24120.7 |
612 | 2023-04-24 16:06:18 | shotts | 2 | 82551 | 87 | 2.123 | 38884.1 |
611 | 2023-04-21 14:42:27 | shotts | 3 | 112716 | 896 | 5.700 | 19774.7 |
610 | 2023-04-16 15:50:05 | shotts | 1 | 48755 | 10 | 0.873 | 55847.7 |
609 | 2023-04-13 16:58:00 | shotts | 3 | 112716 | 896 | 4.546 | 24794.5 |
608 | 2023-03-23 09:07:19 | shotts | 3 | 112716 | 896 | 4.670 | 24136.2 |
607 | 2023-02-27 09:39:49 | shotts | 3 | 112716 | 896 | 5.266 | 21404.5 |
606 | 2023-02-06 19:57:53 | shotts | 1 | 48755 | 10 | 0.733 | 66514.3 |
605 | 2023-01-31 01:13:36 | shotts | 2 | 82551 | 87 | 2.390 | 34540.2 |
604 | 2022-12-31 09:33:30 | shotts | 1 | 48755 | 10 | 0.733 | 66514.3 |
603 | 2022-12-07 20:19:18 | shotts | 3 | 112716 | 896 | 4.623 | 24381.6 |
602 | 2022-12-05 07:17:40 | shotts | 1 | 48755 | 10 | 0.750 | 65006.7 |
601 | 2022-11-12 14:01:53 | shotts | 2 | 82551 | 87 | 5.173 | 15958.1 |
600 | 2022-08-27 08:38:14 | shotts | 1 | 48755 | 10 | 0.750 | 65006.7 |
599 | 2022-07-30 09:51:38 | shotts | 1 | 48755 | 10 | 0.813 | 59969.2 |
598 | 2022-07-28 02:02:06 | shotts | 1 | 48755 | 10 | 0.766 | 63648.8 |
597 | 2022-07-20 22:58:05 | shotts | 3 | 112716 | 896 | 4.610 | 24450.3 |
596 | 2022-06-18 17:03:18 | shotts | 1 | 48755 | 10 | 0.813 | 59969.2 |
595 | 2022-05-12 14:18:54 | shotts | 1 | 48755 | 10 | 1.156 | 42175.6 |
594 | 2022-05-09 09:14:30 | shotts | 1 | 48755 | 10 | 0.966 | 50471.0 |
593 | 2022-05-07 05:00:44 | shotts | 1 | 48755 | 10 | 0.923 | 52822.3 |
592 | 2022-05-05 01:29:14 | shotts | 1 | 48755 | 10 | 0.796 | 61250.0 |
591 | 2022-05-05 00:41:15 | shotts | 2 | 82551 | 87 | 2.153 | 38342.3 |
590 | 2022-04-19 15:52:28 | shotts | 1 | 48755 | 10 | 0.843 | 57835.1 |
589 | 2022-03-22 17:23:20 | shotts | 1 | 48755 | 10 | 0.953 | 51159.5 |
588 | 2022-02-26 20:49:07 | shotts | 3 | 112716 | 896 | 4.673 | 24120.7 |
587 | 2021-12-31 10:21:06 | shotts | 1 | 48755 | 10 | 0.813 | 59969.2 |
586 | 2021-12-28 16:27:42 | shotts | 1 | 48755 | 10 | 0.923 | 52822.3 |
585 | 2021-12-28 06:26:32 | shotts | 1 | 48755 | 10 | 0.783 | 62266.9 |
584 | 2021-11-02 09:25:09 | shotts | 1 | 48755 | 10 | 0.890 | 54780.9 |
583 | 2021-09-19 17:55:05 | shotts | 1 | 48755 | 10 | 0.940 | 51867.0 |
582 | 2021-09-14 17:26:31 | shotts | 1 | 48755 | 10 | 0.873 | 55847.7 |
581 | 2021-08-31 00:56:10 | shotts | 1 | 48755 | 10 | 0.876 | 55656.4 |
580 | 2021-07-05 22:18:44 | shotts | 1 | 48755 | 10 | 0.860 | 56691.9 |
579 | 2021-06-14 14:51:20 | shotts | 1 | 48755 | 10 | 0.860 | 56691.9 |
578 | 2021-05-23 17:18:14 | shotts | 2 | 82551 | 87 | 2.516 | 32810.4 |
577 | 2021-04-27 20:40:33 | shotts | 3 | 112716 | 896 | 5.330 | 21147.5 |
576 | 2021-04-20 05:29:17 | shotts | 1 | 48755 | 10 | 1.530 | 31866.0 |
575 | 2021-03-22 23:14:07 | shotts | 1 | 48755 | 10 | 0.780 | 62506.4 |
574 | 2021-03-08 04:23:16 | shotts | 1 | 48755 | 10 | 0.750 | 65006.7 |
573 | 2021-03-01 00:42:06 | shotts | 2 | 82551 | 87 | 2.110 | 39123.7 |
572 | 2021-02-25 07:46:55 | shotts | 1 | 48755 | 10 | 0.783 | 62266.9 |
571 | 2021-01-11 03:46:34 | shotts | 3 | 112716 | 896 | 4.673 | 24120.7 |
570 | 2020-12-07 17:54:08 | shotts | 1 | 48755 | 10 | 0.766 | 63648.8 |
569 | 2020-12-04 14:05:33 | shotts | 1 | 48755 | 10 | 0.750 | 65006.7 |
568 | 2020-11-10 01:49:35 | shotts | 2 | 82551 | 87 | 2.436 | 33887.9 |
567 | 2020-10-23 10:50:39 | shotts | 3 | 112716 | 896 | 5.533 | 20371.6 |
566 | 2020-10-22 16:46:09 | shotts | 2 | 82551 | 87 | 2.173 | 37989.4 |
565 | 2020-10-12 08:44:39 | shotts | 1 | 48755 | 10 | 0.766 | 63648.8 |