History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"detectives"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 410 | 2025-11-05 00:26:03 | detectives | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 409 | 2025-11-05 00:09:33 | detectives | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 408 | 2025-10-18 21:32:36 | detectives | 1 | 67641 | 3 | 1.236 | 54725.7 |
| 407 | 2025-10-18 02:19:23 | detectives | 1 | 67641 | 3 | 2.216 | 30523.9 |
| 406 | 2025-10-16 18:44:22 | detectives | 4 | 161450 | 273 | 11.186 | 14433.2 |
| 405 | 2025-10-14 03:45:14 | detectives | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 404 | 2025-09-18 15:07:54 | detectives | 4 | 161450 | 273 | 11.046 | 14616.2 |
| 403 | 2025-09-18 07:20:44 | detectives | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 402 | 2025-09-15 17:09:18 | detectives | 2 | 108824 | 9 | 5.283 | 20598.9 |
| 401 | 2025-09-15 10:46:45 | detectives | 3 | 140603 | 48 | 6.596 | 21316.4 |
| 400 | 2025-09-14 05:32:48 | detectives | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 399 | 2025-08-23 23:56:46 | detectives | 3 | 140603 | 48 | 11.813 | 11902.4 |
| 398 | 2025-08-20 22:25:12 | detectives | 1 | 67641 | 3 | 2.673 | 25305.3 |
| 397 | 2025-08-19 10:34:11 | detectives | 1 | 67641 | 3 | 2.830 | 23901.4 |
| 396 | 2025-08-10 10:04:57 | detectives | 1 | 67641 | 3 | 2.656 | 25467.2 |
| 395 | 2025-08-05 10:27:58 | detectives | 3 | 140603 | 48 | 20.266 | 6937.9 |
| 394 | 2025-08-05 07:10:20 | detectives | 1 | 67641 | 3 | 4.530 | 14931.8 |
| 393 | 2025-08-01 04:08:02 | detectives | 3 | 140603 | 48 | 19.826 | 7091.8 |
| 392 | 2025-07-31 01:06:13 | detectives | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 391 | 2025-07-20 15:15:36 | detectives | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 390 | 2025-07-02 20:27:31 | detectives | 1 | 67641 | 3 | 4.013 | 16855.5 |
| 389 | 2025-06-28 23:59:39 | detectives | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 388 | 2025-06-21 00:23:12 | detectives | 1 | 67641 | 3 | 5.393 | 12542.4 |
| 387 | 2025-06-18 02:27:25 | detectives | 1 | 67641 | 3 | 6.436 | 10509.8 |
| 386 | 2025-06-15 21:11:11 | detectives | 1 | 67641 | 3 | 6.923 | 9770.5 |
| 385 | 2025-06-01 08:47:40 | detectives | 1 | 67641 | 3 | 5.686 | 11896.1 |
| 384 | 2025-05-30 08:54:17 | detectives | 2 | 108824 | 9 | 11.326 | 9608.3 |
| 383 | 2025-05-27 22:14:11 | detectives | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 382 | 2025-05-27 00:49:42 | detectives | 3 | 140603 | 48 | 38.190 | 3681.7 |
| 381 | 2025-05-26 15:25:21 | detectives | 2 | 108824 | 9 | 10.296 | 10569.5 |
| 380 | 2025-05-26 08:49:42 | detectives | 3 | 140603 | 48 | 33.096 | 4248.3 |
| 379 | 2025-05-25 00:35:02 | detectives | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 378 | 2025-05-24 04:44:52 | detectives | 3 | 140603 | 48 | 31.970 | 4398.0 |
| 377 | 2025-05-22 16:15:53 | detectives | 3 | 140603 | 48 | 38.093 | 3691.0 |
| 376 | 2025-05-18 10:26:29 | detectives | 3 | 140603 | 48 | 30.923 | 4546.9 |
| 375 | 2025-05-18 08:06:04 | detectives | 3 | 140603 | 48 | 58.316 | 2411.1 |
| 374 | 2025-05-06 00:07:13 | detectives | 1 | 67641 | 3 | 4.343 | 15574.7 |
| 373 | 2025-05-04 05:29:58 | detectives | 1 | 67641 | 3 | 3.030 | 22323.8 |
| 372 | 2025-05-02 12:40:59 | detectives | 1 | 67641 | 3 | 4.126 | 16393.8 |
| 371 | 2025-04-28 09:07:03 | detectives | 1 | 67641 | 3 | 2.546 | 26567.6 |
| 370 | 2025-04-23 23:00:13 | detectives | 1 | 67641 | 3 | 5.983 | 11305.5 |
| 369 | 2025-04-23 01:00:27 | detectives | 1 | 67641 | 3 | 2.343 | 28869.4 |
| 368 | 2025-04-19 16:41:07 | detectives | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 367 | 2025-04-04 00:06:29 | detectives | 1 | 67641 | 3 | 8.220 | 8228.8 |
| 366 | 2025-03-29 18:01:09 | detectives | 1 | 67641 | 3 | 5.093 | 13281.2 |
| 365 | 2025-03-29 06:00:27 | detectives | 1 | 67641 | 3 | 5.593 | 12093.9 |
| 364 | 2025-03-20 22:35:43 | detectives | 3 | 140603 | 48 | 28.890 | 4866.8 |
| 363 | 2025-03-20 02:20:56 | detectives | 1 | 67641 | 3 | 5.843 | 11576.4 |
| 362 | 2025-03-17 21:05:50 | detectives | 3 | 140603 | 48 | 30.003 | 4686.3 |
| 361 | 2025-03-13 12:50:50 | detectives | 3 | 140603 | 48 | 46.396 | 3030.5 |
| 360 | 2025-03-03 13:28:14 | detectives | 3 | 140603 | 48 | 18.516 | 7593.6 |
| 359 | 2025-03-03 13:28:06 | detectives | 2 | 108824 | 9 | 7.953 | 13683.4 |
| 358 | 2025-03-03 13:27:31 | detectives | 3 | 140603 | 48 | 30.003 | 4686.3 |
| 357 | 2025-03-03 12:39:28 | detectives | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 356 | 2025-02-25 16:38:26 | detectives | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 355 | 2025-02-12 15:30:59 | detectives | 3 | 140603 | 48 | 49.516 | 2839.5 |
| 354 | 2025-02-12 15:30:58 | detectives | 2 | 108824 | 9 | 17.550 | 6200.8 |
| 353 | 2025-02-12 14:00:11 | detectives | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 352 | 2025-01-30 11:02:00 | detectives | 2 | 108824 | 9 | 18.683 | 5824.8 |
| 351 | 2025-01-30 10:59:40 | detectives | 1 | 67641 | 3 | 4.623 | 14631.4 |
| 350 | 2025-01-30 03:10:27 | detectives | 3 | 140603 | 48 | 32.516 | 4324.1 |
| 349 | 2025-01-29 05:15:40 | detectives | 3 | 140603 | 48 | 27.276 | 5154.8 |
| 348 | 2025-01-27 10:04:18 | detectives | 3 | 140603 | 48 | 33.400 | 4209.7 |
| 347 | 2025-01-26 23:33:31 | detectives | 1 | 67641 | 3 | 1.200 | 56367.5 |
| 346 | 2025-01-21 08:16:26 | detectives | 1 | 67641 | 3 | 5.546 | 12196.4 |
| 345 | 2025-01-10 23:55:57 | detectives | 3 | 140603 | 48 | 35.876 | 3919.1 |
| 344 | 2025-01-10 23:55:57 | detectives | 2 | 108824 | 9 | 13.826 | 7871.0 |
| 343 | 2025-01-09 04:28:08 | detectives | 2 | 108824 | 9 | 21.593 | 5039.8 |
| 342 | 2025-01-09 04:27:17 | detectives | 3 | 140603 | 48 | 30.816 | 4562.7 |
| 341 | 2025-01-09 04:25:46 | detectives | 1 | 67641 | 3 | 5.893 | 11478.2 |
| 340 | 2025-01-02 18:53:02 | detectives | 3 | 140603 | 48 | 30.676 | 4583.5 |
| 339 | 2025-01-02 18:53:02 | detectives | 2 | 108824 | 9 | 15.250 | 7136.0 |
| 338 | 2024-12-24 11:33:45 | detectives | 3 | 140603 | 48 | 32.753 | 4292.8 |
| 337 | 2024-12-18 21:51:01 | detectives | 3 | 140603 | 48 | 32.656 | 4305.6 |
| 336 | 2024-12-18 21:51:01 | detectives | 2 | 108824 | 9 | 10.453 | 10410.8 |
| 335 | 2024-12-18 21:49:40 | detectives | 1 | 67641 | 3 | 5.123 | 13203.4 |
| 334 | 2024-12-04 05:40:45 | detectives | 1 | 67641 | 3 | 5.500 | 12298.4 |
| 333 | 2024-12-04 02:31:59 | detectives | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 332 | 2024-11-10 04:41:01 | detectives | 1 | 67641 | 3 | 2.923 | 23141.0 |
| 331 | 2024-11-08 07:12:27 | detectives | 1 | 67641 | 3 | 3.003 | 22524.5 |
| 330 | 2024-11-05 09:02:40 | detectives | 3 | 140603 | 48 | 37.380 | 3761.4 |
| 329 | 2024-11-02 01:57:24 | detectives | 3 | 140603 | 48 | 21.550 | 6524.5 |
| 328 | 2024-11-02 01:57:21 | detectives | 1 | 67641 | 3 | 2.750 | 24596.7 |
| 327 | 2024-11-02 01:51:16 | detectives | 2 | 108824 | 9 | 15.080 | 7216.4 |
| 326 | 2024-11-01 15:01:30 | detectives | 3 | 140603 | 48 | 34.076 | 4126.2 |
| 325 | 2024-10-31 04:31:07 | detectives | 3 | 140603 | 48 | 39.533 | 3556.6 |
| 324 | 2024-10-31 04:31:03 | detectives | 3 | 140603 | 48 | 35.673 | 3941.4 |
| 323 | 2024-10-31 04:31:05 | detectives | 2 | 108824 | 9 | 14.940 | 7284.1 |
| 322 | 2024-10-31 04:27:25 | detectives | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 321 | 2024-10-09 07:00:08 | detectives | 1 | 67641 | 3 | 5.813 | 11636.2 |
| 320 | 2024-10-01 18:17:30 | detectives | 3 | 140603 | 48 | 56.303 | 2497.3 |
| 319 | 2024-09-30 02:17:19 | detectives | 2 | 108824 | 9 | 25.190 | 4320.1 |
| 318 | 2024-09-30 02:14:59 | detectives | 1 | 67641 | 3 | 4.563 | 14823.8 |
| 317 | 2024-09-29 10:56:53 | detectives | 3 | 140603 | 48 | 63.256 | 2222.8 |
| 316 | 2024-09-29 04:02:27 | detectives | 2 | 108824 | 9 | 12.566 | 8660.2 |
| 315 | 2024-09-29 03:18:57 | detectives | 1 | 67641 | 3 | 7.563 | 8943.7 |
| 314 | 2024-09-27 04:31:55 | detectives | 3 | 140603 | 48 | 53.360 | 2635.0 |
| 313 | 2024-09-25 22:46:12 | detectives | 4 | 161450 | 273 | 112.460 | 1435.6 |
| 312 | 2024-09-25 19:36:05 | detectives | 4 | 161450 | 273 | 95.023 | 1699.1 |
| 311 | 2024-09-25 19:36:08 | detectives | 2 | 108824 | 9 | 45.643 | 2384.2 |