History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prosect"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 465 | 2025-10-23 13:02:38 | prosect | 1 | 69583 | 5 | 4.266 | 16311.1 |
| 464 | 2025-10-17 01:18:58 | prosect | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 463 | 2025-10-13 09:06:49 | prosect | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 462 | 2025-10-11 21:25:23 | prosect | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 461 | 2025-10-11 03:32:09 | prosect | 3 | 134027 | 230 | 7.000 | 19146.7 |
| 460 | 2025-10-09 23:38:58 | prosect | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 459 | 2025-10-07 05:33:24 | prosect | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 458 | 2025-10-04 11:20:32 | prosect | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 457 | 2025-09-29 03:11:06 | prosect | 1 | 69583 | 5 | 2.423 | 28717.7 |
| 456 | 2025-09-27 10:17:29 | prosect | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 455 | 2025-09-27 00:29:01 | prosect | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 454 | 2025-09-25 14:51:28 | prosect | 3 | 134027 | 230 | 33.750 | 3971.2 |
| 453 | 2025-09-25 11:29:15 | prosect | 1 | 69583 | 5 | 3.000 | 23194.3 |
| 452 | 2025-09-20 12:59:12 | prosect | 1 | 69583 | 5 | 1.940 | 35867.5 |
| 451 | 2025-09-20 02:55:46 | prosect | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 450 | 2025-09-18 22:53:34 | prosect | 1 | 69583 | 5 | 2.546 | 27330.3 |
| 449 | 2025-09-14 10:21:51 | prosect | 3 | 134027 | 230 | 8.140 | 16465.2 |
| 448 | 2025-09-12 19:15:03 | prosect | 3 | 134027 | 230 | 6.966 | 19240.2 |
| 447 | 2025-09-11 09:37:08 | prosect | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 446 | 2025-09-10 06:28:38 | prosect | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 445 | 2025-09-09 00:03:12 | prosect | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 444 | 2025-09-07 14:46:15 | prosect | 2 | 107671 | 31 | 7.906 | 13618.9 |
| 443 | 2025-09-07 12:12:25 | prosect | 2 | 107671 | 31 | 3.000 | 35890.3 |
| 442 | 2025-09-01 04:56:04 | prosect | 1 | 69583 | 5 | 1.200 | 57985.8 |
| 441 | 2025-08-29 23:56:38 | prosect | 3 | 134027 | 230 | 6.110 | 21935.7 |
| 440 | 2025-08-28 16:34:20 | prosect | 2 | 107671 | 31 | 4.203 | 25617.7 |
| 439 | 2025-08-28 14:20:46 | prosect | 2 | 107671 | 31 | 3.406 | 31612.2 |
| 438 | 2025-08-28 02:54:44 | prosect | 2 | 107671 | 31 | 2.966 | 36301.8 |
| 437 | 2025-08-27 10:00:13 | prosect | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 436 | 2025-08-27 01:22:12 | prosect | 2 | 107671 | 31 | 3.500 | 30763.1 |
| 435 | 2025-08-27 00:30:33 | prosect | 2 | 107671 | 31 | 3.313 | 32499.5 |
| 434 | 2025-08-26 23:37:31 | prosect | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 433 | 2025-08-26 01:47:50 | prosect | 3 | 134027 | 230 | 6.736 | 19897.1 |
| 432 | 2025-08-25 10:59:14 | prosect | 1 | 69583 | 5 | 8.453 | 8231.8 |
| 431 | 2025-08-25 00:07:07 | prosect | 1 | 69583 | 5 | 8.033 | 8662.1 |
| 430 | 2025-08-22 22:40:03 | prosect | 3 | 134027 | 230 | 25.686 | 5217.9 |
| 429 | 2025-08-18 12:51:24 | prosect | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 428 | 2025-08-11 23:04:06 | prosect | 3 | 134027 | 230 | 17.890 | 7491.7 |
| 427 | 2025-08-11 06:06:14 | prosect | 3 | 134027 | 230 | 11.626 | 11528.2 |
| 426 | 2025-08-08 23:04:02 | prosect | 1 | 69583 | 5 | 7.720 | 9013.3 |
| 425 | 2025-08-05 10:17:30 | prosect | 1 | 69583 | 5 | 2.423 | 28717.7 |
| 424 | 2025-07-31 01:46:31 | prosect | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 423 | 2025-07-27 12:31:30 | prosect | 2 | 107671 | 31 | 8.233 | 13078.0 |
| 422 | 2025-07-27 11:06:29 | prosect | 3 | 134027 | 230 | 14.983 | 8945.3 |
| 421 | 2025-07-27 05:11:08 | prosect | 3 | 134027 | 230 | 17.423 | 7692.5 |
| 420 | 2025-07-26 08:06:44 | prosect | 2 | 107671 | 31 | 7.940 | 13560.6 |
| 419 | 2025-07-25 11:46:59 | prosect | 3 | 134027 | 230 | 16.826 | 7965.5 |
| 418 | 2025-07-25 02:02:32 | prosect | 1 | 69583 | 5 | 3.123 | 22280.8 |
| 417 | 2025-07-24 17:34:13 | prosect | 1 | 69583 | 5 | 6.576 | 10581.4 |
| 416 | 2025-07-24 04:54:25 | prosect | 3 | 134027 | 230 | 30.516 | 4392.0 |
| 415 | 2025-07-21 17:24:13 | prosect | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 414 | 2025-07-21 02:24:53 | prosect | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 413 | 2025-07-20 14:51:00 | prosect | 3 | 134027 | 230 | 6.296 | 21287.6 |
| 412 | 2025-07-20 01:08:30 | prosect | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 411 | 2025-07-17 05:05:50 | prosect | 2 | 107671 | 31 | 12.000 | 8972.6 |
| 410 | 2025-07-16 08:15:58 | prosect | 1 | 69583 | 5 | 6.533 | 10651.0 |
| 409 | 2025-07-12 10:09:26 | prosect | 1 | 69583 | 5 | 2.500 | 27833.2 |
| 408 | 2025-07-11 00:45:00 | prosect | 1 | 69583 | 5 | 3.466 | 20075.9 |
| 407 | 2025-07-10 17:40:05 | prosect | 1 | 69583 | 5 | 3.500 | 19880.9 |
| 406 | 2025-07-09 22:32:36 | prosect | 1 | 69583 | 5 | 7.266 | 9576.5 |
| 405 | 2025-07-08 05:03:19 | prosect | 2 | 107671 | 31 | 11.876 | 9066.3 |
| 404 | 2025-07-07 15:26:57 | prosect | 2 | 107671 | 31 | 11.843 | 9091.5 |
| 403 | 2025-07-07 11:46:19 | prosect | 1 | 69583 | 5 | 4.936 | 14097.0 |
| 402 | 2025-07-03 12:39:36 | prosect | 2 | 107671 | 31 | 18.783 | 5732.4 |
| 401 | 2025-07-03 08:18:28 | prosect | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 400 | 2025-06-29 22:32:14 | prosect | 1 | 69583 | 5 | 3.186 | 21840.2 |
| 399 | 2025-06-23 13:54:50 | prosect | 2 | 107671 | 31 | 5.983 | 17996.2 |
| 398 | 2025-06-23 13:11:04 | prosect | 3 | 134027 | 230 | 7.030 | 19065.0 |
| 397 | 2025-06-17 04:50:29 | prosect | 1 | 69583 | 5 | 6.716 | 10360.8 |
| 396 | 2025-06-10 03:42:38 | prosect | 1 | 69583 | 5 | 6.000 | 11597.2 |
| 395 | 2025-06-08 03:42:21 | prosect | 3 | 134027 | 230 | 30.003 | 4467.1 |
| 394 | 2025-06-06 22:18:30 | prosect | 1 | 69583 | 5 | 5.953 | 11688.7 |
| 393 | 2025-06-05 22:49:34 | prosect | 3 | 134027 | 230 | 28.466 | 4708.3 |
| 392 | 2025-06-04 19:04:38 | prosect | 3 | 134027 | 230 | 31.236 | 4290.8 |
| 391 | 2025-06-04 10:09:51 | prosect | 3 | 134027 | 230 | 22.973 | 5834.1 |
| 390 | 2025-06-04 02:41:06 | prosect | 1 | 69583 | 5 | 3.186 | 21840.2 |
| 389 | 2025-06-04 01:12:56 | prosect | 1 | 69583 | 5 | 3.530 | 19711.9 |
| 388 | 2025-06-01 01:00:17 | prosect | 3 | 134027 | 230 | 17.983 | 7453.0 |
| 387 | 2025-05-31 11:12:54 | prosect | 1 | 69583 | 5 | 2.776 | 25065.9 |
| 386 | 2025-05-28 20:31:35 | prosect | 1 | 69583 | 5 | 3.500 | 19880.9 |
| 385 | 2025-05-28 18:15:34 | prosect | 2 | 107671 | 31 | 3.576 | 30109.3 |
| 384 | 2025-05-23 14:20:00 | prosect | 2 | 107671 | 31 | 14.593 | 7378.3 |
| 383 | 2025-05-23 13:26:16 | prosect | 3 | 134027 | 230 | 24.780 | 5408.7 |
| 382 | 2025-05-22 12:00:14 | prosect | 1 | 69583 | 5 | 6.253 | 11127.9 |
| 381 | 2025-05-20 01:15:09 | prosect | 1 | 69583 | 5 | 3.093 | 22496.9 |
| 380 | 2025-05-12 09:21:41 | prosect | 3 | 134027 | 230 | 40.546 | 3305.6 |
| 379 | 2025-05-11 03:40:26 | prosect | 3 | 134027 | 230 | 30.690 | 4367.1 |
| 378 | 2025-05-07 22:26:15 | prosect | 3 | 134027 | 230 | 38.366 | 3493.4 |
| 377 | 2025-05-06 21:56:56 | prosect | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 376 | 2025-05-06 03:21:37 | prosect | 1 | 69583 | 5 | 5.796 | 12005.3 |
| 375 | 2025-05-04 09:59:07 | prosect | 3 | 134027 | 230 | 17.846 | 7510.2 |
| 374 | 2025-05-04 00:52:22 | prosect | 2 | 107671 | 31 | 13.610 | 7911.2 |
| 373 | 2025-05-02 02:12:16 | prosect | 1 | 69583 | 5 | 7.966 | 8735.0 |
| 372 | 2025-04-30 11:12:59 | prosect | 1 | 69583 | 5 | 4.706 | 14786.0 |
| 371 | 2025-04-21 11:24:47 | prosect | 1 | 69583 | 5 | 6.173 | 11272.2 |
| 370 | 2025-04-20 00:30:17 | prosect | 1 | 69583 | 5 | 5.310 | 13104.1 |
| 369 | 2025-04-04 02:59:42 | prosect | 1 | 69583 | 5 | 4.656 | 14944.8 |
| 368 | 2025-03-28 10:18:41 | prosect | 3 | 134027 | 230 | 22.110 | 6061.8 |
| 367 | 2025-03-27 11:23:32 | prosect | 3 | 134027 | 230 | 36.220 | 3700.4 |
| 366 | 2025-03-25 03:54:52 | prosect | 3 | 134027 | 230 | 22.936 | 5843.5 |