History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"presenters"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 221 | 2024-05-07 15:31:42 | presenters | 3 | 140603 | 116 | 11.670 | 12048.2 |
| 220 | 2024-05-07 05:43:21 | presenters | 3 | 140603 | 116 | 11.483 | 12244.4 |
| 219 | 2024-05-07 05:43:19 | presenters | 2 | 108824 | 21 | 5.530 | 19678.8 |
| 218 | 2024-05-07 02:36:24 | presenters | 1 | 67641 | 4 | 1.236 | 54725.7 |
| 217 | 2024-05-06 23:10:15 | presenters | 1 | 67641 | 4 | 2.466 | 27429.4 |
| 216 | 2024-05-04 02:47:07 | presenters | 1 | 67641 | 4 | 2.656 | 25467.2 |
| 215 | 2024-05-02 09:48:03 | presenters | 3 | 140603 | 116 | 7.643 | 18396.3 |
| 214 | 2024-04-27 16:12:19 | presenters | 1 | 67641 | 4 | 1.156 | 58513.0 |
| 213 | 2024-04-17 14:53:02 | presenters | 2 | 108824 | 21 | 11.563 | 9411.4 |
| 212 | 2024-04-17 13:42:17 | presenters | 1 | 67641 | 4 | 1.440 | 46972.9 |
| 211 | 2024-04-08 08:19:01 | presenters | 1 | 67641 | 4 | 1.326 | 51011.3 |
| 210 | 2024-04-08 01:57:45 | presenters | 3 | 140603 | 116 | 20.156 | 6975.7 |
| 209 | 2024-04-08 01:56:34 | presenters | 2 | 108824 | 21 | 11.580 | 9397.6 |
| 208 | 2024-04-07 01:50:32 | presenters | 2 | 108824 | 21 | 9.986 | 10897.7 |
| 207 | 2024-04-07 01:50:26 | presenters | 3 | 140603 | 116 | 8.843 | 15899.9 |
| 206 | 2024-04-07 01:43:54 | presenters | 1 | 67641 | 4 | 3.376 | 20035.8 |
| 205 | 2024-04-06 20:03:41 | presenters | 2 | 108824 | 21 | 12.406 | 8771.9 |
| 204 | 2024-04-06 18:55:02 | presenters | 1 | 67641 | 4 | 1.593 | 42461.4 |
| 203 | 2024-04-03 23:54:48 | presenters | 3 | 140603 | 116 | 18.343 | 7665.2 |
| 202 | 2024-04-03 23:54:48 | presenters | 2 | 108824 | 21 | 7.313 | 14880.9 |
| 201 | 2024-04-03 23:49:06 | presenters | 1 | 67641 | 4 | 1.500 | 45094.0 |
| 200 | 2024-04-02 02:59:52 | presenters | 1 | 67641 | 4 | 1.390 | 48662.6 |
| 199 | 2024-03-28 11:23:33 | presenters | 1 | 67641 | 4 | 1.190 | 56841.2 |
| 198 | 2024-03-15 12:57:30 | presenters | 2 | 108824 | 21 | 7.750 | 14041.8 |
| 197 | 2024-03-15 12:25:30 | presenters | 1 | 67641 | 4 | 4.046 | 16718.0 |
| 196 | 2024-03-05 04:44:13 | presenters | 3 | 140603 | 116 | 12.313 | 11419.1 |
| 195 | 2024-03-05 04:44:12 | presenters | 2 | 108824 | 21 | 3.813 | 28540.3 |
| 194 | 2024-03-05 03:24:00 | presenters | 1 | 67641 | 4 | 3.796 | 17819.0 |
| 193 | 2024-03-04 20:36:20 | presenters | 1 | 67641 | 4 | 1.266 | 53428.9 |
| 192 | 2024-03-02 02:47:23 | presenters | 1 | 67641 | 4 | 1.376 | 49157.7 |
| 191 | 2024-02-27 08:16:16 | presenters | 1 | 67641 | 4 | 1.030 | 65670.9 |
| 190 | 2024-02-01 02:39:28 | presenters | 1 | 67641 | 4 | 2.090 | 32364.1 |
| 189 | 2024-01-31 16:36:00 | presenters | 1 | 67641 | 4 | 1.326 | 51011.3 |
| 188 | 2024-01-31 03:03:54 | presenters | 1 | 67641 | 4 | 1.186 | 57032.9 |
| 187 | 2024-01-30 13:37:14 | presenters | 1 | 67641 | 4 | 1.280 | 52844.5 |
| 186 | 2024-01-26 04:26:23 | presenters | 1 | 67641 | 4 | 1.236 | 54725.7 |
| 185 | 2024-01-21 18:38:08 | presenters | 1 | 67641 | 4 | 1.140 | 59334.2 |
| 184 | 2023-12-31 00:59:11 | presenters | 1 | 67641 | 4 | 1.080 | 62630.6 |
| 183 | 2023-12-25 05:23:36 | presenters | 3 | 140603 | 116 | 5.686 | 24727.9 |
| 182 | 2023-11-26 04:25:06 | presenters | 1 | 67641 | 4 | 1.220 | 55443.4 |
| 181 | 2023-11-22 02:00:53 | presenters | 1 | 67641 | 4 | 1.063 | 63632.2 |
| 180 | 2023-09-26 06:02:14 | presenters | 3 | 140603 | 116 | 6.576 | 21381.2 |
| 179 | 2023-09-12 03:17:03 | presenters | 1 | 67641 | 4 | 1.060 | 63812.3 |
| 178 | 2023-08-25 07:11:40 | presenters | 1 | 67641 | 4 | 2.513 | 26916.4 |
| 177 | 2023-07-05 10:01:20 | presenters | 3 | 140603 | 116 | 5.733 | 24525.2 |
| 176 | 2023-06-16 05:54:33 | presenters | 1 | 67641 | 4 | 1.046 | 64666.3 |
| 175 | 2023-05-11 16:07:56 | presenters | 1 | 67641 | 4 | 1.033 | 65480.2 |
| 174 | 2023-03-31 10:25:01 | presenters | 1 | 67641 | 4 | 1.016 | 66575.8 |
| 173 | 2023-03-25 21:57:26 | presenters | 3 | 140603 | 116 | 5.876 | 23928.4 |
| 172 | 2023-02-14 21:16:57 | presenters | 1 | 67641 | 4 | 1.190 | 56841.2 |
| 171 | 2023-01-25 21:25:57 | presenters | 1 | 67641 | 4 | 1.016 | 66575.8 |
| 170 | 2023-01-14 10:25:18 | presenters | 3 | 140603 | 116 | 5.753 | 24439.9 |
| 169 | 2023-01-13 23:51:19 | presenters | 1 | 67641 | 4 | 1.046 | 64666.3 |
| 168 | 2023-01-12 13:31:42 | presenters | 1 | 67641 | 4 | 1.030 | 65670.9 |
| 167 | 2022-12-26 13:51:09 | presenters | 1 | 67641 | 4 | 1.140 | 59334.2 |
| 166 | 2022-12-24 00:03:38 | presenters | 3 | 140603 | 116 | 5.580 | 25197.7 |
| 165 | 2022-12-22 10:29:39 | presenters | 3 | 140603 | 116 | 6.470 | 21731.5 |
| 164 | 2022-11-23 11:07:32 | presenters | 1 | 67641 | 4 | 1.046 | 64666.3 |
| 163 | 2022-11-19 16:06:13 | presenters | 1 | 67641 | 4 | 1.046 | 64666.3 |
| 162 | 2022-11-10 11:05:24 | presenters | 1 | 67641 | 4 | 1.030 | 65670.9 |
| 161 | 2022-11-08 07:51:17 | presenters | 3 | 140603 | 116 | 5.780 | 24325.8 |
| 160 | 2022-11-05 11:21:29 | presenters | 3 | 140603 | 116 | 6.206 | 22656.0 |
| 159 | 2022-10-31 10:31:40 | presenters | 1 | 67641 | 4 | 2.470 | 27385.0 |
| 158 | 2022-10-01 08:09:20 | presenters | 3 | 140603 | 116 | 5.716 | 24598.1 |
| 157 | 2022-09-30 18:02:44 | presenters | 1 | 67641 | 4 | 1.076 | 62863.4 |
| 156 | 2022-08-19 15:52:22 | presenters | 3 | 140603 | 116 | 5.563 | 25274.7 |
| 155 | 2022-06-19 20:15:05 | presenters | 1 | 67641 | 4 | 1.080 | 62630.6 |
| 154 | 2022-06-06 13:05:46 | presenters | 1 | 67641 | 4 | 1.063 | 63632.2 |
| 153 | 2022-03-12 05:33:06 | presenters | 1 | 67641 | 4 | 1.110 | 60937.8 |
| 152 | 2022-02-18 15:43:27 | presenters | 1 | 67641 | 4 | 1.750 | 38652.0 |
| 151 | 2022-02-12 21:05:36 | presenters | 1 | 67641 | 4 | 1.156 | 58513.0 |
| 150 | 2022-01-12 06:32:19 | presenters | 1 | 67641 | 4 | 1.140 | 59334.2 |
| 149 | 2021-10-29 04:17:00 | presenters | 1 | 67641 | 4 | 1.046 | 64666.3 |
| 148 | 2021-10-25 22:25:29 | presenters | 1 | 67641 | 4 | 1.033 | 65480.2 |
| 147 | 2021-07-19 00:01:07 | presenters | 1 | 67641 | 4 | 1.170 | 57812.8 |
| 146 | 2021-04-16 08:30:45 | presenters | 1 | 67641 | 4 | 1.220 | 55443.4 |
| 145 | 2021-04-12 11:56:27 | presenters | 1 | 67641 | 4 | 1.203 | 56226.9 |
| 144 | 2021-02-26 21:47:25 | presenters | 2 | 108824 | 21 | 2.766 | 39343.5 |
| 143 | 2021-01-02 18:06:10 | presenters | 1 | 67641 | 4 | 1.060 | 63812.3 |
| 142 | 2020-12-21 08:00:08 | presenters | 3 | 140603 | 116 | 6.190 | 22714.5 |
| 141 | 2020-11-29 01:57:13 | presenters | 1 | 67641 | 4 | 1.063 | 63632.2 |
| 140 | 2020-10-31 16:50:02 | presenters | 1 | 67641 | 4 | 1.093 | 61885.6 |
| 139 | 2020-10-29 13:45:23 | presenters | 1 | 67641 | 4 | 2.470 | 27385.0 |
| 138 | 2020-10-21 09:02:53 | presenters | 1 | 67641 | 4 | 1.063 | 63632.2 |
| 137 | 2020-09-30 20:48:01 | presenters | 1 | 67641 | 4 | 1.143 | 59178.5 |
| 136 | 2020-08-26 11:51:34 | presenters | 1 | 67641 | 4 | 1.126 | 60071.9 |
| 135 | 2020-06-20 23:39:25 | presenters | 1 | 67641 | 4 | 1.343 | 50365.6 |
| 134 | 2020-06-17 19:41:06 | presenters | 1 | 67641 | 4 | 1.376 | 49157.7 |
| 133 | 2020-03-23 04:31:43 | presenters | 1 | 67641 | 4 | 1.190 | 56841.2 |
| 132 | 2020-03-20 03:37:18 | presenters | 1 | 67641 | 4 | 1.140 | 59334.2 |
| 131 | 2020-03-10 02:30:25 | presenters | 1 | 67641 | 4 | 1.220 | 55443.4 |
| 130 | 2020-02-28 06:56:11 | presenters | 1 | 67641 | 4 | 4.110 | 16457.7 |
| 129 | 2020-02-26 05:01:54 | presenters | 1 | 67641 | 4 | 1.296 | 52192.1 |
| 128 | 2020-02-21 04:23:27 | presenters | 3 | 140603 | 116 | 11.513 | 12212.5 |
| 127 | 2020-02-20 13:39:17 | presenters | 3 | 140603 | 116 | 12.673 | 11094.7 |
| 126 | 2020-02-20 06:54:27 | presenters | 3 | 140603 | 116 | 13.080 | 10749.5 |
| 125 | 2020-02-19 17:54:55 | presenters | 3 | 140603 | 116 | 8.390 | 16758.4 |
| 124 | 2020-02-15 11:57:34 | presenters | 1 | 67641 | 4 | 2.670 | 25333.7 |
| 123 | 2020-02-09 11:53:55 | presenters | 1 | 67641 | 4 | 1.313 | 51516.4 |
| 122 | 2020-02-04 14:19:02 | presenters | 2 | 108824 | 21 | 7.846 | 13870.0 |