History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prefect"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
355 | 2024-04-28 05:56:43 | prefect | 1 | 69583 | 6 | 4.796 | 14508.5 |
354 | 2024-04-28 05:28:37 | prefect | 1 | 69583 | 6 | 6.940 | 10026.4 |
353 | 2024-04-27 10:20:42 | prefect | 1 | 69583 | 6 | 1.483 | 46920.4 |
352 | 2024-04-13 18:08:15 | prefect | 3 | 134027 | 229 | 20.236 | 6623.2 |
351 | 2024-04-13 08:44:29 | prefect | 2 | 107671 | 37 | 3.623 | 29718.7 |
350 | 2024-04-13 08:43:45 | prefect | 3 | 134027 | 229 | 7.093 | 18895.7 |
349 | 2024-04-13 01:19:32 | prefect | 2 | 107671 | 37 | 3.673 | 29314.2 |
348 | 2024-04-13 01:04:29 | prefect | 2 | 107671 | 37 | 3.376 | 31893.1 |
347 | 2024-04-13 01:04:25 | prefect | 1 | 69583 | 6 | 1.313 | 52995.4 |
346 | 2024-04-13 01:04:13 | prefect | 3 | 134027 | 229 | 12.753 | 10509.4 |
345 | 2024-04-13 01:03:40 | prefect | 3 | 134027 | 229 | 8.140 | 16465.2 |
344 | 2024-04-11 01:18:15 | prefect | 3 | 134027 | 229 | 13.923 | 9626.3 |
343 | 2024-04-11 00:47:03 | prefect | 3 | 134027 | 229 | 6.640 | 20184.8 |
342 | 2024-04-03 15:59:28 | prefect | 1 | 69583 | 6 | 2.830 | 24587.6 |
341 | 2024-04-03 07:58:22 | prefect | 1 | 69583 | 6 | 3.720 | 18705.1 |
340 | 2024-04-03 07:58:01 | prefect | 1 | 69583 | 6 | 2.046 | 34009.3 |
339 | 2024-03-31 00:42:44 | prefect | 1 | 69583 | 6 | 4.110 | 16930.2 |
338 | 2024-03-29 05:03:04 | prefect | 1 | 69583 | 6 | 4.263 | 16322.5 |
337 | 2024-03-08 01:06:41 | prefect | 1 | 69583 | 6 | 2.923 | 23805.3 |
336 | 2024-02-27 20:32:58 | prefect | 1 | 69583 | 6 | 1.233 | 56433.9 |
335 | 2024-02-08 09:04:41 | prefect | 2 | 107671 | 37 | 3.626 | 29694.2 |
334 | 2024-02-08 09:03:17 | prefect | 3 | 134027 | 229 | 9.330 | 14365.2 |
333 | 2024-02-07 06:23:54 | prefect | 2 | 107671 | 37 | 3.376 | 31893.1 |
332 | 2024-02-07 06:19:38 | prefect | 3 | 134027 | 229 | 9.640 | 13903.2 |
331 | 2024-02-07 04:35:53 | prefect | 2 | 107671 | 37 | 2.843 | 37872.3 |
330 | 2024-02-07 04:35:33 | prefect | 3 | 134027 | 229 | 6.970 | 19229.1 |
329 | 2024-02-07 04:22:38 | prefect | 2 | 107671 | 37 | 5.873 | 18333.2 |
328 | 2024-02-07 04:21:42 | prefect | 3 | 134027 | 229 | 6.673 | 20085.0 |
327 | 2024-02-06 19:27:47 | prefect | 3 | 134027 | 229 | 5.830 | 22989.2 |
326 | 2024-02-06 19:27:43 | prefect | 2 | 107671 | 37 | 2.843 | 37872.3 |
325 | 2024-02-06 19:27:39 | prefect | 1 | 69583 | 6 | 1.203 | 57841.2 |
324 | 2024-01-07 17:21:57 | prefect | 1 | 69583 | 6 | 1.093 | 63662.4 |
323 | 2023-12-20 00:10:59 | prefect | 3 | 134027 | 229 | 8.940 | 14991.8 |
322 | 2023-12-19 15:48:12 | prefect | 1 | 69583 | 6 | 1.123 | 61961.7 |
321 | 2023-12-09 17:39:20 | prefect | 3 | 134027 | 229 | 6.000 | 22337.8 |
320 | 2023-12-06 15:02:00 | prefect | 1 | 69583 | 6 | 2.763 | 25183.9 |
319 | 2023-11-19 04:16:01 | prefect | 1 | 69583 | 6 | 1.250 | 55666.4 |
318 | 2023-11-15 15:53:27 | prefect | 1 | 69583 | 6 | 1.236 | 56296.9 |
317 | 2023-11-07 14:15:14 | prefect | 1 | 69583 | 6 | 1.220 | 57035.2 |
316 | 2023-10-23 11:53:38 | prefect | 1 | 69583 | 6 | 1.203 | 57841.2 |
315 | 2023-10-05 22:03:05 | prefect | 1 | 69583 | 6 | 1.156 | 60192.9 |
314 | 2023-09-14 20:19:17 | prefect | 1 | 69583 | 6 | 1.080 | 64428.7 |
313 | 2023-09-07 10:29:14 | prefect | 3 | 134027 | 229 | 6.186 | 21666.2 |
312 | 2023-08-02 02:04:30 | prefect | 1 | 69583 | 6 | 1.216 | 57222.9 |
311 | 2023-07-17 20:58:29 | prefect | 1 | 69583 | 6 | 1.093 | 63662.4 |
310 | 2023-06-29 16:09:39 | prefect | 3 | 134027 | 229 | 5.736 | 23365.9 |
309 | 2023-05-19 00:39:38 | prefect | 3 | 134027 | 229 | 5.796 | 23124.1 |
308 | 2023-04-25 21:31:35 | prefect | 1 | 69583 | 6 | 1.236 | 56296.9 |
307 | 2023-03-26 05:46:30 | prefect | 1 | 69583 | 6 | 1.190 | 58473.1 |
306 | 2023-02-28 00:42:27 | prefect | 3 | 134027 | 229 | 5.736 | 23365.9 |
305 | 2023-02-17 15:22:58 | prefect | 1 | 69583 | 6 | 1.190 | 58473.1 |
304 | 2023-01-13 03:38:29 | prefect | 3 | 134027 | 229 | 6.580 | 20368.8 |
303 | 2022-12-16 06:23:10 | prefect | 1 | 69583 | 6 | 1.173 | 59320.5 |
302 | 2022-12-08 03:42:18 | prefect | 3 | 134027 | 229 | 8.000 | 16753.4 |
301 | 2022-12-01 09:12:53 | prefect | 1 | 69583 | 6 | 1.063 | 65459.1 |
300 | 2022-11-28 02:12:27 | prefect | 1 | 69583 | 6 | 1.076 | 64668.2 |
299 | 2022-08-23 09:18:13 | prefect | 1 | 69583 | 6 | 1.060 | 65644.3 |
298 | 2022-07-28 14:56:28 | prefect | 1 | 69583 | 6 | 1.546 | 45008.4 |
297 | 2022-04-09 06:43:09 | prefect | 1 | 69583 | 6 | 1.123 | 61961.7 |
296 | 2022-04-03 18:59:45 | prefect | 3 | 134027 | 229 | 6.783 | 19759.3 |
295 | 2022-03-30 14:40:34 | prefect | 1 | 69583 | 6 | 1.593 | 43680.5 |
294 | 2022-03-29 00:28:45 | prefect | 3 | 134027 | 229 | 6.300 | 21274.1 |
293 | 2022-01-06 13:36:30 | prefect | 1 | 69583 | 6 | 1.343 | 51811.6 |
292 | 2021-12-03 05:10:41 | prefect | 1 | 69583 | 6 | 1.110 | 62687.4 |
291 | 2021-11-04 18:38:31 | prefect | 1 | 69583 | 6 | 1.186 | 58670.3 |
290 | 2021-10-13 05:45:21 | prefect | 1 | 69583 | 6 | 1.203 | 57841.2 |
289 | 2021-08-23 12:12:38 | prefect | 1 | 69583 | 6 | 1.266 | 54962.9 |
288 | 2021-07-26 05:00:22 | prefect | 1 | 69583 | 6 | 1.076 | 64668.2 |
287 | 2021-07-26 02:55:44 | prefect | 1 | 69583 | 6 | 1.063 | 65459.1 |
286 | 2021-05-22 19:10:01 | prefect | 1 | 69583 | 6 | 1.216 | 57222.9 |
285 | 2021-05-16 21:50:23 | prefect | 1 | 69583 | 6 | 1.203 | 57841.2 |
284 | 2021-04-26 00:28:45 | prefect | 3 | 134027 | 229 | 7.080 | 18930.4 |
283 | 2021-04-16 17:02:20 | prefect | 1 | 69583 | 6 | 1.280 | 54361.7 |
282 | 2021-02-20 16:09:05 | prefect | 1 | 69583 | 6 | 1.110 | 62687.4 |
281 | 2021-01-29 11:39:17 | prefect | 1 | 69583 | 6 | 1.173 | 59320.5 |
280 | 2020-12-31 23:38:00 | prefect | 1 | 69583 | 6 | 1.200 | 57985.8 |
279 | 2020-11-19 06:21:53 | prefect | 1 | 69583 | 6 | 1.063 | 65459.1 |
278 | 2020-11-17 04:58:08 | prefect | 1 | 69583 | 6 | 1.123 | 61961.7 |
277 | 2020-11-10 09:52:11 | prefect | 3 | 134027 | 229 | 6.080 | 22043.9 |
276 | 2020-11-09 20:53:05 | prefect | 1 | 69583 | 6 | 1.110 | 62687.4 |
275 | 2020-11-08 01:53:25 | prefect | 3 | 134027 | 229 | 6.686 | 20045.9 |
274 | 2020-10-28 20:17:33 | prefect | 3 | 134027 | 229 | 6.656 | 20136.3 |
273 | 2020-10-17 03:30:53 | prefect | 1 | 69583 | 6 | 1.080 | 64428.7 |
272 | 2020-08-14 15:07:43 | prefect | 1 | 69583 | 6 | 1.093 | 63662.4 |
271 | 2020-05-23 08:06:18 | prefect | 3 | 134027 | 229 | 5.766 | 23244.4 |
270 | 2020-05-13 10:35:45 | prefect | 1 | 69583 | 6 | 1.250 | 55666.4 |
269 | 2020-03-28 16:41:41 | prefect | 1 | 69583 | 6 | 1.343 | 51811.6 |
268 | 2020-03-25 14:51:01 | prefect | 1 | 69583 | 6 | 1.186 | 58670.3 |
267 | 2020-03-25 03:19:38 | prefect | 1 | 69583 | 6 | 1.236 | 56296.9 |
266 | 2020-03-20 04:13:04 | prefect | 1 | 69583 | 6 | 1.203 | 57841.2 |
265 | 2020-02-29 05:45:01 | prefect | 3 | 134027 | 229 | 7.500 | 17870.3 |
264 | 2020-02-29 01:52:30 | prefect | 3 | 134027 | 229 | 7.643 | 17535.9 |
263 | 2020-02-28 14:34:17 | prefect | 3 | 134027 | 229 | 7.376 | 18170.7 |
262 | 2020-02-28 14:12:51 | prefect | 3 | 134027 | 229 | 15.706 | 8533.5 |
261 | 2020-02-28 13:49:20 | prefect | 3 | 134027 | 229 | 15.610 | 8586.0 |
260 | 2020-02-28 12:25:28 | prefect | 3 | 134027 | 229 | 15.516 | 8638.0 |
259 | 2020-02-27 22:46:41 | prefect | 3 | 134027 | 229 | 18.000 | 7445.9 |
258 | 2020-02-22 17:03:40 | prefect | 1 | 69583 | 6 | 1.236 | 56296.9 |
257 | 2020-02-22 14:17:31 | prefect | 1 | 69583 | 6 | 1.530 | 45479.1 |
256 | 2020-02-21 08:55:52 | prefect | 1 | 69583 | 6 | 4.313 | 16133.3 |