History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prance"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
413 | 2024-05-15 11:41:14 | prance | 2 | 82551 | 66 | 2.280 | 36206.6 |
412 | 2024-05-06 00:57:25 | prance | 1 | 48755 | 7 | 0.953 | 51159.5 |
411 | 2024-04-29 19:27:41 | prance | 2 | 82551 | 66 | 2.810 | 29377.6 |
410 | 2024-04-29 19:26:33 | prance | 3 | 112716 | 696 | 6.360 | 17722.6 |
409 | 2024-04-29 13:39:07 | prance | 2 | 82551 | 66 | 2.500 | 33020.4 |
408 | 2024-04-29 13:38:02 | prance | 2 | 82551 | 66 | 2.436 | 33887.9 |
407 | 2024-04-29 13:37:58 | prance | 3 | 112716 | 696 | 5.470 | 20606.2 |
406 | 2024-04-29 13:37:54 | prance | 1 | 48755 | 7 | 0.873 | 55847.7 |
405 | 2024-04-29 13:37:29 | prance | 3 | 112716 | 696 | 6.046 | 18643.1 |
404 | 2024-04-27 20:48:17 | prance | 2 | 82551 | 66 | 7.596 | 10867.7 |
403 | 2024-04-27 20:05:29 | prance | 3 | 112716 | 696 | 8.360 | 13482.8 |
402 | 2024-04-05 11:45:22 | prance | 1 | 48755 | 7 | 3.860 | 12630.8 |
401 | 2024-04-01 18:18:58 | prance | 1 | 48755 | 7 | 1.983 | 24586.5 |
400 | 2024-03-30 19:53:10 | prance | 3 | 112716 | 696 | 8.716 | 12932.1 |
399 | 2024-03-30 13:30:33 | prance | 3 | 112716 | 696 | 11.656 | 9670.2 |
398 | 2024-03-28 21:39:08 | prance | 1 | 48755 | 7 | 1.983 | 24586.5 |
397 | 2024-03-28 21:15:43 | prance | 1 | 48755 | 7 | 1.906 | 25579.7 |
396 | 2024-03-28 19:15:22 | prance | 3 | 112716 | 696 | 9.063 | 12436.9 |
395 | 2024-03-28 18:40:50 | prance | 2 | 82551 | 66 | 4.123 | 20022.1 |
394 | 2024-03-28 07:23:42 | prance | 1 | 48755 | 7 | 0.873 | 55847.7 |
393 | 2024-03-28 07:23:35 | prance | 3 | 112716 | 696 | 5.720 | 19705.6 |
392 | 2024-03-28 07:23:35 | prance | 2 | 82551 | 66 | 2.593 | 31836.1 |
391 | 2024-03-28 07:23:32 | prance | 1 | 48755 | 7 | 0.860 | 56691.9 |
390 | 2024-03-12 10:17:48 | prance | 1 | 48755 | 7 | 0.766 | 63648.8 |
389 | 2024-01-28 08:25:12 | prance | 1 | 48755 | 7 | 0.876 | 55656.4 |
388 | 2024-01-11 14:50:22 | prance | 3 | 112716 | 696 | 11.406 | 9882.2 |
387 | 2024-01-07 10:41:31 | prance | 2 | 82551 | 66 | 2.220 | 37185.1 |
386 | 2024-01-05 13:38:28 | prance | 2 | 82551 | 66 | 2.330 | 35429.6 |
385 | 2024-01-03 11:54:56 | prance | 3 | 112716 | 696 | 5.610 | 20092.0 |
384 | 2024-01-01 09:33:19 | prance | 3 | 112716 | 696 | 4.953 | 22757.1 |
383 | 2024-01-01 09:33:17 | prance | 2 | 82551 | 66 | 2.266 | 36430.3 |
382 | 2023-12-15 00:30:11 | prance | 1 | 48755 | 7 | 0.810 | 60191.4 |
381 | 2023-11-17 00:28:44 | prance | 1 | 48755 | 7 | 0.860 | 56691.9 |
380 | 2023-11-14 20:31:35 | prance | 3 | 112716 | 696 | 4.986 | 22606.5 |
379 | 2023-11-14 20:31:36 | prance | 2 | 82551 | 66 | 2.390 | 34540.2 |
378 | 2023-11-13 18:59:40 | prance | 1 | 48755 | 7 | 0.763 | 63899.1 |
377 | 2023-11-05 16:12:49 | prance | 1 | 48755 | 7 | 0.830 | 58741.0 |
376 | 2023-10-20 16:44:16 | prance | 1 | 48755 | 7 | 0.750 | 65006.7 |
375 | 2023-10-18 15:44:15 | prance | 1 | 48755 | 7 | 0.750 | 65006.7 |
374 | 2023-10-12 00:43:37 | prance | 1 | 48755 | 7 | 0.750 | 65006.7 |
373 | 2023-10-12 00:19:16 | prance | 2 | 82551 | 66 | 2.186 | 37763.5 |
372 | 2023-10-07 10:38:39 | prance | 1 | 48755 | 7 | 0.750 | 65006.7 |
371 | 2023-10-06 11:38:50 | prance | 1 | 48755 | 7 | 0.766 | 63648.8 |
370 | 2023-10-01 00:21:05 | prance | 3 | 112716 | 696 | 6.343 | 17770.1 |
369 | 2023-09-30 10:12:47 | prance | 1 | 48755 | 7 | 0.780 | 62506.4 |
368 | 2023-09-29 10:56:22 | prance | 1 | 48755 | 7 | 0.843 | 57835.1 |
367 | 2023-09-27 07:38:44 | prance | 3 | 112716 | 696 | 5.453 | 20670.5 |
366 | 2023-09-27 07:38:42 | prance | 2 | 82551 | 66 | 2.610 | 31628.7 |
365 | 2023-09-12 19:10:28 | prance | 1 | 48755 | 7 | 0.940 | 51867.0 |
364 | 2023-07-23 08:09:18 | prance | 2 | 82551 | 66 | 2.423 | 34069.7 |
363 | 2023-06-16 07:22:41 | prance | 1 | 48755 | 7 | 0.843 | 57835.1 |
362 | 2023-04-25 19:21:27 | prance | 1 | 48755 | 7 | 0.733 | 66514.3 |
361 | 2023-04-20 13:04:52 | prance | 1 | 48755 | 7 | 0.733 | 66514.3 |
360 | 2023-04-03 16:34:27 | prance | 2 | 82551 | 66 | 2.546 | 32423.8 |
359 | 2023-02-25 00:46:15 | prance | 1 | 48755 | 7 | 0.830 | 58741.0 |
358 | 2023-02-17 13:48:13 | prance | 1 | 48755 | 7 | 0.813 | 59969.2 |
357 | 2022-12-31 23:20:11 | prance | 2 | 82551 | 66 | 2.140 | 38575.2 |
356 | 2022-12-14 20:54:05 | prance | 1 | 48755 | 7 | 0.750 | 65006.7 |
355 | 2022-11-04 15:50:09 | prance | 1 | 48755 | 7 | 0.780 | 62506.4 |
354 | 2022-09-01 16:58:07 | prance | 2 | 82551 | 66 | 2.296 | 35954.3 |
353 | 2022-08-19 02:22:19 | prance | 1 | 48755 | 7 | 0.843 | 57835.1 |
352 | 2022-08-16 16:09:12 | prance | 1 | 48755 | 7 | 0.810 | 60191.4 |
351 | 2022-07-29 13:26:13 | prance | 1 | 48755 | 7 | 0.766 | 63648.8 |
350 | 2022-07-14 23:25:30 | prance | 1 | 48755 | 7 | 0.780 | 62506.4 |
349 | 2022-06-07 10:40:02 | prance | 1 | 48755 | 7 | 0.763 | 63899.1 |
348 | 2022-04-03 04:23:36 | prance | 1 | 48755 | 7 | 0.750 | 65006.7 |
347 | 2022-03-28 04:00:52 | prance | 1 | 48755 | 7 | 0.763 | 63899.1 |
346 | 2022-01-04 19:43:27 | prance | 1 | 48755 | 7 | 1.000 | 48755.0 |
345 | 2022-01-02 16:14:58 | prance | 1 | 48755 | 7 | 0.890 | 54780.9 |
344 | 2021-12-13 22:05:41 | prance | 1 | 48755 | 7 | 0.860 | 56691.9 |
343 | 2021-11-05 04:49:37 | prance | 1 | 48755 | 7 | 0.843 | 57835.1 |
342 | 2021-09-22 13:47:04 | prance | 1 | 48755 | 7 | 0.860 | 56691.9 |
341 | 2021-09-19 17:13:30 | prance | 1 | 48755 | 7 | 0.843 | 57835.1 |
340 | 2021-09-18 21:37:16 | prance | 1 | 48755 | 7 | 0.843 | 57835.1 |
339 | 2021-09-11 20:02:57 | prance | 1 | 48755 | 7 | 0.783 | 62266.9 |
338 | 2021-09-06 15:31:24 | prance | 1 | 48755 | 7 | 0.766 | 63648.8 |
337 | 2021-09-03 02:21:55 | prance | 1 | 48755 | 7 | 0.873 | 55847.7 |
336 | 2021-08-08 11:02:50 | prance | 1 | 48755 | 7 | 0.733 | 66514.3 |
335 | 2021-06-05 15:18:05 | prance | 1 | 48755 | 7 | 0.843 | 57835.1 |
334 | 2021-03-03 12:11:39 | prance | 1 | 48755 | 7 | 0.750 | 65006.7 |
333 | 2020-12-02 09:42:08 | prance | 1 | 48755 | 7 | 0.766 | 63648.8 |
332 | 2020-11-23 03:47:22 | prance | 1 | 48755 | 7 | 0.840 | 58041.7 |
331 | 2020-11-14 00:46:28 | prance | 1 | 48755 | 7 | 0.750 | 65006.7 |
330 | 2020-08-28 04:29:30 | prance | 1 | 48755 | 7 | 0.736 | 66243.2 |
329 | 2020-08-14 17:07:25 | prance | 1 | 48755 | 7 | 1.046 | 46610.9 |
328 | 2020-08-04 09:26:51 | prance | 1 | 48755 | 7 | 0.813 | 59969.2 |
327 | 2020-07-22 17:25:51 | prance | 1 | 48755 | 7 | 0.766 | 63648.8 |
326 | 2020-07-11 03:21:27 | prance | 1 | 48755 | 7 | 0.830 | 58741.0 |
325 | 2020-05-26 14:41:29 | prance | 1 | 48755 | 7 | 0.750 | 65006.7 |
324 | 2020-04-15 16:19:43 | prance | 1 | 48755 | 7 | 0.876 | 55656.4 |
323 | 2020-03-28 22:23:07 | prance | 1 | 48755 | 7 | 0.846 | 57630.0 |
322 | 2020-03-28 00:41:31 | prance | 1 | 48755 | 7 | 0.750 | 65006.7 |
321 | 2020-03-26 05:07:38 | prance | 1 | 48755 | 7 | 0.890 | 54780.9 |
320 | 2020-03-24 02:59:49 | prance | 1 | 48755 | 7 | 0.906 | 53813.5 |
319 | 2020-03-23 00:10:21 | prance | 1 | 48755 | 7 | 0.843 | 57835.1 |
318 | 2020-03-19 22:42:50 | prance | 1 | 48755 | 7 | 0.873 | 55847.7 |
317 | 2020-03-18 23:07:35 | prance | 1 | 48755 | 7 | 0.873 | 55847.7 |
316 | 2020-02-23 09:43:58 | prance | 1 | 48755 | 7 | 0.923 | 52822.3 |
315 | 2020-02-22 19:24:57 | prance | 1 | 48755 | 7 | 1.390 | 35075.5 |
314 | 2020-02-19 12:00:31 | prance | 1 | 48755 | 7 | 0.906 | 53813.5 |