History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"predictions"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
456 | 2024-04-27 15:36:40 | predictions | 4 | 148819 | 324 | 13.110 | 11351.6 |
455 | 2024-04-27 03:34:42 | predictions | 4 | 148819 | 324 | 27.046 | 5502.4 |
454 | 2024-04-27 03:34:46 | predictions | 2 | 86808 | 14 | 8.703 | 9974.5 |
453 | 2024-04-27 03:22:29 | predictions | 1 | 49908 | 3 | 0.903 | 55269.1 |
452 | 2024-04-24 13:54:58 | predictions | 3 | 121633 | 73 | 11.330 | 10735.5 |
451 | 2024-04-23 10:35:07 | predictions | 3 | 121633 | 73 | 16.313 | 7456.2 |
450 | 2024-04-22 13:19:09 | predictions | 3 | 121633 | 73 | 14.923 | 8150.7 |
449 | 2024-04-21 08:12:55 | predictions | 3 | 121633 | 73 | 24.470 | 4970.7 |
448 | 2024-04-21 08:12:28 | predictions | 2 | 86808 | 14 | 5.966 | 14550.5 |
447 | 2024-04-21 04:14:44 | predictions | 3 | 121633 | 73 | 15.376 | 7910.6 |
446 | 2024-04-21 04:14:46 | predictions | 2 | 86808 | 14 | 8.313 | 10442.4 |
445 | 2024-04-21 04:12:03 | predictions | 1 | 49908 | 3 | 1.110 | 44962.2 |
444 | 2024-04-18 16:14:10 | predictions | 4 | 148819 | 324 | 38.626 | 3852.8 |
443 | 2024-04-18 06:57:06 | predictions | 4 | 148819 | 324 | 36.500 | 4077.2 |
442 | 2024-04-17 16:33:51 | predictions | 4 | 148819 | 324 | 26.783 | 5556.5 |
441 | 2024-04-17 16:14:55 | predictions | 4 | 148819 | 324 | 40.470 | 3677.3 |
440 | 2024-04-17 16:15:01 | predictions | 2 | 86808 | 14 | 3.810 | 22784.3 |
439 | 2024-04-17 16:09:49 | predictions | 1 | 49908 | 3 | 1.123 | 44441.7 |
438 | 2024-03-22 16:53:38 | predictions | 3 | 121633 | 73 | 21.750 | 5592.3 |
437 | 2024-03-22 00:04:45 | predictions | 4 | 148819 | 324 | 34.456 | 4319.1 |
436 | 2024-03-22 00:04:42 | predictions | 3 | 121633 | 73 | 10.516 | 11566.5 |
435 | 2024-03-22 00:04:43 | predictions | 2 | 86808 | 14 | 8.393 | 10342.9 |
434 | 2024-03-21 22:33:54 | predictions | 1 | 49908 | 3 | 0.843 | 59202.8 |
433 | 2024-03-16 15:31:00 | predictions | 4 | 148819 | 324 | 14.830 | 10035.0 |
432 | 2024-03-16 07:30:14 | predictions | 4 | 148819 | 324 | 24.986 | 5956.1 |
431 | 2024-03-16 07:29:09 | predictions | 4 | 148819 | 324 | 12.330 | 12069.7 |
430 | 2024-03-16 05:28:00 | predictions | 4 | 148819 | 324 | 35.380 | 4206.3 |
429 | 2024-03-16 05:28:09 | predictions | 2 | 86808 | 14 | 9.296 | 9338.2 |
428 | 2024-03-16 05:28:02 | predictions | 3 | 121633 | 73 | 13.220 | 9200.7 |
427 | 2024-03-16 05:26:39 | predictions | 1 | 49908 | 3 | 0.983 | 50771.1 |
426 | 2024-03-16 03:29:53 | predictions | 1 | 49908 | 3 | 2.013 | 24792.8 |
425 | 2024-03-13 17:19:10 | predictions | 1 | 49908 | 3 | 0.860 | 58032.6 |
424 | 2024-02-21 02:40:47 | predictions | 1 | 49908 | 3 | 0.966 | 51664.6 |
423 | 2024-02-19 02:11:29 | predictions | 2 | 86808 | 14 | 5.766 | 15055.2 |
422 | 2024-02-18 19:36:55 | predictions | 1 | 49908 | 3 | 0.953 | 52369.4 |
421 | 2024-02-18 17:02:54 | predictions | 2 | 86808 | 14 | 2.140 | 40564.5 |
420 | 2024-02-13 10:48:26 | predictions | 3 | 121633 | 73 | 17.190 | 7075.8 |
419 | 2024-02-13 10:03:04 | predictions | 2 | 86808 | 14 | 2.953 | 29396.5 |
418 | 2024-02-13 09:08:15 | predictions | 2 | 86808 | 14 | 2.313 | 37530.5 |
417 | 2024-02-13 09:08:03 | predictions | 3 | 121633 | 73 | 6.970 | 17450.9 |
416 | 2024-02-13 08:57:46 | predictions | 1 | 49908 | 3 | 0.826 | 60421.3 |
415 | 2024-02-12 12:24:53 | predictions | 2 | 86808 | 14 | 6.796 | 12773.4 |
414 | 2024-02-12 09:18:06 | predictions | 1 | 49908 | 3 | 0.766 | 65154.0 |
413 | 2024-02-12 00:10:44 | predictions | 3 | 121633 | 73 | 11.003 | 11054.5 |
412 | 2024-02-12 00:07:39 | predictions | 4 | 148819 | 324 | 11.783 | 12630.0 |
411 | 2024-02-10 21:55:48 | predictions | 2 | 86808 | 14 | 5.843 | 14856.8 |
410 | 2024-02-10 15:33:55 | predictions | 3 | 121633 | 73 | 12.516 | 9718.2 |
409 | 2024-02-10 10:56:12 | predictions | 3 | 121633 | 73 | 7.436 | 16357.3 |
408 | 2024-02-10 05:53:27 | predictions | 4 | 148819 | 324 | 18.703 | 7957.0 |
407 | 2024-02-10 05:53:24 | predictions | 3 | 121633 | 73 | 10.936 | 11122.3 |
406 | 2024-02-10 05:53:24 | predictions | 2 | 86808 | 14 | 5.890 | 14738.2 |
405 | 2024-02-08 14:47:32 | predictions | 4 | 148819 | 324 | 22.596 | 6586.1 |
404 | 2024-02-07 07:46:23 | predictions | 1 | 49908 | 3 | 0.876 | 56972.6 |
403 | 2024-02-02 23:59:35 | predictions | 1 | 49908 | 3 | 0.843 | 59202.8 |
402 | 2023-12-24 09:41:56 | predictions | 4 | 148819 | 324 | 9.330 | 15950.6 |
401 | 2023-12-23 17:58:56 | predictions | 3 | 121633 | 73 | 4.983 | 24409.6 |
400 | 2023-12-23 17:58:57 | predictions | 2 | 86808 | 14 | 2.560 | 33909.4 |
399 | 2023-12-06 09:46:38 | predictions | 4 | 148819 | 324 | 10.143 | 14672.1 |
398 | 2023-12-06 09:46:36 | predictions | 3 | 121633 | 73 | 6.860 | 17730.8 |
397 | 2023-12-06 09:46:32 | predictions | 2 | 86808 | 14 | 2.546 | 34095.8 |
396 | 2023-11-26 11:00:28 | predictions | 1 | 49908 | 3 | 0.796 | 62698.5 |
395 | 2023-11-17 09:20:27 | predictions | 2 | 86808 | 14 | 2.436 | 35635.5 |
394 | 2023-11-12 18:29:16 | predictions | 1 | 49908 | 3 | 0.766 | 65154.0 |
393 | 2023-11-10 11:40:58 | predictions | 1 | 49908 | 3 | 0.826 | 60421.3 |
392 | 2023-11-07 04:36:25 | predictions | 1 | 49908 | 3 | 0.876 | 56972.6 |
391 | 2023-11-04 23:30:06 | predictions | 1 | 49908 | 3 | 0.826 | 60421.3 |
390 | 2023-10-12 10:06:24 | predictions | 1 | 49908 | 3 | 0.780 | 63984.6 |
389 | 2023-10-11 18:41:24 | predictions | 1 | 49908 | 3 | 0.876 | 56972.6 |
388 | 2023-10-04 03:34:12 | predictions | 1 | 49908 | 3 | 0.780 | 63984.6 |
387 | 2023-09-24 00:09:22 | predictions | 1 | 49908 | 3 | 0.783 | 63739.5 |
386 | 2023-09-20 19:58:27 | predictions | 1 | 49908 | 3 | 0.936 | 53320.5 |
385 | 2023-09-11 10:45:49 | predictions | 1 | 49908 | 3 | 0.843 | 59202.8 |
384 | 2023-08-19 02:38:17 | predictions | 2 | 86808 | 14 | 2.470 | 35144.9 |
383 | 2023-06-17 12:58:42 | predictions | 1 | 49908 | 3 | 0.763 | 65410.2 |
382 | 2023-06-12 04:17:30 | predictions | 1 | 49908 | 3 | 0.766 | 65154.0 |
381 | 2023-06-08 20:59:51 | predictions | 1 | 49908 | 3 | 0.766 | 65154.0 |
380 | 2023-05-03 15:12:33 | predictions | 2 | 86808 | 14 | 2.123 | 40889.3 |
379 | 2023-03-31 03:09:53 | predictions | 1 | 49908 | 3 | 0.813 | 61387.5 |
378 | 2023-02-13 23:23:48 | predictions | 1 | 49908 | 3 | 0.906 | 55086.1 |
377 | 2023-02-12 06:26:08 | predictions | 2 | 86808 | 14 | 2.216 | 39173.3 |
376 | 2023-01-13 23:15:25 | predictions | 1 | 49908 | 3 | 0.843 | 59202.8 |
375 | 2022-11-23 12:29:29 | predictions | 2 | 86808 | 14 | 2.106 | 41219.4 |
374 | 2022-11-03 15:58:57 | predictions | 1 | 49908 | 3 | 0.796 | 62698.5 |
373 | 2022-10-16 20:45:54 | predictions | 1 | 49908 | 3 | 0.756 | 66015.9 |
372 | 2022-06-24 02:11:11 | predictions | 1 | 49908 | 3 | 0.796 | 62698.5 |
371 | 2022-06-23 02:54:07 | predictions | 1 | 49908 | 3 | 0.766 | 65154.0 |
370 | 2022-06-15 06:01:40 | predictions | 1 | 49908 | 3 | 0.780 | 63984.6 |
369 | 2022-05-18 18:39:08 | predictions | 1 | 49908 | 3 | 0.796 | 62698.5 |
368 | 2022-05-08 23:25:03 | predictions | 1 | 49908 | 3 | 0.766 | 65154.0 |
367 | 2022-05-06 23:44:00 | predictions | 2 | 86808 | 14 | 2.220 | 39102.7 |
366 | 2022-02-23 23:03:44 | predictions | 1 | 49908 | 3 | 0.953 | 52369.4 |
365 | 2022-02-14 06:58:23 | predictions | 1 | 49908 | 3 | 0.780 | 63984.6 |
364 | 2022-02-10 17:19:40 | predictions | 1 | 49908 | 3 | 0.923 | 54071.5 |
363 | 2021-12-08 20:27:03 | predictions | 1 | 49908 | 3 | 0.923 | 54071.5 |
362 | 2021-12-06 17:59:10 | predictions | 1 | 49908 | 3 | 0.873 | 57168.4 |
361 | 2021-10-28 15:51:30 | predictions | 1 | 49908 | 3 | 0.920 | 54247.8 |
360 | 2021-10-24 03:12:27 | predictions | 1 | 49908 | 3 | 0.830 | 60130.1 |
359 | 2021-08-20 09:58:59 | predictions | 1 | 49908 | 3 | 0.796 | 62698.5 |
358 | 2021-07-25 10:02:57 | predictions | 1 | 49908 | 3 | 0.766 | 65154.0 |
357 | 2021-07-16 21:38:23 | predictions | 1 | 49908 | 3 | 0.763 | 65410.2 |