History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"truncating"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 450 | 2025-10-27 18:55:46 | truncating | 1 | 67641 | 1 | 1.143 | 59178.5 |
| 449 | 2025-09-27 23:06:55 | truncating | 4 | 161450 | 357 | 10.643 | 15169.6 |
| 448 | 2025-09-23 08:54:12 | truncating | 2 | 108824 | 3 | 3.153 | 34514.4 |
| 447 | 2025-09-23 08:53:25 | truncating | 4 | 161450 | 357 | 11.326 | 14254.8 |
| 446 | 2025-09-23 08:24:23 | truncating | 3 | 140603 | 45 | 6.330 | 22212.2 |
| 445 | 2025-09-12 19:32:16 | truncating | 3 | 140603 | 45 | 6.356 | 22121.3 |
| 444 | 2025-09-11 17:15:06 | truncating | 3 | 140603 | 45 | 6.830 | 20586.1 |
| 443 | 2025-09-11 06:05:08 | truncating | 2 | 108824 | 3 | 2.940 | 37015.0 |
| 442 | 2025-09-05 18:34:12 | truncating | 1 | 67641 | 1 | 2.360 | 28661.4 |
| 441 | 2025-08-21 08:15:14 | truncating | 1 | 67641 | 1 | 2.360 | 28661.4 |
| 440 | 2025-08-09 20:18:21 | truncating | 1 | 67641 | 1 | 2.970 | 22774.7 |
| 439 | 2025-07-26 18:52:48 | truncating | 1 | 67641 | 1 | 5.156 | 13118.9 |
| 438 | 2025-07-25 04:43:43 | truncating | 1 | 67641 | 1 | 5.046 | 13404.9 |
| 437 | 2025-07-23 07:04:28 | truncating | 1 | 67641 | 1 | 7.143 | 9469.6 |
| 436 | 2025-07-21 22:05:45 | truncating | 1 | 67641 | 1 | 1.203 | 56226.9 |
| 435 | 2025-07-18 18:20:44 | truncating | 1 | 67641 | 1 | 5.873 | 11517.3 |
| 434 | 2025-07-10 11:44:22 | truncating | 1 | 67641 | 1 | 3.826 | 17679.3 |
| 433 | 2025-07-08 22:00:25 | truncating | 1 | 67641 | 1 | 1.220 | 55443.4 |
| 432 | 2025-07-03 22:29:45 | truncating | 1 | 67641 | 1 | 6.956 | 9724.1 |
| 431 | 2025-06-29 11:25:19 | truncating | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 430 | 2025-06-25 04:11:25 | truncating | 1 | 67641 | 1 | 3.406 | 19859.4 |
| 429 | 2025-06-17 05:55:12 | truncating | 1 | 67641 | 1 | 1.110 | 60937.8 |
| 428 | 2025-06-16 05:43:36 | truncating | 1 | 67641 | 1 | 3.013 | 22449.7 |
| 427 | 2025-06-10 10:45:22 | truncating | 1 | 67641 | 1 | 3.953 | 17111.3 |
| 426 | 2025-06-06 22:40:20 | truncating | 4 | 161450 | 357 | 46.690 | 3457.9 |
| 425 | 2025-06-06 10:40:53 | truncating | 1 | 67641 | 1 | 6.436 | 10509.8 |
| 424 | 2025-06-06 07:46:45 | truncating | 1 | 67641 | 1 | 5.940 | 11387.4 |
| 423 | 2025-06-05 09:27:28 | truncating | 1 | 67641 | 1 | 5.376 | 12582.0 |
| 422 | 2025-06-04 20:29:34 | truncating | 4 | 161450 | 357 | 43.270 | 3731.2 |
| 421 | 2025-06-04 06:34:57 | truncating | 4 | 161450 | 357 | 73.113 | 2208.2 |
| 420 | 2025-06-04 06:00:20 | truncating | 4 | 161450 | 357 | 35.080 | 4602.3 |
| 419 | 2025-06-04 01:11:41 | truncating | 1 | 67641 | 1 | 5.640 | 11993.1 |
| 418 | 2025-06-02 16:25:33 | truncating | 4 | 161450 | 357 | 50.783 | 3179.2 |
| 417 | 2025-06-02 11:25:40 | truncating | 4 | 161450 | 357 | 65.216 | 2475.6 |
| 416 | 2025-06-01 22:06:44 | truncating | 4 | 161450 | 357 | 61.236 | 2636.5 |
| 415 | 2025-05-31 13:55:19 | truncating | 4 | 161450 | 357 | 58.266 | 2770.9 |
| 414 | 2025-05-28 16:17:32 | truncating | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 413 | 2025-05-14 07:07:04 | truncating | 1 | 67641 | 1 | 5.923 | 11420.1 |
| 412 | 2025-05-13 16:31:15 | truncating | 1 | 67641 | 1 | 1.000 | 67641.0 |
| 411 | 2025-05-08 04:11:39 | truncating | 1 | 67641 | 1 | 8.283 | 8166.2 |
| 410 | 2025-04-28 09:26:47 | truncating | 1 | 67641 | 1 | 5.530 | 12231.6 |
| 409 | 2025-04-23 10:56:11 | truncating | 1 | 67641 | 1 | 5.873 | 11517.3 |
| 408 | 2025-04-17 18:03:01 | truncating | 1 | 67641 | 1 | 1.106 | 61158.2 |
| 407 | 2025-04-10 04:45:43 | truncating | 1 | 67641 | 1 | 1.190 | 56841.2 |
| 406 | 2025-04-07 06:52:24 | truncating | 4 | 161450 | 357 | 53.406 | 3023.1 |
| 405 | 2025-04-06 05:22:25 | truncating | 1 | 67641 | 1 | 4.703 | 14382.5 |
| 404 | 2025-04-04 20:02:00 | truncating | 1 | 67641 | 1 | 3.080 | 21961.4 |
| 403 | 2025-04-02 21:13:39 | truncating | 4 | 161450 | 357 | 56.640 | 2850.5 |
| 402 | 2025-04-02 10:35:01 | truncating | 1 | 67641 | 1 | 7.860 | 8605.7 |
| 401 | 2025-04-02 03:43:06 | truncating | 1 | 67641 | 1 | 5.063 | 13359.9 |
| 400 | 2025-03-30 10:07:34 | truncating | 1 | 67641 | 1 | 2.063 | 32787.7 |
| 399 | 2025-03-28 11:08:13 | truncating | 1 | 67641 | 1 | 5.580 | 12122.0 |
| 398 | 2025-03-26 23:20:53 | truncating | 4 | 161450 | 357 | 48.596 | 3322.3 |
| 397 | 2025-03-25 18:02:01 | truncating | 4 | 161450 | 357 | 51.126 | 3157.9 |
| 396 | 2025-03-23 13:13:23 | truncating | 1 | 67641 | 1 | 5.673 | 11923.3 |
| 395 | 2025-03-23 08:27:20 | truncating | 4 | 161450 | 357 | 47.830 | 3375.5 |
| 394 | 2025-03-22 12:56:37 | truncating | 4 | 161450 | 357 | 54.693 | 2951.9 |
| 393 | 2025-03-22 07:01:58 | truncating | 4 | 161450 | 357 | 89.536 | 1803.2 |
| 392 | 2025-03-20 18:51:46 | truncating | 4 | 161450 | 357 | 59.893 | 2695.6 |
| 391 | 2025-03-03 13:44:24 | truncating | 3 | 140603 | 45 | 21.590 | 6512.4 |
| 390 | 2025-03-02 07:38:32 | truncating | 3 | 140603 | 45 | 38.830 | 3621.0 |
| 389 | 2025-03-02 07:38:32 | truncating | 2 | 108824 | 3 | 23.033 | 4724.7 |
| 388 | 2025-02-28 15:34:45 | truncating | 1 | 67641 | 1 | 5.123 | 13203.4 |
| 387 | 2025-02-26 09:28:34 | truncating | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 386 | 2025-02-22 08:12:18 | truncating | 1 | 67641 | 1 | 4.110 | 16457.7 |
| 385 | 2025-02-06 03:17:38 | truncating | 2 | 108824 | 3 | 11.046 | 9851.9 |
| 384 | 2025-01-31 15:40:46 | truncating | 2 | 108824 | 3 | 15.453 | 7042.3 |
| 383 | 2025-01-31 15:38:07 | truncating | 1 | 67641 | 1 | 5.016 | 13485.0 |
| 382 | 2025-01-29 21:50:26 | truncating | 3 | 140603 | 45 | 33.283 | 4224.5 |
| 381 | 2025-01-26 19:17:50 | truncating | 3 | 140603 | 45 | 37.940 | 3705.9 |
| 380 | 2025-01-26 19:17:55 | truncating | 3 | 140603 | 45 | 29.423 | 4778.7 |
| 379 | 2025-01-26 19:17:52 | truncating | 2 | 108824 | 3 | 13.610 | 7995.9 |
| 378 | 2025-01-26 18:07:26 | truncating | 1 | 67641 | 1 | 1.093 | 61885.6 |
| 377 | 2025-01-26 16:47:17 | truncating | 1 | 67641 | 1 | 3.783 | 17880.3 |
| 376 | 2025-01-23 01:03:50 | truncating | 1 | 67641 | 1 | 5.596 | 12087.4 |
| 375 | 2025-01-10 17:48:11 | truncating | 1 | 67641 | 1 | 3.016 | 22427.4 |
| 374 | 2024-12-27 18:29:18 | truncating | 1 | 67641 | 1 | 1.093 | 61885.6 |
| 373 | 2024-12-21 19:29:07 | truncating | 3 | 140603 | 45 | 34.230 | 4107.6 |
| 372 | 2024-12-19 14:11:53 | truncating | 3 | 140603 | 45 | 40.270 | 3491.5 |
| 371 | 2024-12-19 14:11:19 | truncating | 2 | 108824 | 3 | 18.970 | 5736.6 |
| 370 | 2024-12-19 14:11:12 | truncating | 3 | 140603 | 45 | 22.186 | 6337.5 |
| 369 | 2024-12-19 12:30:06 | truncating | 1 | 67641 | 1 | 1.076 | 62863.4 |
| 368 | 2024-12-18 10:27:14 | truncating | 3 | 140603 | 45 | 32.783 | 4288.9 |
| 367 | 2024-12-17 08:29:21 | truncating | 3 | 140603 | 45 | 42.220 | 3330.2 |
| 366 | 2024-12-17 02:24:49 | truncating | 3 | 140603 | 45 | 26.656 | 5274.7 |
| 365 | 2024-12-17 02:24:50 | truncating | 2 | 108824 | 3 | 14.423 | 7545.2 |
| 364 | 2024-12-17 02:22:59 | truncating | 1 | 67641 | 1 | 2.940 | 23007.1 |
| 363 | 2024-12-10 02:03:23 | truncating | 1 | 67641 | 1 | 2.626 | 25758.2 |
| 362 | 2024-11-13 03:28:57 | truncating | 3 | 140603 | 45 | 31.516 | 4461.3 |
| 361 | 2024-11-12 20:08:29 | truncating | 3 | 140603 | 45 | 43.130 | 3260.0 |
| 360 | 2024-11-12 17:22:58 | truncating | 3 | 140603 | 45 | 34.016 | 4133.4 |
| 359 | 2024-11-12 17:22:58 | truncating | 2 | 108824 | 3 | 8.720 | 12479.8 |
| 358 | 2024-11-12 17:00:27 | truncating | 4 | 161450 | 357 | 43.300 | 3728.6 |
| 357 | 2024-11-12 17:00:26 | truncating | 1 | 67641 | 1 | 5.190 | 13032.9 |
| 356 | 2024-11-12 13:18:21 | truncating | 2 | 108824 | 3 | 2.750 | 39572.4 |
| 355 | 2024-11-11 03:39:43 | truncating | 3 | 140603 | 45 | 14.093 | 9976.8 |
| 354 | 2024-11-11 02:40:02 | truncating | 2 | 108824 | 3 | 21.880 | 4973.7 |
| 353 | 2024-11-10 16:09:00 | truncating | 1 | 67641 | 1 | 1.000 | 67641.0 |
| 352 | 2024-11-05 06:42:27 | truncating | 1 | 67641 | 1 | 2.486 | 27208.8 |
| 351 | 2024-10-15 09:42:16 | truncating | 3 | 140603 | 45 | 34.170 | 4114.8 |