History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"metros"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
487 | 2024-04-25 16:07:53 | metros | 2 | 82551 | 58 | 2.640 | 31269.3 |
486 | 2024-04-25 16:07:22 | metros | 1 | 48755 | 4 | 0.923 | 52822.3 |
485 | 2024-04-25 16:05:12 | metros | 2 | 82551 | 58 | 2.623 | 31472.0 |
484 | 2024-04-25 16:04:24 | metros | 1 | 48755 | 4 | 0.953 | 51159.5 |
483 | 2024-04-04 23:13:54 | metros | 2 | 82551 | 58 | 4.140 | 19939.9 |
482 | 2024-04-04 19:45:53 | metros | 3 | 112716 | 752 | 21.156 | 5327.9 |
481 | 2024-04-04 09:51:34 | metros | 2 | 82551 | 58 | 2.656 | 31080.9 |
480 | 2024-04-04 09:51:32 | metros | 1 | 48755 | 4 | 1.750 | 27860.0 |
479 | 2024-04-04 09:51:12 | metros | 3 | 112716 | 752 | 5.906 | 19085.0 |
478 | 2024-04-03 19:44:19 | metros | 3 | 112716 | 752 | 11.766 | 9579.8 |
477 | 2024-04-03 12:51:19 | metros | 3 | 112716 | 752 | 10.016 | 11253.6 |
476 | 2024-04-03 12:51:18 | metros | 2 | 82551 | 58 | 5.966 | 13836.9 |
475 | 2024-04-03 08:38:16 | metros | 3 | 112716 | 752 | 13.313 | 8466.6 |
474 | 2024-04-03 08:38:16 | metros | 2 | 82551 | 58 | 7.796 | 10588.9 |
473 | 2024-04-03 08:38:05 | metros | 1 | 48755 | 4 | 2.826 | 17252.3 |
472 | 2024-03-10 23:48:11 | metros | 1 | 48755 | 4 | 1.906 | 25579.7 |
471 | 2024-03-02 18:03:00 | metros | 1 | 48755 | 4 | 2.860 | 17047.2 |
470 | 2024-02-29 00:56:28 | metros | 2 | 82551 | 58 | 2.593 | 31836.1 |
469 | 2024-02-29 00:56:00 | metros | 3 | 112716 | 752 | 8.813 | 12789.7 |
468 | 2024-02-28 14:13:01 | metros | 2 | 82551 | 58 | 2.406 | 34310.5 |
467 | 2024-02-28 14:12:38 | metros | 3 | 112716 | 752 | 5.986 | 18829.9 |
466 | 2024-02-27 09:12:41 | metros | 3 | 112716 | 752 | 9.330 | 12081.0 |
465 | 2024-02-27 04:46:18 | metros | 1 | 48755 | 4 | 3.563 | 13683.7 |
464 | 2024-02-26 21:38:26 | metros | 1 | 48755 | 4 | 0.856 | 56956.8 |
463 | 2024-02-26 05:35:59 | metros | 3 | 112716 | 752 | 16.936 | 6655.4 |
462 | 2024-02-26 05:36:00 | metros | 2 | 82551 | 58 | 5.936 | 13906.8 |
461 | 2024-02-26 05:35:51 | metros | 1 | 48755 | 4 | 2.110 | 23106.6 |
460 | 2024-02-04 15:21:20 | metros | 1 | 48755 | 4 | 0.843 | 57835.1 |
459 | 2024-01-30 13:23:41 | metros | 1 | 48755 | 4 | 0.733 | 66514.3 |
458 | 2024-01-26 14:47:46 | metros | 2 | 82551 | 58 | 2.516 | 32810.4 |
457 | 2023-12-19 14:29:33 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
456 | 2023-12-13 22:47:57 | metros | 1 | 48755 | 4 | 0.846 | 57630.0 |
455 | 2023-12-09 12:22:11 | metros | 3 | 112716 | 752 | 5.440 | 20719.9 |
454 | 2023-12-09 12:22:12 | metros | 2 | 82551 | 58 | 2.516 | 32810.4 |
453 | 2023-12-08 04:55:07 | metros | 2 | 82551 | 58 | 4.846 | 17034.9 |
452 | 2023-12-04 17:52:36 | metros | 3 | 112716 | 752 | 5.563 | 20261.7 |
451 | 2023-12-01 02:20:57 | metros | 3 | 112716 | 752 | 5.250 | 21469.7 |
450 | 2023-12-01 02:20:56 | metros | 2 | 82551 | 58 | 2.263 | 36478.6 |
449 | 2023-11-27 06:36:18 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
448 | 2023-11-16 14:58:36 | metros | 1 | 48755 | 4 | 0.766 | 63648.8 |
447 | 2023-11-16 14:21:27 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
446 | 2023-11-13 21:06:29 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
445 | 2023-11-13 13:38:01 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
444 | 2023-11-11 00:43:46 | metros | 2 | 82551 | 58 | 4.830 | 17091.3 |
443 | 2023-11-11 00:43:45 | metros | 3 | 112716 | 752 | 5.503 | 20482.6 |
442 | 2023-11-10 23:32:36 | metros | 1 | 48755 | 4 | 0.733 | 66514.3 |
441 | 2023-11-05 20:37:41 | metros | 2 | 82551 | 58 | 2.186 | 37763.5 |
440 | 2023-11-04 10:20:01 | metros | 1 | 48755 | 4 | 1.763 | 27654.6 |
439 | 2023-11-02 01:28:49 | metros | 1 | 48755 | 4 | 0.766 | 63648.8 |
438 | 2023-11-01 16:28:30 | metros | 3 | 112716 | 752 | 5.423 | 20784.8 |
437 | 2023-11-01 16:28:29 | metros | 2 | 82551 | 58 | 2.436 | 33887.9 |
436 | 2023-10-27 17:50:59 | metros | 1 | 48755 | 4 | 0.893 | 54596.9 |
435 | 2023-10-21 07:51:18 | metros | 1 | 48755 | 4 | 0.813 | 59969.2 |
434 | 2023-10-17 12:21:22 | metros | 1 | 48755 | 4 | 0.830 | 58741.0 |
433 | 2023-10-13 15:39:49 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
432 | 2023-10-04 19:04:15 | metros | 1 | 48755 | 4 | 0.830 | 58741.0 |
431 | 2023-09-26 09:05:00 | metros | 3 | 112716 | 752 | 11.186 | 10076.5 |
430 | 2023-09-26 09:04:59 | metros | 2 | 82551 | 58 | 2.530 | 32628.9 |
429 | 2023-09-19 15:30:18 | metros | 1 | 48755 | 4 | 0.876 | 55656.4 |
428 | 2023-09-11 23:48:16 | metros | 1 | 48755 | 4 | 0.966 | 50471.0 |
427 | 2023-09-11 08:11:12 | metros | 1 | 48755 | 4 | 0.890 | 54780.9 |
426 | 2023-08-10 20:19:04 | metros | 2 | 82551 | 58 | 2.106 | 39198.0 |
425 | 2023-07-20 06:22:43 | metros | 1 | 48755 | 4 | 0.813 | 59969.2 |
424 | 2023-06-21 06:57:43 | metros | 1 | 48755 | 4 | 0.736 | 66243.2 |
423 | 2023-04-23 22:31:15 | metros | 2 | 82551 | 58 | 2.093 | 39441.5 |
422 | 2023-04-12 08:14:46 | metros | 1 | 48755 | 4 | 0.813 | 59969.2 |
421 | 2023-04-04 04:06:16 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
420 | 2023-01-30 20:24:32 | metros | 2 | 82551 | 58 | 2.093 | 39441.5 |
419 | 2023-01-14 18:13:34 | metros | 1 | 48755 | 4 | 0.736 | 66243.2 |
418 | 2023-01-07 06:13:54 | metros | 1 | 48755 | 4 | 0.813 | 59969.2 |
417 | 2022-11-11 02:43:02 | metros | 2 | 82551 | 58 | 2.170 | 38041.9 |
416 | 2022-11-01 13:35:07 | metros | 1 | 48755 | 4 | 0.796 | 61250.0 |
415 | 2022-09-19 21:33:05 | metros | 1 | 48755 | 4 | 0.763 | 63899.1 |
414 | 2022-09-19 13:54:39 | metros | 1 | 48755 | 4 | 0.813 | 59969.2 |
413 | 2022-08-31 02:16:16 | metros | 1 | 48755 | 4 | 1.046 | 46610.9 |
412 | 2022-08-23 08:52:04 | metros | 1 | 48755 | 4 | 0.783 | 62266.9 |
411 | 2022-08-14 16:26:35 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
410 | 2022-08-07 02:46:25 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
409 | 2022-07-30 03:43:16 | metros | 1 | 48755 | 4 | 0.826 | 59025.4 |
408 | 2022-07-29 00:39:24 | metros | 1 | 48755 | 4 | 0.846 | 57630.0 |
407 | 2022-07-03 11:01:30 | metros | 1 | 48755 | 4 | 0.733 | 66514.3 |
406 | 2022-06-20 12:40:47 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
405 | 2022-06-16 11:00:17 | metros | 1 | 48755 | 4 | 0.830 | 58741.0 |
404 | 2022-05-30 22:35:24 | metros | 1 | 48755 | 4 | 0.733 | 66514.3 |
403 | 2022-05-26 03:06:17 | metros | 1 | 48755 | 4 | 0.736 | 66243.2 |
402 | 2022-05-20 06:13:27 | metros | 2 | 82551 | 58 | 2.186 | 37763.5 |
401 | 2022-02-27 23:38:01 | metros | 1 | 48755 | 4 | 0.893 | 54596.9 |
400 | 2022-02-25 20:16:11 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
399 | 2022-02-16 08:56:06 | metros | 1 | 48755 | 4 | 0.766 | 63648.8 |
398 | 2021-12-19 00:50:50 | metros | 1 | 48755 | 4 | 0.843 | 57835.1 |
397 | 2021-12-16 21:29:34 | metros | 1 | 48755 | 4 | 0.860 | 56691.9 |
396 | 2021-11-08 09:34:06 | metros | 1 | 48755 | 4 | 0.813 | 59969.2 |
395 | 2021-10-24 01:39:18 | metros | 1 | 48755 | 4 | 0.876 | 55656.4 |
394 | 2021-10-22 00:12:17 | metros | 1 | 48755 | 4 | 0.830 | 58741.0 |
393 | 2021-09-24 20:43:33 | metros | 1 | 48755 | 4 | 0.813 | 59969.2 |
392 | 2021-08-05 07:11:40 | metros | 1 | 48755 | 4 | 0.733 | 66514.3 |
391 | 2021-06-17 15:29:51 | metros | 1 | 48755 | 4 | 0.750 | 65006.7 |
390 | 2021-05-01 03:48:53 | metros | 1 | 48755 | 4 | 0.890 | 54780.9 |
389 | 2021-03-28 11:50:45 | metros | 1 | 48755 | 4 | 0.843 | 57835.1 |
388 | 2021-03-02 12:50:12 | metros | 1 | 48755 | 4 | 0.733 | 66514.3 |