History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substances"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 361 | 2025-10-25 20:09:08 | substances | 1 | 67641 | 2 | 3.326 | 20337.0 |
| 360 | 2025-10-24 18:30:27 | substances | 2 | 108824 | 5 | 7.063 | 15407.6 |
| 359 | 2025-10-14 13:15:53 | substances | 1 | 67641 | 2 | 1.250 | 54112.8 |
| 358 | 2025-09-30 15:48:34 | substances | 3 | 140603 | 34 | 11.220 | 12531.5 |
| 357 | 2025-09-09 19:18:24 | substances | 3 | 140603 | 34 | 13.360 | 10524.2 |
| 356 | 2025-09-08 10:37:46 | substances | 2 | 108824 | 5 | 2.906 | 37448.0 |
| 355 | 2025-08-24 05:07:17 | substances | 1 | 67641 | 2 | 1.233 | 54858.9 |
| 354 | 2025-08-12 11:29:40 | substances | 4 | 161450 | 229 | 23.643 | 6828.7 |
| 353 | 2025-08-12 02:06:26 | substances | 4 | 161450 | 229 | 26.440 | 6106.3 |
| 352 | 2025-08-11 07:08:47 | substances | 2 | 108824 | 5 | 3.030 | 35915.5 |
| 351 | 2025-08-11 06:13:05 | substances | 3 | 140603 | 34 | 5.843 | 24063.5 |
| 350 | 2025-08-09 17:22:16 | substances | 1 | 67641 | 2 | 1.190 | 56841.2 |
| 349 | 2025-08-06 02:45:15 | substances | 4 | 161450 | 229 | 25.240 | 6396.6 |
| 348 | 2025-08-06 02:45:09 | substances | 4 | 161450 | 229 | 26.316 | 6135.1 |
| 347 | 2025-08-05 11:09:19 | substances | 4 | 161450 | 229 | 39.973 | 4039.0 |
| 346 | 2025-08-04 22:11:45 | substances | 3 | 140603 | 34 | 28.186 | 4988.4 |
| 345 | 2025-08-03 15:15:52 | substances | 3 | 140603 | 34 | 6.346 | 22156.2 |
| 344 | 2025-08-03 14:23:38 | substances | 2 | 108824 | 5 | 3.030 | 35915.5 |
| 343 | 2025-08-03 08:06:32 | substances | 4 | 161450 | 229 | 11.326 | 14254.8 |
| 342 | 2025-08-03 03:08:32 | substances | 1 | 67641 | 2 | 3.063 | 22083.3 |
| 341 | 2025-07-30 19:27:43 | substances | 2 | 108824 | 5 | 2.906 | 37448.0 |
| 340 | 2025-07-25 08:23:26 | substances | 1 | 67641 | 2 | 4.576 | 14781.7 |
| 339 | 2025-07-24 22:35:38 | substances | 1 | 67641 | 2 | 4.280 | 15804.0 |
| 338 | 2025-07-24 17:43:36 | substances | 1 | 67641 | 2 | 6.173 | 10957.6 |
| 337 | 2025-07-24 06:23:50 | substances | 1 | 67641 | 2 | 4.483 | 15088.3 |
| 336 | 2025-07-23 16:16:22 | substances | 1 | 67641 | 2 | 2.970 | 22774.7 |
| 335 | 2025-07-22 23:27:08 | substances | 1 | 67641 | 2 | 2.310 | 29281.8 |
| 334 | 2025-07-22 14:59:36 | substances | 1 | 67641 | 2 | 2.593 | 26086.0 |
| 333 | 2025-07-21 10:48:51 | substances | 1 | 67641 | 2 | 1.186 | 57032.9 |
| 332 | 2025-07-09 14:40:30 | substances | 4 | 161450 | 229 | 33.270 | 4852.7 |
| 331 | 2025-07-08 05:58:37 | substances | 4 | 161450 | 229 | 64.156 | 2516.5 |
| 330 | 2025-07-07 21:16:44 | substances | 4 | 161450 | 229 | 51.986 | 3105.6 |
| 329 | 2025-07-05 15:18:06 | substances | 4 | 161450 | 229 | 70.410 | 2293.0 |
| 328 | 2025-07-02 14:49:22 | substances | 4 | 161450 | 229 | 44.733 | 3609.2 |
| 327 | 2025-06-26 16:29:04 | substances | 1 | 67641 | 2 | 3.813 | 17739.6 |
| 326 | 2025-06-22 06:13:09 | substances | 1 | 67641 | 2 | 5.670 | 11929.6 |
| 325 | 2025-06-18 12:42:28 | substances | 1 | 67641 | 2 | 6.436 | 10509.8 |
| 324 | 2025-06-16 13:58:12 | substances | 1 | 67641 | 2 | 8.233 | 8215.8 |
| 323 | 2025-06-10 05:53:20 | substances | 1 | 67641 | 2 | 3.016 | 22427.4 |
| 322 | 2025-06-09 19:26:41 | substances | 2 | 108824 | 5 | 2.626 | 41441.0 |
| 321 | 2025-06-06 06:17:40 | substances | 1 | 67641 | 2 | 6.046 | 11187.7 |
| 320 | 2025-06-04 15:36:58 | substances | 4 | 161450 | 229 | 47.736 | 3382.1 |
| 319 | 2025-05-30 07:05:52 | substances | 2 | 108824 | 5 | 13.670 | 7960.8 |
| 318 | 2025-05-26 16:40:55 | substances | 1 | 67641 | 2 | 7.716 | 8766.3 |
| 317 | 2025-05-26 13:57:44 | substances | 4 | 161450 | 229 | 49.600 | 3255.0 |
| 316 | 2025-05-26 05:24:01 | substances | 3 | 140603 | 34 | 18.750 | 7498.8 |
| 315 | 2025-05-26 04:57:47 | substances | 3 | 140603 | 34 | 31.860 | 4413.2 |
| 314 | 2025-05-25 16:05:08 | substances | 1 | 67641 | 2 | 1.453 | 46552.6 |
| 313 | 2025-05-24 09:34:35 | substances | 3 | 140603 | 34 | 32.216 | 4364.4 |
| 312 | 2025-05-23 15:14:08 | substances | 4 | 161450 | 229 | 52.503 | 3075.1 |
| 311 | 2025-05-23 14:52:12 | substances | 4 | 161450 | 229 | 12.813 | 12600.5 |
| 310 | 2025-05-23 06:54:25 | substances | 3 | 140603 | 34 | 26.983 | 5210.8 |
| 309 | 2025-05-22 23:16:11 | substances | 2 | 108824 | 5 | 2.766 | 39343.5 |
| 308 | 2025-05-20 01:15:24 | substances | 3 | 140603 | 34 | 20.266 | 6937.9 |
| 307 | 2025-05-20 01:04:20 | substances | 2 | 108824 | 5 | 12.530 | 8685.1 |
| 306 | 2025-05-19 05:42:41 | substances | 1 | 67641 | 2 | 2.313 | 29243.8 |
| 305 | 2025-05-15 11:55:30 | substances | 1 | 67641 | 2 | 1.233 | 54858.9 |
| 304 | 2025-05-15 04:03:14 | substances | 1 | 67641 | 2 | 5.563 | 12159.1 |
| 303 | 2025-04-26 15:27:31 | substances | 1 | 67641 | 2 | 4.123 | 16405.8 |
| 302 | 2025-04-16 12:17:40 | substances | 1 | 67641 | 2 | 5.750 | 11763.7 |
| 301 | 2025-04-02 05:41:03 | substances | 1 | 67641 | 2 | 5.736 | 11792.4 |
| 300 | 2025-03-29 00:38:51 | substances | 3 | 140603 | 34 | 31.123 | 4517.7 |
| 299 | 2025-03-23 05:48:09 | substances | 3 | 140603 | 34 | 28.343 | 4960.8 |
| 298 | 2025-03-21 10:07:59 | substances | 3 | 140603 | 34 | 27.863 | 5046.2 |
| 297 | 2025-03-20 12:28:39 | substances | 3 | 140603 | 34 | 23.816 | 5903.7 |
| 296 | 2025-03-20 00:38:06 | substances | 3 | 140603 | 34 | 20.533 | 6847.7 |
| 295 | 2025-03-18 10:31:39 | substances | 3 | 140603 | 34 | 36.093 | 3895.6 |
| 294 | 2025-03-18 10:31:39 | substances | 2 | 108824 | 5 | 14.030 | 7756.5 |
| 293 | 2025-03-18 10:31:31 | substances | 3 | 140603 | 34 | 16.423 | 8561.3 |
| 292 | 2025-03-18 10:30:20 | substances | 1 | 67641 | 2 | 3.250 | 20812.6 |
| 291 | 2025-02-25 14:07:19 | substances | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 290 | 2025-02-20 10:39:32 | substances | 2 | 108824 | 5 | 16.063 | 6774.8 |
| 289 | 2025-02-20 10:37:43 | substances | 1 | 67641 | 2 | 5.440 | 12434.0 |
| 288 | 2025-02-14 22:08:45 | substances | 3 | 140603 | 34 | 32.006 | 4393.0 |
| 287 | 2025-02-14 22:08:00 | substances | 1 | 67641 | 2 | 2.746 | 24632.6 |
| 286 | 2025-02-14 10:18:38 | substances | 3 | 140603 | 34 | 30.376 | 4628.8 |
| 285 | 2025-02-13 13:57:36 | substances | 2 | 108824 | 5 | 12.173 | 8939.8 |
| 284 | 2025-02-13 05:41:01 | substances | 3 | 140603 | 34 | 32.326 | 4349.5 |
| 283 | 2025-02-12 11:22:49 | substances | 2 | 108824 | 5 | 16.656 | 6533.6 |
| 282 | 2025-02-12 05:45:01 | substances | 3 | 140603 | 34 | 31.143 | 4514.8 |
| 281 | 2025-02-11 05:06:05 | substances | 3 | 140603 | 34 | 30.016 | 4684.3 |
| 280 | 2025-02-10 23:52:39 | substances | 3 | 140603 | 34 | 35.410 | 3970.7 |
| 279 | 2025-02-10 23:52:56 | substances | 2 | 108824 | 5 | 8.750 | 12437.0 |
| 278 | 2025-02-10 23:52:02 | substances | 3 | 140603 | 34 | 38.096 | 3690.8 |
| 277 | 2025-02-10 23:46:17 | substances | 1 | 67641 | 2 | 4.360 | 15514.0 |
| 276 | 2025-01-18 04:27:22 | substances | 2 | 108824 | 5 | 8.110 | 13418.5 |
| 275 | 2025-01-18 04:17:49 | substances | 1 | 67641 | 2 | 1.623 | 41676.5 |
| 274 | 2025-01-03 19:10:01 | substances | 2 | 108824 | 5 | 15.013 | 7248.7 |
| 273 | 2025-01-03 19:06:58 | substances | 1 | 67641 | 2 | 2.593 | 26086.0 |
| 272 | 2025-01-03 15:33:53 | substances | 3 | 140603 | 34 | 35.766 | 3931.2 |
| 271 | 2025-01-03 14:52:28 | substances | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 270 | 2025-01-03 06:40:49 | substances | 2 | 108824 | 5 | 23.346 | 4661.4 |
| 269 | 2025-01-03 06:40:38 | substances | 3 | 140603 | 34 | 33.236 | 4230.4 |
| 268 | 2025-01-03 06:37:01 | substances | 1 | 67641 | 2 | 4.720 | 14330.7 |
| 267 | 2025-01-03 06:35:34 | substances | 4 | 161450 | 229 | 64.156 | 2516.5 |
| 266 | 2025-01-02 06:12:27 | substances | 3 | 140603 | 34 | 28.846 | 4874.3 |
| 265 | 2025-01-01 17:52:14 | substances | 3 | 140603 | 34 | 39.436 | 3565.3 |
| 264 | 2025-01-01 17:52:11 | substances | 3 | 140603 | 34 | 32.470 | 4330.2 |
| 263 | 2024-12-31 17:16:58 | substances | 4 | 161450 | 229 | 59.486 | 2714.1 |
| 262 | 2024-12-31 17:17:02 | substances | 3 | 140603 | 34 | 43.503 | 3232.0 |