History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"misnames"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 583 | 2025-07-05 06:50:15 | misnames | 2 | 121059 | 15 | 10.393 | 11648.1 |
| 582 | 2025-06-27 01:30:19 | misnames | 1 | 82945 | 3 | 8.063 | 10287.1 |
| 581 | 2025-06-20 14:54:25 | misnames | 1 | 82945 | 3 | 10.563 | 7852.4 |
| 580 | 2025-06-18 09:02:45 | misnames | 1 | 82945 | 3 | 4.530 | 18310.2 |
| 579 | 2025-06-16 22:02:56 | misnames | 1 | 82945 | 3 | 4.266 | 19443.3 |
| 578 | 2025-06-12 03:31:01 | misnames | 1 | 82945 | 3 | 4.030 | 20581.9 |
| 577 | 2025-06-11 22:00:29 | misnames | 1 | 82945 | 3 | 3.640 | 22787.1 |
| 576 | 2025-05-28 06:16:16 | misnames | 3 | 146162 | 171 | 7.280 | 20077.2 |
| 575 | 2025-05-27 07:04:45 | misnames | 3 | 146162 | 171 | 37.283 | 3920.3 |
| 574 | 2025-05-26 01:49:49 | misnames | 1 | 82945 | 3 | 4.966 | 16702.6 |
| 573 | 2025-05-24 09:13:45 | misnames | 3 | 146162 | 171 | 30.880 | 4733.2 |
| 572 | 2025-05-22 15:05:45 | misnames | 2 | 121059 | 15 | 27.533 | 4396.9 |
| 571 | 2025-05-22 06:56:08 | misnames | 3 | 146162 | 171 | 24.703 | 5916.8 |
| 570 | 2025-05-20 12:42:01 | misnames | 1 | 82945 | 3 | 10.093 | 8218.1 |
| 569 | 2025-05-20 07:33:58 | misnames | 1 | 82945 | 3 | 9.453 | 8774.5 |
| 568 | 2025-05-18 09:40:53 | misnames | 1 | 82945 | 3 | 4.373 | 18967.5 |
| 567 | 2025-05-12 03:50:43 | misnames | 1 | 82945 | 3 | 5.156 | 16087.1 |
| 566 | 2025-05-11 21:29:41 | misnames | 1 | 82945 | 3 | 6.733 | 12319.2 |
| 565 | 2025-05-11 17:41:08 | misnames | 1 | 82945 | 3 | 1.580 | 52496.8 |
| 564 | 2025-05-10 17:56:39 | misnames | 1 | 82945 | 3 | 8.423 | 9847.4 |
| 563 | 2025-05-10 03:44:48 | misnames | 3 | 146162 | 171 | 34.520 | 4234.1 |
| 562 | 2025-05-10 00:07:07 | misnames | 3 | 146162 | 171 | 39.686 | 3683.0 |
| 561 | 2025-05-04 19:26:38 | misnames | 1 | 82945 | 3 | 2.983 | 27805.9 |
| 560 | 2025-04-21 18:17:10 | misnames | 2 | 121059 | 15 | 9.826 | 12320.3 |
| 559 | 2025-04-21 10:38:22 | misnames | 3 | 146162 | 171 | 19.766 | 7394.6 |
| 558 | 2025-04-20 11:24:41 | misnames | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 557 | 2025-04-20 06:35:17 | misnames | 1 | 82945 | 3 | 9.233 | 8983.5 |
| 556 | 2025-04-19 23:00:03 | misnames | 3 | 146162 | 171 | 33.110 | 4414.4 |
| 555 | 2025-04-18 08:30:34 | misnames | 3 | 146162 | 171 | 31.050 | 4707.3 |
| 554 | 2025-04-18 07:51:04 | misnames | 1 | 82945 | 3 | 8.050 | 10303.7 |
| 553 | 2025-04-17 01:07:35 | misnames | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 552 | 2025-04-06 02:45:13 | misnames | 1 | 82945 | 3 | 6.686 | 12405.8 |
| 551 | 2025-03-20 08:40:34 | misnames | 1 | 82945 | 3 | 4.126 | 20103.0 |
| 550 | 2025-03-12 16:35:17 | misnames | 1 | 82945 | 3 | 5.236 | 15841.3 |
| 549 | 2025-03-12 14:37:46 | misnames | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 548 | 2025-03-06 01:46:16 | misnames | 1 | 82945 | 3 | 5.483 | 15127.7 |
| 547 | 2025-02-19 07:23:47 | misnames | 3 | 146162 | 171 | 20.456 | 7145.2 |
| 546 | 2025-02-10 03:41:15 | misnames | 2 | 121059 | 15 | 8.766 | 13810.1 |
| 545 | 2025-02-10 03:34:30 | misnames | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 544 | 2025-01-30 00:31:58 | misnames | 1 | 82945 | 3 | 6.893 | 12033.2 |
| 543 | 2025-01-29 23:33:13 | misnames | 3 | 146162 | 171 | 36.440 | 4011.0 |
| 542 | 2025-01-28 15:31:56 | misnames | 3 | 146162 | 171 | 23.063 | 6337.5 |
| 541 | 2025-01-27 22:13:10 | misnames | 3 | 146162 | 171 | 24.253 | 6026.6 |
| 540 | 2025-01-27 21:59:46 | misnames | 3 | 146162 | 171 | 19.080 | 7660.5 |
| 539 | 2025-01-27 21:59:46 | misnames | 2 | 121059 | 15 | 7.436 | 16280.1 |
| 538 | 2025-01-27 21:59:40 | misnames | 1 | 82945 | 3 | 3.360 | 24686.0 |
| 537 | 2025-01-17 02:50:15 | misnames | 1 | 82945 | 3 | 2.970 | 27927.6 |
| 536 | 2025-01-07 02:33:52 | misnames | 1 | 82945 | 3 | 6.326 | 13111.8 |
| 535 | 2025-01-02 14:45:59 | misnames | 1 | 82945 | 3 | 9.690 | 8559.9 |
| 534 | 2024-12-20 04:29:27 | misnames | 1 | 82945 | 3 | 7.906 | 10491.4 |
| 533 | 2024-12-04 19:33:02 | misnames | 3 | 146162 | 171 | 30.376 | 4811.8 |
| 532 | 2024-12-03 00:42:18 | misnames | 1 | 82945 | 3 | 9.563 | 8673.5 |
| 531 | 2024-11-22 10:19:09 | misnames | 3 | 146162 | 171 | 7.876 | 18557.9 |
| 530 | 2024-11-21 04:07:25 | misnames | 3 | 146162 | 171 | 56.060 | 2607.2 |
| 529 | 2024-11-20 19:38:34 | misnames | 3 | 146162 | 171 | 37.520 | 3895.6 |
| 528 | 2024-11-20 10:34:32 | misnames | 3 | 146162 | 171 | 41.800 | 3496.7 |
| 527 | 2024-11-20 10:34:34 | misnames | 2 | 121059 | 15 | 8.906 | 13593.0 |
| 526 | 2024-11-20 00:02:56 | misnames | 1 | 82945 | 3 | 10.220 | 8115.9 |
| 525 | 2024-11-09 21:16:47 | misnames | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 524 | 2024-11-04 03:50:30 | misnames | 2 | 121059 | 15 | 18.203 | 6650.5 |
| 523 | 2024-10-31 01:31:03 | misnames | 2 | 121059 | 15 | 3.703 | 32692.1 |
| 522 | 2024-10-31 01:31:04 | misnames | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 521 | 2024-10-22 03:40:54 | misnames | 3 | 146162 | 171 | 42.176 | 3465.5 |
| 520 | 2024-10-22 00:15:53 | misnames | 3 | 146162 | 171 | 41.016 | 3563.5 |
| 519 | 2024-10-18 12:03:50 | misnames | 2 | 121059 | 15 | 18.923 | 6397.5 |
| 518 | 2024-10-17 12:51:03 | misnames | 3 | 146162 | 171 | 37.220 | 3927.0 |
| 517 | 2024-10-16 18:47:35 | misnames | 3 | 146162 | 171 | 33.893 | 4312.5 |
| 516 | 2024-10-16 18:47:37 | misnames | 2 | 121059 | 15 | 18.423 | 6571.1 |
| 515 | 2024-10-16 18:47:13 | misnames | 1 | 82945 | 3 | 6.360 | 13041.7 |
| 514 | 2024-10-10 06:35:25 | misnames | 1 | 82945 | 3 | 4.596 | 18047.2 |
| 513 | 2024-09-29 05:59:07 | misnames | 1 | 82945 | 3 | 11.376 | 7291.2 |
| 512 | 2024-09-25 20:18:33 | misnames | 1 | 82945 | 3 | 10.406 | 7970.9 |
| 511 | 2024-09-05 02:43:03 | misnames | 1 | 82945 | 3 | 4.626 | 17930.2 |
| 510 | 2024-08-31 07:47:51 | misnames | 1 | 82945 | 3 | 3.046 | 27230.8 |
| 509 | 2024-08-29 11:33:40 | misnames | 1 | 82945 | 3 | 6.736 | 12313.7 |
| 508 | 2024-08-23 16:22:46 | misnames | 1 | 82945 | 3 | 13.750 | 6032.4 |
| 507 | 2024-08-02 02:22:24 | misnames | 3 | 146162 | 171 | 38.033 | 3843.0 |
| 506 | 2024-08-01 11:44:53 | misnames | 3 | 146162 | 171 | 19.190 | 7616.6 |
| 505 | 2024-08-01 03:07:31 | misnames | 1 | 82945 | 3 | 4.906 | 16906.8 |
| 504 | 2024-08-01 03:01:26 | misnames | 3 | 146162 | 171 | 32.376 | 4514.5 |
| 503 | 2024-07-30 11:30:45 | misnames | 3 | 146162 | 171 | 35.550 | 4111.4 |
| 502 | 2024-07-30 02:03:50 | misnames | 3 | 146162 | 171 | 20.580 | 7102.1 |
| 501 | 2024-07-30 02:03:47 | misnames | 2 | 121059 | 15 | 12.860 | 9413.6 |
| 500 | 2024-07-30 01:53:21 | misnames | 1 | 82945 | 3 | 2.530 | 32784.6 |
| 499 | 2024-07-26 17:56:14 | misnames | 1 | 82945 | 3 | 3.170 | 26165.6 |
| 498 | 2024-07-16 06:40:55 | misnames | 1 | 82945 | 3 | 5.046 | 16437.8 |
| 497 | 2024-07-06 10:58:05 | misnames | 1 | 82945 | 3 | 5.843 | 14195.6 |
| 496 | 2024-07-06 10:56:54 | misnames | 1 | 82945 | 3 | 5.783 | 14342.9 |
| 495 | 2024-07-01 21:20:19 | misnames | 1 | 82945 | 3 | 3.406 | 24352.6 |
| 494 | 2024-06-24 15:18:13 | misnames | 1 | 82945 | 3 | 2.716 | 30539.4 |
| 493 | 2024-06-06 01:16:46 | misnames | 1 | 82945 | 3 | 6.563 | 12638.3 |
| 492 | 2024-06-03 23:17:36 | misnames | 3 | 146162 | 171 | 9.906 | 14754.9 |
| 491 | 2024-06-02 01:47:07 | misnames | 2 | 121059 | 15 | 3.533 | 34265.2 |
| 490 | 2024-06-02 01:37:11 | misnames | 3 | 146162 | 171 | 7.033 | 20782.3 |
| 489 | 2024-05-31 15:24:21 | misnames | 3 | 146162 | 171 | 29.613 | 4935.7 |
| 488 | 2024-05-31 13:13:24 | misnames | 2 | 121059 | 15 | 3.483 | 34757.1 |
| 487 | 2024-05-30 23:12:27 | misnames | 2 | 121059 | 15 | 3.656 | 33112.4 |
| 486 | 2024-05-30 22:29:33 | misnames | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 485 | 2024-05-25 07:42:18 | misnames | 1 | 82945 | 3 | 3.280 | 25288.1 |
| 484 | 2024-05-02 04:34:45 | misnames | 1 | 82945 | 3 | 1.500 | 55296.7 |