History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"petrel"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
564 | 2025-01-25 22:56:20 | petrel | 1 | 48755 | 4 | 4.200 | 11608.3 |
563 | 2025-01-25 13:36:23 | petrel | 1 | 48755 | 4 | 4.203 | 11600.0 |
562 | 2025-01-09 17:35:01 | petrel | 1 | 48755 | 4 | 2.826 | 17252.3 |
561 | 2025-01-05 16:05:34 | petrel | 3 | 112716 | 598 | 33.740 | 3340.7 |
560 | 2025-01-05 11:44:04 | petrel | 2 | 82551 | 38 | 8.923 | 9251.5 |
559 | 2025-01-05 10:29:00 | petrel | 2 | 82551 | 38 | 2.796 | 29524.7 |
558 | 2025-01-05 10:10:40 | petrel | 1 | 48755 | 4 | 2.906 | 16777.4 |
557 | 2025-01-05 09:53:02 | petrel | 3 | 112716 | 598 | 31.296 | 3601.6 |
556 | 2025-01-05 09:26:32 | petrel | 3 | 112716 | 598 | 28.503 | 3954.5 |
555 | 2025-01-05 09:21:25 | petrel | 3 | 112716 | 598 | 28.236 | 3991.9 |
554 | 2025-01-05 09:21:25 | petrel | 2 | 82551 | 38 | 12.063 | 6843.3 |
553 | 2025-01-05 09:21:19 | petrel | 1 | 48755 | 4 | 2.296 | 21234.8 |
552 | 2024-12-26 09:12:34 | petrel | 1 | 48755 | 4 | 3.076 | 15850.1 |
551 | 2024-12-06 15:11:19 | petrel | 2 | 82551 | 38 | 2.733 | 30205.3 |
550 | 2024-12-06 12:17:13 | petrel | 2 | 82551 | 38 | 18.360 | 4496.2 |
549 | 2024-12-06 07:49:38 | petrel | 2 | 82551 | 38 | 34.800 | 2372.2 |
548 | 2024-12-06 02:51:32 | petrel | 3 | 112716 | 598 | 26.030 | 4330.2 |
547 | 2024-12-06 01:47:25 | petrel | 3 | 112716 | 598 | 13.796 | 8170.2 |
546 | 2024-12-06 00:14:59 | petrel | 3 | 112716 | 598 | 29.923 | 3766.9 |
545 | 2024-12-06 00:14:55 | petrel | 2 | 82551 | 38 | 7.343 | 11242.1 |
544 | 2024-12-06 00:14:48 | petrel | 1 | 48755 | 4 | 2.436 | 20014.4 |
543 | 2024-12-04 18:40:35 | petrel | 1 | 48755 | 4 | 2.873 | 16970.1 |
542 | 2024-11-26 05:11:49 | petrel | 1 | 48755 | 4 | 3.983 | 12240.8 |
541 | 2024-11-08 22:10:06 | petrel | 1 | 48755 | 4 | 2.920 | 16696.9 |
540 | 2024-11-05 22:00:57 | petrel | 1 | 48755 | 4 | 4.813 | 10129.9 |
539 | 2024-11-03 17:55:05 | petrel | 1 | 48755 | 4 | 3.953 | 12333.7 |
538 | 2024-10-26 00:36:08 | petrel | 1 | 48755 | 4 | 4.873 | 10005.1 |
537 | 2024-10-09 21:53:21 | petrel | 1 | 48755 | 4 | 6.296 | 7743.8 |
536 | 2024-10-06 21:17:15 | petrel | 3 | 112716 | 598 | 44.050 | 2558.8 |
535 | 2024-10-06 03:43:15 | petrel | 3 | 112716 | 598 | 38.163 | 2953.5 |
534 | 2024-10-05 08:38:09 | petrel | 3 | 112716 | 598 | 57.096 | 1974.1 |
533 | 2024-10-05 08:04:18 | petrel | 3 | 112716 | 598 | 30.220 | 3729.8 |
532 | 2024-10-05 08:04:17 | petrel | 2 | 82551 | 38 | 23.876 | 3457.5 |
531 | 2024-10-05 08:04:14 | petrel | 1 | 48755 | 4 | 5.983 | 8148.9 |
530 | 2024-10-02 04:58:36 | petrel | 1 | 48755 | 4 | 6.470 | 7535.5 |
529 | 2024-09-09 15:18:02 | petrel | 1 | 48755 | 4 | 6.466 | 7540.2 |
528 | 2024-09-01 12:28:05 | petrel | 1 | 48755 | 4 | 3.060 | 15933.0 |
527 | 2024-09-01 07:31:51 | petrel | 1 | 48755 | 4 | 3.060 | 15933.0 |
526 | 2024-08-31 17:27:18 | petrel | 3 | 112716 | 598 | 20.720 | 5440.0 |
525 | 2024-08-31 05:23:22 | petrel | 1 | 48755 | 4 | 7.703 | 6329.4 |
524 | 2024-08-30 10:37:43 | petrel | 3 | 112716 | 598 | 41.736 | 2700.7 |
523 | 2024-08-29 18:29:36 | petrel | 3 | 112716 | 598 | 38.283 | 2944.3 |
522 | 2024-08-29 10:00:40 | petrel | 3 | 112716 | 598 | 36.093 | 3122.9 |
521 | 2024-08-29 08:18:01 | petrel | 3 | 112716 | 598 | 35.143 | 3207.4 |
520 | 2024-08-29 08:18:00 | petrel | 2 | 82551 | 38 | 9.733 | 8481.6 |
519 | 2024-08-29 08:17:58 | petrel | 1 | 48755 | 4 | 8.046 | 6059.5 |
518 | 2024-08-15 11:59:11 | petrel | 1 | 48755 | 4 | 3.313 | 14716.3 |
517 | 2024-08-14 10:26:05 | petrel | 1 | 48755 | 4 | 3.063 | 15917.4 |
516 | 2024-08-12 19:27:58 | petrel | 1 | 48755 | 4 | 5.640 | 8644.5 |
515 | 2024-08-09 12:32:42 | petrel | 1 | 48755 | 4 | 3.030 | 16090.8 |
514 | 2024-08-03 02:17:05 | petrel | 1 | 48755 | 4 | 3.063 | 15917.4 |
513 | 2024-08-02 02:24:51 | petrel | 1 | 48755 | 4 | 3.156 | 15448.4 |
512 | 2024-08-01 02:59:51 | petrel | 1 | 48755 | 4 | 1.360 | 35849.3 |
511 | 2024-07-30 04:14:31 | petrel | 1 | 48755 | 4 | 3.873 | 12588.4 |
510 | 2024-07-28 20:29:08 | petrel | 3 | 112716 | 598 | 18.796 | 5996.8 |
509 | 2024-07-27 08:06:32 | petrel | 1 | 48755 | 4 | 2.986 | 16327.9 |
508 | 2024-07-24 23:23:41 | petrel | 3 | 112716 | 598 | 30.610 | 3682.3 |
507 | 2024-07-24 13:13:33 | petrel | 3 | 112716 | 598 | 23.580 | 4780.2 |
506 | 2024-07-24 05:45:49 | petrel | 3 | 112716 | 598 | 21.626 | 5212.1 |
505 | 2024-07-24 02:16:07 | petrel | 3 | 112716 | 598 | 25.736 | 4379.7 |
504 | 2024-07-23 22:48:05 | petrel | 3 | 112716 | 598 | 22.263 | 5062.9 |
503 | 2024-07-10 11:12:31 | petrel | 1 | 48755 | 4 | 4.063 | 11999.8 |
502 | 2024-07-02 08:25:59 | petrel | 1 | 48755 | 4 | 3.140 | 15527.1 |
501 | 2024-07-01 02:37:47 | petrel | 1 | 48755 | 4 | 3.330 | 14641.1 |
500 | 2024-06-28 04:05:39 | petrel | 1 | 48755 | 4 | 3.326 | 14658.7 |
499 | 2024-06-25 20:47:08 | petrel | 1 | 48755 | 4 | 3.763 | 12956.4 |
498 | 2024-06-20 20:08:55 | petrel | 2 | 82551 | 38 | 11.970 | 6896.5 |
497 | 2024-06-20 20:08:55 | petrel | 1 | 48755 | 4 | 1.470 | 33166.7 |
496 | 2024-06-18 13:40:29 | petrel | 1 | 48755 | 4 | 4.326 | 11270.2 |
495 | 2024-06-08 09:47:21 | petrel | 3 | 112716 | 598 | 30.016 | 3755.2 |
494 | 2024-06-08 09:16:57 | petrel | 3 | 112716 | 598 | 31.486 | 3579.9 |
493 | 2024-06-08 04:04:21 | petrel | 3 | 112716 | 598 | 27.143 | 4152.7 |
492 | 2024-06-07 11:08:36 | petrel | 2 | 82551 | 38 | 7.516 | 10983.4 |
491 | 2024-06-07 11:05:10 | petrel | 3 | 112716 | 598 | 6.236 | 18075.0 |
490 | 2024-06-04 22:55:33 | petrel | 3 | 112716 | 598 | 19.440 | 5798.1 |
489 | 2024-06-04 17:53:11 | petrel | 3 | 112716 | 598 | 8.030 | 14036.9 |
488 | 2024-05-28 00:58:33 | petrel | 1 | 48755 | 4 | 4.093 | 11911.8 |
487 | 2024-05-16 07:29:54 | petrel | 2 | 82551 | 38 | 5.860 | 14087.2 |
486 | 2024-05-14 20:25:56 | petrel | 1 | 48755 | 4 | 1.013 | 48129.3 |
485 | 2024-05-01 22:14:22 | petrel | 1 | 48755 | 4 | 0.893 | 54596.9 |
484 | 2024-05-01 20:52:51 | petrel | 1 | 48755 | 4 | 1.950 | 25002.6 |
483 | 2024-04-28 06:27:08 | petrel | 1 | 48755 | 4 | 1.016 | 47987.2 |
482 | 2024-04-08 06:35:02 | petrel | 3 | 112716 | 598 | 13.610 | 8281.9 |
481 | 2024-04-06 18:19:05 | petrel | 3 | 112716 | 598 | 20.783 | 5423.5 |
480 | 2024-04-05 19:02:47 | petrel | 3 | 112716 | 598 | 6.626 | 17011.2 |
479 | 2024-04-05 15:04:20 | petrel | 3 | 112716 | 598 | 12.376 | 9107.6 |
478 | 2024-04-05 05:06:44 | petrel | 3 | 112716 | 598 | 12.280 | 9178.8 |
477 | 2024-04-05 05:06:46 | petrel | 2 | 82551 | 38 | 2.986 | 27646.0 |
476 | 2024-04-05 05:06:41 | petrel | 1 | 48755 | 4 | 1.936 | 25183.4 |
475 | 2024-04-05 05:06:31 | petrel | 3 | 112716 | 598 | 10.593 | 10640.6 |
474 | 2024-04-05 05:06:32 | petrel | 2 | 82551 | 38 | 5.626 | 14673.1 |
473 | 2024-04-04 12:28:12 | petrel | 1 | 48755 | 4 | 1.030 | 47335.0 |
472 | 2024-02-14 19:15:47 | petrel | 2 | 82551 | 38 | 2.563 | 32208.7 |
471 | 2024-02-14 18:08:53 | petrel | 3 | 112716 | 598 | 7.016 | 16065.6 |
470 | 2024-02-14 00:12:26 | petrel | 3 | 112716 | 598 | 8.953 | 12589.7 |
469 | 2024-01-06 23:40:19 | petrel | 2 | 82551 | 38 | 2.483 | 33246.5 |
468 | 2023-12-25 13:25:58 | petrel | 1 | 48755 | 4 | 0.750 | 65006.7 |
467 | 2023-12-20 15:34:40 | petrel | 3 | 112716 | 598 | 5.686 | 19823.4 |
466 | 2023-12-20 15:34:43 | petrel | 2 | 82551 | 38 | 2.766 | 29844.9 |
465 | 2023-12-08 14:03:28 | petrel | 2 | 82551 | 38 | 2.750 | 30018.5 |