History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grain"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
543 | 2024-04-27 12:36:50 | grain | 1 | 28756 | 14 | 0.546 | 52666.7 |
542 | 2024-04-18 15:02:13 | grain | 2 | 53800 | 145 | 5.206 | 10334.2 |
541 | 2024-04-14 08:53:09 | grain | 1 | 28756 | 14 | 1.030 | 27918.4 |
540 | 2024-04-03 06:06:51 | grain | 1 | 28756 | 14 | 0.513 | 56054.6 |
539 | 2024-04-01 01:52:27 | grain | 1 | 28756 | 14 | 0.563 | 51076.4 |
538 | 2024-03-30 22:04:19 | grain | 1 | 28756 | 14 | 0.500 | 57512.0 |
537 | 2024-03-27 05:04:03 | grain | 1 | 28756 | 14 | 0.500 | 57512.0 |
536 | 2024-03-17 19:35:15 | grain | 2 | 53800 | 145 | 1.703 | 31591.3 |
535 | 2024-03-17 19:35:10 | grain | 1 | 28756 | 14 | 0.533 | 53951.2 |
534 | 2024-03-17 19:35:05 | grain | 2 | 53800 | 145 | 1.483 | 36277.8 |
533 | 2024-03-04 00:27:35 | grain | 1 | 28756 | 14 | 0.966 | 29768.1 |
532 | 2024-02-27 22:36:28 | grain | 1 | 28756 | 14 | 0.533 | 53951.2 |
531 | 2024-02-26 01:55:44 | grain | 2 | 53800 | 145 | 1.860 | 28924.7 |
530 | 2024-02-26 01:33:05 | grain | 1 | 28756 | 14 | 0.453 | 63479.0 |
529 | 2024-02-14 18:07:09 | grain | 2 | 53800 | 145 | 1.560 | 34487.2 |
528 | 2024-02-03 00:14:11 | grain | 1 | 28756 | 14 | 0.483 | 59536.2 |
527 | 2024-01-26 21:47:01 | grain | 1 | 28756 | 14 | 0.470 | 61183.0 |
526 | 2024-01-26 20:46:29 | grain | 1 | 28756 | 14 | 0.533 | 53951.2 |
525 | 2023-12-21 23:03:08 | grain | 1 | 28756 | 14 | 0.513 | 56054.6 |
524 | 2023-12-21 03:50:54 | grain | 2 | 53800 | 145 | 1.360 | 39558.8 |
523 | 2023-12-14 01:37:53 | grain | 2 | 53800 | 145 | 1.343 | 40059.6 |
522 | 2023-11-20 00:30:03 | grain | 1 | 28756 | 14 | 0.486 | 59168.7 |
521 | 2023-11-12 01:49:04 | grain | 1 | 28756 | 14 | 0.483 | 59536.2 |
520 | 2023-11-08 06:11:36 | grain | 1 | 28756 | 14 | 0.420 | 68466.7 |
519 | 2023-10-30 22:09:51 | grain | 2 | 53800 | 145 | 1.580 | 34050.6 |
518 | 2023-10-28 19:52:09 | grain | 1 | 28756 | 14 | 0.470 | 61183.0 |
517 | 2023-10-20 19:55:12 | grain | 1 | 28756 | 14 | 1.013 | 28387.0 |
516 | 2023-10-20 11:41:20 | grain | 1 | 28756 | 14 | 0.483 | 59536.2 |
515 | 2023-10-11 03:11:10 | grain | 1 | 28756 | 14 | 0.470 | 61183.0 |
514 | 2023-10-09 09:00:33 | grain | 1 | 28756 | 14 | 0.500 | 57512.0 |
513 | 2023-10-05 22:03:39 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
512 | 2023-09-26 13:40:19 | grain | 1 | 28756 | 14 | 0.516 | 55728.7 |
511 | 2023-09-22 09:26:05 | grain | 1 | 28756 | 14 | 0.550 | 52283.6 |
510 | 2023-08-06 08:08:56 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
509 | 2023-07-24 18:26:54 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
508 | 2023-05-04 04:34:12 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
507 | 2023-04-12 23:42:36 | grain | 1 | 28756 | 14 | 0.450 | 63902.2 |
506 | 2023-03-05 01:18:16 | grain | 1 | 28756 | 14 | 0.423 | 67981.1 |
505 | 2023-02-24 08:47:10 | grain | 1 | 28756 | 14 | 0.420 | 68466.7 |
504 | 2023-01-04 04:26:56 | grain | 1 | 28756 | 14 | 0.486 | 59168.7 |
503 | 2022-12-23 02:52:04 | grain | 1 | 28756 | 14 | 0.423 | 67981.1 |
502 | 2022-09-20 13:14:52 | grain | 1 | 28756 | 14 | 0.470 | 61183.0 |
501 | 2022-09-19 22:36:10 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
500 | 2022-09-12 02:46:21 | grain | 1 | 28756 | 14 | 1.013 | 28387.0 |
499 | 2022-09-07 02:34:09 | grain | 1 | 28756 | 14 | 0.483 | 59536.2 |
498 | 2022-09-04 22:55:37 | grain | 1 | 28756 | 14 | 0.440 | 65354.5 |
497 | 2022-08-31 01:19:38 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
496 | 2022-08-17 13:57:35 | grain | 1 | 28756 | 14 | 0.420 | 68466.7 |
495 | 2022-08-14 20:14:38 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
494 | 2022-08-09 07:05:17 | grain | 1 | 28756 | 14 | 0.483 | 59536.2 |
493 | 2022-08-06 20:47:28 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
492 | 2022-07-29 04:26:54 | grain | 1 | 28756 | 14 | 0.483 | 59536.2 |
491 | 2022-07-03 08:01:43 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
490 | 2022-06-16 08:01:20 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
489 | 2022-06-15 16:33:21 | grain | 1 | 28756 | 14 | 0.440 | 65354.5 |
488 | 2022-06-03 15:34:50 | grain | 1 | 28756 | 14 | 0.423 | 67981.1 |
487 | 2022-05-30 16:47:12 | grain | 1 | 28756 | 14 | 0.470 | 61183.0 |
486 | 2022-05-03 20:53:10 | grain | 2 | 53800 | 145 | 1.563 | 34421.0 |
485 | 2022-04-28 13:57:35 | grain | 2 | 53800 | 145 | 1.500 | 35866.7 |
484 | 2022-04-11 15:41:26 | grain | 1 | 28756 | 14 | 0.593 | 48492.4 |
483 | 2022-02-20 08:10:37 | grain | 1 | 28756 | 14 | 0.483 | 59536.2 |
482 | 2022-02-03 21:55:30 | grain | 1 | 28756 | 14 | 0.453 | 63479.0 |
481 | 2022-01-07 12:30:14 | grain | 1 | 28756 | 14 | 0.483 | 59536.2 |
480 | 2021-11-26 00:57:46 | grain | 1 | 28756 | 14 | 0.456 | 63061.4 |
479 | 2021-11-15 14:41:52 | grain | 1 | 28756 | 14 | 0.893 | 32201.6 |
478 | 2021-11-09 20:29:17 | grain | 1 | 28756 | 14 | 0.486 | 59168.7 |
477 | 2021-11-07 18:41:31 | grain | 1 | 28756 | 14 | 0.470 | 61183.0 |
476 | 2021-09-27 10:16:19 | grain | 1 | 28756 | 14 | 0.733 | 39230.6 |
475 | 2021-08-25 20:10:14 | grain | 1 | 28756 | 14 | 0.470 | 61183.0 |
474 | 2021-08-23 16:32:37 | grain | 1 | 28756 | 14 | 0.486 | 59168.7 |
473 | 2021-08-12 18:35:50 | grain | 1 | 28756 | 14 | 0.906 | 31739.5 |
472 | 2021-06-15 11:38:02 | grain | 1 | 28756 | 14 | 0.486 | 59168.7 |
471 | 2021-05-15 06:34:13 | grain | 2 | 53800 | 145 | 1.390 | 38705.0 |
470 | 2021-05-12 01:35:32 | grain | 1 | 28756 | 14 | 0.483 | 59536.2 |
469 | 2021-03-25 23:15:13 | grain | 1 | 28756 | 14 | 0.500 | 57512.0 |
468 | 2021-02-07 16:28:16 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
467 | 2021-02-02 17:29:28 | grain | 1 | 28756 | 14 | 0.470 | 61183.0 |
466 | 2021-01-29 12:36:24 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
465 | 2021-01-09 05:42:25 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
464 | 2020-12-23 06:06:36 | grain | 2 | 53800 | 145 | 1.563 | 34421.0 |
463 | 2020-11-08 10:32:24 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
462 | 2020-10-26 18:03:51 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
461 | 2020-10-08 06:05:09 | grain | 1 | 28756 | 14 | 0.483 | 59536.2 |
460 | 2020-09-27 17:52:15 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
459 | 2020-09-09 23:35:43 | grain | 1 | 28756 | 14 | 0.423 | 67981.1 |
458 | 2020-08-24 03:57:56 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
457 | 2020-08-06 06:43:00 | grain | 1 | 28756 | 14 | 0.516 | 55728.7 |
456 | 2020-08-03 00:03:38 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
455 | 2020-07-22 23:12:01 | grain | 1 | 28756 | 14 | 0.453 | 63479.0 |
454 | 2020-05-03 08:22:56 | grain | 1 | 28756 | 14 | 0.453 | 63479.0 |
453 | 2020-04-20 23:45:48 | grain | 1 | 28756 | 14 | 0.436 | 65954.1 |
452 | 2020-03-30 03:45:15 | grain | 1 | 28756 | 14 | 0.530 | 54256.6 |
451 | 2020-03-25 14:55:57 | grain | 1 | 28756 | 14 | 0.486 | 59168.7 |
450 | 2020-03-24 12:06:54 | grain | 1 | 28756 | 14 | 0.530 | 54256.6 |
449 | 2020-03-23 09:57:57 | grain | 1 | 28756 | 14 | 1.063 | 27051.7 |
448 | 2020-03-22 01:04:36 | grain | 1 | 28756 | 14 | 0.500 | 57512.0 |
447 | 2020-03-21 00:56:59 | grain | 1 | 28756 | 14 | 0.530 | 54256.6 |
446 | 2020-03-19 20:19:01 | grain | 1 | 28756 | 14 | 0.516 | 55728.7 |
445 | 2020-03-18 20:09:24 | grain | 1 | 28756 | 14 | 0.516 | 55728.7 |
444 | 2020-03-17 19:21:16 | grain | 1 | 28756 | 14 | 0.453 | 63479.0 |