History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grantee"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 599 | 2024-04-27 10:25:23 | grantee | 1 | 69583 | 5 | 1.983 | 35089.8 |
| 598 | 2024-04-16 15:56:16 | grantee | 1 | 69583 | 5 | 1.436 | 48456.1 |
| 597 | 2024-04-01 05:50:22 | grantee | 2 | 107671 | 33 | 3.936 | 27355.4 |
| 596 | 2024-02-29 17:34:30 | grantee | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 595 | 2024-02-07 01:57:14 | grantee | 3 | 134027 | 347 | 14.110 | 9498.7 |
| 594 | 2024-01-27 19:04:55 | grantee | 3 | 134027 | 347 | 5.920 | 22639.7 |
| 593 | 2024-01-01 09:44:00 | grantee | 3 | 134027 | 347 | 7.046 | 19021.7 |
| 592 | 2023-12-31 17:18:25 | grantee | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 591 | 2023-12-30 13:47:50 | grantee | 2 | 107671 | 33 | 3.063 | 35152.1 |
| 590 | 2023-12-16 22:02:33 | grantee | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 589 | 2023-12-16 05:18:38 | grantee | 2 | 107671 | 33 | 3.343 | 32207.9 |
| 588 | 2023-12-13 21:08:37 | grantee | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 587 | 2023-12-06 11:51:51 | grantee | 2 | 107671 | 33 | 2.796 | 38508.9 |
| 586 | 2023-11-17 16:54:38 | grantee | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 585 | 2023-11-12 08:29:01 | grantee | 3 | 134027 | 347 | 7.280 | 18410.3 |
| 584 | 2023-11-12 04:43:48 | grantee | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 583 | 2023-11-11 17:05:06 | grantee | 3 | 134027 | 347 | 6.733 | 19906.0 |
| 582 | 2023-11-07 09:53:38 | grantee | 3 | 134027 | 347 | 19.643 | 6823.1 |
| 581 | 2023-11-07 09:53:22 | grantee | 3 | 134027 | 347 | 16.236 | 8254.9 |
| 580 | 2023-11-06 10:30:43 | grantee | 3 | 134027 | 347 | 7.250 | 18486.5 |
| 579 | 2023-11-06 07:39:03 | grantee | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 578 | 2023-10-20 14:50:56 | grantee | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 577 | 2023-10-14 19:01:09 | grantee | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 576 | 2023-10-01 23:07:38 | grantee | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 575 | 2023-10-01 06:19:53 | grantee | 3 | 134027 | 347 | 9.313 | 14391.4 |
| 574 | 2023-09-25 13:19:34 | grantee | 3 | 134027 | 347 | 6.516 | 20568.9 |
| 573 | 2023-09-20 17:22:20 | grantee | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 572 | 2023-09-11 03:34:28 | grantee | 2 | 107671 | 33 | 7.530 | 14298.9 |
| 571 | 2023-09-04 04:07:10 | grantee | 2 | 107671 | 33 | 3.420 | 31482.7 |
| 570 | 2023-08-26 21:15:56 | grantee | 3 | 134027 | 347 | 6.406 | 20922.1 |
| 569 | 2023-08-16 10:09:51 | grantee | 1 | 69583 | 5 | 1.436 | 48456.1 |
| 568 | 2023-08-11 19:00:14 | grantee | 3 | 134027 | 347 | 5.923 | 22628.2 |
| 567 | 2023-06-24 04:29:26 | grantee | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 566 | 2023-06-20 19:27:16 | grantee | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 565 | 2023-05-13 11:31:16 | grantee | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 564 | 2023-04-23 02:15:10 | grantee | 3 | 134027 | 347 | 5.690 | 23554.8 |
| 563 | 2023-03-09 16:35:07 | grantee | 1 | 69583 | 5 | 1.030 | 67556.3 |
| 562 | 2023-03-08 15:55:27 | grantee | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 561 | 2023-01-26 18:50:03 | grantee | 3 | 134027 | 347 | 5.796 | 23124.1 |
| 560 | 2023-01-22 02:52:51 | grantee | 2 | 107671 | 33 | 3.203 | 33615.7 |
| 559 | 2023-01-07 18:49:50 | grantee | 3 | 134027 | 347 | 5.906 | 22693.4 |
| 558 | 2022-12-30 08:13:54 | grantee | 3 | 134027 | 347 | 6.390 | 20974.5 |
| 557 | 2022-12-29 07:51:36 | grantee | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 556 | 2022-12-11 22:01:55 | grantee | 3 | 134027 | 347 | 6.716 | 19956.4 |
| 555 | 2022-12-10 15:22:58 | grantee | 3 | 134027 | 347 | 6.610 | 20276.4 |
| 554 | 2022-11-08 22:32:18 | grantee | 3 | 134027 | 347 | 5.906 | 22693.4 |
| 553 | 2022-11-06 03:19:31 | grantee | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 552 | 2022-11-03 00:44:48 | grantee | 2 | 107671 | 33 | 3.423 | 31455.2 |
| 551 | 2022-09-17 23:06:19 | grantee | 1 | 69583 | 5 | 1.033 | 67360.1 |
| 550 | 2022-09-16 01:32:08 | grantee | 3 | 134027 | 347 | 5.826 | 23005.0 |
| 549 | 2022-08-18 23:54:49 | grantee | 3 | 134027 | 347 | 6.003 | 22326.7 |
| 548 | 2022-08-12 22:49:39 | grantee | 3 | 134027 | 347 | 5.826 | 23005.0 |
| 547 | 2022-08-08 23:55:49 | grantee | 3 | 134027 | 347 | 6.440 | 20811.6 |
| 546 | 2022-08-06 23:22:21 | grantee | 3 | 134027 | 347 | 5.843 | 22938.0 |
| 545 | 2022-07-22 23:37:53 | grantee | 3 | 134027 | 347 | 5.830 | 22989.2 |
| 544 | 2022-07-19 23:59:26 | grantee | 3 | 134027 | 347 | 6.300 | 21274.1 |
| 543 | 2022-07-16 13:32:39 | grantee | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 542 | 2022-07-15 23:50:00 | grantee | 3 | 134027 | 347 | 5.843 | 22938.0 |
| 541 | 2022-07-12 04:49:41 | grantee | 3 | 134027 | 347 | 14.766 | 9076.7 |
| 540 | 2022-07-11 09:15:31 | grantee | 3 | 134027 | 347 | 7.376 | 18170.7 |
| 539 | 2022-07-10 15:30:59 | grantee | 3 | 134027 | 347 | 7.576 | 17691.0 |
| 538 | 2022-07-09 03:30:20 | grantee | 3 | 134027 | 347 | 14.626 | 9163.6 |
| 537 | 2022-07-08 08:32:37 | grantee | 3 | 134027 | 347 | 11.143 | 12027.9 |
| 536 | 2022-07-07 14:14:12 | grantee | 3 | 134027 | 347 | 6.923 | 19359.7 |
| 535 | 2022-07-06 05:50:06 | grantee | 3 | 134027 | 347 | 7.186 | 18651.1 |
| 534 | 2022-07-05 04:37:45 | grantee | 3 | 134027 | 347 | 6.733 | 19906.0 |
| 533 | 2022-07-04 15:07:20 | grantee | 3 | 134027 | 347 | 7.140 | 18771.3 |
| 532 | 2022-07-03 02:17:02 | grantee | 3 | 134027 | 347 | 7.673 | 17467.4 |
| 531 | 2022-07-02 03:22:20 | grantee | 3 | 134027 | 347 | 11.733 | 11423.1 |
| 530 | 2022-06-05 11:27:14 | grantee | 2 | 107671 | 33 | 2.843 | 37872.3 |
| 529 | 2022-05-16 10:46:23 | grantee | 3 | 134027 | 347 | 6.860 | 19537.5 |
| 528 | 2022-05-11 22:40:31 | grantee | 3 | 134027 | 347 | 6.420 | 20876.5 |
| 527 | 2022-04-29 21:01:11 | grantee | 3 | 134027 | 347 | 6.830 | 19623.3 |
| 526 | 2022-04-25 16:58:36 | grantee | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 525 | 2022-04-23 11:01:22 | grantee | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 524 | 2022-04-21 07:25:29 | grantee | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 523 | 2022-03-26 02:49:33 | grantee | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 522 | 2022-02-06 00:24:38 | grantee | 3 | 134027 | 347 | 7.923 | 16916.2 |
| 521 | 2022-02-05 00:06:43 | grantee | 3 | 134027 | 347 | 7.393 | 18128.9 |
| 520 | 2022-02-04 00:25:27 | grantee | 3 | 134027 | 347 | 7.690 | 17428.7 |
| 519 | 2022-02-03 00:17:37 | grantee | 3 | 134027 | 347 | 14.610 | 9173.6 |
| 518 | 2022-02-02 00:10:01 | grantee | 3 | 134027 | 347 | 7.046 | 19021.7 |
| 517 | 2022-02-01 00:22:50 | grantee | 3 | 134027 | 347 | 7.330 | 18284.7 |
| 516 | 2022-01-31 00:34:22 | grantee | 3 | 134027 | 347 | 6.736 | 19897.1 |
| 515 | 2022-01-30 00:19:55 | grantee | 3 | 134027 | 347 | 7.706 | 17392.6 |
| 514 | 2022-01-29 00:13:28 | grantee | 3 | 134027 | 347 | 7.063 | 18975.9 |
| 513 | 2022-01-25 21:47:03 | grantee | 3 | 134027 | 347 | 6.096 | 21986.1 |
| 512 | 2022-01-25 20:40:16 | grantee | 3 | 134027 | 347 | 6.780 | 19768.0 |
| 511 | 2022-01-23 15:25:20 | grantee | 3 | 134027 | 347 | 7.563 | 17721.4 |
| 510 | 2022-01-22 19:43:17 | grantee | 3 | 134027 | 347 | 6.170 | 21722.4 |
| 509 | 2022-01-17 00:17:19 | grantee | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 508 | 2022-01-14 20:13:44 | grantee | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 507 | 2022-01-09 09:11:47 | grantee | 3 | 134027 | 347 | 6.783 | 19759.3 |
| 506 | 2021-12-17 07:47:33 | grantee | 3 | 134027 | 347 | 7.016 | 19103.1 |
| 505 | 2021-12-08 18:33:05 | grantee | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 504 | 2021-11-24 04:21:21 | grantee | 3 | 134027 | 347 | 6.593 | 20328.7 |
| 503 | 2021-11-23 02:06:52 | grantee | 3 | 134027 | 347 | 8.186 | 16372.7 |
| 502 | 2021-11-19 15:05:27 | grantee | 3 | 134027 | 347 | 6.530 | 20524.8 |
| 501 | 2021-11-08 16:01:32 | grantee | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 500 | 2021-11-06 15:27:46 | grantee | 1 | 69583 | 5 | 1.250 | 55666.4 |