History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pactions"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 353 | 2024-04-10 01:26:46 | pactions | 1 | 82945 | 5 | 1.533 | 54106.3 |
| 352 | 2024-04-06 07:09:39 | pactions | 1 | 82945 | 5 | 2.283 | 36331.6 |
| 351 | 2024-04-01 15:26:07 | pactions | 3 | 146162 | 299 | 10.626 | 13755.1 |
| 350 | 2024-04-01 12:40:59 | pactions | 1 | 82945 | 5 | 2.716 | 30539.4 |
| 349 | 2024-03-29 01:34:04 | pactions | 2 | 121059 | 45 | 4.453 | 27185.9 |
| 348 | 2024-03-29 01:33:46 | pactions | 3 | 146162 | 299 | 10.050 | 14543.5 |
| 347 | 2024-03-29 01:33:47 | pactions | 2 | 121059 | 45 | 4.266 | 28377.6 |
| 346 | 2024-03-29 01:33:41 | pactions | 1 | 82945 | 5 | 1.503 | 55186.3 |
| 345 | 2024-03-29 01:33:24 | pactions | 3 | 146162 | 299 | 8.330 | 17546.5 |
| 344 | 2024-03-29 00:25:55 | pactions | 3 | 146162 | 299 | 26.066 | 5607.4 |
| 343 | 2024-03-29 00:25:57 | pactions | 2 | 121059 | 45 | 10.876 | 11130.8 |
| 342 | 2024-03-28 22:39:25 | pactions | 1 | 82945 | 5 | 2.046 | 40540.1 |
| 341 | 2024-03-28 09:50:31 | pactions | 1 | 82945 | 5 | 5.096 | 16276.5 |
| 340 | 2024-03-25 13:33:11 | pactions | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 339 | 2024-03-01 02:58:58 | pactions | 1 | 82945 | 5 | 4.470 | 18555.9 |
| 338 | 2024-01-04 05:08:44 | pactions | 3 | 146162 | 299 | 7.483 | 19532.5 |
| 337 | 2024-01-04 05:08:45 | pactions | 2 | 121059 | 45 | 4.016 | 30144.2 |
| 336 | 2023-12-24 19:15:28 | pactions | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 335 | 2023-12-10 14:13:38 | pactions | 1 | 82945 | 5 | 1.953 | 42470.6 |
| 334 | 2023-12-05 01:27:20 | pactions | 3 | 146162 | 299 | 7.080 | 20644.4 |
| 333 | 2023-12-05 01:27:18 | pactions | 2 | 121059 | 45 | 3.453 | 35059.1 |
| 332 | 2023-11-19 18:47:43 | pactions | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 331 | 2023-11-13 20:34:37 | pactions | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 330 | 2023-11-06 05:20:15 | pactions | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 329 | 2023-10-31 21:47:06 | pactions | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 328 | 2023-10-28 02:11:49 | pactions | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 327 | 2023-10-14 15:14:24 | pactions | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 326 | 2023-10-12 10:52:18 | pactions | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 325 | 2023-10-06 14:43:11 | pactions | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 324 | 2023-09-14 20:55:15 | pactions | 1 | 82945 | 5 | 1.626 | 51011.7 |
| 323 | 2023-08-17 21:34:01 | pactions | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 322 | 2023-08-08 15:19:42 | pactions | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 321 | 2023-05-06 02:41:35 | pactions | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 320 | 2023-04-29 22:46:21 | pactions | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 319 | 2023-02-27 14:40:28 | pactions | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 318 | 2023-01-21 10:09:45 | pactions | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 317 | 2022-12-24 00:27:48 | pactions | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 316 | 2022-10-07 03:14:14 | pactions | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 315 | 2022-10-03 13:50:52 | pactions | 1 | 82945 | 5 | 1.440 | 57600.7 |
| 314 | 2022-09-06 23:03:32 | pactions | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 313 | 2022-09-04 20:41:50 | pactions | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 312 | 2022-06-12 23:19:01 | pactions | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 311 | 2022-04-13 18:54:47 | pactions | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 310 | 2022-02-19 00:03:49 | pactions | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 309 | 2022-01-11 16:29:18 | pactions | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 308 | 2021-11-17 15:44:21 | pactions | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 307 | 2021-11-15 22:41:33 | pactions | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 306 | 2021-11-13 20:27:55 | pactions | 1 | 82945 | 5 | 1.623 | 51106.0 |
| 305 | 2021-09-29 10:26:17 | pactions | 1 | 82945 | 5 | 2.983 | 27805.9 |
| 304 | 2021-09-14 11:45:15 | pactions | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 303 | 2021-08-18 02:35:31 | pactions | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 302 | 2021-08-14 19:15:14 | pactions | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 301 | 2021-06-28 03:27:15 | pactions | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 300 | 2021-05-14 03:35:09 | pactions | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 299 | 2021-04-06 09:27:35 | pactions | 3 | 146162 | 299 | 7.940 | 18408.3 |
| 298 | 2021-02-22 14:26:41 | pactions | 2 | 121059 | 45 | 3.216 | 37642.7 |
| 297 | 2021-02-17 19:27:39 | pactions | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 296 | 2021-02-10 18:12:51 | pactions | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 295 | 2021-02-05 23:58:38 | pactions | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 294 | 2021-01-24 11:26:21 | pactions | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 293 | 2021-01-21 15:36:21 | pactions | 3 | 146162 | 299 | 7.530 | 19410.6 |
| 292 | 2020-12-22 10:24:49 | pactions | 3 | 146162 | 299 | 6.453 | 22650.2 |
| 291 | 2020-11-10 21:59:54 | pactions | 1 | 82945 | 5 | 1.610 | 51518.6 |
| 290 | 2020-11-03 23:02:03 | pactions | 1 | 82945 | 5 | 1.513 | 54821.5 |
| 289 | 2020-11-03 08:41:18 | pactions | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 288 | 2020-11-01 22:49:23 | pactions | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 287 | 2020-10-15 10:34:38 | pactions | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 286 | 2020-10-10 00:07:20 | pactions | 1 | 82945 | 5 | 2.720 | 30494.5 |
| 285 | 2020-09-06 10:49:14 | pactions | 2 | 121059 | 45 | 3.500 | 34588.3 |
| 284 | 2020-08-12 11:47:38 | pactions | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 283 | 2020-08-06 12:16:58 | pactions | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 282 | 2020-07-31 13:06:31 | pactions | 1 | 82945 | 5 | 1.533 | 54106.3 |
| 281 | 2020-05-13 18:49:25 | pactions | 2 | 121059 | 45 | 3.470 | 34887.3 |
| 280 | 2020-04-29 02:15:40 | pactions | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 279 | 2020-03-28 09:26:11 | pactions | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 278 | 2020-03-26 10:39:24 | pactions | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 277 | 2020-03-23 22:39:38 | pactions | 1 | 82945 | 5 | 1.623 | 51106.0 |
| 276 | 2020-03-21 08:15:19 | pactions | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 275 | 2020-03-02 18:05:34 | pactions | 3 | 146162 | 299 | 9.140 | 15991.5 |
| 274 | 2020-02-26 06:52:41 | pactions | 1 | 82945 | 5 | 1.626 | 51011.7 |
| 273 | 2020-02-24 09:41:14 | pactions | 1 | 82945 | 5 | 3.580 | 23169.0 |
| 272 | 2020-02-22 18:10:54 | pactions | 1 | 82945 | 5 | 3.173 | 26140.9 |
| 271 | 2020-02-06 09:44:30 | pactions | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 270 | 2020-02-05 21:03:25 | pactions | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 269 | 2020-02-03 23:39:50 | pactions | 1 | 82945 | 5 | 2.830 | 29309.2 |
| 268 | 2020-01-31 07:41:42 | pactions | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 267 | 2020-01-30 05:50:36 | pactions | 1 | 82945 | 5 | 1.673 | 49578.6 |
| 266 | 2020-01-28 05:40:47 | pactions | 1 | 82945 | 5 | 3.000 | 27648.3 |
| 265 | 2020-01-28 03:04:04 | pactions | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 264 | 2020-01-16 16:00:35 | pactions | 3 | 146162 | 299 | 6.970 | 20970.2 |
| 263 | 2020-01-16 15:58:43 | pactions | 3 | 146162 | 299 | 25.296 | 5778.1 |
| 262 | 2020-01-16 15:00:46 | pactions | 3 | 146162 | 299 | 7.470 | 19566.5 |
| 261 | 2020-01-16 14:34:07 | pactions | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 260 | 2020-01-16 10:10:30 | pactions | 2 | 121059 | 45 | 3.920 | 30882.4 |
| 259 | 2020-01-16 10:09:28 | pactions | 3 | 146162 | 299 | 10.656 | 13716.4 |
| 258 | 2020-01-16 04:32:19 | pactions | 1 | 82945 | 5 | 1.703 | 48705.2 |
| 257 | 2020-01-12 10:21:54 | pactions | 1 | 82945 | 5 | 1.653 | 50178.5 |
| 256 | 2020-01-07 15:17:48 | pactions | 1 | 82945 | 5 | 3.530 | 23497.2 |
| 255 | 2020-01-01 07:50:19 | pactions | 1 | 82945 | 5 | 3.140 | 26415.6 |
| 254 | 2019-12-28 06:57:50 | pactions | 1 | 82945 | 5 | 1.483 | 55930.5 |