History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"quantity"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 442 | 2025-10-14 06:53:23 | quantity | 3 | 146162 | 64 | 6.606 | 22125.6 |
| 441 | 2025-10-12 14:41:50 | quantity | 1 | 82945 | 2 | 1.406 | 58993.6 |
| 440 | 2025-10-09 08:18:31 | quantity | 3 | 146162 | 64 | 6.423 | 22756.0 |
| 439 | 2025-10-02 23:37:19 | quantity | 3 | 146162 | 64 | 6.503 | 22476.1 |
| 438 | 2025-09-20 20:27:46 | quantity | 3 | 146162 | 64 | 7.576 | 19292.8 |
| 437 | 2025-09-15 09:06:12 | quantity | 2 | 121059 | 8 | 7.156 | 16917.1 |
| 436 | 2025-09-10 15:51:06 | quantity | 3 | 146162 | 64 | 6.623 | 22068.9 |
| 435 | 2025-09-09 16:28:09 | quantity | 1 | 82945 | 2 | 1.406 | 58993.6 |
| 434 | 2025-09-08 03:42:16 | quantity | 1 | 82945 | 2 | 1.233 | 67270.9 |
| 433 | 2025-08-27 21:44:27 | quantity | 1 | 82945 | 2 | 1.266 | 65517.4 |
| 432 | 2025-08-27 10:30:03 | quantity | 3 | 146162 | 64 | 7.046 | 20744.0 |
| 431 | 2025-08-25 01:25:24 | quantity | 1 | 82945 | 2 | 3.423 | 24231.7 |
| 430 | 2025-08-22 13:31:03 | quantity | 1 | 82945 | 2 | 1.406 | 58993.6 |
| 429 | 2025-08-17 15:49:33 | quantity | 2 | 121059 | 8 | 18.436 | 6566.4 |
| 428 | 2025-08-17 15:07:26 | quantity | 4 | 161609 | 553 | 48.300 | 3345.9 |
| 427 | 2025-08-15 00:13:38 | quantity | 1 | 82945 | 2 | 3.310 | 25058.9 |
| 426 | 2025-08-13 04:57:43 | quantity | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 425 | 2025-08-09 09:39:50 | quantity | 1 | 82945 | 2 | 7.986 | 10386.3 |
| 424 | 2025-08-01 14:08:03 | quantity | 1 | 82945 | 2 | 5.766 | 14385.2 |
| 423 | 2025-07-24 02:38:03 | quantity | 1 | 82945 | 2 | 6.313 | 13138.8 |
| 422 | 2025-07-22 23:13:21 | quantity | 1 | 82945 | 2 | 3.406 | 24352.6 |
| 421 | 2025-07-21 03:48:52 | quantity | 1 | 82945 | 2 | 1.923 | 43133.1 |
| 420 | 2025-07-10 14:44:52 | quantity | 1 | 82945 | 2 | 4.923 | 16848.5 |
| 419 | 2025-07-09 17:16:08 | quantity | 1 | 82945 | 2 | 1.360 | 60989.0 |
| 418 | 2025-07-08 04:21:46 | quantity | 1 | 82945 | 2 | 4.236 | 19581.0 |
| 417 | 2025-07-03 00:37:16 | quantity | 4 | 161609 | 553 | 83.393 | 1937.9 |
| 416 | 2025-07-02 17:46:11 | quantity | 4 | 161609 | 553 | 38.456 | 4202.4 |
| 415 | 2025-07-02 16:28:56 | quantity | 4 | 161609 | 553 | 49.906 | 3238.3 |
| 414 | 2025-07-02 11:20:21 | quantity | 4 | 161609 | 553 | 62.456 | 2587.6 |
| 413 | 2025-07-02 08:51:39 | quantity | 1 | 82945 | 2 | 6.296 | 13174.2 |
| 412 | 2025-07-02 05:11:05 | quantity | 4 | 161609 | 553 | 66.923 | 2414.8 |
| 411 | 2025-06-30 11:42:23 | quantity | 2 | 121059 | 8 | 9.423 | 12847.2 |
| 410 | 2025-06-30 08:55:41 | quantity | 4 | 161609 | 553 | 60.160 | 2686.3 |
| 409 | 2025-06-28 23:38:56 | quantity | 1 | 82945 | 2 | 6.153 | 13480.4 |
| 408 | 2025-06-15 07:42:18 | quantity | 3 | 146162 | 64 | 15.016 | 9733.8 |
| 407 | 2025-06-09 08:41:07 | quantity | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 406 | 2025-06-08 00:16:31 | quantity | 3 | 146162 | 64 | 44.173 | 3308.9 |
| 405 | 2025-06-06 10:34:27 | quantity | 3 | 146162 | 64 | 39.706 | 3681.1 |
| 404 | 2025-06-05 10:50:55 | quantity | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 403 | 2025-06-05 00:17:43 | quantity | 1 | 82945 | 2 | 6.296 | 13174.2 |
| 402 | 2025-06-01 16:30:13 | quantity | 4 | 161609 | 553 | 16.016 | 10090.5 |
| 401 | 2025-05-31 15:10:55 | quantity | 4 | 161609 | 553 | 61.096 | 2645.2 |
| 400 | 2025-05-31 02:47:01 | quantity | 4 | 161609 | 553 | 58.706 | 2752.9 |
| 399 | 2025-05-29 08:26:25 | quantity | 4 | 161609 | 553 | 47.156 | 3427.1 |
| 398 | 2025-05-26 17:48:18 | quantity | 4 | 161609 | 553 | 59.346 | 2723.2 |
| 397 | 2025-05-26 09:07:24 | quantity | 2 | 121059 | 8 | 20.440 | 5922.7 |
| 396 | 2025-05-26 06:33:22 | quantity | 3 | 146162 | 64 | 25.500 | 5731.8 |
| 395 | 2025-05-25 08:56:17 | quantity | 1 | 82945 | 2 | 2.703 | 30686.3 |
| 394 | 2025-05-24 00:16:51 | quantity | 1 | 82945 | 2 | 6.736 | 12313.7 |
| 393 | 2025-05-16 11:41:12 | quantity | 1 | 82945 | 2 | 6.670 | 12435.5 |
| 392 | 2025-05-11 07:44:31 | quantity | 3 | 146162 | 64 | 7.110 | 20557.2 |
| 391 | 2025-05-10 18:24:12 | quantity | 1 | 82945 | 2 | 9.580 | 8658.1 |
| 390 | 2025-05-05 21:51:00 | quantity | 3 | 146162 | 64 | 24.033 | 6081.7 |
| 389 | 2025-05-04 11:18:50 | quantity | 3 | 146162 | 64 | 45.863 | 3186.9 |
| 388 | 2025-05-03 02:52:27 | quantity | 3 | 146162 | 64 | 44.766 | 3265.0 |
| 387 | 2025-04-30 10:45:42 | quantity | 1 | 82945 | 2 | 3.716 | 22321.0 |
| 386 | 2025-04-27 23:52:24 | quantity | 1 | 82945 | 2 | 3.796 | 21850.6 |
| 385 | 2025-04-27 20:46:50 | quantity | 3 | 146162 | 64 | 39.080 | 3740.1 |
| 384 | 2025-04-25 07:27:48 | quantity | 1 | 82945 | 2 | 6.280 | 13207.8 |
| 383 | 2025-04-25 02:47:44 | quantity | 1 | 82945 | 2 | 1.360 | 60989.0 |
| 382 | 2025-04-20 12:10:32 | quantity | 1 | 82945 | 2 | 5.546 | 14955.8 |
| 381 | 2025-04-18 05:48:29 | quantity | 2 | 121059 | 8 | 12.750 | 9494.8 |
| 380 | 2025-04-17 23:00:35 | quantity | 3 | 146162 | 64 | 29.846 | 4897.2 |
| 379 | 2025-04-13 06:36:18 | quantity | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 378 | 2025-04-02 02:13:15 | quantity | 4 | 161609 | 553 | 81.880 | 1973.7 |
| 377 | 2025-03-31 11:37:33 | quantity | 4 | 161609 | 553 | 62.470 | 2587.0 |
| 376 | 2025-03-31 10:47:01 | quantity | 4 | 161609 | 553 | 80.860 | 1998.6 |
| 375 | 2025-03-29 18:06:26 | quantity | 4 | 161609 | 553 | 77.670 | 2080.7 |
| 374 | 2025-03-28 01:08:11 | quantity | 1 | 82945 | 2 | 1.220 | 67987.7 |
| 373 | 2025-03-26 21:50:50 | quantity | 2 | 121059 | 8 | 19.483 | 6213.6 |
| 372 | 2025-03-26 10:37:35 | quantity | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 371 | 2025-03-25 03:53:52 | quantity | 3 | 146162 | 64 | 23.066 | 6336.7 |
| 370 | 2025-03-23 22:50:11 | quantity | 2 | 121059 | 8 | 15.080 | 8027.8 |
| 369 | 2025-03-23 21:43:59 | quantity | 3 | 146162 | 64 | 44.910 | 3254.6 |
| 368 | 2025-03-22 08:19:23 | quantity | 1 | 82945 | 2 | 3.030 | 27374.6 |
| 367 | 2025-03-20 14:52:05 | quantity | 1 | 82945 | 2 | 4.983 | 16645.6 |
| 366 | 2025-03-20 11:56:51 | quantity | 1 | 82945 | 2 | 7.110 | 11666.0 |
| 365 | 2025-03-12 16:47:58 | quantity | 1 | 82945 | 2 | 7.250 | 11440.7 |
| 364 | 2025-02-23 01:12:03 | quantity | 1 | 82945 | 2 | 6.360 | 13041.7 |
| 363 | 2025-02-16 07:36:40 | quantity | 1 | 82945 | 2 | 8.046 | 10308.8 |
| 362 | 2025-02-10 17:28:38 | quantity | 1 | 82945 | 2 | 6.000 | 13824.2 |
| 361 | 2025-02-04 02:23:41 | quantity | 1 | 82945 | 2 | 9.516 | 8716.4 |
| 360 | 2025-01-24 20:53:38 | quantity | 1 | 82945 | 2 | 4.923 | 16848.5 |
| 359 | 2025-01-23 14:23:12 | quantity | 1 | 82945 | 2 | 5.593 | 14830.1 |
| 358 | 2025-01-09 15:28:43 | quantity | 1 | 82945 | 2 | 5.220 | 15889.8 |
| 357 | 2025-01-07 21:16:22 | quantity | 3 | 146162 | 64 | 33.563 | 4354.9 |
| 356 | 2025-01-04 14:25:47 | quantity | 2 | 121059 | 8 | 18.013 | 6720.6 |
| 355 | 2025-01-04 14:25:19 | quantity | 1 | 82945 | 2 | 2.970 | 27927.6 |
| 354 | 2025-01-01 21:35:10 | quantity | 2 | 121059 | 8 | 12.750 | 9494.8 |
| 353 | 2025-01-01 21:12:25 | quantity | 3 | 146162 | 64 | 6.280 | 23274.2 |
| 352 | 2024-12-31 17:47:56 | quantity | 3 | 146162 | 64 | 35.190 | 4153.5 |
| 351 | 2024-12-27 18:17:53 | quantity | 4 | 161609 | 553 | 26.906 | 6006.4 |
| 350 | 2024-12-27 15:42:12 | quantity | 3 | 146162 | 64 | 18.890 | 7737.5 |
| 349 | 2024-12-27 01:22:18 | quantity | 3 | 146162 | 64 | 46.750 | 3126.5 |
| 348 | 2024-12-26 12:57:08 | quantity | 4 | 161609 | 553 | 13.830 | 11685.4 |
| 347 | 2024-12-26 12:57:07 | quantity | 3 | 146162 | 64 | 7.546 | 19369.5 |
| 346 | 2024-12-26 12:57:06 | quantity | 2 | 121059 | 8 | 3.733 | 32429.4 |
| 345 | 2024-12-18 08:18:30 | quantity | 1 | 82945 | 2 | 4.346 | 19085.4 |
| 344 | 2024-12-16 23:42:09 | quantity | 1 | 82945 | 2 | 5.893 | 14075.2 |
| 343 | 2024-12-08 17:10:38 | quantity | 1 | 82945 | 2 | 7.706 | 10763.7 |