History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mercury"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
322 | 2024-05-16 08:21:29 | mercury | 3 | 134027 | 70 | 16.156 | 8295.8 |
321 | 2024-05-15 05:38:41 | mercury | 2 | 107671 | 9 | 7.656 | 14063.6 |
320 | 2024-05-15 05:38:39 | mercury | 3 | 134027 | 70 | 8.236 | 16273.3 |
319 | 2024-05-15 05:38:35 | mercury | 1 | 69583 | 2 | 1.766 | 39401.5 |
318 | 2024-05-15 05:37:04 | mercury | 4 | 151207 | 878 | 42.863 | 3527.7 |
317 | 2024-05-15 04:58:01 | mercury | 4 | 151207 | 878 | 12.626 | 11975.8 |
316 | 2024-05-15 04:02:55 | mercury | 4 | 151207 | 878 | 37.250 | 4059.2 |
315 | 2024-05-15 03:57:39 | mercury | 4 | 151207 | 878 | 36.270 | 4168.9 |
314 | 2024-05-15 01:54:54 | mercury | 4 | 151207 | 878 | 32.546 | 4645.9 |
313 | 2024-05-14 19:21:42 | mercury | 1 | 69583 | 2 | 4.236 | 16426.6 |
312 | 2024-05-08 00:37:12 | mercury | 1 | 69583 | 2 | 1.390 | 50059.7 |
311 | 2024-04-27 08:33:59 | mercury | 1 | 69583 | 2 | 1.233 | 56433.9 |
310 | 2024-04-20 15:05:40 | mercury | 3 | 134027 | 70 | 17.376 | 7713.3 |
309 | 2024-04-20 15:05:45 | mercury | 2 | 107671 | 9 | 9.280 | 11602.5 |
308 | 2024-04-13 18:38:00 | mercury | 4 | 151207 | 878 | 17.706 | 8539.9 |
307 | 2024-04-13 16:20:33 | mercury | 2 | 107671 | 9 | 3.300 | 32627.6 |
306 | 2024-04-13 16:20:21 | mercury | 3 | 134027 | 70 | 5.813 | 23056.4 |
305 | 2024-04-13 04:44:21 | mercury | 4 | 151207 | 878 | 17.436 | 8672.1 |
304 | 2024-04-12 20:47:32 | mercury | 4 | 151207 | 878 | 19.626 | 7704.4 |
303 | 2024-04-10 23:55:50 | mercury | 3 | 134027 | 70 | 7.406 | 18097.1 |
302 | 2024-04-10 20:48:40 | mercury | 4 | 151207 | 878 | 41.673 | 3628.4 |
301 | 2024-04-10 10:12:50 | mercury | 4 | 151207 | 878 | 37.223 | 4062.2 |
300 | 2024-04-10 10:12:52 | mercury | 3 | 134027 | 70 | 13.673 | 9802.3 |
299 | 2024-04-10 10:12:50 | mercury | 2 | 107671 | 9 | 8.876 | 12130.6 |
298 | 2024-04-10 10:12:47 | mercury | 1 | 69583 | 2 | 3.453 | 20151.5 |
297 | 2024-04-08 02:04:15 | mercury | 1 | 69583 | 2 | 3.483 | 19977.9 |
296 | 2024-04-03 15:53:09 | mercury | 1 | 69583 | 2 | 2.873 | 24219.6 |
295 | 2024-03-29 09:01:37 | mercury | 1 | 69583 | 2 | 4.013 | 17339.4 |
294 | 2024-03-14 17:59:25 | mercury | 3 | 134027 | 70 | 17.003 | 7882.6 |
293 | 2024-03-14 17:59:27 | mercury | 2 | 107671 | 9 | 7.826 | 13758.1 |
292 | 2024-03-05 02:09:30 | mercury | 1 | 69583 | 2 | 3.483 | 19977.9 |
291 | 2024-02-28 08:30:13 | mercury | 4 | 151207 | 878 | 38.270 | 3951.1 |
290 | 2024-02-28 08:30:17 | mercury | 3 | 134027 | 70 | 24.953 | 5371.2 |
289 | 2024-02-28 08:30:16 | mercury | 2 | 107671 | 9 | 9.203 | 11699.6 |
288 | 2024-02-28 07:52:10 | mercury | 1 | 69583 | 2 | 1.266 | 54962.9 |
287 | 2024-02-25 03:41:43 | mercury | 1 | 69583 | 2 | 1.123 | 61961.7 |
286 | 2024-02-18 12:47:59 | mercury | 3 | 134027 | 70 | 12.046 | 11126.3 |
285 | 2024-02-14 22:58:36 | mercury | 3 | 134027 | 70 | 17.983 | 7453.0 |
284 | 2024-02-14 22:58:33 | mercury | 2 | 107671 | 9 | 10.626 | 10132.8 |
283 | 2024-02-09 22:15:05 | mercury | 2 | 107671 | 9 | 4.143 | 25988.7 |
282 | 2024-02-09 22:11:01 | mercury | 3 | 134027 | 70 | 6.873 | 19500.5 |
281 | 2024-02-09 05:36:50 | mercury | 2 | 107671 | 9 | 7.406 | 14538.3 |
280 | 2024-02-09 05:36:38 | mercury | 3 | 134027 | 70 | 7.063 | 18975.9 |
279 | 2024-02-09 02:05:26 | mercury | 3 | 134027 | 70 | 15.330 | 8742.8 |
278 | 2024-02-07 23:00:55 | mercury | 4 | 151207 | 878 | 22.563 | 6701.5 |
277 | 2024-02-07 08:42:06 | mercury | 4 | 151207 | 878 | 13.626 | 11096.9 |
276 | 2024-01-27 03:10:45 | mercury | 4 | 151207 | 878 | 12.330 | 12263.3 |
275 | 2024-01-27 02:48:11 | mercury | 4 | 151207 | 878 | 10.720 | 14105.1 |
274 | 2024-01-13 06:53:08 | mercury | 2 | 107671 | 9 | 2.936 | 36672.7 |
273 | 2024-01-10 21:51:46 | mercury | 4 | 151207 | 878 | 17.173 | 8804.9 |
272 | 2024-01-05 21:23:50 | mercury | 3 | 134027 | 70 | 14.766 | 9076.7 |
271 | 2024-01-01 08:59:48 | mercury | 2 | 107671 | 9 | 2.923 | 36835.8 |
270 | 2023-12-29 06:21:08 | mercury | 1 | 69583 | 2 | 1.080 | 64428.7 |
269 | 2023-12-28 06:15:23 | mercury | 3 | 134027 | 70 | 6.783 | 19759.3 |
268 | 2023-12-05 21:39:00 | mercury | 1 | 69583 | 2 | 1.170 | 59472.6 |
267 | 2023-11-30 16:46:23 | mercury | 4 | 151207 | 878 | 9.953 | 15192.1 |
266 | 2023-11-22 22:44:36 | mercury | 4 | 151207 | 878 | 11.673 | 12953.6 |
265 | 2023-11-17 23:33:10 | mercury | 1 | 69583 | 2 | 1.080 | 64428.7 |
264 | 2023-11-13 13:23:18 | mercury | 1 | 69583 | 2 | 1.186 | 58670.3 |
263 | 2023-11-13 06:21:56 | mercury | 3 | 134027 | 70 | 6.906 | 19407.3 |
262 | 2023-11-09 11:03:13 | mercury | 4 | 151207 | 878 | 11.516 | 13130.2 |
261 | 2023-10-26 01:24:12 | mercury | 1 | 69583 | 2 | 1.123 | 61961.7 |
260 | 2023-10-23 08:42:34 | mercury | 4 | 151207 | 878 | 12.593 | 12007.2 |
259 | 2023-10-23 02:58:53 | mercury | 1 | 69583 | 2 | 2.313 | 30083.4 |
258 | 2023-10-19 17:20:19 | mercury | 4 | 151207 | 878 | 12.843 | 11773.5 |
257 | 2023-10-19 02:48:19 | mercury | 4 | 151207 | 878 | 9.830 | 15382.2 |
256 | 2023-10-16 13:58:26 | mercury | 1 | 69583 | 2 | 1.593 | 43680.5 |
255 | 2023-09-28 04:15:01 | mercury | 1 | 69583 | 2 | 1.186 | 58670.3 |
254 | 2023-09-19 08:30:21 | mercury | 1 | 69583 | 2 | 1.060 | 65644.3 |
253 | 2023-09-13 11:54:53 | mercury | 1 | 69583 | 2 | 1.156 | 60192.9 |
252 | 2023-08-15 10:00:32 | mercury | 3 | 134027 | 70 | 6.326 | 21186.7 |
251 | 2023-07-29 11:30:53 | mercury | 4 | 151207 | 878 | 9.830 | 15382.2 |
250 | 2023-07-11 04:14:44 | mercury | 1 | 69583 | 2 | 1.216 | 57222.9 |
249 | 2023-06-11 08:12:16 | mercury | 1 | 69583 | 2 | 1.156 | 60192.9 |
248 | 2023-04-26 13:29:20 | mercury | 3 | 134027 | 70 | 5.720 | 23431.3 |
247 | 2023-04-11 21:25:08 | mercury | 1 | 69583 | 2 | 1.046 | 66522.9 |
246 | 2023-04-06 14:49:14 | mercury | 4 | 151207 | 878 | 9.766 | 15483.0 |
245 | 2023-02-09 15:06:15 | mercury | 1 | 69583 | 2 | 1.046 | 66522.9 |
244 | 2023-02-03 01:08:42 | mercury | 1 | 69583 | 2 | 1.046 | 66522.9 |
243 | 2023-01-29 03:17:48 | mercury | 3 | 134027 | 70 | 6.563 | 20421.6 |
242 | 2023-01-03 01:31:03 | mercury | 4 | 151207 | 878 | 14.076 | 10742.2 |
241 | 2022-12-02 10:42:34 | mercury | 1 | 69583 | 2 | 1.063 | 65459.1 |
240 | 2022-11-11 06:59:49 | mercury | 3 | 134027 | 70 | 5.686 | 23571.4 |
239 | 2022-09-12 11:10:50 | mercury | 1 | 69583 | 2 | 1.063 | 65459.1 |
238 | 2022-09-07 17:08:08 | mercury | 4 | 151207 | 878 | 9.733 | 15535.5 |
237 | 2022-08-15 10:51:47 | mercury | 1 | 69583 | 2 | 1.173 | 59320.5 |
236 | 2022-08-14 03:52:27 | mercury | 1 | 69583 | 2 | 1.216 | 57222.9 |
235 | 2022-07-29 09:49:07 | mercury | 1 | 69583 | 2 | 1.106 | 62914.1 |
234 | 2022-06-21 19:21:41 | mercury | 1 | 69583 | 2 | 1.063 | 65459.1 |
233 | 2022-06-13 04:57:46 | mercury | 3 | 134027 | 70 | 5.843 | 22938.0 |
232 | 2022-04-28 17:03:44 | mercury | 4 | 151207 | 878 | 13.030 | 11604.5 |
231 | 2022-03-24 16:58:58 | mercury | 4 | 151207 | 878 | 12.173 | 12421.5 |
230 | 2022-03-21 21:41:34 | mercury | 1 | 69583 | 2 | 1.156 | 60192.9 |
229 | 2022-03-19 16:27:19 | mercury | 1 | 69583 | 2 | 1.080 | 64428.7 |
228 | 2022-02-06 09:44:00 | mercury | 1 | 69583 | 2 | 1.080 | 64428.7 |
227 | 2022-01-30 04:50:07 | mercury | 3 | 134027 | 70 | 5.830 | 22989.2 |
226 | 2021-12-25 15:21:03 | mercury | 1 | 69583 | 2 | 1.173 | 59320.5 |
225 | 2021-12-23 12:29:50 | mercury | 1 | 69583 | 2 | 1.376 | 50569.0 |
224 | 2021-12-05 08:25:41 | mercury | 4 | 151207 | 878 | 11.766 | 12851.2 |
223 | 2021-11-02 14:54:36 | mercury | 3 | 134027 | 70 | 5.753 | 23296.9 |