History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clarets"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 529 | 2025-04-23 16:11:46 | clarets | 1 | 69583 | 3 | 4.390 | 15850.3 |
| 528 | 2025-04-22 04:59:42 | clarets | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 527 | 2025-04-20 14:19:17 | clarets | 1 | 69583 | 3 | 5.530 | 12582.8 |
| 526 | 2025-04-20 14:16:04 | clarets | 3 | 134027 | 615 | 24.126 | 5555.3 |
| 525 | 2025-04-19 23:08:10 | clarets | 1 | 69583 | 3 | 5.453 | 12760.5 |
| 524 | 2025-04-17 21:39:21 | clarets | 1 | 69583 | 3 | 4.190 | 16606.9 |
| 523 | 2025-04-15 07:23:27 | clarets | 1 | 69583 | 3 | 3.346 | 20795.9 |
| 522 | 2025-04-14 09:03:00 | clarets | 3 | 134027 | 615 | 39.140 | 3424.3 |
| 521 | 2025-04-14 03:04:40 | clarets | 1 | 69583 | 3 | 9.016 | 7717.7 |
| 520 | 2025-04-11 09:44:32 | clarets | 1 | 69583 | 3 | 5.080 | 13697.4 |
| 519 | 2025-04-11 01:55:24 | clarets | 3 | 134027 | 615 | 39.940 | 3355.7 |
| 518 | 2025-04-04 16:49:04 | clarets | 3 | 134027 | 615 | 35.063 | 3822.5 |
| 517 | 2025-04-04 13:27:19 | clarets | 3 | 134027 | 615 | 18.266 | 7337.5 |
| 516 | 2025-04-04 05:56:12 | clarets | 3 | 134027 | 615 | 28.580 | 4689.5 |
| 515 | 2025-04-02 23:27:38 | clarets | 3 | 134027 | 615 | 6.936 | 19323.4 |
| 514 | 2025-03-31 16:39:28 | clarets | 1 | 69583 | 3 | 5.220 | 13330.1 |
| 513 | 2025-03-20 17:05:16 | clarets | 1 | 69583 | 3 | 3.280 | 21214.3 |
| 512 | 2025-03-20 00:28:33 | clarets | 1 | 69583 | 3 | 3.533 | 19695.2 |
| 511 | 2025-03-16 17:20:37 | clarets | 1 | 69583 | 3 | 8.673 | 8022.9 |
| 510 | 2025-03-04 19:55:32 | clarets | 1 | 69583 | 3 | 8.983 | 7746.1 |
| 509 | 2025-02-27 08:22:48 | clarets | 1 | 69583 | 3 | 3.140 | 22160.2 |
| 508 | 2025-02-26 00:20:50 | clarets | 3 | 134027 | 615 | 28.033 | 4781.0 |
| 507 | 2025-02-25 22:07:14 | clarets | 3 | 134027 | 615 | 34.610 | 3872.5 |
| 506 | 2025-02-24 07:08:22 | clarets | 3 | 134027 | 615 | 47.223 | 2838.2 |
| 505 | 2025-02-24 06:04:10 | clarets | 3 | 134027 | 615 | 41.880 | 3200.3 |
| 504 | 2025-02-24 04:06:20 | clarets | 3 | 134027 | 615 | 42.080 | 3185.1 |
| 503 | 2025-02-23 18:46:23 | clarets | 3 | 134027 | 615 | 52.250 | 2565.1 |
| 502 | 2025-02-20 19:19:27 | clarets | 1 | 69583 | 3 | 3.296 | 21111.3 |
| 501 | 2025-01-29 17:19:13 | clarets | 1 | 69583 | 3 | 2.330 | 29863.9 |
| 500 | 2025-01-26 19:52:18 | clarets | 1 | 69583 | 3 | 4.750 | 14649.1 |
| 499 | 2025-01-26 19:37:24 | clarets | 2 | 107671 | 46 | 14.546 | 7402.1 |
| 498 | 2025-01-26 18:12:39 | clarets | 2 | 107671 | 46 | 3.390 | 31761.4 |
| 497 | 2025-01-26 18:12:32 | clarets | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 496 | 2025-01-25 10:21:25 | clarets | 1 | 69583 | 3 | 7.436 | 9357.6 |
| 495 | 2025-01-25 10:16:25 | clarets | 3 | 134027 | 615 | 21.690 | 6179.2 |
| 494 | 2025-01-25 04:44:49 | clarets | 3 | 134027 | 615 | 33.893 | 3954.4 |
| 493 | 2025-01-15 05:34:16 | clarets | 3 | 134027 | 615 | 41.940 | 3195.7 |
| 492 | 2025-01-15 03:25:04 | clarets | 3 | 134027 | 615 | 28.643 | 4679.2 |
| 491 | 2025-01-14 16:43:17 | clarets | 3 | 134027 | 615 | 31.970 | 4192.3 |
| 490 | 2025-01-14 08:23:23 | clarets | 1 | 69583 | 3 | 5.236 | 13289.3 |
| 489 | 2024-12-17 05:04:55 | clarets | 3 | 134027 | 615 | 34.453 | 3890.1 |
| 488 | 2024-12-15 05:44:06 | clarets | 3 | 134027 | 615 | 25.126 | 5334.2 |
| 487 | 2024-12-12 14:22:36 | clarets | 3 | 134027 | 615 | 50.250 | 2667.2 |
| 486 | 2024-12-12 14:18:58 | clarets | 3 | 134027 | 615 | 44.550 | 3008.5 |
| 485 | 2024-12-12 14:19:00 | clarets | 2 | 107671 | 46 | 22.453 | 4795.4 |
| 484 | 2024-12-12 14:18:26 | clarets | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 483 | 2024-12-09 21:41:29 | clarets | 1 | 69583 | 3 | 4.610 | 15093.9 |
| 482 | 2024-11-24 09:35:24 | clarets | 1 | 69583 | 3 | 5.970 | 11655.4 |
| 481 | 2024-11-18 03:52:29 | clarets | 1 | 69583 | 3 | 2.983 | 23326.5 |
| 480 | 2024-11-09 22:07:09 | clarets | 1 | 69583 | 3 | 6.173 | 11272.2 |
| 479 | 2024-10-24 01:14:41 | clarets | 1 | 69583 | 3 | 5.810 | 11976.4 |
| 478 | 2024-10-17 03:43:18 | clarets | 1 | 69583 | 3 | 5.920 | 11753.9 |
| 477 | 2024-10-15 18:39:58 | clarets | 1 | 69583 | 3 | 4.453 | 15626.1 |
| 476 | 2024-10-09 03:24:49 | clarets | 3 | 134027 | 615 | 26.926 | 4977.6 |
| 475 | 2024-10-08 23:37:32 | clarets | 3 | 134027 | 615 | 24.970 | 5367.5 |
| 474 | 2024-10-08 23:37:17 | clarets | 2 | 107671 | 46 | 8.313 | 12952.1 |
| 473 | 2024-10-08 19:15:01 | clarets | 3 | 134027 | 615 | 91.256 | 1468.7 |
| 472 | 2024-10-08 19:15:03 | clarets | 2 | 107671 | 46 | 26.953 | 3994.8 |
| 471 | 2024-10-08 15:58:57 | clarets | 1 | 69583 | 3 | 4.810 | 14466.3 |
| 470 | 2024-09-22 00:02:36 | clarets | 1 | 69583 | 3 | 8.373 | 8310.4 |
| 469 | 2024-09-09 23:40:56 | clarets | 1 | 69583 | 3 | 9.356 | 7437.3 |
| 468 | 2024-09-06 07:41:45 | clarets | 1 | 69583 | 3 | 10.033 | 6935.4 |
| 467 | 2024-08-29 06:51:51 | clarets | 2 | 107671 | 46 | 22.843 | 4713.5 |
| 466 | 2024-08-28 00:43:25 | clarets | 1 | 69583 | 3 | 4.203 | 16555.6 |
| 465 | 2024-08-27 15:28:07 | clarets | 1 | 69583 | 3 | 2.610 | 26660.2 |
| 464 | 2024-08-20 11:53:54 | clarets | 2 | 107671 | 46 | 11.313 | 9517.5 |
| 463 | 2024-08-18 20:08:25 | clarets | 3 | 134027 | 615 | 47.250 | 2836.6 |
| 462 | 2024-08-18 20:08:28 | clarets | 2 | 107671 | 46 | 37.550 | 2867.4 |
| 461 | 2024-08-18 20:08:14 | clarets | 1 | 69583 | 3 | 5.296 | 13138.8 |
| 460 | 2024-08-17 23:57:53 | clarets | 1 | 69583 | 3 | 5.763 | 12074.1 |
| 459 | 2024-08-03 04:43:03 | clarets | 1 | 69583 | 3 | 4.843 | 14367.7 |
| 458 | 2024-08-03 01:13:24 | clarets | 1 | 69583 | 3 | 3.500 | 19880.9 |
| 457 | 2024-07-31 08:19:11 | clarets | 1 | 69583 | 3 | 2.970 | 23428.6 |
| 456 | 2024-07-26 19:29:11 | clarets | 1 | 69583 | 3 | 5.670 | 12272.1 |
| 455 | 2024-07-24 13:13:29 | clarets | 3 | 134027 | 615 | 25.190 | 5320.6 |
| 454 | 2024-07-23 13:02:19 | clarets | 3 | 134027 | 615 | 31.593 | 4242.3 |
| 453 | 2024-07-22 03:05:14 | clarets | 3 | 134027 | 615 | 30.533 | 4389.6 |
| 452 | 2024-07-22 00:43:20 | clarets | 3 | 134027 | 615 | 36.126 | 3710.0 |
| 451 | 2024-07-21 16:00:10 | clarets | 3 | 134027 | 615 | 18.626 | 7195.7 |
| 450 | 2024-07-21 15:19:15 | clarets | 3 | 134027 | 615 | 14.796 | 9058.3 |
| 449 | 2024-07-19 15:05:50 | clarets | 1 | 69583 | 3 | 2.516 | 27656.2 |
| 448 | 2024-07-13 18:11:54 | clarets | 1 | 69583 | 3 | 6.580 | 10574.9 |
| 447 | 2024-07-01 09:05:02 | clarets | 1 | 69583 | 3 | 1.923 | 36184.6 |
| 446 | 2024-07-01 04:50:27 | clarets | 1 | 69583 | 3 | 3.313 | 21003.0 |
| 445 | 2024-06-27 13:11:02 | clarets | 1 | 69583 | 3 | 6.360 | 10940.7 |
| 444 | 2024-06-24 14:10:13 | clarets | 3 | 134027 | 615 | 27.516 | 4870.9 |
| 443 | 2024-06-22 18:10:48 | clarets | 1 | 69583 | 3 | 3.470 | 20052.7 |
| 442 | 2024-06-20 14:17:56 | clarets | 3 | 134027 | 615 | 13.613 | 9845.5 |
| 441 | 2024-06-20 14:12:12 | clarets | 3 | 134027 | 615 | 33.236 | 4032.6 |
| 440 | 2024-06-19 16:38:26 | clarets | 3 | 134027 | 615 | 17.533 | 7644.3 |
| 439 | 2024-06-19 16:38:18 | clarets | 2 | 107671 | 46 | 10.720 | 10043.9 |
| 438 | 2024-06-18 21:40:37 | clarets | 3 | 134027 | 615 | 25.596 | 5236.2 |
| 437 | 2024-06-18 21:40:37 | clarets | 2 | 107671 | 46 | 17.500 | 6152.6 |
| 436 | 2024-06-18 13:59:16 | clarets | 1 | 69583 | 3 | 6.096 | 11414.5 |
| 435 | 2024-06-18 13:57:10 | clarets | 3 | 134027 | 615 | 27.190 | 4929.3 |
| 434 | 2024-06-18 13:56:53 | clarets | 2 | 107671 | 46 | 16.126 | 6676.9 |
| 433 | 2024-06-17 16:42:40 | clarets | 1 | 69583 | 3 | 3.470 | 20052.7 |
| 432 | 2024-06-13 03:21:44 | clarets | 1 | 69583 | 3 | 2.486 | 27989.9 |
| 431 | 2024-06-07 12:29:13 | clarets | 1 | 69583 | 3 | 5.220 | 13330.1 |
| 430 | 2024-06-04 07:27:43 | clarets | 1 | 69583 | 3 | 1.263 | 55093.4 |