History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"needle"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
435 | 2024-04-27 11:13:34 | needle | 1 | 48755 | 4 | 2.953 | 16510.3 |
434 | 2024-04-10 07:19:16 | needle | 1 | 48755 | 4 | 0.890 | 54780.9 |
433 | 2024-03-31 19:25:17 | needle | 3 | 112716 | 390 | 14.546 | 7748.9 |
432 | 2024-03-30 22:30:47 | needle | 2 | 82551 | 27 | 4.986 | 16556.6 |
431 | 2024-03-30 05:34:50 | needle | 2 | 82551 | 27 | 5.436 | 15186.0 |
430 | 2024-03-30 05:34:33 | needle | 3 | 112716 | 390 | 6.986 | 16134.6 |
429 | 2024-03-29 16:43:12 | needle | 2 | 82551 | 27 | 2.673 | 30883.3 |
428 | 2024-03-29 16:42:54 | needle | 3 | 112716 | 390 | 5.906 | 19085.0 |
427 | 2024-03-29 11:13:04 | needle | 2 | 82551 | 27 | 7.953 | 10379.9 |
426 | 2024-03-29 07:06:58 | needle | 1 | 48755 | 4 | 2.953 | 16510.3 |
425 | 2024-03-29 06:44:32 | needle | 3 | 112716 | 390 | 22.143 | 5090.4 |
424 | 2024-03-29 06:38:25 | needle | 1 | 48755 | 4 | 2.343 | 20808.8 |
423 | 2024-03-29 06:38:11 | needle | 3 | 112716 | 390 | 12.516 | 9005.8 |
422 | 2024-03-29 06:38:12 | needle | 2 | 82551 | 27 | 8.236 | 10023.2 |
421 | 2024-03-29 06:38:04 | needle | 1 | 48755 | 4 | 1.876 | 25988.8 |
420 | 2024-03-09 04:33:33 | needle | 2 | 82551 | 27 | 2.406 | 34310.5 |
419 | 2024-03-06 21:01:36 | needle | 1 | 48755 | 4 | 0.903 | 53992.2 |
418 | 2024-03-05 23:30:40 | needle | 1 | 48755 | 4 | 1.890 | 25796.3 |
417 | 2024-02-28 10:34:22 | needle | 2 | 82551 | 27 | 2.686 | 30733.8 |
416 | 2024-02-28 10:33:58 | needle | 3 | 112716 | 390 | 7.983 | 14119.5 |
415 | 2024-02-28 04:24:30 | needle | 2 | 82551 | 27 | 4.716 | 17504.5 |
414 | 2024-02-28 04:05:10 | needle | 3 | 112716 | 390 | 6.296 | 17902.8 |
413 | 2024-02-28 04:04:43 | needle | 3 | 112716 | 390 | 5.920 | 19039.9 |
412 | 2024-02-28 04:04:43 | needle | 2 | 82551 | 27 | 3.033 | 27217.6 |
411 | 2024-02-28 04:04:38 | needle | 1 | 48755 | 4 | 1.813 | 26891.9 |
410 | 2024-01-17 07:23:06 | needle | 3 | 112716 | 390 | 5.690 | 19809.5 |
409 | 2024-01-14 00:47:15 | needle | 2 | 82551 | 27 | 2.143 | 38521.2 |
408 | 2024-01-04 13:49:10 | needle | 1 | 48755 | 4 | 0.830 | 58741.0 |
407 | 2023-12-15 00:22:50 | needle | 3 | 112716 | 390 | 5.640 | 19985.1 |
406 | 2023-12-15 00:22:43 | needle | 2 | 82551 | 27 | 2.420 | 34112.0 |
405 | 2023-12-14 01:16:41 | needle | 1 | 48755 | 4 | 0.936 | 52088.7 |
404 | 2023-12-02 16:05:26 | needle | 3 | 112716 | 390 | 5.313 | 21215.1 |
403 | 2023-12-02 14:05:26 | needle | 2 | 82551 | 27 | 5.283 | 15625.8 |
402 | 2023-11-24 02:36:31 | needle | 2 | 82551 | 27 | 2.420 | 34112.0 |
401 | 2023-11-17 07:01:04 | needle | 1 | 48755 | 4 | 0.733 | 66514.3 |
400 | 2023-11-11 14:05:58 | needle | 1 | 48755 | 4 | 0.843 | 57835.1 |
399 | 2023-11-11 11:24:39 | needle | 1 | 48755 | 4 | 0.810 | 60191.4 |
398 | 2023-11-01 23:48:14 | needle | 1 | 48755 | 4 | 0.813 | 59969.2 |
397 | 2023-10-22 06:11:16 | needle | 1 | 48755 | 4 | 0.733 | 66514.3 |
396 | 2023-10-15 02:33:57 | needle | 1 | 48755 | 4 | 0.813 | 59969.2 |
395 | 2023-10-08 04:46:50 | needle | 1 | 48755 | 4 | 1.750 | 27860.0 |
394 | 2023-09-30 11:33:42 | needle | 1 | 48755 | 4 | 0.860 | 56691.9 |
393 | 2023-09-27 04:48:39 | needle | 1 | 48755 | 4 | 1.343 | 36303.1 |
392 | 2023-09-14 08:33:16 | needle | 1 | 48755 | 4 | 0.796 | 61250.0 |
391 | 2023-09-09 02:30:03 | needle | 1 | 48755 | 4 | 0.780 | 62506.4 |
390 | 2023-08-23 12:02:58 | needle | 2 | 82551 | 27 | 2.143 | 38521.2 |
389 | 2023-07-27 02:52:38 | needle | 1 | 48755 | 4 | 0.720 | 67715.3 |
388 | 2023-05-19 17:35:44 | needle | 1 | 48755 | 4 | 0.736 | 66243.2 |
387 | 2023-05-06 12:37:21 | needle | 2 | 82551 | 27 | 2.063 | 40015.0 |
386 | 2023-04-23 09:15:56 | needle | 1 | 48755 | 4 | 0.733 | 66514.3 |
385 | 2023-02-15 20:19:21 | needle | 1 | 48755 | 4 | 0.813 | 59969.2 |
384 | 2023-02-12 12:42:54 | needle | 2 | 82551 | 27 | 2.080 | 39688.0 |
383 | 2023-01-26 22:22:54 | needle | 1 | 48755 | 4 | 0.716 | 68093.6 |
382 | 2022-12-13 16:36:29 | needle | 1 | 48755 | 4 | 0.733 | 66514.3 |
381 | 2022-11-24 08:43:38 | needle | 2 | 82551 | 27 | 2.106 | 39198.0 |
380 | 2022-10-05 10:01:19 | needle | 1 | 48755 | 4 | 0.733 | 66514.3 |
379 | 2022-08-18 18:07:25 | needle | 1 | 48755 | 4 | 0.890 | 54780.9 |
378 | 2022-08-06 18:58:46 | needle | 1 | 48755 | 4 | 0.733 | 66514.3 |
377 | 2022-07-30 07:45:49 | needle | 1 | 48755 | 4 | 0.750 | 65006.7 |
376 | 2022-07-29 23:59:47 | needle | 1 | 48755 | 4 | 0.763 | 63899.1 |
375 | 2022-07-03 06:51:56 | needle | 1 | 48755 | 4 | 0.813 | 59969.2 |
374 | 2022-06-16 06:53:59 | needle | 1 | 48755 | 4 | 0.813 | 59969.2 |
373 | 2022-06-15 16:13:22 | needle | 1 | 48755 | 4 | 0.860 | 56691.9 |
372 | 2022-05-31 20:54:43 | needle | 1 | 48755 | 4 | 0.720 | 67715.3 |
371 | 2022-05-26 01:30:04 | needle | 1 | 48755 | 4 | 0.736 | 66243.2 |
370 | 2022-05-25 19:21:07 | needle | 1 | 48755 | 4 | 0.736 | 66243.2 |
369 | 2022-04-21 07:15:26 | needle | 2 | 82551 | 27 | 2.106 | 39198.0 |
368 | 2022-04-07 05:03:07 | needle | 1 | 48755 | 4 | 0.750 | 65006.7 |
367 | 2022-04-05 02:36:00 | needle | 1 | 48755 | 4 | 0.923 | 52822.3 |
366 | 2022-01-30 19:50:10 | needle | 1 | 48755 | 4 | 0.826 | 59025.4 |
365 | 2022-01-06 17:21:49 | needle | 1 | 48755 | 4 | 0.783 | 62266.9 |
364 | 2021-11-04 22:14:43 | needle | 1 | 48755 | 4 | 0.750 | 65006.7 |
363 | 2021-10-13 22:40:33 | needle | 1 | 48755 | 4 | 0.830 | 58741.0 |
362 | 2021-10-11 07:07:33 | needle | 1 | 48755 | 4 | 0.813 | 59969.2 |
361 | 2021-10-10 17:00:01 | needle | 1 | 48755 | 4 | 0.843 | 57835.1 |
360 | 2021-08-12 17:14:05 | needle | 1 | 48755 | 4 | 0.843 | 57835.1 |
359 | 2021-07-08 23:46:31 | needle | 1 | 48755 | 4 | 0.843 | 57835.1 |
358 | 2021-05-11 00:21:12 | needle | 1 | 48755 | 4 | 0.873 | 55847.7 |
357 | 2021-04-05 01:35:33 | needle | 1 | 48755 | 4 | 0.953 | 51159.5 |
356 | 2021-03-31 22:24:05 | needle | 1 | 48755 | 4 | 0.873 | 55847.7 |
355 | 2020-12-23 19:15:52 | needle | 1 | 48755 | 4 | 0.750 | 65006.7 |
354 | 2020-10-24 01:31:34 | needle | 1 | 48755 | 4 | 0.733 | 66514.3 |
353 | 2020-10-17 09:39:27 | needle | 1 | 48755 | 4 | 0.846 | 57630.0 |
352 | 2020-10-10 20:34:16 | needle | 1 | 48755 | 4 | 0.733 | 66514.3 |
351 | 2020-09-19 20:43:32 | needle | 1 | 48755 | 4 | 0.733 | 66514.3 |
350 | 2020-08-25 10:17:18 | needle | 1 | 48755 | 4 | 0.750 | 65006.7 |
349 | 2020-08-24 06:42:28 | needle | 1 | 48755 | 4 | 0.736 | 66243.2 |
348 | 2020-08-18 04:34:37 | needle | 1 | 48755 | 4 | 0.733 | 66514.3 |
347 | 2020-08-01 10:37:46 | needle | 1 | 48755 | 4 | 0.873 | 55847.7 |
346 | 2020-07-31 09:01:29 | needle | 1 | 48755 | 4 | 0.766 | 63648.8 |
345 | 2020-07-22 20:10:57 | needle | 1 | 48755 | 4 | 0.796 | 61250.0 |
344 | 2020-06-09 14:02:41 | needle | 1 | 48755 | 4 | 0.826 | 59025.4 |
343 | 2020-04-15 04:37:06 | needle | 1 | 48755 | 4 | 0.750 | 65006.7 |
342 | 2020-03-28 02:08:05 | needle | 1 | 48755 | 4 | 1.763 | 27654.6 |
341 | 2020-03-25 02:16:13 | needle | 1 | 48755 | 4 | 0.826 | 59025.4 |
340 | 2020-03-24 12:03:02 | needle | 1 | 48755 | 4 | 0.890 | 54780.9 |
339 | 2020-03-23 08:38:44 | needle | 1 | 48755 | 4 | 0.923 | 52822.3 |
338 | 2020-03-19 22:13:09 | needle | 1 | 48755 | 4 | 0.796 | 61250.0 |
337 | 2020-03-02 06:45:53 | needle | 1 | 48755 | 4 | 0.826 | 59025.4 |
336 | 2020-02-28 18:35:49 | needle | 1 | 48755 | 4 | 1.076 | 45311.3 |