History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shortage"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
533 | 2024-04-09 19:10:41 | shortage | 1 | 82945 | 2 | 2.783 | 29804.2 |
532 | 2024-04-08 04:51:26 | shortage | 1 | 82945 | 2 | 3.360 | 24686.0 |
531 | 2024-04-01 04:13:21 | shortage | 1 | 82945 | 2 | 3.170 | 26165.6 |
530 | 2024-03-30 23:35:17 | shortage | 2 | 121059 | 8 | 6.703 | 18060.4 |
529 | 2024-03-30 23:34:56 | shortage | 3 | 146162 | 111 | 9.220 | 15852.7 |
528 | 2024-03-30 19:20:42 | shortage | 3 | 146162 | 111 | 21.720 | 6729.4 |
527 | 2024-03-30 11:50:00 | shortage | 3 | 146162 | 111 | 8.173 | 17883.5 |
526 | 2024-03-30 11:50:01 | shortage | 2 | 121059 | 8 | 7.126 | 16988.4 |
525 | 2024-03-30 11:49:59 | shortage | 1 | 82945 | 2 | 1.673 | 49578.6 |
524 | 2024-03-08 02:13:25 | shortage | 2 | 121059 | 8 | 7.843 | 15435.3 |
523 | 2024-03-07 21:59:20 | shortage | 2 | 121059 | 8 | 9.720 | 12454.6 |
522 | 2024-03-07 15:50:01 | shortage | 3 | 146162 | 111 | 11.190 | 13061.8 |
521 | 2024-03-07 14:07:37 | shortage | 1 | 82945 | 2 | 1.610 | 51518.6 |
520 | 2024-03-05 18:28:02 | shortage | 2 | 121059 | 8 | 12.580 | 9623.1 |
519 | 2024-03-05 17:03:55 | shortage | 1 | 82945 | 2 | 1.563 | 53067.8 |
518 | 2024-02-29 05:25:18 | shortage | 3 | 146162 | 111 | 15.063 | 9703.4 |
517 | 2024-02-29 05:25:27 | shortage | 1 | 82945 | 2 | 4.530 | 18310.2 |
516 | 2024-02-29 05:25:27 | shortage | 1 | 82945 | 2 | 1.516 | 54713.1 |
515 | 2024-02-29 05:25:22 | shortage | 2 | 121059 | 8 | 4.063 | 29795.5 |
514 | 2024-02-29 05:25:16 | shortage | 2 | 121059 | 8 | 7.390 | 16381.5 |
513 | 2024-02-29 05:25:11 | shortage | 3 | 146162 | 111 | 11.703 | 12489.3 |
512 | 2024-02-08 00:53:13 | shortage | 2 | 121059 | 8 | 8.533 | 14187.2 |
511 | 2024-02-05 12:50:42 | shortage | 1 | 82945 | 2 | 3.283 | 25265.0 |
510 | 2024-01-31 22:43:36 | shortage | 1 | 82945 | 2 | 1.563 | 53067.8 |
509 | 2024-01-30 06:32:31 | shortage | 1 | 82945 | 2 | 1.280 | 64800.8 |
508 | 2024-01-26 15:59:11 | shortage | 3 | 146162 | 111 | 7.966 | 18348.2 |
507 | 2024-01-26 15:58:43 | shortage | 3 | 146162 | 111 | 6.330 | 23090.4 |
506 | 2024-01-06 06:18:05 | shortage | 3 | 146162 | 111 | 6.530 | 22383.2 |
505 | 2023-12-30 05:39:22 | shortage | 1 | 82945 | 2 | 1.453 | 57085.3 |
504 | 2023-12-28 07:18:54 | shortage | 1 | 82945 | 2 | 1.486 | 55817.6 |
503 | 2023-12-09 15:18:48 | shortage | 1 | 82945 | 2 | 1.326 | 62552.8 |
502 | 2023-11-25 17:28:55 | shortage | 1 | 82945 | 2 | 2.890 | 28700.7 |
501 | 2023-11-04 12:02:52 | shortage | 1 | 82945 | 2 | 1.326 | 62552.8 |
500 | 2023-10-18 21:47:32 | shortage | 1 | 82945 | 2 | 1.390 | 59672.7 |
499 | 2023-10-12 23:05:36 | shortage | 3 | 146162 | 111 | 6.876 | 21256.8 |
498 | 2023-10-09 16:55:16 | shortage | 1 | 82945 | 2 | 1.283 | 64649.3 |
497 | 2023-09-10 10:37:22 | shortage | 1 | 82945 | 2 | 1.326 | 62552.8 |
496 | 2023-07-23 17:18:49 | shortage | 3 | 146162 | 111 | 12.643 | 11560.7 |
495 | 2023-06-19 02:47:04 | shortage | 1 | 82945 | 2 | 1.390 | 59672.7 |
494 | 2023-06-03 02:14:30 | shortage | 1 | 82945 | 2 | 1.423 | 58288.8 |
493 | 2023-05-30 20:09:40 | shortage | 1 | 82945 | 2 | 1.266 | 65517.4 |
492 | 2023-04-04 06:20:34 | shortage | 3 | 146162 | 111 | 10.330 | 14149.3 |
491 | 2023-04-02 11:17:51 | shortage | 1 | 82945 | 2 | 1.250 | 66356.0 |
490 | 2023-02-17 19:28:24 | shortage | 3 | 146162 | 111 | 6.153 | 23754.6 |
489 | 2023-01-28 05:02:58 | shortage | 1 | 82945 | 2 | 1.276 | 65003.9 |
488 | 2023-01-19 10:57:04 | shortage | 3 | 146162 | 111 | 6.203 | 23563.1 |
487 | 2023-01-14 20:49:09 | shortage | 1 | 82945 | 2 | 1.280 | 64800.8 |
486 | 2023-01-02 17:58:17 | shortage | 3 | 146162 | 111 | 7.546 | 19369.5 |
485 | 2022-11-05 09:03:10 | shortage | 1 | 82945 | 2 | 1.266 | 65517.4 |
484 | 2022-09-18 15:30:08 | shortage | 1 | 82945 | 2 | 1.486 | 55817.6 |
483 | 2022-09-07 13:50:45 | shortage | 3 | 146162 | 111 | 6.216 | 23513.8 |
482 | 2022-08-06 02:46:47 | shortage | 2 | 121059 | 8 | 3.186 | 37997.2 |
481 | 2022-06-24 12:30:08 | shortage | 1 | 82945 | 2 | 1.266 | 65517.4 |
480 | 2022-06-22 07:19:26 | shortage | 1 | 82945 | 2 | 1.360 | 60989.0 |
479 | 2022-05-05 18:43:38 | shortage | 1 | 82945 | 2 | 1.280 | 64800.8 |
478 | 2022-03-14 15:51:59 | shortage | 1 | 82945 | 2 | 1.936 | 42843.5 |
477 | 2022-01-08 09:27:41 | shortage | 1 | 82945 | 2 | 1.500 | 55296.7 |
476 | 2021-10-14 15:45:28 | shortage | 1 | 82945 | 2 | 1.326 | 62552.8 |
475 | 2021-10-13 18:59:59 | shortage | 1 | 82945 | 2 | 1.623 | 51106.0 |
474 | 2021-10-12 11:31:44 | shortage | 1 | 82945 | 2 | 1.576 | 52630.1 |
473 | 2021-10-11 14:24:06 | shortage | 1 | 82945 | 2 | 1.576 | 52630.1 |
472 | 2021-10-10 11:24:50 | shortage | 1 | 82945 | 2 | 1.360 | 60989.0 |
471 | 2021-09-26 22:11:06 | shortage | 2 | 121059 | 8 | 3.750 | 32282.4 |
470 | 2021-09-21 21:10:07 | shortage | 2 | 121059 | 8 | 3.610 | 33534.3 |
469 | 2021-09-21 12:17:11 | shortage | 1 | 82945 | 2 | 1.423 | 58288.8 |
468 | 2021-09-20 07:59:24 | shortage | 1 | 82945 | 2 | 1.500 | 55296.7 |
467 | 2021-09-16 06:12:30 | shortage | 1 | 82945 | 2 | 1.296 | 64000.8 |
466 | 2021-09-14 10:03:56 | shortage | 1 | 82945 | 2 | 1.326 | 62552.8 |
465 | 2021-06-08 21:22:57 | shortage | 1 | 82945 | 2 | 1.453 | 57085.3 |
464 | 2021-06-05 15:36:18 | shortage | 1 | 82945 | 2 | 1.453 | 57085.3 |
463 | 2021-05-11 14:03:11 | shortage | 1 | 82945 | 2 | 1.330 | 62364.7 |
462 | 2021-04-10 08:04:23 | shortage | 1 | 82945 | 2 | 1.406 | 58993.6 |
461 | 2021-03-09 21:37:59 | shortage | 1 | 82945 | 2 | 1.373 | 60411.5 |
460 | 2021-02-17 14:59:52 | shortage | 1 | 82945 | 2 | 1.313 | 63172.1 |
459 | 2020-12-02 07:29:40 | shortage | 1 | 82945 | 2 | 1.483 | 55930.5 |
458 | 2020-11-13 01:17:13 | shortage | 1 | 82945 | 2 | 2.330 | 35598.7 |
457 | 2020-10-24 13:36:10 | shortage | 1 | 82945 | 2 | 1.313 | 63172.1 |
456 | 2020-10-23 04:26:40 | shortage | 1 | 82945 | 2 | 1.330 | 62364.7 |
455 | 2020-10-20 20:20:57 | shortage | 1 | 82945 | 2 | 1.313 | 63172.1 |
454 | 2020-10-16 03:25:06 | shortage | 1 | 82945 | 2 | 1.390 | 59672.7 |
453 | 2020-08-18 14:32:31 | shortage | 1 | 82945 | 2 | 1.330 | 62364.7 |
452 | 2020-08-09 06:27:47 | shortage | 1 | 82945 | 2 | 1.466 | 56579.1 |
451 | 2020-07-24 07:26:45 | shortage | 1 | 82945 | 2 | 1.530 | 54212.4 |
450 | 2020-05-11 07:09:03 | shortage | 1 | 82945 | 2 | 1.313 | 63172.1 |
449 | 2020-03-28 10:17:17 | shortage | 1 | 82945 | 2 | 1.406 | 58993.6 |
448 | 2020-03-22 15:50:39 | shortage | 1 | 82945 | 2 | 1.420 | 58412.0 |
447 | 2020-02-23 03:01:42 | shortage | 1 | 82945 | 2 | 3.233 | 25655.7 |
446 | 2020-02-19 01:04:04 | shortage | 1 | 82945 | 2 | 1.533 | 54106.3 |
445 | 2020-02-18 00:21:45 | shortage | 1 | 82945 | 2 | 4.173 | 19876.6 |
444 | 2020-02-05 17:21:33 | shortage | 1 | 82945 | 2 | 1.516 | 54713.1 |
443 | 2020-02-03 20:11:17 | shortage | 1 | 82945 | 2 | 3.156 | 26281.7 |
442 | 2020-02-03 17:00:34 | shortage | 1 | 82945 | 2 | 1.453 | 57085.3 |
441 | 2020-01-29 10:18:04 | shortage | 1 | 82945 | 2 | 1.376 | 60279.8 |
440 | 2020-01-24 13:17:08 | shortage | 1 | 82945 | 2 | 2.266 | 36604.1 |
439 | 2020-01-23 20:58:28 | shortage | 1 | 82945 | 2 | 1.593 | 52068.4 |
438 | 2020-01-16 23:55:38 | shortage | 3 | 146162 | 111 | 7.830 | 18666.9 |
437 | 2020-01-16 21:49:49 | shortage | 3 | 146162 | 111 | 7.766 | 18820.8 |
436 | 2020-01-16 17:41:35 | shortage | 3 | 146162 | 111 | 15.173 | 9633.0 |
435 | 2020-01-16 16:07:54 | shortage | 1 | 82945 | 2 | 3.406 | 24352.6 |
434 | 2020-01-16 15:13:43 | shortage | 1 | 82945 | 2 | 1.576 | 52630.1 |