History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gramps"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
417 | 2024-04-15 13:53:39 | gramps | 1 | 48755 | 13 | 3.343 | 14584.2 |
416 | 2024-04-03 06:17:46 | gramps | 1 | 48755 | 13 | 0.966 | 50471.0 |
415 | 2024-03-31 10:42:39 | gramps | 1 | 48755 | 13 | 1.936 | 25183.4 |
414 | 2024-03-04 02:52:09 | gramps | 1 | 48755 | 13 | 1.936 | 25183.4 |
413 | 2024-03-04 02:50:52 | gramps | 2 | 82551 | 103 | 2.140 | 38575.2 |
412 | 2024-02-25 22:50:49 | gramps | 1 | 48755 | 13 | 0.983 | 49598.2 |
411 | 2024-02-22 15:47:16 | gramps | 1 | 48755 | 13 | 0.856 | 56956.8 |
410 | 2024-02-21 15:28:48 | gramps | 1 | 48755 | 13 | 1.893 | 25755.4 |
409 | 2024-01-27 07:10:21 | gramps | 1 | 48755 | 13 | 0.860 | 56691.9 |
408 | 2024-01-14 12:58:37 | gramps | 2 | 82551 | 103 | 2.516 | 32810.4 |
407 | 2024-01-10 01:20:49 | gramps | 1 | 48755 | 13 | 0.813 | 59969.2 |
406 | 2023-12-18 19:28:24 | gramps | 2 | 82551 | 103 | 2.376 | 34743.7 |
405 | 2023-12-06 21:33:49 | gramps | 1 | 48755 | 13 | 1.000 | 48755.0 |
404 | 2023-12-02 06:56:19 | gramps | 2 | 82551 | 103 | 2.453 | 33653.1 |
403 | 2023-11-22 09:20:37 | gramps | 1 | 48755 | 13 | 1.626 | 29984.6 |
402 | 2023-11-17 00:24:45 | gramps | 1 | 48755 | 13 | 0.796 | 61250.0 |
401 | 2023-11-08 18:41:39 | gramps | 1 | 48755 | 13 | 0.810 | 60191.4 |
400 | 2023-11-02 14:13:18 | gramps | 1 | 48755 | 13 | 0.736 | 66243.2 |
399 | 2023-10-30 19:18:46 | gramps | 1 | 48755 | 13 | 1.406 | 34676.4 |
398 | 2023-10-27 21:04:11 | gramps | 1 | 48755 | 13 | 0.860 | 56691.9 |
397 | 2023-10-26 00:30:45 | gramps | 1 | 48755 | 13 | 0.890 | 54780.9 |
396 | 2023-10-25 22:00:12 | gramps | 1 | 48755 | 13 | 0.860 | 56691.9 |
395 | 2023-10-24 14:54:13 | gramps | 1 | 48755 | 13 | 0.796 | 61250.0 |
394 | 2023-10-12 22:13:35 | gramps | 1 | 48755 | 13 | 0.843 | 57835.1 |
393 | 2023-10-04 07:28:21 | gramps | 1 | 48755 | 13 | 0.750 | 65006.7 |
392 | 2023-09-27 18:49:26 | gramps | 1 | 48755 | 13 | 0.966 | 50471.0 |
391 | 2023-09-19 22:39:40 | gramps | 2 | 82551 | 103 | 2.093 | 39441.5 |
390 | 2023-09-18 03:44:12 | gramps | 1 | 48755 | 13 | 0.843 | 57835.1 |
389 | 2023-09-14 04:08:02 | gramps | 1 | 48755 | 13 | 0.846 | 57630.0 |
388 | 2023-08-25 17:44:44 | gramps | 1 | 48755 | 13 | 0.716 | 68093.6 |
387 | 2023-08-20 06:09:55 | gramps | 1 | 48755 | 13 | 0.716 | 68093.6 |
386 | 2023-07-03 14:15:45 | gramps | 1 | 48755 | 13 | 0.860 | 56691.9 |
385 | 2023-07-01 19:43:43 | gramps | 1 | 48755 | 13 | 1.860 | 26212.4 |
384 | 2023-06-27 21:04:32 | gramps | 2 | 82551 | 103 | 2.436 | 33887.9 |
383 | 2023-05-27 10:51:20 | gramps | 1 | 48755 | 13 | 0.800 | 60943.8 |
382 | 2023-03-21 18:51:15 | gramps | 1 | 48755 | 13 | 0.720 | 67715.3 |
381 | 2023-03-21 05:41:49 | gramps | 2 | 82551 | 103 | 2.093 | 39441.5 |
380 | 2023-03-15 11:21:40 | gramps | 1 | 48755 | 13 | 0.843 | 57835.1 |
379 | 2023-01-08 02:02:20 | gramps | 1 | 48755 | 13 | 0.720 | 67715.3 |
378 | 2022-12-21 00:38:56 | gramps | 2 | 82551 | 103 | 2.346 | 35188.0 |
377 | 2022-11-24 02:41:34 | gramps | 1 | 48755 | 13 | 0.766 | 63648.8 |
376 | 2022-10-05 22:58:24 | gramps | 1 | 48755 | 13 | 0.750 | 65006.7 |
375 | 2022-09-12 16:10:39 | gramps | 1 | 48755 | 13 | 0.733 | 66514.3 |
374 | 2022-08-26 14:29:57 | gramps | 1 | 48755 | 13 | 0.810 | 60191.4 |
373 | 2022-08-16 08:16:50 | gramps | 2 | 82551 | 103 | 2.686 | 30733.8 |
372 | 2022-08-09 13:53:15 | gramps | 1 | 48755 | 13 | 0.720 | 67715.3 |
371 | 2022-08-01 04:29:32 | gramps | 1 | 48755 | 13 | 0.856 | 56956.8 |
370 | 2022-07-27 20:55:16 | gramps | 1 | 48755 | 13 | 0.766 | 63648.8 |
369 | 2022-07-21 17:46:17 | gramps | 1 | 48755 | 13 | 0.733 | 66514.3 |
368 | 2022-07-05 18:07:16 | gramps | 1 | 48755 | 13 | 0.736 | 66243.2 |
367 | 2022-05-22 01:00:34 | gramps | 1 | 48755 | 13 | 0.750 | 65006.7 |
366 | 2022-05-19 19:51:03 | gramps | 1 | 48755 | 13 | 0.766 | 63648.8 |
365 | 2022-03-26 08:27:08 | gramps | 1 | 48755 | 13 | 0.720 | 67715.3 |
364 | 2022-03-12 11:05:50 | gramps | 2 | 82551 | 103 | 2.500 | 33020.4 |
363 | 2022-02-07 17:14:11 | gramps | 1 | 48755 | 13 | 0.810 | 60191.4 |
362 | 2022-02-05 14:39:53 | gramps | 1 | 48755 | 13 | 0.890 | 54780.9 |
361 | 2021-12-05 17:50:57 | gramps | 1 | 48755 | 13 | 0.736 | 66243.2 |
360 | 2021-11-25 06:52:27 | gramps | 1 | 48755 | 13 | 0.736 | 66243.2 |
359 | 2021-10-08 23:34:07 | gramps | 1 | 48755 | 13 | 0.830 | 58741.0 |
358 | 2021-09-20 22:46:57 | gramps | 2 | 82551 | 103 | 2.126 | 38829.3 |
357 | 2021-09-04 17:36:08 | gramps | 1 | 48755 | 13 | 0.810 | 60191.4 |
356 | 2021-08-26 01:11:48 | gramps | 1 | 48755 | 13 | 0.720 | 67715.3 |
355 | 2021-08-18 03:55:41 | gramps | 1 | 48755 | 13 | 0.733 | 66514.3 |
354 | 2021-08-09 12:30:38 | gramps | 1 | 48755 | 13 | 0.720 | 67715.3 |
353 | 2021-07-25 18:31:39 | gramps | 1 | 48755 | 13 | 0.733 | 66514.3 |
352 | 2021-05-25 05:54:02 | gramps | 1 | 48755 | 13 | 0.830 | 58741.0 |
351 | 2021-05-16 04:51:23 | gramps | 1 | 48755 | 13 | 0.766 | 63648.8 |
350 | 2021-02-26 04:14:37 | gramps | 1 | 48755 | 13 | 0.936 | 52088.7 |
349 | 2021-02-21 20:11:50 | gramps | 1 | 48755 | 13 | 0.796 | 61250.0 |
348 | 2021-02-19 17:11:26 | gramps | 1 | 48755 | 13 | 0.783 | 62266.9 |
347 | 2021-01-01 06:10:09 | gramps | 1 | 48755 | 13 | 0.720 | 67715.3 |
346 | 2020-12-31 04:55:33 | gramps | 1 | 48755 | 13 | 0.766 | 63648.8 |
345 | 2020-11-16 01:52:45 | gramps | 1 | 48755 | 13 | 0.716 | 68093.6 |
344 | 2020-11-15 15:31:19 | gramps | 1 | 48755 | 13 | 0.733 | 66514.3 |
343 | 2020-11-05 11:22:53 | gramps | 1 | 48755 | 13 | 1.000 | 48755.0 |
342 | 2020-10-22 17:59:19 | gramps | 1 | 48755 | 13 | 0.813 | 59969.2 |
341 | 2020-10-14 06:05:15 | gramps | 1 | 48755 | 13 | 0.750 | 65006.7 |
340 | 2020-10-10 07:03:48 | gramps | 2 | 82551 | 103 | 2.093 | 39441.5 |
339 | 2020-09-23 19:50:41 | gramps | 1 | 48755 | 13 | 0.720 | 67715.3 |
338 | 2020-08-17 01:09:33 | gramps | 1 | 48755 | 13 | 1.623 | 30040.0 |
337 | 2020-08-13 22:58:56 | gramps | 1 | 48755 | 13 | 0.733 | 66514.3 |
336 | 2020-08-02 22:25:18 | gramps | 1 | 48755 | 13 | 0.750 | 65006.7 |
335 | 2020-08-01 06:18:13 | gramps | 1 | 48755 | 13 | 0.783 | 62266.9 |
334 | 2020-07-20 02:58:58 | gramps | 1 | 48755 | 13 | 0.826 | 59025.4 |
333 | 2020-07-19 03:02:43 | gramps | 1 | 48755 | 13 | 0.936 | 52088.7 |
332 | 2020-07-15 12:40:05 | gramps | 1 | 48755 | 13 | 0.843 | 57835.1 |
331 | 2020-06-14 01:14:32 | gramps | 1 | 48755 | 13 | 0.890 | 54780.9 |
330 | 2020-06-13 01:17:25 | gramps | 1 | 48755 | 13 | 0.750 | 65006.7 |
329 | 2020-06-12 01:05:16 | gramps | 1 | 48755 | 13 | 0.923 | 52822.3 |
328 | 2020-05-09 18:01:47 | gramps | 1 | 48755 | 13 | 0.733 | 66514.3 |
327 | 2020-04-14 01:42:02 | gramps | 1 | 48755 | 13 | 0.830 | 58741.0 |
326 | 2020-03-27 16:24:45 | gramps | 1 | 48755 | 13 | 1.716 | 28412.0 |
325 | 2020-03-25 06:13:00 | gramps | 1 | 48755 | 13 | 0.856 | 56956.8 |
324 | 2020-03-22 16:36:17 | gramps | 1 | 48755 | 13 | 0.843 | 57835.1 |
323 | 2020-03-22 10:16:16 | gramps | 1 | 48755 | 13 | 0.876 | 55656.4 |
322 | 2020-03-18 17:19:59 | gramps | 1 | 48755 | 13 | 1.546 | 31536.2 |
321 | 2020-02-26 19:16:45 | gramps | 1 | 48755 | 13 | 2.046 | 23829.4 |
320 | 2020-02-22 07:52:40 | gramps | 1 | 48755 | 13 | 1.903 | 25620.1 |
319 | 2020-02-21 07:47:31 | gramps | 1 | 48755 | 13 | 0.843 | 57835.1 |
318 | 2020-02-20 07:29:31 | gramps | 1 | 48755 | 13 | 0.893 | 54596.9 |