History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"invoice"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 591 | 2025-06-10 00:09:45 | invoice | 3 | 134027 | 89 | 26.346 | 5087.2 |
| 590 | 2025-06-08 05:40:35 | invoice | 3 | 134027 | 89 | 32.313 | 4147.8 |
| 589 | 2025-06-05 10:36:53 | invoice | 2 | 107671 | 13 | 17.203 | 6258.9 |
| 588 | 2025-06-04 06:56:09 | invoice | 1 | 69583 | 4 | 4.390 | 15850.3 |
| 587 | 2025-06-02 08:04:20 | invoice | 1 | 69583 | 4 | 4.843 | 14367.7 |
| 586 | 2025-05-31 16:23:48 | invoice | 1 | 69583 | 4 | 6.063 | 11476.7 |
| 585 | 2025-05-28 20:22:33 | invoice | 3 | 134027 | 89 | 13.283 | 10090.1 |
| 584 | 2025-05-24 03:31:08 | invoice | 3 | 134027 | 89 | 35.136 | 3814.5 |
| 583 | 2025-05-24 03:06:40 | invoice | 1 | 69583 | 4 | 4.796 | 14508.5 |
| 582 | 2025-05-24 01:30:11 | invoice | 3 | 134027 | 89 | 27.296 | 4910.1 |
| 581 | 2025-05-23 21:45:18 | invoice | 3 | 134027 | 89 | 33.206 | 4036.2 |
| 580 | 2025-05-22 14:26:41 | invoice | 3 | 134027 | 89 | 49.176 | 2725.5 |
| 579 | 2025-05-17 03:03:22 | invoice | 2 | 107671 | 13 | 5.093 | 21141.0 |
| 578 | 2025-05-16 00:48:53 | invoice | 2 | 107671 | 13 | 9.596 | 11220.4 |
| 577 | 2025-05-15 23:15:52 | invoice | 3 | 134027 | 89 | 34.283 | 3909.4 |
| 576 | 2025-05-15 04:45:58 | invoice | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 575 | 2025-05-14 17:15:12 | invoice | 3 | 134027 | 89 | 19.263 | 6957.7 |
| 574 | 2025-05-14 14:13:36 | invoice | 2 | 107671 | 13 | 24.080 | 4471.4 |
| 573 | 2025-05-08 05:13:17 | invoice | 1 | 69583 | 4 | 6.190 | 11241.2 |
| 572 | 2025-05-08 04:58:15 | invoice | 1 | 69583 | 4 | 6.626 | 10501.5 |
| 571 | 2025-05-03 07:14:14 | invoice | 1 | 69583 | 4 | 1.813 | 38380.0 |
| 570 | 2025-05-02 06:12:32 | invoice | 1 | 69583 | 4 | 4.233 | 16438.2 |
| 569 | 2025-04-23 02:56:35 | invoice | 3 | 134027 | 89 | 35.203 | 3807.3 |
| 568 | 2025-04-23 01:16:40 | invoice | 1 | 69583 | 4 | 8.873 | 7842.1 |
| 567 | 2025-04-23 00:43:17 | invoice | 3 | 134027 | 89 | 48.456 | 2766.0 |
| 566 | 2025-04-21 22:08:40 | invoice | 3 | 134027 | 89 | 12.610 | 10628.6 |
| 565 | 2025-04-18 02:16:27 | invoice | 1 | 69583 | 4 | 5.610 | 12403.4 |
| 564 | 2025-04-16 08:13:22 | invoice | 1 | 69583 | 4 | 3.626 | 19190.0 |
| 563 | 2025-04-09 16:41:02 | invoice | 3 | 134027 | 89 | 27.876 | 4808.0 |
| 562 | 2025-04-09 15:05:21 | invoice | 3 | 134027 | 89 | 34.033 | 3938.1 |
| 561 | 2025-04-08 03:28:42 | invoice | 1 | 69583 | 4 | 2.593 | 26834.9 |
| 560 | 2025-04-01 12:31:04 | invoice | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 559 | 2025-03-31 07:56:18 | invoice | 1 | 69583 | 4 | 4.970 | 14000.6 |
| 558 | 2025-03-31 05:09:09 | invoice | 1 | 69583 | 4 | 5.766 | 12067.8 |
| 557 | 2025-03-24 22:09:55 | invoice | 3 | 134027 | 89 | 33.476 | 4003.7 |
| 556 | 2025-03-23 17:42:27 | invoice | 3 | 134027 | 89 | 34.346 | 3902.3 |
| 555 | 2025-03-23 02:07:22 | invoice | 3 | 134027 | 89 | 48.346 | 2772.2 |
| 554 | 2025-03-23 00:03:39 | invoice | 2 | 107671 | 13 | 14.813 | 7268.7 |
| 553 | 2025-03-22 01:38:04 | invoice | 1 | 69583 | 4 | 2.830 | 24587.6 |
| 552 | 2025-03-18 01:53:04 | invoice | 1 | 69583 | 4 | 5.516 | 12614.8 |
| 551 | 2025-03-15 20:12:02 | invoice | 1 | 69583 | 4 | 5.330 | 13055.0 |
| 550 | 2025-03-13 14:40:22 | invoice | 1 | 69583 | 4 | 5.500 | 12651.5 |
| 549 | 2025-02-28 11:39:22 | invoice | 1 | 69583 | 4 | 3.046 | 22844.1 |
| 548 | 2025-02-27 06:30:39 | invoice | 1 | 69583 | 4 | 5.656 | 12302.5 |
| 547 | 2025-02-21 13:27:51 | invoice | 1 | 69583 | 4 | 5.783 | 12032.3 |
| 546 | 2025-02-16 20:50:22 | invoice | 1 | 69583 | 4 | 4.313 | 16133.3 |
| 545 | 2025-02-07 12:32:37 | invoice | 1 | 69583 | 4 | 4.640 | 14996.3 |
| 544 | 2025-01-26 00:52:42 | invoice | 1 | 69583 | 4 | 3.000 | 23194.3 |
| 543 | 2024-12-26 07:59:08 | invoice | 1 | 69583 | 4 | 5.283 | 13171.1 |
| 542 | 2024-12-25 01:00:26 | invoice | 1 | 69583 | 4 | 6.856 | 10149.2 |
| 541 | 2024-12-07 17:51:00 | invoice | 1 | 69583 | 4 | 4.623 | 15051.5 |
| 540 | 2024-12-01 23:16:24 | invoice | 1 | 69583 | 4 | 5.576 | 12479.0 |
| 539 | 2024-11-25 00:05:10 | invoice | 1 | 69583 | 4 | 5.796 | 12005.3 |
| 538 | 2024-11-23 09:04:29 | invoice | 1 | 69583 | 4 | 8.376 | 8307.4 |
| 537 | 2024-11-06 17:09:09 | invoice | 1 | 69583 | 4 | 5.780 | 12038.6 |
| 536 | 2024-10-23 20:14:33 | invoice | 1 | 69583 | 4 | 11.056 | 6293.7 |
| 535 | 2024-10-22 03:53:20 | invoice | 1 | 69583 | 4 | 2.953 | 23563.5 |
| 534 | 2024-10-03 17:37:55 | invoice | 1 | 69583 | 4 | 7.013 | 9922.0 |
| 533 | 2024-09-21 17:37:07 | invoice | 1 | 69583 | 4 | 9.733 | 7149.2 |
| 532 | 2024-09-05 11:24:44 | invoice | 1 | 69583 | 4 | 4.686 | 14849.1 |
| 531 | 2024-08-19 10:52:07 | invoice | 1 | 69583 | 4 | 5.796 | 12005.3 |
| 530 | 2024-08-11 13:32:45 | invoice | 1 | 69583 | 4 | 3.956 | 17589.2 |
| 529 | 2024-08-02 18:57:28 | invoice | 1 | 69583 | 4 | 6.063 | 11476.7 |
| 528 | 2024-08-01 21:56:30 | invoice | 1 | 69583 | 4 | 4.596 | 15139.9 |
| 527 | 2024-07-17 09:03:54 | invoice | 1 | 69583 | 4 | 4.360 | 15959.4 |
| 526 | 2024-07-12 07:52:11 | invoice | 1 | 69583 | 4 | 2.046 | 34009.3 |
| 525 | 2024-07-11 08:37:55 | invoice | 2 | 107671 | 13 | 13.436 | 8013.6 |
| 524 | 2024-07-11 08:37:40 | invoice | 1 | 69583 | 4 | 4.063 | 17126.0 |
| 523 | 2024-07-10 19:33:07 | invoice | 4 | 151207 | 927 | 47.316 | 3195.7 |
| 522 | 2024-07-10 17:10:09 | invoice | 4 | 151207 | 927 | 39.330 | 3844.6 |
| 521 | 2024-07-10 08:57:33 | invoice | 4 | 151207 | 927 | 34.423 | 4392.6 |
| 520 | 2024-07-10 08:40:38 | invoice | 4 | 151207 | 927 | 48.406 | 3123.7 |
| 519 | 2024-07-10 08:25:02 | invoice | 4 | 151207 | 927 | 43.096 | 3508.6 |
| 518 | 2024-07-05 14:00:43 | invoice | 4 | 151207 | 927 | 56.096 | 2695.5 |
| 517 | 2024-07-05 13:50:41 | invoice | 1 | 69583 | 4 | 5.500 | 12651.5 |
| 516 | 2024-07-05 13:43:13 | invoice | 1 | 69583 | 4 | 4.280 | 16257.7 |
| 515 | 2024-07-02 23:43:13 | invoice | 3 | 134027 | 89 | 12.670 | 10578.3 |
| 514 | 2024-07-02 06:55:35 | invoice | 1 | 69583 | 4 | 4.000 | 17395.8 |
| 513 | 2024-07-02 06:53:17 | invoice | 1 | 69583 | 4 | 3.093 | 22496.9 |
| 512 | 2024-07-01 17:37:24 | invoice | 1 | 69583 | 4 | 2.123 | 32775.8 |
| 511 | 2024-06-29 12:40:56 | invoice | 3 | 134027 | 89 | 32.130 | 4171.4 |
| 510 | 2024-06-29 00:23:40 | invoice | 3 | 134027 | 89 | 29.906 | 4481.6 |
| 509 | 2024-06-28 15:15:12 | invoice | 3 | 134027 | 89 | 33.813 | 3963.8 |
| 508 | 2024-06-27 09:48:09 | invoice | 3 | 134027 | 89 | 36.983 | 3624.0 |
| 507 | 2024-06-27 09:48:08 | invoice | 2 | 107671 | 13 | 11.830 | 9101.5 |
| 506 | 2024-06-27 09:47:07 | invoice | 1 | 69583 | 4 | 7.470 | 9315.0 |
| 505 | 2024-06-27 07:01:09 | invoice | 1 | 69583 | 4 | 4.626 | 15041.7 |
| 504 | 2024-06-20 16:07:23 | invoice | 1 | 69583 | 4 | 3.296 | 21111.3 |
| 503 | 2024-06-20 00:54:28 | invoice | 1 | 69583 | 4 | 4.140 | 16807.5 |
| 502 | 2024-06-12 12:34:44 | invoice | 4 | 151207 | 927 | 68.600 | 2204.2 |
| 501 | 2024-06-10 16:51:27 | invoice | 4 | 151207 | 927 | 47.020 | 3215.8 |
| 500 | 2024-06-10 12:07:55 | invoice | 4 | 151207 | 927 | 30.673 | 4929.6 |
| 499 | 2024-06-10 06:10:03 | invoice | 4 | 151207 | 927 | 34.423 | 4392.6 |
| 498 | 2024-06-10 03:57:07 | invoice | 4 | 151207 | 927 | 65.423 | 2311.2 |
| 497 | 2024-06-09 16:20:30 | invoice | 4 | 151207 | 927 | 49.486 | 3055.6 |
| 496 | 2024-06-09 11:09:48 | invoice | 4 | 151207 | 927 | 42.630 | 3547.0 |
| 495 | 2024-06-07 02:18:06 | invoice | 1 | 69583 | 4 | 4.013 | 17339.4 |
| 494 | 2024-05-29 16:09:03 | invoice | 1 | 69583 | 4 | 4.813 | 14457.3 |
| 493 | 2024-05-11 13:59:43 | invoice | 4 | 151207 | 927 | 18.266 | 8278.1 |
| 492 | 2024-05-11 10:33:17 | invoice | 4 | 151207 | 927 | 17.516 | 8632.5 |