History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"plant"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
598 | 2024-04-04 16:35:11 | plant | 1 | 28756 | 14 | 1.186 | 24246.2 |
597 | 2024-04-03 05:55:28 | plant | 1 | 28756 | 14 | 1.156 | 24875.4 |
596 | 2024-04-03 02:30:24 | plant | 2 | 53800 | 157 | 3.470 | 15504.3 |
595 | 2024-04-03 02:22:05 | plant | 1 | 28756 | 14 | 0.563 | 51076.4 |
594 | 2024-03-31 05:49:22 | plant | 2 | 53800 | 157 | 4.923 | 10928.3 |
593 | 2024-03-31 03:49:57 | plant | 1 | 28756 | 14 | 0.500 | 57512.0 |
592 | 2024-03-29 02:22:37 | plant | 1 | 28756 | 14 | 0.483 | 59536.2 |
591 | 2024-03-02 14:25:09 | plant | 1 | 28756 | 14 | 1.640 | 17534.1 |
590 | 2024-02-27 20:18:39 | plant | 1 | 28756 | 14 | 1.046 | 27491.4 |
589 | 2024-02-18 03:34:41 | plant | 1 | 28756 | 14 | 0.513 | 56054.6 |
588 | 2024-01-28 21:59:07 | plant | 1 | 28756 | 14 | 0.483 | 59536.2 |
587 | 2024-01-27 15:08:10 | plant | 1 | 28756 | 14 | 0.516 | 55728.7 |
586 | 2024-01-04 15:28:03 | plant | 2 | 53800 | 157 | 1.640 | 32804.9 |
585 | 2023-12-23 18:45:50 | plant | 2 | 53800 | 157 | 1.610 | 33416.1 |
584 | 2023-12-11 06:17:36 | plant | 2 | 53800 | 157 | 1.796 | 29955.5 |
583 | 2023-11-27 07:11:54 | plant | 2 | 53800 | 157 | 1.390 | 38705.0 |
582 | 2023-11-23 16:59:36 | plant | 1 | 28756 | 14 | 0.516 | 55728.7 |
581 | 2023-11-19 18:33:02 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
580 | 2023-11-12 16:18:45 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
579 | 2023-11-11 00:57:11 | plant | 1 | 28756 | 14 | 0.486 | 59168.7 |
578 | 2023-10-31 09:48:15 | plant | 1 | 28756 | 14 | 0.470 | 61183.0 |
577 | 2023-10-21 23:27:10 | plant | 1 | 28756 | 14 | 0.470 | 61183.0 |
576 | 2023-10-18 21:06:35 | plant | 1 | 28756 | 14 | 0.516 | 55728.7 |
575 | 2023-10-16 08:30:01 | plant | 1 | 28756 | 14 | 0.500 | 57512.0 |
574 | 2023-10-11 03:16:21 | plant | 1 | 28756 | 14 | 0.466 | 61708.2 |
573 | 2023-10-05 18:29:03 | plant | 1 | 28756 | 14 | 0.486 | 59168.7 |
572 | 2023-09-22 22:35:36 | plant | 1 | 28756 | 14 | 0.440 | 65354.5 |
571 | 2023-09-11 01:58:09 | plant | 1 | 28756 | 14 | 0.423 | 67981.1 |
570 | 2023-09-09 15:32:34 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
569 | 2023-08-31 00:53:45 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
568 | 2023-08-11 21:13:13 | plant | 1 | 28756 | 14 | 0.530 | 54256.6 |
567 | 2023-06-25 16:17:45 | plant | 1 | 28756 | 14 | 0.530 | 54256.6 |
566 | 2023-06-20 06:06:04 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
565 | 2023-06-16 07:48:35 | plant | 1 | 28756 | 14 | 0.483 | 59536.2 |
564 | 2023-05-22 08:02:38 | plant | 1 | 28756 | 14 | 0.466 | 61708.2 |
563 | 2023-04-28 02:28:37 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
562 | 2023-04-04 01:47:13 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
561 | 2023-04-02 00:05:46 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
560 | 2023-03-06 18:48:35 | plant | 1 | 28756 | 14 | 0.470 | 61183.0 |
559 | 2023-01-19 20:43:27 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
558 | 2023-01-13 18:16:07 | plant | 1 | 28756 | 14 | 0.440 | 65354.5 |
557 | 2023-01-13 09:51:28 | plant | 1 | 28756 | 14 | 1.000 | 28756.0 |
556 | 2022-11-29 15:13:11 | plant | 1 | 28756 | 14 | 0.420 | 68466.7 |
555 | 2022-11-29 06:46:04 | plant | 1 | 28756 | 14 | 0.500 | 57512.0 |
554 | 2022-11-24 02:59:03 | plant | 2 | 53800 | 157 | 1.596 | 33709.3 |
553 | 2022-11-16 05:20:16 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
552 | 2022-11-14 17:41:59 | plant | 1 | 28756 | 14 | 0.516 | 55728.7 |
551 | 2022-10-13 07:20:04 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
550 | 2022-10-12 22:54:18 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
549 | 2022-09-01 09:05:59 | plant | 1 | 28756 | 14 | 0.500 | 57512.0 |
548 | 2022-08-30 23:08:05 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
547 | 2022-08-30 11:30:10 | plant | 1 | 28756 | 14 | 0.516 | 55728.7 |
546 | 2022-07-25 14:01:35 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
545 | 2022-07-10 00:23:22 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
544 | 2022-07-09 20:04:33 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
543 | 2022-07-07 00:32:18 | plant | 1 | 28756 | 14 | 0.440 | 65354.5 |
542 | 2022-05-22 14:30:53 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
541 | 2022-05-22 08:54:57 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
540 | 2022-04-26 01:36:35 | plant | 2 | 53800 | 157 | 1.423 | 37807.4 |
539 | 2022-04-03 20:27:01 | plant | 1 | 28756 | 14 | 0.483 | 59536.2 |
538 | 2022-04-03 15:26:39 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
537 | 2022-04-03 13:12:41 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
536 | 2022-03-09 14:44:10 | plant | 1 | 28756 | 14 | 0.640 | 44931.3 |
535 | 2021-12-23 01:12:41 | plant | 1 | 28756 | 14 | 0.500 | 57512.0 |
534 | 2021-12-20 00:37:53 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
533 | 2021-12-18 00:18:13 | plant | 1 | 28756 | 14 | 0.500 | 57512.0 |
532 | 2021-11-22 17:52:56 | plant | 1 | 28756 | 14 | 0.500 | 57512.0 |
531 | 2021-11-10 17:18:52 | plant | 1 | 28756 | 14 | 0.440 | 65354.5 |
530 | 2021-10-25 01:34:46 | plant | 1 | 28756 | 14 | 0.470 | 61183.0 |
529 | 2021-10-20 23:09:53 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
528 | 2021-09-15 19:25:18 | plant | 1 | 28756 | 14 | 0.500 | 57512.0 |
527 | 2021-09-13 02:13:46 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
526 | 2021-08-26 11:29:29 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
525 | 2021-07-16 19:19:09 | plant | 1 | 28756 | 14 | 0.486 | 59168.7 |
524 | 2021-06-15 21:55:16 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
523 | 2021-05-31 12:38:40 | plant | 1 | 28756 | 14 | 0.533 | 53951.2 |
522 | 2021-05-06 01:54:15 | plant | 1 | 28756 | 14 | 0.500 | 57512.0 |
521 | 2021-04-04 11:07:50 | plant | 1 | 28756 | 14 | 0.530 | 54256.6 |
520 | 2021-04-04 04:46:52 | plant | 1 | 28756 | 14 | 0.516 | 55728.7 |
519 | 2021-03-28 10:24:03 | plant | 2 | 53800 | 157 | 1.406 | 38264.6 |
518 | 2021-03-16 12:53:12 | plant | 1 | 28756 | 14 | 0.516 | 55728.7 |
517 | 2021-03-08 20:13:32 | plant | 1 | 28756 | 14 | 0.516 | 55728.7 |
516 | 2021-01-19 14:27:33 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
515 | 2021-01-11 17:27:07 | plant | 2 | 53800 | 157 | 1.546 | 34799.5 |
514 | 2020-12-20 09:14:10 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
513 | 2020-12-13 13:16:11 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
512 | 2020-11-24 21:46:52 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
511 | 2020-11-24 16:59:46 | plant | 1 | 28756 | 14 | 0.876 | 32826.5 |
510 | 2020-10-26 15:56:45 | plant | 1 | 28756 | 14 | 0.513 | 56054.6 |
509 | 2020-10-24 15:07:05 | plant | 2 | 53800 | 157 | 1.393 | 38621.7 |
508 | 2020-10-16 17:10:02 | plant | 1 | 28756 | 14 | 0.436 | 65954.1 |
507 | 2020-10-15 19:59:31 | plant | 1 | 28756 | 14 | 0.500 | 57512.0 |
506 | 2020-10-04 22:58:01 | plant | 1 | 28756 | 14 | 0.893 | 32201.6 |
505 | 2020-09-13 07:03:52 | plant | 1 | 28756 | 14 | 0.420 | 68466.7 |
504 | 2020-08-27 21:47:10 | plant | 1 | 28756 | 14 | 0.500 | 57512.0 |
503 | 2020-08-26 07:06:50 | plant | 1 | 28756 | 14 | 0.453 | 63479.0 |
502 | 2020-08-24 23:48:33 | plant | 1 | 28756 | 14 | 0.530 | 54256.6 |
501 | 2020-08-15 00:44:31 | plant | 1 | 28756 | 14 | 0.440 | 65354.5 |
500 | 2020-07-31 11:34:08 | plant | 1 | 28756 | 14 | 0.940 | 30591.5 |
499 | 2020-07-29 01:44:59 | plant | 1 | 28756 | 14 | 0.513 | 56054.6 |