History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"heating"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
663 | 2024-04-27 02:40:49 | heating | 1 | 69583 | 14 | 1.453 | 47889.2 |
662 | 2024-01-30 05:22:19 | heating | 1 | 69583 | 14 | 1.296 | 53690.6 |
661 | 2024-01-18 21:20:26 | heating | 2 | 107671 | 195 | 3.530 | 30501.7 |
660 | 2024-01-15 18:14:13 | heating | 1 | 69583 | 14 | 1.296 | 53690.6 |
659 | 2024-01-12 18:00:05 | heating | 1 | 69583 | 14 | 1.346 | 51696.1 |
658 | 2023-12-16 22:22:37 | heating | 2 | 107671 | 195 | 3.500 | 30763.1 |
657 | 2023-12-03 21:44:20 | heating | 1 | 69583 | 14 | 1.203 | 57841.2 |
656 | 2023-11-22 23:58:22 | heating | 1 | 69583 | 14 | 1.283 | 54234.6 |
655 | 2023-11-18 16:21:50 | heating | 2 | 107671 | 195 | 3.013 | 35735.5 |
654 | 2023-11-12 01:52:08 | heating | 1 | 69583 | 14 | 1.046 | 66522.9 |
653 | 2023-11-08 16:07:51 | heating | 1 | 69583 | 14 | 1.250 | 55666.4 |
652 | 2023-11-02 18:13:12 | heating | 1 | 69583 | 14 | 1.236 | 56296.9 |
651 | 2023-10-29 04:16:46 | heating | 1 | 69583 | 14 | 1.063 | 65459.1 |
650 | 2023-10-24 08:35:52 | heating | 1 | 69583 | 14 | 2.576 | 27012.0 |
649 | 2023-10-23 15:37:13 | heating | 1 | 69583 | 14 | 1.296 | 53690.6 |
648 | 2023-10-16 07:31:01 | heating | 1 | 69583 | 14 | 1.140 | 61037.7 |
647 | 2023-10-11 16:00:36 | heating | 1 | 69583 | 14 | 1.266 | 54962.9 |
646 | 2023-10-06 22:58:10 | heating | 1 | 69583 | 14 | 1.216 | 57222.9 |
645 | 2023-09-29 08:55:48 | heating | 1 | 69583 | 14 | 1.110 | 62687.4 |
644 | 2023-09-25 18:16:41 | heating | 1 | 69583 | 14 | 1.076 | 64668.2 |
643 | 2023-09-14 23:15:47 | heating | 1 | 69583 | 14 | 1.156 | 60192.9 |
642 | 2023-08-31 05:12:36 | heating | 1 | 69583 | 14 | 1.063 | 65459.1 |
641 | 2023-07-01 22:45:21 | heating | 1 | 69583 | 14 | 1.156 | 60192.9 |
640 | 2023-06-06 12:36:34 | heating | 1 | 69583 | 14 | 1.206 | 57697.3 |
639 | 2023-03-28 07:50:35 | heating | 1 | 69583 | 14 | 1.236 | 56296.9 |
638 | 2023-03-25 12:20:13 | heating | 1 | 69583 | 14 | 1.046 | 66522.9 |
637 | 2023-01-11 10:51:40 | heating | 1 | 69583 | 14 | 1.060 | 65644.3 |
636 | 2022-12-20 08:58:24 | heating | 1 | 69583 | 14 | 1.190 | 58473.1 |
635 | 2022-10-25 19:39:25 | heating | 1 | 69583 | 14 | 1.140 | 61037.7 |
634 | 2022-09-19 16:13:04 | heating | 1 | 69583 | 14 | 1.190 | 58473.1 |
633 | 2022-09-18 12:05:22 | heating | 1 | 69583 | 14 | 1.063 | 65459.1 |
632 | 2022-09-12 06:22:18 | heating | 1 | 69583 | 14 | 1.093 | 63662.4 |
631 | 2022-09-10 10:49:13 | heating | 1 | 69583 | 14 | 1.123 | 61961.7 |
630 | 2022-09-06 05:28:51 | heating | 1 | 69583 | 14 | 1.063 | 65459.1 |
629 | 2022-09-01 12:23:41 | heating | 1 | 69583 | 14 | 1.156 | 60192.9 |
628 | 2022-08-15 09:47:17 | heating | 1 | 69583 | 14 | 1.153 | 60349.5 |
627 | 2022-08-06 05:42:23 | heating | 1 | 69583 | 14 | 1.060 | 65644.3 |
626 | 2022-07-10 03:34:40 | heating | 1 | 69583 | 14 | 1.080 | 64428.7 |
625 | 2022-07-02 15:24:53 | heating | 1 | 69583 | 14 | 1.046 | 66522.9 |
624 | 2022-06-15 02:35:12 | heating | 1 | 69583 | 14 | 1.046 | 66522.9 |
623 | 2022-05-21 13:39:02 | heating | 1 | 69583 | 14 | 1.093 | 63662.4 |
622 | 2022-05-18 03:47:40 | heating | 1 | 69583 | 14 | 1.076 | 64668.2 |
621 | 2022-05-17 18:38:58 | heating | 2 | 107671 | 195 | 2.923 | 36835.8 |
620 | 2022-02-20 11:47:54 | heating | 1 | 69583 | 14 | 1.236 | 56296.9 |
619 | 2022-02-10 21:44:32 | heating | 1 | 69583 | 14 | 1.470 | 47335.4 |
618 | 2022-02-10 04:32:51 | heating | 1 | 69583 | 14 | 1.203 | 57841.2 |
617 | 2022-02-09 21:11:59 | heating | 1 | 69583 | 14 | 1.346 | 51696.1 |
616 | 2022-02-09 16:36:53 | heating | 1 | 69583 | 14 | 1.296 | 53690.6 |
615 | 2022-02-09 00:20:08 | heating | 1 | 69583 | 14 | 1.093 | 63662.4 |
614 | 2022-02-08 13:41:55 | heating | 1 | 69583 | 14 | 1.206 | 57697.3 |
613 | 2022-02-07 18:52:15 | heating | 1 | 69583 | 14 | 1.156 | 60192.9 |
612 | 2022-02-05 20:42:12 | heating | 1 | 69583 | 14 | 1.063 | 65459.1 |
611 | 2022-02-05 20:05:04 | heating | 1 | 69583 | 14 | 1.046 | 66522.9 |
610 | 2022-02-04 21:42:01 | heating | 1 | 69583 | 14 | 1.063 | 65459.1 |
609 | 2022-02-04 21:03:56 | heating | 1 | 69583 | 14 | 1.140 | 61037.7 |
608 | 2022-02-03 17:53:01 | heating | 1 | 69583 | 14 | 1.250 | 55666.4 |
607 | 2022-02-03 17:16:28 | heating | 1 | 69583 | 14 | 1.220 | 57035.2 |
606 | 2022-02-02 18:00:24 | heating | 1 | 69583 | 14 | 2.373 | 29322.8 |
605 | 2022-02-02 17:24:31 | heating | 1 | 69583 | 14 | 1.280 | 54361.7 |
604 | 2022-02-01 16:34:09 | heating | 1 | 69583 | 14 | 1.593 | 43680.5 |
603 | 2022-02-01 15:56:27 | heating | 1 | 69583 | 14 | 1.080 | 64428.7 |
602 | 2022-01-31 16:46:44 | heating | 1 | 69583 | 14 | 1.220 | 57035.2 |
601 | 2022-01-31 16:09:13 | heating | 1 | 69583 | 14 | 1.140 | 61037.7 |
600 | 2022-01-30 22:53:52 | heating | 1 | 69583 | 14 | 1.216 | 57222.9 |
599 | 2022-01-30 22:17:09 | heating | 1 | 69583 | 14 | 1.296 | 53690.6 |
598 | 2022-01-29 23:02:06 | heating | 1 | 69583 | 14 | 1.076 | 64668.2 |
597 | 2022-01-29 22:24:43 | heating | 1 | 69583 | 14 | 1.110 | 62687.4 |
596 | 2022-01-23 06:48:06 | heating | 1 | 69583 | 14 | 1.170 | 59472.6 |
595 | 2022-01-22 11:44:36 | heating | 1 | 69583 | 14 | 1.283 | 54234.6 |
594 | 2022-01-21 07:07:05 | heating | 1 | 69583 | 14 | 1.343 | 51811.6 |
593 | 2022-01-20 06:10:08 | heating | 1 | 69583 | 14 | 1.300 | 53525.4 |
592 | 2022-01-19 09:45:17 | heating | 1 | 69583 | 14 | 1.250 | 55666.4 |
591 | 2022-01-18 10:20:52 | heating | 1 | 69583 | 14 | 1.220 | 57035.2 |
590 | 2022-01-17 18:37:13 | heating | 1 | 69583 | 14 | 1.250 | 55666.4 |
589 | 2022-01-17 03:51:24 | heating | 1 | 69583 | 14 | 1.063 | 65459.1 |
588 | 2022-01-16 12:39:06 | heating | 1 | 69583 | 14 | 1.140 | 61037.7 |
587 | 2022-01-16 03:05:41 | heating | 1 | 69583 | 14 | 1.300 | 53525.4 |
586 | 2022-01-15 18:06:49 | heating | 1 | 69583 | 14 | 1.093 | 63662.4 |
585 | 2022-01-15 07:00:27 | heating | 1 | 69583 | 14 | 1.186 | 58670.3 |
584 | 2022-01-15 01:23:00 | heating | 2 | 107671 | 195 | 3.470 | 31029.1 |
583 | 2022-01-14 19:15:22 | heating | 1 | 69583 | 14 | 1.220 | 57035.2 |
582 | 2022-01-14 06:43:36 | heating | 1 | 69583 | 14 | 2.843 | 24475.2 |
581 | 2022-01-13 18:34:39 | heating | 1 | 69583 | 14 | 1.076 | 64668.2 |
580 | 2022-01-03 07:28:29 | heating | 1 | 69583 | 14 | 1.340 | 51927.6 |
579 | 2021-12-05 11:11:09 | heating | 1 | 69583 | 14 | 1.266 | 54962.9 |
578 | 2021-11-10 14:09:44 | heating | 1 | 69583 | 14 | 1.156 | 60192.9 |
577 | 2021-11-08 23:31:29 | heating | 1 | 69583 | 14 | 1.203 | 57841.2 |
576 | 2021-11-08 21:07:39 | heating | 1 | 69583 | 14 | 1.093 | 63662.4 |
575 | 2021-10-23 11:35:23 | heating | 2 | 107671 | 195 | 3.296 | 32667.2 |
574 | 2021-10-15 01:23:53 | heating | 1 | 69583 | 14 | 1.156 | 60192.9 |
573 | 2021-10-14 14:09:50 | heating | 1 | 69583 | 14 | 1.076 | 64668.2 |
572 | 2021-10-14 02:14:53 | heating | 1 | 69583 | 14 | 1.080 | 64428.7 |
571 | 2021-10-13 17:26:57 | heating | 1 | 69583 | 14 | 1.266 | 54962.9 |
570 | 2021-10-12 21:36:29 | heating | 1 | 69583 | 14 | 1.063 | 65459.1 |
569 | 2021-10-12 19:26:29 | heating | 1 | 69583 | 14 | 1.236 | 56296.9 |
568 | 2021-10-12 08:35:50 | heating | 1 | 69583 | 14 | 1.266 | 54962.9 |
567 | 2021-10-11 18:28:10 | heating | 1 | 69583 | 14 | 1.250 | 55666.4 |
566 | 2021-10-11 11:48:08 | heating | 1 | 69583 | 14 | 1.220 | 57035.2 |
565 | 2021-10-10 22:02:05 | heating | 1 | 69583 | 14 | 1.470 | 47335.4 |
564 | 2021-10-10 19:16:52 | heating | 1 | 69583 | 14 | 1.266 | 54962.9 |