History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lampoons"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 504 | 2024-05-11 14:07:51 | lampoons | 3 | 146162 | 109 | 25.936 | 5635.5 |
| 503 | 2024-05-11 14:07:50 | lampoons | 2 | 121059 | 15 | 8.766 | 13810.1 |
| 502 | 2024-05-11 06:42:53 | lampoons | 3 | 146162 | 109 | 17.706 | 8254.9 |
| 501 | 2024-05-11 06:42:51 | lampoons | 2 | 121059 | 15 | 10.750 | 11261.3 |
| 500 | 2024-04-13 17:46:48 | lampoons | 3 | 146162 | 109 | 11.266 | 12973.7 |
| 499 | 2024-04-13 14:17:04 | lampoons | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 498 | 2024-04-13 14:02:23 | lampoons | 1 | 82945 | 3 | 1.610 | 51518.6 |
| 497 | 2024-04-13 09:34:17 | lampoons | 2 | 121059 | 15 | 7.436 | 16280.1 |
| 496 | 2024-04-13 09:34:21 | lampoons | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 495 | 2024-04-13 09:34:09 | lampoons | 3 | 146162 | 109 | 8.283 | 17646.0 |
| 494 | 2024-04-13 06:13:53 | lampoons | 3 | 146162 | 109 | 7.406 | 19735.6 |
| 493 | 2024-04-10 23:21:54 | lampoons | 3 | 146162 | 109 | 8.046 | 18165.8 |
| 492 | 2024-04-10 17:51:44 | lampoons | 1 | 82945 | 3 | 7.236 | 11462.8 |
| 491 | 2024-04-10 17:50:54 | lampoons | 1 | 82945 | 3 | 2.686 | 30880.5 |
| 490 | 2024-04-09 22:26:43 | lampoons | 2 | 121059 | 15 | 8.280 | 14620.7 |
| 489 | 2024-04-09 22:26:40 | lampoons | 3 | 146162 | 109 | 7.156 | 20425.1 |
| 488 | 2024-04-09 22:26:38 | lampoons | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 487 | 2024-04-05 07:13:14 | lampoons | 2 | 121059 | 15 | 8.156 | 14842.9 |
| 486 | 2024-03-31 23:45:10 | lampoons | 2 | 121059 | 15 | 12.940 | 9355.4 |
| 485 | 2024-03-31 23:45:09 | lampoons | 1 | 82945 | 3 | 3.140 | 26415.6 |
| 484 | 2024-03-29 21:04:38 | lampoons | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 483 | 2024-03-20 14:23:34 | lampoons | 3 | 146162 | 109 | 6.733 | 21708.3 |
| 482 | 2024-03-13 17:26:32 | lampoons | 3 | 146162 | 109 | 11.250 | 12992.2 |
| 481 | 2024-03-11 23:09:48 | lampoons | 3 | 146162 | 109 | 16.203 | 9020.7 |
| 480 | 2024-03-11 23:09:47 | lampoons | 2 | 121059 | 15 | 3.923 | 30858.8 |
| 479 | 2024-03-11 23:09:44 | lampoons | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 478 | 2024-03-07 16:54:04 | lampoons | 3 | 146162 | 109 | 6.546 | 22328.4 |
| 477 | 2024-03-07 16:54:00 | lampoons | 2 | 121059 | 15 | 3.343 | 36212.7 |
| 476 | 2024-03-05 02:04:10 | lampoons | 3 | 146162 | 109 | 17.706 | 8254.9 |
| 475 | 2024-03-05 02:04:10 | lampoons | 2 | 121059 | 15 | 13.813 | 8764.1 |
| 474 | 2024-03-04 23:54:25 | lampoons | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 473 | 2024-02-09 20:31:53 | lampoons | 2 | 121059 | 15 | 3.626 | 33386.4 |
| 472 | 2024-02-09 20:31:37 | lampoons | 3 | 146162 | 109 | 6.766 | 21602.4 |
| 471 | 2024-02-06 09:58:34 | lampoons | 2 | 121059 | 15 | 3.390 | 35710.6 |
| 470 | 2024-02-06 09:58:02 | lampoons | 3 | 146162 | 109 | 7.466 | 19577.0 |
| 469 | 2024-02-06 01:50:38 | lampoons | 1 | 82945 | 3 | 3.076 | 26965.2 |
| 468 | 2024-01-31 14:30:11 | lampoons | 2 | 121059 | 15 | 3.826 | 31641.1 |
| 467 | 2024-01-31 10:22:42 | lampoons | 2 | 121059 | 15 | 4.046 | 29920.7 |
| 466 | 2024-01-27 09:45:55 | lampoons | 3 | 146162 | 109 | 8.250 | 17716.6 |
| 465 | 2024-01-26 17:09:59 | lampoons | 3 | 146162 | 109 | 12.703 | 11506.1 |
| 464 | 2024-01-26 17:09:31 | lampoons | 2 | 121059 | 15 | 5.220 | 23191.4 |
| 463 | 2024-01-25 09:36:37 | lampoons | 2 | 121059 | 15 | 3.716 | 32577.8 |
| 462 | 2024-01-05 12:50:37 | lampoons | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 461 | 2023-12-28 18:55:51 | lampoons | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 460 | 2023-12-25 23:43:02 | lampoons | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 459 | 2023-12-01 03:09:02 | lampoons | 3 | 146162 | 109 | 6.233 | 23449.7 |
| 458 | 2023-11-24 01:31:11 | lampoons | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 457 | 2023-11-23 20:04:30 | lampoons | 2 | 121059 | 15 | 8.500 | 14242.2 |
| 456 | 2023-11-16 07:40:34 | lampoons | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 455 | 2023-11-03 20:51:55 | lampoons | 2 | 121059 | 15 | 3.406 | 35542.9 |
| 454 | 2023-10-14 05:43:34 | lampoons | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 453 | 2023-10-11 15:33:52 | lampoons | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 452 | 2023-09-25 16:30:02 | lampoons | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 451 | 2023-09-23 11:05:56 | lampoons | 1 | 82945 | 3 | 1.450 | 57203.4 |
| 450 | 2023-09-12 03:36:37 | lampoons | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 449 | 2023-08-30 01:30:46 | lampoons | 3 | 146162 | 109 | 6.076 | 24055.6 |
| 448 | 2023-08-10 04:38:26 | lampoons | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 447 | 2023-08-10 04:01:50 | lampoons | 2 | 121059 | 15 | 3.156 | 38358.4 |
| 446 | 2023-05-26 13:59:35 | lampoons | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 445 | 2023-05-17 01:23:02 | lampoons | 3 | 146162 | 109 | 6.063 | 24107.2 |
| 444 | 2023-05-08 06:46:43 | lampoons | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 443 | 2023-04-21 03:26:18 | lampoons | 2 | 121059 | 15 | 3.093 | 39139.7 |
| 442 | 2023-03-05 06:47:49 | lampoons | 1 | 82945 | 3 | 1.403 | 59119.7 |
| 441 | 2023-02-22 21:47:39 | lampoons | 3 | 146162 | 109 | 6.186 | 23627.9 |
| 440 | 2023-02-11 01:18:28 | lampoons | 3 | 146162 | 109 | 6.140 | 23804.9 |
| 439 | 2023-02-03 01:10:02 | lampoons | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 438 | 2023-01-30 01:43:51 | lampoons | 2 | 121059 | 15 | 3.080 | 39304.9 |
| 437 | 2023-01-06 07:19:02 | lampoons | 3 | 146162 | 109 | 6.950 | 21030.5 |
| 436 | 2022-12-27 11:37:48 | lampoons | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 435 | 2022-12-04 10:25:25 | lampoons | 3 | 146162 | 109 | 7.406 | 19735.6 |
| 434 | 2022-11-11 13:28:43 | lampoons | 2 | 121059 | 15 | 3.406 | 35542.9 |
| 433 | 2022-10-05 13:32:07 | lampoons | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 432 | 2022-09-13 10:46:50 | lampoons | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 431 | 2022-07-15 00:59:53 | lampoons | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 430 | 2022-06-14 13:55:21 | lampoons | 2 | 121059 | 15 | 3.156 | 38358.4 |
| 429 | 2022-05-28 19:34:38 | lampoons | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 428 | 2022-04-02 08:04:45 | lampoons | 3 | 146162 | 109 | 6.076 | 24055.6 |
| 427 | 2022-03-31 05:28:19 | lampoons | 3 | 146162 | 109 | 6.593 | 22169.3 |
| 426 | 2022-03-19 06:29:17 | lampoons | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 425 | 2022-03-17 02:29:48 | lampoons | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 424 | 2022-01-27 12:15:52 | lampoons | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 423 | 2021-12-25 05:17:42 | lampoons | 1 | 82945 | 3 | 1.346 | 61623.3 |
| 422 | 2021-10-30 01:36:17 | lampoons | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 421 | 2021-10-14 02:03:19 | lampoons | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 420 | 2021-10-10 19:57:38 | lampoons | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 419 | 2021-09-14 01:22:17 | lampoons | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 418 | 2021-09-01 05:01:30 | lampoons | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 417 | 2021-08-27 11:23:04 | lampoons | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 416 | 2021-07-09 03:39:31 | lampoons | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 415 | 2021-05-10 15:51:15 | lampoons | 1 | 82945 | 3 | 1.733 | 47862.1 |
| 414 | 2021-04-05 06:22:07 | lampoons | 1 | 82945 | 3 | 1.346 | 61623.3 |
| 413 | 2021-04-01 02:49:23 | lampoons | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 412 | 2021-02-16 21:19:24 | lampoons | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 411 | 2020-12-23 22:33:31 | lampoons | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 410 | 2020-10-13 17:23:16 | lampoons | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 409 | 2020-09-20 01:14:27 | lampoons | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 408 | 2020-08-05 11:47:48 | lampoons | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 407 | 2020-06-12 17:15:28 | lampoons | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 406 | 2020-03-26 12:43:46 | lampoons | 1 | 82945 | 3 | 1.640 | 50576.2 |
| 405 | 2020-03-24 19:00:25 | lampoons | 1 | 82945 | 3 | 1.436 | 57761.1 |