History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cameras"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 849 | 2024-04-28 02:10:41 | cameras | 1 | 69583 | 4 | 1.436 | 48456.1 |
| 848 | 2024-04-10 23:02:25 | cameras | 1 | 69583 | 4 | 1.360 | 51164.0 |
| 847 | 2024-01-23 14:46:57 | cameras | 1 | 69583 | 4 | 4.063 | 17126.0 |
| 846 | 2024-01-02 12:35:29 | cameras | 3 | 134027 | 558 | 7.143 | 18763.4 |
| 845 | 2024-01-02 12:35:27 | cameras | 2 | 107671 | 35 | 3.513 | 30649.3 |
| 844 | 2023-12-26 21:57:30 | cameras | 1 | 69583 | 4 | 1.356 | 51314.9 |
| 843 | 2023-12-19 08:50:10 | cameras | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 842 | 2023-12-17 04:41:19 | cameras | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 841 | 2023-12-07 22:30:18 | cameras | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 840 | 2023-11-21 14:27:14 | cameras | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 839 | 2023-11-15 05:24:13 | cameras | 1 | 69583 | 4 | 1.310 | 53116.8 |
| 838 | 2023-11-14 19:35:18 | cameras | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 837 | 2023-11-09 12:51:05 | cameras | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 836 | 2023-10-16 08:37:24 | cameras | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 835 | 2023-10-13 13:14:40 | cameras | 1 | 69583 | 4 | 2.546 | 27330.3 |
| 834 | 2023-10-12 08:56:53 | cameras | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 833 | 2023-09-28 14:51:46 | cameras | 3 | 134027 | 558 | 10.236 | 13093.7 |
| 832 | 2023-09-24 12:58:19 | cameras | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 831 | 2023-09-24 05:52:26 | cameras | 3 | 134027 | 558 | 7.826 | 17125.9 |
| 830 | 2023-09-19 04:23:24 | cameras | 3 | 134027 | 558 | 6.063 | 22105.7 |
| 829 | 2023-09-15 04:29:13 | cameras | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 828 | 2023-08-12 14:59:17 | cameras | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 827 | 2023-07-26 22:38:42 | cameras | 3 | 134027 | 558 | 6.330 | 21173.3 |
| 826 | 2023-07-06 12:21:16 | cameras | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 825 | 2023-05-11 20:23:32 | cameras | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 824 | 2023-04-23 17:13:02 | cameras | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 823 | 2023-03-29 23:54:46 | cameras | 1 | 69583 | 4 | 1.200 | 57985.8 |
| 822 | 2023-03-26 15:07:26 | cameras | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 821 | 2023-03-23 21:44:28 | cameras | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 820 | 2023-03-04 03:47:57 | cameras | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 819 | 2022-12-28 00:43:26 | cameras | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 818 | 2022-12-21 04:40:49 | cameras | 1 | 69583 | 4 | 1.326 | 52475.9 |
| 817 | 2022-12-19 22:52:34 | cameras | 3 | 134027 | 558 | 8.686 | 15430.2 |
| 816 | 2022-12-18 13:41:37 | cameras | 3 | 134027 | 558 | 7.173 | 18684.9 |
| 815 | 2022-12-17 18:14:57 | cameras | 3 | 134027 | 558 | 7.873 | 17023.6 |
| 814 | 2022-12-16 23:18:04 | cameras | 3 | 134027 | 558 | 6.093 | 21996.9 |
| 813 | 2022-12-15 22:28:31 | cameras | 3 | 134027 | 558 | 6.830 | 19623.3 |
| 812 | 2022-12-13 15:21:25 | cameras | 3 | 134027 | 558 | 6.313 | 21230.3 |
| 811 | 2022-12-12 19:50:54 | cameras | 3 | 134027 | 558 | 9.690 | 13831.5 |
| 810 | 2022-12-11 14:01:00 | cameras | 3 | 134027 | 558 | 7.250 | 18486.5 |
| 809 | 2022-12-09 15:56:10 | cameras | 3 | 134027 | 558 | 13.843 | 9681.9 |
| 808 | 2022-12-08 23:45:16 | cameras | 3 | 134027 | 558 | 5.986 | 22390.1 |
| 807 | 2022-11-25 20:00:05 | cameras | 2 | 107671 | 35 | 2.923 | 36835.8 |
| 806 | 2022-10-13 05:18:26 | cameras | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 805 | 2022-09-17 08:25:25 | cameras | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 804 | 2022-09-10 16:26:30 | cameras | 3 | 134027 | 558 | 5.966 | 22465.1 |
| 803 | 2022-09-06 23:28:11 | cameras | 1 | 69583 | 4 | 1.436 | 48456.1 |
| 802 | 2022-08-15 04:09:50 | cameras | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 801 | 2022-08-09 19:53:26 | cameras | 3 | 134027 | 558 | 6.076 | 22058.4 |
| 800 | 2022-07-29 11:33:29 | cameras | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 799 | 2022-07-12 20:14:20 | cameras | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 798 | 2022-05-29 00:07:34 | cameras | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 797 | 2022-04-19 02:45:41 | cameras | 2 | 107671 | 35 | 3.376 | 31893.1 |
| 796 | 2022-03-04 12:31:49 | cameras | 1 | 69583 | 4 | 1.640 | 42428.7 |
| 795 | 2022-03-02 08:54:44 | cameras | 1 | 69583 | 4 | 1.720 | 40455.2 |
| 794 | 2022-02-21 02:33:10 | cameras | 1 | 69583 | 4 | 2.563 | 27149.0 |
| 793 | 2021-12-22 10:51:34 | cameras | 2 | 107671 | 35 | 3.593 | 29966.9 |
| 792 | 2021-12-19 16:25:08 | cameras | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 791 | 2021-12-19 08:04:42 | cameras | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 790 | 2021-12-18 19:58:01 | cameras | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 789 | 2021-12-17 23:42:26 | cameras | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 788 | 2021-12-10 20:26:59 | cameras | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 787 | 2021-11-19 16:37:06 | cameras | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 786 | 2021-10-25 07:28:31 | cameras | 2 | 107671 | 35 | 3.373 | 31921.4 |
| 785 | 2021-10-21 17:48:02 | cameras | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 784 | 2021-10-21 04:42:17 | cameras | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 783 | 2021-10-14 01:08:40 | cameras | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 782 | 2021-09-18 20:29:05 | cameras | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 781 | 2021-09-18 06:37:36 | cameras | 1 | 69583 | 4 | 1.500 | 46388.7 |
| 780 | 2021-09-17 14:18:18 | cameras | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 779 | 2021-09-11 16:01:58 | cameras | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 778 | 2021-09-05 17:58:05 | cameras | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 777 | 2021-08-19 03:07:47 | cameras | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 776 | 2021-08-16 19:47:01 | cameras | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 775 | 2021-06-08 05:50:41 | cameras | 1 | 69583 | 4 | 1.096 | 63488.1 |
| 774 | 2021-05-27 23:11:04 | cameras | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 773 | 2021-05-16 03:15:49 | cameras | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 772 | 2021-05-15 19:03:50 | cameras | 2 | 107671 | 35 | 2.876 | 37437.8 |
| 771 | 2021-05-12 18:52:31 | cameras | 1 | 69583 | 4 | 1.406 | 49490.0 |
| 770 | 2021-05-02 05:05:37 | cameras | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 769 | 2021-03-31 10:56:32 | cameras | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 768 | 2021-03-28 08:28:09 | cameras | 3 | 134027 | 558 | 6.686 | 20045.9 |
| 767 | 2021-03-27 16:47:02 | cameras | 3 | 134027 | 558 | 6.283 | 21331.7 |
| 766 | 2021-03-05 05:45:15 | cameras | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 765 | 2021-03-02 09:10:59 | cameras | 3 | 134027 | 558 | 5.940 | 22563.5 |
| 764 | 2021-03-01 11:57:47 | cameras | 3 | 134027 | 558 | 5.986 | 22390.1 |
| 763 | 2021-02-25 09:48:17 | cameras | 3 | 134027 | 558 | 6.923 | 19359.7 |
| 762 | 2021-02-21 11:19:16 | cameras | 2 | 107671 | 35 | 3.140 | 34290.1 |
| 761 | 2021-02-09 04:54:52 | cameras | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 760 | 2021-02-08 21:19:26 | cameras | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 759 | 2021-02-03 15:48:45 | cameras | 1 | 69583 | 4 | 1.326 | 52475.9 |
| 758 | 2021-02-01 11:12:35 | cameras | 3 | 134027 | 558 | 6.013 | 22289.5 |
| 757 | 2021-01-15 00:16:03 | cameras | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 756 | 2021-01-05 00:10:15 | cameras | 3 | 134027 | 558 | 6.500 | 20619.5 |
| 755 | 2020-12-29 11:39:00 | cameras | 3 | 134027 | 558 | 5.936 | 22578.7 |
| 754 | 2020-12-29 11:38:57 | cameras | 2 | 107671 | 35 | 2.906 | 37051.3 |
| 753 | 2020-12-29 11:38:55 | cameras | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 752 | 2020-11-20 17:33:51 | cameras | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 751 | 2020-11-07 01:19:13 | cameras | 3 | 134027 | 558 | 6.063 | 22105.7 |
| 750 | 2020-11-01 22:25:13 | cameras | 1 | 69583 | 4 | 1.106 | 62914.1 |