History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stanch"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 418 | 2024-05-02 13:14:08 | stanch | 2 | 82551 | 43 | 2.296 | 35954.3 |
| 417 | 2024-05-02 13:14:04 | stanch | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 416 | 2024-05-02 13:13:44 | stanch | 3 | 112716 | 450 | 5.483 | 20557.4 |
| 415 | 2024-05-01 11:36:16 | stanch | 3 | 112716 | 450 | 8.766 | 12858.3 |
| 414 | 2024-04-30 22:39:37 | stanch | 3 | 112716 | 450 | 5.156 | 21861.1 |
| 413 | 2024-04-30 22:39:34 | stanch | 2 | 82551 | 43 | 2.313 | 35690.0 |
| 412 | 2024-04-27 14:38:40 | stanch | 1 | 48755 | 5 | 2.593 | 18802.5 |
| 411 | 2024-04-12 14:43:53 | stanch | 1 | 48755 | 5 | 2.220 | 21961.7 |
| 410 | 2024-04-05 05:48:40 | stanch | 1 | 48755 | 5 | 3.593 | 13569.4 |
| 409 | 2024-03-31 22:45:40 | stanch | 3 | 112716 | 450 | 10.703 | 10531.3 |
| 408 | 2024-03-31 22:45:41 | stanch | 2 | 82551 | 43 | 5.783 | 14274.8 |
| 407 | 2024-03-31 22:45:31 | stanch | 1 | 48755 | 5 | 1.953 | 24964.2 |
| 406 | 2024-03-31 22:45:18 | stanch | 3 | 112716 | 450 | 10.406 | 10831.8 |
| 405 | 2024-03-31 22:45:19 | stanch | 2 | 82551 | 43 | 7.063 | 11687.8 |
| 404 | 2024-02-21 12:48:43 | stanch | 2 | 82551 | 43 | 6.500 | 12700.2 |
| 403 | 2024-02-17 13:44:14 | stanch | 2 | 82551 | 43 | 2.470 | 33421.5 |
| 402 | 2024-02-17 13:31:29 | stanch | 3 | 112716 | 450 | 7.893 | 14280.5 |
| 401 | 2024-02-14 18:13:20 | stanch | 3 | 112716 | 450 | 10.346 | 10894.6 |
| 400 | 2024-02-07 12:09:10 | stanch | 2 | 82551 | 43 | 2.530 | 32628.9 |
| 399 | 2024-02-07 12:08:50 | stanch | 3 | 112716 | 450 | 5.330 | 21147.5 |
| 398 | 2024-02-05 17:38:46 | stanch | 3 | 112716 | 450 | 6.186 | 18221.1 |
| 397 | 2024-02-05 13:25:31 | stanch | 2 | 82551 | 43 | 3.236 | 25510.2 |
| 396 | 2024-02-05 13:25:11 | stanch | 3 | 112716 | 450 | 6.030 | 18692.5 |
| 395 | 2024-02-04 16:35:02 | stanch | 3 | 112716 | 450 | 7.906 | 14257.0 |
| 394 | 2024-02-04 15:03:30 | stanch | 2 | 82551 | 43 | 2.593 | 31836.1 |
| 393 | 2024-02-04 15:03:26 | stanch | 3 | 112716 | 450 | 6.000 | 18786.0 |
| 392 | 2024-02-04 15:03:22 | stanch | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 391 | 2024-01-16 12:48:53 | stanch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 390 | 2024-01-11 09:43:42 | stanch | 2 | 82551 | 43 | 2.186 | 37763.5 |
| 389 | 2024-01-07 17:55:01 | stanch | 2 | 82551 | 43 | 2.686 | 30733.8 |
| 388 | 2023-12-27 07:33:34 | stanch | 3 | 112716 | 450 | 8.013 | 14066.6 |
| 387 | 2023-12-25 07:28:24 | stanch | 3 | 112716 | 450 | 6.470 | 17421.3 |
| 386 | 2023-11-30 20:25:54 | stanch | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 385 | 2023-11-26 05:24:20 | stanch | 2 | 82551 | 43 | 2.766 | 29844.9 |
| 384 | 2023-11-17 17:02:23 | stanch | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 383 | 2023-11-14 14:16:29 | stanch | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 382 | 2023-11-13 12:56:03 | stanch | 3 | 112716 | 450 | 5.360 | 21029.1 |
| 381 | 2023-11-13 02:24:30 | stanch | 3 | 112716 | 450 | 5.173 | 21789.3 |
| 380 | 2023-11-05 00:37:44 | stanch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 379 | 2023-10-31 10:41:04 | stanch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 378 | 2023-10-26 18:44:01 | stanch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 377 | 2023-10-21 23:48:19 | stanch | 2 | 82551 | 43 | 2.970 | 27794.9 |
| 376 | 2023-10-20 16:47:12 | stanch | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 375 | 2023-10-16 21:44:05 | stanch | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 374 | 2023-10-15 19:35:04 | stanch | 2 | 82551 | 43 | 2.330 | 35429.6 |
| 373 | 2023-10-07 10:46:38 | stanch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 372 | 2023-09-26 13:01:33 | stanch | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 371 | 2023-09-15 04:48:30 | stanch | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 370 | 2023-08-31 17:56:53 | stanch | 1 | 48755 | 5 | 1.656 | 29441.4 |
| 369 | 2023-08-14 20:32:06 | stanch | 3 | 112716 | 450 | 4.843 | 23274.0 |
| 368 | 2023-07-26 17:17:00 | stanch | 2 | 82551 | 43 | 2.220 | 37185.1 |
| 367 | 2023-06-21 18:44:46 | stanch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 366 | 2023-06-06 09:02:51 | stanch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 365 | 2023-04-28 13:10:10 | stanch | 3 | 112716 | 450 | 5.436 | 20735.1 |
| 364 | 2023-04-06 00:09:32 | stanch | 2 | 82551 | 43 | 2.123 | 38884.1 |
| 363 | 2023-03-28 07:21:13 | stanch | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 362 | 2023-02-24 00:49:13 | stanch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 361 | 2023-02-20 17:49:47 | stanch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 360 | 2023-02-02 22:53:20 | stanch | 3 | 112716 | 450 | 4.610 | 24450.3 |
| 359 | 2023-01-25 15:59:21 | stanch | 3 | 112716 | 450 | 4.690 | 24033.3 |
| 358 | 2023-01-11 13:58:05 | stanch | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 357 | 2023-01-02 15:38:10 | stanch | 2 | 82551 | 43 | 2.126 | 38829.3 |
| 356 | 2022-12-13 10:09:30 | stanch | 3 | 112716 | 450 | 5.500 | 20493.8 |
| 355 | 2022-11-16 08:25:07 | stanch | 3 | 112716 | 450 | 5.203 | 21663.7 |
| 354 | 2022-10-30 05:32:37 | stanch | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 353 | 2022-10-20 07:51:30 | stanch | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 352 | 2022-09-07 07:50:48 | stanch | 2 | 82551 | 43 | 2.250 | 36689.3 |
| 351 | 2022-09-05 06:17:35 | stanch | 2 | 82551 | 43 | 2.173 | 37989.4 |
| 350 | 2022-09-03 02:12:01 | stanch | 2 | 82551 | 43 | 2.610 | 31628.7 |
| 349 | 2022-06-21 05:59:38 | stanch | 3 | 112716 | 450 | 4.766 | 23650.0 |
| 348 | 2022-06-18 21:21:59 | stanch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 347 | 2022-06-18 21:12:59 | stanch | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 346 | 2022-03-30 18:30:27 | stanch | 2 | 82551 | 43 | 3.516 | 23478.7 |
| 345 | 2022-02-24 04:42:39 | stanch | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 344 | 2022-02-10 14:01:10 | stanch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 343 | 2021-12-15 11:11:50 | stanch | 2 | 82551 | 43 | 2.326 | 35490.5 |
| 342 | 2021-12-13 06:19:00 | stanch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 341 | 2021-12-11 04:44:17 | stanch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 340 | 2021-10-20 12:18:22 | stanch | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 339 | 2021-10-14 05:40:39 | stanch | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 338 | 2021-10-10 23:26:24 | stanch | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 337 | 2021-10-04 00:52:22 | stanch | 2 | 82551 | 43 | 2.296 | 35954.3 |
| 336 | 2021-09-23 08:13:37 | stanch | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 335 | 2021-07-09 07:36:18 | stanch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 334 | 2021-06-01 19:31:53 | stanch | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 333 | 2021-05-21 10:08:04 | stanch | 3 | 112716 | 450 | 4.923 | 22895.8 |
| 332 | 2021-05-07 13:13:28 | stanch | 1 | 48755 | 5 | 0.966 | 50471.0 |
| 331 | 2021-04-21 22:01:16 | stanch | 3 | 112716 | 450 | 4.686 | 24053.8 |
| 330 | 2021-04-12 05:35:09 | stanch | 3 | 112716 | 450 | 5.766 | 19548.4 |
| 329 | 2021-04-05 21:55:04 | stanch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 328 | 2021-04-05 11:08:42 | stanch | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 327 | 2021-04-01 07:03:37 | stanch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 326 | 2021-03-24 08:44:47 | stanch | 3 | 112716 | 450 | 4.796 | 23502.1 |
| 325 | 2021-03-10 06:47:42 | stanch | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 324 | 2021-02-17 23:46:33 | stanch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 323 | 2021-02-02 16:56:53 | stanch | 3 | 112716 | 450 | 4.796 | 23502.1 |
| 322 | 2021-01-21 07:13:29 | stanch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 321 | 2021-01-13 12:33:12 | stanch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 320 | 2020-12-24 01:55:31 | stanch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 319 | 2020-11-23 12:42:33 | stanch | 1 | 48755 | 5 | 0.750 | 65006.7 |