History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trigger"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 860 | 2026-01-20 01:08:01 | trigger | 3 | 134027 | 454 | 8.423 | 15912.0 |
| 859 | 2026-01-20 01:07:47 | trigger | 3 | 134027 | 454 | 6.266 | 21389.6 |
| 858 | 2026-01-17 12:36:22 | trigger | 1 | 69583 | 4 | 2.203 | 31585.6 |
| 857 | 2026-01-15 00:00:04 | trigger | 3 | 134027 | 454 | 7.153 | 18737.2 |
| 856 | 2026-01-14 06:55:10 | trigger | 3 | 134027 | 454 | 24.126 | 5555.3 |
| 855 | 2026-01-12 03:27:14 | trigger | 1 | 69583 | 4 | 4.140 | 16807.5 |
| 854 | 2026-01-12 03:26:48 | trigger | 1 | 69583 | 4 | 3.156 | 22047.8 |
| 853 | 2026-01-12 03:26:27 | trigger | 1 | 69583 | 4 | 4.436 | 15686.0 |
| 852 | 2026-01-12 03:26:05 | trigger | 1 | 69583 | 4 | 2.923 | 23805.3 |
| 851 | 2026-01-08 03:17:31 | trigger | 3 | 134027 | 454 | 17.156 | 7812.3 |
| 850 | 2026-01-08 03:17:21 | trigger | 3 | 134027 | 454 | 14.160 | 9465.2 |
| 849 | 2026-01-06 18:14:08 | trigger | 3 | 134027 | 454 | 20.376 | 6577.7 |
| 848 | 2026-01-03 02:25:48 | trigger | 3 | 134027 | 454 | 6.983 | 19193.3 |
| 847 | 2026-01-02 22:21:42 | trigger | 3 | 134027 | 454 | 6.766 | 19808.9 |
| 846 | 2026-01-02 06:04:02 | trigger | 3 | 134027 | 454 | 6.156 | 21771.8 |
| 845 | 2025-12-31 03:14:48 | trigger | 2 | 107671 | 48 | 3.076 | 35003.6 |
| 844 | 2025-12-30 13:23:56 | trigger | 1 | 69583 | 4 | 8.686 | 8010.9 |
| 843 | 2025-12-30 13:23:30 | trigger | 1 | 69583 | 4 | 8.796 | 7910.8 |
| 842 | 2025-12-30 05:56:30 | trigger | 2 | 107671 | 48 | 4.690 | 22957.6 |
| 841 | 2025-12-29 22:31:32 | trigger | 3 | 134027 | 454 | 13.950 | 9607.7 |
| 840 | 2025-12-29 19:24:59 | trigger | 3 | 134027 | 454 | 6.533 | 20515.4 |
| 839 | 2025-12-29 16:47:28 | trigger | 2 | 107671 | 48 | 5.796 | 18576.8 |
| 838 | 2025-12-25 19:23:55 | trigger | 1 | 69583 | 4 | 1.300 | 53525.4 |
| 837 | 2025-12-24 07:23:34 | trigger | 1 | 69583 | 4 | 2.123 | 32775.8 |
| 836 | 2025-12-24 05:02:31 | trigger | 1 | 69583 | 4 | 1.263 | 55093.4 |
| 835 | 2025-12-24 03:47:36 | trigger | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 834 | 2025-11-25 07:18:14 | trigger | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 833 | 2025-10-30 16:18:46 | trigger | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 832 | 2025-10-16 08:01:38 | trigger | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 831 | 2025-10-13 16:49:41 | trigger | 1 | 69583 | 4 | 1.263 | 55093.4 |
| 830 | 2025-09-17 19:33:17 | trigger | 3 | 134027 | 454 | 10.516 | 12745.1 |
| 829 | 2025-09-16 14:25:12 | trigger | 2 | 107671 | 48 | 3.466 | 31064.9 |
| 828 | 2025-09-15 19:46:01 | trigger | 3 | 134027 | 454 | 6.296 | 21287.6 |
| 827 | 2025-09-15 18:28:43 | trigger | 3 | 134027 | 454 | 6.576 | 20381.2 |
| 826 | 2025-09-07 22:13:06 | trigger | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 825 | 2025-09-04 09:19:11 | trigger | 3 | 134027 | 454 | 5.940 | 22563.5 |
| 824 | 2025-09-04 08:37:16 | trigger | 3 | 134027 | 454 | 5.906 | 22693.4 |
| 823 | 2025-08-31 15:06:50 | trigger | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 822 | 2025-08-25 12:01:32 | trigger | 1 | 69583 | 4 | 4.316 | 16122.1 |
| 821 | 2025-08-24 10:27:41 | trigger | 1 | 69583 | 4 | 6.423 | 10833.4 |
| 820 | 2025-08-11 11:55:45 | trigger | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 819 | 2025-08-11 02:31:47 | trigger | 1 | 69583 | 4 | 2.376 | 29285.8 |
| 818 | 2025-08-06 01:18:32 | trigger | 2 | 107671 | 48 | 8.140 | 13227.4 |
| 817 | 2025-08-03 19:15:56 | trigger | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 816 | 2025-08-03 02:31:47 | trigger | 3 | 134027 | 454 | 17.640 | 7597.9 |
| 815 | 2025-08-03 02:28:44 | trigger | 2 | 107671 | 48 | 8.673 | 12414.5 |
| 814 | 2025-08-01 15:27:04 | trigger | 1 | 69583 | 4 | 2.656 | 26198.4 |
| 813 | 2025-08-01 09:17:24 | trigger | 3 | 134027 | 454 | 30.066 | 4457.8 |
| 812 | 2025-08-01 03:41:25 | trigger | 1 | 69583 | 4 | 2.873 | 24219.6 |
| 811 | 2025-07-31 23:16:22 | trigger | 3 | 134027 | 454 | 20.876 | 6420.1 |
| 810 | 2025-07-31 11:36:34 | trigger | 3 | 134027 | 454 | 6.486 | 20664.0 |
| 809 | 2025-07-31 10:34:59 | trigger | 1 | 69583 | 4 | 1.516 | 45899.1 |
| 808 | 2025-07-31 09:56:17 | trigger | 3 | 134027 | 454 | 14.656 | 9144.9 |
| 807 | 2025-07-30 04:11:28 | trigger | 3 | 134027 | 454 | 17.530 | 7645.6 |
| 806 | 2025-07-27 00:28:21 | trigger | 2 | 107671 | 48 | 9.440 | 11405.8 |
| 805 | 2025-07-24 17:32:40 | trigger | 1 | 69583 | 4 | 5.860 | 11874.2 |
| 804 | 2025-07-22 14:10:54 | trigger | 1 | 69583 | 4 | 5.123 | 13582.5 |
| 803 | 2025-07-21 22:05:59 | trigger | 2 | 107671 | 48 | 6.530 | 16488.7 |
| 802 | 2025-07-15 08:53:06 | trigger | 2 | 107671 | 48 | 22.576 | 4769.3 |
| 801 | 2025-07-10 09:28:43 | trigger | 1 | 69583 | 4 | 4.080 | 17054.7 |
| 800 | 2025-07-07 06:34:35 | trigger | 3 | 134027 | 454 | 19.753 | 6785.1 |
| 799 | 2025-07-06 23:14:32 | trigger | 2 | 107671 | 48 | 14.626 | 7361.6 |
| 798 | 2025-07-06 21:24:21 | trigger | 2 | 107671 | 48 | 2.983 | 36094.9 |
| 797 | 2025-07-05 09:30:01 | trigger | 1 | 69583 | 4 | 6.063 | 11476.7 |
| 796 | 2025-07-05 04:43:57 | trigger | 3 | 134027 | 454 | 30.173 | 4442.0 |
| 795 | 2025-07-05 00:42:56 | trigger | 2 | 107671 | 48 | 12.690 | 8484.7 |
| 794 | 2025-07-04 19:00:49 | trigger | 1 | 69583 | 4 | 5.640 | 12337.4 |
| 793 | 2025-07-03 23:25:16 | trigger | 1 | 69583 | 4 | 3.673 | 18944.5 |
| 792 | 2025-06-28 21:09:32 | trigger | 2 | 107671 | 48 | 3.326 | 32372.5 |
| 791 | 2025-06-27 01:55:31 | trigger | 1 | 69583 | 4 | 2.983 | 23326.5 |
| 790 | 2025-06-23 16:39:38 | trigger | 2 | 107671 | 48 | 3.593 | 29966.9 |
| 789 | 2025-06-22 12:22:26 | trigger | 1 | 69583 | 4 | 6.206 | 11212.2 |
| 788 | 2025-06-19 10:24:04 | trigger | 3 | 134027 | 454 | 29.483 | 4545.9 |
| 787 | 2025-06-19 05:24:38 | trigger | 2 | 107671 | 48 | 8.063 | 13353.7 |
| 786 | 2025-06-19 03:01:20 | trigger | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 785 | 2025-06-19 02:09:15 | trigger | 3 | 134027 | 454 | 7.080 | 18930.4 |
| 784 | 2025-06-12 09:30:33 | trigger | 3 | 134027 | 454 | 28.190 | 4754.4 |
| 783 | 2025-06-11 17:41:43 | trigger | 2 | 107671 | 48 | 2.953 | 36461.6 |
| 782 | 2025-06-06 13:31:58 | trigger | 3 | 134027 | 454 | 34.206 | 3918.2 |
| 781 | 2025-06-02 20:55:25 | trigger | 2 | 107671 | 48 | 4.970 | 21664.2 |
| 780 | 2025-06-02 08:14:58 | trigger | 3 | 134027 | 454 | 36.360 | 3686.1 |
| 779 | 2025-06-02 08:03:08 | trigger | 3 | 134027 | 454 | 36.596 | 3662.3 |
| 778 | 2025-06-02 06:18:12 | trigger | 3 | 134027 | 454 | 25.143 | 5330.6 |
| 777 | 2025-06-01 18:54:56 | trigger | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 776 | 2025-06-01 01:16:54 | trigger | 3 | 134027 | 454 | 25.470 | 5262.2 |
| 775 | 2025-05-31 16:23:35 | trigger | 3 | 134027 | 454 | 40.006 | 3350.2 |
| 774 | 2025-05-30 23:11:45 | trigger | 2 | 107671 | 48 | 17.360 | 6202.2 |
| 773 | 2025-05-30 21:45:18 | trigger | 3 | 134027 | 454 | 33.656 | 3982.3 |
| 772 | 2025-05-30 03:05:16 | trigger | 3 | 134027 | 454 | 29.346 | 4567.1 |
| 771 | 2025-05-29 03:21:44 | trigger | 2 | 107671 | 48 | 14.250 | 7555.9 |
| 770 | 2025-05-28 18:24:27 | trigger | 3 | 134027 | 454 | 7.046 | 19021.7 |
| 769 | 2025-05-27 17:52:54 | trigger | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 768 | 2025-05-27 02:29:46 | trigger | 1 | 69583 | 4 | 3.063 | 22717.3 |
| 767 | 2025-05-22 13:48:59 | trigger | 1 | 69583 | 4 | 6.093 | 11420.2 |
| 766 | 2025-05-22 06:32:40 | trigger | 2 | 107671 | 48 | 16.736 | 6433.5 |
| 765 | 2025-05-12 09:39:08 | trigger | 3 | 134027 | 454 | 34.906 | 3839.7 |
| 764 | 2025-05-12 03:39:53 | trigger | 1 | 69583 | 4 | 7.266 | 9576.5 |
| 763 | 2025-05-12 03:38:11 | trigger | 2 | 107671 | 48 | 25.236 | 4266.6 |
| 762 | 2025-05-12 01:12:09 | trigger | 2 | 107671 | 48 | 20.766 | 5185.0 |
| 761 | 2025-05-11 12:04:42 | trigger | 3 | 134027 | 454 | 6.440 | 20811.6 |