History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"incidents"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 456 | 2025-10-30 07:09:49 | incidents | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 455 | 2025-10-25 09:59:54 | incidents | 1 | 81242 | 2 | 1.296 | 62686.7 |
| 454 | 2025-10-16 18:47:18 | incidents | 1 | 81242 | 2 | 1.356 | 59913.0 |
| 453 | 2025-10-15 18:33:14 | incidents | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 452 | 2025-10-10 17:06:40 | incidents | 1 | 81242 | 2 | 1.373 | 59171.2 |
| 451 | 2025-10-10 17:06:25 | incidents | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 450 | 2025-10-09 15:33:56 | incidents | 2 | 121436 | 13 | 3.123 | 38884.4 |
| 449 | 2025-10-09 14:01:28 | incidents | 2 | 121436 | 13 | 3.780 | 32125.9 |
| 448 | 2025-10-02 14:49:56 | incidents | 1 | 81242 | 2 | 1.250 | 64993.6 |
| 447 | 2025-09-27 16:40:47 | incidents | 1 | 81242 | 2 | 1.250 | 64993.6 |
| 446 | 2025-09-25 03:51:26 | incidents | 1 | 81242 | 2 | 3.563 | 22801.6 |
| 445 | 2025-09-18 10:44:57 | incidents | 1 | 81242 | 2 | 1.500 | 54161.3 |
| 444 | 2025-09-17 17:29:11 | incidents | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 443 | 2025-09-17 17:29:09 | incidents | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 442 | 2025-08-27 17:28:43 | incidents | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 441 | 2025-08-23 09:57:07 | incidents | 3 | 148641 | 53 | 39.020 | 3809.4 |
| 440 | 2025-08-19 11:11:23 | incidents | 3 | 148641 | 53 | 31.360 | 4739.8 |
| 439 | 2025-08-12 04:25:51 | incidents | 1 | 81242 | 2 | 2.563 | 31698.0 |
| 438 | 2025-08-06 10:05:28 | incidents | 3 | 148641 | 53 | 40.656 | 3656.1 |
| 437 | 2025-08-01 14:57:55 | incidents | 3 | 148641 | 53 | 31.390 | 4735.3 |
| 436 | 2025-07-31 03:44:53 | incidents | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 435 | 2025-07-29 02:10:18 | incidents | 3 | 148641 | 53 | 29.843 | 4980.8 |
| 434 | 2025-07-27 00:17:47 | incidents | 1 | 81242 | 2 | 2.656 | 30588.1 |
| 433 | 2025-07-26 09:37:06 | incidents | 1 | 81242 | 2 | 6.343 | 12808.1 |
| 432 | 2025-07-24 21:41:39 | incidents | 1 | 81242 | 2 | 3.076 | 26411.6 |
| 431 | 2025-07-14 10:34:24 | incidents | 3 | 148641 | 53 | 34.300 | 4333.6 |
| 430 | 2025-07-12 03:04:40 | incidents | 1 | 81242 | 2 | 1.393 | 58321.6 |
| 429 | 2025-06-30 04:07:13 | incidents | 1 | 81242 | 2 | 9.690 | 8384.1 |
| 428 | 2025-06-22 11:58:51 | incidents | 1 | 81242 | 2 | 5.373 | 15120.4 |
| 427 | 2025-06-10 10:36:55 | incidents | 1 | 81242 | 2 | 6.453 | 12589.8 |
| 426 | 2025-06-05 15:58:58 | incidents | 1 | 81242 | 2 | 3.313 | 24522.2 |
| 425 | 2025-05-30 06:53:02 | incidents | 1 | 81242 | 2 | 8.826 | 9204.8 |
| 424 | 2025-05-25 23:12:14 | incidents | 1 | 81242 | 2 | 4.610 | 17623.0 |
| 423 | 2025-05-18 12:11:12 | incidents | 1 | 81242 | 2 | 6.386 | 12721.9 |
| 422 | 2025-05-14 12:15:05 | incidents | 1 | 81242 | 2 | 2.830 | 28707.4 |
| 421 | 2025-04-27 17:32:25 | incidents | 1 | 81242 | 2 | 1.373 | 59171.2 |
| 420 | 2025-04-27 09:10:18 | incidents | 1 | 81242 | 2 | 1.373 | 59171.2 |
| 419 | 2025-04-22 23:54:26 | incidents | 1 | 81242 | 2 | 6.656 | 12205.8 |
| 418 | 2025-04-18 10:09:59 | incidents | 1 | 81242 | 2 | 8.453 | 9611.0 |
| 417 | 2025-04-15 04:12:24 | incidents | 1 | 81242 | 2 | 9.720 | 8358.2 |
| 416 | 2025-04-06 10:44:29 | incidents | 1 | 81242 | 2 | 4.110 | 19766.9 |
| 415 | 2025-03-27 17:09:10 | incidents | 1 | 81242 | 2 | 7.906 | 10276.0 |
| 414 | 2025-03-23 17:17:50 | incidents | 1 | 81242 | 2 | 3.436 | 23644.4 |
| 413 | 2025-02-24 12:43:30 | incidents | 1 | 81242 | 2 | 7.296 | 11135.1 |
| 412 | 2025-02-19 02:35:55 | incidents | 1 | 81242 | 2 | 6.186 | 13133.2 |
| 411 | 2025-02-14 09:43:25 | incidents | 3 | 148641 | 53 | 35.926 | 4137.4 |
| 410 | 2025-02-12 13:13:27 | incidents | 1 | 81242 | 2 | 3.110 | 26122.8 |
| 409 | 2025-02-01 20:53:55 | incidents | 2 | 121436 | 13 | 17.346 | 7000.8 |
| 408 | 2025-01-26 10:21:01 | incidents | 3 | 148641 | 53 | 35.286 | 4212.5 |
| 407 | 2025-01-26 10:20:42 | incidents | 3 | 148641 | 53 | 35.673 | 4166.8 |
| 406 | 2025-01-26 10:20:56 | incidents | 2 | 121436 | 13 | 19.360 | 6272.5 |
| 405 | 2025-01-22 10:05:12 | incidents | 1 | 81242 | 2 | 3.376 | 24064.6 |
| 404 | 2025-01-18 17:34:58 | incidents | 1 | 81242 | 2 | 6.173 | 13160.9 |
| 403 | 2025-01-08 13:52:08 | incidents | 1 | 81242 | 2 | 3.903 | 20815.3 |
| 402 | 2025-01-05 15:29:58 | incidents | 1 | 81242 | 2 | 4.063 | 19995.6 |
| 401 | 2024-12-21 09:17:06 | incidents | 1 | 81242 | 2 | 6.313 | 12869.0 |
| 400 | 2024-12-16 13:25:06 | incidents | 1 | 81242 | 2 | 7.843 | 10358.5 |
| 399 | 2024-12-06 00:48:53 | incidents | 1 | 81242 | 2 | 5.690 | 14278.0 |
| 398 | 2024-11-20 09:49:10 | incidents | 1 | 81242 | 2 | 6.643 | 12229.7 |
| 397 | 2024-11-06 22:50:21 | incidents | 3 | 148641 | 53 | 45.576 | 3261.4 |
| 396 | 2024-10-27 08:07:04 | incidents | 1 | 81242 | 2 | 3.206 | 25340.6 |
| 395 | 2024-10-21 09:58:43 | incidents | 3 | 148641 | 53 | 36.393 | 4084.3 |
| 394 | 2024-10-21 09:58:41 | incidents | 3 | 148641 | 53 | 29.876 | 4975.3 |
| 393 | 2024-10-21 09:58:43 | incidents | 2 | 121436 | 13 | 18.330 | 6625.0 |
| 392 | 2024-10-21 09:52:32 | incidents | 1 | 81242 | 2 | 4.516 | 17989.8 |
| 391 | 2024-10-20 22:12:38 | incidents | 2 | 121436 | 13 | 19.233 | 6313.9 |
| 390 | 2024-10-15 10:28:55 | incidents | 1 | 81242 | 2 | 6.720 | 12089.6 |
| 389 | 2024-10-08 15:11:37 | incidents | 1 | 81242 | 2 | 1.343 | 60492.9 |
| 388 | 2024-10-02 01:59:52 | incidents | 2 | 121436 | 13 | 34.750 | 3494.6 |
| 387 | 2024-09-30 14:06:32 | incidents | 2 | 121436 | 13 | 28.926 | 4198.2 |
| 386 | 2024-09-22 07:03:59 | incidents | 3 | 148641 | 53 | 54.143 | 2745.3 |
| 385 | 2024-09-19 01:08:26 | incidents | 2 | 121436 | 13 | 29.270 | 4148.8 |
| 384 | 2024-09-19 00:04:50 | incidents | 1 | 81242 | 2 | 9.686 | 8387.6 |
| 383 | 2024-09-18 18:16:44 | incidents | 3 | 148641 | 53 | 55.453 | 2680.5 |
| 382 | 2024-09-15 21:43:40 | incidents | 2 | 121436 | 13 | 17.373 | 6989.9 |
| 381 | 2024-09-15 21:43:22 | incidents | 1 | 81242 | 2 | 8.203 | 9903.9 |
| 380 | 2024-09-15 21:08:32 | incidents | 3 | 148641 | 53 | 43.000 | 3456.8 |
| 379 | 2024-09-15 06:23:16 | incidents | 3 | 148641 | 53 | 62.190 | 2390.1 |
| 378 | 2024-09-12 06:26:39 | incidents | 1 | 81242 | 2 | 13.673 | 5941.8 |
| 377 | 2024-09-11 12:18:40 | incidents | 3 | 148641 | 53 | 78.973 | 1882.2 |
| 376 | 2024-09-08 22:31:46 | incidents | 3 | 148641 | 53 | 35.723 | 4160.9 |
| 375 | 2024-09-05 23:24:38 | incidents | 4 | 165329 | 332 | 121.913 | 1356.1 |
| 374 | 2024-09-05 23:24:36 | incidents | 3 | 148641 | 53 | 35.220 | 4220.4 |
| 373 | 2024-09-05 23:24:35 | incidents | 2 | 121436 | 13 | 27.610 | 4398.3 |
| 372 | 2024-09-05 22:10:12 | incidents | 1 | 81242 | 2 | 1.250 | 64993.6 |
| 371 | 2024-09-01 13:22:02 | incidents | 4 | 165329 | 332 | 51.126 | 3233.8 |
| 370 | 2024-09-01 12:33:37 | incidents | 2 | 121436 | 13 | 41.970 | 2893.4 |
| 369 | 2024-08-28 02:26:45 | incidents | 1 | 81242 | 2 | 8.173 | 9940.3 |
| 368 | 2024-08-18 18:15:33 | incidents | 4 | 165329 | 332 | 112.956 | 1463.7 |
| 367 | 2024-08-18 10:02:28 | incidents | 4 | 165329 | 332 | 116.430 | 1420.0 |
| 366 | 2024-08-17 07:44:15 | incidents | 4 | 165329 | 332 | 113.193 | 1460.6 |
| 365 | 2024-08-15 16:45:57 | incidents | 2 | 121436 | 13 | 30.613 | 3966.8 |
| 364 | 2024-08-13 09:01:03 | incidents | 1 | 81242 | 2 | 14.953 | 5433.2 |
| 363 | 2024-08-11 23:26:41 | incidents | 4 | 165329 | 332 | 75.536 | 2188.7 |
| 362 | 2024-08-11 23:26:45 | incidents | 3 | 148641 | 53 | 25.346 | 5864.5 |
| 361 | 2024-08-09 05:24:40 | incidents | 1 | 81242 | 2 | 3.013 | 26963.8 |
| 360 | 2024-08-07 20:27:37 | incidents | 3 | 148641 | 53 | 27.720 | 5362.2 |
| 359 | 2024-08-03 07:45:53 | incidents | 1 | 81242 | 2 | 4.706 | 17263.5 |
| 358 | 2024-08-01 22:33:58 | incidents | 1 | 81242 | 2 | 9.470 | 8578.9 |
| 357 | 2024-08-01 16:24:26 | incidents | 3 | 148641 | 53 | 25.736 | 5775.6 |