History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canolas"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 722 | 2024-04-20 14:18:14 | canolas | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 721 | 2024-04-20 14:02:36 | canolas | 1 | 69583 | 3 | 1.610 | 43219.3 |
| 720 | 2024-04-13 09:11:11 | canolas | 2 | 107671 | 41 | 3.876 | 27778.9 |
| 719 | 2024-04-13 08:11:29 | canolas | 3 | 134027 | 421 | 7.283 | 18402.7 |
| 718 | 2024-04-13 08:11:33 | canolas | 2 | 107671 | 41 | 3.580 | 30075.7 |
| 717 | 2024-04-13 08:11:25 | canolas | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 716 | 2024-04-13 08:04:56 | canolas | 3 | 134027 | 421 | 7.050 | 19010.9 |
| 715 | 2024-04-12 21:15:01 | canolas | 3 | 134027 | 421 | 12.656 | 10590.0 |
| 714 | 2024-04-11 16:18:07 | canolas | 3 | 134027 | 421 | 6.220 | 21547.7 |
| 713 | 2024-04-01 18:43:01 | canolas | 1 | 69583 | 3 | 3.626 | 19190.0 |
| 712 | 2024-03-07 15:12:49 | canolas | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 711 | 2024-02-28 21:02:02 | canolas | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 710 | 2024-02-28 08:39:14 | canolas | 3 | 134027 | 421 | 16.970 | 7897.9 |
| 709 | 2024-02-27 00:28:32 | canolas | 3 | 134027 | 421 | 7.203 | 18607.1 |
| 708 | 2024-02-27 00:28:32 | canolas | 2 | 107671 | 41 | 3.546 | 30364.1 |
| 707 | 2024-02-27 00:28:28 | canolas | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 706 | 2024-01-14 23:23:51 | canolas | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 705 | 2023-12-22 03:57:59 | canolas | 3 | 134027 | 421 | 9.360 | 14319.1 |
| 704 | 2023-12-22 03:57:58 | canolas | 2 | 107671 | 41 | 3.763 | 28613.1 |
| 703 | 2023-12-11 22:32:48 | canolas | 1 | 69583 | 3 | 2.580 | 26970.2 |
| 702 | 2023-12-08 11:49:04 | canolas | 3 | 134027 | 421 | 7.126 | 18808.2 |
| 701 | 2023-11-29 10:23:54 | canolas | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 700 | 2023-11-26 23:15:17 | canolas | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 699 | 2023-11-22 02:30:55 | canolas | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 698 | 2023-11-10 16:20:35 | canolas | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 697 | 2023-10-29 17:35:47 | canolas | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 696 | 2023-10-28 04:14:41 | canolas | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 695 | 2023-10-24 21:42:00 | canolas | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 694 | 2023-10-11 11:16:02 | canolas | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 693 | 2023-09-24 23:17:44 | canolas | 1 | 69583 | 3 | 1.253 | 55533.1 |
| 692 | 2023-09-24 12:58:28 | canolas | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 691 | 2023-09-15 04:29:04 | canolas | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 690 | 2023-09-07 07:40:41 | canolas | 3 | 134027 | 421 | 6.360 | 21073.4 |
| 689 | 2023-08-12 13:30:50 | canolas | 3 | 134027 | 421 | 6.360 | 21073.4 |
| 688 | 2023-08-08 14:19:29 | canolas | 3 | 134027 | 421 | 5.953 | 22514.2 |
| 687 | 2023-08-06 14:45:33 | canolas | 3 | 134027 | 421 | 6.080 | 22043.9 |
| 686 | 2023-08-04 04:10:33 | canolas | 3 | 134027 | 421 | 6.563 | 20421.6 |
| 685 | 2023-08-02 16:53:19 | canolas | 3 | 134027 | 421 | 7.016 | 19103.1 |
| 684 | 2023-07-29 23:48:47 | canolas | 3 | 134027 | 421 | 7.330 | 18284.7 |
| 683 | 2023-07-28 23:17:18 | canolas | 3 | 134027 | 421 | 6.856 | 19548.9 |
| 682 | 2023-07-27 06:28:17 | canolas | 3 | 134027 | 421 | 6.000 | 22337.8 |
| 681 | 2023-07-26 08:00:20 | canolas | 3 | 134027 | 421 | 7.940 | 16880.0 |
| 680 | 2023-07-25 03:43:35 | canolas | 3 | 134027 | 421 | 6.156 | 21771.8 |
| 679 | 2023-07-23 12:55:05 | canolas | 3 | 134027 | 421 | 6.156 | 21771.8 |
| 678 | 2023-07-22 17:14:24 | canolas | 3 | 134027 | 421 | 7.093 | 18895.7 |
| 677 | 2023-07-21 17:14:03 | canolas | 1 | 69583 | 3 | 2.563 | 27149.0 |
| 676 | 2023-07-21 15:41:20 | canolas | 3 | 134027 | 421 | 7.096 | 18887.7 |
| 675 | 2023-07-20 23:16:20 | canolas | 3 | 134027 | 421 | 8.220 | 16305.0 |
| 674 | 2023-07-19 06:56:06 | canolas | 3 | 134027 | 421 | 6.126 | 21878.4 |
| 673 | 2023-07-15 22:51:47 | canolas | 3 | 134027 | 421 | 6.486 | 20664.0 |
| 672 | 2023-07-15 15:55:46 | canolas | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 671 | 2023-07-12 09:55:54 | canolas | 3 | 134027 | 421 | 11.640 | 11514.3 |
| 670 | 2023-07-11 10:57:25 | canolas | 3 | 134027 | 421 | 7.500 | 17870.3 |
| 669 | 2023-07-10 07:53:28 | canolas | 3 | 134027 | 421 | 6.393 | 20964.6 |
| 668 | 2023-06-28 01:57:48 | canolas | 3 | 134027 | 421 | 6.360 | 21073.4 |
| 667 | 2023-06-17 10:31:34 | canolas | 3 | 134027 | 421 | 5.890 | 22755.0 |
| 666 | 2023-06-06 02:22:07 | canolas | 3 | 134027 | 421 | 5.906 | 22693.4 |
| 665 | 2023-06-05 09:26:24 | canolas | 3 | 134027 | 421 | 5.813 | 23056.4 |
| 664 | 2023-06-04 12:34:03 | canolas | 3 | 134027 | 421 | 6.300 | 21274.1 |
| 663 | 2023-06-02 05:42:48 | canolas | 3 | 134027 | 421 | 6.280 | 21341.9 |
| 662 | 2023-06-01 12:05:56 | canolas | 3 | 134027 | 421 | 5.846 | 22926.3 |
| 661 | 2023-05-31 22:35:13 | canolas | 3 | 134027 | 421 | 5.780 | 23188.1 |
| 660 | 2023-05-30 17:45:31 | canolas | 3 | 134027 | 421 | 5.890 | 22755.0 |
| 659 | 2023-05-29 01:56:21 | canolas | 3 | 134027 | 421 | 6.420 | 20876.5 |
| 658 | 2023-04-22 01:54:02 | canolas | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 657 | 2023-04-08 00:28:15 | canolas | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 656 | 2023-04-04 00:36:20 | canolas | 3 | 134027 | 421 | 6.343 | 21129.9 |
| 655 | 2023-03-09 04:26:41 | canolas | 3 | 134027 | 421 | 5.876 | 22809.2 |
| 654 | 2023-02-10 23:40:56 | canolas | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 653 | 2023-02-10 10:19:51 | canolas | 3 | 134027 | 421 | 6.906 | 19407.3 |
| 652 | 2023-01-02 19:03:29 | canolas | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 651 | 2022-12-27 15:11:03 | canolas | 3 | 134027 | 421 | 5.890 | 22755.0 |
| 650 | 2022-12-22 21:28:49 | canolas | 3 | 134027 | 421 | 6.750 | 19855.9 |
| 649 | 2022-12-13 20:38:47 | canolas | 3 | 134027 | 421 | 11.983 | 11184.8 |
| 648 | 2022-12-09 10:10:25 | canolas | 3 | 134027 | 421 | 8.046 | 16657.6 |
| 647 | 2022-12-08 22:20:30 | canolas | 3 | 134027 | 421 | 11.593 | 11561.0 |
| 646 | 2022-12-07 04:44:56 | canolas | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 645 | 2022-12-04 07:07:26 | canolas | 3 | 134027 | 421 | 6.576 | 20381.2 |
| 644 | 2022-12-03 10:19:27 | canolas | 3 | 134027 | 421 | 6.966 | 19240.2 |
| 643 | 2022-11-06 05:20:05 | canolas | 3 | 134027 | 421 | 7.156 | 18729.3 |
| 642 | 2022-11-05 22:50:07 | canolas | 3 | 134027 | 421 | 6.580 | 20368.8 |
| 641 | 2022-10-30 22:19:15 | canolas | 3 | 134027 | 421 | 6.140 | 21828.5 |
| 640 | 2022-10-24 00:57:02 | canolas | 3 | 134027 | 421 | 5.920 | 22639.7 |
| 639 | 2022-09-22 19:35:39 | canolas | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 638 | 2022-09-22 03:59:21 | canolas | 3 | 134027 | 421 | 5.890 | 22755.0 |
| 637 | 2022-09-14 09:41:02 | canolas | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 636 | 2022-09-01 22:15:51 | canolas | 3 | 134027 | 421 | 6.810 | 19680.9 |
| 635 | 2022-08-28 06:13:22 | canolas | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 634 | 2022-08-14 20:17:50 | canolas | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 633 | 2022-08-09 15:20:48 | canolas | 3 | 134027 | 421 | 9.123 | 14691.1 |
| 632 | 2022-08-08 02:48:00 | canolas | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 631 | 2022-08-06 13:30:53 | canolas | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 630 | 2022-08-05 18:18:45 | canolas | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 629 | 2022-08-03 13:45:21 | canolas | 3 | 134027 | 421 | 6.626 | 20227.4 |
| 628 | 2022-07-15 17:06:51 | canolas | 3 | 134027 | 421 | 6.936 | 19323.4 |
| 627 | 2022-07-11 18:58:58 | canolas | 3 | 134027 | 421 | 5.940 | 22563.5 |
| 626 | 2022-07-04 01:18:39 | canolas | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 625 | 2022-06-09 10:37:47 | canolas | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 624 | 2022-06-05 19:51:34 | canolas | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 623 | 2022-06-03 13:09:37 | canolas | 3 | 134027 | 421 | 6.030 | 22226.7 |