History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"licensee"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 578 | 2025-12-22 13:08:05 | licensee | 4 | 161609 | 535 | 11.656 | 13864.9 |
| 577 | 2025-12-22 13:07:55 | licensee | 4 | 161609 | 535 | 11.436 | 14131.6 |
| 576 | 2025-12-22 03:25:12 | licensee | 4 | 161609 | 535 | 17.266 | 9360.0 |
| 575 | 2025-12-22 03:25:02 | licensee | 4 | 161609 | 535 | 20.863 | 7746.2 |
| 574 | 2025-12-21 20:53:05 | licensee | 1 | 82945 | 7 | 1.373 | 60411.5 |
| 573 | 2025-12-19 00:42:17 | licensee | 4 | 161609 | 535 | 20.953 | 7712.9 |
| 572 | 2025-12-18 14:00:36 | licensee | 1 | 82945 | 7 | 7.156 | 11591.0 |
| 571 | 2025-12-18 14:00:26 | licensee | 1 | 82945 | 7 | 7.376 | 11245.3 |
| 570 | 2025-12-18 00:55:53 | licensee | 4 | 161609 | 535 | 41.126 | 3929.6 |
| 569 | 2025-12-18 00:55:43 | licensee | 4 | 161609 | 535 | 20.596 | 7846.6 |
| 568 | 2025-12-16 16:30:39 | licensee | 1 | 82945 | 7 | 5.966 | 13903.0 |
| 567 | 2025-12-16 02:14:20 | licensee | 4 | 161609 | 535 | 22.173 | 7288.5 |
| 566 | 2025-12-15 13:18:41 | licensee | 1 | 82945 | 7 | 1.436 | 57761.1 |
| 565 | 2025-12-10 00:13:18 | licensee | 1 | 82945 | 7 | 1.373 | 60411.5 |
| 564 | 2025-12-09 10:03:47 | licensee | 4 | 161609 | 535 | 11.826 | 13665.6 |
| 563 | 2025-12-08 22:09:42 | licensee | 3 | 146162 | 63 | 7.686 | 19016.7 |
| 562 | 2025-12-08 07:42:45 | licensee | 3 | 146162 | 63 | 7.360 | 19859.0 |
| 561 | 2025-12-07 22:26:35 | licensee | 1 | 82945 | 7 | 2.906 | 28542.7 |
| 560 | 2025-12-05 05:11:02 | licensee | 1 | 82945 | 7 | 2.966 | 27965.3 |
| 559 | 2025-12-05 02:31:36 | licensee | 1 | 82945 | 7 | 1.393 | 59544.1 |
| 558 | 2025-12-02 20:05:52 | licensee | 1 | 82945 | 7 | 1.580 | 52496.8 |
| 557 | 2025-11-29 09:18:03 | licensee | 1 | 82945 | 7 | 1.440 | 57600.7 |
| 556 | 2025-11-22 18:12:46 | licensee | 1 | 82945 | 7 | 3.203 | 25896.0 |
| 555 | 2025-11-22 01:36:43 | licensee | 1 | 82945 | 7 | 6.796 | 12205.0 |
| 554 | 2025-11-21 22:00:37 | licensee | 4 | 161609 | 535 | 30.173 | 5356.1 |
| 553 | 2025-11-21 07:03:18 | licensee | 4 | 161609 | 535 | 12.516 | 12912.2 |
| 552 | 2025-11-18 19:35:17 | licensee | 4 | 161609 | 535 | 17.346 | 9316.8 |
| 551 | 2025-11-18 04:39:00 | licensee | 4 | 161609 | 535 | 13.076 | 12359.2 |
| 550 | 2025-11-16 16:33:28 | licensee | 3 | 146162 | 63 | 12.046 | 12133.7 |
| 549 | 2025-11-15 19:35:42 | licensee | 1 | 82945 | 7 | 2.376 | 34909.5 |
| 548 | 2025-11-15 01:43:55 | licensee | 3 | 146162 | 63 | 6.703 | 21805.5 |
| 547 | 2025-11-13 01:00:40 | licensee | 2 | 121059 | 16 | 3.780 | 32026.2 |
| 546 | 2025-11-10 20:38:20 | licensee | 1 | 82945 | 7 | 1.440 | 57600.7 |
| 545 | 2025-11-09 13:02:27 | licensee | 1 | 82945 | 7 | 1.470 | 56425.2 |
| 544 | 2025-11-06 12:31:57 | licensee | 4 | 161609 | 535 | 13.720 | 11779.1 |
| 543 | 2025-11-03 09:10:41 | licensee | 1 | 82945 | 7 | 1.280 | 64800.8 |
| 542 | 2025-11-02 19:26:35 | licensee | 3 | 146162 | 63 | 25.016 | 5842.7 |
| 541 | 2025-11-02 18:09:59 | licensee | 4 | 161609 | 535 | 11.203 | 14425.5 |
| 540 | 2025-11-01 18:13:03 | licensee | 3 | 146162 | 63 | 6.953 | 21021.4 |
| 539 | 2025-10-28 20:48:34 | licensee | 1 | 82945 | 7 | 1.436 | 57761.1 |
| 538 | 2025-10-28 19:03:54 | licensee | 1 | 82945 | 7 | 1.423 | 58288.8 |
| 537 | 2025-10-25 12:52:36 | licensee | 1 | 82945 | 7 | 1.360 | 60989.0 |
| 536 | 2025-10-24 12:49:10 | licensee | 1 | 82945 | 7 | 1.453 | 57085.3 |
| 535 | 2025-10-23 06:34:57 | licensee | 3 | 146162 | 63 | 29.596 | 4938.6 |
| 534 | 2025-10-23 06:34:55 | licensee | 3 | 146162 | 63 | 18.423 | 7933.7 |
| 533 | 2025-10-23 05:40:20 | licensee | 1 | 82945 | 7 | 6.563 | 12638.3 |
| 532 | 2025-10-23 05:40:09 | licensee | 1 | 82945 | 7 | 7.076 | 11722.0 |
| 531 | 2025-10-23 05:39:57 | licensee | 1 | 82945 | 7 | 6.610 | 12548.4 |
| 530 | 2025-10-23 05:39:46 | licensee | 1 | 82945 | 7 | 9.390 | 8833.3 |
| 529 | 2025-10-22 23:54:35 | licensee | 1 | 82945 | 7 | 6.703 | 12374.3 |
| 528 | 2025-10-22 20:34:34 | licensee | 4 | 161609 | 535 | 68.986 | 2342.6 |
| 527 | 2025-10-17 17:28:28 | licensee | 1 | 82945 | 7 | 1.280 | 64800.8 |
| 526 | 2025-10-16 21:28:38 | licensee | 4 | 161609 | 535 | 12.830 | 12596.2 |
| 525 | 2025-10-11 20:54:27 | licensee | 1 | 82945 | 7 | 1.376 | 60279.8 |
| 524 | 2025-10-11 11:37:16 | licensee | 1 | 82945 | 7 | 1.283 | 64649.3 |
| 523 | 2025-10-11 09:32:58 | licensee | 4 | 161609 | 535 | 12.110 | 13345.1 |
| 522 | 2025-10-04 18:49:45 | licensee | 4 | 161609 | 535 | 12.813 | 12612.9 |
| 521 | 2025-10-04 07:36:18 | licensee | 1 | 82945 | 7 | 1.423 | 58288.8 |
| 520 | 2025-09-28 17:39:05 | licensee | 1 | 82945 | 7 | 1.393 | 59544.1 |
| 519 | 2025-09-28 02:55:23 | licensee | 4 | 161609 | 535 | 15.410 | 10487.3 |
| 518 | 2025-09-26 22:23:54 | licensee | 1 | 82945 | 7 | 2.500 | 33178.0 |
| 517 | 2025-09-23 09:11:50 | licensee | 1 | 82945 | 7 | 1.470 | 56425.2 |
| 516 | 2025-09-23 07:29:24 | licensee | 4 | 161609 | 535 | 10.813 | 14945.8 |
| 515 | 2025-09-19 23:46:33 | licensee | 1 | 82945 | 7 | 1.580 | 52496.8 |
| 514 | 2025-09-19 08:07:15 | licensee | 1 | 82945 | 7 | 1.423 | 58288.8 |
| 513 | 2025-09-13 00:57:26 | licensee | 1 | 82945 | 7 | 1.326 | 62552.8 |
| 512 | 2025-09-06 19:16:57 | licensee | 1 | 82945 | 7 | 1.500 | 55296.7 |
| 511 | 2025-08-31 19:08:44 | licensee | 1 | 82945 | 7 | 1.466 | 56579.1 |
| 510 | 2025-08-26 12:07:17 | licensee | 4 | 161609 | 535 | 29.050 | 5563.1 |
| 509 | 2025-08-25 17:40:25 | licensee | 1 | 82945 | 7 | 3.576 | 23194.9 |
| 508 | 2025-08-25 11:13:25 | licensee | 4 | 161609 | 535 | 49.643 | 3255.4 |
| 507 | 2025-08-24 12:21:56 | licensee | 1 | 82945 | 7 | 6.203 | 13371.8 |
| 506 | 2025-08-21 17:10:52 | licensee | 4 | 161609 | 535 | 43.300 | 3732.3 |
| 505 | 2025-08-19 07:43:13 | licensee | 4 | 161609 | 535 | 33.656 | 4801.8 |
| 504 | 2025-08-18 03:28:38 | licensee | 1 | 82945 | 7 | 3.283 | 25265.0 |
| 503 | 2025-08-17 12:42:53 | licensee | 4 | 161609 | 535 | 37.420 | 4318.8 |
| 502 | 2025-08-16 06:25:38 | licensee | 4 | 161609 | 535 | 23.126 | 6988.2 |
| 501 | 2025-08-11 08:45:44 | licensee | 1 | 82945 | 7 | 1.503 | 55186.3 |
| 500 | 2025-08-04 00:05:09 | licensee | 1 | 82945 | 7 | 5.720 | 14500.9 |
| 499 | 2025-08-01 00:05:01 | licensee | 1 | 82945 | 7 | 8.956 | 9261.4 |
| 498 | 2025-07-28 22:56:53 | licensee | 1 | 82945 | 7 | 3.406 | 24352.6 |
| 497 | 2025-07-28 10:26:45 | licensee | 1 | 82945 | 7 | 7.066 | 11738.6 |
| 496 | 2025-07-26 22:52:59 | licensee | 4 | 161609 | 535 | 41.660 | 3879.2 |
| 495 | 2025-07-25 18:49:07 | licensee | 4 | 161609 | 535 | 13.000 | 12431.5 |
| 494 | 2025-07-24 19:06:45 | licensee | 1 | 82945 | 7 | 3.720 | 22297.0 |
| 493 | 2025-07-24 14:44:18 | licensee | 1 | 82945 | 7 | 7.906 | 10491.4 |
| 492 | 2025-07-24 07:24:08 | licensee | 4 | 161609 | 535 | 66.333 | 2436.3 |
| 491 | 2025-07-23 14:05:39 | licensee | 4 | 161609 | 535 | 67.706 | 2386.9 |
| 490 | 2025-07-23 13:07:58 | licensee | 1 | 82945 | 7 | 5.420 | 15303.5 |
| 489 | 2025-07-22 15:57:30 | licensee | 1 | 82945 | 7 | 7.453 | 11129.1 |
| 488 | 2025-07-22 08:18:49 | licensee | 4 | 161609 | 535 | 11.236 | 14383.1 |
| 487 | 2025-07-20 17:58:33 | licensee | 1 | 82945 | 7 | 1.420 | 58412.0 |
| 486 | 2025-07-18 22:12:24 | licensee | 4 | 161609 | 535 | 33.233 | 4862.9 |
| 485 | 2025-07-18 12:18:36 | licensee | 4 | 161609 | 535 | 56.783 | 2846.1 |
| 484 | 2025-07-17 18:36:27 | licensee | 4 | 161609 | 535 | 38.833 | 4161.6 |
| 483 | 2025-07-16 22:40:03 | licensee | 1 | 82945 | 7 | 6.986 | 11873.0 |
| 482 | 2025-07-16 11:16:37 | licensee | 4 | 161609 | 535 | 15.326 | 10544.8 |
| 481 | 2025-07-13 18:45:12 | licensee | 1 | 82945 | 7 | 2.486 | 33364.8 |
| 480 | 2025-07-11 22:03:22 | licensee | 1 | 82945 | 7 | 6.750 | 12288.1 |
| 479 | 2025-07-10 21:03:05 | licensee | 1 | 82945 | 7 | 6.673 | 12429.9 |