History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fruit"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 537 | 2024-04-13 21:24:18 | fruit | 3 | 83667 | 884 | 15.093 | 5543.4 |
| 536 | 2024-04-13 12:43:17 | fruit | 2 | 53800 | 58 | 1.640 | 32804.9 |
| 535 | 2024-04-13 12:42:49 | fruit | 1 | 28756 | 5 | 0.610 | 47141.0 |
| 534 | 2024-04-13 12:42:01 | fruit | 3 | 83667 | 884 | 6.826 | 12257.1 |
| 533 | 2024-04-13 12:42:01 | fruit | 3 | 83667 | 884 | 4.266 | 19612.5 |
| 532 | 2024-04-06 12:00:57 | fruit | 1 | 28756 | 5 | 0.953 | 30174.2 |
| 531 | 2024-04-04 19:44:03 | fruit | 1 | 28756 | 5 | 1.893 | 15190.7 |
| 530 | 2024-03-31 15:37:06 | fruit | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 529 | 2024-03-29 07:14:39 | fruit | 1 | 28756 | 5 | 1.423 | 20208.0 |
| 528 | 2024-03-29 00:02:50 | fruit | 3 | 83667 | 884 | 9.986 | 8378.4 |
| 527 | 2024-03-29 00:02:50 | fruit | 2 | 53800 | 58 | 1.813 | 29674.6 |
| 526 | 2024-03-28 23:02:18 | fruit | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 525 | 2024-03-10 18:03:08 | fruit | 3 | 83667 | 884 | 13.813 | 6057.1 |
| 524 | 2024-03-08 20:58:48 | fruit | 2 | 53800 | 58 | 3.593 | 14973.6 |
| 523 | 2024-03-08 20:58:49 | fruit | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 522 | 2024-03-08 20:58:20 | fruit | 3 | 83667 | 884 | 3.423 | 24442.6 |
| 521 | 2024-03-08 08:13:15 | fruit | 3 | 83667 | 884 | 14.330 | 5838.6 |
| 520 | 2024-03-07 07:45:53 | fruit | 3 | 83667 | 884 | 13.800 | 6062.8 |
| 519 | 2024-03-07 07:45:55 | fruit | 2 | 53800 | 58 | 4.906 | 10966.2 |
| 518 | 2024-03-07 05:28:57 | fruit | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 517 | 2024-03-05 18:30:49 | fruit | 1 | 28756 | 5 | 1.093 | 26309.2 |
| 516 | 2024-03-01 11:44:16 | fruit | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 515 | 2024-02-29 08:21:19 | fruit | 2 | 53800 | 58 | 1.673 | 32157.8 |
| 514 | 2024-02-29 08:20:46 | fruit | 3 | 83667 | 884 | 3.860 | 21675.4 |
| 513 | 2024-02-27 21:10:37 | fruit | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 512 | 2024-02-17 17:01:11 | fruit | 2 | 53800 | 58 | 1.546 | 34799.5 |
| 511 | 2024-02-17 16:44:11 | fruit | 3 | 83667 | 884 | 3.763 | 22234.1 |
| 510 | 2024-02-16 01:46:32 | fruit | 3 | 83667 | 884 | 7.233 | 11567.4 |
| 509 | 2024-02-03 20:45:07 | fruit | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 508 | 2024-02-02 23:55:52 | fruit | 2 | 53800 | 58 | 1.593 | 33772.8 |
| 507 | 2024-02-02 23:55:20 | fruit | 3 | 83667 | 884 | 4.700 | 17801.5 |
| 506 | 2024-02-01 14:42:03 | fruit | 2 | 53800 | 58 | 1.343 | 40059.6 |
| 505 | 2024-02-01 14:41:39 | fruit | 3 | 83667 | 884 | 3.876 | 21585.9 |
| 504 | 2024-01-17 02:19:34 | fruit | 2 | 53800 | 58 | 1.530 | 35163.4 |
| 503 | 2024-01-13 17:02:56 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 502 | 2024-01-09 09:27:43 | fruit | 3 | 83667 | 884 | 4.236 | 19751.4 |
| 501 | 2023-12-22 03:23:03 | fruit | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 500 | 2023-12-13 06:56:52 | fruit | 3 | 83667 | 884 | 3.406 | 24564.6 |
| 499 | 2023-12-13 06:56:51 | fruit | 2 | 53800 | 58 | 1.440 | 37361.1 |
| 498 | 2023-11-18 18:58:40 | fruit | 3 | 83667 | 884 | 3.860 | 21675.4 |
| 497 | 2023-11-18 18:58:39 | fruit | 2 | 53800 | 58 | 1.546 | 34799.5 |
| 496 | 2023-11-17 14:02:01 | fruit | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 495 | 2023-11-16 15:15:55 | fruit | 3 | 83667 | 884 | 3.360 | 24900.9 |
| 494 | 2023-11-11 06:28:06 | fruit | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 493 | 2023-11-06 17:06:16 | fruit | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 492 | 2023-11-04 01:29:17 | fruit | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 491 | 2023-10-31 09:52:45 | fruit | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 490 | 2023-10-30 14:58:08 | fruit | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 489 | 2023-10-22 05:31:39 | fruit | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 488 | 2023-10-11 04:57:02 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 487 | 2023-10-05 01:29:41 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 486 | 2023-09-29 10:40:14 | fruit | 1 | 28756 | 5 | 0.953 | 30174.2 |
| 485 | 2023-09-22 16:55:03 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 484 | 2023-09-05 09:11:44 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 483 | 2023-08-28 12:22:53 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 482 | 2023-08-16 20:13:32 | fruit | 3 | 83667 | 884 | 3.233 | 25879.1 |
| 481 | 2023-06-02 12:41:44 | fruit | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 480 | 2023-05-26 06:37:50 | fruit | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 479 | 2023-04-30 09:22:55 | fruit | 3 | 83667 | 884 | 3.576 | 23396.8 |
| 478 | 2023-03-26 19:24:01 | fruit | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 477 | 2023-03-03 01:17:07 | fruit | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 476 | 2023-02-09 23:21:50 | fruit | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 475 | 2023-02-02 13:33:13 | fruit | 3 | 83667 | 884 | 3.156 | 26510.5 |
| 474 | 2023-01-10 09:23:50 | fruit | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 473 | 2022-11-15 15:25:53 | fruit | 3 | 83667 | 884 | 3.296 | 25384.4 |
| 472 | 2022-10-23 10:44:10 | fruit | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 471 | 2022-10-20 14:02:25 | fruit | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 470 | 2022-08-23 12:01:17 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 469 | 2022-07-29 13:04:25 | fruit | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 468 | 2022-07-03 14:45:48 | fruit | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 467 | 2022-06-19 08:25:23 | fruit | 3 | 83667 | 884 | 3.186 | 26260.8 |
| 466 | 2022-06-10 02:24:57 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 465 | 2022-03-16 10:33:38 | fruit | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 464 | 2022-03-12 23:26:24 | fruit | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 463 | 2022-02-17 15:54:09 | fruit | 1 | 28756 | 5 | 0.640 | 44931.3 |
| 462 | 2022-02-15 12:33:28 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 461 | 2022-02-05 03:34:55 | fruit | 3 | 83667 | 884 | 3.233 | 25879.1 |
| 460 | 2021-12-09 01:39:00 | fruit | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 459 | 2021-11-29 07:21:00 | fruit | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 458 | 2021-10-20 13:00:09 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 457 | 2021-09-08 06:39:47 | fruit | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 456 | 2021-08-29 15:45:40 | fruit | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 455 | 2021-08-21 15:21:42 | fruit | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 454 | 2021-07-01 04:53:44 | fruit | 1 | 28756 | 5 | 0.450 | 63902.2 |
| 453 | 2021-05-29 00:10:59 | fruit | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 452 | 2021-04-13 05:17:37 | fruit | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 451 | 2021-02-26 01:56:43 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 450 | 2021-02-19 22:40:09 | fruit | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 449 | 2021-02-19 17:59:43 | fruit | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 448 | 2020-11-26 02:40:34 | fruit | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 447 | 2020-11-16 23:01:51 | fruit | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 446 | 2020-11-07 08:49:24 | fruit | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 445 | 2020-11-04 22:21:48 | fruit | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 444 | 2020-10-30 06:23:53 | fruit | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 443 | 2020-10-21 09:09:36 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 442 | 2020-10-14 17:47:43 | fruit | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 441 | 2020-10-14 15:52:54 | fruit | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 440 | 2020-08-17 08:38:27 | fruit | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 439 | 2020-08-06 17:56:24 | fruit | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 438 | 2020-06-21 00:45:53 | fruit | 1 | 28756 | 5 | 0.860 | 33437.2 |