History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pastime"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
362 | 2024-05-02 07:06:55 | pastime | 1 | 69583 | 3 | 1.296 | 53690.6 |
361 | 2024-02-20 21:00:38 | pastime | 1 | 69583 | 3 | 1.330 | 52318.0 |
360 | 2024-01-29 23:24:01 | pastime | 3 | 134027 | 285 | 9.076 | 14767.2 |
359 | 2024-01-29 09:32:39 | pastime | 1 | 69583 | 3 | 1.173 | 59320.5 |
358 | 2024-01-25 17:16:33 | pastime | 2 | 107671 | 30 | 4.860 | 22154.5 |
357 | 2024-01-24 06:38:24 | pastime | 3 | 134027 | 285 | 5.860 | 22871.5 |
356 | 2024-01-18 20:40:53 | pastime | 1 | 69583 | 3 | 1.110 | 62687.4 |
355 | 2024-01-10 02:40:22 | pastime | 3 | 134027 | 285 | 7.093 | 18895.7 |
354 | 2024-01-10 02:40:24 | pastime | 2 | 107671 | 30 | 3.576 | 30109.3 |
353 | 2023-11-28 13:03:25 | pastime | 1 | 69583 | 3 | 1.110 | 62687.4 |
352 | 2023-11-28 03:22:20 | pastime | 1 | 69583 | 3 | 1.393 | 49951.9 |
351 | 2023-11-24 00:43:18 | pastime | 1 | 69583 | 3 | 1.250 | 55666.4 |
350 | 2023-11-20 06:45:23 | pastime | 1 | 69583 | 3 | 1.236 | 56296.9 |
349 | 2023-11-14 18:21:04 | pastime | 1 | 69583 | 3 | 1.280 | 54361.7 |
348 | 2023-11-05 09:17:15 | pastime | 1 | 69583 | 3 | 1.250 | 55666.4 |
347 | 2023-11-04 13:57:57 | pastime | 3 | 134027 | 285 | 7.950 | 16858.7 |
346 | 2023-11-04 07:50:08 | pastime | 2 | 107671 | 30 | 2.876 | 37437.8 |
345 | 2023-10-26 14:17:58 | pastime | 1 | 69583 | 3 | 1.216 | 57222.9 |
344 | 2023-10-23 04:36:25 | pastime | 1 | 69583 | 3 | 1.250 | 55666.4 |
343 | 2023-10-14 01:39:36 | pastime | 1 | 69583 | 3 | 1.220 | 57035.2 |
342 | 2023-09-29 17:32:20 | pastime | 1 | 69583 | 3 | 1.263 | 55093.4 |
341 | 2023-09-26 16:06:34 | pastime | 1 | 69583 | 3 | 1.076 | 64668.2 |
340 | 2023-09-09 12:12:42 | pastime | 1 | 69583 | 3 | 1.063 | 65459.1 |
339 | 2023-08-09 23:08:19 | pastime | 3 | 134027 | 285 | 5.983 | 22401.3 |
338 | 2023-08-09 07:35:57 | pastime | 2 | 107671 | 30 | 2.936 | 36672.7 |
337 | 2023-08-01 06:19:59 | pastime | 1 | 69583 | 3 | 1.266 | 54962.9 |
336 | 2023-06-23 02:01:42 | pastime | 1 | 69583 | 3 | 1.283 | 54234.6 |
335 | 2023-04-22 05:39:34 | pastime | 3 | 134027 | 285 | 5.796 | 23124.1 |
334 | 2023-04-19 12:15:18 | pastime | 2 | 107671 | 30 | 2.923 | 36835.8 |
333 | 2023-04-16 12:54:34 | pastime | 1 | 69583 | 3 | 1.266 | 54962.9 |
332 | 2023-04-12 20:07:36 | pastime | 1 | 69583 | 3 | 1.076 | 64668.2 |
331 | 2023-04-06 21:39:23 | pastime | 1 | 69583 | 3 | 1.080 | 64428.7 |
330 | 2023-01-24 06:13:44 | pastime | 3 | 134027 | 285 | 6.733 | 19906.0 |
329 | 2023-01-21 17:55:38 | pastime | 1 | 69583 | 3 | 1.233 | 56433.9 |
328 | 2023-01-20 17:44:10 | pastime | 2 | 107671 | 30 | 2.873 | 37476.9 |
327 | 2022-12-27 13:50:39 | pastime | 1 | 69583 | 3 | 1.080 | 64428.7 |
326 | 2022-12-12 10:41:26 | pastime | 3 | 134027 | 285 | 7.080 | 18930.4 |
325 | 2022-11-19 10:18:08 | pastime | 1 | 69583 | 3 | 1.093 | 63662.4 |
324 | 2022-11-04 23:52:57 | pastime | 3 | 134027 | 285 | 6.563 | 20421.6 |
323 | 2022-10-30 17:14:09 | pastime | 2 | 107671 | 30 | 2.876 | 37437.8 |
322 | 2022-08-30 12:53:40 | pastime | 1 | 69583 | 3 | 1.060 | 65644.3 |
321 | 2022-07-13 14:04:30 | pastime | 1 | 69583 | 3 | 1.093 | 63662.4 |
320 | 2022-07-11 05:17:40 | pastime | 1 | 69583 | 3 | 1.096 | 63488.1 |
319 | 2022-07-09 00:17:18 | pastime | 1 | 69583 | 3 | 1.076 | 64668.2 |
318 | 2022-06-06 19:11:51 | pastime | 3 | 134027 | 285 | 5.970 | 22450.1 |
317 | 2022-05-26 17:07:44 | pastime | 2 | 107671 | 30 | 2.893 | 37217.8 |
316 | 2022-04-26 15:20:37 | pastime | 1 | 69583 | 3 | 1.140 | 61037.7 |
315 | 2022-04-22 23:31:42 | pastime | 1 | 69583 | 3 | 1.170 | 59472.6 |
314 | 2022-03-09 10:35:21 | pastime | 1 | 69583 | 3 | 1.516 | 45899.1 |
313 | 2022-02-03 16:57:36 | pastime | 2 | 107671 | 30 | 2.890 | 37256.4 |
312 | 2022-01-25 23:49:40 | pastime | 3 | 134027 | 285 | 6.343 | 21129.9 |
311 | 2022-01-06 19:00:59 | pastime | 1 | 69583 | 3 | 1.343 | 51811.6 |
310 | 2021-12-21 21:53:37 | pastime | 1 | 69583 | 3 | 1.173 | 59320.5 |
309 | 2021-10-28 21:57:07 | pastime | 1 | 69583 | 3 | 1.313 | 52995.4 |
308 | 2021-10-06 07:31:08 | pastime | 1 | 69583 | 3 | 1.236 | 56296.9 |
307 | 2021-09-30 15:02:43 | pastime | 1 | 69583 | 3 | 1.250 | 55666.4 |
306 | 2021-07-26 19:38:07 | pastime | 1 | 69583 | 3 | 1.093 | 63662.4 |
305 | 2021-07-22 12:13:01 | pastime | 2 | 107671 | 30 | 2.966 | 36301.8 |
304 | 2021-07-01 05:38:54 | pastime | 1 | 69583 | 3 | 1.156 | 60192.9 |
303 | 2021-06-29 00:06:28 | pastime | 2 | 107671 | 30 | 3.453 | 31181.9 |
302 | 2021-05-17 12:28:03 | pastime | 1 | 69583 | 3 | 1.203 | 57841.2 |
301 | 2021-04-17 12:08:58 | pastime | 1 | 69583 | 3 | 1.233 | 56433.9 |
300 | 2021-04-10 23:57:33 | pastime | 2 | 107671 | 30 | 3.373 | 31921.4 |
299 | 2021-03-31 06:24:05 | pastime | 1 | 69583 | 3 | 1.093 | 63662.4 |
298 | 2021-03-20 09:01:29 | pastime | 1 | 69583 | 3 | 1.126 | 61796.6 |
297 | 2021-02-18 02:36:17 | pastime | 2 | 107671 | 30 | 3.580 | 30075.7 |
296 | 2021-01-29 23:57:48 | pastime | 1 | 69583 | 3 | 1.106 | 62914.1 |
295 | 2021-01-01 19:15:15 | pastime | 1 | 69583 | 3 | 1.093 | 63662.4 |
294 | 2020-12-26 19:25:24 | pastime | 1 | 69583 | 3 | 1.093 | 63662.4 |
293 | 2020-11-09 14:54:20 | pastime | 2 | 107671 | 30 | 2.983 | 36094.9 |
292 | 2020-10-22 19:37:06 | pastime | 1 | 69583 | 3 | 1.093 | 63662.4 |
291 | 2020-10-17 13:57:33 | pastime | 1 | 69583 | 3 | 1.313 | 52995.4 |
290 | 2020-10-15 06:07:12 | pastime | 1 | 69583 | 3 | 1.233 | 56433.9 |
289 | 2020-10-09 05:35:17 | pastime | 1 | 69583 | 3 | 1.080 | 64428.7 |
288 | 2020-09-23 02:47:15 | pastime | 1 | 69583 | 3 | 1.123 | 61961.7 |
287 | 2020-08-02 10:16:24 | pastime | 1 | 69583 | 3 | 1.190 | 58473.1 |
286 | 2020-07-26 07:06:55 | pastime | 1 | 69583 | 3 | 2.436 | 28564.4 |
285 | 2020-06-15 11:48:15 | pastime | 1 | 69583 | 3 | 1.296 | 53690.6 |
284 | 2020-06-06 04:49:37 | pastime | 1 | 69583 | 3 | 1.170 | 59472.6 |
283 | 2020-06-03 07:54:26 | pastime | 1 | 69583 | 3 | 1.153 | 60349.5 |
282 | 2020-03-29 07:02:31 | pastime | 1 | 69583 | 3 | 1.453 | 47889.2 |
281 | 2020-03-24 13:45:20 | pastime | 1 | 69583 | 3 | 2.610 | 26660.2 |
280 | 2020-03-22 09:18:13 | pastime | 1 | 69583 | 3 | 1.296 | 53690.6 |
279 | 2020-03-21 03:26:48 | pastime | 1 | 69583 | 3 | 1.173 | 59320.5 |
278 | 2020-03-20 23:02:19 | pastime | 1 | 69583 | 3 | 1.470 | 47335.4 |
277 | 2020-02-28 17:43:02 | pastime | 3 | 134027 | 285 | 15.080 | 8887.7 |
276 | 2020-02-28 08:02:13 | pastime | 3 | 134027 | 285 | 12.113 | 11064.7 |
275 | 2020-02-28 07:02:15 | pastime | 3 | 134027 | 285 | 8.110 | 16526.1 |
274 | 2020-02-28 05:43:30 | pastime | 1 | 69583 | 3 | 2.596 | 26803.9 |
273 | 2020-02-28 05:11:54 | pastime | 3 | 134027 | 285 | 6.596 | 20319.4 |
272 | 2020-02-28 00:27:15 | pastime | 3 | 134027 | 285 | 14.656 | 9144.9 |
271 | 2020-02-27 20:11:18 | pastime | 3 | 134027 | 285 | 12.096 | 11080.3 |
270 | 2020-02-24 19:06:26 | pastime | 1 | 69583 | 3 | 1.093 | 63662.4 |
269 | 2020-02-17 00:29:49 | pastime | 1 | 69583 | 3 | 1.360 | 51164.0 |
268 | 2020-02-07 02:34:07 | pastime | 1 | 69583 | 3 | 2.826 | 24622.4 |
267 | 2020-02-06 21:34:41 | pastime | 1 | 69583 | 3 | 1.983 | 35089.8 |
266 | 2020-02-04 09:07:22 | pastime | 1 | 69583 | 3 | 1.283 | 54234.6 |
265 | 2020-02-01 08:06:41 | pastime | 1 | 69583 | 3 | 1.360 | 51164.0 |
264 | 2020-01-30 16:52:46 | pastime | 1 | 69583 | 3 | 2.580 | 26970.2 |
263 | 2020-01-27 04:18:06 | pastime | 1 | 69583 | 3 | 1.300 | 53525.4 |