History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preprice"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 293 | 2024-06-02 15:23:58 | preprice | 1 | 82945 | 4 | 2.393 | 34661.5 |
| 292 | 2024-05-31 18:48:21 | preprice | 1 | 82945 | 4 | 2.970 | 27927.6 |
| 291 | 2024-05-23 14:36:49 | preprice | 1 | 82945 | 4 | 3.500 | 23698.6 |
| 290 | 2024-05-11 08:06:14 | preprice | 1 | 82945 | 4 | 2.250 | 36864.4 |
| 289 | 2024-05-03 18:49:24 | preprice | 2 | 121059 | 14 | 4.406 | 27475.9 |
| 288 | 2024-05-03 02:52:00 | preprice | 3 | 146162 | 123 | 6.640 | 22012.3 |
| 287 | 2024-05-02 06:37:12 | preprice | 1 | 82945 | 4 | 2.780 | 29836.3 |
| 286 | 2024-05-02 06:36:56 | preprice | 3 | 146162 | 123 | 17.516 | 8344.5 |
| 285 | 2024-05-02 06:37:03 | preprice | 2 | 121059 | 14 | 7.830 | 15460.9 |
| 284 | 2024-04-15 21:24:07 | preprice | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 283 | 2024-04-13 09:41:27 | preprice | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 282 | 2024-04-12 20:08:57 | preprice | 2 | 121059 | 14 | 4.436 | 27290.1 |
| 281 | 2024-04-12 20:08:33 | preprice | 3 | 146162 | 123 | 9.453 | 15462.0 |
| 280 | 2024-04-12 00:04:28 | preprice | 3 | 146162 | 123 | 21.733 | 6725.3 |
| 279 | 2024-04-11 01:06:50 | preprice | 3 | 146162 | 123 | 17.266 | 8465.3 |
| 278 | 2024-04-10 01:41:56 | preprice | 3 | 146162 | 123 | 7.656 | 19091.2 |
| 277 | 2024-04-10 01:41:57 | preprice | 2 | 121059 | 14 | 3.970 | 30493.5 |
| 276 | 2024-04-10 01:41:54 | preprice | 1 | 82945 | 4 | 1.783 | 46519.9 |
| 275 | 2024-04-08 13:37:26 | preprice | 1 | 82945 | 4 | 1.640 | 50576.2 |
| 274 | 2024-03-29 12:23:12 | preprice | 1 | 82945 | 4 | 3.080 | 26930.2 |
| 273 | 2024-03-29 12:10:15 | preprice | 1 | 82945 | 4 | 4.296 | 19307.5 |
| 272 | 2024-03-25 15:42:00 | preprice | 2 | 121059 | 14 | 3.266 | 37066.4 |
| 271 | 2024-03-08 21:11:51 | preprice | 1 | 82945 | 4 | 1.640 | 50576.2 |
| 270 | 2024-03-02 03:43:35 | preprice | 3 | 146162 | 123 | 13.580 | 10763.0 |
| 269 | 2024-03-01 17:02:02 | preprice | 1 | 82945 | 4 | 3.593 | 23085.2 |
| 268 | 2024-02-28 01:52:47 | preprice | 3 | 146162 | 123 | 7.876 | 18557.9 |
| 267 | 2024-02-28 01:52:47 | preprice | 2 | 121059 | 14 | 5.516 | 21946.9 |
| 266 | 2024-02-28 01:52:45 | preprice | 1 | 82945 | 4 | 1.546 | 53651.4 |
| 265 | 2024-02-28 01:52:21 | preprice | 3 | 146162 | 123 | 8.390 | 17421.0 |
| 264 | 2024-02-28 01:52:24 | preprice | 2 | 121059 | 14 | 4.173 | 29010.1 |
| 263 | 2024-02-28 01:52:18 | preprice | 1 | 82945 | 4 | 1.580 | 52496.8 |
| 262 | 2024-02-01 17:38:53 | preprice | 1 | 82945 | 4 | 1.300 | 63803.8 |
| 261 | 2024-01-06 10:17:17 | preprice | 2 | 121059 | 14 | 7.110 | 17026.6 |
| 260 | 2024-01-06 10:17:15 | preprice | 3 | 146162 | 123 | 7.266 | 20115.9 |
| 259 | 2023-12-30 06:48:39 | preprice | 1 | 82945 | 4 | 2.796 | 29665.6 |
| 258 | 2023-12-27 16:13:30 | preprice | 1 | 82945 | 4 | 1.360 | 60989.0 |
| 257 | 2023-12-27 01:42:18 | preprice | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 256 | 2023-12-27 01:16:49 | preprice | 3 | 146162 | 123 | 6.466 | 22604.7 |
| 255 | 2023-12-06 11:15:27 | preprice | 2 | 121059 | 14 | 3.643 | 33230.6 |
| 254 | 2023-12-06 11:15:19 | preprice | 3 | 146162 | 123 | 7.533 | 19402.9 |
| 253 | 2023-12-01 17:51:20 | preprice | 2 | 121059 | 14 | 3.326 | 36397.8 |
| 252 | 2023-11-19 00:59:42 | preprice | 1 | 82945 | 4 | 1.356 | 61168.9 |
| 251 | 2023-11-14 08:08:36 | preprice | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 250 | 2023-11-04 14:52:13 | preprice | 1 | 82945 | 4 | 1.403 | 59119.7 |
| 249 | 2023-10-28 03:59:31 | preprice | 1 | 82945 | 4 | 1.563 | 53067.8 |
| 248 | 2023-10-18 08:59:25 | preprice | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 247 | 2023-10-17 15:01:49 | preprice | 1 | 82945 | 4 | 1.326 | 62552.8 |
| 246 | 2023-10-06 22:16:28 | preprice | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 245 | 2023-10-06 21:59:10 | preprice | 3 | 146162 | 123 | 8.593 | 17009.4 |
| 244 | 2023-09-29 04:57:14 | preprice | 3 | 146162 | 123 | 6.530 | 22383.2 |
| 243 | 2023-08-31 16:50:12 | preprice | 2 | 121059 | 14 | 3.330 | 36354.1 |
| 242 | 2023-08-21 07:10:56 | preprice | 1 | 82945 | 4 | 1.356 | 61168.9 |
| 241 | 2023-08-15 05:47:34 | preprice | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 240 | 2023-07-10 15:09:14 | preprice | 3 | 146162 | 123 | 6.953 | 21021.4 |
| 239 | 2023-05-16 14:06:05 | preprice | 2 | 121059 | 14 | 3.220 | 37596.0 |
| 238 | 2023-05-15 20:51:50 | preprice | 1 | 82945 | 4 | 1.266 | 65517.4 |
| 237 | 2023-04-29 23:31:20 | preprice | 1 | 82945 | 4 | 1.263 | 65673.0 |
| 236 | 2023-03-30 19:33:24 | preprice | 3 | 146162 | 123 | 6.233 | 23449.7 |
| 235 | 2023-03-11 10:54:46 | preprice | 1 | 82945 | 4 | 1.280 | 64800.8 |
| 234 | 2023-03-02 23:20:33 | preprice | 1 | 82945 | 4 | 1.280 | 64800.8 |
| 233 | 2023-02-22 18:34:09 | preprice | 2 | 121059 | 14 | 3.173 | 38152.9 |
| 232 | 2023-01-10 04:45:04 | preprice | 1 | 82945 | 4 | 1.266 | 65517.4 |
| 231 | 2023-01-01 01:30:14 | preprice | 1 | 82945 | 4 | 1.360 | 60989.0 |
| 230 | 2022-12-29 02:36:53 | preprice | 3 | 146162 | 123 | 6.313 | 23152.5 |
| 229 | 2022-12-02 21:36:16 | preprice | 2 | 121059 | 14 | 3.156 | 38358.4 |
| 228 | 2022-09-23 07:43:18 | preprice | 3 | 146162 | 123 | 6.626 | 22058.9 |
| 227 | 2022-09-19 03:25:18 | preprice | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 226 | 2022-09-11 23:58:12 | preprice | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 225 | 2022-08-30 02:26:52 | preprice | 3 | 146162 | 123 | 6.326 | 23105.0 |
| 224 | 2022-07-13 21:37:53 | preprice | 2 | 121059 | 14 | 4.140 | 29241.3 |
| 223 | 2022-07-11 10:42:31 | preprice | 2 | 121059 | 14 | 3.250 | 37248.9 |
| 222 | 2022-05-06 08:19:03 | preprice | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 221 | 2022-04-27 10:18:08 | preprice | 1 | 82945 | 4 | 1.530 | 54212.4 |
| 220 | 2022-03-24 19:24:53 | preprice | 3 | 146162 | 123 | 9.500 | 15385.5 |
| 219 | 2022-03-22 15:35:08 | preprice | 3 | 146162 | 123 | 7.046 | 20744.0 |
| 218 | 2022-01-20 21:28:05 | preprice | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 217 | 2022-01-18 16:54:38 | preprice | 1 | 82945 | 4 | 1.326 | 62552.8 |
| 216 | 2022-01-15 10:18:25 | preprice | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 215 | 2022-01-12 03:41:14 | preprice | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 214 | 2021-12-07 13:24:28 | preprice | 3 | 146162 | 123 | 15.470 | 9448.1 |
| 213 | 2021-11-18 13:20:42 | preprice | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 212 | 2021-10-21 18:17:31 | preprice | 1 | 82945 | 4 | 1.450 | 57203.4 |
| 211 | 2021-10-20 20:46:08 | preprice | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 210 | 2021-10-04 05:45:32 | preprice | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 209 | 2021-10-02 02:59:06 | preprice | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 208 | 2021-09-29 13:02:34 | preprice | 1 | 82945 | 4 | 1.280 | 64800.8 |
| 207 | 2021-09-26 06:31:32 | preprice | 1 | 82945 | 4 | 1.420 | 58412.0 |
| 206 | 2021-09-20 00:22:52 | preprice | 1 | 82945 | 4 | 1.513 | 54821.5 |
| 205 | 2021-09-18 20:36:16 | preprice | 1 | 82945 | 4 | 2.580 | 32149.2 |
| 204 | 2021-09-11 19:57:41 | preprice | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 203 | 2021-09-10 18:29:54 | preprice | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 202 | 2021-06-23 06:24:33 | preprice | 1 | 82945 | 4 | 1.530 | 54212.4 |
| 201 | 2021-04-13 23:53:29 | preprice | 1 | 82945 | 4 | 3.060 | 27106.2 |
| 200 | 2021-03-21 02:33:24 | preprice | 1 | 82945 | 4 | 1.466 | 56579.1 |
| 199 | 2021-01-27 15:57:54 | preprice | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 198 | 2020-12-29 21:30:09 | preprice | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 197 | 2020-12-18 05:50:07 | preprice | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 196 | 2020-10-16 17:09:05 | preprice | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 195 | 2020-10-15 16:53:49 | preprice | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 194 | 2020-09-21 22:11:22 | preprice | 1 | 82945 | 4 | 1.423 | 58288.8 |