History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"assignee"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 501 | 2025-11-21 05:30:12 | assignee | 4 | 161609 | 396 | 35.860 | 4506.7 |
| 500 | 2025-11-21 01:33:48 | assignee | 4 | 161609 | 396 | 13.440 | 12024.5 |
| 499 | 2025-11-17 08:00:51 | assignee | 2 | 121059 | 12 | 3.623 | 33414.0 |
| 498 | 2025-11-14 10:25:26 | assignee | 1 | 82945 | 4 | 1.423 | 58288.8 |
| 497 | 2025-11-13 08:40:57 | assignee | 3 | 146162 | 48 | 7.656 | 19091.2 |
| 496 | 2025-11-07 02:27:36 | assignee | 3 | 146162 | 48 | 6.953 | 21021.4 |
| 495 | 2025-11-05 19:45:55 | assignee | 2 | 121059 | 12 | 3.250 | 37248.9 |
| 494 | 2025-11-04 13:07:20 | assignee | 1 | 82945 | 4 | 1.533 | 54106.3 |
| 493 | 2025-11-03 10:33:32 | assignee | 2 | 121059 | 12 | 5.096 | 23755.7 |
| 492 | 2025-11-03 00:54:36 | assignee | 2 | 121059 | 12 | 3.796 | 31891.2 |
| 491 | 2025-11-02 23:43:53 | assignee | 2 | 121059 | 12 | 3.403 | 35574.2 |
| 490 | 2025-11-02 06:46:26 | assignee | 1 | 82945 | 4 | 1.440 | 57600.7 |
| 489 | 2025-11-01 05:51:51 | assignee | 3 | 146162 | 48 | 7.266 | 20115.9 |
| 488 | 2025-11-01 03:02:14 | assignee | 2 | 121059 | 12 | 6.016 | 20122.8 |
| 487 | 2025-11-01 01:09:17 | assignee | 3 | 146162 | 48 | 8.733 | 16736.7 |
| 486 | 2025-10-31 22:01:17 | assignee | 3 | 146162 | 48 | 6.626 | 22058.9 |
| 485 | 2025-10-31 21:59:08 | assignee | 3 | 146162 | 48 | 6.953 | 21021.4 |
| 484 | 2025-10-31 20:51:27 | assignee | 4 | 161609 | 396 | 12.393 | 13040.3 |
| 483 | 2025-10-31 16:11:39 | assignee | 3 | 146162 | 48 | 7.593 | 19249.6 |
| 482 | 2025-10-31 13:05:36 | assignee | 4 | 161609 | 396 | 11.030 | 14651.8 |
| 481 | 2025-10-31 10:13:50 | assignee | 4 | 161609 | 396 | 12.453 | 12977.5 |
| 480 | 2025-10-31 07:40:27 | assignee | 4 | 161609 | 396 | 13.453 | 12012.9 |
| 479 | 2025-10-31 04:49:46 | assignee | 4 | 161609 | 396 | 13.080 | 12355.4 |
| 478 | 2025-10-31 03:44:54 | assignee | 4 | 161609 | 396 | 12.623 | 12802.7 |
| 477 | 2025-10-31 00:56:36 | assignee | 2 | 121059 | 12 | 3.733 | 32429.4 |
| 476 | 2025-10-31 00:47:56 | assignee | 4 | 161609 | 396 | 12.940 | 12489.1 |
| 475 | 2025-10-30 22:27:32 | assignee | 2 | 121059 | 12 | 3.626 | 33386.4 |
| 474 | 2025-10-30 22:26:20 | assignee | 3 | 146162 | 48 | 13.610 | 10739.3 |
| 473 | 2025-10-30 22:23:00 | assignee | 3 | 146162 | 48 | 7.420 | 19698.4 |
| 472 | 2025-10-30 22:17:41 | assignee | 2 | 121059 | 12 | 3.796 | 31891.2 |
| 471 | 2025-10-30 16:53:45 | assignee | 2 | 121059 | 12 | 3.750 | 32282.4 |
| 470 | 2025-10-30 09:36:20 | assignee | 4 | 161609 | 396 | 10.716 | 15081.1 |
| 469 | 2025-10-30 07:29:49 | assignee | 1 | 82945 | 4 | 1.486 | 55817.6 |
| 468 | 2025-10-30 04:59:18 | assignee | 1 | 82945 | 4 | 1.533 | 54106.3 |
| 467 | 2025-10-30 03:09:26 | assignee | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 466 | 2025-10-30 00:54:33 | assignee | 1 | 82945 | 4 | 3.593 | 23085.2 |
| 465 | 2025-10-29 13:37:16 | assignee | 3 | 146162 | 48 | 7.690 | 19006.8 |
| 464 | 2025-10-29 07:02:21 | assignee | 4 | 161609 | 396 | 13.143 | 12296.2 |
| 463 | 2025-10-28 04:55:10 | assignee | 2 | 121059 | 12 | 3.516 | 34430.9 |
| 462 | 2025-10-26 11:43:07 | assignee | 4 | 161609 | 396 | 15.330 | 10542.0 |
| 461 | 2025-10-26 03:30:49 | assignee | 2 | 121059 | 12 | 3.173 | 38152.9 |
| 460 | 2025-10-25 15:03:26 | assignee | 4 | 161609 | 396 | 12.800 | 12625.7 |
| 459 | 2025-10-24 20:42:46 | assignee | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 458 | 2025-10-20 23:46:57 | assignee | 1 | 82945 | 4 | 5.313 | 15611.7 |
| 457 | 2025-10-16 16:42:01 | assignee | 4 | 161609 | 396 | 10.906 | 14818.4 |
| 456 | 2025-10-16 10:04:44 | assignee | 2 | 121059 | 12 | 5.513 | 21958.8 |
| 455 | 2025-10-16 06:12:34 | assignee | 4 | 161609 | 396 | 10.986 | 14710.4 |
| 454 | 2025-10-14 13:35:19 | assignee | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 453 | 2025-10-12 09:53:09 | assignee | 3 | 146162 | 48 | 7.376 | 19815.9 |
| 452 | 2025-10-09 17:49:10 | assignee | 3 | 146162 | 48 | 7.220 | 20244.0 |
| 451 | 2025-10-04 14:07:33 | assignee | 1 | 82945 | 4 | 1.686 | 49196.3 |
| 450 | 2025-10-02 20:48:59 | assignee | 2 | 121059 | 12 | 3.796 | 31891.2 |
| 449 | 2025-10-02 03:32:14 | assignee | 3 | 146162 | 48 | 7.733 | 18901.1 |
| 448 | 2025-10-01 08:12:06 | assignee | 1 | 82945 | 4 | 1.563 | 53067.8 |
| 447 | 2025-10-01 03:40:46 | assignee | 2 | 121059 | 12 | 3.593 | 33693.0 |
| 446 | 2025-10-01 00:54:34 | assignee | 2 | 121059 | 12 | 3.813 | 31749.0 |
| 445 | 2025-09-30 13:23:16 | assignee | 4 | 161609 | 396 | 20.580 | 7852.7 |
| 444 | 2025-09-30 10:30:12 | assignee | 4 | 161609 | 396 | 12.296 | 13143.2 |
| 443 | 2025-09-30 08:10:51 | assignee | 4 | 161609 | 396 | 12.220 | 13225.0 |
| 442 | 2025-09-30 04:44:19 | assignee | 4 | 161609 | 396 | 11.923 | 13554.4 |
| 441 | 2025-09-30 04:13:40 | assignee | 4 | 161609 | 396 | 12.670 | 12755.2 |
| 440 | 2025-09-30 00:55:33 | assignee | 4 | 161609 | 396 | 11.110 | 14546.3 |
| 439 | 2025-09-30 00:48:06 | assignee | 2 | 121059 | 12 | 3.266 | 37066.4 |
| 438 | 2025-09-29 22:55:59 | assignee | 2 | 121059 | 12 | 3.156 | 38358.4 |
| 437 | 2025-09-29 22:15:40 | assignee | 2 | 121059 | 12 | 3.390 | 35710.6 |
| 436 | 2025-09-29 22:13:48 | assignee | 3 | 146162 | 48 | 6.440 | 22696.0 |
| 435 | 2025-09-29 22:11:45 | assignee | 3 | 146162 | 48 | 6.626 | 22058.9 |
| 434 | 2025-09-29 21:45:26 | assignee | 3 | 146162 | 48 | 6.486 | 22535.0 |
| 433 | 2025-09-29 15:57:56 | assignee | 3 | 146162 | 48 | 7.580 | 19282.6 |
| 432 | 2025-09-29 10:03:15 | assignee | 4 | 161609 | 396 | 11.873 | 13611.5 |
| 431 | 2025-09-29 07:22:08 | assignee | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 430 | 2025-09-29 06:26:46 | assignee | 4 | 161609 | 396 | 11.876 | 13608.0 |
| 429 | 2025-09-29 05:24:46 | assignee | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 428 | 2025-09-29 00:51:21 | assignee | 1 | 82945 | 4 | 1.533 | 54106.3 |
| 427 | 2025-09-28 22:19:46 | assignee | 3 | 146162 | 48 | 7.126 | 20511.1 |
| 426 | 2025-09-28 14:00:22 | assignee | 3 | 146162 | 48 | 6.813 | 21453.4 |
| 425 | 2025-09-27 03:09:41 | assignee | 4 | 161609 | 396 | 11.983 | 13486.5 |
| 424 | 2025-09-20 20:36:12 | assignee | 1 | 82945 | 4 | 1.486 | 55817.6 |
| 423 | 2025-09-19 22:21:05 | assignee | 1 | 82945 | 4 | 1.640 | 50576.2 |
| 422 | 2025-09-19 03:00:14 | assignee | 2 | 121059 | 12 | 3.326 | 36397.8 |
| 421 | 2025-09-17 04:36:19 | assignee | 2 | 121059 | 12 | 3.470 | 34887.3 |
| 420 | 2025-09-13 11:20:57 | assignee | 1 | 82945 | 4 | 1.456 | 56967.7 |
| 419 | 2025-09-13 11:18:13 | assignee | 3 | 146162 | 48 | 6.266 | 23326.2 |
| 418 | 2025-09-11 16:17:35 | assignee | 1 | 82945 | 4 | 1.420 | 58412.0 |
| 417 | 2025-09-11 10:00:42 | assignee | 3 | 146162 | 48 | 9.846 | 14844.8 |
| 416 | 2025-09-06 00:22:20 | assignee | 2 | 121059 | 12 | 5.123 | 23630.5 |
| 415 | 2025-09-05 19:48:15 | assignee | 3 | 146162 | 48 | 11.576 | 12626.3 |
| 414 | 2025-09-03 15:25:57 | assignee | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 413 | 2025-09-02 17:40:57 | assignee | 1 | 82945 | 4 | 1.423 | 58288.8 |
| 412 | 2025-09-02 15:46:43 | assignee | 4 | 161609 | 396 | 11.533 | 14012.7 |
| 411 | 2025-09-01 09:15:42 | assignee | 3 | 146162 | 48 | 6.906 | 21164.5 |
| 410 | 2025-08-31 21:30:39 | assignee | 4 | 161609 | 396 | 12.063 | 13397.1 |
| 409 | 2025-08-31 20:55:31 | assignee | 2 | 121059 | 12 | 3.593 | 33693.0 |
| 408 | 2025-08-31 03:28:09 | assignee | 3 | 146162 | 48 | 7.503 | 19480.5 |
| 407 | 2025-08-31 00:22:23 | assignee | 2 | 121059 | 12 | 4.080 | 29671.3 |
| 406 | 2025-08-30 19:39:38 | assignee | 4 | 161609 | 396 | 11.126 | 14525.3 |
| 405 | 2025-08-30 17:10:17 | assignee | 4 | 161609 | 396 | 10.830 | 14922.3 |
| 404 | 2025-08-30 16:31:19 | assignee | 4 | 161609 | 396 | 11.733 | 13773.9 |
| 403 | 2025-08-30 09:52:12 | assignee | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 402 | 2025-08-30 04:40:36 | assignee | 4 | 161609 | 396 | 11.050 | 14625.2 |