History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prisms"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 545 | 2024-05-01 06:41:56 | prisms | 1 | 48755 | 7 | 0.876 | 55656.4 |
| 544 | 2024-04-28 22:10:18 | prisms | 2 | 82551 | 90 | 2.766 | 29844.9 |
| 543 | 2024-04-28 22:08:11 | prisms | 3 | 112716 | 810 | 5.706 | 19753.9 |
| 542 | 2024-04-28 12:05:56 | prisms | 2 | 82551 | 90 | 5.080 | 16250.2 |
| 541 | 2024-04-28 12:05:47 | prisms | 3 | 112716 | 810 | 11.686 | 9645.4 |
| 540 | 2024-04-28 12:05:43 | prisms | 1 | 48755 | 7 | 1.000 | 48755.0 |
| 539 | 2024-04-28 12:05:00 | prisms | 2 | 82551 | 90 | 4.016 | 20555.5 |
| 538 | 2024-04-28 12:04:33 | prisms | 3 | 112716 | 810 | 5.906 | 19085.0 |
| 537 | 2024-04-28 00:16:14 | prisms | 3 | 112716 | 810 | 17.580 | 6411.6 |
| 536 | 2024-04-27 22:50:17 | prisms | 1 | 48755 | 7 | 2.923 | 16679.8 |
| 535 | 2024-04-03 03:07:16 | prisms | 1 | 48755 | 7 | 1.296 | 37619.6 |
| 534 | 2024-03-29 21:10:31 | prisms | 2 | 82551 | 90 | 2.766 | 29844.9 |
| 533 | 2024-03-29 21:09:52 | prisms | 3 | 112716 | 810 | 5.470 | 20606.2 |
| 532 | 2024-03-29 03:11:59 | prisms | 3 | 112716 | 810 | 6.313 | 17854.6 |
| 531 | 2024-03-29 03:07:30 | prisms | 2 | 82551 | 90 | 2.813 | 29346.2 |
| 530 | 2024-03-29 03:07:03 | prisms | 3 | 112716 | 810 | 7.860 | 14340.5 |
| 529 | 2024-03-28 21:47:13 | prisms | 3 | 112716 | 810 | 9.970 | 11305.5 |
| 528 | 2024-03-28 14:59:14 | prisms | 1 | 48755 | 7 | 0.846 | 57630.0 |
| 527 | 2024-03-12 19:35:23 | prisms | 1 | 48755 | 7 | 2.156 | 22613.6 |
| 526 | 2024-03-12 19:35:17 | prisms | 2 | 82551 | 90 | 3.436 | 24025.3 |
| 525 | 2024-03-12 10:22:33 | prisms | 2 | 82551 | 90 | 2.206 | 37421.1 |
| 524 | 2024-03-04 02:35:16 | prisms | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 523 | 2024-03-04 01:13:47 | prisms | 2 | 82551 | 90 | 2.410 | 34253.5 |
| 522 | 2024-03-03 23:52:58 | prisms | 1 | 48755 | 7 | 2.953 | 16510.3 |
| 521 | 2024-03-02 06:51:59 | prisms | 3 | 112716 | 810 | 12.733 | 8852.3 |
| 520 | 2024-02-28 05:30:01 | prisms | 3 | 112716 | 810 | 17.143 | 6575.0 |
| 519 | 2024-02-27 22:54:38 | prisms | 2 | 82551 | 90 | 5.453 | 15138.6 |
| 518 | 2024-02-27 22:54:11 | prisms | 3 | 112716 | 810 | 7.266 | 15512.8 |
| 517 | 2024-02-27 22:46:59 | prisms | 2 | 82551 | 90 | 8.860 | 9317.3 |
| 516 | 2024-02-27 22:46:55 | prisms | 3 | 112716 | 810 | 8.266 | 13636.1 |
| 515 | 2024-02-27 22:46:50 | prisms | 1 | 48755 | 7 | 2.266 | 21515.9 |
| 514 | 2024-02-02 22:00:53 | prisms | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 513 | 2023-12-27 20:20:08 | prisms | 2 | 82551 | 90 | 2.173 | 37989.4 |
| 512 | 2023-12-20 18:40:05 | prisms | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 511 | 2023-12-08 08:24:34 | prisms | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 510 | 2023-12-05 00:47:40 | prisms | 3 | 112716 | 810 | 5.453 | 20670.5 |
| 509 | 2023-11-26 22:11:48 | prisms | 2 | 82551 | 90 | 2.670 | 30918.0 |
| 508 | 2023-11-18 14:37:46 | prisms | 3 | 112716 | 810 | 6.470 | 17421.3 |
| 507 | 2023-11-15 06:46:18 | prisms | 3 | 112716 | 810 | 5.343 | 21096.0 |
| 506 | 2023-11-13 17:01:47 | prisms | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 505 | 2023-11-08 13:12:50 | prisms | 3 | 112716 | 810 | 4.780 | 23580.8 |
| 504 | 2023-11-04 14:20:39 | prisms | 3 | 112716 | 810 | 5.970 | 18880.4 |
| 503 | 2023-11-04 14:20:35 | prisms | 2 | 82551 | 90 | 5.203 | 15866.0 |
| 502 | 2023-11-03 08:01:04 | prisms | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 501 | 2023-10-22 19:27:06 | prisms | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 500 | 2023-10-21 01:57:18 | prisms | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 499 | 2023-10-12 03:19:55 | prisms | 1 | 48755 | 7 | 1.486 | 32809.6 |
| 498 | 2023-10-09 01:04:18 | prisms | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 497 | 2023-10-05 04:27:04 | prisms | 1 | 48755 | 7 | 0.736 | 66243.2 |
| 496 | 2023-09-28 09:28:57 | prisms | 1 | 48755 | 7 | 1.093 | 44606.6 |
| 495 | 2023-09-25 02:36:29 | prisms | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 494 | 2023-09-24 07:55:32 | prisms | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 493 | 2023-09-11 18:45:56 | prisms | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 492 | 2023-09-02 12:42:57 | prisms | 3 | 112716 | 810 | 5.283 | 21335.6 |
| 491 | 2023-08-27 22:43:35 | prisms | 2 | 82551 | 90 | 2.110 | 39123.7 |
| 490 | 2023-08-04 20:06:14 | prisms | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 489 | 2023-06-01 11:51:41 | prisms | 1 | 48755 | 7 | 1.766 | 27607.6 |
| 488 | 2023-05-20 10:25:34 | prisms | 3 | 112716 | 810 | 4.673 | 24120.7 |
| 487 | 2023-05-11 17:21:26 | prisms | 2 | 82551 | 90 | 2.140 | 38575.2 |
| 486 | 2023-04-30 19:21:12 | prisms | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 485 | 2023-03-27 02:06:57 | prisms | 3 | 112716 | 810 | 4.670 | 24136.2 |
| 484 | 2023-02-27 23:58:08 | prisms | 3 | 112716 | 810 | 4.660 | 24188.0 |
| 483 | 2023-02-23 17:58:56 | prisms | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 482 | 2023-02-18 11:41:29 | prisms | 2 | 82551 | 90 | 2.123 | 38884.1 |
| 481 | 2023-02-16 12:22:59 | prisms | 1 | 48755 | 7 | 0.736 | 66243.2 |
| 480 | 2023-02-14 23:00:08 | prisms | 1 | 48755 | 7 | 0.876 | 55656.4 |
| 479 | 2023-02-02 09:34:18 | prisms | 2 | 82551 | 90 | 2.440 | 33832.4 |
| 478 | 2023-01-08 23:22:12 | prisms | 2 | 82551 | 90 | 2.110 | 39123.7 |
| 477 | 2022-12-26 15:31:14 | prisms | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 476 | 2022-12-22 18:14:19 | prisms | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 475 | 2022-12-10 11:16:09 | prisms | 3 | 112716 | 810 | 4.763 | 23664.9 |
| 474 | 2022-12-01 07:51:59 | prisms | 2 | 82551 | 90 | 2.123 | 38884.1 |
| 473 | 2022-11-22 12:44:52 | prisms | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 472 | 2022-11-22 09:47:05 | prisms | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 471 | 2022-11-11 05:57:47 | prisms | 1 | 48755 | 7 | 1.686 | 28917.6 |
| 470 | 2022-11-05 18:29:27 | prisms | 2 | 82551 | 90 | 2.140 | 38575.2 |
| 469 | 2022-11-02 22:12:19 | prisms | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 468 | 2022-10-16 09:50:23 | prisms | 3 | 112716 | 810 | 5.220 | 21593.1 |
| 467 | 2022-10-02 06:40:23 | prisms | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 466 | 2022-09-17 02:04:37 | prisms | 2 | 82551 | 90 | 2.106 | 39198.0 |
| 465 | 2022-09-10 16:30:56 | prisms | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 464 | 2022-09-05 13:02:56 | prisms | 3 | 112716 | 810 | 4.716 | 23900.8 |
| 463 | 2022-08-26 13:49:20 | prisms | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 462 | 2022-08-13 08:22:23 | prisms | 2 | 82551 | 90 | 2.173 | 37989.4 |
| 461 | 2022-07-31 07:19:52 | prisms | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 460 | 2022-07-26 01:25:22 | prisms | 3 | 112716 | 810 | 4.673 | 24120.7 |
| 459 | 2022-07-19 01:51:43 | prisms | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 458 | 2022-07-08 19:25:42 | prisms | 2 | 82551 | 90 | 2.140 | 38575.2 |
| 457 | 2022-05-18 14:17:59 | prisms | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 456 | 2022-04-21 22:13:14 | prisms | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 455 | 2022-03-26 08:49:43 | prisms | 1 | 48755 | 7 | 0.873 | 55847.7 |
| 454 | 2022-01-17 15:31:23 | prisms | 1 | 48755 | 7 | 1.330 | 36657.9 |
| 453 | 2021-12-02 11:19:34 | prisms | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 452 | 2021-11-09 07:04:30 | prisms | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 451 | 2021-10-13 15:25:31 | prisms | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 450 | 2021-08-27 10:02:57 | prisms | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 449 | 2021-08-22 19:01:07 | prisms | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 448 | 2021-07-31 17:44:17 | prisms | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 447 | 2021-07-21 23:49:12 | prisms | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 446 | 2021-06-18 13:37:39 | prisms | 3 | 112716 | 810 | 5.156 | 21861.1 |