History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pisco"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 555 | 2024-05-01 08:03:20 | pisco | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 554 | 2024-05-01 03:35:22 | pisco | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 553 | 2024-04-26 17:09:57 | pisco | 1 | 28756 | 5 | 0.580 | 49579.3 |
| 552 | 2024-04-20 18:53:54 | pisco | 1 | 28756 | 5 | 1.000 | 28756.0 |
| 551 | 2024-04-02 18:43:36 | pisco | 1 | 28756 | 5 | 1.126 | 25538.2 |
| 550 | 2024-03-31 15:22:40 | pisco | 1 | 28756 | 5 | 0.690 | 41675.4 |
| 549 | 2024-03-28 20:08:46 | pisco | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 548 | 2024-03-17 08:14:58 | pisco | 1 | 28756 | 5 | 0.543 | 52957.6 |
| 547 | 2024-03-10 09:28:22 | pisco | 2 | 53800 | 43 | 3.610 | 14903.0 |
| 546 | 2024-03-05 19:11:13 | pisco | 3 | 83667 | 629 | 9.453 | 8850.8 |
| 545 | 2024-03-04 20:49:30 | pisco | 1 | 28756 | 5 | 1.046 | 27491.4 |
| 544 | 2024-03-04 20:49:29 | pisco | 2 | 53800 | 43 | 1.686 | 31909.8 |
| 543 | 2024-03-04 20:49:12 | pisco | 3 | 83667 | 629 | 4.170 | 20064.0 |
| 542 | 2024-03-02 18:02:29 | pisco | 3 | 83667 | 629 | 8.486 | 9859.4 |
| 541 | 2024-03-02 18:02:29 | pisco | 2 | 53800 | 43 | 5.733 | 9384.3 |
| 540 | 2024-03-02 17:53:05 | pisco | 1 | 28756 | 5 | 1.046 | 27491.4 |
| 539 | 2024-03-01 12:53:17 | pisco | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 538 | 2024-02-26 19:43:28 | pisco | 3 | 83667 | 629 | 4.060 | 20607.6 |
| 537 | 2024-02-26 19:43:27 | pisco | 2 | 53800 | 43 | 1.796 | 29955.5 |
| 536 | 2024-02-26 19:43:13 | pisco | 1 | 28756 | 5 | 1.030 | 27918.4 |
| 535 | 2024-02-13 15:24:31 | pisco | 3 | 83667 | 629 | 11.983 | 6982.1 |
| 534 | 2024-02-13 15:24:34 | pisco | 2 | 53800 | 43 | 5.186 | 10374.1 |
| 533 | 2024-02-13 11:39:15 | pisco | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 532 | 2024-01-29 07:36:39 | pisco | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 531 | 2024-01-28 03:58:08 | pisco | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 530 | 2024-01-27 12:15:57 | pisco | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 529 | 2024-01-14 11:26:01 | pisco | 3 | 83667 | 629 | 4.093 | 20441.5 |
| 528 | 2024-01-14 11:25:59 | pisco | 2 | 53800 | 43 | 1.720 | 31279.1 |
| 527 | 2024-01-14 05:14:51 | pisco | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 526 | 2024-01-08 10:08:03 | pisco | 3 | 83667 | 629 | 3.280 | 25508.2 |
| 525 | 2023-12-23 20:51:38 | pisco | 3 | 83667 | 629 | 3.970 | 21074.8 |
| 524 | 2023-12-23 20:51:39 | pisco | 2 | 53800 | 43 | 1.670 | 32215.6 |
| 523 | 2023-12-17 14:31:45 | pisco | 2 | 53800 | 43 | 1.470 | 36598.6 |
| 522 | 2023-12-17 14:31:42 | pisco | 3 | 83667 | 629 | 3.356 | 24930.6 |
| 521 | 2023-12-14 10:01:44 | pisco | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 520 | 2023-11-23 00:51:27 | pisco | 2 | 53800 | 43 | 1.953 | 27547.4 |
| 519 | 2023-11-17 02:53:57 | pisco | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 518 | 2023-11-12 07:44:27 | pisco | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 517 | 2023-11-04 12:11:53 | pisco | 2 | 53800 | 43 | 1.560 | 34487.2 |
| 516 | 2023-10-29 18:25:34 | pisco | 3 | 83667 | 629 | 4.140 | 20209.4 |
| 515 | 2023-10-29 07:25:48 | pisco | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 514 | 2023-10-21 01:46:32 | pisco | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 513 | 2023-10-20 16:35:01 | pisco | 3 | 83667 | 629 | 3.796 | 22040.8 |
| 512 | 2023-10-18 15:15:34 | pisco | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 511 | 2023-10-16 22:07:00 | pisco | 3 | 83667 | 629 | 3.390 | 24680.5 |
| 510 | 2023-10-13 14:52:05 | pisco | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 509 | 2023-10-05 18:02:21 | pisco | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 508 | 2023-09-29 08:59:15 | pisco | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 507 | 2023-09-26 19:11:55 | pisco | 3 | 83667 | 629 | 4.326 | 19340.5 |
| 506 | 2023-09-26 19:11:52 | pisco | 2 | 53800 | 43 | 1.686 | 31909.8 |
| 505 | 2023-09-23 09:56:45 | pisco | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 504 | 2023-09-12 18:38:48 | pisco | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 503 | 2023-08-24 01:12:32 | pisco | 2 | 53800 | 43 | 1.376 | 39098.8 |
| 502 | 2023-07-28 04:50:55 | pisco | 3 | 83667 | 629 | 3.296 | 25384.4 |
| 501 | 2023-05-24 04:22:15 | pisco | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 500 | 2023-05-08 20:50:21 | pisco | 2 | 53800 | 43 | 1.360 | 39558.8 |
| 499 | 2023-04-06 03:01:59 | pisco | 3 | 83667 | 629 | 3.220 | 25983.5 |
| 498 | 2023-02-14 07:36:10 | pisco | 2 | 53800 | 43 | 1.436 | 37465.2 |
| 497 | 2023-01-28 02:27:17 | pisco | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 496 | 2023-01-01 09:32:50 | pisco | 3 | 83667 | 629 | 3.236 | 25855.1 |
| 495 | 2022-11-25 08:34:19 | pisco | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 494 | 2022-11-24 08:54:13 | pisco | 2 | 53800 | 43 | 1.673 | 32157.8 |
| 493 | 2022-09-22 03:35:58 | pisco | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 492 | 2022-09-05 13:32:11 | pisco | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 491 | 2022-09-03 06:29:35 | pisco | 3 | 83667 | 629 | 3.530 | 23701.7 |
| 490 | 2022-08-18 23:17:14 | pisco | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 489 | 2022-05-16 04:13:02 | pisco | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 488 | 2022-05-02 23:58:15 | pisco | 2 | 53800 | 43 | 1.343 | 40059.6 |
| 487 | 2022-04-26 20:44:47 | pisco | 3 | 83667 | 629 | 3.263 | 25641.1 |
| 486 | 2022-04-09 12:27:03 | pisco | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 485 | 2022-03-28 19:29:44 | pisco | 3 | 83667 | 629 | 3.860 | 21675.4 |
| 484 | 2022-01-25 01:12:31 | pisco | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 483 | 2022-01-11 02:15:41 | pisco | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 482 | 2022-01-04 20:41:01 | pisco | 2 | 53800 | 43 | 1.766 | 30464.3 |
| 481 | 2021-11-07 01:53:17 | pisco | 1 | 28756 | 5 | 0.563 | 51076.4 |
| 480 | 2021-10-08 13:27:10 | pisco | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 479 | 2021-09-24 14:01:34 | pisco | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 478 | 2021-09-05 04:31:58 | pisco | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 477 | 2021-07-22 03:50:43 | pisco | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 476 | 2021-07-10 07:10:14 | pisco | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 475 | 2021-06-05 12:46:21 | pisco | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 474 | 2021-05-11 11:42:44 | pisco | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 473 | 2021-04-10 06:24:39 | pisco | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 472 | 2021-04-06 11:38:13 | pisco | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 471 | 2021-04-02 07:56:57 | pisco | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 470 | 2021-03-14 11:13:49 | pisco | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 469 | 2021-01-24 17:03:52 | pisco | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 468 | 2020-12-26 11:53:48 | pisco | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 467 | 2020-12-21 07:31:50 | pisco | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 466 | 2020-11-15 11:38:51 | pisco | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 465 | 2020-10-23 20:33:10 | pisco | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 464 | 2020-10-22 01:08:12 | pisco | 1 | 28756 | 5 | 0.923 | 31154.9 |
| 463 | 2020-10-07 23:15:20 | pisco | 3 | 83667 | 629 | 3.810 | 21959.8 |
| 462 | 2020-09-17 09:50:00 | pisco | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 461 | 2020-09-06 20:51:56 | pisco | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 460 | 2020-07-10 12:12:41 | pisco | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 459 | 2020-06-12 09:27:09 | pisco | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 458 | 2020-06-11 08:59:38 | pisco | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 457 | 2020-06-07 14:24:44 | pisco | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 456 | 2020-06-02 02:46:04 | pisco | 1 | 28756 | 5 | 0.516 | 55728.7 |