History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"airplay"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
708 | 2024-04-23 17:29:00 | airplay | 1 | 69583 | 2 | 1.216 | 57222.9 |
707 | 2024-04-06 13:28:20 | airplay | 4 | 151207 | 950 | 29.643 | 5100.9 |
706 | 2024-04-06 13:28:21 | airplay | 2 | 107671 | 8 | 9.546 | 11279.2 |
705 | 2024-04-06 13:18:54 | airplay | 3 | 134027 | 72 | 8.280 | 16186.8 |
704 | 2024-04-06 12:28:37 | airplay | 3 | 134027 | 72 | 23.280 | 5757.2 |
703 | 2024-04-04 08:06:27 | airplay | 1 | 69583 | 2 | 1.640 | 42428.7 |
702 | 2024-04-01 05:57:28 | airplay | 1 | 69583 | 2 | 1.390 | 50059.7 |
701 | 2024-04-01 05:57:19 | airplay | 2 | 107671 | 8 | 3.783 | 28461.8 |
700 | 2024-03-31 14:35:52 | airplay | 4 | 151207 | 950 | 14.000 | 10800.5 |
699 | 2024-03-31 14:05:29 | airplay | 3 | 134027 | 72 | 18.843 | 7112.8 |
698 | 2024-03-31 13:50:59 | airplay | 3 | 134027 | 72 | 12.736 | 10523.5 |
697 | 2024-03-31 12:48:24 | airplay | 4 | 151207 | 950 | 35.723 | 4232.8 |
696 | 2024-03-31 11:47:12 | airplay | 4 | 151207 | 950 | 14.876 | 10164.5 |
695 | 2024-03-31 09:59:09 | airplay | 4 | 151207 | 950 | 32.516 | 4650.2 |
694 | 2024-03-31 09:59:07 | airplay | 3 | 134027 | 72 | 16.783 | 7985.9 |
693 | 2024-03-31 09:59:10 | airplay | 2 | 107671 | 8 | 9.110 | 11819.0 |
692 | 2024-03-31 09:36:53 | airplay | 1 | 69583 | 2 | 4.190 | 16606.9 |
691 | 2024-03-31 03:27:47 | airplay | 1 | 69583 | 2 | 2.813 | 24736.2 |
690 | 2024-03-04 14:25:47 | airplay | 1 | 69583 | 2 | 1.373 | 50679.5 |
689 | 2024-03-01 03:48:16 | airplay | 1 | 69583 | 2 | 1.266 | 54962.9 |
688 | 2024-02-08 19:44:43 | airplay | 2 | 107671 | 8 | 8.326 | 12931.9 |
687 | 2024-02-08 11:14:32 | airplay | 1 | 69583 | 2 | 2.733 | 25460.3 |
686 | 2024-02-08 07:52:30 | airplay | 4 | 151207 | 950 | 26.720 | 5658.9 |
685 | 2024-02-06 14:37:33 | airplay | 4 | 151207 | 950 | 10.876 | 13902.8 |
684 | 2024-01-31 19:46:56 | airplay | 3 | 134027 | 72 | 7.263 | 18453.4 |
683 | 2024-01-31 10:10:11 | airplay | 3 | 134027 | 72 | 14.830 | 9037.6 |
682 | 2024-01-31 10:10:15 | airplay | 2 | 107671 | 8 | 6.486 | 16600.5 |
681 | 2024-01-31 07:42:51 | airplay | 1 | 69583 | 2 | 2.533 | 27470.6 |
680 | 2024-01-26 05:29:25 | airplay | 4 | 151207 | 950 | 13.313 | 11357.8 |
679 | 2024-01-26 05:29:21 | airplay | 3 | 134027 | 72 | 12.843 | 10435.8 |
678 | 2024-01-26 05:16:23 | airplay | 4 | 151207 | 950 | 13.516 | 11187.3 |
677 | 2024-01-26 05:16:27 | airplay | 2 | 107671 | 8 | 7.280 | 14790.0 |
676 | 2024-01-26 05:16:11 | airplay | 3 | 134027 | 72 | 6.846 | 19577.4 |
675 | 2024-01-17 21:14:17 | airplay | 1 | 69583 | 2 | 1.313 | 52995.4 |
674 | 2024-01-13 23:41:58 | airplay | 3 | 134027 | 72 | 6.126 | 21878.4 |
673 | 2023-12-16 00:08:13 | airplay | 4 | 151207 | 950 | 11.640 | 12990.3 |
672 | 2023-12-16 00:08:12 | airplay | 2 | 107671 | 8 | 3.673 | 29314.2 |
671 | 2023-12-02 06:26:37 | airplay | 1 | 69583 | 2 | 1.110 | 62687.4 |
670 | 2023-11-26 15:48:25 | airplay | 1 | 69583 | 2 | 1.236 | 56296.9 |
669 | 2023-11-24 10:03:00 | airplay | 1 | 69583 | 2 | 1.093 | 63662.4 |
668 | 2023-11-14 02:07:20 | airplay | 1 | 69583 | 2 | 1.080 | 64428.7 |
667 | 2023-10-29 01:08:57 | airplay | 1 | 69583 | 2 | 1.236 | 56296.9 |
666 | 2023-10-29 01:05:08 | airplay | 3 | 134027 | 72 | 8.596 | 15591.8 |
665 | 2023-10-23 16:56:56 | airplay | 3 | 134027 | 72 | 6.063 | 22105.7 |
664 | 2023-10-15 04:49:40 | airplay | 1 | 69583 | 2 | 1.093 | 63662.4 |
663 | 2023-10-03 17:29:57 | airplay | 1 | 69583 | 2 | 1.186 | 58670.3 |
662 | 2023-08-31 18:10:28 | airplay | 1 | 69583 | 2 | 1.060 | 65644.3 |
661 | 2023-08-02 03:54:43 | airplay | 3 | 134027 | 72 | 6.096 | 21986.1 |
660 | 2023-07-30 13:29:08 | airplay | 1 | 69583 | 2 | 1.313 | 52995.4 |
659 | 2023-06-06 04:30:34 | airplay | 1 | 69583 | 2 | 1.063 | 65459.1 |
658 | 2023-04-09 07:00:25 | airplay | 3 | 134027 | 72 | 5.796 | 23124.1 |
657 | 2023-04-07 13:25:00 | airplay | 1 | 69583 | 2 | 2.170 | 32065.9 |
656 | 2023-04-03 19:39:03 | airplay | 1 | 69583 | 2 | 1.203 | 57841.2 |
655 | 2023-03-28 03:03:57 | airplay | 1 | 69583 | 2 | 1.063 | 65459.1 |
654 | 2023-01-11 07:12:37 | airplay | 1 | 69583 | 2 | 1.076 | 64668.2 |
653 | 2023-01-06 08:31:26 | airplay | 3 | 134027 | 72 | 5.796 | 23124.1 |
652 | 2022-12-05 17:27:11 | airplay | 1 | 69583 | 2 | 1.140 | 61037.7 |
651 | 2022-10-25 20:25:06 | airplay | 1 | 69583 | 2 | 1.140 | 61037.7 |
650 | 2022-09-10 10:04:33 | airplay | 3 | 134027 | 72 | 5.893 | 22743.4 |
649 | 2022-08-05 13:28:13 | airplay | 1 | 69583 | 2 | 1.173 | 59320.5 |
648 | 2022-06-15 23:28:03 | airplay | 1 | 69583 | 2 | 1.123 | 61961.7 |
647 | 2022-04-07 14:03:15 | airplay | 1 | 69583 | 2 | 1.466 | 47464.5 |
646 | 2022-02-19 05:08:05 | airplay | 1 | 69583 | 2 | 1.110 | 62687.4 |
645 | 2021-12-23 02:48:33 | airplay | 1 | 69583 | 2 | 1.186 | 58670.3 |
644 | 2021-12-17 04:17:06 | airplay | 1 | 69583 | 2 | 1.093 | 63662.4 |
643 | 2021-09-19 04:31:11 | airplay | 1 | 69583 | 2 | 1.110 | 62687.4 |
642 | 2021-09-03 10:05:20 | airplay | 1 | 69583 | 2 | 1.110 | 62687.4 |
641 | 2021-06-02 13:11:15 | airplay | 1 | 69583 | 2 | 1.233 | 56433.9 |
640 | 2021-05-03 08:17:35 | airplay | 1 | 69583 | 2 | 1.296 | 53690.6 |
639 | 2021-04-01 13:38:49 | airplay | 1 | 69583 | 2 | 1.250 | 55666.4 |
638 | 2021-02-27 21:33:27 | airplay | 1 | 69583 | 2 | 1.093 | 63662.4 |
637 | 2021-01-16 16:14:37 | airplay | 1 | 69583 | 2 | 1.190 | 58473.1 |
636 | 2020-11-23 06:49:20 | airplay | 1 | 69583 | 2 | 1.093 | 63662.4 |
635 | 2020-11-21 20:56:10 | airplay | 1 | 69583 | 2 | 1.096 | 63488.1 |
634 | 2020-11-20 20:30:24 | airplay | 1 | 69583 | 2 | 1.186 | 58670.3 |
633 | 2020-11-08 00:23:38 | airplay | 1 | 69583 | 2 | 1.296 | 53690.6 |
632 | 2020-10-28 01:55:44 | airplay | 1 | 69583 | 2 | 1.123 | 61961.7 |
631 | 2020-10-27 07:23:08 | airplay | 1 | 69583 | 2 | 1.076 | 64668.2 |
630 | 2020-10-25 00:04:52 | airplay | 1 | 69583 | 2 | 2.436 | 28564.4 |
629 | 2020-08-18 17:22:30 | airplay | 1 | 69583 | 2 | 1.080 | 64428.7 |
628 | 2020-05-14 07:59:10 | airplay | 1 | 69583 | 2 | 1.080 | 64428.7 |
627 | 2020-03-29 19:40:15 | airplay | 1 | 69583 | 2 | 1.483 | 46920.4 |
626 | 2020-03-28 17:09:35 | airplay | 1 | 69583 | 2 | 1.263 | 55093.4 |
625 | 2020-03-26 17:39:10 | airplay | 1 | 69583 | 2 | 1.250 | 55666.4 |
624 | 2020-03-24 16:33:06 | airplay | 1 | 69583 | 2 | 1.283 | 54234.6 |
623 | 2020-03-21 15:16:29 | airplay | 1 | 69583 | 2 | 1.093 | 63662.4 |
622 | 2020-02-25 06:06:03 | airplay | 1 | 69583 | 2 | 1.313 | 52995.4 |
621 | 2020-02-24 02:03:22 | airplay | 1 | 69583 | 2 | 1.326 | 52475.9 |
620 | 2020-02-11 17:29:38 | airplay | 1 | 69583 | 2 | 2.753 | 25275.3 |
619 | 2020-02-08 06:42:39 | airplay | 1 | 69583 | 2 | 1.593 | 43680.5 |
618 | 2020-02-08 01:09:15 | airplay | 1 | 69583 | 2 | 2.720 | 25582.0 |
617 | 2020-02-07 04:34:22 | airplay | 1 | 69583 | 2 | 1.296 | 53690.6 |
616 | 2020-02-02 20:48:42 | airplay | 1 | 69583 | 2 | 2.843 | 24475.2 |
615 | 2020-02-01 04:09:26 | airplay | 1 | 69583 | 2 | 1.390 | 50059.7 |
614 | 2020-01-27 07:19:17 | airplay | 1 | 69583 | 2 | 1.283 | 54234.6 |
613 | 2020-01-22 18:43:10 | airplay | 1 | 69583 | 2 | 4.046 | 17198.0 |
612 | 2020-01-13 02:04:25 | airplay | 1 | 69583 | 2 | 1.313 | 52995.4 |
611 | 2020-01-07 13:05:34 | airplay | 1 | 69583 | 2 | 1.140 | 61037.7 |
610 | 2020-01-07 11:56:53 | airplay | 1 | 69583 | 2 | 1.390 | 50059.7 |
609 | 2019-12-31 19:20:35 | airplay | 1 | 69583 | 2 | 1.360 | 51164.0 |