History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"allspice"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 449 | 2025-10-26 13:08:43 | allspice | 2 | 121059 | 3 | 3.906 | 30993.1 |
| 448 | 2025-10-24 17:23:33 | allspice | 2 | 121059 | 3 | 3.563 | 33976.7 |
| 447 | 2025-10-24 16:25:55 | allspice | 4 | 161609 | 279 | 11.986 | 13483.1 |
| 446 | 2025-10-13 11:39:49 | allspice | 2 | 121059 | 3 | 3.703 | 32692.1 |
| 445 | 2025-10-09 12:13:51 | allspice | 3 | 146162 | 19 | 6.326 | 23105.0 |
| 444 | 2025-10-03 17:41:40 | allspice | 4 | 161609 | 279 | 13.156 | 12284.1 |
| 443 | 2025-09-21 19:50:43 | allspice | 1 | 82945 | 2 | 1.390 | 59672.7 |
| 442 | 2025-09-14 20:01:58 | allspice | 4 | 161609 | 279 | 14.500 | 11145.4 |
| 441 | 2025-09-14 13:43:26 | allspice | 3 | 146162 | 19 | 7.233 | 20207.7 |
| 440 | 2025-09-14 13:23:26 | allspice | 2 | 121059 | 3 | 3.686 | 32842.9 |
| 439 | 2025-09-14 10:06:44 | allspice | 4 | 161609 | 279 | 19.986 | 8086.1 |
| 438 | 2025-09-12 14:01:02 | allspice | 3 | 146162 | 19 | 7.216 | 20255.3 |
| 437 | 2025-08-25 17:01:23 | allspice | 1 | 82945 | 2 | 6.313 | 13138.8 |
| 436 | 2025-08-01 13:22:33 | allspice | 3 | 146162 | 19 | 34.580 | 4226.8 |
| 435 | 2025-07-31 10:18:19 | allspice | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 434 | 2025-07-31 09:42:37 | allspice | 3 | 146162 | 19 | 31.956 | 4573.9 |
| 433 | 2025-07-27 14:10:03 | allspice | 1 | 82945 | 2 | 4.186 | 19814.9 |
| 432 | 2025-07-27 09:29:40 | allspice | 3 | 146162 | 19 | 23.423 | 6240.1 |
| 431 | 2025-07-25 17:36:50 | allspice | 1 | 82945 | 2 | 2.783 | 29804.2 |
| 430 | 2025-07-21 12:15:51 | allspice | 2 | 121059 | 3 | 3.826 | 31641.1 |
| 429 | 2025-07-21 10:17:12 | allspice | 3 | 146162 | 19 | 7.453 | 19611.2 |
| 428 | 2025-07-21 08:15:28 | allspice | 1 | 82945 | 2 | 1.610 | 51518.6 |
| 427 | 2025-07-14 12:41:15 | allspice | 3 | 146162 | 19 | 40.313 | 3625.7 |
| 426 | 2025-07-07 08:15:43 | allspice | 1 | 82945 | 2 | 3.733 | 22219.4 |
| 425 | 2025-06-20 20:21:13 | allspice | 1 | 82945 | 2 | 7.076 | 11722.0 |
| 424 | 2025-06-06 17:42:47 | allspice | 2 | 121059 | 3 | 3.890 | 31120.6 |
| 423 | 2025-05-29 06:57:08 | allspice | 1 | 82945 | 2 | 3.310 | 25058.9 |
| 422 | 2025-05-28 21:23:47 | allspice | 2 | 121059 | 3 | 19.296 | 6273.8 |
| 421 | 2025-05-27 03:22:47 | allspice | 1 | 82945 | 2 | 7.296 | 11368.6 |
| 420 | 2025-05-13 14:43:23 | allspice | 2 | 121059 | 3 | 6.656 | 18188.0 |
| 419 | 2025-05-13 01:31:08 | allspice | 1 | 82945 | 2 | 6.343 | 13076.6 |
| 418 | 2025-05-12 19:45:19 | allspice | 1 | 82945 | 2 | 1.330 | 62364.7 |
| 417 | 2025-05-08 23:52:35 | allspice | 1 | 82945 | 2 | 2.390 | 34705.0 |
| 416 | 2025-05-07 05:25:59 | allspice | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 415 | 2025-05-04 11:29:06 | allspice | 1 | 82945 | 2 | 3.626 | 22875.1 |
| 414 | 2025-04-23 15:17:56 | allspice | 1 | 82945 | 2 | 6.466 | 12827.9 |
| 413 | 2025-04-17 02:46:08 | allspice | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 412 | 2025-04-02 11:30:25 | allspice | 1 | 82945 | 2 | 6.706 | 12368.8 |
| 411 | 2025-03-24 21:17:20 | allspice | 3 | 146162 | 19 | 50.080 | 2918.6 |
| 410 | 2025-03-23 07:40:05 | allspice | 2 | 121059 | 3 | 13.470 | 8987.3 |
| 409 | 2025-03-23 01:43:22 | allspice | 3 | 146162 | 19 | 32.580 | 4486.2 |
| 408 | 2025-03-22 15:43:49 | allspice | 1 | 82945 | 2 | 1.516 | 54713.1 |
| 407 | 2025-03-19 09:27:25 | allspice | 1 | 82945 | 2 | 1.390 | 59672.7 |
| 406 | 2025-03-16 08:06:16 | allspice | 1 | 82945 | 2 | 6.470 | 12819.9 |
| 405 | 2025-02-26 14:41:37 | allspice | 3 | 146162 | 19 | 34.096 | 4286.8 |
| 404 | 2025-02-26 14:41:36 | allspice | 2 | 121059 | 3 | 21.860 | 5537.9 |
| 403 | 2025-02-26 14:41:19 | allspice | 1 | 82945 | 2 | 5.093 | 16286.1 |
| 402 | 2025-02-12 14:43:50 | allspice | 1 | 82945 | 2 | 9.156 | 9059.1 |
| 401 | 2025-02-12 08:39:29 | allspice | 1 | 82945 | 2 | 5.936 | 13973.2 |
| 400 | 2025-02-10 12:28:27 | allspice | 1 | 82945 | 2 | 6.453 | 12853.7 |
| 399 | 2025-02-07 12:31:07 | allspice | 1 | 82945 | 2 | 8.753 | 9476.2 |
| 398 | 2025-01-24 23:50:06 | allspice | 3 | 146162 | 19 | 36.300 | 4026.5 |
| 397 | 2025-01-23 15:59:31 | allspice | 3 | 146162 | 19 | 37.000 | 3950.3 |
| 396 | 2025-01-20 08:22:16 | allspice | 1 | 82945 | 2 | 3.466 | 23931.0 |
| 395 | 2025-01-12 03:39:53 | allspice | 2 | 121059 | 3 | 9.093 | 13313.4 |
| 394 | 2025-01-12 03:39:17 | allspice | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 393 | 2025-01-06 14:55:00 | allspice | 3 | 146162 | 19 | 40.770 | 3585.0 |
| 392 | 2025-01-05 21:35:20 | allspice | 1 | 82945 | 2 | 7.016 | 11822.3 |
| 391 | 2025-01-05 21:22:38 | allspice | 3 | 146162 | 19 | 7.686 | 19016.7 |
| 390 | 2025-01-05 21:22:37 | allspice | 2 | 121059 | 3 | 4.173 | 29010.1 |
| 389 | 2025-01-05 13:26:44 | allspice | 3 | 146162 | 19 | 29.570 | 4942.9 |
| 388 | 2025-01-05 13:26:47 | allspice | 2 | 121059 | 3 | 18.143 | 6672.5 |
| 387 | 2025-01-05 13:26:31 | allspice | 1 | 82945 | 2 | 3.300 | 25134.8 |
| 386 | 2024-12-30 21:45:31 | allspice | 2 | 121059 | 3 | 5.186 | 23343.4 |
| 385 | 2024-12-16 06:50:37 | allspice | 1 | 82945 | 2 | 3.593 | 23085.2 |
| 384 | 2024-12-11 09:24:18 | allspice | 3 | 146162 | 19 | 34.000 | 4298.9 |
| 383 | 2024-12-10 05:26:26 | allspice | 3 | 146162 | 19 | 30.953 | 4722.1 |
| 382 | 2024-12-09 00:42:20 | allspice | 4 | 161609 | 279 | 60.113 | 2688.4 |
| 381 | 2024-12-08 21:37:54 | allspice | 4 | 161609 | 279 | 41.690 | 3876.4 |
| 380 | 2024-12-07 13:19:25 | allspice | 4 | 161609 | 279 | 60.753 | 2660.1 |
| 379 | 2024-12-07 13:19:27 | allspice | 3 | 146162 | 19 | 18.533 | 7886.6 |
| 378 | 2024-12-07 13:18:45 | allspice | 2 | 121059 | 3 | 9.373 | 12915.7 |
| 377 | 2024-12-06 18:54:30 | allspice | 1 | 82945 | 2 | 4.096 | 20250.2 |
| 376 | 2024-12-02 05:42:32 | allspice | 2 | 121059 | 3 | 26.766 | 4522.9 |
| 375 | 2024-11-29 09:35:00 | allspice | 1 | 82945 | 2 | 10.313 | 8042.8 |
| 374 | 2024-11-28 18:35:41 | allspice | 2 | 121059 | 3 | 10.953 | 11052.6 |
| 373 | 2024-11-25 03:42:22 | allspice | 2 | 121059 | 3 | 17.173 | 7049.4 |
| 372 | 2024-11-25 03:42:21 | allspice | 1 | 82945 | 2 | 6.376 | 13008.9 |
| 371 | 2024-11-03 23:19:08 | allspice | 2 | 121059 | 3 | 8.763 | 13814.8 |
| 370 | 2024-11-03 23:18:56 | allspice | 3 | 146162 | 19 | 7.643 | 19123.6 |
| 369 | 2024-11-02 09:40:52 | allspice | 1 | 82945 | 2 | 3.750 | 22118.7 |
| 368 | 2024-11-01 19:28:15 | allspice | 1 | 82945 | 2 | 10.720 | 7737.4 |
| 367 | 2024-10-31 02:20:20 | allspice | 3 | 146162 | 19 | 7.110 | 20557.2 |
| 366 | 2024-10-30 12:08:39 | allspice | 3 | 146162 | 19 | 32.590 | 4484.9 |
| 365 | 2024-10-30 09:45:54 | allspice | 3 | 146162 | 19 | 35.590 | 4106.8 |
| 364 | 2024-10-28 09:41:28 | allspice | 3 | 146162 | 19 | 36.406 | 4014.8 |
| 363 | 2024-10-28 09:25:01 | allspice | 2 | 121059 | 3 | 3.610 | 33534.3 |
| 362 | 2024-10-28 09:24:46 | allspice | 3 | 146162 | 19 | 7.233 | 20207.7 |
| 361 | 2024-10-26 10:38:49 | allspice | 3 | 146162 | 19 | 39.796 | 3672.8 |
| 360 | 2024-10-17 05:04:44 | allspice | 2 | 121059 | 3 | 21.706 | 5577.2 |
| 359 | 2024-10-06 03:02:00 | allspice | 1 | 82945 | 2 | 14.016 | 5917.9 |
| 358 | 2024-10-02 00:16:36 | allspice | 1 | 82945 | 2 | 9.186 | 9029.5 |
| 357 | 2024-09-30 01:13:57 | allspice | 1 | 82945 | 2 | 7.486 | 11080.0 |
| 356 | 2024-09-28 01:11:40 | allspice | 3 | 146162 | 19 | 35.003 | 4175.7 |
| 355 | 2024-09-27 03:35:01 | allspice | 3 | 146162 | 19 | 55.550 | 2631.2 |
| 354 | 2024-09-25 13:47:42 | allspice | 2 | 121059 | 3 | 15.970 | 7580.4 |
| 353 | 2024-09-25 12:43:14 | allspice | 4 | 161609 | 279 | 132.400 | 1220.6 |
| 352 | 2024-09-25 12:43:17 | allspice | 3 | 146162 | 19 | 89.973 | 1624.5 |
| 351 | 2024-09-25 12:43:14 | allspice | 2 | 121059 | 3 | 42.953 | 2818.4 |
| 350 | 2024-09-16 07:54:57 | allspice | 1 | 82945 | 2 | 12.473 | 6650.0 |