History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"protei"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
400 | 2024-04-27 10:43:41 | protei | 1 | 48755 | 4 | 0.873 | 55847.7 |
399 | 2024-04-27 04:05:37 | protei | 1 | 48755 | 4 | 2.873 | 16970.1 |
398 | 2024-04-05 17:12:47 | protei | 1 | 48755 | 4 | 1.796 | 27146.4 |
397 | 2024-03-19 23:43:30 | protei | 1 | 48755 | 4 | 2.843 | 17149.1 |
396 | 2024-03-06 01:13:03 | protei | 3 | 112716 | 744 | 11.016 | 10232.0 |
395 | 2024-03-04 20:44:57 | protei | 2 | 82551 | 50 | 2.940 | 28078.6 |
394 | 2024-03-04 20:44:25 | protei | 1 | 48755 | 4 | 1.826 | 26700.4 |
393 | 2024-03-04 20:43:59 | protei | 3 | 112716 | 744 | 8.563 | 13163.1 |
392 | 2024-03-04 14:24:31 | protei | 3 | 112716 | 744 | 7.453 | 15123.6 |
391 | 2024-03-04 09:31:17 | protei | 3 | 112716 | 744 | 15.220 | 7405.8 |
390 | 2024-03-04 09:30:03 | protei | 3 | 112716 | 744 | 6.563 | 17174.5 |
389 | 2024-03-04 09:30:04 | protei | 2 | 82551 | 50 | 2.826 | 29211.3 |
388 | 2024-03-04 09:30:02 | protei | 1 | 48755 | 4 | 0.970 | 50262.9 |
387 | 2024-02-28 08:17:47 | protei | 1 | 48755 | 4 | 0.920 | 52994.6 |
386 | 2024-02-27 19:20:11 | protei | 2 | 82551 | 50 | 2.140 | 38575.2 |
385 | 2024-02-27 18:27:05 | protei | 2 | 82551 | 50 | 2.343 | 35233.0 |
384 | 2024-02-02 20:00:04 | protei | 2 | 82551 | 50 | 4.766 | 17320.8 |
383 | 2024-02-02 19:59:40 | protei | 3 | 112716 | 744 | 5.376 | 20966.5 |
382 | 2024-02-01 07:19:20 | protei | 2 | 82551 | 50 | 2.250 | 36689.3 |
381 | 2024-02-01 07:16:56 | protei | 3 | 112716 | 744 | 5.390 | 20912.1 |
380 | 2024-02-01 05:03:12 | protei | 3 | 112716 | 744 | 9.296 | 12125.2 |
379 | 2024-01-20 05:18:54 | protei | 3 | 112716 | 744 | 4.783 | 23566.0 |
378 | 2024-01-20 04:50:09 | protei | 1 | 48755 | 4 | 0.800 | 60943.8 |
377 | 2023-12-09 02:27:57 | protei | 1 | 48755 | 4 | 1.720 | 28345.9 |
376 | 2023-12-08 04:24:44 | protei | 2 | 82551 | 50 | 2.580 | 31996.5 |
375 | 2023-12-08 04:24:41 | protei | 2 | 82551 | 50 | 2.593 | 31836.1 |
374 | 2023-12-08 02:18:18 | protei | 3 | 112716 | 744 | 5.970 | 18880.4 |
373 | 2023-12-08 02:18:19 | protei | 2 | 82551 | 50 | 2.513 | 32849.6 |
372 | 2023-12-07 22:54:03 | protei | 3 | 112716 | 744 | 5.830 | 19333.8 |
371 | 2023-12-07 22:53:57 | protei | 3 | 112716 | 744 | 5.686 | 19823.4 |
370 | 2023-12-06 07:24:57 | protei | 3 | 112716 | 744 | 5.406 | 20850.2 |
369 | 2023-11-21 10:34:26 | protei | 2 | 82551 | 50 | 2.343 | 35233.0 |
368 | 2023-11-19 21:38:23 | protei | 1 | 48755 | 4 | 0.876 | 55656.4 |
367 | 2023-11-15 19:48:16 | protei | 1 | 48755 | 4 | 1.280 | 38089.8 |
366 | 2023-11-10 15:16:33 | protei | 1 | 48755 | 4 | 0.936 | 52088.7 |
365 | 2023-11-06 00:41:39 | protei | 1 | 48755 | 4 | 0.876 | 55656.4 |
364 | 2023-11-05 21:23:32 | protei | 3 | 112716 | 744 | 5.236 | 21527.1 |
363 | 2023-10-28 03:22:51 | protei | 3 | 112716 | 744 | 10.126 | 11131.3 |
362 | 2023-10-23 11:53:30 | protei | 1 | 48755 | 4 | 0.813 | 59969.2 |
361 | 2023-10-18 08:00:44 | protei | 1 | 48755 | 4 | 0.750 | 65006.7 |
360 | 2023-10-16 07:47:23 | protei | 1 | 48755 | 4 | 0.750 | 65006.7 |
359 | 2023-09-24 23:07:27 | protei | 1 | 48755 | 4 | 0.763 | 63899.1 |
358 | 2023-09-24 21:06:46 | protei | 1 | 48755 | 4 | 0.813 | 59969.2 |
357 | 2023-09-03 13:36:27 | protei | 1 | 48755 | 4 | 0.780 | 62506.4 |
356 | 2023-08-21 17:48:02 | protei | 2 | 82551 | 50 | 2.470 | 33421.5 |
355 | 2023-08-09 09:34:02 | protei | 3 | 112716 | 744 | 4.763 | 23664.9 |
354 | 2023-08-05 23:29:57 | protei | 1 | 48755 | 4 | 0.783 | 62266.9 |
353 | 2023-05-05 16:37:11 | protei | 2 | 82551 | 50 | 2.123 | 38884.1 |
352 | 2023-04-13 17:32:33 | protei | 1 | 48755 | 4 | 0.750 | 65006.7 |
351 | 2023-04-12 18:34:06 | protei | 3 | 112716 | 744 | 4.656 | 24208.8 |
350 | 2023-03-28 01:33:14 | protei | 1 | 48755 | 4 | 0.750 | 65006.7 |
349 | 2023-02-12 00:21:48 | protei | 2 | 82551 | 50 | 2.170 | 38041.9 |
348 | 2023-01-27 12:57:54 | protei | 3 | 112716 | 744 | 5.000 | 22543.2 |
347 | 2023-01-19 01:02:45 | protei | 3 | 112716 | 744 | 4.656 | 24208.8 |
346 | 2023-01-11 13:53:19 | protei | 1 | 48755 | 4 | 0.733 | 66514.3 |
345 | 2022-12-24 18:45:52 | protei | 1 | 48755 | 4 | 0.736 | 66243.2 |
344 | 2022-11-22 19:30:38 | protei | 2 | 82551 | 50 | 2.140 | 38575.2 |
343 | 2022-10-29 00:29:26 | protei | 3 | 112716 | 744 | 4.656 | 24208.8 |
342 | 2022-10-14 21:05:06 | protei | 1 | 48755 | 4 | 0.733 | 66514.3 |
341 | 2022-08-24 13:34:31 | protei | 1 | 48755 | 4 | 0.813 | 59969.2 |
340 | 2022-06-04 10:03:58 | protei | 1 | 48755 | 4 | 0.763 | 63899.1 |
339 | 2022-06-02 06:20:42 | protei | 1 | 48755 | 4 | 0.750 | 65006.7 |
338 | 2022-06-01 09:51:00 | protei | 3 | 112716 | 744 | 4.780 | 23580.8 |
337 | 2022-05-24 08:16:35 | protei | 3 | 112716 | 744 | 5.300 | 21267.2 |
336 | 2022-05-18 14:32:37 | protei | 1 | 48755 | 4 | 0.826 | 59025.4 |
335 | 2022-05-08 08:03:28 | protei | 2 | 82551 | 50 | 2.170 | 38041.9 |
334 | 2022-04-23 20:03:09 | protei | 1 | 48755 | 4 | 0.766 | 63648.8 |
333 | 2022-02-14 06:45:03 | protei | 1 | 48755 | 4 | 0.843 | 57835.1 |
332 | 2022-01-21 10:50:41 | protei | 3 | 112716 | 744 | 5.550 | 20309.2 |
331 | 2021-12-28 22:37:25 | protei | 1 | 48755 | 4 | 0.780 | 62506.4 |
330 | 2021-12-05 18:20:59 | protei | 1 | 48755 | 4 | 0.860 | 56691.9 |
329 | 2021-10-31 13:30:10 | protei | 1 | 48755 | 4 | 0.783 | 62266.9 |
328 | 2021-10-27 12:02:15 | protei | 3 | 112716 | 744 | 4.970 | 22679.3 |
327 | 2021-09-27 04:04:45 | protei | 3 | 112716 | 744 | 5.856 | 19248.0 |
326 | 2021-09-25 05:49:46 | protei | 3 | 112716 | 744 | 6.093 | 18499.3 |
325 | 2021-09-12 04:39:23 | protei | 1 | 48755 | 4 | 0.796 | 61250.0 |
324 | 2021-08-15 11:39:37 | protei | 3 | 112716 | 744 | 4.763 | 23664.9 |
323 | 2021-07-17 17:47:37 | protei | 2 | 82551 | 50 | 2.376 | 34743.7 |
322 | 2021-07-16 16:16:32 | protei | 3 | 112716 | 744 | 5.550 | 20309.2 |
321 | 2021-07-04 10:50:48 | protei | 1 | 48755 | 4 | 0.846 | 57630.0 |
320 | 2021-06-24 20:33:13 | protei | 1 | 48755 | 4 | 0.856 | 56956.8 |
319 | 2021-06-11 21:43:45 | protei | 1 | 48755 | 4 | 1.390 | 35075.5 |
318 | 2021-06-08 06:54:46 | protei | 3 | 112716 | 744 | 5.046 | 22337.7 |
317 | 2021-05-19 10:29:41 | protei | 1 | 48755 | 4 | 0.860 | 56691.9 |
316 | 2021-05-16 09:41:14 | protei | 3 | 112716 | 744 | 5.373 | 20978.2 |
315 | 2021-05-13 00:45:27 | protei | 3 | 112716 | 744 | 5.263 | 21416.7 |
314 | 2021-05-06 22:31:16 | protei | 2 | 82551 | 50 | 2.233 | 36968.7 |
313 | 2021-05-05 21:11:59 | protei | 3 | 112716 | 744 | 5.093 | 22131.6 |
312 | 2021-04-05 05:30:52 | protei | 2 | 82551 | 50 | 2.563 | 32208.7 |
311 | 2021-04-04 00:13:37 | protei | 3 | 112716 | 744 | 5.063 | 22262.7 |
310 | 2021-03-31 22:52:32 | protei | 1 | 48755 | 4 | 0.813 | 59969.2 |
309 | 2021-03-27 01:55:44 | protei | 3 | 112716 | 744 | 5.843 | 19290.8 |
308 | 2021-03-08 20:27:51 | protei | 1 | 48755 | 4 | 0.763 | 63899.1 |
307 | 2021-03-08 09:47:26 | protei | 3 | 112716 | 744 | 4.843 | 23274.0 |
306 | 2021-03-05 16:25:14 | protei | 1 | 48755 | 4 | 0.846 | 57630.0 |
305 | 2021-02-13 09:04:21 | protei | 2 | 82551 | 50 | 2.220 | 37185.1 |
304 | 2021-02-09 05:49:28 | protei | 3 | 112716 | 744 | 4.893 | 23036.2 |
303 | 2020-12-01 02:48:04 | protei | 1 | 48755 | 4 | 0.763 | 63899.1 |
302 | 2020-11-07 11:59:28 | protei | 3 | 112716 | 744 | 5.516 | 20434.4 |
301 | 2020-10-30 14:53:09 | protei | 3 | 112716 | 744 | 10.326 | 10915.7 |