History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"quake"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
675 | 2024-03-15 09:48:25 | quake | 1 | 28756 | 8 | 0.830 | 34645.8 |
674 | 2024-03-04 06:24:08 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
673 | 2024-03-01 12:29:21 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
672 | 2024-02-28 02:45:44 | quake | 1 | 28756 | 8 | 1.220 | 23570.5 |
671 | 2024-02-12 00:12:00 | quake | 3 | 83667 | 1019 | 11.970 | 6989.7 |
670 | 2024-02-09 12:05:29 | quake | 3 | 83667 | 1019 | 3.810 | 21959.8 |
669 | 2024-02-03 04:23:21 | quake | 1 | 28756 | 8 | 1.076 | 26724.9 |
668 | 2024-01-29 05:24:59 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
667 | 2024-01-29 01:23:01 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
666 | 2024-01-15 20:07:08 | quake | 1 | 28756 | 8 | 0.500 | 57512.0 |
665 | 2024-01-14 01:59:13 | quake | 2 | 53800 | 73 | 1.576 | 34137.1 |
664 | 2024-01-10 23:34:57 | quake | 2 | 53800 | 73 | 1.500 | 35866.7 |
663 | 2024-01-10 15:40:07 | quake | 2 | 53800 | 73 | 1.326 | 40573.2 |
662 | 2023-12-17 16:44:30 | quake | 3 | 83667 | 1019 | 3.780 | 22134.1 |
661 | 2023-12-13 03:34:27 | quake | 3 | 83667 | 1019 | 3.860 | 21675.4 |
660 | 2023-12-10 17:47:50 | quake | 2 | 53800 | 73 | 1.563 | 34421.0 |
659 | 2023-12-10 00:35:57 | quake | 3 | 83667 | 1019 | 4.030 | 20761.0 |
658 | 2023-12-04 14:13:43 | quake | 1 | 28756 | 8 | 0.406 | 70827.6 |
657 | 2023-11-18 10:46:01 | quake | 3 | 83667 | 1019 | 3.483 | 24021.5 |
656 | 2023-11-16 20:31:06 | quake | 1 | 28756 | 8 | 0.466 | 61708.2 |
655 | 2023-11-15 01:32:50 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
654 | 2023-11-11 13:38:14 | quake | 3 | 83667 | 1019 | 4.296 | 19475.6 |
653 | 2023-11-10 09:52:05 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
652 | 2023-11-03 19:06:27 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
651 | 2023-10-26 09:20:11 | quake | 1 | 28756 | 8 | 0.860 | 33437.2 |
650 | 2023-10-25 01:11:28 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
649 | 2023-10-18 21:51:33 | quake | 1 | 28756 | 8 | 0.483 | 59536.2 |
648 | 2023-10-14 22:08:04 | quake | 1 | 28756 | 8 | 0.530 | 54256.6 |
647 | 2023-10-05 12:58:31 | quake | 1 | 28756 | 8 | 0.453 | 63479.0 |
646 | 2023-09-27 08:30:36 | quake | 1 | 28756 | 8 | 0.500 | 57512.0 |
645 | 2023-09-13 16:50:16 | quake | 1 | 28756 | 8 | 1.000 | 28756.0 |
644 | 2023-09-11 05:51:18 | quake | 2 | 53800 | 73 | 1.343 | 40059.6 |
643 | 2023-09-10 02:56:40 | quake | 2 | 53800 | 73 | 1.310 | 41068.7 |
642 | 2023-08-29 19:19:44 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
641 | 2023-08-15 03:09:42 | quake | 3 | 83667 | 1019 | 3.173 | 26368.4 |
640 | 2023-08-08 11:41:30 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
639 | 2023-08-04 17:08:09 | quake | 1 | 28756 | 8 | 0.966 | 29768.1 |
638 | 2023-06-04 10:58:56 | quake | 2 | 53800 | 73 | 1.280 | 42031.3 |
637 | 2023-06-02 13:49:32 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
636 | 2023-04-27 11:58:31 | quake | 3 | 83667 | 1019 | 3.750 | 22311.2 |
635 | 2023-04-16 04:52:50 | quake | 1 | 28756 | 8 | 0.466 | 61708.2 |
634 | 2023-03-27 00:55:01 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
633 | 2023-03-12 09:23:15 | quake | 2 | 53800 | 73 | 1.296 | 41512.3 |
632 | 2023-02-09 19:54:55 | quake | 3 | 83667 | 1019 | 3.203 | 26121.4 |
631 | 2023-02-02 02:56:05 | quake | 3 | 83667 | 1019 | 3.516 | 23796.1 |
630 | 2023-01-10 11:44:36 | quake | 1 | 28756 | 8 | 0.406 | 70827.6 |
629 | 2022-12-27 05:53:49 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
628 | 2022-12-15 21:05:58 | quake | 2 | 53800 | 73 | 1.500 | 35866.7 |
627 | 2022-11-14 03:55:33 | quake | 3 | 83667 | 1019 | 3.060 | 27342.2 |
626 | 2022-10-14 05:34:10 | quake | 1 | 28756 | 8 | 0.466 | 61708.2 |
625 | 2022-08-31 01:17:16 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
624 | 2022-08-26 23:18:09 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
623 | 2022-08-10 13:57:11 | quake | 1 | 28756 | 8 | 0.436 | 65954.1 |
622 | 2022-08-09 18:40:08 | quake | 2 | 53800 | 73 | 1.313 | 40974.9 |
621 | 2022-08-07 10:25:43 | quake | 2 | 53800 | 73 | 1.313 | 40974.9 |
620 | 2022-08-06 20:23:50 | quake | 1 | 28756 | 8 | 0.436 | 65954.1 |
619 | 2022-07-25 02:52:41 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
618 | 2022-07-03 07:45:14 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
617 | 2022-06-21 23:24:08 | quake | 3 | 83667 | 1019 | 3.126 | 26764.9 |
616 | 2022-06-17 15:25:32 | quake | 3 | 83667 | 1019 | 3.610 | 23176.5 |
615 | 2022-06-17 03:36:16 | quake | 1 | 28756 | 8 | 0.483 | 59536.2 |
614 | 2022-06-16 07:45:55 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
613 | 2022-06-15 16:28:32 | quake | 1 | 28756 | 8 | 0.436 | 65954.1 |
612 | 2022-06-04 20:26:44 | quake | 1 | 28756 | 8 | 0.403 | 71354.8 |
611 | 2022-06-04 02:55:43 | quake | 1 | 28756 | 8 | 0.453 | 63479.0 |
610 | 2022-06-02 14:46:34 | quake | 1 | 28756 | 8 | 0.406 | 70827.6 |
609 | 2022-04-19 06:11:37 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
608 | 2022-03-08 15:03:05 | quake | 2 | 53800 | 73 | 1.733 | 31044.4 |
607 | 2022-02-12 12:35:50 | quake | 1 | 28756 | 8 | 0.483 | 59536.2 |
606 | 2021-12-31 00:54:48 | quake | 1 | 28756 | 8 | 0.626 | 45936.1 |
605 | 2021-12-04 01:37:57 | quake | 1 | 28756 | 8 | 0.440 | 65354.5 |
604 | 2021-12-02 07:53:59 | quake | 2 | 53800 | 73 | 1.686 | 31909.8 |
603 | 2021-10-13 13:12:50 | quake | 1 | 28756 | 8 | 0.453 | 63479.0 |
602 | 2021-09-22 12:09:28 | quake | 1 | 28756 | 8 | 0.486 | 59168.7 |
601 | 2021-09-20 19:07:15 | quake | 1 | 28756 | 8 | 0.483 | 59536.2 |
600 | 2021-07-27 18:09:02 | quake | 3 | 83667 | 1019 | 3.266 | 25617.6 |
599 | 2021-07-24 08:22:28 | quake | 1 | 28756 | 8 | 0.466 | 61708.2 |
598 | 2021-06-20 13:05:19 | quake | 3 | 83667 | 1019 | 3.626 | 23074.2 |
597 | 2021-06-19 19:08:14 | quake | 3 | 83667 | 1019 | 3.766 | 22216.4 |
596 | 2021-06-07 11:45:21 | quake | 3 | 83667 | 1019 | 3.346 | 25005.1 |
595 | 2021-06-04 07:06:04 | quake | 3 | 83667 | 1019 | 3.876 | 21585.9 |
594 | 2021-05-14 09:05:09 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
593 | 2021-02-20 02:31:31 | quake | 1 | 28756 | 8 | 0.486 | 59168.7 |
592 | 2021-01-31 03:32:18 | quake | 3 | 83667 | 1019 | 3.173 | 26368.4 |
591 | 2021-01-23 14:19:57 | quake | 3 | 83667 | 1019 | 3.233 | 25879.1 |
590 | 2020-11-18 15:23:38 | quake | 1 | 28756 | 8 | 0.440 | 65354.5 |
589 | 2020-11-07 12:32:14 | quake | 1 | 28756 | 8 | 0.563 | 51076.4 |
588 | 2020-10-31 17:17:11 | quake | 3 | 83667 | 1019 | 3.843 | 21771.3 |
587 | 2020-10-28 13:29:36 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
586 | 2020-10-21 18:37:54 | quake | 3 | 83667 | 1019 | 3.670 | 22797.5 |
585 | 2020-10-17 02:25:28 | quake | 1 | 28756 | 8 | 0.953 | 30174.2 |
584 | 2020-07-27 11:54:07 | quake | 1 | 28756 | 8 | 0.576 | 49923.6 |
583 | 2020-07-26 09:26:58 | quake | 1 | 28756 | 8 | 0.560 | 51350.0 |
582 | 2020-07-23 00:57:09 | quake | 1 | 28756 | 8 | 0.483 | 59536.2 |
581 | 2020-06-07 06:40:30 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
580 | 2020-06-06 07:16:52 | quake | 1 | 28756 | 8 | 0.453 | 63479.0 |
579 | 2020-06-05 12:06:44 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
578 | 2020-06-04 06:36:27 | quake | 1 | 28756 | 8 | 0.436 | 65954.1 |
577 | 2020-06-03 06:37:12 | quake | 1 | 28756 | 8 | 0.453 | 63479.0 |
576 | 2020-05-31 06:47:10 | quake | 1 | 28756 | 8 | 0.436 | 65954.1 |