History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"vendor"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 562 | 2025-11-22 06:33:48 | vendor | 1 | 48755 | 3 | 2.983 | 16344.3 |
| 561 | 2025-11-21 02:45:27 | vendor | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 560 | 2025-11-20 22:19:49 | vendor | 1 | 48755 | 3 | 1.656 | 29441.4 |
| 559 | 2025-11-16 16:16:50 | vendor | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 558 | 2025-11-16 13:51:23 | vendor | 1 | 48755 | 3 | 2.466 | 19770.9 |
| 557 | 2025-11-16 08:50:56 | vendor | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 556 | 2025-11-14 02:13:09 | vendor | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 555 | 2025-11-10 20:09:31 | vendor | 1 | 48755 | 3 | 1.093 | 44606.6 |
| 554 | 2025-10-25 09:23:14 | vendor | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 553 | 2025-10-21 21:55:24 | vendor | 1 | 48755 | 3 | 2.016 | 24184.0 |
| 552 | 2025-10-17 04:34:35 | vendor | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 551 | 2025-10-16 14:04:37 | vendor | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 550 | 2025-10-16 09:49:18 | vendor | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 549 | 2025-10-11 18:28:36 | vendor | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 548 | 2025-10-10 21:36:05 | vendor | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 547 | 2025-10-07 18:25:10 | vendor | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 546 | 2025-09-30 17:27:32 | vendor | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 545 | 2025-09-17 05:26:49 | vendor | 3 | 112716 | 384 | 5.500 | 20493.8 |
| 544 | 2025-09-16 08:44:31 | vendor | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 543 | 2025-09-16 01:32:18 | vendor | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 542 | 2025-09-15 17:22:08 | vendor | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 541 | 2025-09-15 17:21:50 | vendor | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 540 | 2025-09-15 17:21:06 | vendor | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 539 | 2025-09-13 17:55:32 | vendor | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 538 | 2025-09-04 03:56:23 | vendor | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 537 | 2025-08-27 03:16:43 | vendor | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 536 | 2025-08-09 00:05:51 | vendor | 3 | 112716 | 384 | 22.000 | 5123.5 |
| 535 | 2025-08-07 13:25:46 | vendor | 3 | 112716 | 384 | 16.483 | 6838.3 |
| 534 | 2025-08-05 11:09:54 | vendor | 3 | 112716 | 384 | 20.873 | 5400.1 |
| 533 | 2025-08-05 00:19:35 | vendor | 2 | 82551 | 37 | 5.733 | 14399.3 |
| 532 | 2025-08-02 06:01:02 | vendor | 3 | 112716 | 384 | 12.893 | 8742.4 |
| 531 | 2025-08-01 11:25:37 | vendor | 1 | 48755 | 3 | 4.140 | 11776.6 |
| 530 | 2025-08-01 05:48:38 | vendor | 1 | 48755 | 3 | 2.440 | 19981.6 |
| 529 | 2025-07-31 18:23:01 | vendor | 3 | 112716 | 384 | 36.546 | 3084.2 |
| 528 | 2025-07-31 03:40:12 | vendor | 3 | 112716 | 384 | 7.013 | 16072.4 |
| 527 | 2025-07-29 04:48:11 | vendor | 3 | 112716 | 384 | 30.460 | 3700.5 |
| 526 | 2025-07-29 03:31:23 | vendor | 2 | 82551 | 37 | 6.376 | 12947.1 |
| 525 | 2025-07-26 08:56:40 | vendor | 3 | 112716 | 384 | 5.360 | 21029.1 |
| 524 | 2025-07-26 08:55:08 | vendor | 1 | 48755 | 3 | 1.440 | 33857.6 |
| 523 | 2025-07-24 13:02:38 | vendor | 1 | 48755 | 3 | 2.623 | 18587.5 |
| 522 | 2025-07-24 04:05:41 | vendor | 1 | 48755 | 3 | 3.890 | 12533.4 |
| 521 | 2025-07-23 09:08:22 | vendor | 1 | 48755 | 3 | 2.190 | 22262.6 |
| 520 | 2025-07-16 23:13:24 | vendor | 1 | 48755 | 3 | 3.796 | 12843.8 |
| 519 | 2025-07-15 07:43:42 | vendor | 2 | 82551 | 37 | 4.780 | 17270.1 |
| 518 | 2025-07-04 23:17:59 | vendor | 1 | 48755 | 3 | 5.873 | 8301.5 |
| 517 | 2025-07-03 01:25:36 | vendor | 3 | 112716 | 384 | 23.393 | 4818.4 |
| 516 | 2025-07-02 10:58:48 | vendor | 1 | 48755 | 3 | 4.140 | 11776.6 |
| 515 | 2025-07-02 05:03:25 | vendor | 1 | 48755 | 3 | 3.923 | 12428.0 |
| 514 | 2025-06-21 09:11:27 | vendor | 1 | 48755 | 3 | 2.703 | 18037.4 |
| 513 | 2025-06-16 03:36:57 | vendor | 1 | 48755 | 3 | 1.796 | 27146.4 |
| 512 | 2025-06-15 22:23:32 | vendor | 1 | 48755 | 3 | 4.123 | 11825.1 |
| 511 | 2025-06-11 10:39:26 | vendor | 3 | 112716 | 384 | 26.986 | 4176.8 |
| 510 | 2025-06-10 12:13:27 | vendor | 3 | 112716 | 384 | 18.186 | 6198.0 |
| 509 | 2025-06-09 22:49:55 | vendor | 3 | 112716 | 384 | 29.956 | 3762.7 |
| 508 | 2025-06-08 18:36:58 | vendor | 3 | 112716 | 384 | 25.986 | 4337.6 |
| 507 | 2025-06-08 14:01:18 | vendor | 3 | 112716 | 384 | 44.226 | 2548.6 |
| 506 | 2025-06-06 23:08:40 | vendor | 3 | 112716 | 384 | 25.550 | 4411.6 |
| 505 | 2025-06-05 11:01:34 | vendor | 2 | 82551 | 37 | 12.270 | 6727.9 |
| 504 | 2025-06-03 08:32:01 | vendor | 2 | 82551 | 37 | 2.233 | 36968.7 |
| 503 | 2025-06-02 10:12:08 | vendor | 1 | 48755 | 3 | 1.953 | 24964.2 |
| 502 | 2025-05-30 17:49:29 | vendor | 3 | 112716 | 384 | 5.530 | 20382.6 |
| 501 | 2025-05-29 21:13:20 | vendor | 3 | 112716 | 384 | 5.440 | 20719.9 |
| 500 | 2025-05-29 02:46:15 | vendor | 3 | 112716 | 384 | 40.206 | 2803.5 |
| 499 | 2025-05-28 06:05:28 | vendor | 3 | 112716 | 384 | 5.330 | 21147.5 |
| 498 | 2025-05-26 08:07:02 | vendor | 3 | 112716 | 384 | 27.250 | 4136.4 |
| 497 | 2025-05-25 03:50:36 | vendor | 1 | 48755 | 3 | 1.966 | 24799.1 |
| 496 | 2025-05-22 16:40:53 | vendor | 1 | 48755 | 3 | 6.033 | 8081.4 |
| 495 | 2025-05-22 11:03:46 | vendor | 1 | 48755 | 3 | 3.860 | 12630.8 |
| 494 | 2025-05-21 10:34:07 | vendor | 3 | 112716 | 384 | 14.886 | 7571.9 |
| 493 | 2025-05-20 09:05:14 | vendor | 1 | 48755 | 3 | 5.250 | 9286.7 |
| 492 | 2025-05-19 01:58:33 | vendor | 3 | 112716 | 384 | 4.643 | 24276.5 |
| 491 | 2025-05-15 23:04:51 | vendor | 1 | 48755 | 3 | 2.843 | 17149.1 |
| 490 | 2025-05-15 03:48:33 | vendor | 3 | 112716 | 384 | 5.250 | 21469.7 |
| 489 | 2025-05-14 04:33:46 | vendor | 3 | 112716 | 384 | 27.490 | 4100.3 |
| 488 | 2025-05-14 03:43:02 | vendor | 1 | 48755 | 3 | 3.843 | 12686.7 |
| 487 | 2025-05-11 18:59:06 | vendor | 1 | 48755 | 3 | 4.220 | 11553.3 |
| 486 | 2025-05-09 22:03:07 | vendor | 2 | 82551 | 37 | 12.470 | 6620.0 |
| 485 | 2025-05-09 16:28:03 | vendor | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 484 | 2025-05-09 13:16:24 | vendor | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 483 | 2025-05-09 13:14:04 | vendor | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 482 | 2025-05-09 11:29:00 | vendor | 3 | 112716 | 384 | 5.936 | 18988.5 |
| 481 | 2025-05-08 20:51:28 | vendor | 3 | 112716 | 384 | 17.390 | 6481.7 |
| 480 | 2025-05-07 15:42:57 | vendor | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 479 | 2025-05-07 02:53:57 | vendor | 3 | 112716 | 384 | 5.466 | 20621.3 |
| 478 | 2025-05-04 09:17:40 | vendor | 3 | 112716 | 384 | 28.876 | 3903.4 |
| 477 | 2025-05-02 20:46:25 | vendor | 3 | 112716 | 384 | 20.423 | 5519.1 |
| 476 | 2025-05-02 14:28:38 | vendor | 3 | 112716 | 384 | 15.636 | 7208.7 |
| 475 | 2025-05-01 05:40:01 | vendor | 3 | 112716 | 384 | 26.760 | 4212.1 |
| 474 | 2025-04-30 04:07:48 | vendor | 1 | 48755 | 3 | 2.326 | 20960.9 |
| 473 | 2025-04-20 11:13:20 | vendor | 1 | 48755 | 3 | 2.800 | 17412.5 |
| 472 | 2025-04-20 10:37:23 | vendor | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 471 | 2025-04-20 08:02:49 | vendor | 1 | 48755 | 3 | 3.060 | 15933.0 |
| 470 | 2025-04-13 22:34:18 | vendor | 1 | 48755 | 3 | 5.110 | 9541.1 |
| 469 | 2025-04-11 03:27:17 | vendor | 1 | 48755 | 3 | 4.110 | 11862.5 |
| 468 | 2025-04-05 05:27:17 | vendor | 3 | 112716 | 384 | 5.313 | 21215.1 |
| 467 | 2025-03-30 07:26:48 | vendor | 2 | 82551 | 37 | 2.546 | 32423.8 |
| 466 | 2025-03-30 01:02:47 | vendor | 2 | 82551 | 37 | 3.890 | 21221.3 |
| 465 | 2025-03-29 11:31:01 | vendor | 1 | 48755 | 3 | 5.080 | 9597.4 |
| 464 | 2025-03-28 14:34:02 | vendor | 2 | 82551 | 37 | 2.470 | 33421.5 |
| 463 | 2025-03-28 03:43:53 | vendor | 3 | 112716 | 384 | 5.360 | 21029.1 |