History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"permittees"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 235 | 2024-05-08 09:10:53 | permittees | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 234 | 2024-05-06 08:01:09 | permittees | 1 | 67641 | 3 | 1.310 | 51634.4 |
| 233 | 2024-05-01 00:04:20 | permittees | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 232 | 2024-04-29 02:33:19 | permittees | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 231 | 2024-04-28 16:05:21 | permittees | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 230 | 2024-04-24 18:30:57 | permittees | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 229 | 2024-04-05 17:42:14 | permittees | 1 | 67641 | 3 | 3.033 | 22301.7 |
| 228 | 2024-04-04 03:03:43 | permittees | 4 | 161450 | 175 | 29.016 | 5564.2 |
| 227 | 2024-04-04 03:03:46 | permittees | 3 | 140603 | 21 | 8.373 | 16792.4 |
| 226 | 2024-04-04 03:03:46 | permittees | 2 | 108824 | 5 | 8.220 | 13238.9 |
| 225 | 2024-04-04 01:30:19 | permittees | 1 | 67641 | 3 | 1.296 | 52192.1 |
| 224 | 2024-03-30 22:02:37 | permittees | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 223 | 2024-03-26 20:16:42 | permittees | 3 | 140603 | 21 | 24.363 | 5771.2 |
| 222 | 2024-03-26 20:16:54 | permittees | 2 | 108824 | 5 | 11.953 | 9104.3 |
| 221 | 2024-03-26 19:07:04 | permittees | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 220 | 2024-03-24 02:40:28 | permittees | 2 | 108824 | 5 | 2.953 | 36852.0 |
| 219 | 2024-03-22 13:07:19 | permittees | 3 | 140603 | 21 | 8.593 | 16362.5 |
| 218 | 2024-03-22 11:35:18 | permittees | 1 | 67641 | 3 | 1.546 | 43752.3 |
| 217 | 2024-03-20 00:32:01 | permittees | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 216 | 2024-03-11 06:17:40 | permittees | 4 | 161450 | 175 | 18.126 | 8907.1 |
| 215 | 2024-03-08 15:24:19 | permittees | 4 | 161450 | 175 | 35.690 | 4523.7 |
| 214 | 2024-03-08 15:13:01 | permittees | 4 | 161450 | 175 | 14.080 | 11466.6 |
| 213 | 2024-03-08 15:12:49 | permittees | 4 | 161450 | 175 | 15.720 | 10270.4 |
| 212 | 2024-03-06 15:18:55 | permittees | 1 | 67641 | 3 | 3.483 | 19420.3 |
| 211 | 2024-03-02 05:22:09 | permittees | 1 | 67641 | 3 | 1.310 | 51634.4 |
| 210 | 2024-02-28 12:31:12 | permittees | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 209 | 2024-02-20 05:48:06 | permittees | 1 | 67641 | 3 | 2.330 | 29030.5 |
| 208 | 2024-02-08 09:56:07 | permittees | 1 | 67641 | 3 | 3.143 | 21521.2 |
| 207 | 2024-02-05 08:29:52 | permittees | 1 | 67641 | 3 | 2.640 | 25621.6 |
| 206 | 2024-02-03 16:59:54 | permittees | 3 | 140603 | 21 | 6.373 | 22062.3 |
| 205 | 2024-02-03 16:53:26 | permittees | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 204 | 2024-01-28 18:05:15 | permittees | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 203 | 2024-01-18 11:35:36 | permittees | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 202 | 2024-01-07 09:45:52 | permittees | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 201 | 2024-01-06 18:06:30 | permittees | 3 | 140603 | 21 | 6.393 | 21993.3 |
| 200 | 2023-12-30 09:20:54 | permittees | 3 | 140603 | 21 | 6.766 | 20780.8 |
| 199 | 2023-12-17 03:26:16 | permittees | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 198 | 2023-12-14 21:04:42 | permittees | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 197 | 2023-12-01 05:02:41 | permittees | 2 | 108824 | 5 | 2.763 | 39386.2 |
| 196 | 2023-11-30 00:25:55 | permittees | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 195 | 2023-11-27 00:09:51 | permittees | 4 | 161450 | 175 | 9.986 | 16167.6 |
| 194 | 2023-11-11 06:30:51 | permittees | 3 | 140603 | 21 | 5.546 | 25352.1 |
| 193 | 2023-10-30 10:55:28 | permittees | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 192 | 2023-10-29 19:09:07 | permittees | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 191 | 2023-10-14 13:16:50 | permittees | 1 | 67641 | 3 | 2.046 | 33060.1 |
| 190 | 2023-08-30 08:53:24 | permittees | 2 | 108824 | 5 | 3.080 | 35332.5 |
| 189 | 2023-08-26 17:41:24 | permittees | 4 | 161450 | 175 | 11.796 | 13686.8 |
| 188 | 2023-08-23 11:34:35 | permittees | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 187 | 2023-08-13 13:04:29 | permittees | 3 | 140603 | 21 | 5.673 | 24784.6 |
| 186 | 2023-08-06 23:08:42 | permittees | 4 | 161450 | 175 | 11.220 | 14389.5 |
| 185 | 2023-08-03 09:17:26 | permittees | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 184 | 2023-05-24 11:42:51 | permittees | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 183 | 2023-05-16 05:04:01 | permittees | 2 | 108824 | 5 | 2.766 | 39343.5 |
| 182 | 2023-05-12 16:06:21 | permittees | 4 | 161450 | 175 | 9.796 | 16481.2 |
| 181 | 2023-04-29 06:54:18 | permittees | 3 | 140603 | 21 | 5.623 | 25005.0 |
| 180 | 2023-03-27 10:28:03 | permittees | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 179 | 2023-03-21 12:54:52 | permittees | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 178 | 2023-02-24 22:15:37 | permittees | 4 | 161450 | 175 | 9.720 | 16610.1 |
| 177 | 2023-02-21 19:13:34 | permittees | 2 | 108824 | 5 | 2.750 | 39572.4 |
| 176 | 2023-02-17 23:59:06 | permittees | 4 | 161450 | 175 | 10.983 | 14700.0 |
| 175 | 2023-02-03 08:17:25 | permittees | 3 | 140603 | 21 | 6.390 | 22003.6 |
| 174 | 2023-01-08 02:22:01 | permittees | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 173 | 2022-12-02 08:21:51 | permittees | 2 | 108824 | 5 | 2.810 | 38727.4 |
| 172 | 2022-11-30 12:04:26 | permittees | 4 | 161450 | 175 | 9.736 | 16582.8 |
| 171 | 2022-11-22 11:21:05 | permittees | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 170 | 2022-11-15 06:49:36 | permittees | 3 | 140603 | 21 | 6.063 | 23190.3 |
| 169 | 2022-10-06 08:21:14 | permittees | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 168 | 2022-09-23 23:43:02 | permittees | 4 | 161450 | 175 | 9.936 | 16249.0 |
| 167 | 2022-08-25 12:29:51 | permittees | 4 | 161450 | 175 | 11.656 | 13851.2 |
| 166 | 2022-08-21 21:04:20 | permittees | 4 | 161450 | 175 | 9.986 | 16167.6 |
| 165 | 2022-08-16 09:59:53 | permittees | 4 | 161450 | 175 | 10.750 | 15018.6 |
| 164 | 2022-07-18 21:17:35 | permittees | 1 | 67641 | 3 | 1.050 | 64420.0 |
| 163 | 2022-07-08 06:53:54 | permittees | 2 | 108824 | 5 | 2.750 | 39572.4 |
| 162 | 2022-07-08 06:38:58 | permittees | 4 | 161450 | 175 | 10.033 | 16091.9 |
| 161 | 2022-06-20 15:42:24 | permittees | 3 | 140603 | 21 | 5.576 | 25215.7 |
| 160 | 2022-05-23 23:34:46 | permittees | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 159 | 2022-03-11 03:52:43 | permittees | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 158 | 2021-11-03 22:47:27 | permittees | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 157 | 2021-07-21 15:41:14 | permittees | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 156 | 2021-05-30 06:11:10 | permittees | 4 | 161450 | 175 | 22.893 | 7052.4 |
| 155 | 2021-05-02 04:40:40 | permittees | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 154 | 2021-04-18 19:59:08 | permittees | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 153 | 2021-03-31 10:21:16 | permittees | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 152 | 2021-02-27 16:47:20 | permittees | 4 | 161450 | 175 | 14.313 | 11280.0 |
| 151 | 2021-02-09 04:47:10 | permittees | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 150 | 2021-01-14 18:53:13 | permittees | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 149 | 2021-01-09 17:23:57 | permittees | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 148 | 2021-01-05 08:18:29 | permittees | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 147 | 2020-11-11 16:15:21 | permittees | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 146 | 2020-10-30 11:41:15 | permittees | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 145 | 2020-10-18 20:38:53 | permittees | 4 | 161450 | 175 | 11.546 | 13983.2 |
| 144 | 2020-09-29 14:09:44 | permittees | 1 | 67641 | 3 | 1.330 | 50857.9 |
| 143 | 2020-09-20 14:50:23 | permittees | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 142 | 2020-09-10 10:19:46 | permittees | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 141 | 2020-07-20 11:07:21 | permittees | 1 | 67641 | 3 | 1.283 | 52721.0 |
| 140 | 2020-06-07 20:00:33 | permittees | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 139 | 2020-04-25 12:15:27 | permittees | 4 | 161450 | 175 | 10.513 | 15357.2 |
| 138 | 2020-03-24 10:51:09 | permittees | 1 | 67641 | 3 | 2.516 | 26884.3 |
| 137 | 2020-02-29 19:17:00 | permittees | 1 | 67641 | 3 | 1.313 | 51516.4 |
| 136 | 2020-02-23 12:10:08 | permittees | 1 | 67641 | 3 | 1.440 | 46972.9 |