History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"messier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
417 | 2024-04-28 21:15:27 | messier | 1 | 69583 | 5 | 1.373 | 50679.5 |
416 | 2024-04-27 23:40:49 | messier | 1 | 69583 | 5 | 3.656 | 19032.5 |
415 | 2024-04-14 05:34:46 | messier | 1 | 69583 | 5 | 1.420 | 49002.1 |
414 | 2024-03-26 16:57:28 | messier | 1 | 69583 | 5 | 1.236 | 56296.9 |
413 | 2024-02-17 18:13:18 | messier | 2 | 107671 | 44 | 3.483 | 30913.3 |
412 | 2024-02-07 05:59:14 | messier | 2 | 107671 | 44 | 3.606 | 29858.8 |
411 | 2024-02-07 05:57:23 | messier | 3 | 134027 | 499 | 7.813 | 17154.4 |
410 | 2024-02-03 20:43:34 | messier | 3 | 134027 | 499 | 6.423 | 20866.7 |
409 | 2024-02-03 20:40:26 | messier | 3 | 134027 | 499 | 6.623 | 20236.6 |
408 | 2024-02-01 14:08:30 | messier | 1 | 69583 | 5 | 1.190 | 58473.1 |
407 | 2024-01-28 20:13:03 | messier | 1 | 69583 | 5 | 1.190 | 58473.1 |
406 | 2024-01-17 02:06:03 | messier | 2 | 107671 | 44 | 3.376 | 31893.1 |
405 | 2024-01-12 01:18:53 | messier | 2 | 107671 | 44 | 3.466 | 31064.9 |
404 | 2023-12-19 12:30:37 | messier | 1 | 69583 | 5 | 1.096 | 63488.1 |
403 | 2023-12-10 23:35:11 | messier | 3 | 134027 | 499 | 6.343 | 21129.9 |
402 | 2023-12-04 10:20:45 | messier | 3 | 134027 | 499 | 6.110 | 21935.7 |
401 | 2023-11-18 08:27:45 | messier | 1 | 69583 | 5 | 1.060 | 65644.3 |
400 | 2023-11-17 00:36:32 | messier | 1 | 69583 | 5 | 1.263 | 55093.4 |
399 | 2023-11-16 20:17:19 | messier | 2 | 107671 | 44 | 3.800 | 28334.5 |
398 | 2023-11-15 17:45:55 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
397 | 2023-11-10 22:21:32 | messier | 3 | 134027 | 499 | 6.500 | 20619.5 |
396 | 2023-11-05 08:17:50 | messier | 1 | 69583 | 5 | 1.093 | 63662.4 |
395 | 2023-10-24 07:38:44 | messier | 1 | 69583 | 5 | 1.266 | 54962.9 |
394 | 2023-10-07 00:56:12 | messier | 1 | 69583 | 5 | 1.156 | 60192.9 |
393 | 2023-10-06 13:26:53 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
392 | 2023-09-30 12:16:22 | messier | 1 | 69583 | 5 | 1.173 | 59320.5 |
391 | 2023-08-18 08:23:57 | messier | 2 | 107671 | 44 | 3.140 | 34290.1 |
390 | 2023-08-15 01:57:50 | messier | 3 | 134027 | 499 | 5.813 | 23056.4 |
389 | 2023-08-01 18:28:27 | messier | 1 | 69583 | 5 | 1.220 | 57035.2 |
388 | 2023-07-07 16:29:11 | messier | 2 | 107671 | 44 | 2.826 | 38100.1 |
387 | 2023-06-10 04:37:41 | messier | 1 | 69583 | 5 | 1.046 | 66522.9 |
386 | 2023-06-06 21:33:45 | messier | 1 | 69583 | 5 | 1.173 | 59320.5 |
385 | 2023-06-03 16:27:35 | messier | 2 | 107671 | 44 | 2.920 | 36873.6 |
384 | 2023-05-01 03:07:39 | messier | 2 | 107671 | 44 | 2.813 | 38276.2 |
383 | 2023-04-29 18:57:41 | messier | 3 | 134027 | 499 | 6.343 | 21129.9 |
382 | 2023-04-26 05:20:43 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
381 | 2023-02-18 18:36:04 | messier | 1 | 69583 | 5 | 1.233 | 56433.9 |
380 | 2023-02-16 02:50:48 | messier | 1 | 69583 | 5 | 1.186 | 58670.3 |
379 | 2023-02-06 12:59:14 | messier | 2 | 107671 | 44 | 2.780 | 38730.6 |
378 | 2023-02-05 10:58:07 | messier | 3 | 134027 | 499 | 5.813 | 23056.4 |
377 | 2022-12-13 21:31:36 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
376 | 2022-11-18 16:30:22 | messier | 2 | 107671 | 44 | 3.000 | 35890.3 |
375 | 2022-11-17 20:58:25 | messier | 3 | 134027 | 499 | 6.970 | 19229.1 |
374 | 2022-11-01 16:00:20 | messier | 1 | 69583 | 5 | 1.280 | 54361.7 |
373 | 2022-10-10 19:44:47 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
372 | 2022-09-19 11:30:33 | messier | 1 | 69583 | 5 | 1.160 | 59985.3 |
371 | 2022-09-05 12:58:25 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
370 | 2022-09-01 21:07:55 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
369 | 2022-08-19 14:00:44 | messier | 1 | 69583 | 5 | 1.186 | 58670.3 |
368 | 2022-08-16 02:49:25 | messier | 1 | 69583 | 5 | 1.080 | 64428.7 |
367 | 2022-08-14 15:22:18 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
366 | 2022-08-10 16:36:38 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
365 | 2022-08-03 00:26:56 | messier | 1 | 69583 | 5 | 1.060 | 65644.3 |
364 | 2022-07-28 23:34:36 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
363 | 2022-07-25 06:08:10 | messier | 1 | 69583 | 5 | 1.283 | 54234.6 |
362 | 2022-07-18 16:02:24 | messier | 1 | 69583 | 5 | 1.250 | 55666.4 |
361 | 2022-07-15 12:59:32 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
360 | 2022-07-08 21:18:27 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
359 | 2022-06-21 06:17:46 | messier | 3 | 134027 | 499 | 6.486 | 20664.0 |
358 | 2022-06-20 15:38:19 | messier | 2 | 107671 | 44 | 2.843 | 37872.3 |
357 | 2022-06-18 10:05:32 | messier | 2 | 107671 | 44 | 2.813 | 38276.2 |
356 | 2022-06-17 04:46:53 | messier | 1 | 69583 | 5 | 1.080 | 64428.7 |
355 | 2022-06-04 04:13:35 | messier | 1 | 69583 | 5 | 1.173 | 59320.5 |
354 | 2022-04-03 15:37:12 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
353 | 2022-03-14 22:58:45 | messier | 1 | 69583 | 5 | 1.296 | 53690.6 |
352 | 2022-02-14 19:34:51 | messier | 1 | 69583 | 5 | 1.216 | 57222.9 |
351 | 2022-02-04 20:58:08 | messier | 3 | 134027 | 499 | 6.986 | 19185.1 |
350 | 2022-01-30 22:50:48 | messier | 2 | 107671 | 44 | 2.796 | 38508.9 |
349 | 2022-01-21 15:45:16 | messier | 1 | 69583 | 5 | 1.410 | 49349.6 |
348 | 2022-01-21 06:02:07 | messier | 1 | 69583 | 5 | 1.233 | 56433.9 |
347 | 2022-01-20 21:39:17 | messier | 1 | 69583 | 5 | 1.720 | 40455.2 |
346 | 2022-01-20 11:33:54 | messier | 1 | 69583 | 5 | 1.110 | 62687.4 |
345 | 2022-01-20 01:51:02 | messier | 1 | 69583 | 5 | 1.876 | 37091.2 |
344 | 2022-01-19 16:59:39 | messier | 1 | 69583 | 5 | 1.203 | 57841.2 |
343 | 2022-01-18 16:41:56 | messier | 1 | 69583 | 5 | 1.280 | 54361.7 |
342 | 2022-01-18 02:09:22 | messier | 1 | 69583 | 5 | 1.123 | 61961.7 |
341 | 2022-01-17 20:30:49 | messier | 1 | 69583 | 5 | 1.343 | 51811.6 |
340 | 2022-01-17 15:52:55 | messier | 1 | 69583 | 5 | 1.250 | 55666.4 |
339 | 2022-01-17 00:55:19 | messier | 1 | 69583 | 5 | 1.110 | 62687.4 |
338 | 2022-01-16 11:24:36 | messier | 1 | 69583 | 5 | 1.220 | 57035.2 |
337 | 2022-01-16 01:59:55 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
336 | 2022-01-15 18:52:25 | messier | 1 | 69583 | 5 | 1.280 | 54361.7 |
335 | 2022-01-15 09:30:34 | messier | 1 | 69583 | 5 | 1.190 | 58473.1 |
334 | 2022-01-15 03:18:42 | messier | 1 | 69583 | 5 | 1.250 | 55666.4 |
333 | 2022-01-14 15:13:59 | messier | 1 | 69583 | 5 | 1.700 | 40931.2 |
332 | 2022-01-13 21:54:03 | messier | 1 | 69583 | 5 | 1.203 | 57841.2 |
331 | 2022-01-13 10:36:19 | messier | 1 | 69583 | 5 | 1.296 | 53690.6 |
330 | 2022-01-13 04:37:43 | messier | 1 | 69583 | 5 | 1.126 | 61796.6 |
329 | 2022-01-12 13:37:15 | messier | 1 | 69583 | 5 | 1.296 | 53690.6 |
328 | 2022-01-12 04:42:53 | messier | 1 | 69583 | 5 | 1.266 | 54962.9 |
327 | 2022-01-11 12:43:40 | messier | 1 | 69583 | 5 | 1.110 | 62687.4 |
326 | 2022-01-10 18:58:48 | messier | 1 | 69583 | 5 | 1.263 | 55093.4 |
325 | 2022-01-10 10:06:01 | messier | 1 | 69583 | 5 | 1.140 | 61037.7 |
324 | 2022-01-09 19:09:46 | messier | 1 | 69583 | 5 | 1.313 | 52995.4 |
323 | 2022-01-07 10:23:07 | messier | 1 | 69583 | 5 | 1.216 | 57222.9 |
322 | 2022-01-06 12:30:55 | messier | 1 | 69583 | 5 | 1.216 | 57222.9 |
321 | 2022-01-05 16:57:19 | messier | 1 | 69583 | 5 | 1.233 | 56433.9 |
320 | 2022-01-05 01:34:19 | messier | 1 | 69583 | 5 | 1.266 | 54962.9 |
319 | 2021-12-04 15:14:15 | messier | 1 | 69583 | 5 | 1.080 | 64428.7 |
318 | 2021-11-07 15:27:38 | messier | 1 | 69583 | 5 | 1.140 | 61037.7 |