History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substitute"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 579 | 2025-05-14 20:26:52 | substitute | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 578 | 2025-05-14 14:04:02 | substitute | 1 | 67641 | 3 | 5.436 | 12443.2 |
| 577 | 2025-05-11 04:04:46 | substitute | 4 | 161450 | 78 | 53.563 | 3014.2 |
| 576 | 2025-05-08 13:57:54 | substitute | 4 | 161450 | 78 | 53.880 | 2996.5 |
| 575 | 2025-05-08 13:22:20 | substitute | 4 | 161450 | 78 | 61.933 | 2606.8 |
| 574 | 2025-05-01 11:25:26 | substitute | 4 | 161450 | 78 | 15.313 | 10543.3 |
| 573 | 2025-04-30 07:39:34 | substitute | 2 | 108824 | 4 | 7.703 | 14127.5 |
| 572 | 2025-04-28 03:19:23 | substitute | 4 | 161450 | 78 | 45.300 | 3564.0 |
| 571 | 2025-04-27 22:03:51 | substitute | 1 | 67641 | 3 | 2.500 | 27056.4 |
| 570 | 2025-04-23 11:03:09 | substitute | 1 | 67641 | 3 | 5.030 | 13447.5 |
| 569 | 2025-04-22 18:22:12 | substitute | 4 | 161450 | 78 | 9.390 | 17193.8 |
| 568 | 2025-04-22 07:29:05 | substitute | 4 | 161450 | 78 | 44.190 | 3653.5 |
| 567 | 2025-04-21 09:34:40 | substitute | 4 | 161450 | 78 | 64.130 | 2517.5 |
| 566 | 2025-04-20 22:14:16 | substitute | 5 | 173545 | 417 | 73.096 | 2374.2 |
| 565 | 2025-04-18 14:21:16 | substitute | 5 | 173545 | 417 | 85.770 | 2023.4 |
| 564 | 2025-04-18 03:56:11 | substitute | 5 | 173545 | 417 | 77.626 | 2235.7 |
| 563 | 2025-04-17 01:35:18 | substitute | 5 | 173545 | 417 | 78.600 | 2208.0 |
| 562 | 2025-04-16 21:42:10 | substitute | 5 | 173545 | 417 | 25.283 | 6864.1 |
| 561 | 2025-04-15 15:24:01 | substitute | 5 | 173545 | 417 | 88.176 | 1968.2 |
| 560 | 2025-04-15 11:32:55 | substitute | 2 | 108824 | 4 | 3.300 | 32977.0 |
| 559 | 2025-04-15 11:09:56 | substitute | 2 | 108824 | 4 | 16.923 | 6430.5 |
| 558 | 2025-04-14 23:56:32 | substitute | 3 | 140603 | 20 | 21.546 | 6525.7 |
| 557 | 2025-04-13 20:25:03 | substitute | 1 | 67641 | 3 | 3.330 | 20312.6 |
| 556 | 2025-04-13 13:47:05 | substitute | 4 | 161450 | 78 | 11.736 | 13756.8 |
| 555 | 2025-04-11 16:17:45 | substitute | 4 | 161450 | 78 | 54.343 | 2970.9 |
| 554 | 2025-04-11 15:45:36 | substitute | 2 | 108824 | 4 | 12.610 | 8630.0 |
| 553 | 2025-04-10 02:41:20 | substitute | 3 | 140603 | 20 | 6.546 | 21479.2 |
| 552 | 2025-04-05 21:31:15 | substitute | 3 | 140603 | 20 | 15.593 | 9017.1 |
| 551 | 2025-04-03 13:36:11 | substitute | 1 | 67641 | 3 | 3.080 | 21961.4 |
| 550 | 2025-04-02 13:32:43 | substitute | 3 | 140603 | 20 | 30.923 | 4546.9 |
| 549 | 2025-04-02 03:45:08 | substitute | 2 | 108824 | 4 | 22.796 | 4773.8 |
| 548 | 2025-03-27 12:53:45 | substitute | 2 | 108824 | 4 | 15.813 | 6881.9 |
| 547 | 2025-03-27 11:21:29 | substitute | 3 | 140603 | 20 | 31.360 | 4483.5 |
| 546 | 2025-03-27 04:37:58 | substitute | 3 | 140603 | 20 | 24.140 | 5824.5 |
| 545 | 2025-03-26 23:00:29 | substitute | 3 | 140603 | 20 | 36.020 | 3903.5 |
| 544 | 2025-03-26 11:38:17 | substitute | 1 | 67641 | 3 | 2.966 | 22805.5 |
| 543 | 2025-03-03 11:31:59 | substitute | 3 | 140603 | 20 | 6.000 | 23433.8 |
| 542 | 2025-03-02 18:28:02 | substitute | 3 | 140603 | 20 | 32.613 | 4311.3 |
| 541 | 2025-03-01 15:17:55 | substitute | 4 | 161450 | 78 | 61.830 | 2611.2 |
| 540 | 2025-03-01 10:51:59 | substitute | 1 | 67641 | 3 | 5.393 | 12542.4 |
| 539 | 2025-02-28 09:02:18 | substitute | 3 | 140603 | 20 | 17.750 | 7921.3 |
| 538 | 2025-02-28 09:02:15 | substitute | 2 | 108824 | 4 | 15.860 | 6861.5 |
| 537 | 2025-02-28 08:57:36 | substitute | 1 | 67641 | 3 | 5.970 | 11330.2 |
| 536 | 2025-02-28 08:56:23 | substitute | 4 | 161450 | 78 | 53.036 | 3044.2 |
| 535 | 2025-02-23 13:20:41 | substitute | 4 | 161450 | 78 | 50.110 | 3221.9 |
| 534 | 2025-02-23 13:20:40 | substitute | 3 | 140603 | 20 | 28.223 | 4981.9 |
| 533 | 2025-02-23 13:20:40 | substitute | 2 | 108824 | 4 | 15.813 | 6881.9 |
| 532 | 2025-02-23 13:18:21 | substitute | 1 | 67641 | 3 | 5.623 | 12029.3 |
| 531 | 2025-02-22 02:07:34 | substitute | 3 | 140603 | 20 | 28.413 | 4948.5 |
| 530 | 2025-02-22 02:07:33 | substitute | 2 | 108824 | 4 | 15.503 | 7019.5 |
| 529 | 2025-02-22 02:06:50 | substitute | 1 | 67641 | 3 | 5.626 | 12022.9 |
| 528 | 2025-02-20 04:24:57 | substitute | 3 | 140603 | 20 | 31.076 | 4524.5 |
| 527 | 2025-02-20 04:24:56 | substitute | 2 | 108824 | 4 | 18.640 | 5838.2 |
| 526 | 2025-02-20 04:24:42 | substitute | 1 | 67641 | 3 | 4.436 | 15248.2 |
| 525 | 2025-01-29 11:56:26 | substitute | 1 | 67641 | 3 | 5.406 | 12512.2 |
| 524 | 2025-01-28 05:25:07 | substitute | 3 | 140603 | 20 | 31.126 | 4517.2 |
| 523 | 2025-01-26 12:44:08 | substitute | 3 | 140603 | 20 | 34.423 | 4084.6 |
| 522 | 2025-01-22 08:51:12 | substitute | 3 | 140603 | 20 | 35.563 | 3953.6 |
| 521 | 2025-01-21 02:16:15 | substitute | 4 | 161450 | 78 | 48.703 | 3315.0 |
| 520 | 2025-01-21 02:16:10 | substitute | 1 | 67641 | 3 | 5.343 | 12659.7 |
| 519 | 2025-01-21 02:12:29 | substitute | 2 | 108824 | 4 | 16.216 | 6710.9 |
| 518 | 2025-01-11 12:51:10 | substitute | 2 | 108824 | 4 | 15.346 | 7091.4 |
| 517 | 2025-01-11 12:50:37 | substitute | 3 | 140603 | 20 | 27.110 | 5186.4 |
| 516 | 2025-01-11 12:49:05 | substitute | 1 | 67641 | 3 | 5.623 | 12029.3 |
| 515 | 2025-01-01 11:17:32 | substitute | 2 | 108824 | 4 | 22.813 | 4770.3 |
| 514 | 2025-01-01 11:15:20 | substitute | 3 | 140603 | 20 | 45.020 | 3123.1 |
| 513 | 2025-01-01 11:11:57 | substitute | 1 | 67641 | 3 | 4.076 | 16594.9 |
| 512 | 2024-12-25 22:55:58 | substitute | 3 | 140603 | 20 | 33.766 | 4164.0 |
| 511 | 2024-12-25 22:55:58 | substitute | 2 | 108824 | 4 | 17.203 | 6325.9 |
| 510 | 2024-12-25 22:52:58 | substitute | 1 | 67641 | 3 | 4.563 | 14823.8 |
| 509 | 2024-12-22 07:14:49 | substitute | 3 | 140603 | 20 | 31.156 | 4512.9 |
| 508 | 2024-12-21 12:33:46 | substitute | 3 | 140603 | 20 | 32.830 | 4282.8 |
| 507 | 2024-12-17 07:34:26 | substitute | 2 | 108824 | 4 | 15.830 | 6874.5 |
| 506 | 2024-12-17 07:32:53 | substitute | 3 | 140603 | 20 | 31.753 | 4428.0 |
| 505 | 2024-12-17 07:29:21 | substitute | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 504 | 2024-12-05 03:05:46 | substitute | 2 | 108824 | 4 | 7.813 | 13928.6 |
| 503 | 2024-12-05 03:02:21 | substitute | 1 | 67641 | 3 | 5.796 | 11670.3 |
| 502 | 2024-11-25 12:08:43 | substitute | 3 | 140603 | 20 | 39.733 | 3538.7 |
| 501 | 2024-11-24 11:43:31 | substitute | 3 | 140603 | 20 | 30.503 | 4609.5 |
| 500 | 2024-11-21 13:19:11 | substitute | 3 | 140603 | 20 | 30.720 | 4576.9 |
| 499 | 2024-11-21 08:57:46 | substitute | 1 | 67641 | 3 | 4.783 | 14142.0 |
| 498 | 2024-11-16 21:03:40 | substitute | 2 | 108824 | 4 | 15.673 | 6943.4 |
| 497 | 2024-11-16 21:03:19 | substitute | 3 | 140603 | 20 | 35.896 | 3917.0 |
| 496 | 2024-11-16 21:03:22 | substitute | 3 | 140603 | 20 | 31.646 | 4443.0 |
| 495 | 2024-11-16 21:02:52 | substitute | 1 | 67641 | 3 | 6.390 | 10585.4 |
| 494 | 2024-11-14 01:45:59 | substitute | 3 | 140603 | 20 | 40.033 | 3512.2 |
| 493 | 2024-11-14 01:46:01 | substitute | 2 | 108824 | 4 | 22.846 | 4763.4 |
| 492 | 2024-11-14 01:44:52 | substitute | 1 | 67641 | 3 | 4.500 | 15031.3 |
| 491 | 2024-11-13 01:02:20 | substitute | 3 | 140603 | 20 | 36.096 | 3895.3 |
| 490 | 2024-11-13 01:02:08 | substitute | 3 | 140603 | 20 | 23.156 | 6072.0 |
| 489 | 2024-10-28 18:34:40 | substitute | 3 | 140603 | 20 | 38.390 | 3662.5 |
| 488 | 2024-10-28 18:34:44 | substitute | 3 | 140603 | 20 | 19.550 | 7192.0 |
| 487 | 2024-10-28 18:34:43 | substitute | 2 | 108824 | 4 | 14.860 | 7323.3 |
| 486 | 2024-10-28 18:29:01 | substitute | 1 | 67641 | 3 | 2.923 | 23141.0 |
| 485 | 2024-10-24 17:33:06 | substitute | 3 | 140603 | 20 | 30.923 | 4546.9 |
| 484 | 2024-10-19 11:16:25 | substitute | 3 | 140603 | 20 | 47.413 | 2965.5 |
| 483 | 2024-10-19 11:15:07 | substitute | 1 | 67641 | 3 | 5.403 | 12519.2 |
| 482 | 2024-10-14 09:40:51 | substitute | 3 | 140603 | 20 | 25.080 | 5606.2 |
| 481 | 2024-10-11 10:13:45 | substitute | 1 | 67641 | 3 | 4.016 | 16842.9 |
| 480 | 2024-10-11 01:59:54 | substitute | 3 | 140603 | 20 | 30.893 | 4551.3 |