History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"greener"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
569 | 2024-04-08 14:06:04 | greener | 1 | 69583 | 6 | 3.016 | 23071.3 |
568 | 2024-03-29 22:42:58 | greener | 1 | 69583 | 6 | 1.513 | 45990.1 |
567 | 2024-03-27 12:17:41 | greener | 2 | 107671 | 44 | 10.453 | 10300.5 |
566 | 2024-03-26 07:25:45 | greener | 2 | 107671 | 44 | 3.080 | 34958.1 |
565 | 2024-03-26 07:16:45 | greener | 3 | 134027 | 411 | 8.216 | 16312.9 |
564 | 2024-03-25 23:58:55 | greener | 1 | 69583 | 6 | 1.376 | 50569.0 |
563 | 2024-03-25 22:31:53 | greener | 2 | 107671 | 44 | 2.923 | 36835.8 |
562 | 2024-03-25 22:29:13 | greener | 3 | 134027 | 411 | 7.000 | 19146.7 |
561 | 2024-03-25 21:26:50 | greener | 3 | 134027 | 411 | 11.640 | 11514.3 |
560 | 2024-03-23 10:28:40 | greener | 3 | 134027 | 411 | 7.346 | 18244.9 |
559 | 2024-03-05 14:04:21 | greener | 1 | 69583 | 6 | 1.266 | 54962.9 |
558 | 2024-02-04 15:56:10 | greener | 3 | 134027 | 411 | 15.750 | 8509.7 |
557 | 2024-01-29 20:38:08 | greener | 3 | 134027 | 411 | 6.546 | 20474.6 |
556 | 2024-01-26 12:42:17 | greener | 3 | 134027 | 411 | 7.186 | 18651.1 |
555 | 2024-01-18 14:34:10 | greener | 3 | 134027 | 411 | 6.156 | 21771.8 |
554 | 2023-12-23 23:23:21 | greener | 1 | 69583 | 6 | 1.110 | 62687.4 |
553 | 2023-12-20 18:52:39 | greener | 1 | 69583 | 6 | 1.186 | 58670.3 |
552 | 2023-12-19 01:19:07 | greener | 1 | 69583 | 6 | 1.033 | 67360.1 |
551 | 2023-12-17 06:28:32 | greener | 1 | 69583 | 6 | 1.076 | 64668.2 |
550 | 2023-12-13 07:17:26 | greener | 1 | 69583 | 6 | 1.030 | 67556.3 |
549 | 2023-11-30 09:11:29 | greener | 3 | 134027 | 411 | 5.656 | 23696.4 |
548 | 2023-11-19 01:27:02 | greener | 1 | 69583 | 6 | 1.140 | 61037.7 |
547 | 2023-11-14 05:44:53 | greener | 1 | 69583 | 6 | 1.033 | 67360.1 |
546 | 2023-10-17 08:39:06 | greener | 1 | 69583 | 6 | 1.266 | 54962.9 |
545 | 2023-10-17 03:34:27 | greener | 1 | 69583 | 6 | 1.186 | 58670.3 |
544 | 2023-10-06 22:41:17 | greener | 1 | 69583 | 6 | 1.063 | 65459.1 |
543 | 2023-09-30 00:14:25 | greener | 1 | 69583 | 6 | 1.280 | 54361.7 |
542 | 2023-09-26 02:03:53 | greener | 1 | 69583 | 6 | 1.173 | 59320.5 |
541 | 2023-09-24 20:39:20 | greener | 1 | 69583 | 6 | 1.203 | 57841.2 |
540 | 2023-08-29 05:27:34 | greener | 3 | 134027 | 411 | 8.080 | 16587.5 |
539 | 2023-08-28 07:14:00 | greener | 1 | 69583 | 6 | 1.220 | 57035.2 |
538 | 2023-07-28 17:44:09 | greener | 1 | 69583 | 6 | 1.186 | 58670.3 |
537 | 2023-05-14 18:12:47 | greener | 1 | 69583 | 6 | 1.156 | 60192.9 |
536 | 2023-05-12 11:38:13 | greener | 3 | 134027 | 411 | 5.563 | 24092.6 |
535 | 2023-04-28 18:39:58 | greener | 1 | 69583 | 6 | 1.030 | 67556.3 |
534 | 2023-02-21 01:33:52 | greener | 3 | 134027 | 411 | 5.563 | 24092.6 |
533 | 2023-02-20 04:58:49 | greener | 1 | 69583 | 6 | 1.063 | 65459.1 |
532 | 2023-02-01 07:36:28 | greener | 1 | 69583 | 6 | 1.143 | 60877.5 |
531 | 2022-12-21 01:07:16 | greener | 1 | 69583 | 6 | 1.030 | 67556.3 |
530 | 2022-12-01 17:04:29 | greener | 3 | 134027 | 411 | 5.640 | 23763.7 |
529 | 2022-10-21 22:31:48 | greener | 1 | 69583 | 6 | 1.033 | 67360.1 |
528 | 2022-09-06 16:00:52 | greener | 1 | 69583 | 6 | 1.046 | 66522.9 |
527 | 2022-08-15 23:51:12 | greener | 1 | 69583 | 6 | 1.046 | 66522.9 |
526 | 2022-07-30 09:37:31 | greener | 1 | 69583 | 6 | 1.046 | 66522.9 |
525 | 2022-07-02 00:20:11 | greener | 1 | 69583 | 6 | 1.046 | 66522.9 |
524 | 2022-05-05 12:26:46 | greener | 1 | 69583 | 6 | 1.296 | 53690.6 |
523 | 2022-04-17 21:08:28 | greener | 1 | 69583 | 6 | 1.156 | 60192.9 |
522 | 2022-04-14 15:45:47 | greener | 3 | 134027 | 411 | 6.313 | 21230.3 |
521 | 2022-03-08 05:38:02 | greener | 1 | 69583 | 6 | 1.190 | 58473.1 |
520 | 2022-01-13 11:35:48 | greener | 1 | 69583 | 6 | 1.236 | 56296.9 |
519 | 2021-12-18 01:02:57 | greener | 3 | 134027 | 411 | 5.796 | 23124.1 |
518 | 2021-11-25 23:36:32 | greener | 1 | 69583 | 6 | 1.076 | 64668.2 |
517 | 2021-11-23 20:57:41 | greener | 1 | 69583 | 6 | 1.080 | 64428.7 |
516 | 2021-11-21 03:13:27 | greener | 1 | 69583 | 6 | 2.546 | 27330.3 |
515 | 2021-08-21 13:34:45 | greener | 1 | 69583 | 6 | 1.046 | 66522.9 |
514 | 2021-05-27 11:40:59 | greener | 1 | 69583 | 6 | 2.403 | 28956.7 |
513 | 2021-05-20 23:08:57 | greener | 1 | 69583 | 6 | 1.233 | 56433.9 |
512 | 2021-03-30 22:24:13 | greener | 1 | 69583 | 6 | 2.360 | 29484.3 |
511 | 2021-02-18 11:10:37 | greener | 1 | 69583 | 6 | 1.063 | 65459.1 |
510 | 2021-02-08 16:48:39 | greener | 1 | 69583 | 6 | 1.140 | 61037.7 |
509 | 2021-01-14 12:02:04 | greener | 1 | 69583 | 6 | 1.076 | 64668.2 |
508 | 2020-11-14 09:52:23 | greener | 1 | 69583 | 6 | 1.093 | 63662.4 |
507 | 2020-10-27 19:32:38 | greener | 1 | 69583 | 6 | 1.173 | 59320.5 |
506 | 2020-10-22 21:22:49 | greener | 1 | 69583 | 6 | 1.140 | 61037.7 |
505 | 2020-09-10 00:25:22 | greener | 1 | 69583 | 6 | 1.123 | 61961.7 |
504 | 2020-09-07 09:56:55 | greener | 1 | 69583 | 6 | 1.030 | 67556.3 |
503 | 2020-08-10 00:20:12 | greener | 1 | 69583 | 6 | 1.093 | 63662.4 |
502 | 2020-08-02 10:11:03 | greener | 1 | 69583 | 6 | 1.123 | 61961.7 |
501 | 2020-07-16 18:39:24 | greener | 1 | 69583 | 6 | 1.170 | 59472.6 |
500 | 2020-05-08 19:29:20 | greener | 1 | 69583 | 6 | 1.096 | 63488.1 |
499 | 2020-03-29 02:56:52 | greener | 1 | 69583 | 6 | 1.046 | 66522.9 |
498 | 2020-03-28 18:18:34 | greener | 1 | 69583 | 6 | 1.780 | 39091.6 |
497 | 2020-03-25 20:52:31 | greener | 1 | 69583 | 6 | 1.233 | 56433.9 |
496 | 2020-03-24 22:12:13 | greener | 1 | 69583 | 6 | 1.220 | 57035.2 |
495 | 2020-03-20 10:41:48 | greener | 1 | 69583 | 6 | 1.096 | 63488.1 |
494 | 2020-03-17 22:27:10 | greener | 1 | 69583 | 6 | 1.046 | 66522.9 |
493 | 2020-02-27 21:25:10 | greener | 3 | 134027 | 411 | 12.063 | 11110.6 |
492 | 2020-02-27 19:18:26 | greener | 3 | 134027 | 411 | 7.813 | 17154.4 |
491 | 2020-02-27 18:15:53 | greener | 3 | 134027 | 411 | 8.033 | 16684.6 |
490 | 2020-02-27 16:20:22 | greener | 3 | 134027 | 411 | 15.016 | 8925.6 |
489 | 2020-02-27 12:11:48 | greener | 3 | 134027 | 411 | 19.360 | 6922.9 |
488 | 2020-02-27 11:14:24 | greener | 3 | 134027 | 411 | 18.736 | 7153.4 |
487 | 2020-02-26 13:41:54 | greener | 1 | 69583 | 6 | 1.266 | 54962.9 |
486 | 2020-02-22 09:16:19 | greener | 1 | 69583 | 6 | 1.253 | 55533.1 |
485 | 2020-02-20 10:29:27 | greener | 1 | 69583 | 6 | 1.173 | 59320.5 |
484 | 2020-02-13 08:32:55 | greener | 1 | 69583 | 6 | 2.626 | 26497.7 |
483 | 2020-02-10 02:41:12 | greener | 1 | 69583 | 6 | 1.733 | 40151.8 |
482 | 2020-02-08 12:42:50 | greener | 1 | 69583 | 6 | 1.280 | 54361.7 |
481 | 2020-02-06 05:54:56 | greener | 1 | 69583 | 6 | 1.106 | 62914.1 |
480 | 2020-02-05 01:57:14 | greener | 1 | 69583 | 6 | 2.686 | 25905.8 |
479 | 2020-01-30 03:36:43 | greener | 1 | 69583 | 6 | 1.250 | 55666.4 |
478 | 2020-01-25 08:52:52 | greener | 1 | 69583 | 6 | 2.720 | 25582.0 |
477 | 2020-01-20 17:43:27 | greener | 1 | 69583 | 6 | 3.266 | 21305.3 |
476 | 2020-01-19 15:46:55 | greener | 1 | 69583 | 6 | 1.186 | 58670.3 |
475 | 2020-01-16 22:56:52 | greener | 1 | 69583 | 6 | 1.313 | 52995.4 |
474 | 2020-01-14 16:25:12 | greener | 3 | 134027 | 411 | 15.580 | 8602.5 |
473 | 2020-01-14 16:20:45 | greener | 3 | 134027 | 411 | 8.920 | 15025.4 |
472 | 2020-01-14 11:40:27 | greener | 3 | 134027 | 411 | 8.376 | 16001.3 |
471 | 2020-01-14 07:21:19 | greener | 1 | 69583 | 6 | 1.156 | 60192.9 |
470 | 2020-01-14 06:32:09 | greener | 1 | 69583 | 6 | 1.313 | 52995.4 |