History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"samps"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
673 | 2024-03-27 02:40:50 | samps | 1 | 28756 | 17 | 1.140 | 25224.6 |
672 | 2024-03-09 10:04:06 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
671 | 2024-03-04 01:36:33 | samps | 2 | 53800 | 236 | 1.703 | 31591.3 |
670 | 2024-03-04 01:36:31 | samps | 1 | 28756 | 17 | 0.533 | 53951.2 |
669 | 2024-03-01 01:20:40 | samps | 1 | 28756 | 17 | 0.563 | 51076.4 |
668 | 2024-02-28 16:51:04 | samps | 1 | 28756 | 17 | 0.593 | 48492.4 |
667 | 2024-02-27 15:03:44 | samps | 2 | 53800 | 236 | 1.673 | 32157.8 |
666 | 2024-02-25 22:09:36 | samps | 2 | 53800 | 236 | 5.736 | 9379.4 |
665 | 2024-02-25 22:05:47 | samps | 1 | 28756 | 17 | 1.123 | 25606.4 |
664 | 2024-02-16 01:38:13 | samps | 1 | 28756 | 17 | 0.576 | 49923.6 |
663 | 2024-02-07 02:45:33 | samps | 1 | 28756 | 17 | 0.516 | 55728.7 |
662 | 2024-02-05 22:42:24 | samps | 1 | 28756 | 17 | 0.516 | 55728.7 |
661 | 2024-02-02 23:25:31 | samps | 1 | 28756 | 17 | 1.096 | 26237.2 |
660 | 2024-01-31 02:09:44 | samps | 1 | 28756 | 17 | 0.530 | 54256.6 |
659 | 2024-01-30 06:06:20 | samps | 1 | 28756 | 17 | 0.513 | 56054.6 |
658 | 2024-01-26 20:12:21 | samps | 1 | 28756 | 17 | 0.550 | 52283.6 |
657 | 2024-01-20 20:35:27 | samps | 1 | 28756 | 17 | 0.533 | 53951.2 |
656 | 2024-01-18 20:31:06 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
655 | 2024-01-18 02:09:40 | samps | 1 | 28756 | 17 | 0.483 | 59536.2 |
654 | 2023-12-27 06:44:58 | samps | 1 | 28756 | 17 | 0.500 | 57512.0 |
653 | 2023-12-12 00:25:10 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
652 | 2023-12-08 07:39:10 | samps | 2 | 53800 | 236 | 1.736 | 30990.8 |
651 | 2023-12-08 07:39:07 | samps | 2 | 53800 | 236 | 2.500 | 21520.0 |
650 | 2023-12-07 18:00:58 | samps | 2 | 53800 | 236 | 1.860 | 28924.7 |
649 | 2023-11-27 20:24:23 | samps | 2 | 53800 | 236 | 1.813 | 29674.6 |
648 | 2023-11-27 16:12:00 | samps | 1 | 28756 | 17 | 0.466 | 61708.2 |
647 | 2023-11-25 19:50:11 | samps | 1 | 28756 | 17 | 0.500 | 57512.0 |
646 | 2023-11-22 19:22:56 | samps | 2 | 53800 | 236 | 1.783 | 30173.9 |
645 | 2023-11-19 06:20:08 | samps | 1 | 28756 | 17 | 0.500 | 57512.0 |
644 | 2023-11-09 04:16:21 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
643 | 2023-10-29 17:28:41 | samps | 1 | 28756 | 17 | 0.533 | 53951.2 |
642 | 2023-10-28 06:36:39 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
641 | 2023-10-21 23:47:32 | samps | 1 | 28756 | 17 | 0.500 | 57512.0 |
640 | 2023-10-19 00:16:33 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
639 | 2023-10-15 15:00:58 | samps | 1 | 28756 | 17 | 0.483 | 59536.2 |
638 | 2023-10-13 04:26:23 | samps | 2 | 53800 | 236 | 1.673 | 32157.8 |
637 | 2023-10-10 23:45:19 | samps | 1 | 28756 | 17 | 0.533 | 53951.2 |
636 | 2023-10-09 04:21:17 | samps | 2 | 53800 | 236 | 1.470 | 36598.6 |
635 | 2023-10-08 21:59:12 | samps | 1 | 28756 | 17 | 0.563 | 51076.4 |
634 | 2023-10-03 15:22:27 | samps | 1 | 28756 | 17 | 0.450 | 63902.2 |
633 | 2023-09-26 08:30:23 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
632 | 2023-09-18 13:10:02 | samps | 1 | 28756 | 17 | 0.513 | 56054.6 |
631 | 2023-09-17 02:59:05 | samps | 1 | 28756 | 17 | 0.530 | 54256.6 |
630 | 2023-09-13 12:44:48 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
629 | 2023-08-22 20:26:06 | samps | 1 | 28756 | 17 | 0.580 | 49579.3 |
628 | 2023-08-11 05:23:29 | samps | 1 | 28756 | 17 | 0.500 | 57512.0 |
627 | 2023-08-10 04:31:44 | samps | 1 | 28756 | 17 | 0.533 | 53951.2 |
626 | 2023-06-21 20:43:00 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
625 | 2023-06-06 23:33:26 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
624 | 2023-06-05 12:58:54 | samps | 1 | 28756 | 17 | 0.466 | 61708.2 |
623 | 2023-06-04 23:33:40 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
622 | 2023-06-01 12:47:43 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
621 | 2023-05-21 15:23:58 | samps | 1 | 28756 | 17 | 0.466 | 61708.2 |
620 | 2023-05-12 18:23:14 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
619 | 2023-04-07 22:51:33 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
618 | 2023-03-06 21:05:12 | samps | 1 | 28756 | 17 | 0.466 | 61708.2 |
617 | 2023-03-06 11:29:06 | samps | 1 | 28756 | 17 | 0.500 | 57512.0 |
616 | 2022-12-28 23:22:35 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
615 | 2022-11-17 23:20:36 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
614 | 2022-09-17 00:37:27 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
613 | 2022-08-10 17:21:52 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
612 | 2022-08-06 10:43:57 | samps | 1 | 28756 | 17 | 0.466 | 61708.2 |
611 | 2022-08-03 01:06:49 | samps | 1 | 28756 | 17 | 0.466 | 61708.2 |
610 | 2022-07-29 09:39:43 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
609 | 2022-07-25 07:24:54 | samps | 1 | 28756 | 17 | 0.466 | 61708.2 |
608 | 2022-07-25 05:04:49 | samps | 1 | 28756 | 17 | 0.593 | 48492.4 |
607 | 2022-07-17 22:50:30 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
606 | 2022-07-15 23:41:53 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
605 | 2022-07-03 15:45:39 | samps | 1 | 28756 | 17 | 0.533 | 53951.2 |
604 | 2022-07-03 02:36:59 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
603 | 2022-06-29 14:26:16 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
602 | 2022-06-17 05:14:33 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
601 | 2022-06-08 22:51:40 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
600 | 2022-06-04 04:45:45 | samps | 1 | 28756 | 17 | 0.450 | 63902.2 |
599 | 2022-03-27 05:58:49 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
598 | 2022-03-23 21:29:57 | samps | 1 | 28756 | 17 | 0.893 | 32201.6 |
597 | 2022-03-02 09:22:52 | samps | 1 | 28756 | 17 | 0.640 | 44931.3 |
596 | 2021-12-23 19:40:07 | samps | 1 | 28756 | 17 | 0.563 | 51076.4 |
595 | 2021-12-22 18:42:01 | samps | 1 | 28756 | 17 | 0.483 | 59536.2 |
594 | 2021-12-21 19:35:49 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
593 | 2021-12-20 17:37:01 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
592 | 2021-12-10 21:14:53 | samps | 1 | 28756 | 17 | 0.516 | 55728.7 |
591 | 2021-12-06 13:42:18 | samps | 1 | 28756 | 17 | 1.080 | 26625.9 |
590 | 2021-12-03 07:32:35 | samps | 1 | 28756 | 17 | 1.076 | 26724.9 |
589 | 2021-11-26 23:41:54 | samps | 1 | 28756 | 17 | 0.563 | 51076.4 |
588 | 2021-11-25 16:15:52 | samps | 1 | 28756 | 17 | 0.483 | 59536.2 |
587 | 2021-11-10 21:22:54 | samps | 1 | 28756 | 17 | 0.533 | 53951.2 |
586 | 2021-10-24 07:35:09 | samps | 1 | 28756 | 17 | 0.486 | 59168.7 |
585 | 2021-09-26 22:58:28 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
584 | 2021-09-21 00:23:17 | samps | 1 | 28756 | 17 | 0.530 | 54256.6 |
583 | 2021-09-12 07:03:11 | samps | 1 | 28756 | 17 | 0.453 | 63479.0 |
582 | 2021-08-30 04:48:04 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
581 | 2021-08-23 12:46:33 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
580 | 2021-07-28 18:17:41 | samps | 1 | 28756 | 17 | 0.513 | 56054.6 |
579 | 2021-05-29 12:23:10 | samps | 1 | 28756 | 17 | 0.530 | 54256.6 |
578 | 2021-02-26 17:52:23 | samps | 1 | 28756 | 17 | 0.470 | 61183.0 |
577 | 2020-11-26 19:15:09 | samps | 1 | 28756 | 17 | 0.486 | 59168.7 |
576 | 2020-11-14 13:54:31 | samps | 1 | 28756 | 17 | 0.516 | 55728.7 |
575 | 2020-10-31 19:54:54 | samps | 1 | 28756 | 17 | 0.530 | 54256.6 |
574 | 2020-10-28 04:37:05 | samps | 1 | 28756 | 17 | 0.563 | 51076.4 |