History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"quake"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 685 | 2024-05-08 08:06:07 | quake | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 684 | 2024-05-07 03:07:26 | quake | 1 | 28756 | 8 | 1.063 | 27051.7 |
| 683 | 2024-05-06 00:40:55 | quake | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 682 | 2024-05-02 04:48:47 | quake | 1 | 28756 | 8 | 0.610 | 47141.0 |
| 681 | 2024-04-30 23:05:23 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
| 680 | 2024-04-29 22:55:13 | quake | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 679 | 2024-04-15 18:59:13 | quake | 2 | 53800 | 73 | 1.330 | 40451.1 |
| 678 | 2024-04-06 00:32:38 | quake | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 677 | 2024-03-31 15:26:45 | quake | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 676 | 2024-03-29 09:33:43 | quake | 1 | 28756 | 8 | 0.953 | 30174.2 |
| 675 | 2024-03-15 09:48:25 | quake | 1 | 28756 | 8 | 0.830 | 34645.8 |
| 674 | 2024-03-04 06:24:08 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 673 | 2024-03-01 12:29:21 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
| 672 | 2024-02-28 02:45:44 | quake | 1 | 28756 | 8 | 1.220 | 23570.5 |
| 671 | 2024-02-12 00:12:00 | quake | 3 | 83667 | 1019 | 11.970 | 6989.7 |
| 670 | 2024-02-09 12:05:29 | quake | 3 | 83667 | 1019 | 3.810 | 21959.8 |
| 669 | 2024-02-03 04:23:21 | quake | 1 | 28756 | 8 | 1.076 | 26724.9 |
| 668 | 2024-01-29 05:24:59 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 667 | 2024-01-29 01:23:01 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
| 666 | 2024-01-15 20:07:08 | quake | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 665 | 2024-01-14 01:59:13 | quake | 2 | 53800 | 73 | 1.576 | 34137.1 |
| 664 | 2024-01-10 23:34:57 | quake | 2 | 53800 | 73 | 1.500 | 35866.7 |
| 663 | 2024-01-10 15:40:07 | quake | 2 | 53800 | 73 | 1.326 | 40573.2 |
| 662 | 2023-12-17 16:44:30 | quake | 3 | 83667 | 1019 | 3.780 | 22134.1 |
| 661 | 2023-12-13 03:34:27 | quake | 3 | 83667 | 1019 | 3.860 | 21675.4 |
| 660 | 2023-12-10 17:47:50 | quake | 2 | 53800 | 73 | 1.563 | 34421.0 |
| 659 | 2023-12-10 00:35:57 | quake | 3 | 83667 | 1019 | 4.030 | 20761.0 |
| 658 | 2023-12-04 14:13:43 | quake | 1 | 28756 | 8 | 0.406 | 70827.6 |
| 657 | 2023-11-18 10:46:01 | quake | 3 | 83667 | 1019 | 3.483 | 24021.5 |
| 656 | 2023-11-16 20:31:06 | quake | 1 | 28756 | 8 | 0.466 | 61708.2 |
| 655 | 2023-11-15 01:32:50 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 654 | 2023-11-11 13:38:14 | quake | 3 | 83667 | 1019 | 4.296 | 19475.6 |
| 653 | 2023-11-10 09:52:05 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 652 | 2023-11-03 19:06:27 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
| 651 | 2023-10-26 09:20:11 | quake | 1 | 28756 | 8 | 0.860 | 33437.2 |
| 650 | 2023-10-25 01:11:28 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 649 | 2023-10-18 21:51:33 | quake | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 648 | 2023-10-14 22:08:04 | quake | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 647 | 2023-10-05 12:58:31 | quake | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 646 | 2023-09-27 08:30:36 | quake | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 645 | 2023-09-13 16:50:16 | quake | 1 | 28756 | 8 | 1.000 | 28756.0 |
| 644 | 2023-09-11 05:51:18 | quake | 2 | 53800 | 73 | 1.343 | 40059.6 |
| 643 | 2023-09-10 02:56:40 | quake | 2 | 53800 | 73 | 1.310 | 41068.7 |
| 642 | 2023-08-29 19:19:44 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
| 641 | 2023-08-15 03:09:42 | quake | 3 | 83667 | 1019 | 3.173 | 26368.4 |
| 640 | 2023-08-08 11:41:30 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
| 639 | 2023-08-04 17:08:09 | quake | 1 | 28756 | 8 | 0.966 | 29768.1 |
| 638 | 2023-06-04 10:58:56 | quake | 2 | 53800 | 73 | 1.280 | 42031.3 |
| 637 | 2023-06-02 13:49:32 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
| 636 | 2023-04-27 11:58:31 | quake | 3 | 83667 | 1019 | 3.750 | 22311.2 |
| 635 | 2023-04-16 04:52:50 | quake | 1 | 28756 | 8 | 0.466 | 61708.2 |
| 634 | 2023-03-27 00:55:01 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
| 633 | 2023-03-12 09:23:15 | quake | 2 | 53800 | 73 | 1.296 | 41512.3 |
| 632 | 2023-02-09 19:54:55 | quake | 3 | 83667 | 1019 | 3.203 | 26121.4 |
| 631 | 2023-02-02 02:56:05 | quake | 3 | 83667 | 1019 | 3.516 | 23796.1 |
| 630 | 2023-01-10 11:44:36 | quake | 1 | 28756 | 8 | 0.406 | 70827.6 |
| 629 | 2022-12-27 05:53:49 | quake | 1 | 28756 | 8 | 0.420 | 68466.7 |
| 628 | 2022-12-15 21:05:58 | quake | 2 | 53800 | 73 | 1.500 | 35866.7 |
| 627 | 2022-11-14 03:55:33 | quake | 3 | 83667 | 1019 | 3.060 | 27342.2 |
| 626 | 2022-10-14 05:34:10 | quake | 1 | 28756 | 8 | 0.466 | 61708.2 |
| 625 | 2022-08-31 01:17:16 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
| 624 | 2022-08-26 23:18:09 | quake | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 623 | 2022-08-10 13:57:11 | quake | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 622 | 2022-08-09 18:40:08 | quake | 2 | 53800 | 73 | 1.313 | 40974.9 |
| 621 | 2022-08-07 10:25:43 | quake | 2 | 53800 | 73 | 1.313 | 40974.9 |
| 620 | 2022-08-06 20:23:50 | quake | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 619 | 2022-07-25 02:52:41 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
| 618 | 2022-07-03 07:45:14 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
| 617 | 2022-06-21 23:24:08 | quake | 3 | 83667 | 1019 | 3.126 | 26764.9 |
| 616 | 2022-06-17 15:25:32 | quake | 3 | 83667 | 1019 | 3.610 | 23176.5 |
| 615 | 2022-06-17 03:36:16 | quake | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 614 | 2022-06-16 07:45:55 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
| 613 | 2022-06-15 16:28:32 | quake | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 612 | 2022-06-04 20:26:44 | quake | 1 | 28756 | 8 | 0.403 | 71354.8 |
| 611 | 2022-06-04 02:55:43 | quake | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 610 | 2022-06-02 14:46:34 | quake | 1 | 28756 | 8 | 0.406 | 70827.6 |
| 609 | 2022-04-19 06:11:37 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
| 608 | 2022-03-08 15:03:05 | quake | 2 | 53800 | 73 | 1.733 | 31044.4 |
| 607 | 2022-02-12 12:35:50 | quake | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 606 | 2021-12-31 00:54:48 | quake | 1 | 28756 | 8 | 0.626 | 45936.1 |
| 605 | 2021-12-04 01:37:57 | quake | 1 | 28756 | 8 | 0.440 | 65354.5 |
| 604 | 2021-12-02 07:53:59 | quake | 2 | 53800 | 73 | 1.686 | 31909.8 |
| 603 | 2021-10-13 13:12:50 | quake | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 602 | 2021-09-22 12:09:28 | quake | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 601 | 2021-09-20 19:07:15 | quake | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 600 | 2021-07-27 18:09:02 | quake | 3 | 83667 | 1019 | 3.266 | 25617.6 |
| 599 | 2021-07-24 08:22:28 | quake | 1 | 28756 | 8 | 0.466 | 61708.2 |
| 598 | 2021-06-20 13:05:19 | quake | 3 | 83667 | 1019 | 3.626 | 23074.2 |
| 597 | 2021-06-19 19:08:14 | quake | 3 | 83667 | 1019 | 3.766 | 22216.4 |
| 596 | 2021-06-07 11:45:21 | quake | 3 | 83667 | 1019 | 3.346 | 25005.1 |
| 595 | 2021-06-04 07:06:04 | quake | 3 | 83667 | 1019 | 3.876 | 21585.9 |
| 594 | 2021-05-14 09:05:09 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
| 593 | 2021-02-20 02:31:31 | quake | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 592 | 2021-01-31 03:32:18 | quake | 3 | 83667 | 1019 | 3.173 | 26368.4 |
| 591 | 2021-01-23 14:19:57 | quake | 3 | 83667 | 1019 | 3.233 | 25879.1 |
| 590 | 2020-11-18 15:23:38 | quake | 1 | 28756 | 8 | 0.440 | 65354.5 |
| 589 | 2020-11-07 12:32:14 | quake | 1 | 28756 | 8 | 0.563 | 51076.4 |
| 588 | 2020-10-31 17:17:11 | quake | 3 | 83667 | 1019 | 3.843 | 21771.3 |
| 587 | 2020-10-28 13:29:36 | quake | 1 | 28756 | 8 | 0.423 | 67981.1 |
| 586 | 2020-10-21 18:37:54 | quake | 3 | 83667 | 1019 | 3.670 | 22797.5 |