History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pias"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1042 | 2024-04-26 23:04:09 | pias | 1 | 13983 | 23 | 0.656 | 21315.5 |
1041 | 2024-04-25 15:22:12 | pias | 1 | 13983 | 23 | 0.593 | 23580.1 |
1040 | 2024-04-25 15:08:34 | pias | 1 | 13983 | 23 | 0.236 | 59250.0 |
1039 | 2024-04-15 14:10:36 | pias | 2 | 29872 | 462 | 1.373 | 21756.7 |
1038 | 2024-04-15 14:10:32 | pias | 2 | 29872 | 462 | 4.623 | 6461.6 |
1037 | 2024-04-01 17:34:02 | pias | 2 | 29872 | 462 | 2.060 | 14501.0 |
1036 | 2024-04-01 16:26:28 | pias | 1 | 13983 | 23 | 0.826 | 16928.6 |
1035 | 2024-03-31 00:23:00 | pias | 1 | 13983 | 23 | 0.266 | 52567.7 |
1034 | 2024-03-28 22:07:07 | pias | 1 | 13983 | 23 | 1.030 | 13575.7 |
1033 | 2024-03-05 00:04:28 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
1032 | 2024-03-03 10:26:31 | pias | 2 | 29872 | 462 | 0.780 | 38297.4 |
1031 | 2024-03-02 17:26:49 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
1030 | 2024-03-02 14:52:15 | pias | 2 | 29872 | 462 | 2.190 | 13640.2 |
1029 | 2024-03-02 13:29:02 | pias | 1 | 13983 | 23 | 0.283 | 49409.9 |
1028 | 2024-03-01 16:49:47 | pias | 1 | 13983 | 23 | 0.796 | 17566.6 |
1027 | 2024-02-20 21:39:24 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
1026 | 2024-01-30 07:33:27 | pias | 1 | 13983 | 23 | 0.403 | 34697.3 |
1025 | 2024-01-25 19:35:05 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
1024 | 2024-01-14 01:24:57 | pias | 1 | 13983 | 23 | 0.233 | 60012.9 |
1023 | 2023-12-15 00:56:47 | pias | 2 | 29872 | 462 | 0.860 | 34734.9 |
1022 | 2023-12-14 19:49:29 | pias | 1 | 13983 | 23 | 0.233 | 60012.9 |
1021 | 2023-12-12 14:07:56 | pias | 2 | 29872 | 462 | 0.766 | 38997.4 |
1020 | 2023-11-26 09:52:51 | pias | 1 | 13983 | 23 | 0.233 | 60012.9 |
1019 | 2023-11-20 01:40:04 | pias | 2 | 29872 | 462 | 0.843 | 35435.3 |
1018 | 2023-11-11 20:01:35 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
1017 | 2023-11-11 00:05:00 | pias | 1 | 13983 | 23 | 0.203 | 68881.8 |
1016 | 2023-11-08 23:47:28 | pias | 1 | 13983 | 23 | 0.233 | 60012.9 |
1015 | 2023-11-02 08:42:57 | pias | 1 | 13983 | 23 | 0.233 | 60012.9 |
1014 | 2023-10-31 06:01:30 | pias | 2 | 29872 | 462 | 0.873 | 34217.6 |
1013 | 2023-10-29 06:13:13 | pias | 2 | 29872 | 462 | 0.763 | 39150.7 |
1012 | 2023-10-25 21:58:41 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
1011 | 2023-10-24 18:48:57 | pias | 1 | 13983 | 23 | 0.216 | 64736.1 |
1010 | 2023-10-21 01:34:32 | pias | 2 | 29872 | 462 | 0.843 | 35435.3 |
1009 | 2023-10-19 15:14:59 | pias | 1 | 13983 | 23 | 0.233 | 60012.9 |
1008 | 2023-10-17 17:56:31 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
1007 | 2023-10-11 03:21:18 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
1006 | 2023-10-07 21:32:49 | pias | 2 | 29872 | 462 | 0.860 | 34734.9 |
1005 | 2023-10-03 13:02:23 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
1004 | 2023-09-26 18:38:26 | pias | 2 | 29872 | 462 | 0.876 | 34100.5 |
1003 | 2023-09-23 18:16:59 | pias | 1 | 13983 | 23 | 0.203 | 68881.8 |
1002 | 2023-09-11 21:10:25 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
1001 | 2023-09-11 13:31:30 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
1000 | 2023-09-11 07:47:58 | pias | 2 | 29872 | 462 | 1.000 | 29872.0 |
999 | 2023-08-12 18:54:12 | pias | 2 | 29872 | 462 | 0.953 | 31345.2 |
998 | 2023-07-29 08:18:27 | pias | 1 | 13983 | 23 | 0.233 | 60012.9 |
997 | 2023-06-25 02:23:56 | pias | 1 | 13983 | 23 | 0.203 | 68881.8 |
996 | 2023-06-02 02:07:02 | pias | 2 | 29872 | 462 | 0.750 | 39829.3 |
995 | 2023-04-21 00:18:30 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
994 | 2023-04-08 07:59:39 | pias | 1 | 13983 | 23 | 0.236 | 59250.0 |
993 | 2023-03-09 19:17:55 | pias | 2 | 29872 | 462 | 0.750 | 39829.3 |
992 | 2023-01-21 01:53:01 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
991 | 2023-01-08 14:50:14 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
990 | 2022-12-15 20:05:16 | pias | 1 | 13983 | 23 | 0.203 | 68881.8 |
989 | 2022-12-14 00:12:51 | pias | 2 | 29872 | 462 | 0.843 | 35435.3 |
988 | 2022-11-18 04:41:45 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
987 | 2022-11-11 10:54:51 | pias | 1 | 13983 | 23 | 0.203 | 68881.8 |
986 | 2022-11-09 20:35:14 | pias | 1 | 13983 | 23 | 0.236 | 59250.0 |
985 | 2022-11-08 02:56:33 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
984 | 2022-10-26 22:58:06 | pias | 2 | 29872 | 462 | 0.750 | 39829.3 |
983 | 2022-10-02 06:05:33 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
982 | 2022-09-24 19:28:07 | pias | 1 | 13983 | 23 | 0.216 | 64736.1 |
981 | 2022-09-21 05:00:43 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
980 | 2022-08-02 21:50:52 | pias | 2 | 29872 | 462 | 0.750 | 39829.3 |
979 | 2022-07-10 04:26:49 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
978 | 2022-06-15 12:17:37 | pias | 1 | 13983 | 23 | 0.236 | 59250.0 |
977 | 2022-06-09 09:19:11 | pias | 1 | 13983 | 23 | 0.200 | 69915.0 |
976 | 2022-06-04 05:58:43 | pias | 1 | 13983 | 23 | 0.216 | 64736.1 |
975 | 2022-05-18 15:30:25 | pias | 1 | 13983 | 23 | 0.236 | 59250.0 |
974 | 2022-05-05 16:36:24 | pias | 1 | 13983 | 23 | 0.266 | 52567.7 |
973 | 2022-03-10 13:47:54 | pias | 1 | 13983 | 23 | 0.216 | 64736.1 |
972 | 2022-03-01 16:11:04 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
971 | 2022-02-28 16:43:28 | pias | 1 | 13983 | 23 | 0.346 | 40413.3 |
970 | 2022-02-27 17:11:50 | pias | 1 | 13983 | 23 | 0.263 | 53167.3 |
969 | 2022-02-26 18:56:34 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
968 | 2022-02-25 11:21:43 | pias | 1 | 13983 | 23 | 0.266 | 52567.7 |
967 | 2022-02-24 10:12:28 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
966 | 2021-12-24 00:12:31 | pias | 1 | 13983 | 23 | 0.266 | 52567.7 |
965 | 2021-12-23 02:34:05 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
964 | 2021-11-23 00:55:35 | pias | 1 | 13983 | 23 | 0.233 | 60012.9 |
963 | 2021-11-13 07:24:21 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
962 | 2021-11-05 18:49:07 | pias | 1 | 13983 | 23 | 0.233 | 60012.9 |
961 | 2021-10-23 21:40:22 | pias | 1 | 13983 | 23 | 0.236 | 59250.0 |
960 | 2021-10-21 20:27:43 | pias | 1 | 13983 | 23 | 0.203 | 68881.8 |
959 | 2021-09-09 17:46:06 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
958 | 2021-09-07 12:18:46 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
957 | 2021-08-23 11:37:37 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
956 | 2021-08-23 01:57:54 | pias | 1 | 13983 | 23 | 0.203 | 68881.8 |
955 | 2021-08-20 21:36:06 | pias | 1 | 13983 | 23 | 0.233 | 60012.9 |
954 | 2021-07-11 09:38:14 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
953 | 2021-06-25 16:19:23 | pias | 2 | 29872 | 462 | 0.940 | 31778.7 |
952 | 2021-06-07 13:59:24 | pias | 2 | 29872 | 462 | 0.843 | 35435.3 |
951 | 2021-06-04 09:18:10 | pias | 2 | 29872 | 462 | 0.750 | 39829.3 |
950 | 2021-05-22 17:51:20 | pias | 1 | 13983 | 23 | 0.266 | 52567.7 |
949 | 2021-04-30 20:42:42 | pias | 2 | 29872 | 462 | 0.873 | 34217.6 |
948 | 2021-04-29 14:42:28 | pias | 1 | 13983 | 23 | 0.266 | 52567.7 |
947 | 2021-04-11 04:54:58 | pias | 1 | 13983 | 23 | 0.250 | 55932.0 |
946 | 2021-02-20 15:15:28 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
945 | 2021-02-17 11:10:23 | pias | 1 | 13983 | 23 | 0.220 | 63559.1 |
944 | 2021-01-13 19:36:10 | pias | 2 | 29872 | 462 | 0.766 | 38997.4 |
943 | 2021-01-12 20:56:39 | pias | 1 | 13983 | 23 | 0.216 | 64736.1 |