History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lecture"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 508 | 2025-11-29 13:41:43 | lecture | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 507 | 2025-11-27 20:17:47 | lecture | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 506 | 2025-11-27 05:42:05 | lecture | 1 | 69583 | 4 | 4.173 | 16674.6 |
| 505 | 2025-11-26 06:09:20 | lecture | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 504 | 2025-11-24 08:09:56 | lecture | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 503 | 2025-11-23 06:32:26 | lecture | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 502 | 2025-11-23 01:23:49 | lecture | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 501 | 2025-11-22 09:01:30 | lecture | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 500 | 2025-11-21 01:48:20 | lecture | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 499 | 2025-11-20 16:32:22 | lecture | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 498 | 2025-11-15 22:29:31 | lecture | 1 | 69583 | 4 | 4.030 | 17266.3 |
| 497 | 2025-11-12 11:30:33 | lecture | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 496 | 2025-11-09 14:14:40 | lecture | 1 | 69583 | 4 | 1.106 | 62914.1 |
| 495 | 2025-10-29 14:58:31 | lecture | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 494 | 2025-10-26 07:09:28 | lecture | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 493 | 2025-10-23 02:19:43 | lecture | 1 | 69583 | 4 | 6.030 | 11539.5 |
| 492 | 2025-10-21 19:15:59 | lecture | 1 | 69583 | 4 | 4.093 | 17000.5 |
| 491 | 2025-10-21 13:06:14 | lecture | 1 | 69583 | 4 | 2.936 | 23699.9 |
| 490 | 2025-10-21 10:29:07 | lecture | 1 | 69583 | 4 | 5.266 | 13213.6 |
| 489 | 2025-10-20 17:24:35 | lecture | 1 | 69583 | 4 | 5.830 | 11935.3 |
| 488 | 2025-10-18 14:36:38 | lecture | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 487 | 2025-10-17 13:21:31 | lecture | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 486 | 2025-10-09 18:37:01 | lecture | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 485 | 2025-10-08 22:37:41 | lecture | 1 | 69583 | 4 | 1.360 | 51164.0 |
| 484 | 2025-10-06 09:42:59 | lecture | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 483 | 2025-09-28 15:17:38 | lecture | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 482 | 2025-09-25 07:04:53 | lecture | 1 | 69583 | 4 | 4.593 | 15149.8 |
| 481 | 2025-09-23 06:10:10 | lecture | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 480 | 2025-09-21 08:06:02 | lecture | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 479 | 2025-09-21 02:42:50 | lecture | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 478 | 2025-09-18 09:40:18 | lecture | 1 | 69583 | 4 | 2.310 | 30122.5 |
| 477 | 2025-09-11 19:19:02 | lecture | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 476 | 2025-09-05 12:01:48 | lecture | 3 | 134027 | 212 | 5.876 | 22809.2 |
| 475 | 2025-09-05 03:26:20 | lecture | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 474 | 2025-09-02 12:48:15 | lecture | 2 | 107671 | 20 | 2.893 | 37217.8 |
| 473 | 2025-09-01 18:50:29 | lecture | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 472 | 2025-09-01 11:23:26 | lecture | 2 | 107671 | 20 | 2.860 | 37647.2 |
| 471 | 2025-08-31 16:33:45 | lecture | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 470 | 2025-08-31 05:16:07 | lecture | 2 | 107671 | 20 | 3.076 | 35003.6 |
| 469 | 2025-08-28 14:42:27 | lecture | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 468 | 2025-08-28 09:43:37 | lecture | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 467 | 2025-08-25 07:22:33 | lecture | 1 | 69583 | 4 | 4.670 | 14900.0 |
| 466 | 2025-08-21 08:05:17 | lecture | 1 | 69583 | 4 | 2.923 | 23805.3 |
| 465 | 2025-08-09 17:56:58 | lecture | 1 | 69583 | 4 | 2.890 | 24077.2 |
| 464 | 2025-08-05 12:05:06 | lecture | 1 | 69583 | 4 | 3.170 | 21950.5 |
| 463 | 2025-08-01 13:39:29 | lecture | 2 | 107671 | 20 | 18.296 | 5884.9 |
| 462 | 2025-07-28 08:32:10 | lecture | 1 | 69583 | 4 | 2.470 | 28171.3 |
| 461 | 2025-07-27 15:02:12 | lecture | 3 | 134027 | 212 | 19.330 | 6933.6 |
| 460 | 2025-07-27 11:27:14 | lecture | 1 | 69583 | 4 | 6.123 | 11364.2 |
| 459 | 2025-07-27 04:54:11 | lecture | 2 | 107671 | 20 | 14.280 | 7540.0 |
| 458 | 2025-07-25 20:42:06 | lecture | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 457 | 2025-07-25 05:59:58 | lecture | 1 | 69583 | 4 | 5.406 | 12871.4 |
| 456 | 2025-07-23 19:06:50 | lecture | 1 | 69583 | 4 | 2.593 | 26834.9 |
| 455 | 2025-07-20 23:20:17 | lecture | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 454 | 2025-07-13 15:59:53 | lecture | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 453 | 2025-07-13 05:15:50 | lecture | 3 | 134027 | 212 | 6.623 | 20236.6 |
| 452 | 2025-07-10 11:31:39 | lecture | 3 | 134027 | 212 | 7.670 | 17474.2 |
| 451 | 2025-07-10 09:40:11 | lecture | 2 | 107671 | 20 | 3.703 | 29076.7 |
| 450 | 2025-07-08 17:01:31 | lecture | 1 | 69583 | 4 | 3.250 | 21410.2 |
| 449 | 2025-07-05 11:59:51 | lecture | 2 | 107671 | 20 | 15.250 | 7060.4 |
| 448 | 2025-07-04 03:27:22 | lecture | 1 | 69583 | 4 | 5.046 | 13789.7 |
| 447 | 2025-06-24 02:50:18 | lecture | 1 | 69583 | 4 | 6.763 | 10288.8 |
| 446 | 2025-06-21 19:59:08 | lecture | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 445 | 2025-06-14 09:02:19 | lecture | 1 | 69583 | 4 | 2.970 | 23428.6 |
| 444 | 2025-06-13 03:13:12 | lecture | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 443 | 2025-06-11 08:48:51 | lecture | 1 | 69583 | 4 | 3.186 | 21840.2 |
| 442 | 2025-06-11 01:05:14 | lecture | 3 | 134027 | 212 | 23.440 | 5717.9 |
| 441 | 2025-06-10 23:05:29 | lecture | 3 | 134027 | 212 | 38.173 | 3511.0 |
| 440 | 2025-06-10 12:00:20 | lecture | 1 | 69583 | 4 | 3.326 | 20920.9 |
| 439 | 2025-06-10 08:52:49 | lecture | 3 | 134027 | 212 | 30.253 | 4430.2 |
| 438 | 2025-06-09 13:34:33 | lecture | 3 | 134027 | 212 | 6.750 | 19855.9 |
| 437 | 2025-06-08 20:40:18 | lecture | 2 | 107671 | 20 | 3.466 | 31064.9 |
| 436 | 2025-06-07 14:50:21 | lecture | 1 | 69583 | 4 | 3.173 | 21929.7 |
| 435 | 2025-06-03 07:05:27 | lecture | 1 | 69583 | 4 | 3.703 | 18791.0 |
| 434 | 2025-06-02 02:58:59 | lecture | 1 | 69583 | 4 | 6.250 | 11133.3 |
| 433 | 2025-05-22 15:28:51 | lecture | 1 | 69583 | 4 | 3.266 | 21305.3 |
| 432 | 2025-05-20 09:34:27 | lecture | 3 | 134027 | 212 | 31.843 | 4209.0 |
| 431 | 2025-05-20 08:14:58 | lecture | 3 | 134027 | 212 | 30.313 | 4421.4 |
| 430 | 2025-05-18 21:30:33 | lecture | 3 | 134027 | 212 | 7.203 | 18607.1 |
| 429 | 2025-05-08 16:28:39 | lecture | 1 | 69583 | 4 | 5.970 | 11655.4 |
| 428 | 2025-05-08 08:28:11 | lecture | 1 | 69583 | 4 | 5.936 | 11722.2 |
| 427 | 2025-05-02 02:28:24 | lecture | 1 | 69583 | 4 | 5.923 | 11747.9 |
| 426 | 2025-05-01 22:47:30 | lecture | 3 | 134027 | 212 | 38.046 | 3522.8 |
| 425 | 2025-04-30 11:39:46 | lecture | 3 | 134027 | 212 | 27.720 | 4835.0 |
| 424 | 2025-04-28 13:14:15 | lecture | 3 | 134027 | 212 | 33.660 | 3981.8 |
| 423 | 2025-04-27 02:18:55 | lecture | 2 | 107671 | 20 | 3.750 | 28712.3 |
| 422 | 2025-04-26 01:02:07 | lecture | 3 | 134027 | 212 | 24.003 | 5583.8 |
| 421 | 2025-04-25 06:45:59 | lecture | 1 | 69583 | 4 | 6.220 | 11187.0 |
| 420 | 2025-04-20 13:55:45 | lecture | 1 | 69583 | 4 | 5.950 | 11694.6 |
| 419 | 2025-04-06 07:37:07 | lecture | 1 | 69583 | 4 | 3.000 | 23194.3 |
| 418 | 2025-03-31 03:55:17 | lecture | 1 | 69583 | 4 | 3.080 | 22591.9 |
| 417 | 2025-03-27 22:18:34 | lecture | 1 | 69583 | 4 | 2.640 | 26357.2 |
| 416 | 2025-03-26 21:37:01 | lecture | 2 | 107671 | 20 | 16.173 | 6657.5 |
| 415 | 2025-03-24 21:54:15 | lecture | 2 | 107671 | 20 | 11.283 | 9542.8 |
| 414 | 2025-03-23 09:02:47 | lecture | 1 | 69583 | 4 | 6.456 | 10778.0 |
| 413 | 2025-03-20 16:46:49 | lecture | 1 | 69583 | 4 | 7.016 | 9917.8 |
| 412 | 2025-03-05 07:15:30 | lecture | 1 | 69583 | 4 | 8.576 | 8113.7 |
| 411 | 2025-03-04 13:51:17 | lecture | 1 | 69583 | 4 | 5.813 | 11970.2 |
| 410 | 2025-02-26 10:42:04 | lecture | 1 | 69583 | 4 | 2.940 | 23667.7 |
| 409 | 2025-02-24 12:15:29 | lecture | 1 | 69583 | 4 | 8.750 | 7952.3 |