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 |
| 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 |
| 541 | 2023-10-06 20:06:30 | permits | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 540 | 2023-09-29 06:46:32 | permits | 1 | 69583 | 3 | 2.763 | 25183.9 |
| 539 | 2023-09-24 17:45:11 | permits | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 538 | 2023-08-23 10:43:17 | permits | 3 | 134027 | 447 | 6.093 | 21996.9 |
| 537 | 2023-08-18 21:50:27 | permits | 2 | 107671 | 37 | 2.906 | 37051.3 |
| 536 | 2023-08-17 23:57:18 | permits | 3 | 134027 | 447 | 7.330 | 18284.7 |
| 535 | 2023-08-05 01:27:06 | permits | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 534 | 2023-08-03 20:57:24 | permits | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 533 | 2023-04-30 16:39:35 | permits | 2 | 107671 | 37 | 2.923 | 36835.8 |
| 532 | 2023-04-29 09:42:24 | permits | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 531 | 2023-04-27 13:26:06 | permits | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 530 | 2023-02-25 15:31:22 | permits | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 529 | 2023-02-25 15:02:26 | permits | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 528 | 2023-02-19 04:15:24 | permits | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 527 | 2023-02-08 08:47:14 | permits | 2 | 107671 | 37 | 2.860 | 37647.2 |
| 526 | 2023-01-18 22:27:41 | permits | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 525 | 2023-01-01 18:59:48 | permits | 2 | 107671 | 37 | 3.360 | 32044.9 |
| 524 | 2022-12-29 02:10:54 | permits | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 523 | 2022-12-17 05:56:09 | permits | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 522 | 2022-11-28 08:21:27 | permits | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 521 | 2022-11-21 09:29:20 | permits | 2 | 107671 | 37 | 3.170 | 33965.6 |
| 520 | 2022-11-13 00:17:57 | permits | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 519 | 2022-10-01 05:44:47 | permits | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 518 | 2022-09-29 01:30:47 | permits | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 517 | 2022-08-24 18:05:13 | permits | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 516 | 2022-07-18 08:30:39 | permits | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 515 | 2022-06-07 00:13:00 | permits | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 514 | 2022-05-31 08:58:59 | permits | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 513 | 2022-05-11 08:51:35 | permits | 1 | 69583 | 3 | 1.686 | 41271.1 |
| 512 | 2022-04-30 06:54:36 | permits | 2 | 107671 | 37 | 2.936 | 36672.7 |
| 511 | 2022-04-27 10:56:10 | permits | 1 | 69583 | 3 | 1.593 | 43680.5 |
| 510 | 2022-04-14 03:13:06 | permits | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 509 | 2022-04-11 22:42:58 | permits | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 508 | 2022-02-23 15:30:36 | permits | 1 | 69583 | 3 | 1.593 | 43680.5 |
| 507 | 2022-02-22 22:53:32 | permits | 1 | 69583 | 3 | 2.560 | 27180.9 |
| 506 | 2022-01-13 18:18:30 | permits | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 505 | 2022-01-05 14:53:03 | permits | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 504 | 2022-01-04 09:00:32 | permits | 2 | 107671 | 37 | 2.983 | 36094.9 |
| 503 | 2021-11-12 04:43:09 | permits | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 502 | 2021-11-07 23:41:43 | permits | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 501 | 2021-11-05 23:22:57 | permits | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 500 | 2021-10-31 13:36:41 | permits | 2 | 107671 | 37 | 3.033 | 35499.8 |
| 499 | 2021-10-28 16:23:24 | permits | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 498 | 2021-10-10 07:25:12 | permits | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 497 | 2021-08-30 11:50:01 | permits | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 496 | 2021-08-21 00:55:47 | permits | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 495 | 2021-08-14 19:44:57 | permits | 3 | 134027 | 447 | 7.063 | 18975.9 |
| 494 | 2021-08-12 15:31:44 | permits | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 493 | 2021-08-07 04:40:43 | permits | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 492 | 2021-08-01 13:44:34 | permits | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 491 | 2021-07-13 21:27:36 | permits | 3 | 134027 | 447 | 6.020 | 22263.6 |
| 490 | 2021-06-25 09:34:20 | permits | 3 | 134027 | 447 | 5.986 | 22390.1 |
| 489 | 2021-06-22 19:51:32 | permits | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 488 | 2021-05-15 17:59:50 | permits | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 487 | 2021-05-11 22:26:38 | permits | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 486 | 2021-05-05 10:06:24 | permits | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 485 | 2021-04-27 06:21:01 | permits | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 484 | 2021-04-21 13:40:32 | permits | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 483 | 2021-04-15 08:23:21 | permits | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 482 | 2021-04-12 16:32:50 | permits | 3 | 134027 | 447 | 6.856 | 19548.9 |
| 481 | 2021-03-16 08:55:42 | permits | 3 | 134027 | 447 | 6.096 | 21986.1 |
| 480 | 2021-02-26 14:22:43 | permits | 3 | 134027 | 447 | 6.796 | 19721.5 |
| 479 | 2021-02-19 13:11:34 | permits | 3 | 134027 | 447 | 6.156 | 21771.8 |
| 478 | 2021-02-11 21:14:51 | permits | 1 | 69583 | 3 | 1.423 | 48898.8 |
| 477 | 2021-02-07 12:19:22 | permits | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 476 | 2021-01-28 10:38:34 | permits | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 475 | 2020-12-30 18:11:57 | permits | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 474 | 2020-12-21 08:19:22 | permits | 2 | 107671 | 37 | 3.326 | 32372.5 |
| 473 | 2020-12-01 11:18:09 | permits | 3 | 134027 | 447 | 6.796 | 19721.5 |
| 472 | 2020-11-11 14:58:23 | permits | 2 | 107671 | 37 | 3.843 | 28017.4 |
| 471 | 2020-11-05 17:36:14 | permits | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 470 | 2020-10-30 00:56:30 | permits | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 469 | 2020-10-27 16:40:11 | permits | 3 | 134027 | 447 | 7.846 | 17082.2 |
| 468 | 2020-10-20 04:24:16 | permits | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 467 | 2020-10-16 21:09:49 | permits | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 466 | 2020-10-16 08:02:34 | permits | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 465 | 2020-10-12 07:49:56 | permits | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 464 | 2020-08-16 17:22:20 | permits | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 463 | 2020-08-04 22:13:40 | permits | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 462 | 2020-08-01 16:38:48 | permits | 1 | 69583 | 3 | 1.126 | 61796.6 |