History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hogfish"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
297 | 2024-05-01 22:58:14 | hogfish | 2 | 107671 | 26 | 3.403 | 31640.0 |
296 | 2024-04-29 17:52:26 | hogfish | 2 | 107671 | 26 | 6.376 | 16886.9 |
295 | 2024-04-29 17:52:12 | hogfish | 3 | 134027 | 174 | 7.236 | 18522.2 |
294 | 2024-04-29 00:58:28 | hogfish | 3 | 134027 | 174 | 10.376 | 12917.0 |
293 | 2024-04-27 10:36:16 | hogfish | 1 | 69583 | 4 | 3.156 | 22047.8 |
292 | 2024-04-26 21:08:36 | hogfish | 3 | 134027 | 174 | 16.640 | 8054.5 |
291 | 2024-04-26 20:58:05 | hogfish | 1 | 69583 | 4 | 6.576 | 10581.4 |
290 | 2024-04-26 20:11:28 | hogfish | 2 | 107671 | 26 | 12.673 | 8496.1 |
289 | 2024-04-26 20:06:42 | hogfish | 3 | 134027 | 174 | 6.986 | 19185.1 |
288 | 2024-04-25 10:27:08 | hogfish | 3 | 134027 | 174 | 12.953 | 10347.2 |
287 | 2024-04-25 10:26:58 | hogfish | 1 | 69583 | 4 | 2.920 | 23829.8 |
286 | 2024-03-22 04:25:46 | hogfish | 1 | 69583 | 4 | 2.750 | 25302.9 |
285 | 2024-03-07 13:44:33 | hogfish | 1 | 69583 | 4 | 1.063 | 65459.1 |
284 | 2024-02-27 22:43:12 | hogfish | 1 | 69583 | 4 | 5.373 | 12950.5 |
283 | 2024-02-19 18:51:42 | hogfish | 1 | 69583 | 4 | 1.313 | 52995.4 |
282 | 2024-02-07 12:56:21 | hogfish | 1 | 69583 | 4 | 1.186 | 58670.3 |
281 | 2024-01-27 05:38:04 | hogfish | 1 | 69583 | 4 | 1.266 | 54962.9 |
280 | 2024-01-20 17:32:06 | hogfish | 1 | 69583 | 4 | 1.080 | 64428.7 |
279 | 2023-12-17 14:36:27 | hogfish | 1 | 69583 | 4 | 1.046 | 66522.9 |
278 | 2023-11-30 16:39:42 | hogfish | 1 | 69583 | 4 | 1.236 | 56296.9 |
277 | 2023-11-18 23:59:23 | hogfish | 1 | 69583 | 4 | 1.063 | 65459.1 |
276 | 2023-11-05 18:02:13 | hogfish | 1 | 69583 | 4 | 1.153 | 60349.5 |
275 | 2023-11-05 06:41:57 | hogfish | 1 | 69583 | 4 | 1.046 | 66522.9 |
274 | 2023-10-13 15:14:40 | hogfish | 1 | 69583 | 4 | 1.063 | 65459.1 |
273 | 2023-09-27 09:13:24 | hogfish | 1 | 69583 | 4 | 1.076 | 64668.2 |
272 | 2023-09-25 19:09:38 | hogfish | 1 | 69583 | 4 | 1.063 | 65459.1 |
271 | 2023-09-15 23:18:12 | hogfish | 1 | 69583 | 4 | 1.220 | 57035.2 |
270 | 2023-07-09 23:59:37 | hogfish | 1 | 69583 | 4 | 1.156 | 60192.9 |
269 | 2023-07-03 19:01:52 | hogfish | 1 | 69583 | 4 | 1.220 | 57035.2 |
268 | 2023-05-29 22:37:42 | hogfish | 1 | 69583 | 4 | 1.046 | 66522.9 |
267 | 2023-04-12 21:51:21 | hogfish | 1 | 69583 | 4 | 1.033 | 67360.1 |
266 | 2023-02-14 17:21:50 | hogfish | 3 | 134027 | 174 | 12.250 | 10941.0 |
265 | 2023-02-06 17:05:14 | hogfish | 1 | 69583 | 4 | 1.046 | 66522.9 |
264 | 2023-02-03 20:22:40 | hogfish | 1 | 69583 | 4 | 1.033 | 67360.1 |
263 | 2023-01-18 16:29:22 | hogfish | 3 | 134027 | 174 | 6.343 | 21129.9 |
262 | 2022-12-26 10:32:02 | hogfish | 3 | 134027 | 174 | 6.266 | 21389.6 |
261 | 2022-12-03 01:43:31 | hogfish | 1 | 69583 | 4 | 1.046 | 66522.9 |
260 | 2022-11-12 03:02:51 | hogfish | 3 | 134027 | 174 | 6.250 | 21444.3 |
259 | 2022-10-12 21:36:07 | hogfish | 1 | 69583 | 4 | 1.236 | 56296.9 |
258 | 2022-09-13 06:19:03 | hogfish | 1 | 69583 | 4 | 1.060 | 65644.3 |
257 | 2022-08-26 18:38:23 | hogfish | 1 | 69583 | 4 | 1.140 | 61037.7 |
256 | 2022-07-31 10:38:35 | hogfish | 1 | 69583 | 4 | 1.063 | 65459.1 |
255 | 2022-07-13 01:11:30 | hogfish | 3 | 134027 | 174 | 5.700 | 23513.5 |
254 | 2022-07-05 20:08:49 | hogfish | 1 | 69583 | 4 | 1.093 | 63662.4 |
253 | 2022-06-14 12:23:26 | hogfish | 1 | 69583 | 4 | 1.203 | 57841.2 |
252 | 2022-06-11 10:37:54 | hogfish | 1 | 69583 | 4 | 1.330 | 52318.0 |
251 | 2022-03-23 16:23:34 | hogfish | 1 | 69583 | 4 | 1.453 | 47889.2 |
250 | 2022-03-21 13:01:16 | hogfish | 1 | 69583 | 4 | 1.216 | 57222.9 |
249 | 2022-02-21 14:03:54 | hogfish | 1 | 69583 | 4 | 1.356 | 51314.9 |
248 | 2022-02-10 13:06:50 | hogfish | 1 | 69583 | 4 | 1.203 | 57841.2 |
247 | 2021-12-27 11:40:36 | hogfish | 1 | 69583 | 4 | 1.283 | 54234.6 |
246 | 2021-11-15 16:15:56 | hogfish | 1 | 69583 | 4 | 1.280 | 54361.7 |
245 | 2021-10-27 02:36:37 | hogfish | 1 | 69583 | 4 | 1.076 | 64668.2 |
244 | 2021-09-28 23:52:47 | hogfish | 1 | 69583 | 4 | 1.076 | 64668.2 |
243 | 2021-09-21 01:36:12 | hogfish | 1 | 69583 | 4 | 1.173 | 59320.5 |
242 | 2021-09-08 18:21:50 | hogfish | 1 | 69583 | 4 | 1.140 | 61037.7 |
241 | 2021-07-23 23:16:43 | hogfish | 1 | 69583 | 4 | 1.046 | 66522.9 |
240 | 2021-05-28 08:18:55 | hogfish | 1 | 69583 | 4 | 1.203 | 57841.2 |
239 | 2021-05-06 21:06:59 | hogfish | 1 | 69583 | 4 | 1.233 | 56433.9 |
238 | 2021-04-05 04:11:40 | hogfish | 1 | 69583 | 4 | 1.203 | 57841.2 |
237 | 2021-03-09 13:34:04 | hogfish | 1 | 69583 | 4 | 1.093 | 63662.4 |
236 | 2021-01-28 04:57:26 | hogfish | 1 | 69583 | 4 | 1.080 | 64428.7 |
235 | 2021-01-23 17:24:53 | hogfish | 3 | 134027 | 174 | 5.780 | 23188.1 |
234 | 2020-12-25 05:03:10 | hogfish | 3 | 134027 | 174 | 5.640 | 23763.7 |
233 | 2020-11-02 10:33:21 | hogfish | 1 | 69583 | 4 | 1.280 | 54361.7 |
232 | 2020-10-30 01:52:45 | hogfish | 1 | 69583 | 4 | 1.063 | 65459.1 |
231 | 2020-10-16 23:20:20 | hogfish | 1 | 69583 | 4 | 2.000 | 34791.5 |
230 | 2020-10-06 07:39:16 | hogfish | 1 | 69583 | 4 | 1.076 | 64668.2 |
229 | 2020-10-03 07:12:23 | hogfish | 1 | 69583 | 4 | 1.046 | 66522.9 |
228 | 2020-09-22 15:00:07 | hogfish | 1 | 69583 | 4 | 1.063 | 65459.1 |
227 | 2020-09-14 07:22:29 | hogfish | 1 | 69583 | 4 | 1.063 | 65459.1 |
226 | 2020-08-02 01:44:09 | hogfish | 1 | 69583 | 4 | 1.360 | 51164.0 |
225 | 2020-07-26 04:31:59 | hogfish | 1 | 69583 | 4 | 1.203 | 57841.2 |
224 | 2020-06-09 19:24:24 | hogfish | 1 | 69583 | 4 | 1.076 | 64668.2 |
223 | 2020-03-29 04:35:23 | hogfish | 1 | 69583 | 4 | 1.203 | 57841.2 |
222 | 2020-03-28 19:30:26 | hogfish | 1 | 69583 | 4 | 1.186 | 58670.3 |
221 | 2020-03-28 14:21:31 | hogfish | 1 | 69583 | 4 | 1.266 | 54962.9 |
220 | 2020-03-26 20:08:45 | hogfish | 1 | 69583 | 4 | 1.233 | 56433.9 |
219 | 2020-03-19 22:12:40 | hogfish | 1 | 69583 | 4 | 1.216 | 57222.9 |
218 | 2020-03-05 09:03:09 | hogfish | 1 | 69583 | 4 | 1.170 | 59472.6 |
217 | 2020-03-02 18:33:26 | hogfish | 1 | 69583 | 4 | 2.656 | 26198.4 |
216 | 2020-03-02 16:41:42 | hogfish | 1 | 69583 | 4 | 1.156 | 60192.9 |
215 | 2020-02-24 11:46:26 | hogfish | 1 | 69583 | 4 | 2.580 | 26970.2 |
214 | 2020-02-23 07:37:27 | hogfish | 1 | 69583 | 4 | 1.250 | 55666.4 |
213 | 2020-02-17 19:40:56 | hogfish | 1 | 69583 | 4 | 3.950 | 17615.9 |
212 | 2020-02-12 23:50:19 | hogfish | 1 | 69583 | 4 | 1.356 | 51314.9 |
211 | 2020-02-03 01:34:54 | hogfish | 1 | 69583 | 4 | 1.266 | 54962.9 |
210 | 2020-01-28 01:57:42 | hogfish | 1 | 69583 | 4 | 1.030 | 67556.3 |
209 | 2020-01-27 01:55:55 | hogfish | 1 | 69583 | 4 | 1.250 | 55666.4 |
208 | 2020-01-21 12:26:32 | hogfish | 1 | 69583 | 4 | 1.376 | 50569.0 |
207 | 2020-01-21 12:06:25 | hogfish | 1 | 69583 | 4 | 3.796 | 18330.6 |
206 | 2020-01-17 11:13:06 | hogfish | 1 | 69583 | 4 | 2.690 | 25867.3 |
205 | 2020-01-17 10:12:18 | hogfish | 1 | 69583 | 4 | 1.203 | 57841.2 |
204 | 2020-01-08 04:54:41 | hogfish | 1 | 69583 | 4 | 3.796 | 18330.6 |
203 | 2019-12-31 09:39:12 | hogfish | 1 | 69583 | 4 | 1.250 | 55666.4 |
202 | 2019-12-31 06:31:22 | hogfish | 1 | 69583 | 4 | 1.203 | 57841.2 |
201 | 2019-12-30 16:09:58 | hogfish | 1 | 69583 | 4 | 1.060 | 65644.3 |
200 | 2019-12-02 09:50:55 | hogfish | 1 | 69583 | 4 | 1.046 | 66522.9 |
199 | 2019-09-17 11:59:41 | hogfish | 1 | 69583 | 4 | 1.000 | 69583.0 |
198 | 2019-08-31 00:35:58 | hogfish | 1 | 69583 | 4 | 0.990 | 70285.9 |