History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"voucher"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 627 | 2024-05-04 03:19:59 | voucher | 1 | 69583 | 8 | 1.313 | 52995.4 |
| 626 | 2024-04-30 08:12:33 | voucher | 1 | 69583 | 8 | 1.703 | 40859.1 |
| 625 | 2024-04-27 03:56:09 | voucher | 1 | 69583 | 8 | 2.656 | 26198.4 |
| 624 | 2024-03-22 02:24:00 | voucher | 3 | 134027 | 324 | 7.580 | 17681.7 |
| 623 | 2024-03-22 02:24:00 | voucher | 2 | 107671 | 53 | 3.563 | 30219.2 |
| 622 | 2024-03-20 18:51:13 | voucher | 2 | 107671 | 53 | 7.190 | 14975.1 |
| 621 | 2024-03-20 18:19:31 | voucher | 3 | 134027 | 324 | 8.033 | 16684.6 |
| 620 | 2024-03-19 23:44:06 | voucher | 2 | 107671 | 53 | 3.530 | 30501.7 |
| 619 | 2024-03-19 23:43:23 | voucher | 1 | 69583 | 8 | 2.033 | 34226.8 |
| 618 | 2024-03-19 23:42:51 | voucher | 3 | 134027 | 324 | 7.406 | 18097.1 |
| 617 | 2024-03-19 16:17:44 | voucher | 3 | 134027 | 324 | 16.640 | 8054.5 |
| 616 | 2024-03-19 16:16:32 | voucher | 3 | 134027 | 324 | 30.376 | 4412.3 |
| 615 | 2024-03-03 23:56:04 | voucher | 1 | 69583 | 8 | 2.703 | 25742.9 |
| 614 | 2024-02-27 10:44:13 | voucher | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 613 | 2024-01-31 14:41:00 | voucher | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 612 | 2023-11-30 08:19:02 | voucher | 3 | 134027 | 324 | 6.110 | 21935.7 |
| 611 | 2023-11-25 01:40:47 | voucher | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 610 | 2023-11-22 01:41:03 | voucher | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 609 | 2023-11-20 07:23:37 | voucher | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 608 | 2023-11-19 18:04:40 | voucher | 3 | 134027 | 324 | 8.423 | 15912.0 |
| 607 | 2023-11-19 18:04:41 | voucher | 2 | 107671 | 53 | 5.390 | 19976.1 |
| 606 | 2023-11-08 19:02:38 | voucher | 1 | 69583 | 8 | 1.126 | 61796.6 |
| 605 | 2023-10-27 06:48:30 | voucher | 3 | 134027 | 324 | 11.483 | 11671.8 |
| 604 | 2023-10-25 16:44:38 | voucher | 3 | 134027 | 324 | 5.860 | 22871.5 |
| 603 | 2023-10-25 16:44:36 | voucher | 2 | 107671 | 53 | 2.890 | 37256.4 |
| 602 | 2023-10-19 19:06:29 | voucher | 1 | 69583 | 8 | 1.346 | 51696.1 |
| 601 | 2023-10-03 15:53:26 | voucher | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 600 | 2023-10-03 15:45:33 | voucher | 1 | 69583 | 8 | 1.030 | 67556.3 |
| 599 | 2023-09-24 22:04:56 | voucher | 1 | 69583 | 8 | 1.140 | 61037.7 |
| 598 | 2023-09-09 14:43:23 | voucher | 1 | 69583 | 8 | 1.016 | 68487.2 |
| 597 | 2023-08-28 22:37:27 | voucher | 3 | 134027 | 324 | 5.546 | 24166.4 |
| 596 | 2023-06-15 01:39:09 | voucher | 1 | 69583 | 8 | 1.283 | 54234.6 |
| 595 | 2023-05-31 07:33:39 | voucher | 1 | 69583 | 8 | 1.123 | 61961.7 |
| 594 | 2023-05-28 01:39:32 | voucher | 1 | 69583 | 8 | 1.016 | 68487.2 |
| 593 | 2023-05-14 22:01:58 | voucher | 3 | 134027 | 324 | 5.453 | 24578.6 |
| 592 | 2023-03-31 17:52:26 | voucher | 1 | 69583 | 8 | 1.173 | 59320.5 |
| 591 | 2023-02-21 02:34:46 | voucher | 3 | 134027 | 324 | 5.516 | 24297.9 |
| 590 | 2023-01-25 03:10:10 | voucher | 1 | 69583 | 8 | 1.016 | 68487.2 |
| 589 | 2023-01-13 16:31:20 | voucher | 1 | 69583 | 8 | 1.030 | 67556.3 |
| 588 | 2022-12-01 18:54:52 | voucher | 3 | 134027 | 324 | 5.483 | 24444.1 |
| 587 | 2022-10-30 03:52:55 | voucher | 1 | 69583 | 8 | 1.110 | 62687.4 |
| 586 | 2022-09-19 04:35:32 | voucher | 1 | 69583 | 8 | 1.050 | 66269.5 |
| 585 | 2022-09-04 04:32:57 | voucher | 3 | 134027 | 324 | 5.860 | 22871.5 |
| 584 | 2022-09-03 17:36:47 | voucher | 1 | 69583 | 8 | 1.200 | 57985.8 |
| 583 | 2022-08-22 08:59:20 | voucher | 3 | 134027 | 324 | 6.250 | 21444.3 |
| 582 | 2022-08-21 10:46:30 | voucher | 3 | 134027 | 324 | 6.283 | 21331.7 |
| 581 | 2022-08-06 19:15:12 | voucher | 3 | 134027 | 324 | 6.673 | 20085.0 |
| 580 | 2022-07-22 05:12:37 | voucher | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 579 | 2022-07-11 08:23:30 | voucher | 3 | 134027 | 324 | 5.516 | 24297.9 |
| 578 | 2022-07-03 10:55:42 | voucher | 2 | 107671 | 53 | 2.733 | 39396.6 |
| 577 | 2022-06-19 06:29:59 | voucher | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 576 | 2022-06-15 08:19:50 | voucher | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 575 | 2022-06-03 06:56:13 | voucher | 1 | 69583 | 8 | 1.016 | 68487.2 |
| 574 | 2022-05-02 16:13:51 | voucher | 1 | 69583 | 8 | 1.263 | 55093.4 |
| 573 | 2022-04-29 05:56:51 | voucher | 1 | 69583 | 8 | 1.140 | 61037.7 |
| 572 | 2022-03-13 21:07:19 | voucher | 1 | 69583 | 8 | 1.140 | 61037.7 |
| 571 | 2022-01-05 15:10:42 | voucher | 1 | 69583 | 8 | 2.500 | 27833.2 |
| 570 | 2021-12-08 03:59:28 | voucher | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 569 | 2021-11-14 12:56:39 | voucher | 1 | 69583 | 8 | 1.296 | 53690.6 |
| 568 | 2021-10-08 14:46:59 | voucher | 3 | 134027 | 324 | 6.296 | 21287.6 |
| 567 | 2021-10-04 07:25:45 | voucher | 1 | 69583 | 8 | 1.826 | 38106.8 |
| 566 | 2021-10-02 04:44:08 | voucher | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 565 | 2021-09-26 00:06:41 | voucher | 3 | 134027 | 324 | 6.860 | 19537.5 |
| 564 | 2021-09-25 15:36:20 | voucher | 3 | 134027 | 324 | 5.576 | 24036.4 |
| 563 | 2021-09-21 09:10:25 | voucher | 1 | 69583 | 8 | 1.030 | 67556.3 |
| 562 | 2021-09-20 13:31:26 | voucher | 3 | 134027 | 324 | 5.626 | 23822.8 |
| 561 | 2021-09-20 13:24:17 | voucher | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 560 | 2021-09-14 02:54:08 | voucher | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 559 | 2021-09-13 12:49:12 | voucher | 1 | 69583 | 8 | 1.106 | 62914.1 |
| 558 | 2021-09-12 23:11:52 | voucher | 1 | 69583 | 8 | 1.140 | 61037.7 |
| 557 | 2021-08-19 01:15:08 | voucher | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 556 | 2021-08-09 10:31:34 | voucher | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 555 | 2021-07-27 19:55:44 | voucher | 2 | 107671 | 53 | 6.140 | 17536.0 |
| 554 | 2021-07-18 01:42:29 | voucher | 1 | 69583 | 8 | 1.016 | 68487.2 |
| 553 | 2021-07-04 21:38:32 | voucher | 1 | 69583 | 8 | 1.170 | 59472.6 |
| 552 | 2021-06-25 15:45:50 | voucher | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 551 | 2021-05-18 20:32:30 | voucher | 2 | 107671 | 53 | 2.923 | 36835.8 |
| 550 | 2021-05-18 20:17:50 | voucher | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 549 | 2021-05-13 07:22:57 | voucher | 1 | 69583 | 8 | 1.030 | 67556.3 |
| 548 | 2021-05-07 05:48:52 | voucher | 1 | 69583 | 8 | 1.296 | 53690.6 |
| 547 | 2021-04-18 20:26:52 | voucher | 2 | 107671 | 53 | 3.296 | 32667.2 |
| 546 | 2021-03-21 15:21:05 | voucher | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 545 | 2021-02-13 16:57:48 | voucher | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 544 | 2021-01-31 06:23:37 | voucher | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 543 | 2021-01-31 06:01:07 | voucher | 2 | 107671 | 53 | 3.283 | 32796.5 |
| 542 | 2021-01-03 08:54:26 | voucher | 1 | 69583 | 8 | 1.030 | 67556.3 |
| 541 | 2020-09-20 04:25:54 | voucher | 1 | 69583 | 8 | 1.033 | 67360.1 |
| 540 | 2020-09-18 18:45:41 | voucher | 1 | 69583 | 8 | 1.060 | 65644.3 |
| 539 | 2020-09-14 05:21:59 | voucher | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 538 | 2020-08-13 17:16:50 | voucher | 1 | 69583 | 8 | 1.263 | 55093.4 |
| 537 | 2020-08-10 03:58:27 | voucher | 1 | 69583 | 8 | 1.050 | 66269.5 |
| 536 | 2020-07-31 12:17:54 | voucher | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 535 | 2020-07-18 03:01:06 | voucher | 1 | 69583 | 8 | 1.190 | 58473.1 |
| 534 | 2020-05-27 06:16:36 | voucher | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 533 | 2020-05-15 13:04:35 | voucher | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 532 | 2020-05-10 05:03:47 | voucher | 1 | 69583 | 8 | 1.143 | 60877.5 |
| 531 | 2020-05-06 05:03:48 | voucher | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 530 | 2020-05-02 05:09:58 | voucher | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 529 | 2020-04-28 11:42:43 | voucher | 1 | 69583 | 8 | 1.123 | 61961.7 |
| 528 | 2020-04-27 12:03:24 | voucher | 1 | 69583 | 8 | 1.203 | 57841.2 |