History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opened"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
445 | 2024-04-27 06:43:36 | opened | 1 | 48755 | 4 | 3.546 | 13749.3 |
444 | 2024-04-05 06:27:34 | opened | 3 | 112716 | 747 | 14.940 | 7544.6 |
443 | 2024-04-04 01:47:32 | opened | 2 | 82551 | 43 | 2.876 | 28703.4 |
442 | 2024-04-04 01:46:36 | opened | 3 | 112716 | 747 | 6.313 | 17854.6 |
441 | 2024-04-03 09:09:32 | opened | 3 | 112716 | 747 | 13.796 | 8170.2 |
440 | 2024-03-31 18:25:27 | opened | 1 | 48755 | 4 | 2.860 | 17047.2 |
439 | 2024-03-29 21:56:47 | opened | 2 | 82551 | 43 | 7.796 | 10588.9 |
438 | 2024-03-28 18:42:53 | opened | 2 | 82551 | 43 | 7.546 | 10939.7 |
437 | 2024-03-28 16:06:13 | opened | 3 | 112716 | 747 | 5.220 | 21593.1 |
436 | 2024-03-28 14:43:17 | opened | 2 | 82551 | 43 | 2.296 | 35954.3 |
435 | 2024-03-28 14:43:17 | opened | 1 | 48755 | 4 | 0.813 | 59969.2 |
434 | 2024-03-28 00:37:22 | opened | 3 | 112716 | 747 | 5.313 | 21215.1 |
433 | 2024-03-06 03:01:54 | opened | 3 | 112716 | 747 | 7.876 | 14311.3 |
432 | 2024-03-04 19:24:40 | opened | 3 | 112716 | 747 | 9.063 | 12436.9 |
431 | 2024-03-04 08:04:28 | opened | 3 | 112716 | 747 | 14.436 | 7808.0 |
430 | 2024-02-29 12:24:59 | opened | 3 | 112716 | 747 | 12.203 | 9236.7 |
429 | 2024-02-27 11:43:22 | opened | 3 | 112716 | 747 | 5.220 | 21593.1 |
428 | 2024-02-27 11:43:23 | opened | 2 | 82551 | 43 | 2.533 | 32590.2 |
427 | 2024-02-27 11:43:20 | opened | 1 | 48755 | 4 | 0.766 | 63648.8 |
426 | 2024-02-05 14:06:27 | opened | 2 | 82551 | 43 | 2.356 | 35038.6 |
425 | 2024-01-31 18:01:08 | opened | 2 | 82551 | 43 | 2.470 | 33421.5 |
424 | 2024-01-31 18:00:44 | opened | 3 | 112716 | 747 | 6.686 | 16858.5 |
423 | 2024-01-30 06:58:42 | opened | 2 | 82551 | 43 | 2.250 | 36689.3 |
422 | 2024-01-30 06:57:06 | opened | 3 | 112716 | 747 | 5.013 | 22484.7 |
421 | 2024-01-29 14:27:31 | opened | 3 | 112716 | 747 | 5.576 | 20214.5 |
420 | 2024-01-29 14:27:27 | opened | 1 | 48755 | 4 | 0.953 | 51159.5 |
419 | 2024-01-20 19:52:24 | opened | 1 | 48755 | 4 | 0.826 | 59025.4 |
418 | 2024-01-16 22:57:07 | opened | 2 | 82551 | 43 | 2.733 | 30205.3 |
417 | 2024-01-14 05:02:44 | opened | 3 | 112716 | 747 | 5.670 | 19879.4 |
416 | 2024-01-10 22:26:05 | opened | 2 | 82551 | 43 | 2.623 | 31472.0 |
415 | 2024-01-01 16:22:48 | opened | 2 | 82551 | 43 | 4.486 | 18401.9 |
414 | 2023-12-23 05:53:25 | opened | 3 | 112716 | 747 | 5.063 | 22262.7 |
413 | 2023-12-22 12:35:19 | opened | 3 | 112716 | 747 | 5.453 | 20670.5 |
412 | 2023-12-16 17:50:30 | opened | 3 | 112716 | 747 | 5.936 | 18988.5 |
411 | 2023-12-09 22:03:06 | opened | 1 | 48755 | 4 | 0.830 | 58741.0 |
410 | 2023-12-01 23:59:30 | opened | 3 | 112716 | 747 | 4.783 | 23566.0 |
409 | 2023-11-17 05:19:36 | opened | 1 | 48755 | 4 | 0.766 | 63648.8 |
408 | 2023-11-17 01:50:35 | opened | 1 | 48755 | 4 | 0.800 | 60943.8 |
407 | 2023-11-16 14:04:11 | opened | 1 | 48755 | 4 | 0.893 | 54596.9 |
406 | 2023-11-16 01:50:07 | opened | 3 | 112716 | 747 | 4.700 | 23982.1 |
405 | 2023-11-12 15:01:07 | opened | 2 | 82551 | 43 | 2.110 | 39123.7 |
404 | 2023-11-12 04:05:14 | opened | 3 | 112716 | 747 | 4.906 | 22975.1 |
403 | 2023-11-12 04:05:06 | opened | 2 | 82551 | 43 | 2.080 | 39688.0 |
402 | 2023-11-06 10:31:42 | opened | 1 | 48755 | 4 | 0.796 | 61250.0 |
401 | 2023-11-04 23:59:04 | opened | 1 | 48755 | 4 | 1.610 | 30282.6 |
400 | 2023-10-21 08:48:24 | opened | 1 | 48755 | 4 | 0.843 | 57835.1 |
399 | 2023-10-13 15:50:12 | opened | 1 | 48755 | 4 | 0.750 | 65006.7 |
398 | 2023-10-08 16:16:44 | opened | 1 | 48755 | 4 | 0.736 | 66243.2 |
397 | 2023-09-26 10:11:41 | opened | 1 | 48755 | 4 | 0.813 | 59969.2 |
396 | 2023-09-25 16:03:22 | opened | 1 | 48755 | 4 | 0.736 | 66243.2 |
395 | 2023-09-17 04:17:27 | opened | 1 | 48755 | 4 | 0.810 | 60191.4 |
394 | 2023-09-04 05:03:35 | opened | 1 | 48755 | 4 | 0.736 | 66243.2 |
393 | 2023-08-30 11:10:11 | opened | 3 | 112716 | 747 | 5.500 | 20493.8 |
392 | 2023-08-15 05:02:40 | opened | 2 | 82551 | 43 | 2.420 | 34112.0 |
391 | 2023-08-13 23:00:04 | opened | 1 | 48755 | 4 | 0.733 | 66514.3 |
390 | 2023-08-11 00:30:54 | opened | 3 | 112716 | 747 | 4.766 | 23650.0 |
389 | 2023-05-17 15:21:10 | opened | 3 | 112716 | 747 | 4.703 | 23966.8 |
388 | 2023-05-10 03:35:44 | opened | 3 | 112716 | 747 | 5.033 | 22395.4 |
387 | 2023-04-29 05:47:42 | opened | 1 | 48755 | 4 | 0.736 | 66243.2 |
386 | 2023-04-27 16:40:25 | opened | 2 | 82551 | 43 | 2.233 | 36968.7 |
385 | 2023-04-06 15:19:13 | opened | 3 | 112716 | 747 | 5.060 | 22275.9 |
384 | 2023-03-13 08:51:47 | opened | 3 | 112716 | 747 | 6.220 | 18121.5 |
383 | 2023-03-02 16:49:24 | opened | 1 | 48755 | 4 | 0.733 | 66514.3 |
382 | 2023-02-23 05:55:38 | opened | 3 | 112716 | 747 | 4.736 | 23799.8 |
381 | 2023-01-31 10:58:20 | opened | 2 | 82551 | 43 | 2.076 | 39764.5 |
380 | 2023-01-05 17:57:54 | opened | 1 | 48755 | 4 | 0.843 | 57835.1 |
379 | 2022-12-26 18:34:38 | opened | 1 | 48755 | 4 | 0.720 | 67715.3 |
378 | 2022-12-06 03:00:05 | opened | 3 | 112716 | 747 | 4.610 | 24450.3 |
377 | 2022-11-12 18:01:18 | opened | 2 | 82551 | 43 | 2.076 | 39764.5 |
376 | 2022-09-15 00:32:39 | opened | 1 | 48755 | 4 | 0.736 | 66243.2 |
375 | 2022-09-11 06:43:51 | opened | 1 | 48755 | 4 | 1.720 | 28345.9 |
374 | 2022-09-04 03:23:53 | opened | 3 | 112716 | 747 | 4.673 | 24120.7 |
373 | 2022-09-01 05:21:30 | opened | 1 | 48755 | 4 | 0.813 | 59969.2 |
372 | 2022-07-04 13:33:35 | opened | 3 | 112716 | 747 | 5.343 | 21096.0 |
371 | 2022-06-29 12:43:33 | opened | 3 | 112716 | 747 | 5.046 | 22337.7 |
370 | 2022-06-28 09:32:09 | opened | 3 | 112716 | 747 | 4.623 | 24381.6 |
369 | 2022-06-14 21:24:33 | opened | 2 | 82551 | 43 | 2.203 | 37472.1 |
368 | 2022-05-12 05:49:42 | opened | 3 | 112716 | 747 | 4.826 | 23356.0 |
367 | 2022-05-09 08:59:39 | opened | 1 | 48755 | 4 | 0.810 | 60191.4 |
366 | 2022-04-25 07:25:44 | opened | 1 | 48755 | 4 | 0.860 | 56691.9 |
365 | 2022-04-08 21:25:48 | opened | 3 | 112716 | 747 | 5.453 | 20670.5 |
364 | 2022-01-31 19:22:31 | opened | 2 | 82551 | 43 | 2.156 | 38289.0 |
363 | 2022-01-29 15:47:03 | opened | 2 | 82551 | 43 | 2.546 | 32423.8 |
362 | 2022-01-21 07:33:07 | opened | 1 | 48755 | 4 | 0.750 | 65006.7 |
361 | 2022-01-18 19:10:08 | opened | 1 | 48755 | 4 | 0.750 | 65006.7 |
360 | 2022-01-18 01:06:44 | opened | 1 | 48755 | 4 | 0.750 | 65006.7 |
359 | 2022-01-14 18:18:06 | opened | 1 | 48755 | 4 | 0.873 | 55847.7 |
358 | 2021-12-19 19:29:14 | opened | 3 | 112716 | 747 | 5.016 | 22471.3 |
357 | 2021-12-16 01:44:05 | opened | 3 | 112716 | 747 | 5.703 | 19764.3 |
356 | 2021-12-16 00:20:13 | opened | 3 | 112716 | 747 | 5.186 | 21734.7 |
355 | 2021-11-16 12:50:43 | opened | 1 | 48755 | 4 | 0.750 | 65006.7 |
354 | 2021-11-08 07:15:34 | opened | 2 | 82551 | 43 | 2.123 | 38884.1 |
353 | 2021-10-08 11:30:53 | opened | 1 | 48755 | 4 | 0.766 | 63648.8 |
352 | 2021-10-06 17:05:00 | opened | 3 | 112716 | 747 | 5.486 | 20546.1 |
351 | 2021-10-02 04:44:42 | opened | 1 | 48755 | 4 | 0.813 | 59969.2 |
350 | 2021-08-30 16:49:02 | opened | 1 | 48755 | 4 | 0.733 | 66514.3 |
349 | 2021-08-15 10:53:01 | opened | 1 | 48755 | 4 | 0.720 | 67715.3 |
348 | 2021-07-27 21:10:40 | opened | 1 | 48755 | 4 | 0.750 | 65006.7 |
347 | 2021-07-06 07:23:42 | opened | 1 | 48755 | 4 | 0.733 | 66514.3 |
346 | 2021-07-02 18:37:25 | opened | 1 | 48755 | 4 | 0.826 | 59025.4 |