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 |
| 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 |
| 559 | 2024-04-06 01:37:01 | permits | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 558 | 2024-03-29 05:44:06 | permits | 1 | 69583 | 3 | 3.406 | 20429.5 |
| 557 | 2024-03-29 01:17:48 | permits | 1 | 69583 | 3 | 3.330 | 20895.8 |
| 556 | 2024-03-13 18:05:05 | permits | 1 | 69583 | 3 | 3.923 | 17737.2 |
| 555 | 2024-02-27 21:46:11 | permits | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 554 | 2024-02-22 04:20:08 | permits | 2 | 107671 | 37 | 3.453 | 31181.9 |
| 553 | 2024-02-12 13:33:59 | permits | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 552 | 2024-01-17 07:22:24 | permits | 3 | 134027 | 447 | 6.893 | 19443.9 |
| 551 | 2024-01-17 02:37:29 | permits | 2 | 107671 | 37 | 3.796 | 28364.3 |
| 550 | 2024-01-07 18:45:10 | permits | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 549 | 2023-12-25 23:28:05 | permits | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 548 | 2023-12-20 20:25:48 | permits | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 547 | 2023-11-24 21:06:27 | permits | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 546 | 2023-11-19 00:52:43 | permits | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 545 | 2023-11-17 17:53:15 | permits | 2 | 107671 | 37 | 2.890 | 37256.4 |
| 544 | 2023-11-06 12:18:22 | permits | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 543 | 2023-10-09 02:45:47 | permits | 3 | 134027 | 447 | 5.923 | 22628.2 |
| 542 | 2023-10-07 08:04:05 | permits | 1 | 69583 | 3 | 1.080 | 64428.7 |