History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"frosts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
655 | 2024-03-27 08:21:03 | frosts | 1 | 48755 | 5 | 1.763 | 27654.6 |
654 | 2024-03-04 06:59:37 | frosts | 2 | 82551 | 89 | 2.233 | 36968.7 |
653 | 2024-03-04 06:59:36 | frosts | 1 | 48755 | 5 | 0.750 | 65006.7 |
652 | 2024-02-28 17:42:44 | frosts | 1 | 48755 | 5 | 0.766 | 63648.8 |
651 | 2024-02-27 21:44:43 | frosts | 1 | 48755 | 5 | 0.936 | 52088.7 |
650 | 2024-02-25 12:56:07 | frosts | 1 | 48755 | 5 | 0.766 | 63648.8 |
649 | 2024-02-25 06:29:14 | frosts | 1 | 48755 | 5 | 0.860 | 56691.9 |
648 | 2024-02-22 08:56:06 | frosts | 3 | 112716 | 943 | 5.156 | 21861.1 |
647 | 2024-02-13 14:07:09 | frosts | 3 | 112716 | 943 | 8.486 | 13282.6 |
646 | 2024-02-13 11:07:37 | frosts | 3 | 112716 | 943 | 13.190 | 8545.6 |
645 | 2024-02-11 18:21:41 | frosts | 3 | 112716 | 943 | 6.516 | 17298.3 |
644 | 2024-02-09 16:47:37 | frosts | 3 | 112716 | 943 | 10.533 | 10701.2 |
643 | 2024-02-06 15:15:38 | frosts | 2 | 82551 | 89 | 4.346 | 18994.7 |
642 | 2024-02-06 15:14:31 | frosts | 3 | 112716 | 943 | 5.750 | 19602.8 |
641 | 2024-02-06 04:51:45 | frosts | 3 | 112716 | 943 | 4.656 | 24208.8 |
640 | 2024-02-06 04:51:37 | frosts | 2 | 82551 | 89 | 2.470 | 33421.5 |
639 | 2024-02-05 20:26:18 | frosts | 2 | 82551 | 89 | 2.453 | 33653.1 |
638 | 2024-02-05 10:21:25 | frosts | 2 | 82551 | 89 | 4.593 | 17973.2 |
637 | 2024-01-11 10:25:23 | frosts | 3 | 112716 | 943 | 4.720 | 23880.5 |
636 | 2024-01-10 12:37:06 | frosts | 3 | 112716 | 943 | 5.610 | 20092.0 |
635 | 2023-12-31 20:34:40 | frosts | 2 | 82551 | 89 | 2.436 | 33887.9 |
634 | 2023-12-17 12:59:56 | frosts | 2 | 82551 | 89 | 2.360 | 34979.2 |
633 | 2023-12-17 07:31:56 | frosts | 2 | 82551 | 89 | 2.513 | 32849.6 |
632 | 2023-12-16 21:19:54 | frosts | 1 | 48755 | 5 | 0.953 | 51159.5 |
631 | 2023-12-03 19:53:19 | frosts | 1 | 48755 | 5 | 0.716 | 68093.6 |
630 | 2023-11-23 15:06:01 | frosts | 1 | 48755 | 5 | 0.733 | 66514.3 |
629 | 2023-11-17 09:11:13 | frosts | 3 | 112716 | 943 | 5.173 | 21789.3 |
628 | 2023-11-15 13:40:23 | frosts | 1 | 48755 | 5 | 0.733 | 66514.3 |
627 | 2023-11-13 05:49:09 | frosts | 1 | 48755 | 5 | 0.800 | 60943.8 |
626 | 2023-11-11 13:17:27 | frosts | 2 | 82551 | 89 | 2.203 | 37472.1 |
625 | 2023-11-04 11:38:37 | frosts | 1 | 48755 | 5 | 0.720 | 67715.3 |
624 | 2023-10-22 22:02:51 | frosts | 1 | 48755 | 5 | 0.860 | 56691.9 |
623 | 2023-10-19 14:12:19 | frosts | 1 | 48755 | 5 | 0.876 | 55656.4 |
622 | 2023-10-11 12:53:42 | frosts | 1 | 48755 | 5 | 0.736 | 66243.2 |
621 | 2023-10-05 04:26:02 | frosts | 1 | 48755 | 5 | 0.810 | 60191.4 |
620 | 2023-09-25 09:10:25 | frosts | 1 | 48755 | 5 | 0.826 | 59025.4 |
619 | 2023-09-22 07:49:28 | frosts | 1 | 48755 | 5 | 0.796 | 61250.0 |
618 | 2023-09-18 07:14:29 | frosts | 1 | 48755 | 5 | 0.750 | 65006.7 |
617 | 2023-08-19 08:29:59 | frosts | 3 | 112716 | 943 | 5.326 | 21163.3 |
616 | 2023-08-15 01:45:02 | frosts | 2 | 82551 | 89 | 2.373 | 34787.6 |
615 | 2023-08-07 10:30:00 | frosts | 1 | 48755 | 5 | 0.893 | 54596.9 |
614 | 2023-07-08 06:05:54 | frosts | 1 | 48755 | 5 | 0.733 | 66514.3 |
613 | 2023-05-18 04:42:55 | frosts | 1 | 48755 | 5 | 0.733 | 66514.3 |
612 | 2023-05-04 22:35:47 | frosts | 3 | 112716 | 943 | 4.953 | 22757.1 |
611 | 2023-05-03 13:48:16 | frosts | 1 | 48755 | 5 | 0.733 | 66514.3 |
610 | 2023-04-27 09:27:06 | frosts | 2 | 82551 | 89 | 2.110 | 39123.7 |
609 | 2023-04-11 21:48:02 | frosts | 1 | 48755 | 5 | 0.750 | 65006.7 |
608 | 2023-02-22 06:08:33 | frosts | 2 | 82551 | 89 | 2.390 | 34540.2 |
607 | 2023-02-11 15:42:56 | frosts | 3 | 112716 | 943 | 4.923 | 22895.8 |
606 | 2023-02-09 11:17:14 | frosts | 3 | 112716 | 943 | 5.280 | 21347.7 |
605 | 2023-02-02 01:31:12 | frosts | 2 | 82551 | 89 | 2.296 | 35954.3 |
604 | 2023-02-01 08:15:41 | frosts | 1 | 48755 | 5 | 0.750 | 65006.7 |
603 | 2023-01-21 08:10:28 | frosts | 1 | 48755 | 5 | 0.796 | 61250.0 |
602 | 2023-01-04 21:46:53 | frosts | 2 | 82551 | 89 | 2.486 | 33206.4 |
601 | 2022-12-25 18:40:34 | frosts | 3 | 112716 | 943 | 5.060 | 22275.9 |
600 | 2022-12-14 12:18:59 | frosts | 2 | 82551 | 89 | 2.156 | 38289.0 |
599 | 2022-11-29 18:23:45 | frosts | 1 | 48755 | 5 | 0.720 | 67715.3 |
598 | 2022-11-22 03:47:31 | frosts | 3 | 112716 | 943 | 5.393 | 20900.4 |
597 | 2022-11-14 02:51:52 | frosts | 2 | 82551 | 89 | 2.080 | 39688.0 |
596 | 2022-10-07 01:30:10 | frosts | 1 | 48755 | 5 | 0.733 | 66514.3 |
595 | 2022-08-23 11:55:15 | frosts | 1 | 48755 | 5 | 0.810 | 60191.4 |
594 | 2022-07-29 12:47:31 | frosts | 1 | 48755 | 5 | 0.750 | 65006.7 |
593 | 2022-07-23 14:34:29 | frosts | 1 | 48755 | 5 | 0.766 | 63648.8 |
592 | 2022-06-17 07:13:36 | frosts | 2 | 82551 | 89 | 2.373 | 34787.6 |
591 | 2022-06-17 04:01:07 | frosts | 1 | 48755 | 5 | 0.720 | 67715.3 |
590 | 2022-06-12 21:30:32 | frosts | 1 | 48755 | 5 | 0.846 | 57630.0 |
589 | 2022-05-03 22:25:10 | frosts | 3 | 112716 | 943 | 5.936 | 18988.5 |
588 | 2022-03-18 15:22:47 | frosts | 1 | 48755 | 5 | 0.733 | 66514.3 |
587 | 2022-02-22 08:43:55 | frosts | 1 | 48755 | 5 | 0.970 | 50262.9 |
586 | 2022-02-05 08:55:05 | frosts | 2 | 82551 | 89 | 2.500 | 33020.4 |
585 | 2022-01-03 15:35:28 | frosts | 3 | 112716 | 943 | 7.326 | 15385.7 |
584 | 2021-12-24 14:26:38 | frosts | 1 | 48755 | 5 | 0.860 | 56691.9 |
583 | 2021-12-22 11:07:18 | frosts | 1 | 48755 | 5 | 0.766 | 63648.8 |
582 | 2021-11-17 14:07:03 | frosts | 1 | 48755 | 5 | 0.826 | 59025.4 |
581 | 2021-11-10 09:18:47 | frosts | 1 | 48755 | 5 | 0.876 | 55656.4 |
580 | 2021-11-07 08:31:01 | frosts | 1 | 48755 | 5 | 0.906 | 53813.5 |
579 | 2021-10-28 17:19:19 | frosts | 1 | 48755 | 5 | 0.860 | 56691.9 |
578 | 2021-10-27 09:33:13 | frosts | 1 | 48755 | 5 | 0.750 | 65006.7 |
577 | 2021-09-15 14:11:28 | frosts | 1 | 48755 | 5 | 0.813 | 59969.2 |
576 | 2021-08-29 00:36:18 | frosts | 1 | 48755 | 5 | 0.830 | 58741.0 |
575 | 2021-08-18 00:53:16 | frosts | 1 | 48755 | 5 | 0.810 | 60191.4 |
574 | 2021-08-14 17:31:15 | frosts | 1 | 48755 | 5 | 0.860 | 56691.9 |
573 | 2021-05-14 01:57:33 | frosts | 1 | 48755 | 5 | 0.750 | 65006.7 |
572 | 2021-05-09 14:53:04 | frosts | 1 | 48755 | 5 | 0.750 | 65006.7 |
571 | 2021-05-02 00:53:25 | frosts | 1 | 48755 | 5 | 0.906 | 53813.5 |
570 | 2021-05-01 19:00:26 | frosts | 1 | 48755 | 5 | 0.890 | 54780.9 |
569 | 2021-03-31 07:18:19 | frosts | 1 | 48755 | 5 | 0.766 | 63648.8 |
568 | 2021-02-15 01:01:17 | frosts | 1 | 48755 | 5 | 0.783 | 62266.9 |
567 | 2021-02-10 15:15:12 | frosts | 1 | 48755 | 5 | 0.733 | 66514.3 |
566 | 2021-02-09 01:10:00 | frosts | 1 | 48755 | 5 | 0.733 | 66514.3 |
565 | 2021-02-05 21:58:36 | frosts | 1 | 48755 | 5 | 0.733 | 66514.3 |
564 | 2021-01-14 20:21:25 | frosts | 1 | 48755 | 5 | 0.860 | 56691.9 |
563 | 2020-11-18 07:55:36 | frosts | 1 | 48755 | 5 | 0.720 | 67715.3 |
562 | 2020-11-03 20:34:34 | frosts | 1 | 48755 | 5 | 0.813 | 59969.2 |
561 | 2020-10-25 14:16:21 | frosts | 1 | 48755 | 5 | 0.763 | 63899.1 |
560 | 2020-10-21 21:40:54 | frosts | 1 | 48755 | 5 | 0.860 | 56691.9 |
559 | 2020-10-16 08:39:31 | frosts | 1 | 48755 | 5 | 0.736 | 66243.2 |
558 | 2020-10-14 15:59:22 | frosts | 1 | 48755 | 5 | 0.796 | 61250.0 |
557 | 2020-09-16 07:55:31 | frosts | 1 | 48755 | 5 | 0.890 | 54780.9 |
556 | 2020-09-10 09:32:36 | frosts | 1 | 48755 | 5 | 0.733 | 66514.3 |