History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"misdates"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 437 | 2024-04-16 07:38:39 | misdates | 2 | 121059 | 27 | 4.080 | 29671.3 |
| 436 | 2024-04-16 06:25:27 | misdates | 3 | 146162 | 280 | 8.300 | 17609.9 |
| 435 | 2024-04-16 04:59:42 | misdates | 2 | 121059 | 27 | 11.643 | 10397.6 |
| 434 | 2024-04-16 04:58:47 | misdates | 3 | 146162 | 280 | 31.686 | 4612.8 |
| 433 | 2024-04-16 04:56:05 | misdates | 1 | 82945 | 5 | 4.296 | 19307.5 |
| 432 | 2024-04-11 05:48:27 | misdates | 1 | 82945 | 5 | 1.373 | 60411.5 |
| 431 | 2024-04-06 10:11:31 | misdates | 1 | 82945 | 5 | 1.623 | 51106.0 |
| 430 | 2024-03-12 03:52:42 | misdates | 2 | 121059 | 27 | 4.890 | 24756.4 |
| 429 | 2024-03-12 03:51:59 | misdates | 3 | 146162 | 280 | 9.436 | 15489.8 |
| 428 | 2024-03-07 18:14:25 | misdates | 3 | 146162 | 280 | 6.703 | 21805.5 |
| 427 | 2024-03-05 16:58:59 | misdates | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 426 | 2024-03-05 12:03:25 | misdates | 2 | 121059 | 27 | 3.500 | 34588.3 |
| 425 | 2024-03-05 12:02:30 | misdates | 3 | 146162 | 280 | 7.546 | 19369.5 |
| 424 | 2024-03-05 01:23:03 | misdates | 2 | 121059 | 27 | 9.250 | 13087.5 |
| 423 | 2024-03-04 13:32:41 | misdates | 3 | 146162 | 280 | 35.486 | 4118.9 |
| 422 | 2024-03-04 12:24:53 | misdates | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 421 | 2024-03-04 12:24:04 | misdates | 2 | 121059 | 27 | 8.343 | 14510.2 |
| 420 | 2024-03-04 10:55:06 | misdates | 3 | 146162 | 280 | 16.456 | 8882.0 |
| 419 | 2024-03-03 05:25:25 | misdates | 3 | 146162 | 280 | 24.550 | 5953.6 |
| 418 | 2024-03-03 05:25:24 | misdates | 2 | 121059 | 27 | 8.470 | 14292.7 |
| 417 | 2024-03-03 04:47:24 | misdates | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 416 | 2024-02-29 10:29:06 | misdates | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 415 | 2024-02-07 01:20:38 | misdates | 3 | 146162 | 280 | 10.936 | 13365.2 |
| 414 | 2024-02-01 00:07:24 | misdates | 3 | 146162 | 280 | 7.126 | 20511.1 |
| 413 | 2024-01-31 10:02:08 | misdates | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 412 | 2024-01-29 12:41:45 | misdates | 3 | 146162 | 280 | 8.830 | 16552.9 |
| 411 | 2024-01-25 17:55:03 | misdates | 3 | 146162 | 280 | 7.236 | 20199.3 |
| 410 | 2024-01-24 23:12:32 | misdates | 3 | 146162 | 280 | 7.690 | 19006.8 |
| 409 | 2024-01-10 01:18:09 | misdates | 2 | 121059 | 27 | 3.423 | 35366.3 |
| 408 | 2024-01-01 12:52:05 | misdates | 3 | 146162 | 280 | 7.876 | 18557.9 |
| 407 | 2023-12-28 13:49:17 | misdates | 3 | 146162 | 280 | 6.486 | 22535.0 |
| 406 | 2023-12-28 13:49:13 | misdates | 2 | 121059 | 27 | 3.313 | 36540.6 |
| 405 | 2023-12-28 01:24:32 | misdates | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 404 | 2023-12-06 08:34:31 | misdates | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 403 | 2023-11-21 00:25:51 | misdates | 1 | 82945 | 5 | 1.310 | 63316.8 |
| 402 | 2023-11-17 16:43:18 | misdates | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 401 | 2023-11-14 20:37:06 | misdates | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 400 | 2023-11-04 23:38:39 | misdates | 3 | 146162 | 280 | 6.686 | 21860.9 |
| 399 | 2023-11-03 17:55:01 | misdates | 1 | 82945 | 5 | 2.920 | 28405.8 |
| 398 | 2023-11-02 23:32:39 | misdates | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 397 | 2023-10-30 10:08:08 | misdates | 1 | 82945 | 5 | 1.373 | 60411.5 |
| 396 | 2023-10-17 09:44:55 | misdates | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 395 | 2023-08-14 05:45:25 | misdates | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 394 | 2023-08-09 23:39:19 | misdates | 3 | 146162 | 280 | 6.156 | 23743.0 |
| 393 | 2023-08-04 11:01:35 | misdates | 1 | 82945 | 5 | 2.890 | 28700.7 |
| 392 | 2023-07-08 07:16:03 | misdates | 3 | 146162 | 280 | 6.126 | 23859.3 |
| 391 | 2023-05-16 03:24:29 | misdates | 1 | 82945 | 5 | 1.236 | 67107.6 |
| 390 | 2023-05-15 12:22:32 | misdates | 3 | 146162 | 280 | 6.186 | 23627.9 |
| 389 | 2023-04-23 07:04:35 | misdates | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 388 | 2023-04-23 05:57:28 | misdates | 3 | 146162 | 280 | 6.483 | 22545.4 |
| 387 | 2023-04-22 17:03:35 | misdates | 3 | 146162 | 280 | 6.173 | 23677.6 |
| 386 | 2023-03-25 17:51:10 | misdates | 3 | 146162 | 280 | 6.126 | 23859.3 |
| 385 | 2023-03-19 10:03:14 | misdates | 3 | 146162 | 280 | 6.016 | 24295.5 |
| 384 | 2023-03-11 19:53:18 | misdates | 1 | 82945 | 5 | 1.550 | 53512.9 |
| 383 | 2023-02-26 05:31:03 | misdates | 3 | 146162 | 280 | 13.700 | 10668.8 |
| 382 | 2023-01-27 22:46:31 | misdates | 3 | 146162 | 280 | 6.986 | 20922.1 |
| 381 | 2023-01-14 14:37:11 | misdates | 1 | 82945 | 5 | 1.233 | 67270.9 |
| 380 | 2023-01-08 18:59:03 | misdates | 3 | 146162 | 280 | 6.296 | 23215.1 |
| 379 | 2023-01-05 18:56:24 | misdates | 3 | 146162 | 280 | 9.733 | 15017.2 |
| 378 | 2022-12-30 17:39:13 | misdates | 1 | 82945 | 5 | 1.233 | 67270.9 |
| 377 | 2022-12-13 02:01:32 | misdates | 3 | 146162 | 280 | 6.000 | 24360.3 |
| 376 | 2022-12-09 20:54:00 | misdates | 3 | 146162 | 280 | 6.063 | 24107.2 |
| 375 | 2022-11-10 08:33:26 | misdates | 3 | 146162 | 280 | 6.643 | 22002.4 |
| 374 | 2022-09-27 00:29:05 | misdates | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 373 | 2022-09-19 11:41:25 | misdates | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 372 | 2022-09-18 21:50:47 | misdates | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 371 | 2022-08-24 02:47:21 | misdates | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 370 | 2022-06-30 00:14:12 | misdates | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 369 | 2022-06-10 01:28:06 | misdates | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 368 | 2022-05-29 22:53:39 | misdates | 3 | 146162 | 280 | 6.186 | 23627.9 |
| 367 | 2022-02-26 13:19:53 | misdates | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 366 | 2022-02-26 12:15:14 | misdates | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 365 | 2022-02-23 01:52:27 | misdates | 1 | 82945 | 5 | 1.580 | 52496.8 |
| 364 | 2021-12-15 11:35:17 | misdates | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 363 | 2021-11-21 14:51:44 | misdates | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 362 | 2021-11-07 06:10:04 | misdates | 1 | 82945 | 5 | 2.763 | 30019.9 |
| 361 | 2021-10-22 15:46:45 | misdates | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 360 | 2021-10-20 14:41:03 | misdates | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 359 | 2021-08-18 18:01:52 | misdates | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 358 | 2021-05-14 18:50:28 | misdates | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 357 | 2021-03-24 02:54:31 | misdates | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 356 | 2021-02-17 11:06:02 | misdates | 1 | 82945 | 5 | 1.466 | 56579.1 |
| 355 | 2021-02-11 20:07:32 | misdates | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 354 | 2021-02-06 21:08:19 | misdates | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 353 | 2021-02-02 10:54:19 | misdates | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 352 | 2021-01-06 18:00:10 | misdates | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 351 | 2021-01-06 17:10:55 | misdates | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 350 | 2020-12-08 20:49:32 | misdates | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 349 | 2020-11-05 14:02:16 | misdates | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 348 | 2020-11-04 21:24:59 | misdates | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 347 | 2020-11-04 21:01:59 | misdates | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 346 | 2020-10-30 07:56:50 | misdates | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 345 | 2020-10-16 11:12:48 | misdates | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 344 | 2020-10-06 20:55:43 | misdates | 1 | 82945 | 5 | 1.373 | 60411.5 |
| 343 | 2020-08-01 04:11:12 | misdates | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 342 | 2020-07-31 03:43:29 | misdates | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 341 | 2020-07-24 02:13:10 | misdates | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 340 | 2020-07-22 23:38:32 | misdates | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 339 | 2020-06-17 08:01:38 | misdates | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 338 | 2020-05-04 05:12:36 | misdates | 1 | 82945 | 5 | 1.266 | 65517.4 |