History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prefire"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 504 | 2025-10-30 07:46:09 | prefire | 3 | 134027 | 327 | 37.766 | 3548.9 |
| 503 | 2025-10-30 07:45:32 | prefire | 3 | 134027 | 327 | 27.000 | 4964.0 |
| 502 | 2025-10-30 07:44:59 | prefire | 3 | 134027 | 327 | 32.003 | 4188.0 |
| 501 | 2025-10-30 07:44:30 | prefire | 3 | 134027 | 327 | 45.110 | 2971.1 |
| 500 | 2025-10-25 13:26:27 | prefire | 2 | 107671 | 40 | 7.876 | 13670.8 |
| 499 | 2025-10-25 03:37:22 | prefire | 3 | 134027 | 327 | 7.263 | 18453.4 |
| 498 | 2025-10-25 02:19:18 | prefire | 3 | 134027 | 327 | 7.266 | 18445.8 |
| 497 | 2025-10-24 18:28:09 | prefire | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 496 | 2025-10-23 07:43:19 | prefire | 3 | 134027 | 327 | 23.016 | 5823.2 |
| 495 | 2025-10-23 07:43:12 | prefire | 3 | 134027 | 327 | 28.546 | 4695.1 |
| 494 | 2025-10-23 07:43:20 | prefire | 2 | 107671 | 40 | 14.330 | 7513.7 |
| 493 | 2025-10-23 07:43:01 | prefire | 3 | 134027 | 327 | 29.830 | 4493.0 |
| 492 | 2025-10-23 07:42:55 | prefire | 3 | 134027 | 327 | 30.143 | 4446.4 |
| 491 | 2025-10-23 07:43:11 | prefire | 2 | 107671 | 40 | 10.250 | 10504.5 |
| 490 | 2025-10-23 07:43:00 | prefire | 2 | 107671 | 40 | 10.546 | 10209.7 |
| 489 | 2025-10-23 07:42:54 | prefire | 2 | 107671 | 40 | 16.440 | 6549.3 |
| 488 | 2025-10-23 03:17:03 | prefire | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 487 | 2025-09-30 18:45:45 | prefire | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 486 | 2025-09-21 01:30:39 | prefire | 3 | 134027 | 327 | 6.670 | 20094.0 |
| 485 | 2025-09-19 12:12:15 | prefire | 3 | 134027 | 327 | 6.923 | 19359.7 |
| 484 | 2025-09-18 22:44:30 | prefire | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 483 | 2025-09-15 03:57:44 | prefire | 1 | 69583 | 6 | 1.656 | 42018.7 |
| 482 | 2025-08-29 11:22:16 | prefire | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 481 | 2025-08-27 16:38:45 | prefire | 3 | 134027 | 327 | 9.563 | 14015.2 |
| 480 | 2025-08-27 12:39:11 | prefire | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 479 | 2025-08-27 08:52:07 | prefire | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 478 | 2025-08-26 23:35:55 | prefire | 1 | 69583 | 6 | 4.766 | 14599.9 |
| 477 | 2025-08-25 12:47:16 | prefire | 3 | 134027 | 327 | 31.610 | 4240.0 |
| 476 | 2025-08-25 02:01:30 | prefire | 2 | 107671 | 40 | 16.876 | 6380.1 |
| 475 | 2025-08-24 01:01:32 | prefire | 1 | 69583 | 6 | 1.610 | 43219.3 |
| 474 | 2025-08-14 16:52:08 | prefire | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 473 | 2025-08-12 19:19:31 | prefire | 1 | 69583 | 6 | 2.953 | 23563.5 |
| 472 | 2025-08-08 22:18:00 | prefire | 1 | 69583 | 6 | 5.623 | 12374.7 |
| 471 | 2025-07-28 16:14:51 | prefire | 2 | 107671 | 40 | 7.893 | 13641.3 |
| 470 | 2025-07-28 15:26:59 | prefire | 3 | 134027 | 327 | 31.176 | 4299.0 |
| 469 | 2025-07-27 10:14:46 | prefire | 1 | 69583 | 6 | 4.500 | 15462.9 |
| 468 | 2025-07-24 17:10:32 | prefire | 1 | 69583 | 6 | 6.423 | 10833.4 |
| 467 | 2025-07-23 10:29:29 | prefire | 1 | 69583 | 6 | 6.546 | 10629.9 |
| 466 | 2025-07-23 02:50:57 | prefire | 1 | 69583 | 6 | 8.200 | 8485.7 |
| 465 | 2025-07-22 09:55:07 | prefire | 1 | 69583 | 6 | 4.766 | 14599.9 |
| 464 | 2025-07-17 02:13:39 | prefire | 1 | 69583 | 6 | 2.533 | 27470.6 |
| 463 | 2025-07-16 19:24:31 | prefire | 3 | 134027 | 327 | 15.796 | 8484.9 |
| 462 | 2025-07-04 22:13:47 | prefire | 1 | 69583 | 6 | 2.940 | 23667.7 |
| 461 | 2025-07-03 22:50:05 | prefire | 1 | 69583 | 6 | 5.780 | 12038.6 |
| 460 | 2025-06-28 11:10:05 | prefire | 2 | 107671 | 40 | 16.923 | 6362.4 |
| 459 | 2025-06-27 03:18:34 | prefire | 3 | 134027 | 327 | 7.063 | 18975.9 |
| 458 | 2025-06-26 09:44:26 | prefire | 1 | 69583 | 6 | 8.210 | 8475.4 |
| 457 | 2025-06-24 20:20:25 | prefire | 2 | 107671 | 40 | 10.140 | 10618.4 |
| 456 | 2025-06-24 19:36:17 | prefire | 3 | 134027 | 327 | 7.406 | 18097.1 |
| 455 | 2025-06-24 04:49:14 | prefire | 2 | 107671 | 40 | 12.296 | 8756.6 |
| 454 | 2025-06-24 02:36:46 | prefire | 3 | 134027 | 327 | 47.640 | 2813.3 |
| 453 | 2025-06-23 21:58:29 | prefire | 3 | 134027 | 327 | 40.626 | 3299.0 |
| 452 | 2025-06-23 19:57:06 | prefire | 2 | 107671 | 40 | 3.563 | 30219.2 |
| 451 | 2025-06-23 06:28:14 | prefire | 3 | 134027 | 327 | 38.330 | 3496.7 |
| 450 | 2025-06-23 02:34:11 | prefire | 1 | 69583 | 6 | 2.906 | 23944.6 |
| 449 | 2025-06-22 23:10:26 | prefire | 2 | 107671 | 40 | 3.453 | 31181.9 |
| 448 | 2025-06-22 03:30:41 | prefire | 1 | 69583 | 6 | 6.343 | 10970.0 |
| 447 | 2025-06-03 22:10:15 | prefire | 1 | 69583 | 6 | 3.483 | 19977.9 |
| 446 | 2025-05-30 12:23:52 | prefire | 1 | 69583 | 6 | 3.220 | 21609.6 |
| 445 | 2025-05-27 04:41:57 | prefire | 3 | 134027 | 327 | 22.016 | 6087.7 |
| 444 | 2025-05-24 02:16:46 | prefire | 3 | 134027 | 327 | 26.310 | 5094.1 |
| 443 | 2025-05-23 22:46:12 | prefire | 3 | 134027 | 327 | 38.750 | 3458.8 |
| 442 | 2025-05-23 03:20:34 | prefire | 1 | 69583 | 6 | 6.003 | 11591.4 |
| 441 | 2025-05-22 23:00:54 | prefire | 2 | 107671 | 40 | 4.500 | 23926.9 |
| 440 | 2025-05-22 07:10:21 | prefire | 3 | 134027 | 327 | 51.846 | 2585.1 |
| 439 | 2025-05-21 02:47:15 | prefire | 3 | 134027 | 327 | 5.966 | 22465.1 |
| 438 | 2025-05-20 03:02:40 | prefire | 1 | 69583 | 6 | 6.343 | 10970.0 |
| 437 | 2025-05-16 00:43:23 | prefire | 1 | 69583 | 6 | 2.983 | 23326.5 |
| 436 | 2025-05-03 22:00:59 | prefire | 1 | 69583 | 6 | 6.750 | 10308.6 |
| 435 | 2025-04-25 08:30:53 | prefire | 1 | 69583 | 6 | 4.860 | 14317.5 |
| 434 | 2025-04-24 16:27:29 | prefire | 3 | 134027 | 327 | 52.956 | 2530.9 |
| 433 | 2025-04-23 21:35:53 | prefire | 3 | 134027 | 327 | 52.253 | 2565.0 |
| 432 | 2025-04-23 02:22:24 | prefire | 3 | 134027 | 327 | 30.613 | 4378.1 |
| 431 | 2025-04-23 02:10:07 | prefire | 1 | 69583 | 6 | 2.766 | 25156.5 |
| 430 | 2025-04-21 07:12:03 | prefire | 3 | 134027 | 327 | 24.096 | 5562.2 |
| 429 | 2025-04-19 00:03:29 | prefire | 3 | 134027 | 327 | 13.016 | 10297.1 |
| 428 | 2025-04-11 00:06:58 | prefire | 1 | 69583 | 6 | 6.096 | 11414.5 |
| 427 | 2025-04-10 12:27:03 | prefire | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 426 | 2025-04-01 22:00:45 | prefire | 1 | 69583 | 6 | 4.346 | 16010.8 |
| 425 | 2025-03-29 01:40:45 | prefire | 1 | 69583 | 6 | 6.546 | 10629.9 |
| 424 | 2025-03-25 18:36:08 | prefire | 2 | 107671 | 40 | 14.126 | 7622.2 |
| 423 | 2025-03-25 02:29:37 | prefire | 3 | 134027 | 327 | 36.673 | 3654.7 |
| 422 | 2025-03-24 20:37:26 | prefire | 2 | 107671 | 40 | 3.343 | 32207.9 |
| 421 | 2025-03-24 10:30:23 | prefire | 1 | 69583 | 6 | 3.186 | 21840.2 |
| 420 | 2025-03-24 00:41:11 | prefire | 1 | 69583 | 6 | 3.450 | 20169.0 |
| 419 | 2025-03-23 23:47:08 | prefire | 2 | 107671 | 40 | 15.076 | 7141.9 |
| 418 | 2025-03-23 22:37:13 | prefire | 3 | 134027 | 327 | 32.226 | 4159.0 |
| 417 | 2025-03-23 19:05:44 | prefire | 3 | 134027 | 327 | 46.893 | 2858.1 |
| 416 | 2025-03-23 03:07:58 | prefire | 3 | 134027 | 327 | 32.936 | 4069.3 |
| 415 | 2025-03-23 03:07:20 | prefire | 1 | 69583 | 6 | 6.233 | 11163.6 |
| 414 | 2025-03-21 09:21:22 | prefire | 3 | 134027 | 327 | 32.233 | 4158.1 |
| 413 | 2025-03-21 00:11:49 | prefire | 2 | 107671 | 40 | 11.736 | 9174.4 |
| 412 | 2025-03-17 18:38:05 | prefire | 1 | 69583 | 6 | 6.093 | 11420.2 |
| 411 | 2025-03-16 23:33:07 | prefire | 1 | 69583 | 6 | 6.153 | 11308.8 |
| 410 | 2025-03-15 01:41:58 | prefire | 1 | 69583 | 6 | 9.220 | 7547.0 |
| 409 | 2025-03-10 19:00:50 | prefire | 1 | 69583 | 6 | 10.733 | 6483.1 |
| 408 | 2025-03-09 23:35:47 | prefire | 1 | 69583 | 6 | 8.766 | 7937.8 |
| 407 | 2025-03-09 00:24:05 | prefire | 1 | 69583 | 6 | 5.016 | 13872.2 |
| 406 | 2025-03-01 12:34:48 | prefire | 1 | 69583 | 6 | 5.483 | 12690.7 |
| 405 | 2025-02-25 22:59:37 | prefire | 1 | 69583 | 6 | 5.296 | 13138.8 |