History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sapwood"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
553 | 2024-05-08 22:14:12 | sapwood | 1 | 69583 | 2 | 1.376 | 50569.0 |
552 | 2024-04-07 15:18:53 | sapwood | 1 | 69583 | 2 | 4.700 | 14804.9 |
551 | 2024-04-05 13:54:25 | sapwood | 1 | 69583 | 2 | 2.033 | 34226.8 |
550 | 2024-03-28 14:04:40 | sapwood | 1 | 69583 | 2 | 1.330 | 52318.0 |
549 | 2024-03-25 03:35:06 | sapwood | 4 | 151207 | 892 | 10.453 | 14465.4 |
548 | 2024-03-23 15:35:09 | sapwood | 1 | 69583 | 2 | 1.153 | 60349.5 |
547 | 2024-03-19 22:04:54 | sapwood | 2 | 107671 | 7 | 2.936 | 36672.7 |
546 | 2024-03-19 22:03:35 | sapwood | 3 | 134027 | 84 | 7.500 | 17870.3 |
545 | 2024-03-19 16:47:11 | sapwood | 4 | 151207 | 892 | 13.533 | 11173.2 |
544 | 2024-03-19 16:37:49 | sapwood | 4 | 151207 | 892 | 16.703 | 9052.7 |
543 | 2024-03-19 08:19:39 | sapwood | 3 | 134027 | 84 | 16.423 | 8160.9 |
542 | 2024-03-18 21:38:24 | sapwood | 4 | 151207 | 892 | 24.173 | 6255.2 |
541 | 2024-03-18 11:53:31 | sapwood | 2 | 107671 | 7 | 3.750 | 28712.3 |
540 | 2024-03-18 11:52:57 | sapwood | 3 | 134027 | 84 | 7.796 | 17191.8 |
539 | 2024-03-18 11:06:44 | sapwood | 4 | 151207 | 892 | 13.000 | 11631.3 |
538 | 2024-03-18 09:32:10 | sapwood | 3 | 134027 | 84 | 11.283 | 11878.7 |
537 | 2024-03-18 09:32:06 | sapwood | 4 | 151207 | 892 | 12.423 | 12171.5 |
536 | 2024-03-18 09:32:12 | sapwood | 2 | 107671 | 7 | 3.703 | 29076.7 |
535 | 2024-03-18 09:31:59 | sapwood | 1 | 69583 | 2 | 2.813 | 24736.2 |
534 | 2024-02-28 16:50:37 | sapwood | 1 | 69583 | 2 | 2.203 | 31585.6 |
533 | 2024-02-14 22:51:17 | sapwood | 1 | 69583 | 2 | 4.046 | 17198.0 |
532 | 2024-02-09 18:36:52 | sapwood | 4 | 151207 | 892 | 18.140 | 8335.6 |
531 | 2024-02-09 18:36:51 | sapwood | 3 | 134027 | 84 | 7.703 | 17399.3 |
530 | 2024-02-09 18:36:45 | sapwood | 2 | 107671 | 7 | 4.126 | 26095.7 |
529 | 2024-02-07 14:18:25 | sapwood | 4 | 151207 | 892 | 20.690 | 7308.2 |
528 | 2024-02-07 06:31:38 | sapwood | 4 | 151207 | 892 | 12.296 | 12297.3 |
527 | 2024-02-07 05:16:39 | sapwood | 4 | 151207 | 892 | 22.096 | 6843.2 |
526 | 2024-02-07 05:10:22 | sapwood | 4 | 151207 | 892 | 11.453 | 13202.4 |
525 | 2024-02-07 05:10:26 | sapwood | 2 | 107671 | 7 | 3.500 | 30763.1 |
524 | 2024-02-07 05:09:46 | sapwood | 3 | 134027 | 84 | 6.936 | 19323.4 |
523 | 2024-02-01 20:20:57 | sapwood | 1 | 69583 | 2 | 1.110 | 62687.4 |
522 | 2024-01-26 08:57:45 | sapwood | 3 | 134027 | 84 | 14.660 | 9142.4 |
521 | 2024-01-25 21:58:43 | sapwood | 3 | 134027 | 84 | 10.060 | 13322.8 |
520 | 2024-01-14 02:39:20 | sapwood | 3 | 134027 | 84 | 5.970 | 22450.1 |
519 | 2024-01-07 16:32:59 | sapwood | 1 | 69583 | 2 | 1.266 | 54962.9 |
518 | 2023-12-20 05:35:23 | sapwood | 1 | 69583 | 2 | 1.123 | 61961.7 |
517 | 2023-11-25 03:50:49 | sapwood | 1 | 69583 | 2 | 2.673 | 26031.8 |
516 | 2023-10-28 09:58:56 | sapwood | 1 | 69583 | 2 | 1.173 | 59320.5 |
515 | 2023-10-28 06:40:13 | sapwood | 1 | 69583 | 2 | 1.266 | 54962.9 |
514 | 2023-10-25 03:06:41 | sapwood | 1 | 69583 | 2 | 1.266 | 54962.9 |
513 | 2023-10-22 19:49:32 | sapwood | 3 | 134027 | 84 | 5.843 | 22938.0 |
512 | 2023-10-15 03:44:09 | sapwood | 1 | 69583 | 2 | 1.096 | 63488.1 |
511 | 2023-10-07 16:34:41 | sapwood | 1 | 69583 | 2 | 1.673 | 41591.8 |
510 | 2023-10-07 09:24:30 | sapwood | 1 | 69583 | 2 | 1.093 | 63662.4 |
509 | 2023-09-27 04:59:31 | sapwood | 1 | 69583 | 2 | 1.376 | 50569.0 |
508 | 2023-09-22 02:14:09 | sapwood | 1 | 69583 | 2 | 1.220 | 57035.2 |
507 | 2023-08-03 10:34:06 | sapwood | 1 | 69583 | 2 | 1.220 | 57035.2 |
506 | 2023-08-01 14:49:58 | sapwood | 3 | 134027 | 84 | 6.376 | 21020.5 |
505 | 2023-06-23 11:31:11 | sapwood | 1 | 69583 | 2 | 1.140 | 61037.7 |
504 | 2023-04-30 14:39:58 | sapwood | 1 | 69583 | 2 | 1.143 | 60877.5 |
503 | 2023-04-08 23:36:56 | sapwood | 3 | 134027 | 84 | 13.030 | 10286.0 |
502 | 2023-02-22 09:35:40 | sapwood | 1 | 69583 | 2 | 1.123 | 61961.7 |
501 | 2023-02-21 15:00:00 | sapwood | 1 | 69583 | 2 | 1.110 | 62687.4 |
500 | 2023-01-06 05:42:29 | sapwood | 3 | 134027 | 84 | 6.576 | 20381.2 |
499 | 2022-12-17 21:54:31 | sapwood | 1 | 69583 | 2 | 1.093 | 63662.4 |
498 | 2022-10-18 13:00:58 | sapwood | 1 | 69583 | 2 | 1.106 | 62914.1 |
497 | 2022-10-14 19:42:16 | sapwood | 1 | 69583 | 2 | 1.110 | 62687.4 |
496 | 2022-09-09 15:13:01 | sapwood | 3 | 134027 | 84 | 5.940 | 22563.5 |
495 | 2022-08-26 05:41:35 | sapwood | 1 | 69583 | 2 | 1.126 | 61796.6 |
494 | 2022-06-30 10:54:05 | sapwood | 2 | 107671 | 7 | 3.186 | 33795.0 |
493 | 2022-06-13 07:17:45 | sapwood | 1 | 69583 | 2 | 1.123 | 61961.7 |
492 | 2022-04-13 09:28:03 | sapwood | 1 | 69583 | 2 | 1.800 | 38657.2 |
491 | 2022-03-28 20:07:56 | sapwood | 3 | 134027 | 84 | 12.420 | 10791.2 |
490 | 2022-01-29 08:59:16 | sapwood | 1 | 69583 | 2 | 1.470 | 47335.4 |
489 | 2022-01-11 05:19:42 | sapwood | 1 | 69583 | 2 | 1.263 | 55093.4 |
488 | 2022-01-09 01:47:16 | sapwood | 1 | 69583 | 2 | 1.156 | 60192.9 |
487 | 2022-01-05 12:42:13 | sapwood | 4 | 151207 | 892 | 11.033 | 13705.0 |
486 | 2021-11-03 02:23:58 | sapwood | 1 | 69583 | 2 | 1.173 | 59320.5 |
485 | 2021-10-12 14:33:03 | sapwood | 1 | 69583 | 2 | 2.560 | 27180.9 |
484 | 2021-10-09 12:08:55 | sapwood | 1 | 69583 | 2 | 1.126 | 61796.6 |
483 | 2021-07-11 11:47:27 | sapwood | 1 | 69583 | 2 | 1.326 | 52475.9 |
482 | 2021-04-29 04:45:19 | sapwood | 1 | 69583 | 2 | 2.500 | 27833.2 |
481 | 2021-04-13 19:17:41 | sapwood | 2 | 107671 | 7 | 3.593 | 29966.9 |
480 | 2021-04-07 13:10:39 | sapwood | 1 | 69583 | 2 | 1.283 | 54234.6 |
479 | 2021-04-03 09:31:56 | sapwood | 1 | 69583 | 2 | 1.233 | 56433.9 |
478 | 2021-03-28 20:25:30 | sapwood | 1 | 69583 | 2 | 1.126 | 61796.6 |
477 | 2021-01-27 11:58:05 | sapwood | 2 | 107671 | 7 | 3.373 | 31921.4 |
476 | 2021-01-12 15:13:40 | sapwood | 1 | 69583 | 2 | 1.156 | 60192.9 |
475 | 2020-12-11 06:20:23 | sapwood | 1 | 69583 | 2 | 1.110 | 62687.4 |
474 | 2020-11-10 06:07:06 | sapwood | 2 | 107671 | 7 | 3.080 | 34958.1 |
473 | 2020-11-01 03:12:44 | sapwood | 4 | 151207 | 892 | 10.110 | 14956.2 |
472 | 2020-10-25 02:19:17 | sapwood | 1 | 69583 | 2 | 1.186 | 58670.3 |
471 | 2020-10-24 22:06:00 | sapwood | 1 | 69583 | 2 | 1.283 | 54234.6 |
470 | 2020-10-22 00:26:17 | sapwood | 1 | 69583 | 2 | 1.296 | 53690.6 |
469 | 2020-09-27 16:29:14 | sapwood | 1 | 69583 | 2 | 1.093 | 63662.4 |
468 | 2020-09-01 01:32:01 | sapwood | 1 | 69583 | 2 | 1.156 | 60192.9 |
467 | 2020-08-28 20:39:47 | sapwood | 1 | 69583 | 2 | 1.296 | 53690.6 |
466 | 2020-08-14 12:19:05 | sapwood | 1 | 69583 | 2 | 1.140 | 61037.7 |
465 | 2020-07-25 07:41:34 | sapwood | 1 | 69583 | 2 | 1.173 | 59320.5 |
464 | 2020-07-11 06:06:59 | sapwood | 1 | 69583 | 2 | 1.173 | 59320.5 |
463 | 2020-05-21 05:00:57 | sapwood | 1 | 69583 | 2 | 1.106 | 62914.1 |
462 | 2020-03-29 22:29:50 | sapwood | 1 | 69583 | 2 | 1.173 | 59320.5 |
461 | 2020-03-25 05:39:31 | sapwood | 1 | 69583 | 2 | 1.190 | 58473.1 |
460 | 2020-03-25 00:54:03 | sapwood | 1 | 69583 | 2 | 1.330 | 52318.0 |
459 | 2020-03-21 06:08:43 | sapwood | 1 | 69583 | 2 | 1.250 | 55666.4 |
458 | 2020-02-24 12:27:33 | sapwood | 1 | 69583 | 2 | 1.220 | 57035.2 |
457 | 2020-02-24 09:03:00 | sapwood | 1 | 69583 | 2 | 1.326 | 52475.9 |
456 | 2020-02-23 01:04:25 | sapwood | 1 | 69583 | 2 | 1.326 | 52475.9 |
455 | 2020-02-12 06:51:45 | sapwood | 1 | 69583 | 2 | 1.530 | 45479.1 |
454 | 2020-02-11 23:14:38 | sapwood | 1 | 69583 | 2 | 2.830 | 24587.6 |