History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"serovar"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
561 | 2024-03-28 02:32:03 | serovar | 1 | 69583 | 2 | 1.233 | 56433.9 |
560 | 2024-03-13 17:19:33 | serovar | 2 | 107671 | 9 | 3.343 | 32207.9 |
559 | 2024-03-13 17:19:19 | serovar | 3 | 134027 | 94 | 9.046 | 14816.2 |
558 | 2024-03-12 03:51:08 | serovar | 2 | 107671 | 9 | 4.483 | 24017.6 |
557 | 2024-03-12 03:50:24 | serovar | 3 | 134027 | 94 | 8.580 | 15620.9 |
556 | 2024-03-11 01:48:36 | serovar | 3 | 134027 | 94 | 13.016 | 10297.1 |
555 | 2024-03-10 20:11:18 | serovar | 3 | 134027 | 94 | 8.440 | 15880.0 |
554 | 2024-03-10 20:11:18 | serovar | 2 | 107671 | 9 | 5.373 | 20039.3 |
553 | 2024-03-01 19:27:38 | serovar | 4 | 151207 | 1319 | 19.830 | 7625.2 |
552 | 2024-03-01 14:55:10 | serovar | 4 | 151207 | 1319 | 26.250 | 5760.3 |
551 | 2024-03-01 14:55:11 | serovar | 2 | 107671 | 9 | 6.470 | 16641.6 |
550 | 2024-03-01 14:55:07 | serovar | 1 | 69583 | 2 | 1.376 | 50569.0 |
549 | 2024-02-09 19:04:08 | serovar | 1 | 69583 | 2 | 2.123 | 32775.8 |
548 | 2024-02-07 10:38:15 | serovar | 3 | 134027 | 94 | 16.110 | 8319.5 |
547 | 2024-02-07 10:38:19 | serovar | 2 | 107671 | 9 | 3.736 | 28819.9 |
546 | 2024-01-31 00:50:35 | serovar | 1 | 69583 | 2 | 1.310 | 53116.8 |
545 | 2024-01-23 16:28:17 | serovar | 4 | 151207 | 1319 | 36.923 | 4095.2 |
544 | 2024-01-20 04:54:22 | serovar | 4 | 151207 | 1319 | 11.623 | 13009.3 |
543 | 2023-12-29 09:33:48 | serovar | 4 | 151207 | 1319 | 11.530 | 13114.2 |
542 | 2023-12-28 15:08:13 | serovar | 4 | 151207 | 1319 | 11.373 | 13295.3 |
541 | 2023-12-27 21:50:31 | serovar | 3 | 134027 | 94 | 11.003 | 12181.0 |
540 | 2023-12-23 02:50:54 | serovar | 2 | 107671 | 9 | 3.516 | 30623.2 |
539 | 2023-12-08 11:47:19 | serovar | 4 | 151207 | 1319 | 10.750 | 14065.8 |
538 | 2023-12-08 11:44:46 | serovar | 4 | 151207 | 1319 | 13.500 | 11200.5 |
537 | 2023-12-08 11:39:15 | serovar | 4 | 151207 | 1319 | 12.483 | 12113.0 |
536 | 2023-12-06 06:54:18 | serovar | 4 | 151207 | 1319 | 10.733 | 14088.0 |
535 | 2023-12-04 00:46:59 | serovar | 1 | 69583 | 2 | 1.093 | 63662.4 |
534 | 2023-11-30 00:39:37 | serovar | 1 | 69583 | 2 | 1.153 | 60349.5 |
533 | 2023-11-29 20:48:46 | serovar | 4 | 151207 | 1319 | 14.076 | 10742.2 |
532 | 2023-11-19 10:45:12 | serovar | 1 | 69583 | 2 | 1.280 | 54361.7 |
531 | 2023-11-12 11:15:26 | serovar | 4 | 151207 | 1319 | 13.140 | 11507.4 |
530 | 2023-11-12 09:31:20 | serovar | 1 | 69583 | 2 | 1.156 | 60192.9 |
529 | 2023-11-10 03:36:52 | serovar | 4 | 151207 | 1319 | 13.580 | 11134.5 |
528 | 2023-10-31 12:34:25 | serovar | 4 | 151207 | 1319 | 11.033 | 13705.0 |
527 | 2023-10-31 12:12:22 | serovar | 4 | 151207 | 1319 | 14.780 | 10230.5 |
526 | 2023-10-31 12:10:03 | serovar | 4 | 151207 | 1319 | 12.250 | 12343.4 |
525 | 2023-10-26 17:29:34 | serovar | 4 | 151207 | 1319 | 16.143 | 9366.7 |
524 | 2023-10-20 12:59:32 | serovar | 4 | 151207 | 1319 | 15.093 | 10018.4 |
523 | 2023-10-18 15:40:37 | serovar | 1 | 69583 | 2 | 1.110 | 62687.4 |
522 | 2023-10-17 09:46:26 | serovar | 4 | 151207 | 1319 | 29.520 | 5122.2 |
521 | 2023-10-17 02:47:06 | serovar | 1 | 69583 | 2 | 1.250 | 55666.4 |
520 | 2023-10-11 09:22:04 | serovar | 4 | 151207 | 1319 | 14.236 | 10621.5 |
519 | 2023-10-04 01:39:23 | serovar | 4 | 151207 | 1319 | 24.440 | 6186.9 |
518 | 2023-09-28 15:13:45 | serovar | 3 | 134027 | 94 | 6.016 | 22278.4 |
517 | 2023-09-25 17:42:02 | serovar | 1 | 69583 | 2 | 1.220 | 57035.2 |
516 | 2023-09-24 22:55:13 | serovar | 1 | 69583 | 2 | 1.296 | 53690.6 |
515 | 2023-09-24 00:54:57 | serovar | 2 | 107671 | 9 | 2.953 | 36461.6 |
514 | 2023-09-22 20:39:48 | serovar | 4 | 151207 | 1319 | 15.423 | 9804.0 |
513 | 2023-09-14 12:15:17 | serovar | 1 | 69583 | 2 | 1.203 | 57841.2 |
512 | 2023-09-10 19:19:07 | serovar | 4 | 151207 | 1319 | 32.766 | 4614.8 |
511 | 2023-09-03 01:27:35 | serovar | 4 | 151207 | 1319 | 11.623 | 13009.3 |
510 | 2023-07-08 02:13:23 | serovar | 3 | 134027 | 94 | 7.016 | 19103.1 |
509 | 2023-07-06 16:38:34 | serovar | 1 | 69583 | 2 | 1.140 | 61037.7 |
508 | 2023-06-30 10:09:13 | serovar | 2 | 107671 | 9 | 6.686 | 16103.9 |
507 | 2023-06-07 22:51:24 | serovar | 1 | 69583 | 2 | 1.126 | 61796.6 |
506 | 2023-05-20 00:04:34 | serovar | 4 | 151207 | 1319 | 11.623 | 13009.3 |
505 | 2023-05-10 15:25:41 | serovar | 4 | 151207 | 1319 | 9.970 | 15166.2 |
504 | 2023-04-16 03:05:06 | serovar | 1 | 69583 | 2 | 1.106 | 62914.1 |
503 | 2023-03-28 01:18:54 | serovar | 4 | 151207 | 1319 | 11.736 | 12884.0 |
502 | 2023-03-26 15:54:00 | serovar | 3 | 134027 | 94 | 6.000 | 22337.8 |
501 | 2023-03-21 17:31:06 | serovar | 2 | 107671 | 9 | 2.936 | 36672.7 |
500 | 2023-03-03 00:36:29 | serovar | 4 | 151207 | 1319 | 10.046 | 15051.5 |
499 | 2023-02-28 19:54:39 | serovar | 4 | 151207 | 1319 | 10.983 | 13767.4 |
498 | 2023-02-12 23:21:19 | serovar | 1 | 69583 | 2 | 1.096 | 63488.1 |
497 | 2023-02-08 09:27:26 | serovar | 1 | 69583 | 2 | 1.096 | 63488.1 |
496 | 2022-12-23 19:13:39 | serovar | 3 | 134027 | 94 | 5.860 | 22871.5 |
495 | 2022-12-22 01:32:44 | serovar | 2 | 107671 | 9 | 2.906 | 37051.3 |
494 | 2022-12-08 20:51:49 | serovar | 4 | 151207 | 1319 | 10.063 | 15026.0 |
493 | 2022-10-01 04:36:37 | serovar | 1 | 69583 | 2 | 1.123 | 61961.7 |
492 | 2022-08-23 04:35:22 | serovar | 3 | 134027 | 94 | 5.906 | 22693.4 |
491 | 2022-08-19 05:40:58 | serovar | 2 | 107671 | 9 | 3.173 | 33933.5 |
490 | 2022-07-24 06:51:06 | serovar | 4 | 151207 | 1319 | 10.173 | 14863.6 |
489 | 2022-06-17 10:51:26 | serovar | 1 | 69583 | 2 | 1.220 | 57035.2 |
488 | 2022-06-15 05:34:33 | serovar | 1 | 69583 | 2 | 1.266 | 54962.9 |
487 | 2022-05-07 13:50:46 | serovar | 1 | 69583 | 2 | 1.110 | 62687.4 |
486 | 2022-01-06 18:08:41 | serovar | 1 | 69583 | 2 | 1.296 | 53690.6 |
485 | 2021-09-17 19:44:52 | serovar | 1 | 69583 | 2 | 1.263 | 55093.4 |
484 | 2021-06-14 10:45:07 | serovar | 1 | 69583 | 2 | 1.143 | 60877.5 |
483 | 2021-03-25 09:30:40 | serovar | 1 | 69583 | 2 | 1.236 | 56296.9 |
482 | 2021-03-11 15:05:50 | serovar | 1 | 69583 | 2 | 1.266 | 54962.9 |
481 | 2021-01-08 12:36:45 | serovar | 1 | 69583 | 2 | 1.280 | 54361.7 |
480 | 2020-12-10 04:07:31 | serovar | 1 | 69583 | 2 | 1.110 | 62687.4 |
479 | 2020-12-08 11:00:56 | serovar | 1 | 69583 | 2 | 1.110 | 62687.4 |
478 | 2020-11-11 09:35:32 | serovar | 1 | 69583 | 2 | 1.313 | 52995.4 |
477 | 2020-11-04 03:03:52 | serovar | 1 | 69583 | 2 | 1.140 | 61037.7 |
476 | 2020-11-03 21:47:59 | serovar | 1 | 69583 | 2 | 1.156 | 60192.9 |
475 | 2020-09-10 13:45:55 | serovar | 1 | 69583 | 2 | 1.110 | 62687.4 |
474 | 2020-09-05 05:46:37 | serovar | 1 | 69583 | 2 | 1.110 | 62687.4 |
473 | 2020-09-01 20:56:44 | serovar | 1 | 69583 | 2 | 1.250 | 55666.4 |
472 | 2020-07-25 00:29:38 | serovar | 1 | 69583 | 2 | 1.216 | 57222.9 |
471 | 2020-05-22 00:41:54 | serovar | 1 | 69583 | 2 | 1.233 | 56433.9 |
470 | 2020-05-18 21:15:44 | serovar | 1 | 69583 | 2 | 1.126 | 61796.6 |
469 | 2020-03-26 08:53:58 | serovar | 1 | 69583 | 2 | 1.330 | 52318.0 |
468 | 2020-03-25 07:01:47 | serovar | 1 | 69583 | 2 | 1.250 | 55666.4 |
467 | 2020-03-21 12:15:48 | serovar | 1 | 69583 | 2 | 1.313 | 52995.4 |
466 | 2020-02-23 20:16:16 | serovar | 1 | 69583 | 2 | 2.736 | 25432.4 |
465 | 2020-02-22 12:02:03 | serovar | 1 | 69583 | 2 | 1.343 | 51811.6 |
464 | 2020-02-18 22:00:52 | serovar | 1 | 69583 | 2 | 3.216 | 21636.5 |
463 | 2020-02-12 11:47:40 | serovar | 4 | 151207 | 1319 | 13.690 | 11045.1 |
462 | 2020-02-07 03:31:26 | serovar | 1 | 69583 | 2 | 1.500 | 46388.7 |