History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cannas"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 550 | 2024-04-27 05:50:49 | cannas | 2 | 82551 | 100 | 2.860 | 28864.0 |
| 549 | 2024-04-27 05:50:43 | cannas | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 548 | 2024-04-27 05:50:12 | cannas | 3 | 112716 | 1059 | 5.703 | 19764.3 |
| 547 | 2024-04-27 00:19:22 | cannas | 1 | 48755 | 5 | 1.013 | 48129.3 |
| 546 | 2024-04-26 15:15:12 | cannas | 3 | 112716 | 1059 | 4.953 | 22757.1 |
| 545 | 2024-04-24 22:01:26 | cannas | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 544 | 2024-04-03 05:42:19 | cannas | 1 | 48755 | 5 | 1.013 | 48129.3 |
| 543 | 2024-03-31 06:50:01 | cannas | 1 | 48755 | 5 | 1.983 | 24586.5 |
| 542 | 2024-03-28 15:00:03 | cannas | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 541 | 2024-03-27 21:55:13 | cannas | 1 | 48755 | 5 | 0.986 | 49447.3 |
| 540 | 2024-03-01 11:40:13 | cannas | 2 | 82551 | 100 | 2.813 | 29346.2 |
| 539 | 2024-02-29 17:43:39 | cannas | 2 | 82551 | 100 | 5.560 | 14847.3 |
| 538 | 2024-02-29 17:42:45 | cannas | 3 | 112716 | 1059 | 5.936 | 18988.5 |
| 537 | 2024-02-28 10:27:21 | cannas | 1 | 48755 | 5 | 3.046 | 16006.2 |
| 536 | 2024-02-27 04:35:17 | cannas | 3 | 112716 | 1059 | 13.906 | 8105.6 |
| 535 | 2024-02-27 04:35:18 | cannas | 2 | 82551 | 100 | 5.060 | 16314.4 |
| 534 | 2024-02-26 20:11:50 | cannas | 3 | 112716 | 1059 | 6.173 | 18259.5 |
| 533 | 2024-02-26 20:11:50 | cannas | 2 | 82551 | 100 | 3.466 | 23817.4 |
| 532 | 2024-02-26 20:11:47 | cannas | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 531 | 2023-12-27 19:54:30 | cannas | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 530 | 2023-12-24 07:09:33 | cannas | 2 | 82551 | 100 | 2.530 | 32628.9 |
| 529 | 2023-12-22 06:23:49 | cannas | 3 | 112716 | 1059 | 7.376 | 15281.5 |
| 528 | 2023-12-22 06:23:52 | cannas | 2 | 82551 | 100 | 2.903 | 28436.4 |
| 527 | 2023-12-20 15:38:37 | cannas | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 526 | 2023-12-14 08:10:44 | cannas | 3 | 112716 | 1059 | 5.220 | 21593.1 |
| 525 | 2023-12-14 08:10:42 | cannas | 2 | 82551 | 100 | 2.310 | 35736.4 |
| 524 | 2023-11-30 06:31:27 | cannas | 2 | 82551 | 100 | 2.673 | 30883.3 |
| 523 | 2023-11-28 05:04:07 | cannas | 1 | 48755 | 5 | 1.970 | 24748.7 |
| 522 | 2023-11-26 14:49:11 | cannas | 3 | 112716 | 1059 | 6.050 | 18630.7 |
| 521 | 2023-11-25 00:44:04 | cannas | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 520 | 2023-11-21 01:49:44 | cannas | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 519 | 2023-11-11 07:37:47 | cannas | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 518 | 2023-11-01 03:50:12 | cannas | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 517 | 2023-10-29 17:49:00 | cannas | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 516 | 2023-10-22 01:31:41 | cannas | 3 | 112716 | 1059 | 11.860 | 9503.9 |
| 515 | 2023-10-22 01:31:40 | cannas | 2 | 82551 | 100 | 2.550 | 32372.9 |
| 514 | 2023-10-17 00:20:06 | cannas | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 513 | 2023-10-13 12:21:17 | cannas | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 512 | 2023-10-07 16:28:09 | cannas | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 511 | 2023-10-04 11:44:10 | cannas | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 510 | 2023-09-29 00:15:47 | cannas | 3 | 112716 | 1059 | 6.170 | 18268.4 |
| 509 | 2023-09-24 08:47:34 | cannas | 3 | 112716 | 1059 | 5.076 | 22205.7 |
| 508 | 2023-09-24 08:47:25 | cannas | 2 | 82551 | 100 | 2.873 | 28733.4 |
| 507 | 2023-09-23 20:00:30 | cannas | 2 | 82551 | 100 | 2.580 | 31996.5 |
| 506 | 2023-09-19 10:51:54 | cannas | 1 | 48755 | 5 | 1.156 | 42175.6 |
| 505 | 2023-09-12 19:58:01 | cannas | 1 | 48755 | 5 | 0.893 | 54596.9 |
| 504 | 2023-08-05 05:35:49 | cannas | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 503 | 2023-08-03 07:50:25 | cannas | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 502 | 2023-06-27 07:16:44 | cannas | 2 | 82551 | 100 | 2.263 | 36478.6 |
| 501 | 2023-05-02 14:54:55 | cannas | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 500 | 2023-04-24 01:23:10 | cannas | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 499 | 2023-03-20 15:04:27 | cannas | 2 | 82551 | 100 | 2.170 | 38041.9 |
| 498 | 2023-02-22 22:57:22 | cannas | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 497 | 2023-01-11 16:40:23 | cannas | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 496 | 2022-12-22 02:53:12 | cannas | 2 | 82551 | 100 | 2.470 | 33421.5 |
| 495 | 2022-12-20 09:22:23 | cannas | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 494 | 2022-10-01 09:59:59 | cannas | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 493 | 2022-09-04 22:22:38 | cannas | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 492 | 2022-09-02 18:15:26 | cannas | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 491 | 2022-08-20 01:47:50 | cannas | 2 | 82551 | 100 | 2.470 | 33421.5 |
| 490 | 2022-06-30 19:19:34 | cannas | 3 | 112716 | 1059 | 4.736 | 23799.8 |
| 489 | 2022-06-30 02:47:18 | cannas | 3 | 112716 | 1059 | 4.876 | 23116.5 |
| 488 | 2022-06-29 13:17:32 | cannas | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 487 | 2022-06-14 10:08:53 | cannas | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 486 | 2022-04-13 19:23:04 | cannas | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 485 | 2022-04-11 14:25:36 | cannas | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 484 | 2022-03-02 15:32:07 | cannas | 1 | 48755 | 5 | 0.986 | 49447.3 |
| 483 | 2022-01-07 10:17:02 | cannas | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 482 | 2022-01-05 07:27:30 | cannas | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 481 | 2022-01-03 00:05:04 | cannas | 1 | 48755 | 5 | 2.140 | 22782.7 |
| 480 | 2021-11-25 18:23:38 | cannas | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 479 | 2021-11-01 11:40:26 | cannas | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 478 | 2021-09-18 19:27:40 | cannas | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 477 | 2021-08-27 22:28:49 | cannas | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 476 | 2021-08-25 17:49:16 | cannas | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 475 | 2021-08-22 21:15:02 | cannas | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 474 | 2021-08-12 17:19:16 | cannas | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 473 | 2021-07-04 06:47:42 | cannas | 1 | 48755 | 5 | 0.986 | 49447.3 |
| 472 | 2021-06-27 11:53:51 | cannas | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 471 | 2021-06-26 07:47:16 | cannas | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 470 | 2021-06-15 00:23:52 | cannas | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 469 | 2021-05-12 02:20:44 | cannas | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 468 | 2021-04-07 15:17:45 | cannas | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 467 | 2021-02-23 10:37:47 | cannas | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 466 | 2021-02-14 22:37:58 | cannas | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 465 | 2021-02-07 17:50:36 | cannas | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 464 | 2021-02-02 18:41:28 | cannas | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 463 | 2021-01-29 13:35:55 | cannas | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 462 | 2020-11-27 11:35:45 | cannas | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 461 | 2020-11-02 11:20:06 | cannas | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 460 | 2020-10-30 18:18:12 | cannas | 1 | 48755 | 5 | 1.550 | 31454.8 |
| 459 | 2020-10-26 19:09:48 | cannas | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 458 | 2020-10-21 23:05:42 | cannas | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 457 | 2020-10-17 19:14:22 | cannas | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 456 | 2020-09-16 19:49:21 | cannas | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 455 | 2020-08-02 23:18:01 | cannas | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 454 | 2020-07-22 23:53:15 | cannas | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 453 | 2020-07-20 17:12:26 | cannas | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 452 | 2020-04-21 00:24:00 | cannas | 1 | 48755 | 5 | 0.800 | 60943.8 |
| 451 | 2020-04-16 23:23:12 | cannas | 1 | 48755 | 5 | 0.860 | 56691.9 |