History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rolling"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 474 | 2024-05-03 13:49:52 | rolling | 1 | 69583 | 12 | 1.300 | 53525.4 |
| 473 | 2024-04-27 18:00:19 | rolling | 1 | 69583 | 12 | 1.266 | 54962.9 |
| 472 | 2024-04-17 08:57:56 | rolling | 1 | 69583 | 12 | 1.343 | 51811.6 |
| 471 | 2024-04-10 13:21:25 | rolling | 2 | 107671 | 154 | 10.843 | 9930.0 |
| 470 | 2024-04-09 17:16:56 | rolling | 2 | 107671 | 154 | 7.906 | 13618.9 |
| 469 | 2024-04-09 03:09:08 | rolling | 1 | 69583 | 12 | 1.376 | 50569.0 |
| 468 | 2024-04-09 03:06:53 | rolling | 2 | 107671 | 154 | 4.263 | 25257.1 |
| 467 | 2024-04-08 15:48:04 | rolling | 2 | 107671 | 154 | 3.703 | 29076.7 |
| 466 | 2024-01-08 23:46:24 | rolling | 2 | 107671 | 154 | 2.876 | 37437.8 |
| 465 | 2024-01-02 10:43:26 | rolling | 1 | 69583 | 12 | 1.216 | 57222.9 |
| 464 | 2023-12-15 13:25:36 | rolling | 1 | 69583 | 12 | 1.233 | 56433.9 |
| 463 | 2023-12-09 10:36:06 | rolling | 2 | 107671 | 154 | 2.890 | 37256.4 |
| 462 | 2023-11-29 06:14:17 | rolling | 1 | 69583 | 12 | 1.123 | 61961.7 |
| 461 | 2023-11-27 17:39:01 | rolling | 1 | 69583 | 12 | 1.110 | 62687.4 |
| 460 | 2023-11-19 11:11:56 | rolling | 1 | 69583 | 12 | 1.186 | 58670.3 |
| 459 | 2023-11-15 04:19:18 | rolling | 1 | 69583 | 12 | 1.076 | 64668.2 |
| 458 | 2023-11-04 06:19:29 | rolling | 1 | 69583 | 12 | 1.220 | 57035.2 |
| 457 | 2023-10-23 16:20:42 | rolling | 1 | 69583 | 12 | 1.283 | 54234.6 |
| 456 | 2023-10-13 18:58:27 | rolling | 1 | 69583 | 12 | 1.096 | 63488.1 |
| 455 | 2023-10-06 21:14:36 | rolling | 1 | 69583 | 12 | 1.156 | 60192.9 |
| 454 | 2023-09-23 14:22:22 | rolling | 1 | 69583 | 12 | 1.170 | 59472.6 |
| 453 | 2023-09-11 13:00:05 | rolling | 2 | 107671 | 154 | 3.343 | 32207.9 |
| 452 | 2023-09-07 07:50:19 | rolling | 2 | 107671 | 154 | 3.016 | 35699.9 |
| 451 | 2023-08-18 18:49:08 | rolling | 1 | 69583 | 12 | 1.093 | 63662.4 |
| 450 | 2023-08-04 14:45:32 | rolling | 1 | 69583 | 12 | 1.220 | 57035.2 |
| 449 | 2023-05-23 12:39:08 | rolling | 2 | 107671 | 154 | 6.890 | 15627.1 |
| 448 | 2023-05-21 11:04:46 | rolling | 1 | 69583 | 12 | 1.076 | 64668.2 |
| 447 | 2023-04-27 02:43:26 | rolling | 1 | 69583 | 12 | 1.080 | 64428.7 |
| 446 | 2023-03-16 21:39:27 | rolling | 1 | 69583 | 12 | 2.173 | 32021.6 |
| 445 | 2023-03-03 08:11:46 | rolling | 2 | 107671 | 154 | 2.843 | 37872.3 |
| 444 | 2023-01-22 06:29:23 | rolling | 1 | 69583 | 12 | 1.203 | 57841.2 |
| 443 | 2023-01-05 03:19:18 | rolling | 1 | 69583 | 12 | 1.060 | 65644.3 |
| 442 | 2022-12-10 18:04:14 | rolling | 2 | 107671 | 154 | 2.903 | 37089.6 |
| 441 | 2022-10-07 22:20:56 | rolling | 1 | 69583 | 12 | 1.076 | 64668.2 |
| 440 | 2022-10-03 13:28:12 | rolling | 1 | 69583 | 12 | 1.080 | 64428.7 |
| 439 | 2022-08-08 00:06:35 | rolling | 2 | 107671 | 154 | 3.016 | 35699.9 |
| 438 | 2022-07-25 19:46:26 | rolling | 2 | 107671 | 154 | 2.843 | 37872.3 |
| 437 | 2022-06-21 06:28:45 | rolling | 1 | 69583 | 12 | 1.170 | 59472.6 |
| 436 | 2022-06-07 04:40:33 | rolling | 1 | 69583 | 12 | 1.390 | 50059.7 |
| 435 | 2022-05-23 07:19:36 | rolling | 1 | 69583 | 12 | 1.076 | 64668.2 |
| 434 | 2022-05-21 02:48:15 | rolling | 1 | 69583 | 12 | 1.093 | 63662.4 |
| 433 | 2022-03-02 01:40:04 | rolling | 1 | 69583 | 12 | 1.500 | 46388.7 |
| 432 | 2022-02-04 16:40:40 | rolling | 1 | 69583 | 12 | 1.110 | 62687.4 |
| 431 | 2021-11-30 16:08:54 | rolling | 1 | 69583 | 12 | 1.283 | 54234.6 |
| 430 | 2021-11-28 14:34:42 | rolling | 1 | 69583 | 12 | 1.300 | 53525.4 |
| 429 | 2021-11-18 09:21:25 | rolling | 1 | 69583 | 12 | 1.343 | 51811.6 |
| 428 | 2021-11-10 00:47:08 | rolling | 1 | 69583 | 12 | 1.233 | 56433.9 |
| 427 | 2021-10-12 06:14:27 | rolling | 1 | 69583 | 12 | 1.123 | 61961.7 |
| 426 | 2021-09-08 04:56:37 | rolling | 1 | 69583 | 12 | 1.203 | 57841.2 |
| 425 | 2021-08-25 22:17:35 | rolling | 1 | 69583 | 12 | 1.280 | 54361.7 |
| 424 | 2021-08-23 18:33:44 | rolling | 1 | 69583 | 12 | 1.266 | 54962.9 |
| 423 | 2021-08-15 14:00:47 | rolling | 1 | 69583 | 12 | 1.093 | 63662.4 |
| 422 | 2021-05-27 19:32:00 | rolling | 1 | 69583 | 12 | 1.220 | 57035.2 |
| 421 | 2021-05-22 09:08:37 | rolling | 1 | 69583 | 12 | 1.280 | 54361.7 |
| 420 | 2021-05-14 22:08:18 | rolling | 1 | 69583 | 12 | 1.326 | 52475.9 |
| 419 | 2021-04-23 06:09:49 | rolling | 1 | 69583 | 12 | 1.296 | 53690.6 |
| 418 | 2021-03-25 10:07:41 | rolling | 1 | 69583 | 12 | 1.423 | 48898.8 |
| 417 | 2021-02-19 23:50:44 | rolling | 1 | 69583 | 12 | 1.123 | 61961.7 |
| 416 | 2021-02-12 01:26:10 | rolling | 1 | 69583 | 12 | 1.203 | 57841.2 |
| 415 | 2021-02-07 01:02:22 | rolling | 1 | 69583 | 12 | 1.123 | 61961.7 |
| 414 | 2021-01-08 14:00:32 | rolling | 1 | 69583 | 12 | 2.233 | 31161.2 |
| 413 | 2020-11-05 02:00:08 | rolling | 1 | 69583 | 12 | 1.123 | 61961.7 |
| 412 | 2020-11-04 22:21:59 | rolling | 1 | 69583 | 12 | 1.173 | 59320.5 |
| 411 | 2020-11-01 06:19:39 | rolling | 1 | 69583 | 12 | 1.190 | 58473.1 |
| 410 | 2020-10-22 11:27:52 | rolling | 1 | 69583 | 12 | 1.326 | 52475.9 |
| 409 | 2020-10-15 03:29:02 | rolling | 1 | 69583 | 12 | 1.110 | 62687.4 |
| 408 | 2020-09-27 06:48:37 | rolling | 1 | 69583 | 12 | 1.206 | 57697.3 |
| 407 | 2020-08-01 07:15:09 | rolling | 1 | 69583 | 12 | 1.283 | 54234.6 |
| 406 | 2020-06-20 19:30:08 | rolling | 1 | 69583 | 12 | 1.216 | 57222.9 |
| 405 | 2020-04-29 20:20:29 | rolling | 1 | 69583 | 12 | 1.203 | 57841.2 |
| 404 | 2020-03-28 19:13:42 | rolling | 1 | 69583 | 12 | 1.300 | 53525.4 |
| 403 | 2020-03-28 16:21:42 | rolling | 1 | 69583 | 12 | 1.263 | 55093.4 |
| 402 | 2020-03-26 09:04:17 | rolling | 1 | 69583 | 12 | 1.470 | 47335.4 |
| 401 | 2020-03-24 15:36:04 | rolling | 1 | 69583 | 12 | 1.170 | 59472.6 |
| 400 | 2020-03-20 23:29:02 | rolling | 1 | 69583 | 12 | 1.080 | 64428.7 |
| 399 | 2020-03-19 21:41:31 | rolling | 1 | 69583 | 12 | 1.220 | 57035.2 |
| 398 | 2020-02-29 05:42:45 | rolling | 1 | 69583 | 12 | 1.560 | 44604.5 |
| 397 | 2020-02-24 11:46:51 | rolling | 1 | 69583 | 12 | 2.606 | 26701.1 |
| 396 | 2020-02-20 12:45:07 | rolling | 1 | 69583 | 12 | 2.420 | 28753.3 |
| 395 | 2020-02-17 01:11:57 | rolling | 1 | 69583 | 12 | 2.376 | 29285.8 |
| 394 | 2020-02-16 16:25:23 | rolling | 1 | 69583 | 12 | 1.423 | 48898.8 |
| 393 | 2020-02-13 16:55:19 | rolling | 1 | 69583 | 12 | 2.563 | 27149.0 |
| 392 | 2020-02-06 20:01:00 | rolling | 1 | 69583 | 12 | 1.406 | 49490.0 |
| 391 | 2020-02-01 04:30:33 | rolling | 1 | 69583 | 12 | 2.280 | 30518.9 |
| 390 | 2020-01-31 17:20:34 | rolling | 1 | 69583 | 12 | 2.716 | 25619.7 |
| 389 | 2020-01-28 22:07:52 | rolling | 1 | 69583 | 12 | 1.236 | 56296.9 |
| 388 | 2020-01-27 03:05:26 | rolling | 1 | 69583 | 12 | 1.373 | 50679.5 |
| 387 | 2020-01-26 16:16:34 | rolling | 1 | 69583 | 12 | 1.686 | 41271.1 |
| 386 | 2020-01-25 23:19:48 | rolling | 1 | 69583 | 12 | 1.140 | 61037.7 |
| 385 | 2020-01-25 08:56:47 | rolling | 1 | 69583 | 12 | 1.296 | 53690.6 |
| 384 | 2020-01-24 09:07:39 | rolling | 1 | 69583 | 12 | 5.406 | 12871.4 |
| 383 | 2020-01-16 12:53:33 | rolling | 1 | 69583 | 12 | 1.220 | 57035.2 |
| 382 | 2020-01-14 00:26:21 | rolling | 1 | 69583 | 12 | 2.500 | 27833.2 |
| 381 | 2020-01-11 06:05:34 | rolling | 1 | 69583 | 12 | 1.906 | 36507.3 |
| 380 | 2020-01-05 03:46:22 | rolling | 1 | 69583 | 12 | 1.313 | 52995.4 |
| 379 | 2019-12-29 11:47:33 | rolling | 1 | 69583 | 12 | 1.330 | 52318.0 |
| 378 | 2019-12-27 04:29:56 | rolling | 1 | 69583 | 12 | 1.330 | 52318.0 |
| 377 | 2019-12-26 20:06:10 | rolling | 1 | 69583 | 12 | 1.390 | 50059.7 |
| 376 | 2019-12-26 08:15:24 | rolling | 1 | 69583 | 12 | 1.330 | 52318.0 |
| 375 | 2019-12-10 15:59:26 | rolling | 1 | 69583 | 12 | 1.156 | 60192.9 |