History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opioids"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 388 | 2025-10-20 23:05:45 | opioids | 1 | 69583 | 2 | 4.796 | 14508.5 |
| 387 | 2025-10-11 08:03:47 | opioids | 1 | 69583 | 2 | 1.156 | 60192.9 |
| 386 | 2025-10-07 20:09:38 | opioids | 1 | 69583 | 2 | 1.143 | 60877.5 |
| 385 | 2025-10-07 18:32:07 | opioids | 1 | 69583 | 2 | 1.156 | 60192.9 |
| 384 | 2025-09-29 17:59:15 | opioids | 1 | 69583 | 2 | 1.156 | 60192.9 |
| 383 | 2025-09-28 05:57:46 | opioids | 1 | 69583 | 2 | 1.203 | 57841.2 |
| 382 | 2025-09-27 20:29:29 | opioids | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 381 | 2025-09-26 09:07:02 | opioids | 1 | 69583 | 2 | 1.106 | 62914.1 |
| 380 | 2025-09-18 21:31:02 | opioids | 1 | 69583 | 2 | 1.216 | 57222.9 |
| 379 | 2025-09-08 12:49:31 | opioids | 1 | 69583 | 2 | 1.203 | 57841.2 |
| 378 | 2025-08-28 04:46:55 | opioids | 1 | 69583 | 2 | 1.140 | 61037.7 |
| 377 | 2025-08-27 20:29:36 | opioids | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 376 | 2025-08-27 05:37:33 | opioids | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 375 | 2025-08-23 15:51:33 | opioids | 1 | 69583 | 2 | 7.533 | 9237.1 |
| 374 | 2025-08-20 22:20:57 | opioids | 1 | 69583 | 2 | 2.750 | 25302.9 |
| 373 | 2025-08-19 10:37:52 | opioids | 1 | 69583 | 2 | 2.343 | 29698.3 |
| 372 | 2025-08-09 08:31:42 | opioids | 1 | 69583 | 2 | 6.860 | 10143.3 |
| 371 | 2025-07-27 06:23:02 | opioids | 1 | 69583 | 2 | 3.390 | 20526.0 |
| 370 | 2025-07-24 23:42:21 | opioids | 1 | 69583 | 2 | 5.156 | 13495.5 |
| 369 | 2025-07-16 22:12:41 | opioids | 1 | 69583 | 2 | 2.953 | 23563.5 |
| 368 | 2025-07-16 04:15:59 | opioids | 1 | 69583 | 2 | 5.236 | 13289.3 |
| 367 | 2025-07-14 16:42:50 | opioids | 3 | 134027 | 124 | 29.750 | 4505.1 |
| 366 | 2025-07-14 15:09:36 | opioids | 3 | 134027 | 124 | 35.706 | 3753.6 |
| 365 | 2025-07-14 00:07:37 | opioids | 1 | 69583 | 2 | 4.623 | 15051.5 |
| 364 | 2025-07-10 23:27:54 | opioids | 2 | 107671 | 5 | 8.703 | 12371.7 |
| 363 | 2025-07-10 14:00:39 | opioids | 3 | 134027 | 124 | 31.953 | 4194.5 |
| 362 | 2025-07-10 12:53:20 | opioids | 3 | 134027 | 124 | 21.703 | 6175.5 |
| 361 | 2025-07-09 05:50:50 | opioids | 1 | 69583 | 2 | 1.686 | 41271.1 |
| 360 | 2025-07-04 00:44:22 | opioids | 1 | 69583 | 2 | 5.890 | 11813.8 |
| 359 | 2025-06-24 09:10:21 | opioids | 2 | 107671 | 5 | 10.546 | 10209.7 |
| 358 | 2025-06-23 06:45:51 | opioids | 1 | 69583 | 2 | 1.326 | 52475.9 |
| 357 | 2025-06-16 05:43:35 | opioids | 1 | 69583 | 2 | 5.890 | 11813.8 |
| 356 | 2025-06-12 14:48:08 | opioids | 1 | 69583 | 2 | 4.063 | 17126.0 |
| 355 | 2025-06-08 06:15:09 | opioids | 1 | 69583 | 2 | 7.483 | 9298.8 |
| 354 | 2025-06-04 11:08:28 | opioids | 1 | 69583 | 2 | 3.580 | 19436.6 |
| 353 | 2025-05-26 21:05:38 | opioids | 1 | 69583 | 2 | 3.156 | 22047.8 |
| 352 | 2025-05-12 09:01:51 | opioids | 1 | 69583 | 2 | 3.873 | 17966.2 |
| 351 | 2025-05-06 07:54:05 | opioids | 1 | 69583 | 2 | 2.656 | 26198.4 |
| 350 | 2025-05-04 12:07:56 | opioids | 1 | 69583 | 2 | 2.906 | 23944.6 |
| 349 | 2025-05-03 22:22:58 | opioids | 1 | 69583 | 2 | 4.686 | 14849.1 |
| 348 | 2025-04-25 20:45:06 | opioids | 1 | 69583 | 2 | 2.796 | 24886.6 |
| 347 | 2025-04-11 05:16:21 | opioids | 1 | 69583 | 2 | 5.546 | 12546.5 |
| 346 | 2025-04-02 06:24:14 | opioids | 1 | 69583 | 2 | 5.766 | 12067.8 |
| 345 | 2025-04-02 05:56:43 | opioids | 1 | 69583 | 2 | 5.596 | 12434.4 |
| 344 | 2025-03-25 13:30:06 | opioids | 1 | 69583 | 2 | 2.546 | 27330.3 |
| 343 | 2025-03-24 14:21:28 | opioids | 3 | 134027 | 124 | 6.830 | 19623.3 |
| 342 | 2025-03-21 14:33:22 | opioids | 3 | 134027 | 124 | 30.800 | 4351.5 |
| 341 | 2025-03-20 23:29:02 | opioids | 2 | 107671 | 5 | 8.190 | 13146.6 |
| 340 | 2025-03-19 21:40:58 | opioids | 1 | 69583 | 2 | 2.936 | 23699.9 |
| 339 | 2025-03-11 08:42:27 | opioids | 3 | 134027 | 124 | 33.566 | 3992.9 |
| 338 | 2025-03-11 08:08:32 | opioids | 1 | 69583 | 2 | 9.393 | 7408.0 |
| 337 | 2025-03-10 07:38:56 | opioids | 3 | 134027 | 124 | 49.080 | 2730.8 |
| 336 | 2025-03-09 16:16:22 | opioids | 3 | 134027 | 124 | 33.596 | 3989.4 |
| 335 | 2025-03-09 10:53:02 | opioids | 3 | 134027 | 124 | 39.940 | 3355.7 |
| 334 | 2025-02-27 08:20:29 | opioids | 1 | 69583 | 2 | 3.826 | 18186.9 |
| 333 | 2025-02-11 16:32:12 | opioids | 1 | 69583 | 2 | 3.250 | 21410.2 |
| 332 | 2025-02-09 15:07:40 | opioids | 2 | 107671 | 5 | 19.890 | 5413.3 |
| 331 | 2025-02-07 10:25:45 | opioids | 3 | 134027 | 124 | 26.203 | 5114.9 |
| 330 | 2025-02-07 10:25:44 | opioids | 2 | 107671 | 5 | 9.436 | 11410.7 |
| 329 | 2025-02-07 10:23:26 | opioids | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 328 | 2025-02-01 01:07:37 | opioids | 3 | 134027 | 124 | 31.783 | 4216.9 |
| 327 | 2025-01-30 12:22:38 | opioids | 3 | 134027 | 124 | 34.566 | 3877.4 |
| 326 | 2025-01-30 12:22:41 | opioids | 2 | 107671 | 5 | 16.360 | 6581.4 |
| 325 | 2025-01-06 18:54:59 | opioids | 1 | 69583 | 2 | 6.300 | 11044.9 |
| 324 | 2024-12-28 11:58:13 | opioids | 1 | 69583 | 2 | 6.050 | 11501.3 |
| 323 | 2024-12-26 13:53:38 | opioids | 2 | 107671 | 5 | 16.156 | 6664.5 |
| 322 | 2024-12-24 15:38:21 | opioids | 1 | 69583 | 2 | 3.673 | 18944.5 |
| 321 | 2024-12-23 06:09:40 | opioids | 3 | 134027 | 124 | 28.016 | 4783.9 |
| 320 | 2024-12-23 00:28:28 | opioids | 3 | 134027 | 124 | 16.326 | 8209.4 |
| 319 | 2024-12-19 23:19:29 | opioids | 1 | 69583 | 2 | 2.703 | 25742.9 |
| 318 | 2024-11-30 22:04:52 | opioids | 1 | 69583 | 2 | 2.796 | 24886.6 |
| 317 | 2024-11-28 02:12:39 | opioids | 3 | 134027 | 124 | 36.156 | 3706.9 |
| 316 | 2024-11-28 00:46:13 | opioids | 3 | 134027 | 124 | 48.813 | 2745.7 |
| 315 | 2024-11-27 16:36:57 | opioids | 3 | 134027 | 124 | 32.986 | 4063.1 |
| 314 | 2024-11-27 16:10:22 | opioids | 1 | 69583 | 2 | 3.140 | 22160.2 |
| 313 | 2024-10-29 09:41:36 | opioids | 1 | 69583 | 2 | 5.623 | 12374.7 |
| 312 | 2024-10-28 12:40:52 | opioids | 1 | 69583 | 2 | 14.640 | 4752.9 |
| 311 | 2024-10-25 17:03:43 | opioids | 1 | 69583 | 2 | 5.656 | 12302.5 |
| 310 | 2024-10-14 00:59:48 | opioids | 1 | 69583 | 2 | 5.923 | 11747.9 |
| 309 | 2024-10-13 11:12:41 | opioids | 3 | 134027 | 124 | 31.170 | 4299.9 |
| 308 | 2024-10-12 18:58:21 | opioids | 3 | 134027 | 124 | 30.456 | 4400.7 |
| 307 | 2024-10-11 19:51:59 | opioids | 3 | 134027 | 124 | 22.083 | 6069.2 |
| 306 | 2024-10-11 19:51:58 | opioids | 2 | 107671 | 5 | 6.506 | 16549.5 |
| 305 | 2024-09-27 12:16:13 | opioids | 1 | 69583 | 2 | 4.483 | 15521.5 |
| 304 | 2024-09-22 22:47:00 | opioids | 1 | 69583 | 2 | 8.313 | 8370.4 |
| 303 | 2024-09-21 14:03:49 | opioids | 1 | 69583 | 2 | 5.156 | 13495.5 |
| 302 | 2024-09-13 19:46:44 | opioids | 1 | 69583 | 2 | 3.733 | 18640.0 |
| 301 | 2024-09-07 16:06:35 | opioids | 1 | 69583 | 2 | 9.656 | 7206.2 |
| 300 | 2024-09-04 18:12:05 | opioids | 1 | 69583 | 2 | 9.610 | 7240.7 |
| 299 | 2024-08-18 22:46:01 | opioids | 1 | 69583 | 2 | 8.780 | 7925.2 |
| 298 | 2024-08-12 13:01:33 | opioids | 1 | 69583 | 2 | 8.016 | 8680.5 |
| 297 | 2024-07-17 07:39:39 | opioids | 1 | 69583 | 2 | 4.453 | 15626.1 |
| 296 | 2024-07-16 07:31:11 | opioids | 1 | 69583 | 2 | 4.860 | 14317.5 |
| 295 | 2024-07-11 02:51:56 | opioids | 1 | 69583 | 2 | 3.906 | 17814.4 |
| 294 | 2024-07-10 23:41:22 | opioids | 1 | 69583 | 2 | 2.766 | 25156.5 |
| 293 | 2024-07-10 14:19:38 | opioids | 1 | 69583 | 2 | 4.610 | 15093.9 |
| 292 | 2024-07-07 06:53:06 | opioids | 1 | 69583 | 2 | 5.483 | 12690.7 |
| 291 | 2024-07-06 08:37:42 | opioids | 1 | 69583 | 2 | 6.593 | 10554.1 |
| 290 | 2024-06-29 06:05:20 | opioids | 3 | 134027 | 124 | 22.406 | 5981.7 |
| 289 | 2024-06-28 17:15:20 | opioids | 3 | 134027 | 124 | 29.923 | 4479.1 |