History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prior"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 648 | 2024-04-04 19:45:19 | prior | 3 | 83667 | 1047 | 7.940 | 10537.4 |
| 647 | 2024-04-03 09:09:11 | prior | 3 | 83667 | 1047 | 10.126 | 8262.6 |
| 646 | 2024-04-03 08:00:53 | prior | 3 | 83667 | 1047 | 10.060 | 8316.8 |
| 645 | 2024-04-03 08:00:54 | prior | 2 | 53800 | 83 | 5.466 | 9842.7 |
| 644 | 2024-04-03 08:00:52 | prior | 1 | 28756 | 5 | 1.140 | 25224.6 |
| 643 | 2024-03-31 15:19:12 | prior | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 642 | 2024-03-29 21:10:27 | prior | 2 | 53800 | 83 | 2.343 | 22962.0 |
| 641 | 2024-03-29 21:10:01 | prior | 3 | 83667 | 1047 | 4.203 | 19906.5 |
| 640 | 2024-03-29 09:18:00 | prior | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 639 | 2024-03-25 21:20:05 | prior | 3 | 83667 | 1047 | 11.810 | 7084.4 |
| 638 | 2024-03-23 18:16:06 | prior | 3 | 83667 | 1047 | 6.686 | 12513.8 |
| 637 | 2024-03-04 09:42:18 | prior | 3 | 83667 | 1047 | 12.783 | 6545.2 |
| 636 | 2024-03-04 09:42:19 | prior | 2 | 53800 | 83 | 3.720 | 14462.4 |
| 635 | 2024-03-04 06:38:18 | prior | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 634 | 2024-03-01 13:12:20 | prior | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 633 | 2024-02-28 16:51:18 | prior | 1 | 28756 | 5 | 0.610 | 47141.0 |
| 632 | 2024-02-28 11:48:32 | prior | 2 | 53800 | 83 | 3.030 | 17755.8 |
| 631 | 2024-02-28 11:48:09 | prior | 3 | 83667 | 1047 | 4.406 | 18989.3 |
| 630 | 2024-02-28 07:22:02 | prior | 3 | 83667 | 1047 | 13.470 | 6211.4 |
| 629 | 2024-02-28 07:22:01 | prior | 2 | 53800 | 83 | 2.810 | 19145.9 |
| 628 | 2024-02-28 07:12:09 | prior | 3 | 83667 | 1047 | 6.280 | 13322.8 |
| 627 | 2024-02-28 07:12:09 | prior | 2 | 53800 | 83 | 1.860 | 28924.7 |
| 626 | 2024-02-28 07:12:01 | prior | 1 | 28756 | 5 | 1.033 | 27837.4 |
| 625 | 2024-02-03 04:17:07 | prior | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 624 | 2024-01-31 00:32:47 | prior | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 623 | 2024-01-29 08:11:31 | prior | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 622 | 2024-01-29 03:24:37 | prior | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 621 | 2024-01-18 13:52:12 | prior | 3 | 83667 | 1047 | 4.076 | 20526.7 |
| 620 | 2023-12-30 04:50:04 | prior | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 619 | 2023-12-28 01:29:22 | prior | 3 | 83667 | 1047 | 3.296 | 25384.4 |
| 618 | 2023-12-23 02:16:59 | prior | 3 | 83667 | 1047 | 3.530 | 23701.7 |
| 617 | 2023-12-23 02:16:57 | prior | 2 | 53800 | 83 | 1.373 | 39184.3 |
| 616 | 2023-11-25 00:57:38 | prior | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 615 | 2023-11-21 10:43:32 | prior | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 614 | 2023-11-19 03:27:18 | prior | 3 | 83667 | 1047 | 3.423 | 24442.6 |
| 613 | 2023-11-19 03:27:15 | prior | 2 | 53800 | 83 | 1.406 | 38264.6 |
| 612 | 2023-11-18 22:26:57 | prior | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 611 | 2023-11-15 14:59:06 | prior | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 610 | 2023-11-12 08:04:28 | prior | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 609 | 2023-11-03 13:22:20 | prior | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 608 | 2023-10-24 21:45:32 | prior | 1 | 28756 | 5 | 0.890 | 32310.1 |
| 607 | 2023-10-21 14:00:06 | prior | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 606 | 2023-10-15 04:33:24 | prior | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 605 | 2023-10-05 21:30:46 | prior | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 604 | 2023-10-03 20:23:20 | prior | 3 | 83667 | 1047 | 5.783 | 14467.8 |
| 603 | 2023-10-01 13:35:25 | prior | 3 | 83667 | 1047 | 3.550 | 23568.2 |
| 602 | 2023-10-01 05:22:42 | prior | 3 | 83667 | 1047 | 5.373 | 15571.7 |
| 601 | 2023-09-28 04:39:09 | prior | 3 | 83667 | 1047 | 4.423 | 18916.3 |
| 600 | 2023-09-24 11:42:39 | prior | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 599 | 2023-09-22 19:47:39 | prior | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 598 | 2023-09-20 21:25:15 | prior | 3 | 83667 | 1047 | 3.343 | 25027.5 |
| 597 | 2023-09-10 14:26:34 | prior | 1 | 28756 | 5 | 0.983 | 29253.3 |
| 596 | 2023-08-23 09:10:27 | prior | 3 | 83667 | 1047 | 3.360 | 24900.9 |
| 595 | 2023-07-25 12:41:15 | prior | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 594 | 2023-07-13 09:25:19 | prior | 3 | 83667 | 1047 | 3.326 | 25155.4 |
| 593 | 2023-07-04 23:45:29 | prior | 3 | 83667 | 1047 | 3.390 | 24680.5 |
| 592 | 2023-07-02 23:21:50 | prior | 3 | 83667 | 1047 | 3.296 | 25384.4 |
| 591 | 2023-07-01 22:07:50 | prior | 3 | 83667 | 1047 | 3.360 | 24900.9 |
| 590 | 2023-06-30 23:37:20 | prior | 3 | 83667 | 1047 | 4.796 | 17445.2 |
| 589 | 2023-06-27 23:50:02 | prior | 3 | 83667 | 1047 | 3.826 | 21868.0 |
| 588 | 2023-06-24 23:12:52 | prior | 3 | 83667 | 1047 | 3.330 | 25125.2 |
| 587 | 2023-06-22 22:45:05 | prior | 3 | 83667 | 1047 | 3.813 | 21942.6 |
| 586 | 2023-06-21 23:02:03 | prior | 3 | 83667 | 1047 | 3.326 | 25155.4 |
| 585 | 2023-06-21 00:06:08 | prior | 3 | 83667 | 1047 | 3.860 | 21675.4 |
| 584 | 2023-06-20 00:04:54 | prior | 3 | 83667 | 1047 | 3.313 | 25254.2 |
| 583 | 2023-06-19 16:21:52 | prior | 1 | 28756 | 5 | 0.456 | 63061.4 |
| 582 | 2023-06-18 23:10:44 | prior | 3 | 83667 | 1047 | 3.330 | 25125.2 |
| 581 | 2023-06-16 23:50:50 | prior | 3 | 83667 | 1047 | 4.050 | 20658.5 |
| 580 | 2023-04-06 09:21:38 | prior | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 579 | 2023-04-03 08:03:19 | prior | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 578 | 2023-03-30 08:34:38 | prior | 3 | 83667 | 1047 | 3.250 | 25743.7 |
| 577 | 2023-01-17 12:27:24 | prior | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 576 | 2022-12-27 23:49:39 | prior | 3 | 83667 | 1047 | 3.716 | 22515.3 |
| 575 | 2022-12-27 13:26:36 | prior | 3 | 83667 | 1047 | 3.280 | 25508.2 |
| 574 | 2022-12-24 17:12:35 | prior | 3 | 83667 | 1047 | 3.783 | 22116.6 |
| 573 | 2022-12-17 15:20:52 | prior | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 572 | 2022-12-10 06:37:10 | prior | 3 | 83667 | 1047 | 3.296 | 25384.4 |
| 571 | 2022-12-09 11:48:07 | prior | 3 | 83667 | 1047 | 7.906 | 10582.7 |
| 570 | 2022-12-09 00:41:22 | prior | 3 | 83667 | 1047 | 3.266 | 25617.6 |
| 569 | 2022-11-14 08:01:28 | prior | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 568 | 2022-11-01 04:56:51 | prior | 3 | 83667 | 1047 | 3.296 | 25384.4 |
| 567 | 2022-10-25 15:04:41 | prior | 3 | 83667 | 1047 | 3.326 | 25155.4 |
| 566 | 2022-10-24 01:38:01 | prior | 3 | 83667 | 1047 | 3.283 | 25484.9 |
| 565 | 2022-09-26 03:59:55 | prior | 3 | 83667 | 1047 | 3.296 | 25384.4 |
| 564 | 2022-08-31 18:23:52 | prior | 3 | 83667 | 1047 | 3.376 | 24782.9 |
| 563 | 2022-08-17 10:37:05 | prior | 1 | 28756 | 5 | 1.076 | 26724.9 |
| 562 | 2022-08-15 19:35:08 | prior | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 561 | 2022-07-29 13:24:50 | prior | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 560 | 2022-07-05 00:29:22 | prior | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 559 | 2022-06-24 19:39:13 | prior | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 558 | 2022-05-24 14:39:45 | prior | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 557 | 2022-05-18 16:06:19 | prior | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 556 | 2022-04-24 05:32:58 | prior | 1 | 28756 | 5 | 0.450 | 63902.2 |
| 555 | 2022-04-13 10:32:23 | prior | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 554 | 2022-03-07 15:20:05 | prior | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 553 | 2021-12-22 14:09:29 | prior | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 552 | 2021-12-20 04:53:16 | prior | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 551 | 2021-12-18 04:06:06 | prior | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 550 | 2021-11-12 07:55:25 | prior | 1 | 28756 | 5 | 1.046 | 27491.4 |
| 549 | 2021-10-25 04:19:45 | prior | 1 | 28756 | 5 | 0.516 | 55728.7 |