History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substance"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 396 | 2025-12-27 13:06:39 | substance | 2 | 121436 | 5 | 3.610 | 33638.8 |
| 395 | 2025-12-18 20:34:12 | substance | 1 | 81242 | 2 | 3.500 | 23212.0 |
| 394 | 2025-12-17 08:41:57 | substance | 1 | 81242 | 2 | 2.733 | 29726.3 |
| 393 | 2025-12-14 15:00:50 | substance | 1 | 81242 | 2 | 1.330 | 61084.2 |
| 392 | 2025-12-13 13:46:26 | substance | 4 | 165329 | 247 | 14.596 | 11327.0 |
| 391 | 2025-12-13 00:34:23 | substance | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 390 | 2025-12-12 11:17:33 | substance | 4 | 165329 | 247 | 13.233 | 12493.7 |
| 389 | 2025-12-12 08:49:27 | substance | 4 | 165329 | 247 | 18.596 | 8890.6 |
| 388 | 2025-12-12 04:37:18 | substance | 4 | 165329 | 247 | 22.843 | 7237.6 |
| 387 | 2025-12-12 03:39:48 | substance | 4 | 165329 | 247 | 18.780 | 8803.5 |
| 386 | 2025-12-10 12:05:09 | substance | 4 | 165329 | 247 | 12.830 | 12886.1 |
| 385 | 2025-12-04 21:12:40 | substance | 1 | 81242 | 2 | 1.500 | 54161.3 |
| 384 | 2025-12-01 16:24:44 | substance | 1 | 81242 | 2 | 2.283 | 35585.6 |
| 383 | 2025-11-29 03:24:35 | substance | 3 | 148641 | 33 | 8.016 | 18543.0 |
| 382 | 2025-11-23 16:49:36 | substance | 1 | 81242 | 2 | 1.250 | 64993.6 |
| 381 | 2025-11-07 10:57:01 | substance | 4 | 165329 | 247 | 12.546 | 13177.8 |
| 380 | 2025-10-30 19:13:47 | substance | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 379 | 2025-10-30 00:49:52 | substance | 1 | 81242 | 2 | 1.483 | 54782.2 |
| 378 | 2025-10-24 01:38:50 | substance | 4 | 165329 | 247 | 11.830 | 13975.4 |
| 377 | 2025-10-23 22:06:07 | substance | 1 | 81242 | 2 | 1.343 | 60492.9 |
| 376 | 2025-10-20 04:44:33 | substance | 1 | 81242 | 2 | 1.500 | 54161.3 |
| 375 | 2025-10-19 00:28:20 | substance | 4 | 165329 | 247 | 13.406 | 12332.5 |
| 374 | 2025-10-14 15:15:54 | substance | 2 | 121436 | 5 | 3.093 | 39261.6 |
| 373 | 2025-10-12 09:57:23 | substance | 4 | 165329 | 247 | 11.593 | 14261.1 |
| 372 | 2025-10-03 23:49:48 | substance | 3 | 148641 | 33 | 6.390 | 23261.5 |
| 371 | 2025-09-24 02:56:57 | substance | 3 | 148641 | 33 | 8.813 | 16866.1 |
| 370 | 2025-09-09 05:19:55 | substance | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 369 | 2025-09-08 22:11:06 | substance | 1 | 81242 | 2 | 1.283 | 63321.9 |
| 368 | 2025-08-29 20:50:41 | substance | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 367 | 2025-08-09 19:03:03 | substance | 1 | 81242 | 2 | 8.283 | 9808.3 |
| 366 | 2025-07-25 16:28:10 | substance | 1 | 81242 | 2 | 3.576 | 22718.7 |
| 365 | 2025-07-24 03:01:03 | substance | 1 | 81242 | 2 | 6.436 | 12623.1 |
| 364 | 2025-07-10 17:45:22 | substance | 3 | 148641 | 33 | 28.343 | 5244.4 |
| 363 | 2025-07-09 22:36:36 | substance | 1 | 81242 | 2 | 5.423 | 14981.0 |
| 362 | 2025-07-08 02:59:53 | substance | 3 | 148641 | 33 | 56.410 | 2635.0 |
| 361 | 2025-07-06 23:15:20 | substance | 1 | 81242 | 2 | 3.390 | 23965.2 |
| 360 | 2025-07-05 12:02:45 | substance | 4 | 165329 | 247 | 47.986 | 3445.4 |
| 359 | 2025-07-05 05:22:19 | substance | 3 | 148641 | 33 | 28.563 | 5204.0 |
| 358 | 2025-07-02 00:13:30 | substance | 4 | 165329 | 247 | 38.240 | 4323.5 |
| 357 | 2025-06-30 23:33:07 | substance | 2 | 121436 | 5 | 3.140 | 38673.9 |
| 356 | 2025-06-30 22:36:14 | substance | 4 | 165329 | 247 | 19.440 | 8504.6 |
| 355 | 2025-06-29 19:18:05 | substance | 3 | 148641 | 33 | 6.876 | 21617.4 |
| 354 | 2025-06-26 17:44:43 | substance | 1 | 81242 | 2 | 8.703 | 9334.9 |
| 353 | 2025-06-21 12:08:24 | substance | 1 | 81242 | 2 | 1.263 | 64324.6 |
| 352 | 2025-06-12 07:09:02 | substance | 3 | 148641 | 33 | 33.513 | 4435.3 |
| 351 | 2025-05-31 10:39:41 | substance | 3 | 148641 | 33 | 38.050 | 3906.5 |
| 350 | 2025-05-31 06:21:32 | substance | 1 | 81242 | 2 | 6.643 | 12229.7 |
| 349 | 2025-05-28 07:31:49 | substance | 1 | 81242 | 2 | 1.500 | 54161.3 |
| 348 | 2025-05-23 22:22:11 | substance | 1 | 81242 | 2 | 5.750 | 14129.0 |
| 347 | 2025-05-20 02:41:38 | substance | 1 | 81242 | 2 | 3.703 | 21939.5 |
| 346 | 2025-05-19 22:21:40 | substance | 1 | 81242 | 2 | 3.813 | 21306.6 |
| 345 | 2025-05-15 07:08:52 | substance | 1 | 81242 | 2 | 1.310 | 62016.8 |
| 344 | 2025-05-02 03:07:53 | substance | 1 | 81242 | 2 | 5.390 | 15072.7 |
| 343 | 2025-04-25 23:37:32 | substance | 2 | 121436 | 5 | 9.796 | 12396.5 |
| 342 | 2025-04-25 19:01:58 | substance | 3 | 148641 | 33 | 63.613 | 2336.6 |
| 341 | 2025-04-25 16:27:24 | substance | 1 | 81242 | 2 | 3.640 | 22319.2 |
| 340 | 2025-04-23 00:38:40 | substance | 1 | 81242 | 2 | 4.190 | 19389.5 |
| 339 | 2025-04-19 21:35:38 | substance | 1 | 81242 | 2 | 3.830 | 21212.0 |
| 338 | 2025-04-19 18:49:21 | substance | 1 | 81242 | 2 | 1.483 | 54782.2 |
| 337 | 2025-04-15 21:53:08 | substance | 1 | 81242 | 2 | 7.266 | 11181.1 |
| 336 | 2025-04-09 16:41:22 | substance | 1 | 81242 | 2 | 8.843 | 9187.2 |
| 335 | 2025-04-03 02:12:51 | substance | 1 | 81242 | 2 | 1.766 | 46003.4 |
| 334 | 2025-03-24 00:33:09 | substance | 2 | 121436 | 5 | 12.953 | 9375.1 |
| 333 | 2025-03-23 20:05:14 | substance | 3 | 148641 | 33 | 38.573 | 3853.5 |
| 332 | 2025-03-22 18:42:22 | substance | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 331 | 2025-03-18 10:31:01 | substance | 1 | 81242 | 2 | 5.843 | 13904.2 |
| 330 | 2025-02-11 10:15:05 | substance | 1 | 81242 | 2 | 7.313 | 11109.3 |
| 329 | 2025-02-10 02:16:02 | substance | 1 | 81242 | 2 | 8.206 | 9900.3 |
| 328 | 2025-02-05 18:24:58 | substance | 1 | 81242 | 2 | 5.390 | 15072.7 |
| 327 | 2025-01-26 20:32:16 | substance | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 326 | 2025-01-25 12:33:23 | substance | 1 | 81242 | 2 | 11.440 | 7101.6 |
| 325 | 2025-01-09 17:09:09 | substance | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 324 | 2025-01-03 19:09:05 | substance | 3 | 148641 | 33 | 41.173 | 3610.2 |
| 323 | 2025-01-03 19:09:01 | substance | 2 | 121436 | 5 | 24.093 | 5040.3 |
| 322 | 2025-01-03 19:06:30 | substance | 1 | 81242 | 2 | 5.486 | 14809.0 |
| 321 | 2025-01-03 15:33:48 | substance | 3 | 148641 | 33 | 44.723 | 3323.6 |
| 320 | 2025-01-03 15:33:51 | substance | 3 | 148641 | 33 | 35.766 | 4155.9 |
| 319 | 2025-01-03 14:52:31 | substance | 1 | 81242 | 2 | 1.280 | 63470.3 |
| 318 | 2025-01-03 11:31:42 | substance | 3 | 148641 | 33 | 40.126 | 3704.4 |
| 317 | 2025-01-03 06:37:53 | substance | 3 | 148641 | 33 | 45.580 | 3261.1 |
| 316 | 2025-01-03 06:37:44 | substance | 4 | 165329 | 247 | 49.440 | 3344.0 |
| 315 | 2025-01-03 06:37:50 | substance | 2 | 121436 | 5 | 17.533 | 6926.1 |
| 314 | 2024-12-14 03:42:27 | substance | 1 | 81242 | 2 | 3.156 | 25742.1 |
| 313 | 2024-12-06 17:30:22 | substance | 1 | 81242 | 2 | 3.813 | 21306.6 |
| 312 | 2024-12-02 15:29:15 | substance | 1 | 81242 | 2 | 9.750 | 8332.5 |
| 311 | 2024-11-25 09:17:43 | substance | 1 | 81242 | 2 | 2.936 | 27671.0 |
| 310 | 2024-11-08 03:41:30 | substance | 1 | 81242 | 2 | 1.250 | 64993.6 |
| 309 | 2024-11-07 09:35:57 | substance | 3 | 148641 | 33 | 24.470 | 6074.4 |
| 308 | 2024-11-03 13:16:42 | substance | 2 | 121436 | 5 | 17.483 | 6945.9 |
| 307 | 2024-11-03 13:09:11 | substance | 1 | 81242 | 2 | 10.096 | 8046.9 |
| 306 | 2024-11-02 10:54:38 | substance | 3 | 148641 | 33 | 36.596 | 4061.7 |
| 305 | 2024-11-02 09:15:42 | substance | 3 | 148641 | 33 | 35.220 | 4220.4 |
| 304 | 2024-11-02 09:15:24 | substance | 3 | 148641 | 33 | 35.660 | 4168.3 |
| 303 | 2024-11-02 09:15:28 | substance | 2 | 121436 | 5 | 26.660 | 4555.0 |
| 302 | 2024-11-02 09:15:02 | substance | 1 | 81242 | 2 | 3.453 | 23527.9 |
| 301 | 2024-10-24 13:14:29 | substance | 1 | 81242 | 2 | 8.280 | 9811.8 |
| 300 | 2024-10-08 08:36:13 | substance | 1 | 81242 | 2 | 12.940 | 6278.4 |
| 299 | 2024-09-23 12:06:31 | substance | 3 | 148641 | 33 | 41.833 | 3553.2 |
| 298 | 2024-09-20 21:32:55 | substance | 2 | 121436 | 5 | 24.936 | 4869.9 |
| 297 | 2024-09-20 21:31:59 | substance | 1 | 81242 | 2 | 5.033 | 16141.9 |