History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lears"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1120 | 2024-04-16 23:50:46 | lears | 1 | 28756 | 30 | 0.546 | 52666.7 |
1119 | 2024-04-16 23:12:04 | lears | 1 | 28756 | 30 | 1.690 | 17015.4 |
1118 | 2024-04-16 23:03:34 | lears | 1 | 28756 | 30 | 1.313 | 21901.0 |
1117 | 2024-04-05 17:34:19 | lears | 2 | 53800 | 293 | 4.046 | 13297.1 |
1116 | 2024-04-05 05:51:04 | lears | 2 | 53800 | 293 | 5.486 | 9806.8 |
1115 | 2024-04-05 05:47:29 | lears | 2 | 53800 | 293 | 5.860 | 9180.9 |
1114 | 2024-04-05 05:47:15 | lears | 1 | 28756 | 30 | 1.936 | 14853.3 |
1113 | 2024-04-05 05:47:02 | lears | 2 | 53800 | 293 | 2.343 | 22962.0 |
1112 | 2024-04-05 05:46:48 | lears | 1 | 28756 | 30 | 1.250 | 23004.8 |
1111 | 2024-04-03 02:46:11 | lears | 1 | 28756 | 30 | 1.750 | 16432.0 |
1110 | 2024-04-01 17:01:21 | lears | 1 | 28756 | 30 | 1.186 | 24246.2 |
1109 | 2024-03-29 01:17:31 | lears | 1 | 28756 | 30 | 1.703 | 16885.5 |
1108 | 2024-03-05 18:02:41 | lears | 2 | 53800 | 293 | 5.656 | 9512.0 |
1107 | 2024-03-05 16:54:37 | lears | 2 | 53800 | 293 | 1.966 | 27365.2 |
1106 | 2024-03-05 16:54:15 | lears | 1 | 28756 | 30 | 1.173 | 24514.9 |
1105 | 2024-03-03 22:50:38 | lears | 1 | 28756 | 30 | 1.750 | 16432.0 |
1104 | 2024-03-02 14:15:38 | lears | 1 | 28756 | 30 | 1.156 | 24875.4 |
1103 | 2024-02-28 04:51:25 | lears | 2 | 53800 | 293 | 6.076 | 8854.5 |
1102 | 2024-02-27 23:08:41 | lears | 2 | 53800 | 293 | 3.690 | 14579.9 |
1101 | 2024-02-27 20:33:44 | lears | 1 | 28756 | 30 | 0.546 | 52666.7 |
1100 | 2024-02-13 14:23:19 | lears | 2 | 53800 | 293 | 4.966 | 10833.7 |
1099 | 2024-02-13 05:10:27 | lears | 2 | 53800 | 293 | 1.890 | 28465.6 |
1098 | 2024-02-04 12:14:14 | lears | 2 | 53800 | 293 | 1.763 | 30516.2 |
1097 | 2024-02-04 12:14:10 | lears | 1 | 28756 | 30 | 0.546 | 52666.7 |
1096 | 2024-01-29 00:02:09 | lears | 1 | 28756 | 30 | 0.436 | 65954.1 |
1095 | 2024-01-19 19:49:59 | lears | 1 | 28756 | 30 | 0.486 | 59168.7 |
1094 | 2024-01-04 13:33:42 | lears | 1 | 28756 | 30 | 0.500 | 57512.0 |
1093 | 2023-12-31 13:14:39 | lears | 2 | 53800 | 293 | 1.440 | 37361.1 |
1092 | 2023-12-31 03:19:46 | lears | 2 | 53800 | 293 | 1.406 | 38264.6 |
1091 | 2023-12-27 14:28:54 | lears | 2 | 53800 | 293 | 1.780 | 30224.7 |
1090 | 2023-12-26 10:12:50 | lears | 1 | 28756 | 30 | 0.436 | 65954.1 |
1089 | 2023-11-29 08:37:25 | lears | 2 | 53800 | 293 | 1.470 | 36598.6 |
1088 | 2023-11-24 16:42:08 | lears | 1 | 28756 | 30 | 0.483 | 59536.2 |
1087 | 2023-11-23 05:22:27 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1086 | 2023-11-16 09:20:29 | lears | 1 | 28756 | 30 | 0.546 | 52666.7 |
1085 | 2023-11-13 21:40:30 | lears | 2 | 53800 | 293 | 1.783 | 30173.9 |
1084 | 2023-11-13 16:05:39 | lears | 1 | 28756 | 30 | 0.500 | 57512.0 |
1083 | 2023-11-13 05:39:32 | lears | 1 | 28756 | 30 | 0.483 | 59536.2 |
1082 | 2023-11-10 13:56:31 | lears | 1 | 28756 | 30 | 0.513 | 56054.6 |
1081 | 2023-11-08 17:47:36 | lears | 1 | 28756 | 30 | 0.483 | 59536.2 |
1080 | 2023-10-30 19:26:12 | lears | 1 | 28756 | 30 | 0.530 | 54256.6 |
1079 | 2023-10-28 05:56:55 | lears | 1 | 28756 | 30 | 0.436 | 65954.1 |
1078 | 2023-10-24 23:24:22 | lears | 1 | 28756 | 30 | 0.500 | 57512.0 |
1077 | 2023-10-24 00:48:44 | lears | 1 | 28756 | 30 | 1.030 | 27918.4 |
1076 | 2023-10-20 03:00:57 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1075 | 2023-10-13 19:16:15 | lears | 1 | 28756 | 30 | 0.516 | 55728.7 |
1074 | 2023-10-04 11:36:22 | lears | 1 | 28756 | 30 | 0.580 | 49579.3 |
1073 | 2023-09-27 08:56:04 | lears | 1 | 28756 | 30 | 0.436 | 65954.1 |
1072 | 2023-09-24 15:29:09 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1071 | 2023-09-11 20:47:51 | lears | 1 | 28756 | 30 | 0.533 | 53951.2 |
1070 | 2023-09-01 12:35:32 | lears | 1 | 28756 | 30 | 0.420 | 68466.7 |
1069 | 2023-08-15 21:32:16 | lears | 2 | 53800 | 293 | 1.546 | 34799.5 |
1068 | 2023-08-09 15:53:12 | lears | 1 | 28756 | 30 | 0.500 | 57512.0 |
1067 | 2023-07-15 18:05:42 | lears | 1 | 28756 | 30 | 0.530 | 54256.6 |
1066 | 2023-06-03 17:51:19 | lears | 1 | 28756 | 30 | 1.000 | 28756.0 |
1065 | 2023-04-28 00:05:00 | lears | 2 | 53800 | 293 | 1.406 | 38264.6 |
1064 | 2023-04-08 02:29:51 | lears | 1 | 28756 | 30 | 0.500 | 57512.0 |
1063 | 2023-03-25 20:12:53 | lears | 1 | 28756 | 30 | 0.440 | 65354.5 |
1062 | 2023-02-02 18:20:14 | lears | 2 | 53800 | 293 | 1.390 | 38705.0 |
1061 | 2023-01-09 17:49:29 | lears | 1 | 28756 | 30 | 0.436 | 65954.1 |
1060 | 2023-01-02 21:03:17 | lears | 1 | 28756 | 30 | 0.440 | 65354.5 |
1059 | 2022-11-15 23:08:14 | lears | 2 | 53800 | 293 | 1.406 | 38264.6 |
1058 | 2022-10-13 06:13:13 | lears | 1 | 28756 | 30 | 0.436 | 65954.1 |
1057 | 2022-09-22 21:24:49 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1056 | 2022-08-07 18:14:46 | lears | 1 | 28756 | 30 | 0.436 | 65954.1 |
1055 | 2022-06-18 10:48:13 | lears | 2 | 53800 | 293 | 1.420 | 37887.3 |
1054 | 2022-06-16 06:28:26 | lears | 2 | 53800 | 293 | 1.403 | 38346.4 |
1053 | 2022-06-09 12:06:11 | lears | 1 | 28756 | 30 | 0.466 | 61708.2 |
1052 | 2022-06-05 21:23:49 | lears | 1 | 28756 | 30 | 0.483 | 59536.2 |
1051 | 2022-05-30 01:51:47 | lears | 1 | 28756 | 30 | 0.436 | 65954.1 |
1050 | 2022-05-18 10:54:53 | lears | 1 | 28756 | 30 | 0.456 | 63061.4 |
1049 | 2022-03-25 09:25:55 | lears | 1 | 28756 | 30 | 0.593 | 48492.4 |
1048 | 2022-02-15 18:57:20 | lears | 1 | 28756 | 30 | 0.516 | 55728.7 |
1047 | 2022-02-04 07:22:41 | lears | 2 | 53800 | 293 | 1.436 | 37465.2 |
1046 | 2022-01-20 15:00:21 | lears | 1 | 28756 | 30 | 0.466 | 61708.2 |
1045 | 2022-01-09 23:46:16 | lears | 1 | 28756 | 30 | 0.500 | 57512.0 |
1044 | 2021-11-16 05:59:31 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1043 | 2021-11-09 13:35:56 | lears | 2 | 53800 | 293 | 1.390 | 38705.0 |
1042 | 2021-11-07 20:00:45 | lears | 1 | 28756 | 30 | 0.483 | 59536.2 |
1041 | 2021-10-03 23:52:59 | lears | 1 | 28756 | 30 | 0.516 | 55728.7 |
1040 | 2021-09-01 15:11:41 | lears | 1 | 28756 | 30 | 0.483 | 59536.2 |
1039 | 2021-08-15 03:48:20 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1038 | 2021-08-04 16:44:22 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1037 | 2021-06-28 09:44:46 | lears | 1 | 28756 | 30 | 0.593 | 48492.4 |
1036 | 2021-04-30 09:39:04 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1035 | 2021-04-26 18:32:37 | lears | 1 | 28756 | 30 | 0.470 | 61183.0 |
1034 | 2021-04-24 14:08:05 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1033 | 2021-04-22 23:34:59 | lears | 1 | 28756 | 30 | 0.530 | 54256.6 |
1032 | 2021-04-22 17:33:31 | lears | 1 | 28756 | 30 | 1.000 | 28756.0 |
1031 | 2021-04-10 05:21:02 | lears | 1 | 28756 | 30 | 0.606 | 47452.1 |
1030 | 2021-03-16 05:35:00 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1029 | 2021-01-30 07:09:39 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1028 | 2021-01-26 13:58:05 | lears | 1 | 28756 | 30 | 0.440 | 65354.5 |
1027 | 2021-01-24 15:54:50 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1026 | 2021-01-22 05:33:37 | lears | 1 | 28756 | 30 | 0.436 | 65954.1 |
1025 | 2020-12-30 04:35:30 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1024 | 2020-10-30 21:31:12 | lears | 1 | 28756 | 30 | 0.513 | 56054.6 |
1023 | 2020-10-26 10:53:58 | lears | 1 | 28756 | 30 | 0.733 | 39230.6 |
1022 | 2020-10-24 11:14:56 | lears | 1 | 28756 | 30 | 0.453 | 63479.0 |
1021 | 2020-10-20 20:27:51 | lears | 1 | 28756 | 30 | 0.500 | 57512.0 |