History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"purposes"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 275 | 2024-04-08 07:09:48 | purposes | 1 | 82945 | 3 | 2.000 | 41472.5 |
| 274 | 2024-04-06 18:18:01 | purposes | 1 | 82945 | 3 | 3.733 | 22219.4 |
| 273 | 2024-04-03 14:59:20 | purposes | 1 | 82945 | 3 | 3.830 | 21656.7 |
| 272 | 2024-03-29 10:21:41 | purposes | 2 | 121059 | 14 | 6.860 | 17647.1 |
| 271 | 2024-03-29 00:04:43 | purposes | 3 | 146162 | 176 | 13.173 | 11095.6 |
| 270 | 2024-03-28 20:29:01 | purposes | 1 | 82945 | 3 | 2.653 | 31264.6 |
| 269 | 2024-03-28 20:28:49 | purposes | 3 | 146162 | 176 | 7.970 | 18339.0 |
| 268 | 2024-03-28 20:28:51 | purposes | 2 | 121059 | 14 | 4.063 | 29795.5 |
| 267 | 2024-03-28 20:28:46 | purposes | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 266 | 2024-03-27 14:32:39 | purposes | 1 | 82945 | 3 | 1.623 | 51106.0 |
| 265 | 2024-03-23 08:02:45 | purposes | 1 | 82945 | 3 | 2.440 | 33993.9 |
| 264 | 2024-03-07 13:15:03 | purposes | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 263 | 2024-03-05 08:55:23 | purposes | 2 | 121059 | 14 | 4.203 | 28803.0 |
| 262 | 2024-03-03 09:13:32 | purposes | 2 | 121059 | 14 | 3.860 | 31362.4 |
| 261 | 2024-02-29 00:26:28 | purposes | 2 | 121059 | 14 | 3.780 | 32026.2 |
| 260 | 2024-02-29 00:26:16 | purposes | 3 | 146162 | 176 | 7.280 | 20077.2 |
| 259 | 2024-02-28 11:59:43 | purposes | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 258 | 2024-02-27 22:39:23 | purposes | 2 | 121059 | 14 | 5.813 | 20825.6 |
| 257 | 2024-02-27 22:39:11 | purposes | 3 | 146162 | 176 | 9.110 | 16044.1 |
| 256 | 2024-02-27 17:36:59 | purposes | 3 | 146162 | 176 | 7.440 | 19645.4 |
| 255 | 2024-02-27 17:36:55 | purposes | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 254 | 2024-02-05 20:27:18 | purposes | 2 | 121059 | 14 | 3.500 | 34588.3 |
| 253 | 2024-01-23 17:42:47 | purposes | 3 | 146162 | 176 | 17.970 | 8133.7 |
| 252 | 2024-01-23 01:51:50 | purposes | 3 | 146162 | 176 | 17.030 | 8582.6 |
| 251 | 2024-01-17 14:29:59 | purposes | 3 | 146162 | 176 | 7.266 | 20115.9 |
| 250 | 2024-01-17 14:29:57 | purposes | 2 | 121059 | 14 | 3.703 | 32692.1 |
| 249 | 2023-12-20 06:11:43 | purposes | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 248 | 2023-12-15 14:14:47 | purposes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 247 | 2023-12-12 05:11:05 | purposes | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 246 | 2023-12-08 08:24:28 | purposes | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 245 | 2023-12-02 08:23:44 | purposes | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 244 | 2023-11-22 02:00:44 | purposes | 2 | 121059 | 14 | 3.156 | 38358.4 |
| 243 | 2023-11-02 08:53:20 | purposes | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 242 | 2023-10-07 18:10:23 | purposes | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 241 | 2023-08-23 04:25:13 | purposes | 2 | 121059 | 14 | 3.750 | 32282.4 |
| 240 | 2023-08-09 03:37:57 | purposes | 1 | 82945 | 3 | 1.346 | 61623.3 |
| 239 | 2023-08-04 02:07:22 | purposes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 238 | 2023-05-08 19:58:48 | purposes | 2 | 121059 | 14 | 3.140 | 38553.8 |
| 237 | 2023-04-28 03:21:34 | purposes | 1 | 82945 | 3 | 1.300 | 63803.8 |
| 236 | 2023-04-20 12:01:10 | purposes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 235 | 2023-03-03 01:03:53 | purposes | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 234 | 2023-02-16 12:06:09 | purposes | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 233 | 2023-02-14 07:32:07 | purposes | 2 | 121059 | 14 | 3.516 | 34430.9 |
| 232 | 2023-01-17 09:01:36 | purposes | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 231 | 2022-12-31 15:02:28 | purposes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 230 | 2022-12-15 03:01:04 | purposes | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 229 | 2022-11-24 08:17:35 | purposes | 2 | 121059 | 14 | 3.126 | 38726.5 |
| 228 | 2022-08-24 00:26:49 | purposes | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 227 | 2022-08-19 07:52:27 | purposes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 226 | 2022-05-06 19:26:30 | purposes | 2 | 121059 | 14 | 3.296 | 36729.1 |
| 225 | 2022-04-15 17:45:03 | purposes | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 224 | 2022-04-13 14:15:10 | purposes | 1 | 82945 | 3 | 1.766 | 46967.7 |
| 223 | 2022-04-12 23:05:25 | purposes | 1 | 82945 | 3 | 3.500 | 23698.6 |
| 222 | 2022-02-03 21:38:55 | purposes | 1 | 82945 | 3 | 2.983 | 27805.9 |
| 221 | 2022-01-11 11:18:09 | purposes | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 220 | 2021-12-28 11:02:44 | purposes | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 219 | 2021-11-11 14:07:38 | purposes | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 218 | 2021-11-10 15:04:22 | purposes | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 217 | 2021-10-13 20:51:37 | purposes | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 216 | 2021-09-08 10:38:10 | purposes | 1 | 82945 | 3 | 2.923 | 28376.7 |
| 215 | 2021-07-10 16:03:57 | purposes | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 214 | 2021-06-07 12:46:01 | purposes | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 213 | 2021-06-04 08:04:35 | purposes | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 212 | 2021-04-28 10:53:31 | purposes | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 211 | 2021-03-05 08:01:36 | purposes | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 210 | 2021-01-11 13:26:05 | purposes | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 209 | 2020-12-11 16:33:43 | purposes | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 208 | 2020-11-30 11:14:57 | purposes | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 207 | 2020-10-31 02:06:32 | purposes | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 206 | 2020-10-24 08:01:26 | purposes | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 205 | 2020-10-17 06:48:42 | purposes | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 204 | 2020-09-01 12:03:24 | purposes | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 203 | 2020-08-26 18:54:01 | purposes | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 202 | 2020-08-23 15:05:26 | purposes | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 201 | 2020-08-10 11:50:06 | purposes | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 200 | 2020-05-24 14:28:37 | purposes | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 199 | 2020-05-09 23:46:46 | purposes | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 198 | 2020-03-26 20:15:06 | purposes | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 197 | 2020-03-21 04:11:24 | purposes | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 196 | 2020-02-29 10:39:06 | purposes | 1 | 82945 | 3 | 3.170 | 26165.6 |
| 195 | 2020-02-29 09:02:56 | purposes | 1 | 82945 | 3 | 1.640 | 50576.2 |
| 194 | 2020-02-26 07:56:19 | purposes | 1 | 82945 | 3 | 2.156 | 38471.7 |
| 193 | 2020-02-23 17:33:36 | purposes | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 192 | 2020-02-11 08:43:16 | purposes | 1 | 82945 | 3 | 3.206 | 25871.8 |
| 191 | 2020-02-10 04:28:23 | purposes | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 190 | 2020-02-08 06:20:23 | purposes | 1 | 82945 | 3 | 3.360 | 24686.0 |
| 189 | 2020-02-08 01:05:04 | purposes | 1 | 82945 | 3 | 3.250 | 25521.5 |
| 188 | 2020-02-04 11:42:11 | purposes | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 187 | 2020-02-01 11:17:33 | purposes | 1 | 82945 | 3 | 3.186 | 26034.2 |
| 186 | 2020-01-31 17:39:36 | purposes | 1 | 82945 | 3 | 3.360 | 24686.0 |
| 185 | 2020-01-27 22:58:28 | purposes | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 184 | 2020-01-20 20:33:56 | purposes | 1 | 82945 | 3 | 4.280 | 19379.7 |
| 183 | 2020-01-18 15:51:37 | purposes | 1 | 82945 | 3 | 3.203 | 25896.0 |
| 182 | 2020-01-15 09:54:00 | purposes | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 181 | 2020-01-15 08:13:32 | purposes | 1 | 82945 | 3 | 1.623 | 51106.0 |
| 180 | 2020-01-06 22:38:33 | purposes | 1 | 82945 | 3 | 1.750 | 47397.1 |
| 179 | 2020-01-02 13:44:04 | purposes | 1 | 82945 | 3 | 1.953 | 42470.6 |
| 178 | 2019-12-31 18:45:41 | purposes | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 177 | 2019-12-29 18:05:28 | purposes | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 176 | 2019-12-28 03:22:13 | purposes | 1 | 82945 | 3 | 1.530 | 54212.4 |