History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pillows"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
563 | 2024-04-22 13:59:32 | pillows | 1 | 69583 | 5 | 4.843 | 14367.7 |
562 | 2024-04-06 19:19:39 | pillows | 2 | 107671 | 40 | 13.813 | 7794.9 |
561 | 2024-03-25 01:54:39 | pillows | 2 | 107671 | 40 | 3.190 | 33752.7 |
560 | 2024-03-25 01:53:53 | pillows | 3 | 134027 | 301 | 7.423 | 18055.6 |
559 | 2024-03-24 17:24:32 | pillows | 2 | 107671 | 40 | 3.296 | 32667.2 |
558 | 2024-03-24 17:23:45 | pillows | 3 | 134027 | 301 | 7.110 | 18850.5 |
557 | 2024-03-24 14:18:20 | pillows | 3 | 134027 | 301 | 24.956 | 5370.5 |
556 | 2024-03-23 02:18:36 | pillows | 1 | 69583 | 5 | 2.733 | 25460.3 |
555 | 2024-03-21 22:22:44 | pillows | 3 | 134027 | 301 | 8.033 | 16684.6 |
554 | 2024-03-12 19:35:39 | pillows | 2 | 107671 | 40 | 10.546 | 10209.7 |
553 | 2024-03-12 19:35:37 | pillows | 1 | 69583 | 5 | 4.236 | 16426.6 |
552 | 2024-03-12 19:35:18 | pillows | 3 | 134027 | 301 | 7.826 | 17125.9 |
551 | 2024-03-12 11:55:15 | pillows | 3 | 134027 | 301 | 9.046 | 14816.2 |
550 | 2024-03-01 03:24:05 | pillows | 1 | 69583 | 5 | 1.373 | 50679.5 |
549 | 2024-02-21 21:13:59 | pillows | 1 | 69583 | 5 | 4.030 | 17266.3 |
548 | 2024-02-01 19:43:35 | pillows | 1 | 69583 | 5 | 1.216 | 57222.9 |
547 | 2024-01-13 23:04:40 | pillows | 1 | 69583 | 5 | 1.173 | 59320.5 |
546 | 2024-01-09 02:58:33 | pillows | 3 | 134027 | 301 | 7.156 | 18729.3 |
545 | 2024-01-09 02:58:32 | pillows | 2 | 107671 | 40 | 3.390 | 31761.4 |
544 | 2023-12-25 10:43:05 | pillows | 1 | 69583 | 5 | 1.093 | 63662.4 |
543 | 2023-12-14 20:50:23 | pillows | 1 | 69583 | 5 | 1.250 | 55666.4 |
542 | 2023-12-07 03:36:35 | pillows | 2 | 107671 | 40 | 2.966 | 36301.8 |
541 | 2023-11-27 00:55:23 | pillows | 3 | 134027 | 301 | 6.906 | 19407.3 |
540 | 2023-11-18 20:49:00 | pillows | 1 | 69583 | 5 | 2.796 | 24886.6 |
539 | 2023-11-16 09:56:56 | pillows | 1 | 69583 | 5 | 1.313 | 52995.4 |
538 | 2023-11-16 06:39:02 | pillows | 1 | 69583 | 5 | 1.093 | 63662.4 |
537 | 2023-11-15 03:33:22 | pillows | 1 | 69583 | 5 | 1.080 | 64428.7 |
536 | 2023-11-06 03:40:31 | pillows | 1 | 69583 | 5 | 1.173 | 59320.5 |
535 | 2023-11-03 12:15:35 | pillows | 1 | 69583 | 5 | 1.220 | 57035.2 |
534 | 2023-10-13 23:06:12 | pillows | 1 | 69583 | 5 | 1.186 | 58670.3 |
533 | 2023-09-29 08:46:39 | pillows | 1 | 69583 | 5 | 1.156 | 60192.9 |
532 | 2023-09-26 03:28:33 | pillows | 1 | 69583 | 5 | 1.263 | 55093.4 |
531 | 2023-09-04 20:57:59 | pillows | 2 | 107671 | 40 | 3.220 | 33438.2 |
530 | 2023-08-29 02:34:39 | pillows | 1 | 69583 | 5 | 1.110 | 62687.4 |
529 | 2023-08-26 02:21:33 | pillows | 3 | 134027 | 301 | 5.673 | 23625.4 |
528 | 2023-08-12 16:32:21 | pillows | 3 | 134027 | 301 | 6.983 | 19193.3 |
527 | 2023-07-18 13:09:52 | pillows | 1 | 69583 | 5 | 1.080 | 64428.7 |
526 | 2023-07-14 16:56:02 | pillows | 1 | 69583 | 5 | 1.093 | 63662.4 |
525 | 2023-06-23 01:51:33 | pillows | 3 | 134027 | 301 | 6.626 | 20227.4 |
524 | 2023-06-15 09:33:22 | pillows | 3 | 134027 | 301 | 6.626 | 20227.4 |
523 | 2023-06-14 11:05:34 | pillows | 3 | 134027 | 301 | 7.250 | 18486.5 |
522 | 2023-06-13 10:50:52 | pillows | 3 | 134027 | 301 | 6.906 | 19407.3 |
521 | 2023-06-11 11:34:58 | pillows | 3 | 134027 | 301 | 6.936 | 19323.4 |
520 | 2023-06-10 20:12:54 | pillows | 3 | 134027 | 301 | 6.436 | 20824.6 |
519 | 2023-05-26 08:46:48 | pillows | 1 | 69583 | 5 | 1.080 | 64428.7 |
518 | 2023-05-22 04:18:21 | pillows | 2 | 107671 | 40 | 3.296 | 32667.2 |
517 | 2023-05-11 02:08:23 | pillows | 3 | 134027 | 301 | 5.670 | 23637.9 |
516 | 2023-03-23 07:03:12 | pillows | 1 | 69583 | 5 | 1.080 | 64428.7 |
515 | 2023-03-20 03:32:34 | pillows | 1 | 69583 | 5 | 1.296 | 53690.6 |
514 | 2023-03-16 20:29:25 | pillows | 1 | 69583 | 5 | 1.080 | 64428.7 |
513 | 2023-02-28 08:24:29 | pillows | 2 | 107671 | 40 | 3.220 | 33438.2 |
512 | 2023-02-18 20:17:43 | pillows | 3 | 134027 | 301 | 6.063 | 22105.7 |
511 | 2023-01-09 09:48:56 | pillows | 1 | 69583 | 5 | 1.050 | 66269.5 |
510 | 2022-12-10 00:04:45 | pillows | 2 | 107671 | 40 | 2.766 | 38926.6 |
509 | 2022-12-01 22:50:18 | pillows | 3 | 134027 | 301 | 6.673 | 20085.0 |
508 | 2022-12-01 05:03:54 | pillows | 3 | 134027 | 301 | 5.593 | 23963.3 |
507 | 2022-11-29 23:29:09 | pillows | 3 | 134027 | 301 | 6.500 | 20619.5 |
506 | 2022-11-27 23:18:14 | pillows | 3 | 134027 | 301 | 6.703 | 19995.1 |
505 | 2022-11-18 12:00:16 | pillows | 1 | 69583 | 5 | 1.203 | 57841.2 |
504 | 2022-10-05 20:31:52 | pillows | 1 | 69583 | 5 | 1.080 | 64428.7 |
503 | 2022-07-24 10:57:51 | pillows | 2 | 107671 | 40 | 2.813 | 38276.2 |
502 | 2022-07-22 01:35:38 | pillows | 1 | 69583 | 5 | 1.126 | 61796.6 |
501 | 2022-07-07 17:37:34 | pillows | 3 | 134027 | 301 | 5.640 | 23763.7 |
500 | 2022-05-25 13:01:02 | pillows | 3 | 134027 | 301 | 7.110 | 18850.5 |
499 | 2022-05-20 15:56:42 | pillows | 1 | 69583 | 5 | 1.186 | 58670.3 |
498 | 2022-04-29 02:36:28 | pillows | 3 | 134027 | 301 | 6.580 | 20368.8 |
497 | 2022-03-31 20:21:20 | pillows | 3 | 134027 | 301 | 6.093 | 21996.9 |
496 | 2022-03-31 05:59:42 | pillows | 1 | 69583 | 5 | 1.063 | 65459.1 |
495 | 2022-03-21 20:50:29 | pillows | 3 | 134027 | 301 | 6.733 | 19906.0 |
494 | 2022-03-20 22:05:27 | pillows | 3 | 134027 | 301 | 5.653 | 23709.0 |
493 | 2022-03-02 03:17:10 | pillows | 2 | 107671 | 40 | 3.436 | 31336.1 |
492 | 2022-02-18 19:40:13 | pillows | 3 | 134027 | 301 | 5.940 | 22563.5 |
491 | 2022-02-16 15:56:13 | pillows | 3 | 134027 | 301 | 6.500 | 20619.5 |
490 | 2022-02-02 00:59:19 | pillows | 1 | 69583 | 5 | 1.063 | 65459.1 |
489 | 2021-12-11 02:52:13 | pillows | 3 | 134027 | 301 | 7.093 | 18895.7 |
488 | 2021-12-10 08:11:09 | pillows | 1 | 69583 | 5 | 1.423 | 48898.8 |
487 | 2021-12-10 05:30:31 | pillows | 3 | 134027 | 301 | 9.780 | 13704.2 |
486 | 2021-12-09 00:49:04 | pillows | 3 | 134027 | 301 | 11.186 | 11981.7 |
485 | 2021-11-28 02:54:37 | pillows | 2 | 107671 | 40 | 2.906 | 37051.3 |
484 | 2021-11-23 23:42:20 | pillows | 1 | 69583 | 5 | 1.096 | 63488.1 |
483 | 2021-11-17 06:20:03 | pillows | 3 | 134027 | 301 | 5.750 | 23309.0 |
482 | 2021-11-10 08:58:44 | pillows | 3 | 134027 | 301 | 5.906 | 22693.4 |
481 | 2021-11-09 22:40:56 | pillows | 3 | 134027 | 301 | 5.953 | 22514.2 |
480 | 2021-11-09 10:56:44 | pillows | 3 | 134027 | 301 | 12.110 | 11067.5 |
479 | 2021-11-08 11:34:04 | pillows | 3 | 134027 | 301 | 5.686 | 23571.4 |
478 | 2021-10-25 20:49:35 | pillows | 3 | 134027 | 301 | 6.766 | 19808.9 |
477 | 2021-10-24 20:57:35 | pillows | 3 | 134027 | 301 | 5.906 | 22693.4 |
476 | 2021-10-23 17:50:49 | pillows | 3 | 134027 | 301 | 5.860 | 22871.5 |
475 | 2021-10-07 14:44:33 | pillows | 1 | 69583 | 5 | 1.220 | 57035.2 |
474 | 2021-10-05 12:37:32 | pillows | 1 | 69583 | 5 | 1.250 | 55666.4 |
473 | 2021-09-14 05:24:36 | pillows | 1 | 69583 | 5 | 1.250 | 55666.4 |
472 | 2021-08-27 09:25:10 | pillows | 1 | 69583 | 5 | 1.093 | 63662.4 |
471 | 2021-08-24 02:12:20 | pillows | 1 | 69583 | 5 | 1.190 | 58473.1 |
470 | 2021-06-08 15:43:47 | pillows | 3 | 134027 | 301 | 6.860 | 19537.5 |
469 | 2021-06-07 01:46:48 | pillows | 3 | 134027 | 301 | 7.310 | 18334.7 |
468 | 2021-06-03 02:08:07 | pillows | 3 | 134027 | 301 | 6.576 | 20381.2 |
467 | 2021-05-20 01:01:30 | pillows | 1 | 69583 | 5 | 1.220 | 57035.2 |
466 | 2021-05-08 20:37:25 | pillows | 3 | 134027 | 301 | 6.156 | 21771.8 |
465 | 2021-04-29 09:20:56 | pillows | 1 | 69583 | 5 | 1.233 | 56433.9 |
464 | 2021-03-28 22:50:24 | pillows | 1 | 69583 | 5 | 1.140 | 61037.7 |