History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preplans"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 497 | 2025-12-17 16:29:09 | preplans | 3 | 146162 | 150 | 7.346 | 19896.8 |
| 496 | 2025-12-12 02:04:45 | preplans | 2 | 121059 | 16 | 3.686 | 32842.9 |
| 495 | 2025-12-11 04:51:36 | preplans | 1 | 82945 | 4 | 1.373 | 60411.5 |
| 494 | 2025-12-11 00:20:37 | preplans | 1 | 82945 | 4 | 1.546 | 53651.4 |
| 493 | 2025-12-08 12:44:30 | preplans | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 492 | 2025-12-03 17:32:14 | preplans | 1 | 82945 | 4 | 1.576 | 52630.1 |
| 491 | 2025-11-28 05:46:33 | preplans | 1 | 82945 | 4 | 5.903 | 14051.3 |
| 490 | 2025-11-23 15:15:58 | preplans | 1 | 82945 | 4 | 1.563 | 53067.8 |
| 489 | 2025-11-22 00:49:01 | preplans | 1 | 82945 | 4 | 1.576 | 52630.1 |
| 488 | 2025-11-19 09:15:57 | preplans | 1 | 82945 | 4 | 3.623 | 22894.0 |
| 487 | 2025-11-16 07:21:12 | preplans | 3 | 146162 | 150 | 7.470 | 19566.5 |
| 486 | 2025-11-16 00:03:24 | preplans | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 485 | 2025-11-10 04:55:47 | preplans | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 484 | 2025-11-10 00:26:32 | preplans | 1 | 82945 | 4 | 1.330 | 62364.7 |
| 483 | 2025-11-08 19:02:40 | preplans | 1 | 82945 | 4 | 1.360 | 60989.0 |
| 482 | 2025-10-28 08:40:12 | preplans | 1 | 82945 | 4 | 1.623 | 51106.0 |
| 481 | 2025-10-19 20:52:52 | preplans | 1 | 82945 | 4 | 6.373 | 13015.1 |
| 480 | 2025-10-19 20:52:46 | preplans | 1 | 82945 | 4 | 3.936 | 21073.4 |
| 479 | 2025-10-19 20:52:37 | preplans | 1 | 82945 | 4 | 8.890 | 9330.1 |
| 478 | 2025-10-19 20:52:41 | preplans | 1 | 82945 | 4 | 4.623 | 17941.8 |
| 477 | 2025-10-18 08:25:05 | preplans | 3 | 146162 | 150 | 8.406 | 17387.8 |
| 476 | 2025-10-16 01:02:39 | preplans | 1 | 82945 | 4 | 1.860 | 44594.1 |
| 475 | 2025-10-08 01:07:23 | preplans | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 474 | 2025-10-05 02:29:38 | preplans | 1 | 82945 | 4 | 1.546 | 53651.4 |
| 473 | 2025-09-30 20:43:10 | preplans | 1 | 82945 | 4 | 1.483 | 55930.5 |
| 472 | 2025-09-29 06:08:37 | preplans | 1 | 82945 | 4 | 1.486 | 55817.6 |
| 471 | 2025-09-29 02:50:11 | preplans | 1 | 82945 | 4 | 1.360 | 60989.0 |
| 470 | 2025-09-27 06:57:18 | preplans | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 469 | 2025-09-27 01:30:50 | preplans | 1 | 82945 | 4 | 1.530 | 54212.4 |
| 468 | 2025-09-18 16:05:48 | preplans | 1 | 82945 | 4 | 1.610 | 51518.6 |
| 467 | 2025-09-18 06:27:15 | preplans | 2 | 121059 | 16 | 3.690 | 32807.3 |
| 466 | 2025-09-15 04:18:44 | preplans | 1 | 82945 | 4 | 1.530 | 54212.4 |
| 465 | 2025-09-15 00:53:00 | preplans | 1 | 82945 | 4 | 4.186 | 19814.9 |
| 464 | 2025-09-02 14:33:41 | preplans | 1 | 82945 | 4 | 1.310 | 63316.8 |
| 463 | 2025-08-28 19:46:48 | preplans | 1 | 82945 | 4 | 1.593 | 52068.4 |
| 462 | 2025-08-27 06:31:08 | preplans | 1 | 82945 | 4 | 1.563 | 53067.8 |
| 461 | 2025-08-27 05:32:38 | preplans | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 460 | 2025-08-27 01:39:03 | preplans | 1 | 82945 | 4 | 1.596 | 51970.6 |
| 459 | 2025-08-27 01:12:58 | preplans | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 458 | 2025-08-25 10:28:49 | preplans | 1 | 82945 | 4 | 7.753 | 10698.4 |
| 457 | 2025-08-09 17:57:06 | preplans | 1 | 82945 | 4 | 7.296 | 11368.6 |
| 456 | 2025-08-09 17:42:43 | preplans | 3 | 146162 | 150 | 8.673 | 16852.5 |
| 455 | 2025-08-07 07:32:17 | preplans | 1 | 82945 | 4 | 6.890 | 12038.5 |
| 454 | 2025-08-06 04:22:20 | preplans | 3 | 146162 | 150 | 31.970 | 4571.8 |
| 453 | 2025-08-03 23:00:10 | preplans | 3 | 146162 | 150 | 17.890 | 8170.0 |
| 452 | 2025-07-28 10:23:49 | preplans | 2 | 121059 | 16 | 8.500 | 14242.2 |
| 451 | 2025-07-28 09:09:29 | preplans | 3 | 146162 | 150 | 33.456 | 4368.8 |
| 450 | 2025-07-27 06:14:24 | preplans | 3 | 146162 | 150 | 43.220 | 3381.8 |
| 449 | 2025-07-27 01:51:57 | preplans | 1 | 82945 | 4 | 5.140 | 16137.2 |
| 448 | 2025-07-24 21:30:28 | preplans | 3 | 146162 | 150 | 21.423 | 6822.7 |
| 447 | 2025-07-24 09:40:23 | preplans | 1 | 82945 | 4 | 4.593 | 18059.0 |
| 446 | 2025-07-23 14:26:31 | preplans | 1 | 82945 | 4 | 4.920 | 16858.7 |
| 445 | 2025-07-23 13:16:17 | preplans | 1 | 82945 | 4 | 7.013 | 11827.3 |
| 444 | 2025-07-23 04:44:31 | preplans | 1 | 82945 | 4 | 6.766 | 12259.1 |
| 443 | 2025-07-22 14:52:48 | preplans | 1 | 82945 | 4 | 3.140 | 26415.6 |
| 442 | 2025-07-22 10:22:38 | preplans | 1 | 82945 | 4 | 3.030 | 27374.6 |
| 441 | 2025-07-19 22:02:14 | preplans | 3 | 146162 | 150 | 7.923 | 18447.8 |
| 440 | 2025-07-17 21:11:27 | preplans | 1 | 82945 | 4 | 3.126 | 26533.9 |
| 439 | 2025-07-15 20:55:57 | preplans | 1 | 82945 | 4 | 1.610 | 51518.6 |
| 438 | 2025-07-14 19:50:16 | preplans | 3 | 146162 | 150 | 45.970 | 3179.5 |
| 437 | 2025-07-14 08:58:20 | preplans | 3 | 146162 | 150 | 42.690 | 3423.8 |
| 436 | 2025-07-11 03:02:26 | preplans | 3 | 146162 | 150 | 34.720 | 4209.7 |
| 435 | 2025-07-10 09:59:15 | preplans | 2 | 121059 | 16 | 10.796 | 11213.3 |
| 434 | 2025-07-09 09:29:42 | preplans | 3 | 146162 | 150 | 6.673 | 21903.5 |
| 433 | 2025-07-08 01:37:10 | preplans | 3 | 146162 | 150 | 33.600 | 4350.1 |
| 432 | 2025-07-01 21:03:18 | preplans | 1 | 82945 | 4 | 7.346 | 11291.2 |
| 431 | 2025-06-26 20:51:20 | preplans | 3 | 146162 | 150 | 51.503 | 2837.9 |
| 430 | 2025-06-25 13:36:47 | preplans | 3 | 146162 | 150 | 19.843 | 7365.9 |
| 429 | 2025-06-23 16:52:47 | preplans | 3 | 146162 | 150 | 7.376 | 19815.9 |
| 428 | 2025-06-23 12:02:02 | preplans | 2 | 121059 | 16 | 12.016 | 10074.8 |
| 427 | 2025-06-21 16:51:21 | preplans | 1 | 82945 | 4 | 1.483 | 55930.5 |
| 426 | 2025-06-21 15:16:08 | preplans | 1 | 82945 | 4 | 7.266 | 11415.5 |
| 425 | 2025-06-21 15:04:47 | preplans | 1 | 82945 | 4 | 7.220 | 11488.2 |
| 424 | 2025-06-18 10:17:54 | preplans | 1 | 82945 | 4 | 4.906 | 16906.8 |
| 423 | 2025-06-15 20:25:56 | preplans | 1 | 82945 | 4 | 7.780 | 10661.3 |
| 422 | 2025-06-12 01:15:15 | preplans | 1 | 82945 | 4 | 3.720 | 22297.0 |
| 421 | 2025-06-07 12:45:35 | preplans | 2 | 121059 | 16 | 13.640 | 8875.3 |
| 420 | 2025-06-05 07:40:24 | preplans | 1 | 82945 | 4 | 6.533 | 12696.3 |
| 419 | 2025-06-02 05:07:20 | preplans | 3 | 146162 | 150 | 38.736 | 3773.3 |
| 418 | 2025-05-31 04:23:18 | preplans | 1 | 82945 | 4 | 4.110 | 20181.3 |
| 417 | 2025-05-28 19:50:59 | preplans | 2 | 121059 | 16 | 16.686 | 7255.1 |
| 416 | 2025-05-28 07:40:30 | preplans | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 415 | 2025-05-28 06:32:21 | preplans | 1 | 82945 | 4 | 2.906 | 28542.7 |
| 414 | 2025-05-22 08:12:29 | preplans | 1 | 82945 | 4 | 7.280 | 11393.5 |
| 413 | 2025-05-18 09:09:55 | preplans | 2 | 121059 | 16 | 25.566 | 4735.2 |
| 412 | 2025-05-17 01:43:43 | preplans | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 411 | 2025-05-06 04:47:09 | preplans | 3 | 146162 | 150 | 48.543 | 3011.0 |
| 410 | 2025-05-04 19:28:38 | preplans | 1 | 82945 | 4 | 1.626 | 51011.7 |
| 409 | 2025-05-02 18:36:59 | preplans | 2 | 121059 | 16 | 3.330 | 36354.1 |
| 408 | 2025-05-02 18:19:59 | preplans | 3 | 146162 | 150 | 6.970 | 20970.2 |
| 407 | 2025-04-30 19:57:43 | preplans | 1 | 82945 | 4 | 1.593 | 52068.4 |
| 406 | 2025-04-30 03:58:00 | preplans | 3 | 146162 | 150 | 50.690 | 2883.4 |
| 405 | 2025-04-29 11:42:47 | preplans | 3 | 146162 | 150 | 14.190 | 10300.4 |
| 404 | 2025-04-29 05:45:47 | preplans | 3 | 146162 | 150 | 40.283 | 3628.4 |
| 403 | 2025-04-27 05:04:04 | preplans | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 402 | 2025-04-24 20:52:56 | preplans | 3 | 146162 | 150 | 8.376 | 17450.1 |
| 401 | 2025-04-23 16:02:56 | preplans | 3 | 146162 | 150 | 33.546 | 4357.1 |
| 400 | 2025-04-23 11:22:15 | preplans | 2 | 121059 | 16 | 13.703 | 8834.5 |
| 399 | 2025-04-20 16:10:19 | preplans | 1 | 82945 | 4 | 9.406 | 8818.3 |
| 398 | 2025-04-16 02:31:34 | preplans | 1 | 82945 | 4 | 3.673 | 22582.4 |