History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"permits"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 659 | 2025-07-01 20:12:15 | permits | 1 | 69583 | 3 | 3.360 | 20709.2 |
| 658 | 2025-06-20 13:10:08 | permits | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 657 | 2025-06-16 04:17:41 | permits | 1 | 69583 | 3 | 2.983 | 23326.5 |
| 656 | 2025-06-15 21:27:13 | permits | 1 | 69583 | 3 | 5.123 | 13582.5 |
| 655 | 2025-06-09 16:04:51 | permits | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 654 | 2025-05-30 20:02:50 | permits | 1 | 69583 | 3 | 6.283 | 11074.8 |
| 653 | 2025-05-29 02:07:32 | permits | 1 | 69583 | 3 | 5.970 | 11655.4 |
| 652 | 2025-05-24 03:05:05 | permits | 1 | 69583 | 3 | 4.750 | 14649.1 |
| 651 | 2025-05-22 03:55:25 | permits | 1 | 69583 | 3 | 3.313 | 21003.0 |
| 650 | 2025-05-21 18:39:08 | permits | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 649 | 2025-05-20 15:17:56 | permits | 1 | 69583 | 3 | 9.063 | 7677.7 |
| 648 | 2025-05-15 21:43:05 | permits | 1 | 69583 | 3 | 2.343 | 29698.3 |
| 647 | 2025-05-06 04:12:41 | permits | 1 | 69583 | 3 | 6.516 | 10678.8 |
| 646 | 2025-04-29 20:03:01 | permits | 1 | 69583 | 3 | 4.186 | 16622.8 |
| 645 | 2025-04-28 02:31:09 | permits | 1 | 69583 | 3 | 7.826 | 8891.3 |
| 644 | 2025-04-27 02:01:32 | permits | 3 | 134027 | 447 | 11.970 | 11196.9 |
| 643 | 2025-04-23 03:40:55 | permits | 2 | 107671 | 37 | 14.140 | 7614.6 |
| 642 | 2025-04-23 02:46:43 | permits | 1 | 69583 | 3 | 4.440 | 15671.8 |
| 641 | 2025-04-21 21:25:22 | permits | 3 | 134027 | 447 | 7.610 | 17612.0 |
| 640 | 2025-04-21 12:08:31 | permits | 3 | 134027 | 447 | 50.896 | 2633.4 |
| 639 | 2025-04-21 07:01:24 | permits | 3 | 134027 | 447 | 36.770 | 3645.0 |
| 638 | 2025-04-20 13:26:43 | permits | 1 | 69583 | 3 | 1.516 | 45899.1 |
| 637 | 2025-04-20 12:24:57 | permits | 3 | 134027 | 447 | 8.703 | 15400.1 |
| 636 | 2025-04-16 23:38:52 | permits | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 635 | 2025-04-16 02:41:28 | permits | 1 | 69583 | 3 | 6.530 | 10655.9 |
| 634 | 2025-04-15 20:28:22 | permits | 1 | 69583 | 3 | 6.533 | 10651.0 |
| 633 | 2025-04-07 21:40:14 | permits | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 632 | 2025-04-07 03:02:00 | permits | 1 | 69583 | 3 | 5.970 | 11655.4 |
| 631 | 2025-03-29 14:49:37 | permits | 3 | 134027 | 447 | 38.783 | 3455.8 |
| 630 | 2025-03-28 21:21:59 | permits | 1 | 69583 | 3 | 5.596 | 12434.4 |
| 629 | 2025-03-28 03:52:05 | permits | 1 | 69583 | 3 | 8.813 | 7895.5 |
| 628 | 2025-03-23 04:23:57 | permits | 1 | 69583 | 3 | 6.796 | 10238.8 |
| 627 | 2025-03-22 11:03:11 | permits | 2 | 107671 | 37 | 19.300 | 5578.8 |
| 626 | 2025-03-22 05:14:21 | permits | 2 | 107671 | 37 | 3.546 | 30364.1 |
| 625 | 2025-03-20 18:30:40 | permits | 2 | 107671 | 37 | 11.830 | 9101.5 |
| 624 | 2025-03-19 14:56:59 | permits | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 623 | 2025-03-16 11:45:00 | permits | 1 | 69583 | 3 | 6.546 | 10629.9 |
| 622 | 2025-03-15 18:20:07 | permits | 3 | 134027 | 447 | 48.393 | 2769.6 |
| 621 | 2025-03-15 16:06:37 | permits | 3 | 134027 | 447 | 36.766 | 3645.4 |
| 620 | 2025-03-15 10:35:34 | permits | 3 | 134027 | 447 | 35.283 | 3798.6 |
| 619 | 2025-03-15 03:33:42 | permits | 3 | 134027 | 447 | 21.423 | 6256.2 |
| 618 | 2025-03-15 03:00:16 | permits | 3 | 134027 | 447 | 28.720 | 4666.7 |
| 617 | 2025-03-14 13:27:10 | permits | 3 | 134027 | 447 | 6.766 | 19808.9 |
| 616 | 2025-03-14 04:30:36 | permits | 1 | 69583 | 3 | 7.436 | 9357.6 |
| 615 | 2025-03-13 08:02:15 | permits | 1 | 69583 | 3 | 3.063 | 22717.3 |
| 614 | 2025-02-25 13:03:09 | permits | 1 | 69583 | 3 | 3.236 | 21502.8 |
| 613 | 2025-02-25 03:04:46 | permits | 1 | 69583 | 3 | 8.876 | 7839.5 |
| 612 | 2025-02-19 18:42:21 | permits | 1 | 69583 | 3 | 5.346 | 13015.9 |
| 611 | 2025-02-05 07:09:45 | permits | 1 | 69583 | 3 | 3.703 | 18791.0 |
| 610 | 2025-01-29 06:15:56 | permits | 1 | 69583 | 3 | 6.516 | 10678.8 |
| 609 | 2025-01-28 10:52:05 | permits | 3 | 134027 | 447 | 23.673 | 5661.6 |
| 608 | 2025-01-28 10:18:16 | permits | 3 | 134027 | 447 | 9.640 | 13903.2 |
| 607 | 2025-01-28 09:58:58 | permits | 3 | 134027 | 447 | 6.546 | 20474.6 |
| 606 | 2025-01-23 22:17:17 | permits | 1 | 69583 | 3 | 6.063 | 11476.7 |
| 605 | 2025-01-21 23:16:07 | permits | 1 | 69583 | 3 | 6.140 | 11332.7 |
| 604 | 2025-01-19 12:09:17 | permits | 1 | 69583 | 3 | 5.186 | 13417.5 |
| 603 | 2024-12-27 08:09:36 | permits | 1 | 69583 | 3 | 4.423 | 15732.1 |
| 602 | 2024-12-19 12:48:37 | permits | 1 | 69583 | 3 | 4.076 | 17071.4 |
| 601 | 2024-12-14 07:34:42 | permits | 3 | 134027 | 447 | 35.596 | 3765.2 |
| 600 | 2024-12-14 01:39:18 | permits | 3 | 134027 | 447 | 27.703 | 4838.0 |
| 599 | 2024-12-12 17:09:13 | permits | 3 | 134027 | 447 | 55.066 | 2433.9 |
| 598 | 2024-12-12 10:33:10 | permits | 1 | 69583 | 3 | 2.343 | 29698.3 |
| 597 | 2024-12-12 02:03:02 | permits | 3 | 134027 | 447 | 22.190 | 6040.0 |
| 596 | 2024-12-12 02:03:03 | permits | 2 | 107671 | 37 | 10.313 | 10440.3 |
| 595 | 2024-12-12 02:02:31 | permits | 1 | 69583 | 3 | 3.453 | 20151.5 |
| 594 | 2024-11-18 04:08:27 | permits | 1 | 69583 | 3 | 6.173 | 11272.2 |
| 593 | 2024-11-16 05:04:23 | permits | 1 | 69583 | 3 | 2.923 | 23805.3 |
| 592 | 2024-11-09 12:50:49 | permits | 1 | 69583 | 3 | 3.283 | 21194.9 |
| 591 | 2024-10-20 06:14:35 | permits | 1 | 69583 | 3 | 6.000 | 11597.2 |
| 590 | 2024-10-18 04:48:38 | permits | 1 | 69583 | 3 | 5.720 | 12164.9 |
| 589 | 2024-10-14 01:35:50 | permits | 1 | 69583 | 3 | 5.860 | 11874.2 |
| 588 | 2024-09-21 16:25:29 | permits | 1 | 69583 | 3 | 8.533 | 8154.6 |
| 587 | 2024-09-09 23:08:40 | permits | 1 | 69583 | 3 | 9.313 | 7471.6 |
| 586 | 2024-09-05 11:13:29 | permits | 1 | 69583 | 3 | 5.750 | 12101.4 |
| 585 | 2024-09-03 03:26:11 | permits | 1 | 69583 | 3 | 14.050 | 4952.5 |
| 584 | 2024-09-03 03:23:33 | permits | 1 | 69583 | 3 | 9.016 | 7717.7 |
| 583 | 2024-08-27 16:17:17 | permits | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 582 | 2024-08-27 01:54:43 | permits | 1 | 69583 | 3 | 4.703 | 14795.4 |
| 581 | 2024-08-20 03:32:46 | permits | 1 | 69583 | 3 | 14.596 | 4767.3 |
| 580 | 2024-08-14 05:53:03 | permits | 1 | 69583 | 3 | 12.593 | 5525.5 |
| 579 | 2024-08-10 08:18:31 | permits | 1 | 69583 | 3 | 2.400 | 28992.9 |
| 578 | 2024-08-04 03:10:27 | permits | 1 | 69583 | 3 | 4.250 | 16372.5 |
| 577 | 2024-08-02 12:12:37 | permits | 1 | 69583 | 3 | 3.406 | 20429.5 |
| 576 | 2024-07-30 01:02:36 | permits | 1 | 69583 | 3 | 1.953 | 35628.8 |
| 575 | 2024-07-26 21:53:49 | permits | 2 | 107671 | 37 | 15.940 | 6754.8 |
| 574 | 2024-07-18 20:29:01 | permits | 1 | 69583 | 3 | 4.000 | 17395.8 |
| 573 | 2024-07-14 08:38:26 | permits | 1 | 69583 | 3 | 4.000 | 17395.8 |
| 572 | 2024-07-09 22:59:29 | permits | 1 | 69583 | 3 | 2.716 | 25619.7 |
| 571 | 2024-07-06 20:00:29 | permits | 1 | 69583 | 3 | 4.486 | 15511.1 |
| 570 | 2024-07-06 19:48:13 | permits | 1 | 69583 | 3 | 2.970 | 23428.6 |
| 569 | 2024-06-30 06:03:20 | permits | 1 | 69583 | 3 | 4.813 | 14457.3 |
| 568 | 2024-06-22 23:37:59 | permits | 1 | 69583 | 3 | 2.593 | 26834.9 |
| 567 | 2024-06-15 18:21:02 | permits | 1 | 69583 | 3 | 4.046 | 17198.0 |
| 566 | 2024-05-19 23:22:51 | permits | 1 | 69583 | 3 | 1.436 | 48456.1 |
| 565 | 2024-05-15 02:18:38 | permits | 1 | 69583 | 3 | 1.420 | 49002.1 |
| 564 | 2024-05-12 18:09:42 | permits | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 563 | 2024-05-11 09:41:17 | permits | 1 | 69583 | 3 | 1.593 | 43680.5 |
| 562 | 2024-05-08 01:18:45 | permits | 1 | 69583 | 3 | 1.873 | 37150.6 |
| 561 | 2024-04-28 05:59:24 | permits | 1 | 69583 | 3 | 4.170 | 16686.6 |
| 560 | 2024-04-27 22:57:16 | permits | 1 | 69583 | 3 | 3.813 | 18248.9 |