History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spense"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 455 | 2024-12-21 19:53:52 | spense | 1 | 48755 | 5 | 1.296 | 37619.6 |
| 454 | 2024-12-05 16:39:06 | spense | 3 | 112716 | 708 | 13.546 | 8321.0 |
| 453 | 2024-12-05 11:59:07 | spense | 3 | 112716 | 708 | 33.660 | 3348.7 |
| 452 | 2024-12-04 21:26:47 | spense | 1 | 48755 | 5 | 2.250 | 21668.9 |
| 451 | 2024-12-04 19:25:48 | spense | 2 | 82551 | 59 | 14.736 | 5602.0 |
| 450 | 2024-12-04 09:37:12 | spense | 3 | 112716 | 708 | 20.830 | 5411.2 |
| 449 | 2024-12-04 05:36:48 | spense | 2 | 82551 | 59 | 17.500 | 4717.2 |
| 448 | 2024-12-04 05:36:41 | spense | 3 | 112716 | 708 | 20.080 | 5613.3 |
| 447 | 2024-12-04 05:34:29 | spense | 1 | 48755 | 5 | 2.376 | 20519.8 |
| 446 | 2024-11-27 06:05:06 | spense | 1 | 48755 | 5 | 5.720 | 8523.6 |
| 445 | 2024-11-09 03:26:23 | spense | 1 | 48755 | 5 | 3.966 | 12293.2 |
| 444 | 2024-11-03 19:57:46 | spense | 1 | 48755 | 5 | 6.173 | 7898.1 |
| 443 | 2024-11-03 14:03:53 | spense | 1 | 48755 | 5 | 2.140 | 22782.7 |
| 442 | 2024-10-27 12:17:53 | spense | 2 | 82551 | 59 | 8.610 | 9587.8 |
| 441 | 2024-10-27 12:17:48 | spense | 1 | 48755 | 5 | 4.233 | 11517.8 |
| 440 | 2024-10-09 13:36:54 | spense | 1 | 48755 | 5 | 2.156 | 22613.6 |
| 439 | 2024-10-08 06:08:37 | spense | 3 | 112716 | 708 | 29.203 | 3859.7 |
| 438 | 2024-10-08 06:06:04 | spense | 3 | 112716 | 708 | 38.483 | 2929.0 |
| 437 | 2024-10-04 14:25:57 | spense | 2 | 82551 | 59 | 3.093 | 26689.6 |
| 436 | 2024-10-04 13:21:22 | spense | 3 | 112716 | 708 | 41.470 | 2718.0 |
| 435 | 2024-10-04 07:39:55 | spense | 3 | 112716 | 708 | 41.890 | 2690.8 |
| 434 | 2024-10-03 06:51:32 | spense | 1 | 48755 | 5 | 5.936 | 8213.4 |
| 433 | 2024-10-02 16:38:29 | spense | 2 | 82551 | 59 | 19.606 | 4210.5 |
| 432 | 2024-10-02 03:51:05 | spense | 2 | 82551 | 59 | 32.796 | 2517.1 |
| 431 | 2024-10-02 03:50:50 | spense | 3 | 112716 | 708 | 42.533 | 2650.1 |
| 430 | 2024-10-02 03:49:37 | spense | 1 | 48755 | 5 | 6.903 | 7062.9 |
| 429 | 2024-09-25 17:22:41 | spense | 1 | 48755 | 5 | 9.466 | 5150.5 |
| 428 | 2024-09-09 02:49:44 | spense | 1 | 48755 | 5 | 6.466 | 7540.2 |
| 427 | 2024-09-01 12:28:30 | spense | 2 | 82551 | 59 | 17.593 | 4692.3 |
| 426 | 2024-09-01 12:28:05 | spense | 1 | 48755 | 5 | 3.016 | 16165.5 |
| 425 | 2024-09-01 04:58:43 | spense | 1 | 48755 | 5 | 6.483 | 7520.4 |
| 424 | 2024-08-31 13:01:18 | spense | 3 | 112716 | 708 | 68.066 | 1656.0 |
| 423 | 2024-08-30 09:52:19 | spense | 2 | 82551 | 59 | 9.080 | 9091.5 |
| 422 | 2024-08-30 08:42:15 | spense | 3 | 112716 | 708 | 63.130 | 1785.5 |
| 421 | 2024-08-30 04:17:20 | spense | 3 | 112716 | 708 | 59.660 | 1889.3 |
| 420 | 2024-08-30 04:17:02 | spense | 2 | 82551 | 59 | 20.363 | 4054.0 |
| 419 | 2024-08-30 02:45:18 | spense | 3 | 112716 | 708 | 49.500 | 2277.1 |
| 418 | 2024-08-29 22:23:27 | spense | 3 | 112716 | 708 | 48.376 | 2330.0 |
| 417 | 2024-08-29 22:23:28 | spense | 2 | 82551 | 59 | 27.313 | 3022.4 |
| 416 | 2024-08-29 22:23:18 | spense | 1 | 48755 | 5 | 8.373 | 5822.9 |
| 415 | 2024-08-26 14:51:09 | spense | 1 | 48755 | 5 | 3.203 | 15221.7 |
| 414 | 2024-08-14 05:12:58 | spense | 1 | 48755 | 5 | 7.720 | 6315.4 |
| 413 | 2024-08-09 15:59:15 | spense | 1 | 48755 | 5 | 1.660 | 29370.5 |
| 412 | 2024-08-07 20:04:02 | spense | 1 | 48755 | 5 | 1.296 | 37619.6 |
| 411 | 2024-08-04 06:36:00 | spense | 1 | 48755 | 5 | 3.486 | 13985.9 |
| 410 | 2024-07-31 02:40:58 | spense | 1 | 48755 | 5 | 4.923 | 9903.5 |
| 409 | 2024-07-30 23:26:49 | spense | 1 | 48755 | 5 | 4.250 | 11471.8 |
| 408 | 2024-07-27 07:44:42 | spense | 1 | 48755 | 5 | 2.953 | 16510.3 |
| 407 | 2024-07-10 10:38:59 | spense | 1 | 48755 | 5 | 3.060 | 15933.0 |
| 406 | 2024-06-30 23:28:32 | spense | 1 | 48755 | 5 | 4.406 | 11065.6 |
| 405 | 2024-06-30 11:19:21 | spense | 1 | 48755 | 5 | 3.500 | 13930.0 |
| 404 | 2024-06-20 05:23:18 | spense | 1 | 48755 | 5 | 1.750 | 27860.0 |
| 403 | 2024-06-12 13:32:31 | spense | 1 | 48755 | 5 | 2.063 | 23633.1 |
| 402 | 2024-06-03 05:19:11 | spense | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 401 | 2024-05-27 13:47:42 | spense | 3 | 112716 | 708 | 7.623 | 14786.3 |
| 400 | 2024-05-27 13:47:41 | spense | 2 | 82551 | 59 | 5.000 | 16510.2 |
| 399 | 2024-05-27 13:47:41 | spense | 1 | 48755 | 5 | 0.983 | 49598.2 |
| 398 | 2024-05-09 02:03:09 | spense | 1 | 48755 | 5 | 1.656 | 29441.4 |
| 397 | 2024-04-30 03:36:14 | spense | 1 | 48755 | 5 | 1.063 | 45865.5 |
| 396 | 2024-04-28 18:00:14 | spense | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 395 | 2024-04-28 05:05:05 | spense | 1 | 48755 | 5 | 1.936 | 25183.4 |
| 394 | 2024-04-27 01:28:37 | spense | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 393 | 2024-04-22 05:30:37 | spense | 1 | 48755 | 5 | 0.966 | 50471.0 |
| 392 | 2024-04-06 02:17:37 | spense | 3 | 112716 | 708 | 7.250 | 15547.0 |
| 391 | 2024-04-06 02:17:31 | spense | 2 | 82551 | 59 | 5.063 | 16304.8 |
| 390 | 2024-04-06 02:17:11 | spense | 1 | 48755 | 5 | 2.596 | 18780.8 |
| 389 | 2024-03-06 23:58:01 | spense | 1 | 48755 | 5 | 1.936 | 25183.4 |
| 388 | 2024-02-28 04:54:07 | spense | 1 | 48755 | 5 | 0.970 | 50262.9 |
| 387 | 2024-02-20 10:19:04 | spense | 1 | 48755 | 5 | 2.013 | 24220.1 |
| 386 | 2024-01-19 04:13:46 | spense | 3 | 112716 | 708 | 5.920 | 19039.9 |
| 385 | 2024-01-19 04:13:45 | spense | 2 | 82551 | 59 | 2.656 | 31080.9 |
| 384 | 2024-01-15 07:01:22 | spense | 3 | 112716 | 708 | 4.796 | 23502.1 |
| 383 | 2024-01-14 23:27:01 | spense | 2 | 82551 | 59 | 2.530 | 32628.9 |
| 382 | 2024-01-07 05:11:08 | spense | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 381 | 2024-01-02 16:15:04 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 380 | 2023-12-31 17:52:57 | spense | 3 | 112716 | 708 | 4.860 | 23192.6 |
| 379 | 2023-12-31 17:51:09 | spense | 2 | 82551 | 59 | 2.406 | 34310.5 |
| 378 | 2023-11-17 11:29:57 | spense | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 377 | 2023-11-16 09:06:18 | spense | 1 | 48755 | 5 | 0.893 | 54596.9 |
| 376 | 2023-11-09 23:23:24 | spense | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 375 | 2023-10-30 19:57:36 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 374 | 2023-10-23 03:07:11 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 373 | 2023-10-22 20:48:24 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 372 | 2023-10-20 15:46:49 | spense | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 371 | 2023-10-19 18:52:56 | spense | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 370 | 2023-10-11 14:20:44 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 369 | 2023-10-08 18:36:13 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 368 | 2023-09-28 14:34:12 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 367 | 2023-09-26 18:33:32 | spense | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 366 | 2023-09-18 00:56:24 | spense | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 365 | 2023-09-14 09:01:49 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 364 | 2023-08-17 05:23:05 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 363 | 2023-05-26 03:19:35 | spense | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 362 | 2023-05-19 05:11:21 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 361 | 2023-03-14 18:47:53 | spense | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 360 | 2023-01-30 04:34:33 | spense | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 359 | 2022-09-27 21:08:35 | spense | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 358 | 2022-07-29 08:36:26 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 357 | 2022-07-13 03:28:33 | spense | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 356 | 2022-05-14 19:31:42 | spense | 1 | 48755 | 5 | 0.903 | 53992.2 |