History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gallons"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
591 | 2024-05-09 07:50:04 | gallons | 1 | 69583 | 8 | 1.593 | 43680.5 |
590 | 2024-05-01 01:13:34 | gallons | 1 | 69583 | 8 | 1.283 | 54234.6 |
589 | 2024-04-23 03:36:44 | gallons | 3 | 134027 | 537 | 12.813 | 10460.2 |
588 | 2024-04-22 15:49:38 | gallons | 3 | 134027 | 537 | 26.906 | 4981.3 |
587 | 2024-04-20 16:05:34 | gallons | 3 | 134027 | 537 | 23.080 | 5807.1 |
586 | 2024-04-19 10:15:31 | gallons | 2 | 107671 | 66 | 11.656 | 9237.4 |
585 | 2024-04-19 08:58:33 | gallons | 3 | 134027 | 537 | 8.030 | 16690.8 |
584 | 2024-04-17 02:50:05 | gallons | 3 | 134027 | 537 | 5.796 | 23124.1 |
583 | 2024-04-06 05:53:36 | gallons | 3 | 134027 | 537 | 15.330 | 8742.8 |
582 | 2024-04-06 05:36:09 | gallons | 2 | 107671 | 66 | 4.123 | 26114.7 |
581 | 2024-04-05 14:13:45 | gallons | 3 | 134027 | 537 | 19.546 | 6857.0 |
580 | 2024-04-05 14:13:52 | gallons | 1 | 69583 | 8 | 4.140 | 16807.5 |
579 | 2024-04-05 14:13:40 | gallons | 2 | 107671 | 66 | 8.750 | 12305.3 |
578 | 2024-03-28 18:38:57 | gallons | 1 | 69583 | 8 | 2.843 | 24475.2 |
577 | 2024-03-02 23:03:58 | gallons | 1 | 69583 | 8 | 1.330 | 52318.0 |
576 | 2024-02-28 10:31:12 | gallons | 1 | 69583 | 8 | 3.736 | 18625.0 |
575 | 2024-02-19 08:51:04 | gallons | 1 | 69583 | 8 | 3.890 | 17887.7 |
574 | 2024-02-05 02:03:46 | gallons | 3 | 134027 | 537 | 6.923 | 19359.7 |
573 | 2024-02-04 17:37:39 | gallons | 3 | 134027 | 537 | 11.736 | 11420.2 |
572 | 2024-02-04 17:07:22 | gallons | 3 | 134027 | 537 | 11.420 | 11736.2 |
571 | 2024-01-15 14:39:09 | gallons | 3 | 134027 | 537 | 6.940 | 19312.2 |
570 | 2024-01-15 14:39:07 | gallons | 2 | 107671 | 66 | 3.140 | 34290.1 |
569 | 2024-01-06 09:15:26 | gallons | 3 | 134027 | 537 | 11.123 | 12049.5 |
568 | 2024-01-03 07:52:43 | gallons | 1 | 69583 | 8 | 1.233 | 56433.9 |
567 | 2023-12-16 13:53:08 | gallons | 3 | 134027 | 537 | 10.126 | 13235.9 |
566 | 2023-12-16 13:53:10 | gallons | 2 | 107671 | 66 | 3.170 | 33965.6 |
565 | 2023-12-14 15:57:03 | gallons | 3 | 134027 | 537 | 6.486 | 20664.0 |
564 | 2023-12-10 05:25:14 | gallons | 1 | 69583 | 8 | 1.093 | 63662.4 |
563 | 2023-11-26 10:58:28 | gallons | 1 | 69583 | 8 | 1.093 | 63662.4 |
562 | 2023-11-19 15:16:44 | gallons | 3 | 134027 | 537 | 5.656 | 23696.4 |
561 | 2023-11-14 01:21:32 | gallons | 1 | 69583 | 8 | 1.173 | 59320.5 |
560 | 2023-11-13 15:44:00 | gallons | 1 | 69583 | 8 | 1.063 | 65459.1 |
559 | 2023-11-12 10:03:55 | gallons | 1 | 69583 | 8 | 1.080 | 64428.7 |
558 | 2023-11-01 23:31:27 | gallons | 1 | 69583 | 8 | 1.173 | 59320.5 |
557 | 2023-10-31 14:59:44 | gallons | 1 | 69583 | 8 | 1.063 | 65459.1 |
556 | 2023-10-25 04:18:58 | gallons | 1 | 69583 | 8 | 1.233 | 56433.9 |
555 | 2023-10-11 20:48:03 | gallons | 1 | 69583 | 8 | 1.076 | 64668.2 |
554 | 2023-10-07 19:21:55 | gallons | 1 | 69583 | 8 | 1.156 | 60192.9 |
553 | 2023-09-25 06:04:17 | gallons | 1 | 69583 | 8 | 1.170 | 59472.6 |
552 | 2023-09-25 00:32:28 | gallons | 1 | 69583 | 8 | 1.220 | 57035.2 |
551 | 2023-09-23 20:57:16 | gallons | 1 | 69583 | 8 | 1.060 | 65644.3 |
550 | 2023-09-14 15:06:53 | gallons | 3 | 134027 | 537 | 6.233 | 21502.8 |
549 | 2023-08-27 06:05:39 | gallons | 3 | 134027 | 537 | 5.830 | 22989.2 |
548 | 2023-07-31 07:43:54 | gallons | 1 | 69583 | 8 | 1.186 | 58670.3 |
547 | 2023-07-15 16:13:06 | gallons | 1 | 69583 | 8 | 1.063 | 65459.1 |
546 | 2023-06-14 06:51:19 | gallons | 3 | 134027 | 537 | 5.890 | 22755.0 |
545 | 2023-06-08 01:50:23 | gallons | 3 | 134027 | 537 | 5.593 | 23963.3 |
544 | 2023-04-22 22:17:01 | gallons | 1 | 69583 | 8 | 1.076 | 64668.2 |
543 | 2023-04-16 01:08:35 | gallons | 1 | 69583 | 8 | 1.063 | 65459.1 |
542 | 2023-03-14 22:29:15 | gallons | 3 | 134027 | 537 | 5.576 | 24036.4 |
541 | 2023-02-09 18:42:41 | gallons | 1 | 69583 | 8 | 1.063 | 65459.1 |
540 | 2023-01-10 12:52:20 | gallons | 1 | 69583 | 8 | 1.313 | 52995.4 |
539 | 2023-01-02 23:39:53 | gallons | 3 | 134027 | 537 | 6.923 | 19359.7 |
538 | 2022-12-18 05:12:58 | gallons | 3 | 134027 | 537 | 5.610 | 23890.7 |
537 | 2022-12-07 11:46:47 | gallons | 1 | 69583 | 8 | 1.046 | 66522.9 |
536 | 2022-11-23 03:47:08 | gallons | 3 | 134027 | 537 | 6.080 | 22043.9 |
535 | 2022-09-30 07:34:50 | gallons | 1 | 69583 | 8 | 1.063 | 65459.1 |
534 | 2022-09-26 17:23:07 | gallons | 1 | 69583 | 8 | 1.063 | 65459.1 |
533 | 2022-08-23 18:51:46 | gallons | 3 | 134027 | 537 | 5.923 | 22628.2 |
532 | 2022-08-11 18:59:46 | gallons | 3 | 134027 | 537 | 5.736 | 23365.9 |
531 | 2022-08-05 13:07:46 | gallons | 1 | 69583 | 8 | 1.233 | 56433.9 |
530 | 2022-08-03 03:47:13 | gallons | 1 | 69583 | 8 | 1.093 | 63662.4 |
529 | 2022-06-13 08:26:57 | gallons | 1 | 69583 | 8 | 1.296 | 53690.6 |
528 | 2022-03-24 01:58:47 | gallons | 1 | 69583 | 8 | 1.546 | 45008.4 |
527 | 2022-02-26 04:20:46 | gallons | 1 | 69583 | 8 | 1.063 | 65459.1 |
526 | 2022-02-26 03:52:26 | gallons | 1 | 69583 | 8 | 1.466 | 47464.5 |
525 | 2022-02-22 18:16:47 | gallons | 1 | 69583 | 8 | 1.216 | 57222.9 |
524 | 2022-02-03 16:26:44 | gallons | 3 | 134027 | 537 | 6.783 | 19759.3 |
523 | 2021-12-28 20:19:02 | gallons | 1 | 69583 | 8 | 1.233 | 56433.9 |
522 | 2021-12-25 18:10:09 | gallons | 1 | 69583 | 8 | 1.283 | 54234.6 |
521 | 2021-12-23 10:29:20 | gallons | 3 | 134027 | 537 | 7.093 | 18895.7 |
520 | 2021-12-20 11:28:31 | gallons | 3 | 134027 | 537 | 12.563 | 10668.4 |
519 | 2021-12-19 11:26:37 | gallons | 3 | 134027 | 537 | 6.736 | 19897.1 |
518 | 2021-12-18 11:22:09 | gallons | 3 | 134027 | 537 | 10.143 | 13213.7 |
517 | 2021-12-17 11:21:22 | gallons | 3 | 134027 | 537 | 6.813 | 19672.2 |
516 | 2021-12-15 11:16:34 | gallons | 3 | 134027 | 537 | 7.156 | 18729.3 |
515 | 2021-11-28 16:34:16 | gallons | 3 | 134027 | 537 | 10.920 | 12273.5 |
514 | 2021-11-27 13:39:46 | gallons | 3 | 134027 | 537 | 6.326 | 21186.7 |
513 | 2021-11-17 23:15:00 | gallons | 1 | 69583 | 8 | 1.250 | 55666.4 |
512 | 2021-10-30 14:46:59 | gallons | 1 | 69583 | 8 | 1.263 | 55093.4 |
511 | 2021-09-21 04:28:45 | gallons | 3 | 134027 | 537 | 6.313 | 21230.3 |
510 | 2021-09-17 10:51:06 | gallons | 3 | 134027 | 537 | 8.516 | 15738.3 |
509 | 2021-09-14 15:16:58 | gallons | 1 | 69583 | 8 | 1.186 | 58670.3 |
508 | 2021-08-25 20:59:49 | gallons | 1 | 69583 | 8 | 1.173 | 59320.5 |
507 | 2021-08-18 10:40:31 | gallons | 1 | 69583 | 8 | 1.060 | 65644.3 |
506 | 2021-08-02 10:05:50 | gallons | 3 | 134027 | 537 | 6.610 | 20276.4 |
505 | 2021-07-30 21:13:01 | gallons | 3 | 134027 | 537 | 5.796 | 23124.1 |
504 | 2021-07-05 23:48:51 | gallons | 1 | 69583 | 8 | 1.220 | 57035.2 |
503 | 2021-06-17 14:19:05 | gallons | 3 | 134027 | 537 | 6.186 | 21666.2 |
502 | 2021-06-15 01:17:35 | gallons | 3 | 134027 | 537 | 7.343 | 18252.3 |
501 | 2021-06-04 16:38:55 | gallons | 2 | 107671 | 66 | 2.830 | 38046.3 |
500 | 2021-05-28 17:08:57 | gallons | 3 | 134027 | 537 | 5.830 | 22989.2 |
499 | 2021-05-17 18:24:11 | gallons | 1 | 69583 | 8 | 1.220 | 57035.2 |
498 | 2021-05-15 14:21:12 | gallons | 3 | 134027 | 537 | 7.126 | 18808.2 |
497 | 2021-05-08 04:57:23 | gallons | 3 | 134027 | 537 | 11.233 | 11931.5 |
496 | 2021-05-06 04:39:24 | gallons | 3 | 134027 | 537 | 6.310 | 21240.4 |
495 | 2021-04-29 20:12:41 | gallons | 3 | 134027 | 537 | 13.623 | 9838.3 |
494 | 2021-04-28 20:06:12 | gallons | 3 | 134027 | 537 | 6.623 | 20236.6 |
493 | 2021-04-28 14:52:23 | gallons | 3 | 134027 | 537 | 6.283 | 21331.7 |
492 | 2021-04-28 05:26:44 | gallons | 3 | 134027 | 537 | 6.660 | 20124.2 |