History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rifling"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 563 | 2024-04-27 08:58:56 | rifling | 1 | 69583 | 8 | 1.266 | 54962.9 |
| 562 | 2024-02-26 09:36:39 | rifling | 2 | 107671 | 99 | 6.580 | 16363.4 |
| 561 | 2024-02-09 17:05:24 | rifling | 1 | 69583 | 8 | 1.360 | 51164.0 |
| 560 | 2024-02-03 20:58:43 | rifling | 2 | 107671 | 99 | 3.283 | 32796.5 |
| 559 | 2024-02-02 21:27:24 | rifling | 2 | 107671 | 99 | 4.436 | 24272.1 |
| 558 | 2024-02-02 21:22:20 | rifling | 3 | 134027 | 949 | 7.076 | 18941.1 |
| 557 | 2024-02-02 11:04:59 | rifling | 3 | 134027 | 949 | 6.576 | 20381.2 |
| 556 | 2024-02-02 10:28:43 | rifling | 2 | 107671 | 99 | 3.186 | 33795.0 |
| 555 | 2024-02-02 06:09:16 | rifling | 2 | 107671 | 99 | 2.796 | 38508.9 |
| 554 | 2024-02-02 06:05:48 | rifling | 3 | 134027 | 949 | 6.780 | 19768.0 |
| 553 | 2024-02-01 11:51:15 | rifling | 3 | 134027 | 949 | 7.173 | 18684.9 |
| 552 | 2023-12-25 12:57:11 | rifling | 3 | 134027 | 949 | 7.093 | 18895.7 |
| 551 | 2023-12-18 06:39:59 | rifling | 3 | 134027 | 949 | 6.890 | 19452.4 |
| 550 | 2023-12-16 12:23:53 | rifling | 1 | 69583 | 8 | 1.190 | 58473.1 |
| 549 | 2023-12-05 20:02:27 | rifling | 3 | 134027 | 949 | 8.203 | 16338.8 |
| 548 | 2023-12-01 20:01:38 | rifling | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 547 | 2023-11-26 15:05:58 | rifling | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 546 | 2023-11-22 15:17:48 | rifling | 2 | 107671 | 99 | 2.843 | 37872.3 |
| 545 | 2023-11-11 21:13:23 | rifling | 3 | 134027 | 949 | 6.046 | 22167.9 |
| 544 | 2023-11-06 23:11:28 | rifling | 1 | 69583 | 8 | 1.096 | 63488.1 |
| 543 | 2023-11-04 06:09:25 | rifling | 3 | 134027 | 949 | 6.736 | 19897.1 |
| 542 | 2023-11-04 06:09:21 | rifling | 2 | 107671 | 99 | 3.406 | 31612.2 |
| 541 | 2023-11-02 02:11:30 | rifling | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 540 | 2023-11-01 17:31:19 | rifling | 1 | 69583 | 8 | 1.330 | 52318.0 |
| 539 | 2023-10-21 01:17:05 | rifling | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 538 | 2023-10-06 18:35:09 | rifling | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 537 | 2023-09-16 19:11:15 | rifling | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 536 | 2023-09-16 13:23:18 | rifling | 1 | 69583 | 8 | 1.236 | 56296.9 |
| 535 | 2023-08-24 01:26:02 | rifling | 2 | 107671 | 99 | 2.890 | 37256.4 |
| 534 | 2023-08-15 08:24:40 | rifling | 3 | 134027 | 949 | 5.733 | 23378.2 |
| 533 | 2023-07-08 14:40:50 | rifling | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 532 | 2023-07-05 16:16:47 | rifling | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 531 | 2023-06-05 07:31:34 | rifling | 3 | 134027 | 949 | 6.796 | 19721.5 |
| 530 | 2023-05-09 20:10:39 | rifling | 2 | 107671 | 99 | 2.966 | 36301.8 |
| 529 | 2023-04-29 22:35:15 | rifling | 3 | 134027 | 949 | 6.483 | 20673.6 |
| 528 | 2023-04-13 03:35:14 | rifling | 1 | 69583 | 8 | 1.236 | 56296.9 |
| 527 | 2023-03-12 07:45:16 | rifling | 1 | 69583 | 8 | 1.173 | 59320.5 |
| 526 | 2023-02-13 08:16:20 | rifling | 2 | 107671 | 99 | 2.780 | 38730.6 |
| 525 | 2023-02-05 22:10:00 | rifling | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 524 | 2023-02-05 16:18:54 | rifling | 3 | 134027 | 949 | 5.640 | 23763.7 |
| 523 | 2023-01-31 17:55:51 | rifling | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 522 | 2022-12-16 02:01:33 | rifling | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 521 | 2022-12-04 18:16:39 | rifling | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 520 | 2022-11-24 15:33:03 | rifling | 3 | 134027 | 949 | 6.046 | 22167.9 |
| 519 | 2022-11-23 20:04:45 | rifling | 2 | 107671 | 99 | 2.843 | 37872.3 |
| 518 | 2022-11-18 04:10:28 | rifling | 3 | 134027 | 949 | 5.876 | 22809.2 |
| 517 | 2022-11-17 03:46:48 | rifling | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 516 | 2022-11-12 13:46:03 | rifling | 1 | 69583 | 8 | 1.170 | 59472.6 |
| 515 | 2022-11-06 08:23:53 | rifling | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 514 | 2022-09-18 06:38:21 | rifling | 1 | 69583 | 8 | 1.173 | 59320.5 |
| 513 | 2022-08-23 10:31:34 | rifling | 1 | 69583 | 8 | 1.173 | 59320.5 |
| 512 | 2022-08-07 14:33:32 | rifling | 1 | 69583 | 8 | 1.173 | 59320.5 |
| 511 | 2022-08-01 06:23:52 | rifling | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 510 | 2022-07-20 15:24:36 | rifling | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 509 | 2022-07-16 22:13:24 | rifling | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 508 | 2022-06-25 18:08:12 | rifling | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 507 | 2022-06-07 11:35:14 | rifling | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 506 | 2022-05-03 00:03:44 | rifling | 3 | 134027 | 949 | 6.953 | 19276.1 |
| 505 | 2022-05-02 03:10:47 | rifling | 2 | 107671 | 99 | 2.780 | 38730.6 |
| 504 | 2022-03-26 15:14:14 | rifling | 1 | 69583 | 8 | 1.060 | 65644.3 |
| 503 | 2022-03-16 04:40:28 | rifling | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 502 | 2022-03-12 17:51:07 | rifling | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 501 | 2022-01-10 14:54:25 | rifling | 3 | 134027 | 949 | 6.736 | 19897.1 |
| 500 | 2022-01-03 16:00:28 | rifling | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 499 | 2021-12-31 13:38:26 | rifling | 3 | 134027 | 949 | 7.123 | 18816.1 |
| 498 | 2021-12-30 16:57:35 | rifling | 2 | 107671 | 99 | 3.186 | 33795.0 |
| 497 | 2021-11-22 07:10:44 | rifling | 1 | 69583 | 8 | 1.346 | 51696.1 |
| 496 | 2021-11-18 21:47:24 | rifling | 1 | 69583 | 8 | 1.296 | 53690.6 |
| 495 | 2021-10-30 22:11:57 | rifling | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 494 | 2021-09-21 11:24:32 | rifling | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 493 | 2021-09-19 07:23:23 | rifling | 1 | 69583 | 8 | 1.216 | 57222.9 |
| 492 | 2021-08-30 15:38:50 | rifling | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 491 | 2021-08-16 02:34:11 | rifling | 1 | 69583 | 8 | 1.283 | 54234.6 |
| 490 | 2021-07-02 19:55:26 | rifling | 1 | 69583 | 8 | 1.263 | 55093.4 |
| 489 | 2021-05-25 21:40:31 | rifling | 3 | 134027 | 949 | 6.406 | 20922.1 |
| 488 | 2021-05-12 01:44:03 | rifling | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 487 | 2021-04-30 07:22:30 | rifling | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 486 | 2021-04-19 12:37:04 | rifling | 2 | 107671 | 99 | 3.220 | 33438.2 |
| 485 | 2021-03-01 09:00:25 | rifling | 3 | 134027 | 949 | 5.780 | 23188.1 |
| 484 | 2021-02-24 21:33:09 | rifling | 2 | 107671 | 99 | 2.873 | 37476.9 |
| 483 | 2021-02-21 18:06:23 | rifling | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 482 | 2021-02-16 03:41:43 | rifling | 3 | 134027 | 949 | 6.940 | 19312.2 |
| 481 | 2021-02-10 12:58:12 | rifling | 3 | 134027 | 949 | 5.813 | 23056.4 |
| 480 | 2021-02-07 16:43:56 | rifling | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 479 | 2021-02-03 08:13:13 | rifling | 3 | 134027 | 949 | 6.860 | 19537.5 |
| 478 | 2021-01-13 08:45:18 | rifling | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 477 | 2020-12-12 05:53:52 | rifling | 3 | 134027 | 949 | 5.783 | 23176.0 |
| 476 | 2020-11-17 14:37:19 | rifling | 2 | 107671 | 99 | 2.906 | 37051.3 |
| 475 | 2020-11-05 22:39:08 | rifling | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 474 | 2020-11-01 12:41:39 | rifling | 3 | 134027 | 949 | 6.140 | 21828.5 |
| 473 | 2020-10-27 22:34:01 | rifling | 3 | 134027 | 949 | 11.873 | 11288.4 |
| 472 | 2020-10-23 01:16:52 | rifling | 1 | 69583 | 8 | 2.033 | 34226.8 |
| 471 | 2020-10-21 18:16:16 | rifling | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 470 | 2020-10-16 11:16:17 | rifling | 1 | 69583 | 8 | 1.060 | 65644.3 |
| 469 | 2020-10-03 07:29:48 | rifling | 1 | 69583 | 8 | 1.046 | 66522.9 |
| 468 | 2020-09-30 16:36:38 | rifling | 1 | 69583 | 8 | 1.063 | 65459.1 |
| 467 | 2020-08-05 01:18:26 | rifling | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 466 | 2020-08-01 19:46:54 | rifling | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 465 | 2020-07-31 07:37:10 | rifling | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 464 | 2020-07-29 17:28:12 | rifling | 1 | 69583 | 8 | 1.216 | 57222.9 |