History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prescriber"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 393 | 2025-10-25 17:39:31 | prescriber | 1 | 67641 | 6 | 1.220 | 55443.4 |
| 392 | 2025-10-23 07:56:17 | prescriber | 1 | 67641 | 6 | 4.313 | 15683.1 |
| 391 | 2025-10-23 07:56:11 | prescriber | 1 | 67641 | 6 | 5.796 | 11670.3 |
| 390 | 2025-10-23 07:56:02 | prescriber | 1 | 67641 | 6 | 2.953 | 22905.9 |
| 389 | 2025-10-23 07:55:51 | prescriber | 1 | 67641 | 6 | 5.690 | 11887.7 |
| 388 | 2025-08-28 00:01:19 | prescriber | 1 | 67641 | 6 | 1.216 | 55625.8 |
| 387 | 2025-08-14 17:17:11 | prescriber | 3 | 140603 | 30 | 6.093 | 23076.2 |
| 386 | 2025-08-11 05:38:43 | prescriber | 1 | 67641 | 6 | 2.703 | 25024.4 |
| 385 | 2025-08-09 17:29:29 | prescriber | 1 | 67641 | 6 | 6.546 | 10333.2 |
| 384 | 2025-08-09 00:04:51 | prescriber | 1 | 67641 | 6 | 2.970 | 22774.7 |
| 383 | 2025-07-24 14:37:35 | prescriber | 1 | 67641 | 6 | 5.233 | 12925.9 |
| 382 | 2025-07-23 18:20:51 | prescriber | 1 | 67641 | 6 | 5.330 | 12690.6 |
| 381 | 2025-07-23 17:24:45 | prescriber | 3 | 140603 | 30 | 25.813 | 5447.0 |
| 380 | 2025-07-22 15:18:13 | prescriber | 1 | 67641 | 6 | 3.953 | 17111.3 |
| 379 | 2025-07-22 07:36:56 | prescriber | 1 | 67641 | 6 | 2.703 | 25024.4 |
| 378 | 2025-07-21 23:04:39 | prescriber | 3 | 140603 | 30 | 32.910 | 4272.3 |
| 377 | 2025-07-18 18:19:51 | prescriber | 3 | 140603 | 30 | 31.116 | 4518.7 |
| 376 | 2025-07-16 01:55:22 | prescriber | 1 | 67641 | 6 | 1.280 | 52844.5 |
| 375 | 2025-07-15 16:28:16 | prescriber | 1 | 67641 | 6 | 1.266 | 53428.9 |
| 374 | 2025-07-10 23:30:53 | prescriber | 2 | 108824 | 11 | 24.816 | 4385.2 |
| 373 | 2025-07-09 16:42:18 | prescriber | 3 | 140603 | 30 | 6.360 | 22107.4 |
| 372 | 2025-07-09 03:35:20 | prescriber | 1 | 67641 | 6 | 8.266 | 8183.0 |
| 371 | 2025-07-08 00:13:31 | prescriber | 1 | 67641 | 6 | 6.656 | 10162.4 |
| 370 | 2025-07-07 07:34:04 | prescriber | 3 | 140603 | 30 | 33.173 | 4238.5 |
| 369 | 2025-07-03 01:08:26 | prescriber | 3 | 140603 | 30 | 33.066 | 4252.2 |
| 368 | 2025-07-01 21:19:26 | prescriber | 3 | 140603 | 30 | 25.003 | 5623.4 |
| 367 | 2025-07-01 21:01:30 | prescriber | 1 | 67641 | 6 | 2.953 | 22905.9 |
| 366 | 2025-06-30 14:50:07 | prescriber | 4 | 161450 | 175 | 53.706 | 3006.2 |
| 365 | 2025-06-28 11:54:44 | prescriber | 3 | 140603 | 30 | 20.783 | 6765.3 |
| 364 | 2025-06-28 01:51:00 | prescriber | 2 | 108824 | 11 | 11.500 | 9463.0 |
| 363 | 2025-06-28 00:43:53 | prescriber | 4 | 161450 | 175 | 77.066 | 2095.0 |
| 362 | 2025-06-26 22:10:11 | prescriber | 1 | 67641 | 6 | 4.220 | 16028.7 |
| 361 | 2025-06-26 15:53:22 | prescriber | 1 | 67641 | 6 | 4.673 | 14474.9 |
| 360 | 2025-06-25 03:11:40 | prescriber | 1 | 67641 | 6 | 5.076 | 13325.7 |
| 359 | 2025-06-17 05:03:09 | prescriber | 1 | 67641 | 6 | 1.406 | 48108.8 |
| 358 | 2025-06-14 09:11:30 | prescriber | 1 | 67641 | 6 | 8.296 | 8153.4 |
| 357 | 2025-06-11 18:10:19 | prescriber | 1 | 67641 | 6 | 1.046 | 64666.3 |
| 356 | 2025-06-04 12:41:07 | prescriber | 4 | 161450 | 175 | 80.486 | 2005.9 |
| 355 | 2025-06-04 01:17:42 | prescriber | 1 | 67641 | 6 | 7.813 | 8657.5 |
| 354 | 2025-06-02 00:38:03 | prescriber | 4 | 161450 | 175 | 64.286 | 2511.4 |
| 353 | 2025-05-31 07:53:08 | prescriber | 3 | 140603 | 30 | 21.113 | 6659.5 |
| 352 | 2025-05-30 13:32:48 | prescriber | 4 | 161450 | 175 | 59.240 | 2725.4 |
| 351 | 2025-05-30 08:49:46 | prescriber | 4 | 161450 | 175 | 66.926 | 2412.4 |
| 350 | 2025-05-28 11:27:25 | prescriber | 3 | 140603 | 30 | 13.203 | 10649.3 |
| 349 | 2025-05-28 03:50:35 | prescriber | 4 | 161450 | 175 | 37.406 | 4316.2 |
| 348 | 2025-05-28 03:50:29 | prescriber | 2 | 108824 | 11 | 3.220 | 33796.3 |
| 347 | 2025-05-27 17:55:33 | prescriber | 1 | 67641 | 6 | 3.170 | 21337.9 |
| 346 | 2025-05-26 22:28:05 | prescriber | 1 | 67641 | 6 | 6.186 | 10934.5 |
| 345 | 2025-05-26 15:40:28 | prescriber | 1 | 67641 | 6 | 5.596 | 12087.4 |
| 344 | 2025-05-26 00:37:11 | prescriber | 1 | 67641 | 6 | 6.093 | 11101.4 |
| 343 | 2025-05-03 18:47:21 | prescriber | 3 | 140603 | 30 | 6.140 | 22899.5 |
| 342 | 2025-04-26 14:45:51 | prescriber | 1 | 67641 | 6 | 3.296 | 20522.1 |
| 341 | 2025-04-23 11:33:06 | prescriber | 3 | 140603 | 30 | 23.766 | 5916.1 |
| 340 | 2025-04-22 21:34:06 | prescriber | 3 | 140603 | 30 | 21.486 | 6543.9 |
| 339 | 2025-04-22 08:27:54 | prescriber | 3 | 140603 | 30 | 6.156 | 22840.0 |
| 338 | 2025-04-19 20:35:43 | prescriber | 3 | 140603 | 30 | 46.986 | 2992.4 |
| 337 | 2025-04-14 16:40:12 | prescriber | 3 | 140603 | 30 | 33.220 | 4232.5 |
| 336 | 2025-04-10 23:04:53 | prescriber | 1 | 67641 | 6 | 4.986 | 13566.2 |
| 335 | 2025-04-06 10:10:34 | prescriber | 3 | 140603 | 30 | 25.563 | 5500.3 |
| 334 | 2025-04-06 03:42:47 | prescriber | 2 | 108824 | 11 | 16.703 | 6515.2 |
| 333 | 2025-04-05 00:28:44 | prescriber | 1 | 67641 | 6 | 1.266 | 53428.9 |
| 332 | 2025-03-30 22:50:08 | prescriber | 4 | 161450 | 175 | 47.186 | 3421.6 |
| 331 | 2025-03-25 07:52:42 | prescriber | 4 | 161450 | 175 | 50.770 | 3180.0 |
| 330 | 2025-03-22 03:11:48 | prescriber | 2 | 108824 | 11 | 6.843 | 15903.0 |
| 329 | 2025-03-22 01:01:33 | prescriber | 4 | 161450 | 175 | 50.800 | 3178.1 |
| 328 | 2025-03-20 20:36:58 | prescriber | 3 | 140603 | 30 | 5.953 | 23618.8 |
| 327 | 2025-03-20 10:03:19 | prescriber | 1 | 67641 | 6 | 2.923 | 23141.0 |
| 326 | 2025-03-19 21:12:21 | prescriber | 1 | 67641 | 6 | 8.530 | 7929.8 |
| 325 | 2025-03-17 19:35:23 | prescriber | 3 | 140603 | 30 | 33.423 | 4206.8 |
| 324 | 2025-03-11 03:56:37 | prescriber | 1 | 67641 | 6 | 5.500 | 12298.4 |
| 323 | 2025-03-09 14:31:40 | prescriber | 3 | 140603 | 30 | 31.423 | 4474.5 |
| 322 | 2025-03-09 14:31:32 | prescriber | 3 | 140603 | 30 | 32.660 | 4305.1 |
| 321 | 2025-03-09 14:31:28 | prescriber | 2 | 108824 | 11 | 14.703 | 7401.5 |
| 320 | 2025-03-09 14:29:03 | prescriber | 1 | 67641 | 6 | 6.060 | 11161.9 |
| 319 | 2025-03-07 22:05:54 | prescriber | 3 | 140603 | 30 | 32.500 | 4326.2 |
| 318 | 2025-03-07 22:05:53 | prescriber | 3 | 140603 | 30 | 20.140 | 6981.3 |
| 317 | 2025-03-07 22:05:51 | prescriber | 2 | 108824 | 11 | 8.060 | 13501.7 |
| 316 | 2025-03-07 21:35:24 | prescriber | 1 | 67641 | 6 | 1.046 | 64666.3 |
| 315 | 2025-02-14 15:42:53 | prescriber | 3 | 140603 | 30 | 36.080 | 3897.0 |
| 314 | 2025-02-11 16:51:31 | prescriber | 2 | 108824 | 11 | 9.313 | 11685.2 |
| 313 | 2025-02-11 16:48:36 | prescriber | 1 | 67641 | 6 | 5.720 | 11825.3 |
| 312 | 2025-02-06 08:56:50 | prescriber | 2 | 108824 | 11 | 13.673 | 7959.0 |
| 311 | 2025-02-03 13:59:51 | prescriber | 3 | 140603 | 30 | 32.860 | 4278.8 |
| 310 | 2025-02-03 13:59:14 | prescriber | 3 | 140603 | 30 | 34.876 | 4031.5 |
| 309 | 2025-02-03 00:34:00 | prescriber | 1 | 67641 | 6 | 5.813 | 11636.2 |
| 308 | 2025-02-02 15:40:32 | prescriber | 3 | 140603 | 30 | 37.173 | 3782.4 |
| 307 | 2025-02-01 23:55:57 | prescriber | 3 | 140603 | 30 | 35.046 | 4012.0 |
| 306 | 2025-02-01 16:04:54 | prescriber | 3 | 140603 | 30 | 37.533 | 3746.1 |
| 305 | 2025-02-01 16:04:54 | prescriber | 2 | 108824 | 11 | 19.390 | 5612.4 |
| 304 | 2025-02-01 15:58:43 | prescriber | 1 | 67641 | 6 | 2.503 | 27024.0 |
| 303 | 2025-01-28 05:24:11 | prescriber | 4 | 161450 | 175 | 24.376 | 6623.3 |
| 302 | 2025-01-05 15:29:15 | prescriber | 1 | 67641 | 6 | 3.000 | 22547.0 |
| 301 | 2025-01-04 15:37:55 | prescriber | 4 | 161450 | 175 | 76.883 | 2099.9 |
| 300 | 2025-01-04 15:38:13 | prescriber | 2 | 108824 | 11 | 16.766 | 6490.8 |
| 299 | 2025-01-04 15:31:16 | prescriber | 1 | 67641 | 6 | 3.250 | 20812.6 |
| 298 | 2025-01-02 09:58:26 | prescriber | 2 | 108824 | 11 | 24.800 | 4388.1 |
| 297 | 2025-01-02 09:58:17 | prescriber | 3 | 140603 | 30 | 25.860 | 5437.1 |
| 296 | 2025-01-02 09:53:47 | prescriber | 1 | 67641 | 6 | 5.843 | 11576.4 |
| 295 | 2024-12-30 18:09:46 | prescriber | 1 | 67641 | 6 | 1.096 | 61716.2 |
| 294 | 2024-12-20 17:34:21 | prescriber | 3 | 140603 | 30 | 33.253 | 4228.3 |