History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drugs"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 585 | 2025-12-01 22:57:11 | drugs | 1 | 28756 | 10 | 0.453 | 63479.0 |
| 584 | 2025-12-01 11:57:04 | drugs | 2 | 53800 | 126 | 1.453 | 37026.8 |
| 583 | 2025-11-30 23:56:22 | drugs | 2 | 53800 | 126 | 1.673 | 32157.8 |
| 582 | 2025-11-30 23:53:38 | drugs | 2 | 53800 | 126 | 1.750 | 30742.9 |
| 581 | 2025-11-30 23:44:28 | drugs | 2 | 53800 | 126 | 1.546 | 34799.5 |
| 580 | 2025-11-25 13:28:35 | drugs | 1 | 28756 | 10 | 0.516 | 55728.7 |
| 579 | 2025-11-24 22:35:05 | drugs | 1 | 28756 | 10 | 0.530 | 54256.6 |
| 578 | 2025-11-20 16:29:55 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
| 577 | 2025-11-20 00:56:27 | drugs | 1 | 28756 | 10 | 0.483 | 59536.2 |
| 576 | 2025-10-31 04:30:57 | drugs | 1 | 28756 | 10 | 0.516 | 55728.7 |
| 575 | 2025-10-24 23:09:59 | drugs | 1 | 28756 | 10 | 0.466 | 61708.2 |
| 574 | 2025-10-24 01:21:07 | drugs | 1 | 28756 | 10 | 0.513 | 56054.6 |
| 573 | 2025-10-23 08:13:45 | drugs | 1 | 28756 | 10 | 1.360 | 21144.1 |
| 572 | 2025-10-23 03:43:56 | drugs | 1 | 28756 | 10 | 2.330 | 12341.6 |
| 571 | 2025-10-23 03:43:19 | drugs | 1 | 28756 | 10 | 1.016 | 28303.1 |
| 570 | 2025-10-22 15:27:19 | drugs | 1 | 28756 | 10 | 0.513 | 56054.6 |
| 569 | 2025-10-22 15:26:47 | drugs | 1 | 28756 | 10 | 0.513 | 56054.6 |
| 568 | 2025-10-22 04:16:28 | drugs | 1 | 28756 | 10 | 0.516 | 55728.7 |
| 567 | 2025-10-16 20:53:07 | drugs | 1 | 28756 | 10 | 0.516 | 55728.7 |
| 566 | 2025-10-03 04:06:36 | drugs | 1 | 28756 | 10 | 0.440 | 65354.5 |
| 565 | 2025-10-02 01:24:02 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
| 564 | 2025-09-21 05:53:26 | drugs | 1 | 28756 | 10 | 0.470 | 61183.0 |
| 563 | 2025-09-01 16:37:47 | drugs | 1 | 28756 | 10 | 0.483 | 59536.2 |
| 562 | 2025-08-31 20:01:19 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
| 561 | 2025-08-28 04:24:53 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
| 560 | 2025-08-25 00:37:33 | drugs | 1 | 28756 | 10 | 2.626 | 10950.5 |
| 559 | 2025-08-24 08:09:19 | drugs | 1 | 28756 | 10 | 1.390 | 20687.8 |
| 558 | 2025-08-09 05:26:22 | drugs | 1 | 28756 | 10 | 1.640 | 17534.1 |
| 557 | 2025-08-04 00:53:03 | drugs | 1 | 28756 | 10 | 1.263 | 22768.0 |
| 556 | 2025-08-01 02:06:24 | drugs | 1 | 28756 | 10 | 1.360 | 21144.1 |
| 555 | 2025-07-31 15:11:30 | drugs | 1 | 28756 | 10 | 2.050 | 14027.3 |
| 554 | 2025-07-30 23:38:22 | drugs | 1 | 28756 | 10 | 2.373 | 12118.0 |
| 553 | 2025-07-27 22:11:14 | drugs | 2 | 53800 | 126 | 3.203 | 16796.8 |
| 552 | 2025-07-27 04:15:49 | drugs | 1 | 28756 | 10 | 0.856 | 33593.5 |
| 551 | 2025-07-25 09:09:33 | drugs | 1 | 28756 | 10 | 1.186 | 24246.2 |
| 550 | 2025-07-24 10:51:29 | drugs | 1 | 28756 | 10 | 2.563 | 11219.7 |
| 549 | 2025-07-24 01:45:23 | drugs | 1 | 28756 | 10 | 1.940 | 14822.7 |
| 548 | 2025-07-23 22:04:34 | drugs | 2 | 53800 | 126 | 11.703 | 4597.1 |
| 547 | 2025-07-23 14:20:32 | drugs | 1 | 28756 | 10 | 1.143 | 25158.4 |
| 546 | 2025-07-19 15:58:59 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
| 545 | 2025-07-19 14:19:39 | drugs | 2 | 53800 | 126 | 1.610 | 33416.1 |
| 544 | 2025-07-19 00:05:26 | drugs | 2 | 53800 | 126 | 1.576 | 34137.1 |
| 543 | 2025-07-10 17:21:30 | drugs | 2 | 53800 | 126 | 9.610 | 5598.3 |
| 542 | 2025-07-09 04:38:49 | drugs | 1 | 28756 | 10 | 1.593 | 18051.5 |
| 541 | 2025-07-05 05:28:51 | drugs | 2 | 53800 | 126 | 4.250 | 12658.8 |
| 540 | 2025-07-04 01:35:38 | drugs | 1 | 28756 | 10 | 1.750 | 16432.0 |
| 539 | 2025-07-03 23:47:32 | drugs | 1 | 28756 | 10 | 2.343 | 12273.2 |
| 538 | 2025-06-30 00:00:42 | drugs | 1 | 28756 | 10 | 2.546 | 11294.6 |
| 537 | 2025-06-09 04:20:08 | drugs | 1 | 28756 | 10 | 0.533 | 53951.2 |
| 536 | 2025-06-08 09:08:22 | drugs | 1 | 28756 | 10 | 1.296 | 22188.3 |
| 535 | 2025-05-31 04:53:18 | drugs | 1 | 28756 | 10 | 2.233 | 12877.7 |
| 534 | 2025-05-31 04:14:56 | drugs | 1 | 28756 | 10 | 3.516 | 8178.6 |
| 533 | 2025-05-29 05:21:51 | drugs | 1 | 28756 | 10 | 1.513 | 19005.9 |
| 532 | 2025-05-28 23:56:07 | drugs | 1 | 28756 | 10 | 0.970 | 29645.4 |
| 531 | 2025-05-25 19:20:44 | drugs | 2 | 53800 | 126 | 7.890 | 6818.8 |
| 530 | 2025-05-24 05:01:04 | drugs | 1 | 28756 | 10 | 2.046 | 14054.7 |
| 529 | 2025-05-21 10:13:44 | drugs | 1 | 28756 | 10 | 0.513 | 56054.6 |
| 528 | 2025-05-18 01:10:38 | drugs | 1 | 28756 | 10 | 1.233 | 23322.0 |
| 527 | 2025-05-10 04:06:27 | drugs | 1 | 28756 | 10 | 1.483 | 19390.4 |
| 526 | 2025-05-08 09:26:41 | drugs | 1 | 28756 | 10 | 3.580 | 8032.4 |
| 525 | 2025-05-03 19:43:18 | drugs | 1 | 28756 | 10 | 0.466 | 61708.2 |
| 524 | 2025-04-28 23:57:54 | drugs | 1 | 28756 | 10 | 0.516 | 55728.7 |
| 523 | 2025-04-27 23:56:43 | drugs | 1 | 28756 | 10 | 3.706 | 7759.3 |
| 522 | 2025-04-26 23:02:48 | drugs | 1 | 28756 | 10 | 0.516 | 55728.7 |
| 521 | 2025-04-26 22:58:47 | drugs | 1 | 28756 | 10 | 0.470 | 61183.0 |
| 520 | 2025-04-26 22:51:36 | drugs | 1 | 28756 | 10 | 0.453 | 63479.0 |
| 519 | 2025-04-26 22:35:30 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
| 518 | 2025-04-25 16:54:04 | drugs | 1 | 28756 | 10 | 1.046 | 27491.4 |
| 517 | 2025-04-25 14:21:33 | drugs | 2 | 53800 | 126 | 1.856 | 28987.1 |
| 516 | 2025-04-14 01:01:55 | drugs | 1 | 28756 | 10 | 2.483 | 11581.2 |
| 515 | 2025-04-09 04:32:11 | drugs | 1 | 28756 | 10 | 2.000 | 14378.0 |
| 514 | 2025-04-06 08:30:50 | drugs | 1 | 28756 | 10 | 2.343 | 12273.2 |
| 513 | 2025-03-29 00:41:24 | drugs | 1 | 28756 | 10 | 2.533 | 11352.5 |
| 512 | 2025-03-27 01:45:11 | drugs | 1 | 28756 | 10 | 1.123 | 25606.4 |
| 511 | 2025-03-26 11:58:32 | drugs | 2 | 53800 | 126 | 10.016 | 5371.4 |
| 510 | 2025-03-16 08:20:14 | drugs | 1 | 28756 | 10 | 1.266 | 22714.1 |
| 509 | 2025-03-15 00:00:38 | drugs | 1 | 28756 | 10 | 2.343 | 12273.2 |
| 508 | 2025-03-09 07:20:13 | drugs | 1 | 28756 | 10 | 1.266 | 22714.1 |
| 507 | 2025-03-05 20:28:26 | drugs | 1 | 28756 | 10 | 2.300 | 12502.6 |
| 506 | 2025-02-26 10:24:36 | drugs | 2 | 53800 | 126 | 4.780 | 11255.2 |
| 505 | 2025-02-26 10:16:53 | drugs | 2 | 53800 | 126 | 7.763 | 6930.3 |
| 504 | 2025-02-26 07:12:19 | drugs | 2 | 53800 | 126 | 7.500 | 7173.3 |
| 503 | 2025-02-26 04:33:55 | drugs | 2 | 53800 | 126 | 3.580 | 15027.9 |
| 502 | 2025-02-26 03:55:33 | drugs | 2 | 53800 | 126 | 7.376 | 7293.9 |
| 501 | 2025-02-26 03:51:50 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
| 500 | 2025-02-25 06:48:38 | drugs | 1 | 28756 | 10 | 2.703 | 10638.5 |
| 499 | 2025-02-24 22:21:24 | drugs | 1 | 28756 | 10 | 1.296 | 22188.3 |
| 498 | 2025-02-23 19:43:55 | drugs | 1 | 28756 | 10 | 0.970 | 29645.4 |
| 497 | 2025-02-12 21:16:33 | drugs | 1 | 28756 | 10 | 3.173 | 9062.7 |
| 496 | 2025-01-27 04:28:11 | drugs | 2 | 53800 | 126 | 9.110 | 5905.6 |
| 495 | 2025-01-26 18:42:26 | drugs | 2 | 53800 | 126 | 8.530 | 6307.2 |
| 494 | 2025-01-26 18:04:14 | drugs | 2 | 53800 | 126 | 7.816 | 6883.3 |
| 493 | 2025-01-26 17:02:11 | drugs | 1 | 28756 | 10 | 0.530 | 54256.6 |
| 492 | 2025-01-26 04:14:51 | drugs | 1 | 28756 | 10 | 0.470 | 61183.0 |
| 491 | 2025-01-25 08:56:31 | drugs | 1 | 28756 | 10 | 1.470 | 19561.9 |
| 490 | 2025-01-07 17:18:54 | drugs | 2 | 53800 | 126 | 4.923 | 10928.3 |
| 489 | 2025-01-07 17:18:52 | drugs | 1 | 28756 | 10 | 1.716 | 16757.6 |
| 488 | 2024-12-27 15:35:01 | drugs | 2 | 53800 | 126 | 5.406 | 9951.9 |
| 487 | 2024-12-27 09:57:21 | drugs | 2 | 53800 | 126 | 4.533 | 11868.5 |
| 486 | 2024-12-27 09:22:45 | drugs | 1 | 28756 | 10 | 0.530 | 54256.6 |