History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loach"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1187 | 2024-04-25 14:52:19 | loach | 1 | 28756 | 7 | 0.483 | 59536.2 |
1186 | 2024-04-22 22:33:51 | loach | 1 | 28756 | 7 | 0.546 | 52666.7 |
1185 | 2024-04-08 15:02:57 | loach | 1 | 28756 | 7 | 0.516 | 55728.7 |
1184 | 2024-04-05 05:49:07 | loach | 1 | 28756 | 7 | 2.406 | 11951.8 |
1183 | 2024-04-03 03:38:31 | loach | 1 | 28756 | 7 | 1.970 | 14597.0 |
1182 | 2024-04-01 17:37:53 | loach | 3 | 83667 | 922 | 7.923 | 10560.0 |
1181 | 2024-03-31 11:34:52 | loach | 3 | 83667 | 922 | 11.830 | 7072.4 |
1180 | 2024-03-31 09:56:25 | loach | 3 | 83667 | 922 | 10.626 | 7873.8 |
1179 | 2024-03-31 09:56:27 | loach | 2 | 53800 | 86 | 4.783 | 11248.2 |
1178 | 2024-03-31 08:46:15 | loach | 1 | 28756 | 7 | 1.000 | 28756.0 |
1177 | 2024-03-29 02:16:35 | loach | 1 | 28756 | 7 | 1.766 | 16283.1 |
1176 | 2024-03-10 21:13:54 | loach | 3 | 83667 | 922 | 8.670 | 9650.2 |
1175 | 2024-03-09 18:41:33 | loach | 3 | 83667 | 922 | 9.390 | 8910.2 |
1174 | 2024-03-09 04:41:19 | loach | 3 | 83667 | 922 | 3.343 | 25027.5 |
1173 | 2024-03-01 04:03:20 | loach | 1 | 28756 | 7 | 0.563 | 51076.4 |
1172 | 2024-02-27 19:52:24 | loach | 1 | 28756 | 7 | 0.516 | 55728.7 |
1171 | 2024-02-07 14:09:26 | loach | 2 | 53800 | 86 | 3.593 | 14973.6 |
1170 | 2024-02-07 01:48:44 | loach | 2 | 53800 | 86 | 1.643 | 32745.0 |
1169 | 2024-01-29 00:04:23 | loach | 1 | 28756 | 7 | 0.483 | 59536.2 |
1168 | 2024-01-28 22:10:13 | loach | 1 | 28756 | 7 | 0.500 | 57512.0 |
1167 | 2024-01-22 12:24:12 | loach | 3 | 83667 | 922 | 10.016 | 8353.3 |
1166 | 2024-01-20 05:42:21 | loach | 3 | 83667 | 922 | 3.436 | 24350.1 |
1165 | 2024-01-14 04:07:43 | loach | 3 | 83667 | 922 | 3.766 | 22216.4 |
1164 | 2024-01-06 13:31:40 | loach | 1 | 28756 | 7 | 0.486 | 59168.7 |
1163 | 2023-12-30 19:12:09 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1162 | 2023-12-24 16:10:42 | loach | 3 | 83667 | 922 | 3.343 | 25027.5 |
1161 | 2023-12-13 00:10:34 | loach | 2 | 53800 | 86 | 1.640 | 32804.9 |
1160 | 2023-12-12 03:35:21 | loach | 2 | 53800 | 86 | 1.656 | 32487.9 |
1159 | 2023-11-24 11:35:48 | loach | 3 | 83667 | 922 | 3.310 | 25277.0 |
1158 | 2023-11-17 15:15:36 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1157 | 2023-11-15 05:32:58 | loach | 1 | 28756 | 7 | 0.436 | 65954.1 |
1156 | 2023-11-12 04:11:00 | loach | 1 | 28756 | 7 | 0.486 | 59168.7 |
1155 | 2023-11-11 01:02:25 | loach | 2 | 53800 | 86 | 1.423 | 37807.4 |
1154 | 2023-11-03 18:02:33 | loach | 1 | 28756 | 7 | 0.486 | 59168.7 |
1153 | 2023-10-22 13:49:29 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1152 | 2023-10-18 17:32:08 | loach | 1 | 28756 | 7 | 0.546 | 52666.7 |
1151 | 2023-10-18 13:32:22 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1150 | 2023-10-11 12:18:38 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1149 | 2023-10-04 13:03:35 | loach | 1 | 28756 | 7 | 0.470 | 61183.0 |
1148 | 2023-10-03 23:37:56 | loach | 3 | 83667 | 922 | 9.220 | 9074.5 |
1147 | 2023-09-30 20:42:03 | loach | 3 | 83667 | 922 | 3.953 | 21165.4 |
1146 | 2023-09-21 00:10:19 | loach | 1 | 28756 | 7 | 0.436 | 65954.1 |
1145 | 2023-09-16 10:04:58 | loach | 3 | 83667 | 922 | 4.093 | 20441.5 |
1144 | 2023-09-07 11:49:37 | loach | 1 | 28756 | 7 | 0.436 | 65954.1 |
1143 | 2023-09-03 21:24:08 | loach | 1 | 28756 | 7 | 0.486 | 59168.7 |
1142 | 2023-08-26 11:19:19 | loach | 3 | 83667 | 922 | 3.500 | 23904.9 |
1141 | 2023-08-14 15:38:31 | loach | 1 | 28756 | 7 | 0.483 | 59536.2 |
1140 | 2023-08-13 23:46:01 | loach | 2 | 53800 | 86 | 1.393 | 38621.7 |
1139 | 2023-06-29 10:45:44 | loach | 3 | 83667 | 922 | 3.423 | 24442.6 |
1138 | 2023-06-25 02:33:42 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1137 | 2023-05-21 13:13:46 | loach | 1 | 28756 | 7 | 0.420 | 68466.7 |
1136 | 2023-05-13 19:18:51 | loach | 1 | 28756 | 7 | 0.500 | 57512.0 |
1135 | 2023-05-06 03:24:52 | loach | 3 | 83667 | 922 | 3.593 | 23286.1 |
1134 | 2023-04-25 21:13:20 | loach | 2 | 53800 | 86 | 1.373 | 39184.3 |
1133 | 2023-04-25 11:56:17 | loach | 1 | 28756 | 7 | 0.530 | 54256.6 |
1132 | 2023-03-09 23:43:54 | loach | 1 | 28756 | 7 | 0.436 | 65954.1 |
1131 | 2023-02-12 06:41:20 | loach | 3 | 83667 | 922 | 3.330 | 25125.2 |
1130 | 2023-02-04 17:56:04 | loach | 1 | 28756 | 7 | 0.486 | 59168.7 |
1129 | 2023-01-31 16:51:58 | loach | 2 | 53800 | 86 | 1.373 | 39184.3 |
1128 | 2022-12-29 16:43:44 | loach | 1 | 28756 | 7 | 0.436 | 65954.1 |
1127 | 2022-12-01 20:03:12 | loach | 3 | 83667 | 922 | 3.453 | 24230.2 |
1126 | 2022-11-28 13:02:29 | loach | 3 | 83667 | 922 | 3.456 | 24209.2 |
1125 | 2022-11-26 16:05:44 | loach | 3 | 83667 | 922 | 3.376 | 24782.9 |
1124 | 2022-11-25 08:01:09 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1123 | 2022-11-24 02:10:14 | loach | 3 | 83667 | 922 | 3.330 | 25125.2 |
1122 | 2022-11-14 07:41:42 | loach | 2 | 53800 | 86 | 1.453 | 37026.8 |
1121 | 2022-10-21 23:28:07 | loach | 1 | 28756 | 7 | 0.440 | 65354.5 |
1120 | 2022-09-19 14:53:03 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1119 | 2022-09-16 20:50:27 | loach | 1 | 28756 | 7 | 0.483 | 59536.2 |
1118 | 2022-08-28 14:24:28 | loach | 1 | 28756 | 7 | 0.486 | 59168.7 |
1117 | 2022-08-15 06:01:43 | loach | 1 | 28756 | 7 | 0.436 | 65954.1 |
1116 | 2022-08-06 21:35:07 | loach | 1 | 28756 | 7 | 0.516 | 55728.7 |
1115 | 2022-07-29 13:49:14 | loach | 1 | 28756 | 7 | 0.563 | 51076.4 |
1114 | 2022-07-02 01:00:29 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1113 | 2022-06-13 20:40:20 | loach | 1 | 28756 | 7 | 0.563 | 51076.4 |
1112 | 2022-05-12 03:33:44 | loach | 2 | 53800 | 86 | 1.766 | 30464.3 |
1111 | 2022-05-01 11:16:00 | loach | 1 | 28756 | 7 | 0.440 | 65354.5 |
1110 | 2022-04-27 15:05:59 | loach | 3 | 83667 | 922 | 4.296 | 19475.6 |
1109 | 2022-04-24 08:41:06 | loach | 1 | 28756 | 7 | 0.500 | 57512.0 |
1108 | 2022-03-11 14:53:21 | loach | 1 | 28756 | 7 | 0.483 | 59536.2 |
1107 | 2022-01-20 22:44:04 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1106 | 2022-01-20 12:23:32 | loach | 1 | 28756 | 7 | 0.530 | 54256.6 |
1105 | 2021-12-29 00:18:17 | loach | 1 | 28756 | 7 | 0.686 | 41918.4 |
1104 | 2021-12-26 08:48:55 | loach | 3 | 83667 | 922 | 3.893 | 21491.7 |
1103 | 2021-12-13 18:43:32 | loach | 3 | 83667 | 922 | 3.330 | 25125.2 |
1102 | 2021-12-07 21:42:44 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1101 | 2021-12-01 07:53:17 | loach | 1 | 28756 | 7 | 0.530 | 54256.6 |
1100 | 2021-11-30 05:19:29 | loach | 3 | 83667 | 922 | 3.623 | 23093.3 |
1099 | 2021-11-27 20:35:23 | loach | 1 | 28756 | 7 | 0.516 | 55728.7 |
1098 | 2021-11-20 06:55:17 | loach | 1 | 28756 | 7 | 0.453 | 63479.0 |
1097 | 2021-11-19 11:55:03 | loach | 3 | 83667 | 922 | 3.830 | 21845.2 |
1096 | 2021-11-18 11:52:55 | loach | 3 | 83667 | 922 | 4.140 | 20209.4 |
1095 | 2021-11-18 04:28:11 | loach | 1 | 28756 | 7 | 0.500 | 57512.0 |
1094 | 2021-11-17 17:57:18 | loach | 1 | 28756 | 7 | 0.470 | 61183.0 |
1093 | 2021-11-17 12:01:35 | loach | 3 | 83667 | 922 | 3.780 | 22134.1 |
1092 | 2021-11-15 11:42:25 | loach | 3 | 83667 | 922 | 3.846 | 21754.3 |
1091 | 2021-11-01 21:21:52 | loach | 3 | 83667 | 922 | 4.110 | 20356.9 |
1090 | 2021-10-31 22:13:10 | loach | 3 | 83667 | 922 | 3.420 | 24464.0 |
1089 | 2021-10-08 14:34:34 | loach | 3 | 83667 | 922 | 3.813 | 21942.6 |
1088 | 2021-10-05 23:39:56 | loach | 1 | 28756 | 7 | 0.500 | 57512.0 |