History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"threatener"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 183 | 2024-04-28 07:47:43 | threatener | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 182 | 2024-04-27 09:25:15 | threatener | 1 | 67641 | 3 | 1.236 | 54725.7 |
| 181 | 2024-04-25 21:33:57 | threatener | 1 | 67641 | 3 | 2.376 | 28468.4 |
| 180 | 2024-04-12 14:10:09 | threatener | 4 | 161450 | 117 | 42.830 | 3769.6 |
| 179 | 2024-03-28 17:02:24 | threatener | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 178 | 2024-03-26 16:53:38 | threatener | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 177 | 2024-03-22 08:30:21 | threatener | 4 | 161450 | 117 | 30.956 | 5215.5 |
| 176 | 2024-03-21 23:54:54 | threatener | 4 | 161450 | 117 | 26.830 | 6017.5 |
| 175 | 2024-03-21 23:53:58 | threatener | 3 | 140603 | 17 | 21.546 | 6525.7 |
| 174 | 2024-03-21 23:53:53 | threatener | 2 | 108824 | 5 | 10.686 | 10183.8 |
| 173 | 2024-03-21 22:44:09 | threatener | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 172 | 2024-03-20 20:56:46 | threatener | 2 | 108824 | 5 | 11.046 | 9851.9 |
| 171 | 2024-03-20 20:56:06 | threatener | 3 | 140603 | 17 | 10.123 | 13889.5 |
| 170 | 2024-03-20 19:02:04 | threatener | 1 | 67641 | 3 | 1.406 | 48108.8 |
| 169 | 2024-03-20 16:21:25 | threatener | 4 | 161450 | 117 | 36.953 | 4369.1 |
| 168 | 2024-02-26 20:36:42 | threatener | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 167 | 2024-02-26 00:02:14 | threatener | 3 | 140603 | 17 | 24.440 | 5753.0 |
| 166 | 2024-02-25 18:18:26 | threatener | 4 | 161450 | 117 | 27.690 | 5830.6 |
| 165 | 2024-02-21 17:49:15 | threatener | 3 | 140603 | 17 | 15.830 | 8882.1 |
| 164 | 2024-02-21 09:35:49 | threatener | 4 | 161450 | 117 | 27.533 | 5863.9 |
| 163 | 2024-02-21 04:50:58 | threatener | 4 | 161450 | 117 | 10.593 | 15241.2 |
| 162 | 2024-02-19 13:32:08 | threatener | 4 | 161450 | 117 | 13.626 | 11848.7 |
| 161 | 2024-02-19 13:32:09 | threatener | 2 | 108824 | 5 | 5.546 | 19622.1 |
| 160 | 2024-02-19 13:32:06 | threatener | 3 | 140603 | 17 | 7.250 | 19393.5 |
| 159 | 2024-02-19 05:44:46 | threatener | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 158 | 2024-02-18 00:40:15 | threatener | 4 | 161450 | 117 | 22.000 | 7338.6 |
| 157 | 2024-02-16 23:35:32 | threatener | 4 | 161450 | 117 | 20.656 | 7816.1 |
| 156 | 2024-02-16 23:35:34 | threatener | 3 | 140603 | 17 | 15.983 | 8797.0 |
| 155 | 2024-02-16 23:35:36 | threatener | 2 | 108824 | 5 | 3.470 | 31361.4 |
| 154 | 2024-02-16 20:10:48 | threatener | 1 | 67641 | 3 | 1.736 | 38963.7 |
| 153 | 2024-02-03 18:47:28 | threatener | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 152 | 2024-01-26 17:57:27 | threatener | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 151 | 2024-01-20 11:07:21 | threatener | 2 | 108824 | 5 | 2.813 | 38686.1 |
| 150 | 2023-11-27 15:18:29 | threatener | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 149 | 2023-11-16 07:37:53 | threatener | 1 | 67641 | 3 | 0.966 | 70021.7 |
| 148 | 2023-10-30 01:22:48 | threatener | 2 | 108824 | 5 | 2.610 | 41695.0 |
| 147 | 2023-09-13 21:12:04 | threatener | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 146 | 2023-08-07 08:59:53 | threatener | 2 | 108824 | 5 | 5.563 | 19562.1 |
| 145 | 2023-06-24 11:57:39 | threatener | 1 | 67641 | 3 | 0.970 | 69733.0 |
| 144 | 2023-05-27 07:37:06 | threatener | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 143 | 2023-04-20 01:25:21 | threatener | 2 | 108824 | 5 | 5.000 | 21764.8 |
| 142 | 2023-04-03 11:43:01 | threatener | 1 | 67641 | 3 | 0.970 | 69733.0 |
| 141 | 2023-01-20 18:12:45 | threatener | 2 | 108824 | 5 | 2.750 | 39572.4 |
| 140 | 2023-01-16 00:00:43 | threatener | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 139 | 2022-12-25 11:21:04 | threatener | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 138 | 2022-11-12 20:08:31 | threatener | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 137 | 2022-10-31 18:08:44 | threatener | 2 | 108824 | 5 | 2.563 | 42459.6 |
| 136 | 2022-07-04 04:39:35 | threatener | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 135 | 2022-06-30 23:32:12 | threatener | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 134 | 2022-05-15 02:00:52 | threatener | 2 | 108824 | 5 | 2.580 | 42179.8 |
| 133 | 2022-03-04 17:48:55 | threatener | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 132 | 2022-03-02 13:08:19 | threatener | 1 | 67641 | 3 | 1.423 | 47534.1 |
| 131 | 2022-01-21 05:16:02 | threatener | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 130 | 2022-01-17 22:48:25 | threatener | 1 | 67641 | 3 | 1.106 | 61158.2 |
| 129 | 2022-01-14 15:57:41 | threatener | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 128 | 2021-08-30 17:36:26 | threatener | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 127 | 2021-05-08 00:07:42 | threatener | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 126 | 2021-04-22 03:00:28 | threatener | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 125 | 2021-04-06 10:10:35 | threatener | 1 | 67641 | 3 | 1.106 | 61158.2 |
| 124 | 2021-02-14 10:18:18 | threatener | 1 | 67641 | 3 | 0.966 | 70021.7 |
| 123 | 2021-01-01 01:12:48 | threatener | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 122 | 2020-12-22 11:09:46 | threatener | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 121 | 2020-11-18 04:07:36 | threatener | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 120 | 2020-10-24 17:46:49 | threatener | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 119 | 2020-10-14 10:38:10 | threatener | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 118 | 2020-09-13 12:25:24 | threatener | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 117 | 2020-05-04 19:31:17 | threatener | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 116 | 2020-03-26 14:21:07 | threatener | 1 | 67641 | 3 | 1.143 | 59178.5 |
| 115 | 2020-03-03 08:50:28 | threatener | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 114 | 2020-03-01 08:41:55 | threatener | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 113 | 2020-03-01 07:15:38 | threatener | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 112 | 2020-02-29 11:35:13 | threatener | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 111 | 2020-02-21 03:35:44 | threatener | 1 | 67641 | 3 | 3.640 | 18582.7 |
| 110 | 2020-02-11 03:50:01 | threatener | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 109 | 2020-02-04 16:30:02 | threatener | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 108 | 2020-01-19 15:52:23 | threatener | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 107 | 2020-01-14 17:22:57 | threatener | 1 | 67641 | 3 | 1.200 | 56367.5 |
| 106 | 2020-01-08 15:13:44 | threatener | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 105 | 2020-01-03 23:29:22 | threatener | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 104 | 2019-10-05 06:44:44 | threatener | 1 | 67641 | 3 | 1.056 | 64054.0 |
| 103 | 2019-06-13 07:50:04 | threatener | 1 | 67641 | 3 | 1.006 | 67237.6 |
| 102 | 2019-02-03 20:19:57 | threatener | 1 | 67641 | 3 | 1.103 | 61324.6 |
| 101 | 2018-09-19 11:56:08 | threatener | 1 | 67641 | 3 | 1.226 | 55172.1 |
| 100 | 2018-06-24 15:50:53 | threatener | 1 | 67641 | 3 | 1.023 | 66120.2 |
| 99 | 2018-06-17 13:27:23 | threatener | 1 | 67641 | 3 | 1.133 | 59700.8 |
| 98 | 2017-11-02 16:41:59 | threatener | 1 | 67641 | 3 | 1.493 | 45305.4 |
| 97 | 2017-10-24 20:48:50 | threatener | 1 | 67641 | 3 | 2.076 | 32582.4 |
| 96 | 2017-08-05 12:14:29 | threatener | 1 | 67641 | 3 | 1.860 | 36366.1 |
| 95 | 2017-07-23 01:41:18 | threatener | 1 | 67641 | 3 | 1.796 | 37662.0 |
| 94 | 2017-05-18 01:20:35 | threatener | 1 | 67641 | 3 | 1.283 | 52721.0 |
| 93 | 2017-03-13 23:11:37 | threatener | 1 | 67641 | 3 | 1.356 | 49882.7 |
| 92 | 2016-12-08 12:39:55 | threatener | 1 | 67641 | 3 | 1.390 | 48662.6 |
| 91 | 2016-12-08 12:36:39 | threatener | 1 | 67641 | 3 | 1.680 | 40262.5 |
| 90 | 2016-12-06 18:22:38 | threatener | 1 | 67641 | 3 | 1.693 | 39953.3 |
| 89 | 2016-11-19 00:35:30 | threatener | 1 | 67641 | 3 | 1.650 | 40994.5 |
| 88 | 2016-10-16 12:34:54 | threatener | 1 | 67641 | 3 | 1.383 | 48908.9 |
| 87 | 2016-07-27 10:49:15 | threatener | 1 | 67641 | 3 | 2.490 | 27165.1 |
| 86 | 2016-07-11 07:42:25 | threatener | 2 | 108824 | 5 | 3.836 | 28369.1 |
| 85 | 2016-07-10 07:50:17 | threatener | 4 | 161450 | 117 | 21.753 | 7422.0 |
| 84 | 2016-07-10 07:14:05 | threatener | 3 | 140603 | 17 | 10.116 | 13899.1 |