History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prosected"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 324 | 2024-04-20 16:58:20 | prosected | 2 | 121436 | 17 | 14.956 | 8119.6 |
| 323 | 2024-04-20 03:32:24 | prosected | 3 | 148641 | 102 | 8.610 | 17263.8 |
| 322 | 2024-04-20 03:32:17 | prosected | 2 | 121436 | 17 | 5.046 | 24065.8 |
| 321 | 2024-04-20 03:31:09 | prosected | 1 | 81242 | 5 | 3.436 | 23644.4 |
| 320 | 2024-04-08 00:46:48 | prosected | 3 | 148641 | 102 | 17.860 | 8322.6 |
| 319 | 2024-04-07 20:12:21 | prosected | 2 | 121436 | 17 | 15.033 | 8078.0 |
| 318 | 2024-04-07 20:12:20 | prosected | 3 | 148641 | 102 | 11.033 | 13472.4 |
| 317 | 2024-04-07 20:07:44 | prosected | 1 | 81242 | 5 | 3.440 | 23616.9 |
| 316 | 2024-03-31 20:52:07 | prosected | 1 | 81242 | 5 | 4.580 | 17738.4 |
| 315 | 2024-03-28 06:13:29 | prosected | 1 | 81242 | 5 | 1.360 | 59736.8 |
| 314 | 2024-03-18 12:21:51 | prosected | 2 | 121436 | 17 | 9.533 | 12738.5 |
| 313 | 2024-03-18 12:21:39 | prosected | 3 | 148641 | 102 | 15.860 | 9372.1 |
| 312 | 2024-03-18 11:09:30 | prosected | 1 | 81242 | 5 | 1.546 | 52549.8 |
| 311 | 2024-03-05 13:34:30 | prosected | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 310 | 2024-03-01 13:52:03 | prosected | 1 | 81242 | 5 | 5.766 | 14089.8 |
| 309 | 2024-02-29 14:08:14 | prosected | 1 | 81242 | 5 | 1.346 | 60358.1 |
| 308 | 2024-02-27 05:09:37 | prosected | 1 | 81242 | 5 | 1.813 | 44810.8 |
| 307 | 2024-01-30 13:51:08 | prosected | 1 | 81242 | 5 | 1.420 | 57212.7 |
| 306 | 2024-01-30 02:40:45 | prosected | 1 | 81242 | 5 | 1.343 | 60492.9 |
| 305 | 2024-01-25 19:18:59 | prosected | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 304 | 2024-01-21 00:01:17 | prosected | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 303 | 2024-01-11 02:38:43 | prosected | 1 | 81242 | 5 | 1.373 | 59171.2 |
| 302 | 2023-12-09 00:37:11 | prosected | 1 | 81242 | 5 | 1.440 | 56418.1 |
| 301 | 2023-11-21 09:58:57 | prosected | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 300 | 2023-11-17 11:43:33 | prosected | 1 | 81242 | 5 | 1.376 | 59042.2 |
| 299 | 2023-09-27 21:56:05 | prosected | 1 | 81242 | 5 | 1.390 | 58447.5 |
| 298 | 2023-09-04 16:10:47 | prosected | 1 | 81242 | 5 | 1.220 | 66591.8 |
| 297 | 2023-09-03 17:02:17 | prosected | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 296 | 2023-05-13 16:58:01 | prosected | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 295 | 2023-04-30 22:20:31 | prosected | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 294 | 2023-02-10 20:45:04 | prosected | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 293 | 2023-01-07 11:32:19 | prosected | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 292 | 2023-01-03 17:22:24 | prosected | 1 | 81242 | 5 | 2.750 | 29542.5 |
| 291 | 2022-12-08 05:15:54 | prosected | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 290 | 2022-12-01 00:05:00 | prosected | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 289 | 2022-11-25 09:43:28 | prosected | 1 | 81242 | 5 | 1.236 | 65729.8 |
| 288 | 2022-11-23 08:46:08 | prosected | 1 | 81242 | 5 | 1.483 | 54782.2 |
| 287 | 2022-08-23 09:55:21 | prosected | 1 | 81242 | 5 | 1.326 | 61268.5 |
| 286 | 2022-08-11 00:45:58 | prosected | 1 | 81242 | 5 | 1.263 | 64324.6 |
| 285 | 2022-08-08 16:19:20 | prosected | 1 | 81242 | 5 | 1.263 | 64324.6 |
| 284 | 2022-06-08 07:39:32 | prosected | 1 | 81242 | 5 | 1.376 | 59042.2 |
| 283 | 2022-06-07 10:02:38 | prosected | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 282 | 2022-04-12 08:55:48 | prosected | 1 | 81242 | 5 | 1.670 | 48647.9 |
| 281 | 2022-03-26 23:33:14 | prosected | 1 | 81242 | 5 | 1.313 | 61875.1 |
| 280 | 2022-03-24 19:56:49 | prosected | 1 | 81242 | 5 | 1.483 | 54782.2 |
| 279 | 2022-03-18 09:25:06 | prosected | 1 | 81242 | 5 | 1.596 | 50903.5 |
| 278 | 2021-12-24 09:11:17 | prosected | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 277 | 2021-12-21 13:19:27 | prosected | 1 | 81242 | 5 | 1.860 | 43678.5 |
| 276 | 2021-12-04 04:53:29 | prosected | 1 | 81242 | 5 | 1.596 | 50903.5 |
| 275 | 2021-10-25 04:37:06 | prosected | 1 | 81242 | 5 | 1.670 | 48647.9 |
| 274 | 2021-09-28 04:30:54 | prosected | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 273 | 2021-09-04 15:21:43 | prosected | 1 | 81242 | 5 | 1.280 | 63470.3 |
| 272 | 2021-06-09 15:13:06 | prosected | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 271 | 2021-06-01 23:51:51 | prosected | 1 | 81242 | 5 | 1.436 | 56575.2 |
| 270 | 2021-05-31 15:22:29 | prosected | 1 | 81242 | 5 | 1.513 | 53696.0 |
| 269 | 2021-05-07 18:30:44 | prosected | 1 | 81242 | 5 | 2.750 | 29542.5 |
| 268 | 2021-05-05 10:50:20 | prosected | 2 | 121436 | 17 | 6.953 | 17465.3 |
| 267 | 2021-04-06 03:19:08 | prosected | 1 | 81242 | 5 | 1.330 | 61084.2 |
| 266 | 2021-03-31 08:38:06 | prosected | 3 | 148641 | 102 | 6.500 | 22867.8 |
| 265 | 2021-03-10 10:59:26 | prosected | 1 | 81242 | 5 | 1.423 | 57092.1 |
| 264 | 2021-03-01 10:18:53 | prosected | 1 | 81242 | 5 | 1.280 | 63470.3 |
| 263 | 2021-01-18 15:16:24 | prosected | 2 | 121436 | 17 | 3.216 | 37760.0 |
| 262 | 2021-01-14 22:48:55 | prosected | 3 | 148641 | 102 | 6.373 | 23323.6 |
| 261 | 2020-11-29 18:39:31 | prosected | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 260 | 2020-11-26 06:56:39 | prosected | 1 | 81242 | 5 | 1.300 | 62493.8 |
| 259 | 2020-10-31 12:56:17 | prosected | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 258 | 2020-10-30 04:10:08 | prosected | 2 | 121436 | 17 | 3.216 | 37760.0 |
| 257 | 2020-10-27 03:18:39 | prosected | 3 | 148641 | 102 | 6.843 | 21721.6 |
| 256 | 2020-08-29 11:01:59 | prosected | 1 | 81242 | 5 | 1.343 | 60492.9 |
| 255 | 2020-08-07 11:55:57 | prosected | 1 | 81242 | 5 | 1.326 | 61268.5 |
| 254 | 2020-06-16 06:42:51 | prosected | 1 | 81242 | 5 | 1.280 | 63470.3 |
| 253 | 2020-06-02 12:03:19 | prosected | 1 | 81242 | 5 | 1.516 | 53589.7 |
| 252 | 2020-06-01 12:31:21 | prosected | 1 | 81242 | 5 | 1.283 | 63321.9 |
| 251 | 2020-05-29 14:00:23 | prosected | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 250 | 2020-05-28 14:16:51 | prosected | 1 | 81242 | 5 | 1.343 | 60492.9 |
| 249 | 2020-05-27 13:36:59 | prosected | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 248 | 2020-05-24 10:44:16 | prosected | 1 | 81242 | 5 | 1.483 | 54782.2 |
| 247 | 2020-05-23 11:17:53 | prosected | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 246 | 2020-05-20 15:06:07 | prosected | 1 | 81242 | 5 | 1.280 | 63470.3 |
| 245 | 2020-05-19 14:21:53 | prosected | 1 | 81242 | 5 | 1.326 | 61268.5 |
| 244 | 2020-05-18 15:43:02 | prosected | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 243 | 2020-05-16 11:07:21 | prosected | 1 | 81242 | 5 | 1.346 | 60358.1 |
| 242 | 2020-05-14 04:47:39 | prosected | 1 | 81242 | 5 | 1.410 | 57618.4 |
| 241 | 2020-05-13 10:29:40 | prosected | 1 | 81242 | 5 | 1.330 | 61084.2 |
| 240 | 2020-05-12 11:13:16 | prosected | 1 | 81242 | 5 | 1.440 | 56418.1 |
| 239 | 2020-05-11 11:56:13 | prosected | 1 | 81242 | 5 | 1.313 | 61875.1 |
| 238 | 2020-05-10 11:13:24 | prosected | 1 | 81242 | 5 | 1.313 | 61875.1 |
| 237 | 2020-05-09 11:09:28 | prosected | 1 | 81242 | 5 | 1.263 | 64324.6 |
| 236 | 2020-05-08 11:10:28 | prosected | 1 | 81242 | 5 | 1.330 | 61084.2 |
| 235 | 2020-05-07 10:30:18 | prosected | 1 | 81242 | 5 | 1.283 | 63321.9 |
| 234 | 2020-05-06 11:12:13 | prosected | 1 | 81242 | 5 | 1.343 | 60492.9 |
| 233 | 2020-05-05 10:37:15 | prosected | 1 | 81242 | 5 | 1.313 | 61875.1 |
| 232 | 2020-05-03 10:39:16 | prosected | 1 | 81242 | 5 | 1.280 | 63470.3 |
| 231 | 2020-05-02 11:10:56 | prosected | 1 | 81242 | 5 | 1.330 | 61084.2 |
| 230 | 2020-05-01 10:36:35 | prosected | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 229 | 2020-04-30 10:45:24 | prosected | 1 | 81242 | 5 | 1.326 | 61268.5 |
| 228 | 2020-04-29 10:48:25 | prosected | 1 | 81242 | 5 | 1.300 | 62493.8 |
| 227 | 2020-04-22 15:54:19 | prosected | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 226 | 2020-04-21 17:13:50 | prosected | 1 | 81242 | 5 | 1.330 | 61084.2 |
| 225 | 2020-04-18 02:53:39 | prosected | 1 | 81242 | 5 | 1.483 | 54782.2 |