History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sporting"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
482 | 2024-04-27 14:53:57 | sporting | 1 | 82945 | 10 | 2.313 | 35860.4 |
481 | 2024-04-01 14:15:16 | sporting | 2 | 121059 | 82 | 11.483 | 10542.5 |
480 | 2024-03-31 17:56:05 | sporting | 1 | 82945 | 10 | 2.796 | 29665.6 |
479 | 2024-03-31 05:21:48 | sporting | 3 | 146162 | 584 | 25.423 | 5749.2 |
478 | 2024-03-31 05:21:42 | sporting | 2 | 121059 | 82 | 8.736 | 13857.5 |
477 | 2024-03-31 03:38:03 | sporting | 1 | 82945 | 10 | 1.610 | 51518.6 |
476 | 2024-03-05 21:44:26 | sporting | 3 | 146162 | 584 | 8.500 | 17195.5 |
475 | 2024-03-05 02:48:09 | sporting | 3 | 146162 | 584 | 21.453 | 6813.1 |
474 | 2024-03-04 09:35:46 | sporting | 3 | 146162 | 584 | 17.050 | 8572.6 |
473 | 2024-03-02 17:53:12 | sporting | 3 | 146162 | 584 | 7.203 | 20291.8 |
472 | 2024-03-02 14:37:51 | sporting | 3 | 146162 | 584 | 15.000 | 9744.1 |
471 | 2024-03-02 10:02:05 | sporting | 3 | 146162 | 584 | 7.626 | 19166.3 |
470 | 2024-03-02 04:02:02 | sporting | 1 | 82945 | 10 | 1.596 | 51970.6 |
469 | 2024-03-01 02:37:13 | sporting | 1 | 82945 | 10 | 1.500 | 55296.7 |
468 | 2024-02-05 05:51:54 | sporting | 2 | 121059 | 82 | 4.720 | 25648.1 |
467 | 2024-02-05 05:51:29 | sporting | 2 | 121059 | 82 | 3.766 | 32145.2 |
466 | 2024-02-04 17:49:11 | sporting | 2 | 121059 | 82 | 8.123 | 14903.2 |
465 | 2024-02-04 06:56:53 | sporting | 2 | 121059 | 82 | 6.546 | 18493.6 |
464 | 2024-01-30 16:35:44 | sporting | 1 | 82945 | 10 | 1.470 | 56425.2 |
463 | 2024-01-20 03:32:17 | sporting | 1 | 82945 | 10 | 1.453 | 57085.3 |
462 | 2024-01-17 06:12:22 | sporting | 3 | 146162 | 584 | 6.470 | 22590.7 |
461 | 2024-01-14 21:27:54 | sporting | 1 | 82945 | 10 | 1.436 | 57761.1 |
460 | 2023-12-15 05:44:06 | sporting | 1 | 82945 | 10 | 1.470 | 56425.2 |
459 | 2023-12-09 15:20:25 | sporting | 1 | 82945 | 10 | 1.470 | 56425.2 |
458 | 2023-12-03 05:29:26 | sporting | 1 | 82945 | 10 | 1.296 | 64000.8 |
457 | 2023-11-21 19:26:58 | sporting | 3 | 146162 | 584 | 7.546 | 19369.5 |
456 | 2023-11-11 16:09:02 | sporting | 2 | 121059 | 82 | 3.563 | 33976.7 |
455 | 2023-11-11 14:01:01 | sporting | 1 | 82945 | 10 | 1.280 | 64800.8 |
454 | 2023-11-09 02:16:54 | sporting | 1 | 82945 | 10 | 1.280 | 64800.8 |
453 | 2023-11-06 02:26:10 | sporting | 1 | 82945 | 10 | 1.280 | 64800.8 |
452 | 2023-11-05 18:09:41 | sporting | 1 | 82945 | 10 | 1.436 | 57761.1 |
451 | 2023-11-04 03:03:34 | sporting | 3 | 146162 | 584 | 8.876 | 16467.1 |
450 | 2023-10-31 22:00:30 | sporting | 3 | 146162 | 584 | 9.033 | 16180.9 |
449 | 2023-10-21 03:31:36 | sporting | 3 | 146162 | 584 | 7.313 | 19986.6 |
448 | 2023-10-16 11:59:16 | sporting | 3 | 146162 | 584 | 7.250 | 20160.3 |
447 | 2023-10-09 01:22:15 | sporting | 3 | 146162 | 584 | 6.436 | 22710.1 |
446 | 2023-09-11 14:03:40 | sporting | 3 | 146162 | 584 | 7.000 | 20880.3 |
445 | 2023-09-11 14:03:41 | sporting | 2 | 121059 | 82 | 5.203 | 23267.2 |
444 | 2023-09-10 12:04:07 | sporting | 1 | 82945 | 10 | 1.280 | 64800.8 |
443 | 2023-08-29 21:46:34 | sporting | 1 | 82945 | 10 | 1.283 | 64649.3 |
442 | 2023-08-23 11:14:02 | sporting | 3 | 146162 | 584 | 6.470 | 22590.7 |
441 | 2023-08-14 07:20:41 | sporting | 2 | 121059 | 82 | 3.173 | 38152.9 |
440 | 2023-08-03 22:35:42 | sporting | 3 | 146162 | 584 | 9.503 | 15380.6 |
439 | 2023-07-17 00:07:11 | sporting | 1 | 82945 | 10 | 2.970 | 27927.6 |
438 | 2023-06-02 17:59:47 | sporting | 1 | 82945 | 10 | 1.263 | 65673.0 |
437 | 2023-05-08 03:19:50 | sporting | 3 | 146162 | 584 | 6.310 | 23163.5 |
436 | 2023-04-28 17:16:55 | sporting | 2 | 121059 | 82 | 3.283 | 36874.5 |
435 | 2023-03-29 01:52:36 | sporting | 1 | 82945 | 10 | 1.326 | 62552.8 |
434 | 2023-03-24 21:39:36 | sporting | 1 | 82945 | 10 | 1.343 | 61761.0 |
433 | 2023-03-13 04:53:16 | sporting | 3 | 146162 | 584 | 7.610 | 19206.6 |
432 | 2023-02-15 15:27:29 | sporting | 3 | 146162 | 584 | 6.220 | 23498.7 |
431 | 2023-02-05 00:25:59 | sporting | 2 | 121059 | 82 | 3.673 | 32959.2 |
430 | 2023-01-09 02:11:32 | sporting | 1 | 82945 | 10 | 1.300 | 63803.8 |
429 | 2022-12-10 12:25:35 | sporting | 1 | 82945 | 10 | 1.470 | 56425.2 |
428 | 2022-11-26 15:32:58 | sporting | 3 | 146162 | 584 | 6.330 | 23090.4 |
427 | 2022-11-18 03:52:26 | sporting | 2 | 121059 | 82 | 3.186 | 37997.2 |
426 | 2022-10-08 08:29:29 | sporting | 1 | 82945 | 10 | 1.360 | 60989.0 |
425 | 2022-08-07 00:48:21 | sporting | 1 | 82945 | 10 | 1.296 | 64000.8 |
424 | 2022-08-03 16:25:47 | sporting | 1 | 82945 | 10 | 1.296 | 64000.8 |
423 | 2022-07-17 22:54:35 | sporting | 1 | 82945 | 10 | 1.280 | 64800.8 |
422 | 2022-07-03 15:46:30 | sporting | 1 | 82945 | 10 | 1.343 | 61761.0 |
421 | 2022-07-03 02:42:25 | sporting | 1 | 82945 | 10 | 1.280 | 64800.8 |
420 | 2022-06-23 09:20:30 | sporting | 2 | 121059 | 82 | 3.280 | 36908.2 |
419 | 2022-06-21 04:27:14 | sporting | 2 | 121059 | 82 | 3.390 | 35710.6 |
418 | 2022-06-08 22:54:40 | sporting | 1 | 82945 | 10 | 1.313 | 63172.1 |
417 | 2022-05-25 03:58:10 | sporting | 1 | 82945 | 10 | 1.326 | 62552.8 |
416 | 2022-04-27 19:09:06 | sporting | 3 | 146162 | 584 | 7.986 | 18302.3 |
415 | 2022-04-22 06:41:08 | sporting | 3 | 146162 | 584 | 6.436 | 22710.1 |
414 | 2022-04-02 06:47:21 | sporting | 1 | 82945 | 10 | 1.376 | 60279.8 |
413 | 2022-03-29 19:38:55 | sporting | 1 | 82945 | 10 | 1.610 | 51518.6 |
412 | 2022-02-10 20:32:06 | sporting | 1 | 82945 | 10 | 1.346 | 61623.3 |
411 | 2022-02-02 16:08:26 | sporting | 2 | 121059 | 82 | 4.123 | 29361.9 |
410 | 2021-12-08 23:43:14 | sporting | 1 | 82945 | 10 | 1.343 | 61761.0 |
409 | 2021-12-06 14:20:18 | sporting | 1 | 82945 | 10 | 1.483 | 55930.5 |
408 | 2021-10-13 22:49:22 | sporting | 1 | 82945 | 10 | 1.280 | 64800.8 |
407 | 2021-09-22 22:11:31 | sporting | 1 | 82945 | 10 | 1.483 | 55930.5 |
406 | 2021-08-26 01:12:05 | sporting | 1 | 82945 | 10 | 1.263 | 65673.0 |
405 | 2021-07-09 05:48:04 | sporting | 1 | 82945 | 10 | 1.390 | 59672.7 |
404 | 2021-05-29 15:35:45 | sporting | 3 | 146162 | 584 | 7.470 | 19566.5 |
403 | 2021-05-25 05:55:52 | sporting | 1 | 82945 | 10 | 1.453 | 57085.3 |
402 | 2021-03-26 18:33:26 | sporting | 1 | 82945 | 10 | 1.296 | 64000.8 |
401 | 2021-02-19 17:11:45 | sporting | 1 | 82945 | 10 | 1.313 | 63172.1 |
400 | 2021-01-10 13:29:57 | sporting | 3 | 146162 | 584 | 7.000 | 20880.3 |
399 | 2020-12-11 16:09:39 | sporting | 1 | 82945 | 10 | 1.296 | 64000.8 |
398 | 2020-12-05 16:21:48 | sporting | 3 | 146162 | 584 | 6.546 | 22328.4 |
397 | 2020-11-18 21:09:49 | sporting | 1 | 82945 | 10 | 1.326 | 62552.8 |
396 | 2020-11-16 01:53:00 | sporting | 1 | 82945 | 10 | 1.280 | 64800.8 |
395 | 2020-10-31 21:54:17 | sporting | 3 | 146162 | 584 | 7.110 | 20557.2 |
394 | 2020-10-31 07:05:33 | sporting | 1 | 82945 | 10 | 1.436 | 57761.1 |
393 | 2020-09-28 19:42:41 | sporting | 3 | 146162 | 584 | 6.343 | 23043.0 |
392 | 2020-09-25 22:36:14 | sporting | 1 | 82945 | 10 | 1.313 | 63172.1 |
391 | 2020-09-07 04:11:19 | sporting | 1 | 82945 | 10 | 1.420 | 58412.0 |
390 | 2020-09-07 00:48:53 | sporting | 3 | 146162 | 584 | 6.500 | 22486.5 |
389 | 2020-09-02 22:38:40 | sporting | 3 | 146162 | 584 | 7.563 | 19325.9 |
388 | 2020-09-02 02:31:57 | sporting | 3 | 146162 | 584 | 6.546 | 22328.4 |
387 | 2020-08-26 15:52:31 | sporting | 1 | 82945 | 10 | 1.343 | 61761.0 |
386 | 2020-08-25 11:50:44 | sporting | 3 | 146162 | 584 | 7.030 | 20791.2 |
385 | 2020-08-23 18:12:04 | sporting | 1 | 82945 | 10 | 1.420 | 58412.0 |
384 | 2020-08-20 22:50:24 | sporting | 1 | 82945 | 10 | 1.313 | 63172.1 |
383 | 2020-08-17 00:45:48 | sporting | 1 | 82945 | 10 | 1.296 | 64000.8 |