History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"serum"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
539 | 2024-04-18 18:22:08 | serum | 1 | 28756 | 6 | 1.126 | 25538.2 |
538 | 2024-04-18 00:43:47 | serum | 1 | 28756 | 6 | 1.110 | 25906.3 |
537 | 2024-04-05 09:56:15 | serum | 3 | 83667 | 986 | 9.860 | 8485.5 |
536 | 2024-04-04 19:55:10 | serum | 3 | 83667 | 986 | 12.800 | 6536.5 |
535 | 2024-04-03 19:44:15 | serum | 3 | 83667 | 986 | 9.826 | 8514.9 |
534 | 2024-04-03 10:58:42 | serum | 3 | 83667 | 986 | 10.923 | 7659.7 |
533 | 2024-04-03 10:58:43 | serum | 2 | 53800 | 90 | 3.046 | 17662.5 |
532 | 2024-04-03 10:58:11 | serum | 1 | 28756 | 6 | 1.203 | 23903.6 |
531 | 2024-03-31 13:59:47 | serum | 1 | 28756 | 6 | 0.593 | 48492.4 |
530 | 2024-03-28 20:04:58 | serum | 1 | 28756 | 6 | 0.530 | 54256.6 |
529 | 2024-03-04 06:32:59 | serum | 1 | 28756 | 6 | 0.533 | 53951.2 |
528 | 2024-03-01 11:51:13 | serum | 1 | 28756 | 6 | 0.486 | 59168.7 |
527 | 2024-02-28 13:18:06 | serum | 2 | 53800 | 90 | 2.906 | 18513.4 |
526 | 2024-02-26 04:05:47 | serum | 1 | 28756 | 6 | 0.483 | 59536.2 |
525 | 2024-02-03 00:43:43 | serum | 1 | 28756 | 6 | 0.516 | 55728.7 |
524 | 2024-01-28 23:09:03 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
523 | 2024-01-27 00:23:41 | serum | 1 | 28756 | 6 | 0.546 | 52666.7 |
522 | 2024-01-19 09:59:32 | serum | 3 | 83667 | 986 | 4.266 | 19612.5 |
521 | 2024-01-01 19:18:05 | serum | 1 | 28756 | 6 | 0.516 | 55728.7 |
520 | 2023-12-14 15:35:59 | serum | 1 | 28756 | 6 | 0.516 | 55728.7 |
519 | 2023-12-10 05:09:39 | serum | 2 | 53800 | 90 | 1.673 | 32157.8 |
518 | 2023-12-09 01:25:32 | serum | 3 | 83667 | 986 | 3.436 | 24350.1 |
517 | 2023-12-08 10:03:20 | serum | 3 | 83667 | 986 | 4.203 | 19906.5 |
516 | 2023-12-07 17:36:25 | serum | 2 | 53800 | 90 | 1.533 | 35094.6 |
515 | 2023-12-04 00:04:27 | serum | 3 | 83667 | 986 | 3.890 | 21508.2 |
514 | 2023-11-28 15:29:55 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
513 | 2023-11-20 08:12:52 | serum | 2 | 53800 | 90 | 1.643 | 32745.0 |
512 | 2023-11-18 04:40:00 | serum | 3 | 83667 | 986 | 3.923 | 21327.3 |
511 | 2023-11-18 04:39:50 | serum | 2 | 53800 | 90 | 1.593 | 33772.8 |
510 | 2023-11-12 21:15:32 | serum | 1 | 28756 | 6 | 0.470 | 61183.0 |
509 | 2023-11-11 01:25:24 | serum | 1 | 28756 | 6 | 0.470 | 61183.0 |
508 | 2023-11-10 23:22:17 | serum | 3 | 83667 | 986 | 3.546 | 23594.8 |
507 | 2023-11-10 23:22:15 | serum | 2 | 53800 | 90 | 1.390 | 38705.0 |
506 | 2023-11-10 03:14:58 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
505 | 2023-11-02 07:29:56 | serum | 3 | 83667 | 986 | 3.893 | 21491.7 |
504 | 2023-11-02 07:29:51 | serum | 2 | 53800 | 90 | 3.373 | 15950.2 |
503 | 2023-11-02 06:25:29 | serum | 1 | 28756 | 6 | 0.516 | 55728.7 |
502 | 2023-10-27 00:03:09 | serum | 1 | 28756 | 6 | 0.513 | 56054.6 |
501 | 2023-10-21 07:48:15 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
500 | 2023-10-21 07:23:42 | serum | 1 | 28756 | 6 | 0.530 | 54256.6 |
499 | 2023-10-18 00:09:49 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
498 | 2023-10-14 12:46:00 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
497 | 2023-10-04 18:59:58 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
496 | 2023-09-26 09:29:51 | serum | 1 | 28756 | 6 | 0.626 | 45936.1 |
495 | 2023-09-21 22:50:29 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
494 | 2023-08-19 21:15:14 | serum | 2 | 53800 | 90 | 1.423 | 37807.4 |
493 | 2023-08-16 11:46:16 | serum | 1 | 28756 | 6 | 0.470 | 61183.0 |
492 | 2023-08-01 20:22:01 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
491 | 2023-05-17 13:41:44 | serum | 1 | 28756 | 6 | 0.436 | 65954.1 |
490 | 2023-05-05 09:25:27 | serum | 2 | 53800 | 90 | 1.483 | 36277.8 |
489 | 2023-04-13 10:26:04 | serum | 1 | 28756 | 6 | 0.546 | 52666.7 |
488 | 2023-03-11 18:56:38 | serum | 1 | 28756 | 6 | 0.483 | 59536.2 |
487 | 2023-02-12 00:39:08 | serum | 2 | 53800 | 90 | 1.390 | 38705.0 |
486 | 2022-12-31 17:04:09 | serum | 1 | 28756 | 6 | 0.436 | 65954.1 |
485 | 2022-12-24 11:20:29 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
484 | 2022-11-22 19:30:23 | serum | 2 | 53800 | 90 | 1.423 | 37807.4 |
483 | 2022-09-20 13:55:50 | serum | 1 | 28756 | 6 | 0.450 | 63902.2 |
482 | 2022-08-24 06:50:05 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
481 | 2022-06-26 19:29:42 | serum | 2 | 53800 | 90 | 1.406 | 38264.6 |
480 | 2022-05-02 05:38:55 | serum | 1 | 28756 | 6 | 0.450 | 63902.2 |
479 | 2022-04-30 01:05:26 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
478 | 2022-04-23 13:05:41 | serum | 1 | 28756 | 6 | 0.470 | 61183.0 |
477 | 2022-04-20 02:31:10 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
476 | 2022-02-10 08:09:28 | serum | 2 | 53800 | 90 | 1.733 | 31044.4 |
475 | 2022-01-21 05:00:35 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
474 | 2021-12-31 21:22:00 | serum | 1 | 28756 | 6 | 0.533 | 53951.2 |
473 | 2021-11-16 19:43:40 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
472 | 2021-11-13 06:40:34 | serum | 2 | 53800 | 90 | 1.440 | 37361.1 |
471 | 2021-10-06 16:42:24 | serum | 1 | 28756 | 6 | 0.530 | 54256.6 |
470 | 2021-09-18 08:42:12 | serum | 1 | 28756 | 6 | 0.513 | 56054.6 |
469 | 2021-09-06 18:26:58 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
468 | 2021-09-04 13:29:05 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
467 | 2021-08-20 03:35:36 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
466 | 2021-06-18 12:59:49 | serum | 1 | 28756 | 6 | 0.466 | 61708.2 |
465 | 2021-05-23 07:37:05 | serum | 1 | 28756 | 6 | 1.016 | 28303.1 |
464 | 2021-05-01 14:07:19 | serum | 1 | 28756 | 6 | 0.486 | 59168.7 |
463 | 2021-04-24 13:32:00 | serum | 1 | 28756 | 6 | 0.626 | 45936.1 |
462 | 2021-04-18 09:57:32 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
461 | 2021-03-26 11:15:57 | serum | 1 | 28756 | 6 | 0.470 | 61183.0 |
460 | 2021-03-19 08:20:46 | serum | 1 | 28756 | 6 | 1.033 | 27837.4 |
459 | 2021-02-23 21:11:18 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
458 | 2021-01-09 18:48:40 | serum | 1 | 28756 | 6 | 0.466 | 61708.2 |
457 | 2020-12-16 10:48:05 | serum | 1 | 28756 | 6 | 0.466 | 61708.2 |
456 | 2020-11-17 09:57:25 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
455 | 2020-10-21 20:37:42 | serum | 1 | 28756 | 6 | 0.546 | 52666.7 |
454 | 2020-10-18 04:28:59 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
453 | 2020-09-16 01:53:29 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
452 | 2020-09-08 04:00:31 | serum | 1 | 28756 | 6 | 0.470 | 61183.0 |
451 | 2020-09-06 12:00:58 | serum | 1 | 28756 | 6 | 0.456 | 63061.4 |
450 | 2020-08-15 12:49:17 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
449 | 2020-07-25 19:29:26 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
448 | 2020-07-19 23:06:45 | serum | 1 | 28756 | 6 | 0.546 | 52666.7 |
447 | 2020-06-06 15:59:52 | serum | 1 | 28756 | 6 | 0.453 | 63479.0 |
446 | 2020-06-03 08:02:30 | serum | 1 | 28756 | 6 | 0.530 | 54256.6 |
445 | 2020-03-30 08:32:22 | serum | 1 | 28756 | 6 | 0.516 | 55728.7 |
444 | 2020-03-30 03:00:55 | serum | 1 | 28756 | 6 | 1.000 | 28756.0 |
443 | 2020-03-26 06:44:26 | serum | 1 | 28756 | 6 | 0.500 | 57512.0 |
442 | 2020-03-24 13:07:08 | serum | 1 | 28756 | 6 | 1.046 | 27491.4 |
441 | 2020-03-24 03:42:05 | serum | 3 | 83667 | 986 | 3.910 | 21398.2 |
440 | 2020-03-23 16:51:49 | serum | 3 | 83667 | 986 | 9.330 | 8967.5 |