History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crisps"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 556 | 2024-05-04 13:24:30 | crisps | 1 | 48755 | 6 | 0.936 | 52088.7 |
| 555 | 2024-05-03 09:57:42 | crisps | 2 | 82551 | 78 | 2.826 | 29211.3 |
| 554 | 2024-04-29 17:57:50 | crisps | 3 | 112716 | 789 | 12.720 | 8861.3 |
| 553 | 2024-04-28 02:55:10 | crisps | 1 | 48755 | 6 | 1.893 | 25755.4 |
| 552 | 2024-04-28 00:26:16 | crisps | 3 | 112716 | 789 | 14.546 | 7748.9 |
| 551 | 2024-04-27 17:11:24 | crisps | 3 | 112716 | 789 | 13.280 | 8487.7 |
| 550 | 2024-04-14 15:53:34 | crisps | 3 | 112716 | 789 | 20.863 | 5402.7 |
| 549 | 2024-04-06 14:17:32 | crisps | 3 | 112716 | 789 | 6.533 | 17253.3 |
| 548 | 2024-04-06 14:17:34 | crisps | 2 | 82551 | 78 | 3.110 | 26543.7 |
| 547 | 2024-04-06 14:17:20 | crisps | 1 | 48755 | 6 | 0.890 | 54780.9 |
| 546 | 2024-03-31 10:42:17 | crisps | 1 | 48755 | 6 | 3.766 | 12946.1 |
| 545 | 2024-03-30 05:45:07 | crisps | 3 | 112716 | 789 | 9.220 | 12225.2 |
| 544 | 2024-03-30 05:45:07 | crisps | 2 | 82551 | 78 | 2.873 | 28733.4 |
| 543 | 2024-03-29 02:18:38 | crisps | 3 | 112716 | 789 | 10.140 | 11116.0 |
| 542 | 2024-03-29 02:18:36 | crisps | 2 | 82551 | 78 | 5.686 | 14518.3 |
| 541 | 2024-03-29 02:18:32 | crisps | 1 | 48755 | 6 | 2.283 | 21355.7 |
| 540 | 2024-03-20 19:05:37 | crisps | 3 | 112716 | 789 | 6.986 | 16134.6 |
| 539 | 2024-03-20 19:05:30 | crisps | 2 | 82551 | 78 | 3.733 | 22113.8 |
| 538 | 2024-03-20 19:05:00 | crisps | 1 | 48755 | 6 | 1.500 | 32503.3 |
| 537 | 2024-03-20 19:04:35 | crisps | 3 | 112716 | 789 | 12.466 | 9041.9 |
| 536 | 2024-03-20 19:04:31 | crisps | 2 | 82551 | 78 | 5.800 | 14232.9 |
| 535 | 2024-03-08 04:03:09 | crisps | 1 | 48755 | 6 | 0.970 | 50262.9 |
| 534 | 2024-03-07 03:21:31 | crisps | 2 | 82551 | 78 | 3.140 | 26290.1 |
| 533 | 2024-03-07 02:20:15 | crisps | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 532 | 2024-03-02 18:18:50 | crisps | 3 | 112716 | 789 | 6.670 | 16899.0 |
| 531 | 2024-03-01 11:33:09 | crisps | 3 | 112716 | 789 | 4.780 | 23580.8 |
| 530 | 2024-02-21 05:47:58 | crisps | 3 | 112716 | 789 | 19.876 | 5671.0 |
| 529 | 2024-02-20 19:30:23 | crisps | 3 | 112716 | 789 | 6.813 | 16544.3 |
| 528 | 2024-02-18 14:54:19 | crisps | 3 | 112716 | 789 | 4.830 | 23336.6 |
| 527 | 2024-02-18 14:54:18 | crisps | 2 | 82551 | 78 | 2.390 | 34540.2 |
| 526 | 2024-02-07 20:20:31 | crisps | 2 | 82551 | 78 | 2.686 | 30733.8 |
| 525 | 2024-02-07 20:20:02 | crisps | 3 | 112716 | 789 | 5.453 | 20670.5 |
| 524 | 2024-02-04 21:13:26 | crisps | 2 | 82551 | 78 | 3.063 | 26951.0 |
| 523 | 2024-02-04 21:13:22 | crisps | 3 | 112716 | 789 | 6.593 | 17096.3 |
| 522 | 2024-01-20 00:17:23 | crisps | 3 | 112716 | 789 | 5.876 | 19182.4 |
| 521 | 2024-01-14 00:11:06 | crisps | 3 | 112716 | 789 | 5.783 | 19490.9 |
| 520 | 2024-01-14 00:11:07 | crisps | 2 | 82551 | 78 | 2.673 | 30883.3 |
| 519 | 2023-12-28 03:04:42 | crisps | 3 | 112716 | 789 | 5.143 | 21916.4 |
| 518 | 2023-12-28 03:04:43 | crisps | 2 | 82551 | 78 | 2.483 | 33246.5 |
| 517 | 2023-12-22 07:05:08 | crisps | 2 | 82551 | 78 | 2.186 | 37763.5 |
| 516 | 2023-12-14 04:55:17 | crisps | 1 | 48755 | 6 | 0.796 | 61250.0 |
| 515 | 2023-11-20 20:11:47 | crisps | 3 | 112716 | 789 | 5.143 | 21916.4 |
| 514 | 2023-11-20 09:07:58 | crisps | 1 | 48755 | 6 | 1.436 | 33951.9 |
| 513 | 2023-11-18 06:12:45 | crisps | 1 | 48755 | 6 | 0.780 | 62506.4 |
| 512 | 2023-11-16 06:52:05 | crisps | 1 | 48755 | 6 | 0.923 | 52822.3 |
| 511 | 2023-10-30 09:06:15 | crisps | 1 | 48755 | 6 | 1.640 | 29728.7 |
| 510 | 2023-10-26 04:34:29 | crisps | 1 | 48755 | 6 | 0.953 | 51159.5 |
| 509 | 2023-10-18 04:33:33 | crisps | 1 | 48755 | 6 | 0.860 | 56691.9 |
| 508 | 2023-10-13 23:15:51 | crisps | 1 | 48755 | 6 | 0.873 | 55847.7 |
| 507 | 2023-10-05 04:24:19 | crisps | 1 | 48755 | 6 | 0.843 | 57835.1 |
| 506 | 2023-10-01 05:17:27 | crisps | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 505 | 2023-09-30 00:56:14 | crisps | 2 | 82551 | 78 | 2.483 | 33246.5 |
| 504 | 2023-09-29 08:36:47 | crisps | 2 | 82551 | 78 | 3.626 | 22766.4 |
| 503 | 2023-09-24 08:31:40 | crisps | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 502 | 2023-09-23 15:34:20 | crisps | 2 | 82551 | 78 | 2.420 | 34112.0 |
| 501 | 2023-09-13 12:34:19 | crisps | 1 | 48755 | 6 | 0.860 | 56691.9 |
| 500 | 2023-08-21 18:16:58 | crisps | 3 | 112716 | 789 | 5.280 | 21347.7 |
| 499 | 2023-08-05 05:51:37 | crisps | 3 | 112716 | 789 | 8.483 | 13287.3 |
| 498 | 2023-08-03 17:33:12 | crisps | 1 | 48755 | 6 | 0.860 | 56691.9 |
| 497 | 2023-07-28 08:22:17 | crisps | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 496 | 2023-07-04 09:39:10 | crisps | 2 | 82551 | 78 | 2.516 | 32810.4 |
| 495 | 2023-05-04 23:29:44 | crisps | 3 | 112716 | 789 | 5.486 | 20546.1 |
| 494 | 2023-04-27 05:52:18 | crisps | 1 | 48755 | 6 | 0.763 | 63899.1 |
| 493 | 2023-04-22 13:43:22 | crisps | 1 | 48755 | 6 | 0.763 | 63899.1 |
| 492 | 2023-04-11 19:08:37 | crisps | 3 | 112716 | 789 | 4.750 | 23729.7 |
| 491 | 2023-03-22 06:48:30 | crisps | 2 | 82551 | 78 | 2.126 | 38829.3 |
| 490 | 2023-03-15 15:18:20 | crisps | 3 | 112716 | 789 | 4.670 | 24136.2 |
| 489 | 2023-02-17 22:49:52 | crisps | 3 | 112716 | 789 | 5.046 | 22337.7 |
| 488 | 2023-02-17 00:51:12 | crisps | 1 | 48755 | 6 | 0.736 | 66243.2 |
| 487 | 2023-02-15 06:28:47 | crisps | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 486 | 2023-02-11 05:22:28 | crisps | 3 | 112716 | 789 | 5.296 | 21283.2 |
| 485 | 2023-01-10 04:00:57 | crisps | 1 | 48755 | 6 | 0.753 | 64747.7 |
| 484 | 2023-01-01 04:14:29 | crisps | 3 | 112716 | 789 | 4.660 | 24188.0 |
| 483 | 2022-12-26 21:52:08 | crisps | 1 | 48755 | 6 | 0.843 | 57835.1 |
| 482 | 2022-12-21 15:08:28 | crisps | 2 | 82551 | 78 | 2.500 | 33020.4 |
| 481 | 2022-12-14 20:32:06 | crisps | 1 | 48755 | 6 | 1.670 | 29194.6 |
| 480 | 2022-11-30 18:33:46 | crisps | 3 | 112716 | 789 | 4.640 | 24292.2 |
| 479 | 2022-11-27 11:45:35 | crisps | 3 | 112716 | 789 | 4.876 | 23116.5 |
| 478 | 2022-11-23 08:48:48 | crisps | 3 | 112716 | 789 | 5.733 | 19660.9 |
| 477 | 2022-11-14 10:46:51 | crisps | 1 | 48755 | 6 | 0.796 | 61250.0 |
| 476 | 2022-09-26 08:17:52 | crisps | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 475 | 2022-09-03 22:46:41 | crisps | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 474 | 2022-08-22 17:26:08 | crisps | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 473 | 2022-08-17 15:15:34 | crisps | 2 | 82551 | 78 | 2.170 | 38041.9 |
| 472 | 2022-06-09 09:04:21 | crisps | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 471 | 2022-06-05 18:05:09 | crisps | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 470 | 2022-05-18 21:22:10 | crisps | 1 | 48755 | 6 | 0.826 | 59025.4 |
| 469 | 2022-04-28 16:51:42 | crisps | 3 | 112716 | 789 | 5.783 | 19490.9 |
| 468 | 2022-04-12 04:54:12 | crisps | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 467 | 2022-04-08 15:19:33 | crisps | 1 | 48755 | 6 | 1.156 | 42175.6 |
| 466 | 2022-03-01 19:28:57 | crisps | 1 | 48755 | 6 | 1.076 | 45311.3 |
| 465 | 2022-02-28 19:56:22 | crisps | 1 | 48755 | 6 | 0.783 | 62266.9 |
| 464 | 2022-02-27 20:30:36 | crisps | 1 | 48755 | 6 | 0.860 | 56691.9 |
| 463 | 2022-02-26 22:13:10 | crisps | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 462 | 2022-02-25 14:28:56 | crisps | 1 | 48755 | 6 | 0.953 | 51159.5 |
| 461 | 2022-02-18 23:56:17 | crisps | 1 | 48755 | 6 | 0.860 | 56691.9 |
| 460 | 2022-01-08 00:39:00 | crisps | 1 | 48755 | 6 | 0.843 | 57835.1 |
| 459 | 2022-01-05 22:03:10 | crisps | 1 | 48755 | 6 | 0.906 | 53813.5 |
| 458 | 2021-12-09 12:53:07 | crisps | 1 | 48755 | 6 | 1.796 | 27146.4 |
| 457 | 2021-11-24 18:38:34 | crisps | 1 | 48755 | 6 | 0.830 | 58741.0 |