History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"optics"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
372 | 2024-04-27 17:15:55 | optics | 1 | 48755 | 2 | 1.876 | 25988.8 |
371 | 2024-04-24 14:05:27 | optics | 1 | 48755 | 2 | 3.343 | 14584.2 |
370 | 2024-03-31 23:03:35 | optics | 1 | 48755 | 2 | 0.813 | 59969.2 |
369 | 2024-03-31 10:06:49 | optics | 1 | 48755 | 2 | 2.780 | 17537.8 |
368 | 2024-03-29 23:30:13 | optics | 1 | 48755 | 2 | 2.593 | 18802.5 |
367 | 2024-02-28 03:55:07 | optics | 1 | 48755 | 2 | 0.876 | 55656.4 |
366 | 2024-02-13 13:43:51 | optics | 2 | 82551 | 28 | 2.830 | 29170.0 |
365 | 2024-01-31 18:18:48 | optics | 2 | 82551 | 28 | 2.610 | 31628.7 |
364 | 2024-01-30 00:53:26 | optics | 2 | 82551 | 28 | 2.440 | 33832.4 |
363 | 2024-01-30 00:50:47 | optics | 2 | 82551 | 28 | 2.580 | 31996.5 |
362 | 2024-01-30 00:50:23 | optics | 3 | 112716 | 410 | 4.780 | 23580.8 |
361 | 2024-01-30 00:49:38 | optics | 3 | 112716 | 410 | 5.440 | 20719.9 |
360 | 2024-01-29 23:29:45 | optics | 2 | 82551 | 28 | 5.440 | 15174.8 |
359 | 2024-01-29 23:29:13 | optics | 3 | 112716 | 410 | 6.253 | 18025.9 |
358 | 2024-01-29 21:03:33 | optics | 3 | 112716 | 410 | 5.470 | 20606.2 |
357 | 2023-12-21 03:18:37 | optics | 1 | 48755 | 2 | 0.796 | 61250.0 |
356 | 2023-12-03 15:37:00 | optics | 1 | 48755 | 2 | 0.813 | 59969.2 |
355 | 2023-11-19 04:24:24 | optics | 2 | 82551 | 28 | 2.343 | 35233.0 |
354 | 2023-11-16 21:24:09 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
353 | 2023-11-15 12:09:50 | optics | 2 | 82551 | 28 | 2.200 | 37523.2 |
352 | 2023-11-13 22:36:08 | optics | 2 | 82551 | 28 | 2.330 | 35429.6 |
351 | 2023-11-13 22:36:02 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
350 | 2023-11-09 04:44:15 | optics | 3 | 112716 | 410 | 5.250 | 21469.7 |
349 | 2023-11-07 22:23:21 | optics | 3 | 112716 | 410 | 4.903 | 22989.2 |
348 | 2023-11-06 18:29:06 | optics | 3 | 112716 | 410 | 5.296 | 21283.2 |
347 | 2023-11-05 08:09:56 | optics | 1 | 48755 | 2 | 0.733 | 66514.3 |
346 | 2023-11-04 15:46:04 | optics | 1 | 48755 | 2 | 0.720 | 67715.3 |
345 | 2023-10-23 17:54:43 | optics | 1 | 48755 | 2 | 0.936 | 52088.7 |
344 | 2023-10-19 00:07:22 | optics | 1 | 48755 | 2 | 0.813 | 59969.2 |
343 | 2023-10-13 12:49:15 | optics | 1 | 48755 | 2 | 0.796 | 61250.0 |
342 | 2023-10-07 13:31:49 | optics | 1 | 48755 | 2 | 0.846 | 57630.0 |
341 | 2023-09-26 08:11:52 | optics | 1 | 48755 | 2 | 0.763 | 63899.1 |
340 | 2023-09-15 23:56:13 | optics | 1 | 48755 | 2 | 0.840 | 58041.7 |
339 | 2023-08-16 01:10:08 | optics | 2 | 82551 | 28 | 2.110 | 39123.7 |
338 | 2023-08-11 13:34:44 | optics | 3 | 112716 | 410 | 5.346 | 21084.2 |
337 | 2023-08-03 16:57:07 | optics | 1 | 48755 | 2 | 0.830 | 58741.0 |
336 | 2023-08-03 06:12:30 | optics | 1 | 48755 | 2 | 0.733 | 66514.3 |
335 | 2023-05-02 03:20:16 | optics | 1 | 48755 | 2 | 0.843 | 57835.1 |
334 | 2023-04-29 12:59:25 | optics | 2 | 82551 | 28 | 2.173 | 37989.4 |
333 | 2023-04-22 12:35:43 | optics | 1 | 48755 | 2 | 0.736 | 66243.2 |
332 | 2023-04-22 10:06:10 | optics | 3 | 112716 | 410 | 4.593 | 24540.8 |
331 | 2023-02-22 16:26:46 | optics | 1 | 48755 | 2 | 0.720 | 67715.3 |
330 | 2023-02-22 10:16:36 | optics | 2 | 82551 | 28 | 2.313 | 35690.0 |
329 | 2023-02-03 04:54:21 | optics | 2 | 82551 | 28 | 2.093 | 39441.5 |
328 | 2023-01-25 20:35:18 | optics | 2 | 82551 | 28 | 2.360 | 34979.2 |
327 | 2023-01-25 19:10:13 | optics | 3 | 112716 | 410 | 4.656 | 24208.8 |
326 | 2023-01-12 22:23:56 | optics | 3 | 112716 | 410 | 4.563 | 24702.2 |
325 | 2022-12-29 22:16:24 | optics | 1 | 48755 | 2 | 0.716 | 68093.6 |
324 | 2022-12-25 19:18:55 | optics | 2 | 82551 | 28 | 2.060 | 40073.3 |
323 | 2022-12-19 23:48:16 | optics | 1 | 48755 | 2 | 0.846 | 57630.0 |
322 | 2022-12-11 15:37:41 | optics | 3 | 112716 | 410 | 5.436 | 20735.1 |
321 | 2022-11-16 02:57:18 | optics | 2 | 82551 | 28 | 2.096 | 39385.0 |
320 | 2022-11-06 22:32:27 | optics | 3 | 112716 | 410 | 4.640 | 24292.2 |
319 | 2022-10-01 23:13:53 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
318 | 2022-09-18 04:45:40 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
317 | 2022-09-04 20:32:28 | optics | 1 | 48755 | 2 | 0.736 | 66243.2 |
316 | 2022-08-30 20:06:47 | optics | 1 | 48755 | 2 | 0.796 | 61250.0 |
315 | 2022-08-30 09:10:45 | optics | 3 | 112716 | 410 | 4.673 | 24120.7 |
314 | 2022-08-07 12:52:41 | optics | 1 | 48755 | 2 | 0.720 | 67715.3 |
313 | 2022-08-07 00:52:09 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
312 | 2022-07-09 22:34:10 | optics | 3 | 112716 | 410 | 4.860 | 23192.6 |
311 | 2022-06-25 17:15:34 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
310 | 2022-06-18 04:10:58 | optics | 2 | 82551 | 28 | 2.346 | 35188.0 |
309 | 2022-06-15 23:53:40 | optics | 2 | 82551 | 28 | 2.110 | 39123.7 |
308 | 2022-06-05 05:21:01 | optics | 3 | 112716 | 410 | 4.733 | 23814.9 |
307 | 2022-05-18 15:40:04 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
306 | 2022-05-06 06:32:54 | optics | 1 | 48755 | 2 | 0.736 | 66243.2 |
305 | 2022-05-02 19:55:49 | optics | 1 | 48755 | 2 | 0.893 | 54596.9 |
304 | 2022-03-06 02:28:54 | optics | 1 | 48755 | 2 | 0.736 | 66243.2 |
303 | 2022-01-30 17:18:31 | optics | 2 | 82551 | 28 | 2.093 | 39441.5 |
302 | 2022-01-18 15:43:38 | optics | 1 | 48755 | 2 | 0.736 | 66243.2 |
301 | 2022-01-15 09:05:01 | optics | 1 | 48755 | 2 | 0.780 | 62506.4 |
300 | 2021-12-22 22:03:40 | optics | 1 | 48755 | 2 | 0.876 | 55656.4 |
299 | 2021-10-30 01:30:46 | optics | 2 | 82551 | 28 | 2.186 | 37763.5 |
298 | 2021-10-29 20:27:08 | optics | 1 | 48755 | 2 | 0.796 | 61250.0 |
297 | 2021-10-27 20:07:15 | optics | 1 | 48755 | 2 | 0.860 | 56691.9 |
296 | 2021-10-05 20:30:24 | optics | 1 | 48755 | 2 | 0.813 | 59969.2 |
295 | 2021-09-16 00:59:43 | optics | 1 | 48755 | 2 | 0.733 | 66514.3 |
294 | 2021-08-31 21:02:01 | optics | 2 | 82551 | 28 | 2.076 | 39764.5 |
293 | 2021-08-16 14:10:56 | optics | 2 | 82551 | 28 | 2.220 | 37185.1 |
292 | 2021-08-14 05:31:28 | optics | 1 | 48755 | 2 | 0.733 | 66514.3 |
291 | 2021-08-12 01:56:04 | optics | 1 | 48755 | 2 | 0.736 | 66243.2 |
290 | 2021-07-07 00:09:28 | optics | 1 | 48755 | 2 | 0.860 | 56691.9 |
289 | 2021-07-05 07:30:08 | optics | 2 | 82551 | 28 | 2.373 | 34787.6 |
288 | 2021-07-03 10:50:28 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
287 | 2021-06-16 17:25:26 | optics | 1 | 48755 | 2 | 0.843 | 57835.1 |
286 | 2021-05-13 01:44:23 | optics | 1 | 48755 | 2 | 0.813 | 59969.2 |
285 | 2021-03-29 17:04:07 | optics | 1 | 48755 | 2 | 1.546 | 31536.2 |
284 | 2021-03-27 08:12:46 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
283 | 2021-03-25 08:39:32 | optics | 1 | 48755 | 2 | 0.843 | 57835.1 |
282 | 2021-03-21 00:56:05 | optics | 1 | 48755 | 2 | 0.906 | 53813.5 |
281 | 2021-03-01 10:34:38 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
280 | 2021-01-10 16:10:58 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
279 | 2020-12-18 03:54:30 | optics | 1 | 48755 | 2 | 0.750 | 65006.7 |
278 | 2020-10-27 15:20:02 | optics | 1 | 48755 | 2 | 0.826 | 59025.4 |
277 | 2020-10-24 03:11:35 | optics | 1 | 48755 | 2 | 0.733 | 66514.3 |
276 | 2020-10-16 16:41:24 | optics | 1 | 48755 | 2 | 0.813 | 59969.2 |
275 | 2020-10-09 16:12:25 | optics | 1 | 48755 | 2 | 0.733 | 66514.3 |
274 | 2020-09-28 22:06:43 | optics | 1 | 48755 | 2 | 0.736 | 66243.2 |
273 | 2020-09-14 06:05:31 | optics | 1 | 48755 | 2 | 0.733 | 66514.3 |