History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"approve"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
537 | 2024-04-16 07:05:23 | approve | 1 | 69583 | 4 | 1.280 | 54361.7 |
536 | 2024-04-13 16:14:08 | approve | 2 | 107671 | 13 | 2.903 | 37089.6 |
535 | 2024-04-08 15:28:27 | approve | 2 | 107671 | 13 | 3.516 | 30623.2 |
534 | 2024-04-05 18:53:28 | approve | 2 | 107671 | 13 | 4.783 | 22511.2 |
533 | 2024-04-05 18:51:48 | approve | 3 | 134027 | 104 | 8.846 | 15151.1 |
532 | 2024-04-01 00:54:14 | approve | 1 | 69583 | 4 | 1.486 | 46825.7 |
531 | 2024-04-01 00:54:04 | approve | 2 | 107671 | 13 | 3.686 | 29210.8 |
530 | 2024-04-01 00:53:42 | approve | 3 | 134027 | 104 | 17.906 | 7485.0 |
529 | 2024-03-31 05:55:47 | approve | 1 | 69583 | 4 | 4.076 | 17071.4 |
528 | 2024-03-31 04:28:20 | approve | 2 | 107671 | 13 | 4.670 | 23055.9 |
527 | 2024-03-30 00:58:47 | approve | 3 | 134027 | 104 | 20.986 | 6386.5 |
526 | 2024-03-29 04:58:45 | approve | 3 | 134027 | 104 | 20.406 | 6568.0 |
525 | 2024-03-29 01:29:49 | approve | 3 | 134027 | 104 | 20.673 | 6483.2 |
524 | 2024-03-29 01:29:49 | approve | 2 | 107671 | 13 | 8.280 | 13003.7 |
523 | 2024-03-29 01:10:48 | approve | 1 | 69583 | 4 | 2.000 | 34791.5 |
522 | 2024-03-10 14:11:43 | approve | 1 | 69583 | 4 | 3.610 | 19275.1 |
521 | 2024-02-27 22:06:22 | approve | 1 | 69583 | 4 | 1.296 | 53690.6 |
520 | 2024-01-01 19:33:00 | approve | 1 | 69583 | 4 | 1.093 | 63662.4 |
519 | 2023-12-16 15:10:09 | approve | 1 | 69583 | 4 | 1.233 | 56433.9 |
518 | 2023-12-12 02:22:13 | approve | 2 | 107671 | 13 | 2.783 | 38688.8 |
517 | 2023-12-01 21:56:40 | approve | 1 | 69583 | 4 | 1.346 | 51696.1 |
516 | 2023-11-23 11:40:32 | approve | 1 | 69583 | 4 | 1.093 | 63662.4 |
515 | 2023-11-21 21:48:53 | approve | 1 | 69583 | 4 | 1.096 | 63488.1 |
514 | 2023-11-07 09:13:59 | approve | 1 | 69583 | 4 | 1.156 | 60192.9 |
513 | 2023-10-24 19:26:59 | approve | 1 | 69583 | 4 | 1.250 | 55666.4 |
512 | 2023-10-24 02:33:03 | approve | 1 | 69583 | 4 | 1.250 | 55666.4 |
511 | 2023-10-13 06:13:39 | approve | 1 | 69583 | 4 | 1.126 | 61796.6 |
510 | 2023-10-09 17:55:54 | approve | 1 | 69583 | 4 | 1.220 | 57035.2 |
509 | 2023-10-08 14:15:51 | approve | 1 | 69583 | 4 | 1.076 | 64668.2 |
508 | 2023-09-23 09:05:37 | approve | 1 | 69583 | 4 | 1.126 | 61796.6 |
507 | 2023-09-18 16:11:25 | approve | 1 | 69583 | 4 | 1.110 | 62687.4 |
506 | 2023-09-09 09:31:09 | approve | 2 | 107671 | 13 | 2.716 | 39643.2 |
505 | 2023-08-19 18:02:46 | approve | 1 | 69583 | 4 | 1.203 | 57841.2 |
504 | 2023-08-08 17:11:49 | approve | 1 | 69583 | 4 | 1.106 | 62914.1 |
503 | 2023-07-14 12:54:49 | approve | 2 | 107671 | 13 | 3.266 | 32967.2 |
502 | 2023-06-16 07:07:18 | approve | 1 | 69583 | 4 | 1.173 | 59320.5 |
501 | 2023-05-29 15:00:35 | approve | 2 | 107671 | 13 | 2.733 | 39396.6 |
500 | 2023-05-21 20:30:00 | approve | 1 | 69583 | 4 | 1.110 | 62687.4 |
499 | 2023-03-17 09:58:38 | approve | 1 | 69583 | 4 | 1.076 | 64668.2 |
498 | 2023-03-04 20:26:31 | approve | 2 | 107671 | 13 | 2.796 | 38508.9 |
497 | 2023-02-21 16:49:01 | approve | 1 | 69583 | 4 | 1.063 | 65459.1 |
496 | 2023-01-05 03:46:26 | approve | 1 | 69583 | 4 | 1.200 | 57985.8 |
495 | 2022-12-11 22:43:05 | approve | 2 | 107671 | 13 | 2.733 | 39396.6 |
494 | 2022-12-10 02:59:04 | approve | 1 | 69583 | 4 | 1.046 | 66522.9 |
493 | 2022-11-26 18:18:45 | approve | 1 | 69583 | 4 | 1.063 | 65459.1 |
492 | 2022-11-10 00:38:42 | approve | 1 | 69583 | 4 | 1.280 | 54361.7 |
491 | 2022-11-05 09:44:48 | approve | 1 | 69583 | 4 | 1.060 | 65644.3 |
490 | 2022-11-01 04:09:39 | approve | 1 | 69583 | 4 | 1.220 | 57035.2 |
489 | 2022-10-01 04:29:40 | approve | 1 | 69583 | 4 | 1.093 | 63662.4 |
488 | 2022-09-30 14:17:38 | approve | 1 | 69583 | 4 | 1.170 | 59472.6 |
487 | 2022-08-25 17:27:35 | approve | 1 | 69583 | 4 | 1.263 | 55093.4 |
486 | 2022-07-26 08:16:53 | approve | 2 | 107671 | 13 | 2.860 | 37647.2 |
485 | 2022-07-24 00:12:05 | approve | 2 | 107671 | 13 | 2.750 | 39153.1 |
484 | 2022-07-14 23:38:41 | approve | 1 | 69583 | 4 | 1.173 | 59320.5 |
483 | 2022-06-11 20:28:33 | approve | 2 | 107671 | 13 | 3.156 | 34116.3 |
482 | 2022-05-14 22:48:20 | approve | 1 | 69583 | 4 | 1.076 | 64668.2 |
481 | 2022-05-08 08:21:45 | approve | 2 | 107671 | 13 | 2.766 | 38926.6 |
480 | 2022-03-31 15:09:16 | approve | 1 | 69583 | 4 | 1.610 | 43219.3 |
479 | 2022-03-16 19:49:28 | approve | 2 | 107671 | 13 | 2.783 | 38688.8 |
478 | 2022-02-02 22:14:21 | approve | 1 | 69583 | 4 | 1.220 | 57035.2 |
477 | 2021-12-17 03:11:06 | approve | 1 | 69583 | 4 | 1.076 | 64668.2 |
476 | 2021-12-13 14:35:44 | approve | 1 | 69583 | 4 | 1.076 | 64668.2 |
475 | 2021-09-09 21:07:43 | approve | 1 | 69583 | 4 | 1.220 | 57035.2 |
474 | 2021-06-08 22:59:05 | approve | 1 | 69583 | 4 | 1.063 | 65459.1 |
473 | 2021-05-28 01:40:41 | approve | 2 | 107671 | 13 | 3.546 | 30364.1 |
472 | 2021-05-20 04:41:14 | approve | 1 | 69583 | 4 | 1.203 | 57841.2 |
471 | 2021-05-02 07:29:51 | approve | 2 | 107671 | 13 | 3.186 | 33795.0 |
470 | 2021-04-20 08:44:49 | approve | 1 | 69583 | 4 | 1.436 | 48456.1 |
469 | 2021-03-31 13:40:41 | approve | 2 | 107671 | 13 | 2.750 | 39153.1 |
468 | 2021-03-06 16:36:35 | approve | 1 | 69583 | 4 | 1.080 | 64428.7 |
467 | 2021-02-01 11:56:20 | approve | 1 | 69583 | 4 | 1.186 | 58670.3 |
466 | 2021-01-15 07:33:44 | approve | 2 | 107671 | 13 | 2.843 | 37872.3 |
465 | 2020-12-16 13:02:05 | approve | 2 | 107671 | 13 | 2.796 | 38508.9 |
464 | 2020-12-06 13:08:31 | approve | 1 | 69583 | 4 | 1.046 | 66522.9 |
463 | 2020-11-10 08:30:48 | approve | 2 | 107671 | 13 | 2.970 | 36252.9 |
462 | 2020-11-09 23:17:54 | approve | 2 | 107671 | 13 | 2.750 | 39153.1 |
461 | 2020-10-31 23:20:56 | approve | 1 | 69583 | 4 | 1.140 | 61037.7 |
460 | 2020-10-25 23:33:59 | approve | 1 | 69583 | 4 | 1.156 | 60192.9 |
459 | 2020-08-31 09:10:30 | approve | 1 | 69583 | 4 | 1.110 | 62687.4 |
458 | 2020-08-20 20:13:54 | approve | 1 | 69583 | 4 | 1.110 | 62687.4 |
457 | 2020-08-08 11:36:45 | approve | 1 | 69583 | 4 | 1.233 | 56433.9 |
456 | 2020-05-26 15:01:43 | approve | 1 | 69583 | 4 | 1.080 | 64428.7 |
455 | 2020-03-26 16:53:18 | approve | 1 | 69583 | 4 | 1.576 | 44151.6 |
454 | 2020-03-25 16:48:03 | approve | 1 | 69583 | 4 | 1.250 | 55666.4 |
453 | 2020-03-21 19:56:09 | approve | 1 | 69583 | 4 | 1.076 | 64668.2 |
452 | 2020-03-01 01:50:52 | approve | 3 | 134027 | 104 | 9.593 | 13971.3 |
451 | 2020-02-23 09:50:09 | approve | 1 | 69583 | 4 | 1.110 | 62687.4 |
450 | 2020-02-23 02:31:46 | approve | 1 | 69583 | 4 | 3.783 | 18393.6 |
449 | 2020-02-23 01:04:41 | approve | 1 | 69583 | 4 | 1.220 | 57035.2 |
448 | 2020-02-22 12:32:06 | approve | 1 | 69583 | 4 | 2.670 | 26061.0 |
447 | 2020-02-21 11:42:51 | approve | 3 | 134027 | 104 | 7.283 | 18402.7 |
446 | 2020-02-12 19:28:52 | approve | 1 | 69583 | 4 | 1.436 | 48456.1 |
445 | 2020-02-12 15:12:01 | approve | 3 | 134027 | 104 | 12.923 | 10371.2 |
444 | 2020-02-06 10:51:41 | approve | 3 | 134027 | 104 | 6.860 | 19537.5 |
443 | 2020-02-06 00:09:07 | approve | 1 | 69583 | 4 | 2.796 | 24886.6 |
442 | 2020-02-03 14:51:29 | approve | 3 | 134027 | 104 | 13.610 | 9847.7 |
441 | 2020-02-03 02:58:23 | approve | 3 | 134027 | 104 | 9.610 | 13946.6 |
440 | 2020-02-02 11:34:05 | approve | 3 | 134027 | 104 | 7.280 | 18410.3 |
439 | 2020-01-28 23:41:46 | approve | 1 | 69583 | 4 | 2.560 | 27180.9 |
438 | 2020-01-25 16:39:24 | approve | 1 | 69583 | 4 | 1.453 | 47889.2 |