History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"locater"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
426 | 2024-04-18 21:21:20 | locater | 1 | 69583 | 6 | 1.203 | 57841.2 |
425 | 2024-04-08 09:46:47 | locater | 3 | 134027 | 489 | 26.266 | 5102.7 |
424 | 2024-04-08 06:37:13 | locater | 3 | 134027 | 489 | 9.656 | 13880.2 |
423 | 2024-04-07 11:03:03 | locater | 3 | 134027 | 489 | 27.516 | 4870.9 |
422 | 2024-04-07 05:18:22 | locater | 3 | 134027 | 489 | 38.113 | 3516.6 |
421 | 2024-04-06 10:28:41 | locater | 2 | 107671 | 32 | 8.453 | 12737.6 |
420 | 2024-04-06 10:23:47 | locater | 3 | 134027 | 489 | 13.923 | 9626.3 |
419 | 2024-04-06 10:23:41 | locater | 1 | 69583 | 6 | 1.420 | 49002.1 |
418 | 2024-04-05 20:03:10 | locater | 1 | 69583 | 6 | 1.813 | 38380.0 |
417 | 2024-03-29 03:16:57 | locater | 1 | 69583 | 6 | 2.266 | 30707.4 |
416 | 2024-02-27 23:20:21 | locater | 1 | 69583 | 6 | 3.890 | 17887.7 |
415 | 2024-02-17 18:05:49 | locater | 1 | 69583 | 6 | 1.280 | 54361.7 |
414 | 2024-02-05 19:46:14 | locater | 2 | 107671 | 32 | 3.110 | 34620.9 |
413 | 2024-02-02 23:10:09 | locater | 3 | 134027 | 489 | 7.343 | 18252.3 |
412 | 2024-02-02 23:10:05 | locater | 2 | 107671 | 32 | 5.140 | 20947.7 |
411 | 2024-02-02 21:43:03 | locater | 2 | 107671 | 32 | 3.000 | 35890.3 |
410 | 2024-02-01 02:06:00 | locater | 3 | 134027 | 489 | 6.970 | 19229.1 |
409 | 2024-01-23 03:49:50 | locater | 3 | 134027 | 489 | 7.983 | 16789.1 |
408 | 2024-01-18 23:05:40 | locater | 3 | 134027 | 489 | 7.000 | 19146.7 |
407 | 2024-01-18 23:05:41 | locater | 2 | 107671 | 32 | 3.516 | 30623.2 |
406 | 2023-12-26 19:10:22 | locater | 1 | 69583 | 6 | 1.233 | 56433.9 |
405 | 2023-11-19 17:10:22 | locater | 1 | 69583 | 6 | 1.186 | 58670.3 |
404 | 2023-11-17 02:31:45 | locater | 1 | 69583 | 6 | 1.140 | 61037.7 |
403 | 2023-11-11 19:38:26 | locater | 1 | 69583 | 6 | 1.203 | 57841.2 |
402 | 2023-11-06 03:51:38 | locater | 1 | 69583 | 6 | 1.263 | 55093.4 |
401 | 2023-10-19 14:09:19 | locater | 1 | 69583 | 6 | 1.080 | 64428.7 |
400 | 2023-10-15 21:03:21 | locater | 1 | 69583 | 6 | 1.093 | 63662.4 |
399 | 2023-10-15 13:30:35 | locater | 1 | 69583 | 6 | 1.203 | 57841.2 |
398 | 2023-10-14 21:49:00 | locater | 1 | 69583 | 6 | 1.080 | 64428.7 |
397 | 2023-10-04 13:03:36 | locater | 1 | 69583 | 6 | 1.123 | 61961.7 |
396 | 2023-09-23 10:30:20 | locater | 1 | 69583 | 6 | 1.203 | 57841.2 |
395 | 2023-08-11 00:25:54 | locater | 1 | 69583 | 6 | 2.376 | 29285.8 |
394 | 2023-06-21 18:15:39 | locater | 1 | 69583 | 6 | 1.220 | 57035.2 |
393 | 2023-05-08 23:46:06 | locater | 1 | 69583 | 6 | 1.046 | 66522.9 |
392 | 2023-03-03 00:06:54 | locater | 1 | 69583 | 6 | 1.030 | 67556.3 |
391 | 2023-03-02 21:51:36 | locater | 1 | 69583 | 6 | 1.046 | 66522.9 |
390 | 2022-12-27 20:14:53 | locater | 1 | 69583 | 6 | 1.033 | 67360.1 |
389 | 2022-11-10 13:28:41 | locater | 1 | 69583 | 6 | 1.046 | 66522.9 |
388 | 2022-09-18 03:53:30 | locater | 1 | 69583 | 6 | 1.063 | 65459.1 |
387 | 2022-09-14 21:11:37 | locater | 1 | 69583 | 6 | 1.060 | 65644.3 |
386 | 2022-08-07 09:18:38 | locater | 1 | 69583 | 6 | 1.203 | 57841.2 |
385 | 2022-08-07 00:46:45 | locater | 1 | 69583 | 6 | 1.076 | 64668.2 |
384 | 2022-07-21 09:34:50 | locater | 1 | 69583 | 6 | 1.046 | 66522.9 |
383 | 2022-07-17 18:54:06 | locater | 1 | 69583 | 6 | 1.063 | 65459.1 |
382 | 2022-07-17 16:24:28 | locater | 1 | 69583 | 6 | 1.063 | 65459.1 |
381 | 2022-06-25 16:54:42 | locater | 1 | 69583 | 6 | 1.156 | 60192.9 |
380 | 2022-03-27 03:05:09 | locater | 1 | 69583 | 6 | 1.063 | 65459.1 |
379 | 2022-03-23 18:39:49 | locater | 1 | 69583 | 6 | 1.076 | 64668.2 |
378 | 2022-03-13 04:39:23 | locater | 1 | 69583 | 6 | 1.140 | 61037.7 |
377 | 2021-12-23 11:14:30 | locater | 1 | 69583 | 6 | 1.203 | 57841.2 |
376 | 2021-11-29 17:39:19 | locater | 1 | 69583 | 6 | 1.076 | 64668.2 |
375 | 2021-11-11 17:49:58 | locater | 1 | 69583 | 6 | 1.170 | 59472.6 |
374 | 2021-10-25 01:00:49 | locater | 1 | 69583 | 6 | 1.280 | 54361.7 |
373 | 2021-08-23 12:10:34 | locater | 1 | 69583 | 6 | 1.106 | 62914.1 |
372 | 2021-07-24 19:22:47 | locater | 3 | 134027 | 489 | 5.673 | 23625.4 |
371 | 2021-07-05 19:18:10 | locater | 1 | 69583 | 6 | 1.200 | 57985.8 |
370 | 2021-06-25 23:41:04 | locater | 3 | 134027 | 489 | 6.846 | 19577.4 |
369 | 2021-06-08 18:25:14 | locater | 3 | 134027 | 489 | 6.266 | 21389.6 |
368 | 2021-05-26 10:22:35 | locater | 1 | 69583 | 6 | 1.283 | 54234.6 |
367 | 2021-05-22 19:05:03 | locater | 1 | 69583 | 6 | 1.140 | 61037.7 |
366 | 2021-05-15 11:00:47 | locater | 1 | 69583 | 6 | 1.236 | 56296.9 |
365 | 2021-04-20 01:57:27 | locater | 1 | 69583 | 6 | 1.076 | 64668.2 |
364 | 2021-02-16 09:09:07 | locater | 1 | 69583 | 6 | 1.096 | 63488.1 |
363 | 2021-01-28 03:26:32 | locater | 1 | 69583 | 6 | 1.173 | 59320.5 |
362 | 2021-01-27 16:23:26 | locater | 3 | 134027 | 489 | 5.893 | 22743.4 |
361 | 2021-01-04 18:02:49 | locater | 1 | 69583 | 6 | 1.076 | 64668.2 |
360 | 2020-12-29 22:16:43 | locater | 3 | 134027 | 489 | 6.623 | 20236.6 |
359 | 2020-11-07 00:53:56 | locater | 1 | 69583 | 6 | 1.080 | 64428.7 |
358 | 2020-10-23 01:00:33 | locater | 1 | 69583 | 6 | 1.093 | 63662.4 |
357 | 2020-10-15 19:10:51 | locater | 3 | 134027 | 489 | 6.283 | 21331.7 |
356 | 2020-10-06 09:42:42 | locater | 1 | 69583 | 6 | 1.076 | 64668.2 |
355 | 2020-09-22 05:31:07 | locater | 1 | 69583 | 6 | 1.046 | 66522.9 |
354 | 2020-08-27 23:54:00 | locater | 1 | 69583 | 6 | 1.140 | 61037.7 |
353 | 2020-08-15 02:07:59 | locater | 1 | 69583 | 6 | 1.093 | 63662.4 |
352 | 2020-08-11 12:04:48 | locater | 1 | 69583 | 6 | 1.640 | 42428.7 |
351 | 2020-08-05 17:23:27 | locater | 1 | 69583 | 6 | 1.326 | 52475.9 |
350 | 2020-07-30 07:24:38 | locater | 1 | 69583 | 6 | 1.110 | 62687.4 |
349 | 2020-07-23 06:23:13 | locater | 1 | 69583 | 6 | 1.140 | 61037.7 |
348 | 2020-06-13 13:29:38 | locater | 1 | 69583 | 6 | 1.093 | 63662.4 |
347 | 2020-06-02 16:34:32 | locater | 1 | 69583 | 6 | 1.063 | 65459.1 |
346 | 2020-05-04 05:11:22 | locater | 1 | 69583 | 6 | 1.106 | 62914.1 |
345 | 2020-03-29 22:06:09 | locater | 1 | 69583 | 6 | 1.080 | 64428.7 |
344 | 2020-03-28 06:11:15 | locater | 1 | 69583 | 6 | 1.296 | 53690.6 |
343 | 2020-03-25 13:14:53 | locater | 1 | 69583 | 6 | 1.296 | 53690.6 |
342 | 2020-03-24 00:58:18 | locater | 1 | 69583 | 6 | 1.266 | 54962.9 |
341 | 2020-03-23 23:44:07 | locater | 1 | 69583 | 6 | 1.283 | 54234.6 |
340 | 2020-03-20 08:54:41 | locater | 1 | 69583 | 6 | 1.640 | 42428.7 |
339 | 2020-03-18 15:28:50 | locater | 1 | 69583 | 6 | 1.296 | 53690.6 |
338 | 2020-02-29 08:44:21 | locater | 1 | 69583 | 6 | 2.576 | 27012.0 |
337 | 2020-02-23 23:19:34 | locater | 1 | 69583 | 6 | 1.063 | 65459.1 |
336 | 2020-02-15 08:30:13 | locater | 1 | 69583 | 6 | 1.356 | 51314.9 |
335 | 2020-02-07 23:58:18 | locater | 1 | 69583 | 6 | 2.690 | 25867.3 |
334 | 2020-02-07 17:44:19 | locater | 1 | 69583 | 6 | 2.486 | 27989.9 |
333 | 2020-02-05 20:52:34 | locater | 1 | 69583 | 6 | 1.250 | 55666.4 |
332 | 2020-02-03 21:03:37 | locater | 1 | 69583 | 6 | 2.626 | 26497.7 |
331 | 2020-02-02 19:29:21 | locater | 1 | 69583 | 6 | 1.220 | 57035.2 |
330 | 2020-02-02 00:14:58 | locater | 1 | 69583 | 6 | 1.250 | 55666.4 |
329 | 2020-01-29 02:06:05 | locater | 1 | 69583 | 6 | 3.923 | 17737.2 |
328 | 2020-01-23 19:30:07 | locater | 1 | 69583 | 6 | 2.703 | 25742.9 |
327 | 2020-01-16 12:10:58 | locater | 1 | 69583 | 6 | 1.250 | 55666.4 |