History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"alarms"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
635 | 2024-04-25 06:44:50 | alarms | 1 | 48755 | 3 | 1.343 | 36303.1 |
634 | 2024-04-23 04:09:20 | alarms | 3 | 112716 | 838 | 6.923 | 16281.4 |
633 | 2024-04-12 23:33:08 | alarms | 2 | 82551 | 61 | 4.703 | 17552.8 |
632 | 2024-04-12 23:32:20 | alarms | 3 | 112716 | 838 | 6.643 | 16967.6 |
631 | 2024-04-11 13:29:07 | alarms | 2 | 82551 | 61 | 3.780 | 21838.9 |
630 | 2024-04-11 13:28:21 | alarms | 3 | 112716 | 838 | 5.330 | 21147.5 |
629 | 2024-04-10 03:40:48 | alarms | 3 | 112716 | 838 | 5.830 | 19333.8 |
628 | 2024-04-08 17:06:00 | alarms | 3 | 112716 | 838 | 19.766 | 5702.5 |
627 | 2024-04-08 16:39:22 | alarms | 3 | 112716 | 838 | 15.873 | 7101.1 |
626 | 2024-04-08 07:55:12 | alarms | 3 | 112716 | 838 | 18.956 | 5946.2 |
625 | 2024-04-07 22:30:36 | alarms | 3 | 112716 | 838 | 5.846 | 19280.9 |
624 | 2024-04-03 15:51:47 | alarms | 1 | 48755 | 3 | 2.203 | 22131.2 |
623 | 2024-03-31 06:02:25 | alarms | 1 | 48755 | 3 | 1.186 | 41108.8 |
622 | 2024-03-26 12:41:51 | alarms | 1 | 48755 | 3 | 0.966 | 50471.0 |
621 | 2024-03-04 09:40:37 | alarms | 1 | 48755 | 3 | 0.986 | 49447.3 |
620 | 2024-03-01 16:51:53 | alarms | 1 | 48755 | 3 | 0.970 | 50262.9 |
619 | 2024-02-03 05:08:41 | alarms | 1 | 48755 | 3 | 0.983 | 49598.2 |
618 | 2023-12-24 16:10:55 | alarms | 1 | 48755 | 3 | 0.893 | 54596.9 |
617 | 2023-12-21 07:36:06 | alarms | 2 | 82551 | 61 | 2.873 | 28733.4 |
616 | 2023-12-21 07:24:31 | alarms | 3 | 112716 | 838 | 5.310 | 21227.1 |
615 | 2023-12-12 04:13:04 | alarms | 1 | 48755 | 3 | 0.846 | 57630.0 |
614 | 2023-12-11 19:39:23 | alarms | 3 | 112716 | 838 | 4.860 | 23192.6 |
613 | 2023-12-08 07:26:19 | alarms | 1 | 48755 | 3 | 0.860 | 56691.9 |
612 | 2023-12-08 07:26:18 | alarms | 1 | 48755 | 3 | 0.860 | 56691.9 |
611 | 2023-11-21 00:13:28 | alarms | 1 | 48755 | 3 | 0.763 | 63899.1 |
610 | 2023-11-12 04:27:15 | alarms | 1 | 48755 | 3 | 0.860 | 56691.9 |
609 | 2023-11-07 11:22:07 | alarms | 1 | 48755 | 3 | 0.780 | 62506.4 |
608 | 2023-11-03 05:43:46 | alarms | 1 | 48755 | 3 | 0.780 | 62506.4 |
607 | 2023-11-01 05:15:39 | alarms | 1 | 48755 | 3 | 0.800 | 60943.8 |
606 | 2023-10-20 08:02:41 | alarms | 1 | 48755 | 3 | 0.750 | 65006.7 |
605 | 2023-10-11 07:03:36 | alarms | 1 | 48755 | 3 | 0.846 | 57630.0 |
604 | 2023-10-05 20:16:27 | alarms | 1 | 48755 | 3 | 0.953 | 51159.5 |
603 | 2023-09-30 01:29:04 | alarms | 1 | 48755 | 3 | 0.810 | 60191.4 |
602 | 2023-09-25 02:54:24 | alarms | 1 | 48755 | 3 | 0.876 | 55656.4 |
601 | 2023-09-16 14:29:32 | alarms | 1 | 48755 | 3 | 0.876 | 55656.4 |
600 | 2023-09-12 18:14:34 | alarms | 1 | 48755 | 3 | 0.936 | 52088.7 |
599 | 2023-09-11 13:59:53 | alarms | 1 | 48755 | 3 | 0.766 | 63648.8 |
598 | 2023-09-10 18:40:28 | alarms | 3 | 112716 | 838 | 5.546 | 20323.8 |
597 | 2023-09-09 22:18:02 | alarms | 1 | 48755 | 3 | 0.843 | 57835.1 |
596 | 2023-09-09 10:35:51 | alarms | 3 | 112716 | 838 | 5.500 | 20493.8 |
595 | 2023-07-28 02:16:54 | alarms | 1 | 48755 | 3 | 0.890 | 54780.9 |
594 | 2023-06-07 16:38:50 | alarms | 1 | 48755 | 3 | 0.843 | 57835.1 |
593 | 2023-05-29 21:10:17 | alarms | 3 | 112716 | 838 | 4.766 | 23650.0 |
592 | 2023-04-25 19:18:39 | alarms | 1 | 48755 | 3 | 0.810 | 60191.4 |
591 | 2023-03-27 15:50:46 | alarms | 1 | 48755 | 3 | 0.843 | 57835.1 |
590 | 2023-03-08 13:42:07 | alarms | 1 | 48755 | 3 | 0.750 | 65006.7 |
589 | 2023-03-07 00:47:03 | alarms | 3 | 112716 | 838 | 4.750 | 23729.7 |
588 | 2023-02-17 14:23:52 | alarms | 1 | 48755 | 3 | 0.766 | 63648.8 |
587 | 2022-12-17 15:33:32 | alarms | 1 | 48755 | 3 | 0.733 | 66514.3 |
586 | 2022-12-13 16:17:41 | alarms | 3 | 112716 | 838 | 5.030 | 22408.7 |
585 | 2022-12-03 14:24:20 | alarms | 1 | 48755 | 3 | 0.750 | 65006.7 |
584 | 2022-08-30 16:59:07 | alarms | 1 | 48755 | 3 | 0.766 | 63648.8 |
583 | 2022-08-28 07:01:20 | alarms | 1 | 48755 | 3 | 0.750 | 65006.7 |
582 | 2022-08-23 08:58:01 | alarms | 1 | 48755 | 3 | 0.780 | 62506.4 |
581 | 2022-06-30 14:37:28 | alarms | 3 | 112716 | 838 | 4.873 | 23130.7 |
580 | 2022-06-28 10:11:21 | alarms | 3 | 112716 | 838 | 4.830 | 23336.6 |
579 | 2022-05-14 04:49:00 | alarms | 1 | 48755 | 3 | 0.860 | 56691.9 |
578 | 2022-05-10 19:53:17 | alarms | 1 | 48755 | 3 | 1.156 | 42175.6 |
577 | 2022-04-10 19:30:40 | alarms | 1 | 48755 | 3 | 0.876 | 55656.4 |
576 | 2022-02-09 17:58:52 | alarms | 3 | 112716 | 838 | 5.110 | 22057.9 |
575 | 2022-02-06 00:36:03 | alarms | 1 | 48755 | 3 | 0.830 | 58741.0 |
574 | 2022-01-10 22:17:14 | alarms | 1 | 48755 | 3 | 0.813 | 59969.2 |
573 | 2021-11-13 03:25:33 | alarms | 1 | 48755 | 3 | 0.906 | 53813.5 |
572 | 2021-11-01 18:32:36 | alarms | 1 | 48755 | 3 | 0.860 | 56691.9 |
571 | 2021-10-02 23:21:45 | alarms | 1 | 48755 | 3 | 0.953 | 51159.5 |
570 | 2021-09-30 20:01:02 | alarms | 1 | 48755 | 3 | 0.970 | 50262.9 |
569 | 2021-08-27 03:54:32 | alarms | 1 | 48755 | 3 | 0.766 | 63648.8 |
568 | 2021-08-24 23:59:38 | alarms | 1 | 48755 | 3 | 0.780 | 62506.4 |
567 | 2021-08-01 23:20:57 | alarms | 1 | 48755 | 3 | 0.766 | 63648.8 |
566 | 2021-07-28 13:50:25 | alarms | 1 | 48755 | 3 | 0.766 | 63648.8 |
565 | 2021-05-19 22:24:53 | alarms | 1 | 48755 | 3 | 0.783 | 62266.9 |
564 | 2021-05-01 08:57:32 | alarms | 1 | 48755 | 3 | 0.920 | 52994.6 |
563 | 2021-04-20 00:13:34 | alarms | 1 | 48755 | 3 | 0.876 | 55656.4 |
562 | 2021-04-13 01:03:02 | alarms | 1 | 48755 | 3 | 0.936 | 52088.7 |
561 | 2021-03-24 13:43:50 | alarms | 1 | 48755 | 3 | 0.860 | 56691.9 |
560 | 2021-03-23 12:23:26 | alarms | 1 | 48755 | 3 | 0.830 | 58741.0 |
559 | 2021-03-22 21:54:27 | alarms | 1 | 48755 | 3 | 0.903 | 53992.2 |
558 | 2021-03-21 21:16:21 | alarms | 1 | 48755 | 3 | 1.733 | 28133.3 |
557 | 2021-02-01 05:48:14 | alarms | 1 | 48755 | 3 | 0.763 | 63899.1 |
556 | 2021-01-30 04:21:42 | alarms | 1 | 48755 | 3 | 0.763 | 63899.1 |
555 | 2021-01-28 22:14:02 | alarms | 1 | 48755 | 3 | 0.860 | 56691.9 |
554 | 2021-01-26 18:56:35 | alarms | 1 | 48755 | 3 | 0.783 | 62266.9 |
553 | 2021-01-26 18:39:09 | alarms | 1 | 48755 | 3 | 0.780 | 62506.4 |
552 | 2021-01-04 16:39:11 | alarms | 1 | 48755 | 3 | 0.796 | 61250.0 |
551 | 2020-12-07 13:44:13 | alarms | 1 | 48755 | 3 | 1.530 | 31866.0 |
550 | 2020-11-18 21:35:54 | alarms | 3 | 112716 | 838 | 5.343 | 21096.0 |
549 | 2020-11-02 13:04:35 | alarms | 3 | 112716 | 838 | 5.126 | 21989.1 |
548 | 2020-11-02 13:04:34 | alarms | 1 | 48755 | 3 | 0.796 | 61250.0 |
547 | 2020-10-26 03:05:57 | alarms | 1 | 48755 | 3 | 0.766 | 63648.8 |
546 | 2020-10-22 16:45:15 | alarms | 3 | 112716 | 838 | 4.986 | 22606.5 |
545 | 2020-10-17 17:07:35 | alarms | 1 | 48755 | 3 | 0.830 | 58741.0 |
544 | 2020-10-15 01:12:30 | alarms | 1 | 48755 | 3 | 0.780 | 62506.4 |
543 | 2020-10-01 23:06:52 | alarms | 1 | 48755 | 3 | 0.826 | 59025.4 |
542 | 2020-09-05 23:08:40 | alarms | 1 | 48755 | 3 | 0.750 | 65006.7 |
541 | 2020-09-04 04:50:56 | alarms | 1 | 48755 | 3 | 0.813 | 59969.2 |
540 | 2020-08-29 02:32:35 | alarms | 1 | 48755 | 3 | 1.000 | 48755.0 |
539 | 2020-08-20 17:14:07 | alarms | 1 | 48755 | 3 | 0.780 | 62506.4 |
538 | 2020-07-30 03:56:01 | alarms | 1 | 48755 | 3 | 0.813 | 59969.2 |
537 | 2020-07-22 12:45:55 | alarms | 1 | 48755 | 3 | 0.796 | 61250.0 |
536 | 2020-07-20 09:48:29 | alarms | 1 | 48755 | 3 | 0.796 | 61250.0 |