History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lilies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
594 | 2024-04-20 03:17:25 | lilies | 1 | 48755 | 2 | 1.140 | 42767.5 |
593 | 2024-03-27 17:18:47 | lilies | 1 | 48755 | 2 | 0.970 | 50262.9 |
592 | 2024-02-29 20:30:19 | lilies | 1 | 48755 | 2 | 0.893 | 54596.9 |
591 | 2024-02-25 05:40:56 | lilies | 1 | 48755 | 2 | 0.736 | 66243.2 |
590 | 2024-02-24 20:48:16 | lilies | 1 | 48755 | 2 | 0.936 | 52088.7 |
589 | 2024-02-20 21:46:37 | lilies | 1 | 48755 | 2 | 0.920 | 52994.6 |
588 | 2024-01-27 14:35:30 | lilies | 1 | 48755 | 2 | 0.843 | 57835.1 |
587 | 2024-01-09 01:22:26 | lilies | 2 | 82551 | 101 | 2.110 | 39123.7 |
586 | 2023-12-28 12:42:13 | lilies | 2 | 82551 | 101 | 2.423 | 34069.7 |
585 | 2023-12-27 23:38:16 | lilies | 2 | 82551 | 101 | 2.140 | 38575.2 |
584 | 2023-12-20 21:06:14 | lilies | 1 | 48755 | 2 | 0.873 | 55847.7 |
583 | 2023-11-29 22:39:59 | lilies | 2 | 82551 | 101 | 2.423 | 34069.7 |
582 | 2023-11-16 21:08:25 | lilies | 1 | 48755 | 2 | 0.876 | 55656.4 |
581 | 2023-11-13 03:46:48 | lilies | 1 | 48755 | 2 | 0.873 | 55847.7 |
580 | 2023-10-30 10:01:08 | lilies | 1 | 48755 | 2 | 0.750 | 65006.7 |
579 | 2023-10-25 22:10:02 | lilies | 1 | 48755 | 2 | 0.733 | 66514.3 |
578 | 2023-10-22 06:23:58 | lilies | 1 | 48755 | 2 | 0.826 | 59025.4 |
577 | 2023-10-18 11:45:22 | lilies | 1 | 48755 | 2 | 0.736 | 66243.2 |
576 | 2023-10-11 22:10:30 | lilies | 1 | 48755 | 2 | 0.826 | 59025.4 |
575 | 2023-10-09 06:29:34 | lilies | 1 | 48755 | 2 | 0.876 | 55656.4 |
574 | 2023-09-25 23:01:39 | lilies | 1 | 48755 | 2 | 0.843 | 57835.1 |
573 | 2023-09-24 05:35:01 | lilies | 1 | 48755 | 2 | 2.780 | 17537.8 |
572 | 2023-08-05 04:44:04 | lilies | 1 | 48755 | 2 | 0.733 | 66514.3 |
571 | 2023-07-12 23:51:34 | lilies | 1 | 48755 | 2 | 0.810 | 60191.4 |
570 | 2023-05-05 23:58:22 | lilies | 1 | 48755 | 2 | 0.733 | 66514.3 |
569 | 2023-04-05 10:57:13 | lilies | 1 | 48755 | 2 | 0.830 | 58741.0 |
568 | 2023-03-01 08:57:08 | lilies | 1 | 48755 | 2 | 1.623 | 30040.0 |
567 | 2022-12-31 05:24:26 | lilies | 1 | 48755 | 2 | 0.720 | 67715.3 |
566 | 2022-12-27 00:08:10 | lilies | 1 | 48755 | 2 | 0.720 | 67715.3 |
565 | 2022-09-16 18:10:51 | lilies | 1 | 48755 | 2 | 0.793 | 61481.7 |
564 | 2022-09-15 00:28:10 | lilies | 1 | 48755 | 2 | 0.750 | 65006.7 |
563 | 2022-07-01 13:08:04 | lilies | 1 | 48755 | 2 | 0.750 | 65006.7 |
562 | 2022-06-29 06:04:17 | lilies | 1 | 48755 | 2 | 0.733 | 66514.3 |
561 | 2022-06-18 21:03:43 | lilies | 2 | 82551 | 101 | 2.643 | 31233.8 |
560 | 2022-05-28 02:34:03 | lilies | 1 | 48755 | 2 | 0.923 | 52822.3 |
559 | 2022-05-01 18:32:57 | lilies | 2 | 82551 | 101 | 2.453 | 33653.1 |
558 | 2022-03-02 02:31:56 | lilies | 1 | 48755 | 2 | 1.030 | 47335.0 |
557 | 2022-02-13 11:01:33 | lilies | 2 | 82551 | 101 | 2.360 | 34979.2 |
556 | 2022-02-13 06:01:41 | lilies | 1 | 48755 | 2 | 0.750 | 65006.7 |
555 | 2022-02-12 15:37:45 | lilies | 2 | 82551 | 101 | 2.406 | 34310.5 |
554 | 2022-02-11 20:47:16 | lilies | 2 | 82551 | 101 | 2.140 | 38575.2 |
553 | 2022-02-11 06:20:54 | lilies | 2 | 82551 | 101 | 2.576 | 32046.2 |
552 | 2022-02-07 09:46:02 | lilies | 2 | 82551 | 101 | 2.123 | 38884.1 |
551 | 2022-02-06 17:07:30 | lilies | 2 | 82551 | 101 | 2.110 | 39123.7 |
550 | 2022-02-05 17:54:51 | lilies | 2 | 82551 | 101 | 2.170 | 38041.9 |
549 | 2022-02-05 01:24:21 | lilies | 2 | 82551 | 101 | 2.140 | 38575.2 |
548 | 2022-02-04 14:16:07 | lilies | 2 | 82551 | 101 | 2.643 | 31233.8 |
547 | 2022-02-03 23:28:03 | lilies | 2 | 82551 | 101 | 2.656 | 31080.9 |
546 | 2022-02-03 11:22:57 | lilies | 2 | 82551 | 101 | 2.500 | 33020.4 |
545 | 2022-02-03 03:40:50 | lilies | 2 | 82551 | 101 | 2.406 | 34310.5 |
544 | 2022-02-02 11:13:27 | lilies | 2 | 82551 | 101 | 2.376 | 34743.7 |
543 | 2022-02-01 13:12:32 | lilies | 2 | 82551 | 101 | 2.250 | 36689.3 |
542 | 2022-02-01 02:27:50 | lilies | 2 | 82551 | 101 | 2.203 | 37472.1 |
541 | 2022-01-31 10:19:38 | lilies | 2 | 82551 | 101 | 2.170 | 38041.9 |
540 | 2022-01-30 21:22:04 | lilies | 2 | 82551 | 101 | 2.296 | 35954.3 |
539 | 2022-01-30 08:54:53 | lilies | 2 | 82551 | 101 | 2.470 | 33421.5 |
538 | 2022-01-29 23:25:42 | lilies | 1 | 48755 | 2 | 0.830 | 58741.0 |
537 | 2022-01-29 15:25:23 | lilies | 2 | 82551 | 101 | 2.563 | 32208.7 |
536 | 2022-01-28 12:41:21 | lilies | 2 | 82551 | 101 | 2.453 | 33653.1 |
535 | 2022-01-27 21:45:16 | lilies | 2 | 82551 | 101 | 2.530 | 32628.9 |
534 | 2022-01-27 02:49:29 | lilies | 2 | 82551 | 101 | 2.296 | 35954.3 |
533 | 2022-01-26 18:56:08 | lilies | 2 | 82551 | 101 | 2.376 | 34743.7 |
532 | 2022-01-26 07:39:19 | lilies | 2 | 82551 | 101 | 2.156 | 38289.0 |
531 | 2022-01-25 14:05:48 | lilies | 2 | 82551 | 101 | 2.546 | 32423.8 |
530 | 2022-01-25 02:06:44 | lilies | 2 | 82551 | 101 | 2.313 | 35690.0 |
529 | 2022-01-24 07:47:30 | lilies | 2 | 82551 | 101 | 2.390 | 34540.2 |
528 | 2022-01-23 17:54:50 | lilies | 2 | 82551 | 101 | 2.203 | 37472.1 |
527 | 2022-01-21 16:07:56 | lilies | 2 | 82551 | 101 | 2.640 | 31269.3 |
526 | 2022-01-21 04:26:07 | lilies | 2 | 82551 | 101 | 2.376 | 34743.7 |
525 | 2022-01-20 18:28:59 | lilies | 2 | 82551 | 101 | 2.500 | 33020.4 |
524 | 2022-01-20 08:34:51 | lilies | 2 | 82551 | 101 | 2.373 | 34787.6 |
523 | 2022-01-19 20:52:02 | lilies | 2 | 82551 | 101 | 2.686 | 30733.8 |
522 | 2022-01-19 09:19:44 | lilies | 2 | 82551 | 101 | 2.610 | 31628.7 |
521 | 2022-01-18 18:07:55 | lilies | 2 | 82551 | 101 | 2.466 | 33475.7 |
520 | 2022-01-18 00:35:42 | lilies | 2 | 82551 | 101 | 2.140 | 38575.2 |
519 | 2022-01-16 21:30:38 | lilies | 2 | 82551 | 101 | 2.440 | 33832.4 |
518 | 2022-01-08 22:06:03 | lilies | 2 | 82551 | 101 | 2.486 | 33206.4 |
517 | 2022-01-08 06:32:23 | lilies | 2 | 82551 | 101 | 2.123 | 38884.1 |
516 | 2022-01-07 18:11:53 | lilies | 2 | 82551 | 101 | 2.640 | 31269.3 |
515 | 2022-01-07 07:32:17 | lilies | 2 | 82551 | 101 | 2.576 | 32046.2 |
514 | 2022-01-05 13:03:58 | lilies | 2 | 82551 | 101 | 2.500 | 33020.4 |
513 | 2022-01-04 19:38:25 | lilies | 2 | 82551 | 101 | 2.580 | 31996.5 |
512 | 2021-12-23 14:38:52 | lilies | 2 | 82551 | 101 | 2.406 | 34310.5 |
511 | 2021-12-23 04:11:04 | lilies | 2 | 82551 | 101 | 2.280 | 36206.6 |
510 | 2021-12-22 20:35:38 | lilies | 2 | 82551 | 101 | 5.596 | 14751.8 |
509 | 2021-12-22 12:29:24 | lilies | 2 | 82551 | 101 | 2.640 | 31269.3 |
508 | 2021-12-22 01:59:27 | lilies | 2 | 82551 | 101 | 2.483 | 33246.5 |
507 | 2021-12-21 19:19:20 | lilies | 2 | 82551 | 101 | 2.453 | 33653.1 |
506 | 2021-12-21 08:51:27 | lilies | 2 | 82551 | 101 | 2.250 | 36689.3 |
505 | 2021-12-20 21:30:15 | lilies | 2 | 82551 | 101 | 2.236 | 36919.1 |
504 | 2021-12-20 10:12:52 | lilies | 2 | 82551 | 101 | 2.423 | 34069.7 |
503 | 2021-12-20 03:35:17 | lilies | 2 | 82551 | 101 | 2.483 | 33246.5 |
502 | 2021-12-19 17:48:07 | lilies | 2 | 82551 | 101 | 2.420 | 34112.0 |
501 | 2021-12-19 05:59:37 | lilies | 2 | 82551 | 101 | 2.453 | 33653.1 |
500 | 2021-12-18 19:12:53 | lilies | 2 | 82551 | 101 | 2.623 | 31472.0 |
499 | 2021-12-17 06:32:13 | lilies | 2 | 82551 | 101 | 2.736 | 30172.1 |
498 | 2021-12-16 20:24:07 | lilies | 1 | 48755 | 2 | 0.813 | 59969.2 |
497 | 2021-12-16 10:47:45 | lilies | 2 | 82551 | 101 | 2.096 | 39385.0 |
496 | 2021-12-15 21:43:48 | lilies | 2 | 82551 | 101 | 2.516 | 32810.4 |
495 | 2021-12-15 05:13:02 | lilies | 2 | 82551 | 101 | 2.453 | 33653.1 |