History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shootings"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 425 | 2025-12-07 09:58:36 | shootings | 3 | 148641 | 165 | 7.170 | 20731.0 |
| 424 | 2025-12-02 16:59:36 | shootings | 3 | 148641 | 165 | 7.436 | 19989.4 |
| 423 | 2025-11-29 00:25:55 | shootings | 2 | 121436 | 24 | 3.796 | 31990.5 |
| 422 | 2025-11-24 05:24:08 | shootings | 1 | 81242 | 2 | 1.516 | 53589.7 |
| 421 | 2025-11-23 09:20:59 | shootings | 3 | 148641 | 165 | 7.703 | 19296.5 |
| 420 | 2025-11-04 05:03:20 | shootings | 3 | 148641 | 165 | 6.516 | 22811.7 |
| 419 | 2025-10-23 10:19:17 | shootings | 1 | 81242 | 2 | 7.093 | 11453.8 |
| 418 | 2025-10-22 16:28:15 | shootings | 1 | 81242 | 2 | 7.016 | 11579.5 |
| 417 | 2025-10-22 16:27:54 | shootings | 1 | 81242 | 2 | 7.216 | 11258.6 |
| 416 | 2025-10-20 09:05:12 | shootings | 1 | 81242 | 2 | 7.626 | 10653.3 |
| 415 | 2025-10-20 09:04:53 | shootings | 1 | 81242 | 2 | 5.610 | 14481.6 |
| 414 | 2025-10-20 09:04:38 | shootings | 1 | 81242 | 2 | 6.016 | 13504.3 |
| 413 | 2025-10-20 09:04:22 | shootings | 1 | 81242 | 2 | 3.063 | 26523.7 |
| 412 | 2025-10-07 20:33:51 | shootings | 1 | 81242 | 2 | 2.233 | 36382.4 |
| 411 | 2025-09-22 02:31:58 | shootings | 1 | 81242 | 2 | 1.296 | 62686.7 |
| 410 | 2025-09-09 05:09:20 | shootings | 3 | 148641 | 165 | 7.140 | 20818.1 |
| 409 | 2025-08-19 14:50:12 | shootings | 1 | 81242 | 2 | 4.016 | 20229.6 |
| 408 | 2025-08-12 15:39:26 | shootings | 3 | 148641 | 165 | 18.966 | 7837.2 |
| 407 | 2025-08-12 09:17:59 | shootings | 3 | 148641 | 165 | 17.906 | 8301.2 |
| 406 | 2025-08-11 21:50:40 | shootings | 1 | 81242 | 2 | 2.766 | 29371.7 |
| 405 | 2025-08-10 16:40:16 | shootings | 3 | 148641 | 165 | 37.160 | 4000.0 |
| 404 | 2025-08-10 05:11:21 | shootings | 2 | 121436 | 24 | 8.346 | 14550.2 |
| 403 | 2025-08-09 13:26:43 | shootings | 1 | 81242 | 2 | 5.700 | 14253.0 |
| 402 | 2025-08-08 19:53:13 | shootings | 1 | 81242 | 2 | 3.346 | 24280.3 |
| 401 | 2025-08-05 20:48:37 | shootings | 3 | 148641 | 165 | 24.423 | 6086.1 |
| 400 | 2025-08-04 06:49:23 | shootings | 1 | 81242 | 2 | 3.343 | 24302.1 |
| 399 | 2025-08-01 22:24:25 | shootings | 3 | 148641 | 165 | 16.516 | 8999.8 |
| 398 | 2025-07-31 01:51:40 | shootings | 1 | 81242 | 2 | 8.483 | 9577.0 |
| 397 | 2025-07-27 03:31:09 | shootings | 1 | 81242 | 2 | 10.123 | 8025.5 |
| 396 | 2025-07-26 03:19:37 | shootings | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 395 | 2025-07-24 15:11:41 | shootings | 1 | 81242 | 2 | 3.610 | 22504.7 |
| 394 | 2025-07-24 09:06:00 | shootings | 1 | 81242 | 2 | 6.940 | 11706.3 |
| 393 | 2025-07-22 23:55:58 | shootings | 1 | 81242 | 2 | 8.843 | 9187.2 |
| 392 | 2025-07-22 16:20:30 | shootings | 1 | 81242 | 2 | 6.643 | 12229.7 |
| 391 | 2025-07-20 11:36:07 | shootings | 2 | 121436 | 24 | 4.033 | 30110.6 |
| 390 | 2025-07-04 17:47:20 | shootings | 2 | 121436 | 24 | 6.203 | 19577.0 |
| 389 | 2025-07-04 06:39:37 | shootings | 1 | 81242 | 2 | 3.673 | 22118.7 |
| 388 | 2025-07-03 23:21:35 | shootings | 3 | 148641 | 165 | 32.343 | 4595.8 |
| 387 | 2025-07-03 15:50:47 | shootings | 1 | 81242 | 2 | 1.293 | 62832.2 |
| 386 | 2025-07-03 07:48:18 | shootings | 2 | 121436 | 24 | 3.673 | 33061.8 |
| 385 | 2025-07-01 21:02:58 | shootings | 2 | 121436 | 24 | 14.390 | 8438.9 |
| 384 | 2025-06-27 15:22:17 | shootings | 3 | 148641 | 165 | 37.766 | 3935.8 |
| 383 | 2025-06-26 16:56:53 | shootings | 1 | 81242 | 2 | 7.796 | 10421.0 |
| 382 | 2025-06-26 08:07:12 | shootings | 2 | 121436 | 24 | 9.063 | 13399.1 |
| 381 | 2025-06-26 04:45:24 | shootings | 3 | 148641 | 165 | 39.550 | 3758.3 |
| 380 | 2025-06-24 08:20:11 | shootings | 3 | 148641 | 165 | 27.893 | 5329.0 |
| 379 | 2025-06-24 08:14:59 | shootings | 2 | 121436 | 24 | 16.063 | 7560.0 |
| 378 | 2025-06-17 19:25:16 | shootings | 1 | 81242 | 2 | 1.326 | 61268.5 |
| 377 | 2025-06-10 04:19:51 | shootings | 1 | 81242 | 2 | 11.316 | 7179.4 |
| 376 | 2025-06-04 00:58:39 | shootings | 1 | 81242 | 2 | 7.050 | 11523.7 |
| 375 | 2025-06-02 14:43:28 | shootings | 1 | 81242 | 2 | 6.983 | 11634.3 |
| 374 | 2025-05-26 17:55:45 | shootings | 1 | 81242 | 2 | 3.346 | 24280.3 |
| 373 | 2025-05-08 21:21:36 | shootings | 1 | 81242 | 2 | 4.140 | 19623.7 |
| 372 | 2025-05-06 14:33:00 | shootings | 3 | 148641 | 165 | 42.220 | 3520.6 |
| 371 | 2025-05-04 03:40:07 | shootings | 1 | 81242 | 2 | 10.360 | 7841.9 |
| 370 | 2025-05-02 23:04:34 | shootings | 3 | 148641 | 165 | 30.376 | 4893.4 |
| 369 | 2025-05-02 19:11:57 | shootings | 2 | 121436 | 24 | 3.563 | 34082.5 |
| 368 | 2025-05-02 08:07:36 | shootings | 3 | 148641 | 165 | 32.893 | 4518.9 |
| 367 | 2025-04-30 18:47:45 | shootings | 3 | 148641 | 165 | 7.546 | 19698.0 |
| 366 | 2025-04-29 09:41:46 | shootings | 3 | 148641 | 165 | 8.173 | 18186.8 |
| 365 | 2025-04-28 15:17:10 | shootings | 3 | 148641 | 165 | 28.830 | 5155.8 |
| 364 | 2025-04-27 14:59:11 | shootings | 2 | 121436 | 24 | 3.546 | 34245.9 |
| 363 | 2025-04-25 02:40:57 | shootings | 2 | 121436 | 24 | 18.820 | 6452.5 |
| 362 | 2025-04-23 02:50:50 | shootings | 1 | 81242 | 2 | 3.576 | 22718.7 |
| 361 | 2025-04-18 02:25:40 | shootings | 1 | 81242 | 2 | 3.656 | 22221.6 |
| 360 | 2025-04-02 16:22:51 | shootings | 2 | 121436 | 24 | 17.890 | 6787.9 |
| 359 | 2025-04-01 22:29:09 | shootings | 3 | 148641 | 165 | 35.313 | 4209.2 |
| 358 | 2025-04-01 16:29:17 | shootings | 1 | 81242 | 2 | 1.516 | 53589.7 |
| 357 | 2025-03-27 08:42:33 | shootings | 1 | 81242 | 2 | 6.580 | 12346.8 |
| 356 | 2025-03-23 04:25:17 | shootings | 1 | 81242 | 2 | 2.923 | 27794.0 |
| 355 | 2025-03-22 09:52:38 | shootings | 2 | 121436 | 24 | 17.156 | 7078.3 |
| 354 | 2025-03-21 04:42:34 | shootings | 3 | 148641 | 165 | 39.376 | 3774.9 |
| 353 | 2025-03-20 06:53:35 | shootings | 1 | 81242 | 2 | 6.546 | 12410.9 |
| 352 | 2025-03-19 10:10:00 | shootings | 3 | 148641 | 165 | 19.813 | 7502.2 |
| 351 | 2025-03-19 05:36:31 | shootings | 2 | 121436 | 24 | 5.436 | 22339.2 |
| 350 | 2025-03-18 13:38:02 | shootings | 1 | 81242 | 2 | 5.640 | 14404.6 |
| 349 | 2025-03-11 07:45:07 | shootings | 3 | 148641 | 165 | 38.176 | 3893.6 |
| 348 | 2025-03-05 10:45:52 | shootings | 1 | 81242 | 2 | 2.813 | 28880.9 |
| 347 | 2025-03-02 15:30:30 | shootings | 3 | 148641 | 165 | 36.893 | 4029.0 |
| 346 | 2025-03-02 10:13:07 | shootings | 1 | 81242 | 2 | 3.610 | 22504.7 |
| 345 | 2025-02-25 04:49:15 | shootings | 3 | 148641 | 165 | 35.610 | 4174.1 |
| 344 | 2025-02-24 13:08:13 | shootings | 1 | 81242 | 2 | 7.486 | 10852.5 |
| 343 | 2025-02-24 10:24:30 | shootings | 1 | 81242 | 2 | 4.610 | 17623.0 |
| 342 | 2025-02-24 03:57:51 | shootings | 3 | 148641 | 165 | 56.143 | 2647.5 |
| 341 | 2025-02-24 03:57:48 | shootings | 2 | 121436 | 24 | 16.123 | 7531.8 |
| 340 | 2025-02-19 05:43:00 | shootings | 1 | 81242 | 2 | 3.483 | 23325.3 |
| 339 | 2025-02-10 11:06:23 | shootings | 1 | 81242 | 2 | 1.236 | 65729.8 |
| 338 | 2025-02-09 08:56:51 | shootings | 1 | 81242 | 2 | 1.423 | 57092.1 |
| 337 | 2025-02-09 04:20:11 | shootings | 1 | 81242 | 2 | 3.403 | 23873.6 |
| 336 | 2025-01-27 00:44:46 | shootings | 1 | 81242 | 2 | 8.236 | 9864.3 |
| 335 | 2025-01-24 19:30:28 | shootings | 1 | 81242 | 2 | 5.220 | 15563.6 |
| 334 | 2025-01-15 10:25:43 | shootings | 2 | 121436 | 24 | 16.950 | 7164.4 |
| 333 | 2025-01-15 06:49:52 | shootings | 3 | 148641 | 165 | 42.066 | 3533.5 |
| 332 | 2025-01-15 01:25:08 | shootings | 3 | 148641 | 165 | 33.830 | 4393.8 |
| 331 | 2025-01-13 23:58:13 | shootings | 3 | 148641 | 165 | 35.173 | 4226.0 |
| 330 | 2025-01-13 21:26:57 | shootings | 3 | 148641 | 165 | 29.300 | 5073.1 |
| 329 | 2025-01-13 17:17:14 | shootings | 3 | 148641 | 165 | 43.486 | 3418.1 |
| 328 | 2025-01-13 17:17:17 | shootings | 2 | 121436 | 24 | 17.983 | 6752.8 |
| 327 | 2025-01-13 17:15:51 | shootings | 1 | 81242 | 2 | 6.013 | 13511.1 |
| 326 | 2025-01-11 23:47:50 | shootings | 2 | 121436 | 24 | 14.203 | 8550.0 |