History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"readings"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
645 | 2024-05-05 18:28:08 | readings | 1 | 82945 | 6 | 1.580 | 52496.8 |
644 | 2024-04-08 16:04:21 | readings | 3 | 146162 | 548 | 18.236 | 8015.0 |
643 | 2024-04-07 21:20:29 | readings | 3 | 146162 | 548 | 19.843 | 7365.9 |
642 | 2024-04-07 21:02:35 | readings | 1 | 82945 | 6 | 3.546 | 23391.1 |
641 | 2024-04-06 06:35:04 | readings | 1 | 82945 | 6 | 5.063 | 16382.6 |
640 | 2024-04-05 11:14:50 | readings | 3 | 146162 | 548 | 30.470 | 4796.9 |
639 | 2024-04-05 01:52:42 | readings | 3 | 146162 | 548 | 18.516 | 7893.8 |
638 | 2024-04-04 23:28:04 | readings | 3 | 146162 | 548 | 11.326 | 12905.0 |
637 | 2024-04-04 23:28:00 | readings | 2 | 121059 | 63 | 7.453 | 16243.0 |
636 | 2024-04-04 23:27:50 | readings | 1 | 82945 | 6 | 4.470 | 18555.9 |
635 | 2024-03-30 00:58:41 | readings | 1 | 82945 | 6 | 4.826 | 17187.1 |
634 | 2024-03-01 03:54:26 | readings | 1 | 82945 | 6 | 2.813 | 29486.3 |
633 | 2024-02-14 12:18:14 | readings | 3 | 146162 | 548 | 15.923 | 9179.3 |
632 | 2024-02-12 16:13:40 | readings | 3 | 146162 | 548 | 24.970 | 5853.5 |
631 | 2024-02-08 08:13:57 | readings | 2 | 121059 | 63 | 8.610 | 14060.3 |
630 | 2024-02-08 08:11:26 | readings | 3 | 146162 | 548 | 9.110 | 16044.1 |
629 | 2024-02-05 11:22:45 | readings | 3 | 146162 | 548 | 9.000 | 16240.2 |
628 | 2024-02-05 09:11:02 | readings | 2 | 121059 | 63 | 3.766 | 32145.2 |
627 | 2024-02-05 09:10:29 | readings | 3 | 146162 | 548 | 8.423 | 17352.7 |
626 | 2024-02-05 04:42:34 | readings | 2 | 121059 | 63 | 8.770 | 13803.8 |
625 | 2024-02-05 04:41:54 | readings | 3 | 146162 | 548 | 8.610 | 16975.8 |
624 | 2024-02-05 03:37:46 | readings | 3 | 146162 | 548 | 9.033 | 16180.9 |
623 | 2024-01-31 08:00:50 | readings | 1 | 82945 | 6 | 1.356 | 61168.9 |
622 | 2023-12-29 23:04:28 | readings | 3 | 146162 | 548 | 7.030 | 20791.2 |
621 | 2023-12-25 22:23:21 | readings | 3 | 146162 | 548 | 6.953 | 21021.4 |
620 | 2023-12-21 01:57:28 | readings | 1 | 82945 | 6 | 1.513 | 54821.5 |
619 | 2023-11-25 23:17:22 | readings | 1 | 82945 | 6 | 1.330 | 62364.7 |
618 | 2023-11-18 10:44:45 | readings | 1 | 82945 | 6 | 1.593 | 52068.4 |
617 | 2023-11-12 09:57:14 | readings | 3 | 146162 | 548 | 6.516 | 22431.2 |
616 | 2023-11-11 00:12:56 | readings | 1 | 82945 | 6 | 2.953 | 28088.4 |
615 | 2023-10-24 18:02:30 | readings | 1 | 82945 | 6 | 1.440 | 57600.7 |
614 | 2023-10-23 17:30:06 | readings | 1 | 82945 | 6 | 1.483 | 55930.5 |
613 | 2023-10-16 04:53:50 | readings | 1 | 82945 | 6 | 1.343 | 61761.0 |
612 | 2023-10-13 21:12:58 | readings | 1 | 82945 | 6 | 1.313 | 63172.1 |
611 | 2023-09-28 07:43:38 | readings | 1 | 82945 | 6 | 1.530 | 54212.4 |
610 | 2023-09-22 02:47:53 | readings | 1 | 82945 | 6 | 1.296 | 64000.8 |
609 | 2023-09-11 18:07:31 | readings | 1 | 82945 | 6 | 1.376 | 60279.8 |
608 | 2023-08-15 22:37:41 | readings | 3 | 146162 | 548 | 6.843 | 21359.3 |
607 | 2023-06-30 14:55:58 | readings | 1 | 82945 | 6 | 1.420 | 58412.0 |
606 | 2023-06-15 13:15:16 | readings | 1 | 82945 | 6 | 1.546 | 53651.4 |
605 | 2023-04-28 06:50:46 | readings | 3 | 146162 | 548 | 6.750 | 21653.6 |
604 | 2023-03-30 19:05:58 | readings | 1 | 82945 | 6 | 1.296 | 64000.8 |
603 | 2023-03-11 02:50:25 | readings | 1 | 82945 | 6 | 1.500 | 55296.7 |
602 | 2023-03-07 20:03:57 | readings | 1 | 82945 | 6 | 1.453 | 57085.3 |
601 | 2023-02-04 13:27:54 | readings | 3 | 146162 | 548 | 6.360 | 22981.4 |
600 | 2023-01-13 17:47:13 | readings | 1 | 82945 | 6 | 1.296 | 64000.8 |
599 | 2022-11-19 11:04:13 | readings | 1 | 82945 | 6 | 1.453 | 57085.3 |
598 | 2022-11-17 22:25:31 | readings | 3 | 146162 | 548 | 7.826 | 18676.5 |
597 | 2022-10-28 11:39:23 | readings | 1 | 82945 | 6 | 1.266 | 65517.4 |
596 | 2022-09-06 16:41:49 | readings | 1 | 82945 | 6 | 1.330 | 62364.7 |
595 | 2022-09-03 12:17:13 | readings | 1 | 82945 | 6 | 1.296 | 64000.8 |
594 | 2022-07-30 03:49:19 | readings | 1 | 82945 | 6 | 1.483 | 55930.5 |
593 | 2022-06-20 13:59:39 | readings | 3 | 146162 | 548 | 6.516 | 22431.2 |
592 | 2022-06-17 10:36:24 | readings | 1 | 82945 | 6 | 1.296 | 64000.8 |
591 | 2022-04-01 04:24:41 | readings | 1 | 82945 | 6 | 1.576 | 52630.1 |
590 | 2022-02-27 01:52:00 | readings | 1 | 82945 | 6 | 1.313 | 63172.1 |
589 | 2022-02-24 21:51:04 | readings | 1 | 82945 | 6 | 1.856 | 44690.2 |
588 | 2021-12-14 10:06:50 | readings | 1 | 82945 | 6 | 1.533 | 54106.3 |
587 | 2021-12-11 20:31:06 | readings | 1 | 82945 | 6 | 1.516 | 54713.1 |
586 | 2021-12-09 19:06:01 | readings | 1 | 82945 | 6 | 1.436 | 57761.1 |
585 | 2021-10-31 08:57:09 | readings | 1 | 82945 | 6 | 1.546 | 53651.4 |
584 | 2021-10-29 08:33:07 | readings | 1 | 82945 | 6 | 1.530 | 54212.4 |
583 | 2021-09-13 07:50:57 | readings | 1 | 82945 | 6 | 1.296 | 64000.8 |
582 | 2021-09-07 03:37:08 | readings | 1 | 82945 | 6 | 1.280 | 64800.8 |
581 | 2021-07-25 09:40:54 | readings | 1 | 82945 | 6 | 1.313 | 63172.1 |
580 | 2021-06-06 04:43:26 | readings | 1 | 82945 | 6 | 1.296 | 64000.8 |
579 | 2021-06-03 00:01:57 | readings | 1 | 82945 | 6 | 1.516 | 54713.1 |
578 | 2021-05-15 10:06:28 | readings | 1 | 82945 | 6 | 1.343 | 61761.0 |
577 | 2021-04-14 14:20:41 | readings | 1 | 82945 | 6 | 1.593 | 52068.4 |
576 | 2021-02-28 12:04:33 | readings | 1 | 82945 | 6 | 1.516 | 54713.1 |
575 | 2021-02-24 15:35:47 | readings | 1 | 82945 | 6 | 1.296 | 64000.8 |
574 | 2021-02-22 08:57:23 | readings | 1 | 82945 | 6 | 1.453 | 57085.3 |
573 | 2021-02-21 03:05:16 | readings | 1 | 82945 | 6 | 1.390 | 59672.7 |
572 | 2021-01-26 05:36:06 | readings | 1 | 82945 | 6 | 1.296 | 64000.8 |
571 | 2021-01-14 03:17:12 | readings | 3 | 146162 | 548 | 6.846 | 21350.0 |
570 | 2020-11-28 16:15:21 | readings | 1 | 82945 | 6 | 1.296 | 64000.8 |
569 | 2020-11-19 18:12:15 | readings | 3 | 146162 | 548 | 6.653 | 21969.3 |
568 | 2020-11-18 16:48:16 | readings | 2 | 121059 | 63 | 3.406 | 35542.9 |
567 | 2020-10-23 01:46:25 | readings | 1 | 82945 | 6 | 1.580 | 52496.8 |
566 | 2020-10-19 20:29:25 | readings | 2 | 121059 | 63 | 3.813 | 31749.0 |
565 | 2020-10-17 00:45:08 | readings | 1 | 82945 | 6 | 1.296 | 64000.8 |
564 | 2020-10-15 11:48:13 | readings | 3 | 146162 | 548 | 6.953 | 21021.4 |
563 | 2020-10-08 10:58:48 | readings | 1 | 82945 | 6 | 1.360 | 60989.0 |
562 | 2020-09-27 23:25:47 | readings | 1 | 82945 | 6 | 1.280 | 64800.8 |
561 | 2020-08-25 12:20:03 | readings | 1 | 82945 | 6 | 1.390 | 59672.7 |
560 | 2020-08-13 17:47:40 | readings | 1 | 82945 | 6 | 1.376 | 60279.8 |
559 | 2020-08-10 19:44:37 | readings | 1 | 82945 | 6 | 1.436 | 57761.1 |
558 | 2020-07-21 20:09:14 | readings | 1 | 82945 | 6 | 1.390 | 59672.7 |
557 | 2020-05-24 02:38:47 | readings | 1 | 82945 | 6 | 1.453 | 57085.3 |
556 | 2020-05-06 05:39:33 | readings | 1 | 82945 | 6 | 1.470 | 56425.2 |
555 | 2020-03-24 13:59:11 | readings | 1 | 82945 | 6 | 1.500 | 55296.7 |
554 | 2020-03-21 01:16:02 | readings | 1 | 82945 | 6 | 2.313 | 35860.4 |
553 | 2020-03-01 23:19:07 | readings | 1 | 82945 | 6 | 1.466 | 56579.1 |
552 | 2020-02-25 07:45:24 | readings | 1 | 82945 | 6 | 1.466 | 56579.1 |
551 | 2020-02-22 06:42:08 | readings | 1 | 82945 | 6 | 3.313 | 25036.2 |
550 | 2020-02-20 21:52:55 | readings | 1 | 82945 | 6 | 1.360 | 60989.0 |
549 | 2020-02-12 12:15:52 | readings | 3 | 146162 | 548 | 17.516 | 8344.5 |
548 | 2020-02-11 18:20:17 | readings | 3 | 146162 | 548 | 7.876 | 18557.9 |
547 | 2020-02-11 16:58:03 | readings | 3 | 146162 | 548 | 9.843 | 14849.3 |
546 | 2020-02-11 10:39:31 | readings | 3 | 146162 | 548 | 15.750 | 9280.1 |