History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opioid"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 484 | 2025-12-03 16:44:37 | opioid | 1 | 48755 | 2 | 0.763 | 63899.1 |
| 483 | 2025-12-02 15:59:18 | opioid | 1 | 48755 | 2 | 0.903 | 53992.2 |
| 482 | 2025-11-27 19:03:14 | opioid | 3 | 112716 | 196 | 5.390 | 20912.1 |
| 481 | 2025-11-25 07:51:16 | opioid | 1 | 48755 | 2 | 0.873 | 55847.7 |
| 480 | 2025-11-21 08:15:54 | opioid | 1 | 48755 | 2 | 1.000 | 48755.0 |
| 479 | 2025-11-15 17:26:59 | opioid | 1 | 48755 | 2 | 0.873 | 55847.7 |
| 478 | 2025-11-11 20:32:30 | opioid | 1 | 48755 | 2 | 0.906 | 53813.5 |
| 477 | 2025-09-26 04:31:14 | opioid | 1 | 48755 | 2 | 0.763 | 63899.1 |
| 476 | 2025-09-23 09:21:00 | opioid | 1 | 48755 | 2 | 0.796 | 61250.0 |
| 475 | 2025-09-18 07:16:48 | opioid | 1 | 48755 | 2 | 0.906 | 53813.5 |
| 474 | 2025-09-01 07:28:26 | opioid | 1 | 48755 | 2 | 0.810 | 60191.4 |
| 473 | 2025-08-27 00:16:44 | opioid | 1 | 48755 | 2 | 0.750 | 65006.7 |
| 472 | 2025-08-14 00:24:37 | opioid | 1 | 48755 | 2 | 0.813 | 59969.2 |
| 471 | 2025-08-13 06:35:02 | opioid | 1 | 48755 | 2 | 4.343 | 11226.1 |
| 470 | 2025-08-11 06:47:58 | opioid | 1 | 48755 | 2 | 0.860 | 56691.9 |
| 469 | 2025-08-10 08:20:54 | opioid | 1 | 48755 | 2 | 3.733 | 13060.5 |
| 468 | 2025-08-05 09:26:56 | opioid | 1 | 48755 | 2 | 5.186 | 9401.3 |
| 467 | 2025-08-05 03:55:15 | opioid | 1 | 48755 | 2 | 3.800 | 12830.3 |
| 466 | 2025-08-02 04:42:34 | opioid | 1 | 48755 | 2 | 1.453 | 33554.7 |
| 465 | 2025-08-01 02:16:11 | opioid | 1 | 48755 | 2 | 2.266 | 21515.9 |
| 464 | 2025-07-25 02:46:30 | opioid | 1 | 48755 | 2 | 2.190 | 22262.6 |
| 463 | 2025-07-19 10:08:24 | opioid | 1 | 48755 | 2 | 1.716 | 28412.0 |
| 462 | 2025-07-14 18:03:08 | opioid | 2 | 82551 | 9 | 9.373 | 8807.3 |
| 461 | 2025-07-13 08:38:58 | opioid | 2 | 82551 | 9 | 2.690 | 30688.1 |
| 460 | 2025-07-13 04:55:34 | opioid | 1 | 48755 | 2 | 2.063 | 23633.1 |
| 459 | 2025-07-05 07:26:12 | opioid | 1 | 48755 | 2 | 1.970 | 24748.7 |
| 458 | 2025-07-04 21:45:23 | opioid | 2 | 82551 | 9 | 7.233 | 11413.1 |
| 457 | 2025-07-04 08:40:17 | opioid | 1 | 48755 | 2 | 1.200 | 40629.2 |
| 456 | 2025-06-28 08:17:24 | opioid | 1 | 48755 | 2 | 3.530 | 13811.6 |
| 455 | 2025-06-26 06:15:57 | opioid | 1 | 48755 | 2 | 2.143 | 22750.8 |
| 454 | 2025-06-23 01:48:35 | opioid | 1 | 48755 | 2 | 3.953 | 12333.7 |
| 453 | 2025-05-31 01:07:52 | opioid | 1 | 48755 | 2 | 4.406 | 11065.6 |
| 452 | 2025-05-22 03:13:39 | opioid | 2 | 82551 | 9 | 6.550 | 12603.2 |
| 451 | 2025-05-22 02:22:57 | opioid | 1 | 48755 | 2 | 3.906 | 12482.1 |
| 450 | 2025-05-21 09:56:41 | opioid | 1 | 48755 | 2 | 1.110 | 43923.4 |
| 449 | 2025-05-17 19:04:23 | opioid | 1 | 48755 | 2 | 3.936 | 12386.9 |
| 448 | 2025-05-16 08:39:20 | opioid | 1 | 48755 | 2 | 2.063 | 23633.1 |
| 447 | 2025-05-11 17:26:30 | opioid | 1 | 48755 | 2 | 0.813 | 59969.2 |
| 446 | 2025-04-30 16:37:24 | opioid | 2 | 82551 | 9 | 11.146 | 7406.3 |
| 445 | 2025-04-29 01:19:19 | opioid | 1 | 48755 | 2 | 0.843 | 57835.1 |
| 444 | 2025-04-26 06:36:09 | opioid | 3 | 112716 | 196 | 28.800 | 3913.8 |
| 443 | 2025-04-24 08:55:36 | opioid | 3 | 112716 | 196 | 29.266 | 3851.4 |
| 442 | 2025-04-23 05:11:15 | opioid | 1 | 48755 | 2 | 6.020 | 8098.8 |
| 441 | 2025-04-20 12:59:12 | opioid | 1 | 48755 | 2 | 4.126 | 11816.5 |
| 440 | 2025-04-11 10:31:23 | opioid | 2 | 82551 | 9 | 10.846 | 7611.2 |
| 439 | 2025-04-10 07:56:51 | opioid | 3 | 112716 | 196 | 6.343 | 17770.1 |
| 438 | 2025-04-09 07:53:37 | opioid | 1 | 48755 | 2 | 6.093 | 8001.8 |
| 437 | 2025-04-09 01:25:09 | opioid | 1 | 48755 | 2 | 3.813 | 12786.5 |
| 436 | 2025-04-09 00:25:10 | opioid | 3 | 112716 | 196 | 33.296 | 3385.3 |
| 435 | 2025-04-08 23:02:46 | opioid | 3 | 112716 | 196 | 23.466 | 4803.4 |
| 434 | 2025-04-08 19:27:12 | opioid | 3 | 112716 | 196 | 29.496 | 3821.4 |
| 433 | 2025-04-07 23:31:57 | opioid | 3 | 112716 | 196 | 16.983 | 6637.0 |
| 432 | 2025-04-02 22:43:21 | opioid | 1 | 48755 | 2 | 0.763 | 63899.1 |
| 431 | 2025-03-29 02:11:13 | opioid | 1 | 48755 | 2 | 1.983 | 24586.5 |
| 430 | 2025-03-24 20:27:35 | opioid | 2 | 82551 | 9 | 6.390 | 12918.8 |
| 429 | 2025-03-23 05:46:47 | opioid | 1 | 48755 | 2 | 4.080 | 11949.8 |
| 428 | 2025-03-20 12:40:25 | opioid | 3 | 112716 | 196 | 28.810 | 3912.4 |
| 427 | 2025-03-20 11:34:04 | opioid | 1 | 48755 | 2 | 5.766 | 8455.6 |
| 426 | 2025-03-17 18:46:44 | opioid | 3 | 112716 | 196 | 14.703 | 7666.2 |
| 425 | 2025-03-09 07:16:08 | opioid | 1 | 48755 | 2 | 2.500 | 19502.0 |
| 424 | 2025-03-06 19:17:39 | opioid | 3 | 112716 | 196 | 31.050 | 3630.1 |
| 423 | 2025-03-05 01:59:03 | opioid | 3 | 112716 | 196 | 26.986 | 4176.8 |
| 422 | 2025-03-04 23:26:17 | opioid | 3 | 112716 | 196 | 28.576 | 3944.4 |
| 421 | 2025-03-04 20:33:31 | opioid | 3 | 112716 | 196 | 18.030 | 6251.6 |
| 420 | 2025-03-04 14:58:36 | opioid | 3 | 112716 | 196 | 25.423 | 4433.6 |
| 419 | 2025-03-03 18:07:59 | opioid | 1 | 48755 | 2 | 2.376 | 20519.8 |
| 418 | 2025-02-24 01:12:36 | opioid | 3 | 112716 | 196 | 26.736 | 4215.9 |
| 417 | 2025-02-23 22:48:12 | opioid | 1 | 48755 | 2 | 3.966 | 12293.2 |
| 416 | 2025-02-23 22:40:08 | opioid | 3 | 112716 | 196 | 5.953 | 18934.3 |
| 415 | 2025-02-23 22:40:08 | opioid | 2 | 82551 | 9 | 2.546 | 32423.8 |
| 414 | 2025-02-07 02:42:44 | opioid | 1 | 48755 | 2 | 3.720 | 13106.2 |
| 413 | 2025-02-03 14:44:47 | opioid | 1 | 48755 | 2 | 3.110 | 15676.8 |
| 412 | 2025-01-30 12:21:38 | opioid | 2 | 82551 | 9 | 11.016 | 7493.7 |
| 411 | 2025-01-30 12:21:22 | opioid | 1 | 48755 | 2 | 6.156 | 7919.9 |
| 410 | 2025-01-20 09:06:14 | opioid | 3 | 112716 | 196 | 26.126 | 4314.3 |
| 409 | 2025-01-19 07:59:15 | opioid | 3 | 112716 | 196 | 24.390 | 4621.4 |
| 408 | 2025-01-18 04:49:03 | opioid | 2 | 82551 | 9 | 10.076 | 8192.8 |
| 407 | 2025-01-18 04:48:33 | opioid | 1 | 48755 | 2 | 1.970 | 24748.7 |
| 406 | 2025-01-15 08:53:14 | opioid | 3 | 112716 | 196 | 26.706 | 4220.6 |
| 405 | 2025-01-14 10:25:09 | opioid | 3 | 112716 | 196 | 22.936 | 4914.4 |
| 404 | 2025-01-14 10:25:10 | opioid | 2 | 82551 | 9 | 5.860 | 14087.2 |
| 403 | 2025-01-02 22:08:12 | opioid | 1 | 48755 | 2 | 2.110 | 23106.6 |
| 402 | 2025-01-02 21:38:06 | opioid | 2 | 82551 | 9 | 2.216 | 37252.3 |
| 401 | 2025-01-01 15:12:40 | opioid | 3 | 112716 | 196 | 32.420 | 3476.7 |
| 400 | 2024-12-29 11:52:12 | opioid | 1 | 48755 | 2 | 2.326 | 20960.9 |
| 399 | 2024-12-28 11:58:14 | opioid | 1 | 48755 | 2 | 3.986 | 12231.6 |
| 398 | 2024-12-15 20:21:47 | opioid | 1 | 48755 | 2 | 4.140 | 11776.6 |
| 397 | 2024-12-11 02:44:01 | opioid | 3 | 112716 | 196 | 31.656 | 3560.7 |
| 396 | 2024-12-10 18:30:15 | opioid | 3 | 112716 | 196 | 30.936 | 3643.5 |
| 395 | 2024-12-10 15:52:46 | opioid | 3 | 112716 | 196 | 21.533 | 5234.6 |
| 394 | 2024-12-10 05:07:13 | opioid | 3 | 112716 | 196 | 14.626 | 7706.5 |
| 393 | 2024-12-10 05:07:13 | opioid | 2 | 82551 | 9 | 6.360 | 12979.7 |
| 392 | 2024-11-29 10:59:37 | opioid | 1 | 48755 | 2 | 4.653 | 10478.2 |
| 391 | 2024-11-29 09:39:32 | opioid | 1 | 48755 | 2 | 3.516 | 13866.6 |
| 390 | 2024-11-27 16:10:53 | opioid | 1 | 48755 | 2 | 1.810 | 26936.5 |
| 389 | 2024-11-14 14:14:34 | opioid | 1 | 48755 | 2 | 0.893 | 54596.9 |
| 388 | 2024-11-10 01:46:46 | opioid | 3 | 112716 | 196 | 24.580 | 4585.7 |
| 387 | 2024-11-09 07:31:54 | opioid | 3 | 112716 | 196 | 28.566 | 3945.8 |
| 386 | 2024-11-08 14:38:13 | opioid | 3 | 112716 | 196 | 17.186 | 6558.6 |
| 385 | 2024-11-08 02:46:25 | opioid | 3 | 112716 | 196 | 28.486 | 3956.9 |