History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subtotally"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 468 | 2025-11-13 10:03:00 | subtotally | 5 | 173545 | 533 | 16.923 | 10255.0 |
| 467 | 2025-11-12 18:42:43 | subtotally | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 466 | 2025-10-25 07:56:25 | subtotally | 1 | 67641 | 1 | 1.233 | 54858.9 |
| 465 | 2025-10-25 03:31:36 | subtotally | 5 | 173545 | 533 | 42.626 | 4071.3 |
| 464 | 2025-10-23 13:58:54 | subtotally | 1 | 67641 | 1 | 1.080 | 62630.6 |
| 463 | 2025-10-22 21:18:37 | subtotally | 1 | 67641 | 1 | 4.190 | 16143.4 |
| 462 | 2025-10-03 12:29:37 | subtotally | 3 | 140603 | 13 | 6.186 | 22729.2 |
| 461 | 2025-09-24 17:57:41 | subtotally | 1 | 67641 | 1 | 1.093 | 61885.6 |
| 460 | 2025-09-18 15:15:11 | subtotally | 5 | 173545 | 533 | 18.343 | 9461.1 |
| 459 | 2025-09-18 09:17:16 | subtotally | 3 | 140603 | 13 | 5.503 | 25550.2 |
| 458 | 2025-09-18 03:33:16 | subtotally | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 457 | 2025-09-17 05:11:23 | subtotally | 4 | 161450 | 70 | 12.373 | 13048.6 |
| 456 | 2025-09-09 10:48:32 | subtotally | 2 | 108824 | 6 | 3.140 | 34657.3 |
| 455 | 2025-09-04 18:17:02 | subtotally | 1 | 67641 | 1 | 1.190 | 56841.2 |
| 454 | 2025-08-19 14:54:41 | subtotally | 3 | 140603 | 13 | 18.953 | 7418.5 |
| 453 | 2025-08-19 06:04:13 | subtotally | 2 | 108824 | 6 | 7.393 | 14719.9 |
| 452 | 2025-08-18 12:24:39 | subtotally | 1 | 67641 | 1 | 1.093 | 61885.6 |
| 451 | 2025-08-17 12:06:55 | subtotally | 1 | 67641 | 1 | 2.310 | 29281.8 |
| 450 | 2025-08-03 15:05:01 | subtotally | 1 | 67641 | 1 | 1.076 | 62863.4 |
| 449 | 2025-07-25 08:11:04 | subtotally | 1 | 67641 | 1 | 4.876 | 13872.2 |
| 448 | 2025-07-24 18:01:28 | subtotally | 1 | 67641 | 1 | 2.610 | 25916.1 |
| 447 | 2025-07-18 06:54:02 | subtotally | 1 | 67641 | 1 | 5.343 | 12659.7 |
| 446 | 2025-07-18 06:52:29 | subtotally | 1 | 67641 | 1 | 2.826 | 23935.2 |
| 445 | 2025-07-08 11:37:29 | subtotally | 1 | 67641 | 1 | 6.000 | 11273.5 |
| 444 | 2025-07-02 13:32:14 | subtotally | 1 | 67641 | 1 | 5.406 | 12512.2 |
| 443 | 2025-06-14 13:53:26 | subtotally | 1 | 67641 | 1 | 7.233 | 9351.7 |
| 442 | 2025-06-12 03:19:23 | subtotally | 2 | 108824 | 6 | 18.220 | 5972.8 |
| 441 | 2025-06-11 04:12:47 | subtotally | 3 | 140603 | 13 | 24.093 | 5835.8 |
| 440 | 2025-06-05 02:09:38 | subtotally | 3 | 140603 | 13 | 16.793 | 8372.7 |
| 439 | 2025-06-05 00:45:29 | subtotally | 2 | 108824 | 6 | 15.876 | 6854.6 |
| 438 | 2025-06-03 19:38:06 | subtotally | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 437 | 2025-05-22 13:24:56 | subtotally | 1 | 67641 | 1 | 5.576 | 12130.7 |
| 436 | 2025-04-19 05:03:25 | subtotally | 1 | 67641 | 1 | 1.216 | 55625.8 |
| 435 | 2025-04-19 02:00:33 | subtotally | 1 | 67641 | 1 | 1.236 | 54725.7 |
| 434 | 2025-04-18 10:29:37 | subtotally | 1 | 67641 | 1 | 7.836 | 8632.1 |
| 433 | 2025-04-14 16:10:08 | subtotally | 1 | 67641 | 1 | 2.893 | 23380.9 |
| 432 | 2025-04-14 12:59:38 | subtotally | 1 | 67641 | 1 | 3.826 | 17679.3 |
| 431 | 2025-04-06 14:20:13 | subtotally | 3 | 140603 | 13 | 41.093 | 3421.6 |
| 430 | 2025-04-06 14:18:54 | subtotally | 4 | 161450 | 70 | 68.843 | 2345.2 |
| 429 | 2025-03-30 14:39:14 | subtotally | 4 | 161450 | 70 | 30.863 | 5231.2 |
| 428 | 2025-03-26 18:03:44 | subtotally | 2 | 108824 | 6 | 13.080 | 8319.9 |
| 427 | 2025-03-26 16:28:06 | subtotally | 3 | 140603 | 13 | 27.973 | 5026.4 |
| 426 | 2025-03-26 14:41:30 | subtotally | 1 | 67641 | 1 | 5.343 | 12659.7 |
| 425 | 2025-03-26 07:30:50 | subtotally | 4 | 161450 | 70 | 66.346 | 2433.5 |
| 424 | 2025-03-26 00:30:11 | subtotally | 4 | 161450 | 70 | 45.346 | 3560.4 |
| 423 | 2025-03-24 10:07:45 | subtotally | 1 | 67641 | 1 | 4.063 | 16648.0 |
| 422 | 2025-03-24 09:41:02 | subtotally | 1 | 67641 | 1 | 5.563 | 12159.1 |
| 421 | 2025-03-10 01:33:18 | subtotally | 3 | 140603 | 13 | 20.940 | 6714.6 |
| 420 | 2025-02-23 19:54:20 | subtotally | 3 | 140603 | 13 | 32.890 | 4274.9 |
| 419 | 2025-02-20 05:19:59 | subtotally | 3 | 140603 | 13 | 31.826 | 4417.9 |
| 418 | 2025-02-20 05:19:58 | subtotally | 2 | 108824 | 6 | 15.856 | 6863.3 |
| 417 | 2025-02-20 05:18:59 | subtotally | 4 | 161450 | 70 | 49.310 | 3274.2 |
| 416 | 2025-02-20 05:14:36 | subtotally | 1 | 67641 | 1 | 3.156 | 21432.5 |
| 415 | 2025-02-20 00:15:30 | subtotally | 4 | 161450 | 70 | 56.426 | 2861.3 |
| 414 | 2025-02-19 14:05:18 | subtotally | 4 | 161450 | 70 | 65.556 | 2462.8 |
| 413 | 2025-02-18 13:16:34 | subtotally | 4 | 161450 | 70 | 104.646 | 1542.8 |
| 412 | 2025-02-18 13:16:32 | subtotally | 2 | 108824 | 6 | 25.686 | 4236.7 |
| 411 | 2025-01-27 01:35:07 | subtotally | 1 | 67641 | 1 | 2.016 | 33552.1 |
| 410 | 2025-01-22 16:25:15 | subtotally | 2 | 108824 | 6 | 14.190 | 7669.1 |
| 409 | 2025-01-22 01:24:15 | subtotally | 2 | 108824 | 6 | 14.733 | 7386.4 |
| 408 | 2025-01-22 01:22:31 | subtotally | 1 | 67641 | 1 | 3.530 | 19161.8 |
| 407 | 2025-01-19 18:54:12 | subtotally | 4 | 161450 | 70 | 41.690 | 3872.6 |
| 406 | 2025-01-19 10:34:08 | subtotally | 4 | 161450 | 70 | 49.316 | 3273.8 |
| 405 | 2025-01-19 08:26:28 | subtotally | 4 | 161450 | 70 | 36.643 | 4406.0 |
| 404 | 2025-01-19 08:26:19 | subtotally | 4 | 161450 | 70 | 36.690 | 4400.4 |
| 403 | 2025-01-19 08:24:32 | subtotally | 1 | 67641 | 1 | 2.516 | 26884.3 |
| 402 | 2025-01-16 16:12:47 | subtotally | 3 | 140603 | 13 | 29.160 | 4821.8 |
| 401 | 2025-01-16 16:12:44 | subtotally | 2 | 108824 | 6 | 14.046 | 7747.7 |
| 400 | 2025-01-16 14:13:28 | subtotally | 3 | 140603 | 13 | 32.673 | 4303.3 |
| 399 | 2025-01-16 00:34:03 | subtotally | 3 | 140603 | 13 | 35.630 | 3946.2 |
| 398 | 2025-01-14 00:26:40 | subtotally | 3 | 140603 | 13 | 34.406 | 4086.6 |
| 397 | 2024-12-26 11:50:05 | subtotally | 1 | 67641 | 1 | 3.450 | 19606.1 |
| 396 | 2024-12-26 06:53:42 | subtotally | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 395 | 2024-12-21 06:53:58 | subtotally | 3 | 140603 | 13 | 30.050 | 4679.0 |
| 394 | 2024-12-20 08:49:00 | subtotally | 2 | 108824 | 6 | 15.266 | 7128.5 |
| 393 | 2024-12-20 08:48:26 | subtotally | 3 | 140603 | 13 | 34.420 | 4084.9 |
| 392 | 2024-12-20 08:45:59 | subtotally | 1 | 67641 | 1 | 3.936 | 17185.2 |
| 391 | 2024-12-15 23:47:19 | subtotally | 3 | 140603 | 13 | 48.893 | 2875.7 |
| 390 | 2024-12-13 18:39:11 | subtotally | 3 | 140603 | 13 | 22.063 | 6372.8 |
| 389 | 2024-12-13 18:38:36 | subtotally | 2 | 108824 | 6 | 15.363 | 7083.5 |
| 388 | 2024-12-10 00:25:49 | subtotally | 3 | 140603 | 13 | 39.783 | 3534.2 |
| 387 | 2024-12-08 14:24:19 | subtotally | 4 | 161450 | 70 | 51.580 | 3130.1 |
| 386 | 2024-12-08 14:23:53 | subtotally | 4 | 161450 | 70 | 61.220 | 2637.2 |
| 385 | 2024-12-08 14:24:20 | subtotally | 3 | 140603 | 13 | 31.956 | 4399.9 |
| 384 | 2024-12-08 14:24:20 | subtotally | 2 | 108824 | 6 | 15.703 | 6930.1 |
| 383 | 2024-12-08 14:21:57 | subtotally | 1 | 67641 | 1 | 4.420 | 15303.4 |
| 382 | 2024-12-05 02:12:37 | subtotally | 3 | 140603 | 13 | 28.266 | 4974.3 |
| 381 | 2024-11-23 08:12:46 | subtotally | 2 | 108824 | 6 | 11.250 | 9673.2 |
| 380 | 2024-11-23 08:08:42 | subtotally | 1 | 67641 | 1 | 2.296 | 29460.4 |
| 379 | 2024-11-11 16:36:13 | subtotally | 3 | 140603 | 13 | 31.550 | 4456.5 |
| 378 | 2024-11-07 11:21:27 | subtotally | 1 | 67641 | 1 | 3.046 | 22206.5 |
| 377 | 2024-11-06 20:17:33 | subtotally | 4 | 161450 | 70 | 61.736 | 2615.2 |
| 376 | 2024-11-06 20:16:38 | subtotally | 3 | 140603 | 13 | 25.580 | 5496.6 |
| 375 | 2024-11-06 20:16:40 | subtotally | 2 | 108824 | 6 | 9.593 | 11344.1 |
| 374 | 2024-11-06 20:16:30 | subtotally | 1 | 67641 | 1 | 2.686 | 25182.8 |
| 373 | 2024-11-04 18:14:35 | subtotally | 2 | 108824 | 6 | 13.046 | 8341.6 |
| 372 | 2024-11-04 18:12:32 | subtotally | 1 | 67641 | 1 | 4.080 | 16578.7 |
| 371 | 2024-10-25 18:31:11 | subtotally | 4 | 161450 | 70 | 54.300 | 2973.3 |
| 370 | 2024-10-25 09:23:02 | subtotally | 4 | 161450 | 70 | 54.033 | 2988.0 |
| 369 | 2024-10-25 02:46:24 | subtotally | 1 | 67641 | 1 | 4.970 | 13609.9 |