History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"select"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 614 | 2024-04-09 19:40:09 | select | 2 | 82551 | 36 | 2.893 | 28534.7 |
| 613 | 2024-03-31 14:53:51 | select | 1 | 48755 | 3 | 2.423 | 20121.7 |
| 612 | 2024-03-29 05:06:58 | select | 1 | 48755 | 3 | 1.033 | 47197.5 |
| 611 | 2024-03-26 08:16:38 | select | 2 | 82551 | 36 | 2.736 | 30172.1 |
| 610 | 2024-03-26 08:16:18 | select | 3 | 112716 | 534 | 6.330 | 17806.6 |
| 609 | 2024-03-24 23:07:16 | select | 2 | 82551 | 36 | 2.266 | 36430.3 |
| 608 | 2024-03-24 23:06:08 | select | 3 | 112716 | 534 | 4.920 | 22909.8 |
| 607 | 2024-03-23 09:42:45 | select | 2 | 82551 | 36 | 2.546 | 32423.8 |
| 606 | 2024-03-23 09:42:22 | select | 3 | 112716 | 534 | 5.936 | 18988.5 |
| 605 | 2024-03-19 19:06:50 | select | 2 | 82551 | 36 | 2.766 | 29844.9 |
| 604 | 2024-03-19 19:06:27 | select | 3 | 112716 | 534 | 5.250 | 21469.7 |
| 603 | 2024-03-18 11:08:35 | select | 2 | 82551 | 36 | 2.736 | 30172.1 |
| 602 | 2024-03-18 11:08:11 | select | 3 | 112716 | 534 | 6.516 | 17298.3 |
| 601 | 2024-03-13 17:54:48 | select | 3 | 112716 | 534 | 17.470 | 6452.0 |
| 600 | 2024-03-13 16:37:57 | select | 3 | 112716 | 534 | 6.266 | 17988.5 |
| 599 | 2024-03-01 12:06:39 | select | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 598 | 2024-01-30 19:01:21 | select | 2 | 82551 | 36 | 2.830 | 29170.0 |
| 597 | 2024-01-30 18:59:20 | select | 3 | 112716 | 534 | 5.330 | 21147.5 |
| 596 | 2024-01-24 11:46:06 | select | 3 | 112716 | 534 | 6.970 | 16171.6 |
| 595 | 2024-01-21 09:12:48 | select | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 594 | 2024-01-21 07:42:34 | select | 3 | 112716 | 534 | 5.596 | 20142.2 |
| 593 | 2024-01-21 07:42:33 | select | 2 | 82551 | 36 | 2.593 | 31836.1 |
| 592 | 2023-12-10 13:24:05 | select | 2 | 82551 | 36 | 2.200 | 37523.2 |
| 591 | 2023-12-10 11:08:34 | select | 3 | 112716 | 534 | 4.766 | 23650.0 |
| 590 | 2023-11-25 14:30:51 | select | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 589 | 2023-11-24 11:16:44 | select | 1 | 48755 | 3 | 1.530 | 31866.0 |
| 588 | 2023-11-20 15:23:58 | select | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 587 | 2023-11-18 09:34:52 | select | 1 | 48755 | 3 | 2.000 | 24377.5 |
| 586 | 2023-11-17 06:36:41 | select | 1 | 48755 | 3 | 1.906 | 25579.7 |
| 585 | 2023-11-04 11:45:45 | select | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 584 | 2023-10-23 18:17:05 | select | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 583 | 2023-10-18 16:12:27 | select | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 582 | 2023-10-13 12:32:33 | select | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 581 | 2023-10-07 12:13:02 | select | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 580 | 2023-09-26 08:18:52 | select | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 579 | 2023-09-14 07:22:02 | select | 1 | 48755 | 3 | 1.673 | 29142.3 |
| 578 | 2023-09-10 08:16:41 | select | 2 | 82551 | 36 | 2.173 | 37989.4 |
| 577 | 2023-09-03 23:24:24 | select | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 576 | 2023-08-19 05:50:22 | select | 3 | 112716 | 534 | 5.016 | 22471.3 |
| 575 | 2023-08-18 23:46:50 | select | 3 | 112716 | 534 | 5.203 | 21663.7 |
| 574 | 2023-07-24 04:02:39 | select | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 573 | 2023-06-02 05:14:31 | select | 2 | 82551 | 36 | 2.140 | 38575.2 |
| 572 | 2023-04-05 01:29:41 | select | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 571 | 2023-03-31 04:56:17 | select | 3 | 112716 | 534 | 5.156 | 21861.1 |
| 570 | 2023-03-08 02:02:18 | select | 2 | 82551 | 36 | 2.186 | 37763.5 |
| 569 | 2023-02-27 10:27:18 | select | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 568 | 2023-02-05 04:17:42 | select | 3 | 112716 | 534 | 9.313 | 12103.1 |
| 567 | 2023-01-20 15:04:38 | select | 3 | 112716 | 534 | 4.796 | 23502.1 |
| 566 | 2023-01-02 13:49:04 | select | 3 | 112716 | 534 | 4.766 | 23650.0 |
| 565 | 2022-12-28 17:35:48 | select | 3 | 112716 | 534 | 10.140 | 11116.0 |
| 564 | 2022-12-22 19:16:14 | select | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 563 | 2022-12-19 23:06:11 | select | 3 | 112716 | 534 | 4.766 | 23650.0 |
| 562 | 2022-12-16 11:58:01 | select | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 561 | 2022-12-12 22:45:46 | select | 2 | 82551 | 36 | 2.220 | 37185.1 |
| 560 | 2022-11-13 11:57:09 | select | 3 | 112716 | 534 | 5.186 | 21734.7 |
| 559 | 2022-11-11 04:52:10 | select | 3 | 112716 | 534 | 5.970 | 18880.4 |
| 558 | 2022-11-09 11:43:46 | select | 3 | 112716 | 534 | 6.093 | 18499.3 |
| 557 | 2022-11-08 16:58:31 | select | 3 | 112716 | 534 | 4.826 | 23356.0 |
| 556 | 2022-11-07 21:51:30 | select | 3 | 112716 | 534 | 5.593 | 20153.0 |
| 555 | 2022-11-06 18:15:21 | select | 3 | 112716 | 534 | 4.923 | 22895.8 |
| 554 | 2022-11-05 10:44:17 | select | 3 | 112716 | 534 | 5.966 | 18893.1 |
| 553 | 2022-10-11 07:45:07 | select | 3 | 112716 | 534 | 4.860 | 23192.6 |
| 552 | 2022-09-09 08:57:19 | select | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 551 | 2022-09-07 11:39:01 | select | 3 | 112716 | 534 | 5.643 | 19974.5 |
| 550 | 2022-08-27 00:02:30 | select | 3 | 112716 | 534 | 4.860 | 23192.6 |
| 549 | 2022-08-17 13:07:37 | select | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 548 | 2022-08-16 07:59:10 | select | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 547 | 2022-07-31 02:12:33 | select | 2 | 82551 | 36 | 2.186 | 37763.5 |
| 546 | 2022-07-29 03:41:30 | select | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 545 | 2022-07-26 09:54:58 | select | 3 | 112716 | 534 | 5.096 | 22118.5 |
| 544 | 2022-07-22 17:55:39 | select | 3 | 112716 | 534 | 5.016 | 22471.3 |
| 543 | 2022-07-19 11:07:20 | select | 3 | 112716 | 534 | 4.940 | 22817.0 |
| 542 | 2022-07-19 11:06:45 | select | 2 | 82551 | 36 | 2.233 | 36968.7 |
| 541 | 2022-06-14 00:10:08 | select | 3 | 112716 | 534 | 4.890 | 23050.3 |
| 540 | 2022-06-07 07:56:57 | select | 3 | 112716 | 534 | 4.846 | 23259.6 |
| 539 | 2022-05-19 21:08:02 | select | 3 | 112716 | 534 | 5.503 | 20482.6 |
| 538 | 2022-05-16 23:50:17 | select | 3 | 112716 | 534 | 6.220 | 18121.5 |
| 537 | 2022-05-15 19:41:48 | select | 3 | 112716 | 534 | 4.860 | 23192.6 |
| 536 | 2022-05-13 20:26:27 | select | 3 | 112716 | 534 | 5.533 | 20371.6 |
| 535 | 2022-04-12 04:57:44 | select | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 534 | 2022-04-06 04:15:03 | select | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 533 | 2022-03-19 01:56:59 | select | 2 | 82551 | 36 | 2.483 | 33246.5 |
| 532 | 2022-03-13 17:42:37 | select | 3 | 112716 | 534 | 5.546 | 20323.8 |
| 531 | 2022-02-12 22:06:35 | select | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 530 | 2022-02-11 19:12:01 | select | 3 | 112716 | 534 | 5.233 | 21539.5 |
| 529 | 2022-01-28 23:01:48 | select | 3 | 112716 | 534 | 6.330 | 17806.6 |
| 528 | 2022-01-28 04:04:28 | select | 3 | 112716 | 534 | 5.076 | 22205.7 |
| 527 | 2022-01-27 10:14:04 | select | 3 | 112716 | 534 | 5.313 | 21215.1 |
| 526 | 2022-01-26 23:30:31 | select | 3 | 112716 | 534 | 5.906 | 19085.0 |
| 525 | 2022-01-26 14:10:59 | select | 3 | 112716 | 534 | 5.236 | 21527.1 |
| 524 | 2022-01-26 01:36:58 | select | 3 | 112716 | 534 | 5.953 | 18934.3 |
| 523 | 2022-01-25 06:01:06 | select | 3 | 112716 | 534 | 4.766 | 23650.0 |
| 522 | 2022-01-24 21:06:04 | select | 3 | 112716 | 534 | 5.530 | 20382.6 |
| 521 | 2022-01-24 01:36:59 | select | 3 | 112716 | 534 | 4.953 | 22757.1 |
| 520 | 2022-01-23 20:27:25 | select | 3 | 112716 | 534 | 4.890 | 23050.3 |
| 519 | 2022-01-21 08:18:09 | select | 3 | 112716 | 534 | 5.016 | 22471.3 |
| 518 | 2022-01-20 19:37:50 | select | 3 | 112716 | 534 | 4.813 | 23419.1 |
| 517 | 2022-01-20 08:01:43 | select | 3 | 112716 | 534 | 5.373 | 20978.2 |
| 516 | 2022-01-19 21:37:46 | select | 3 | 112716 | 534 | 5.126 | 21989.1 |
| 515 | 2022-01-19 12:04:52 | select | 3 | 112716 | 534 | 6.360 | 17722.6 |