History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"staple"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
437 | 2024-04-11 13:34:19 | staple | 2 | 82551 | 69 | 2.173 | 37989.4 |
436 | 2024-04-11 05:49:12 | staple | 3 | 112716 | 785 | 6.220 | 18121.5 |
435 | 2024-04-08 04:37:02 | staple | 2 | 82551 | 69 | 2.656 | 31080.9 |
434 | 2024-04-08 04:36:23 | staple | 3 | 112716 | 785 | 6.453 | 17467.2 |
433 | 2024-04-07 19:44:18 | staple | 3 | 112716 | 785 | 12.596 | 8948.6 |
432 | 2024-04-07 17:33:58 | staple | 3 | 112716 | 785 | 15.280 | 7376.7 |
431 | 2024-04-06 23:07:05 | staple | 3 | 112716 | 785 | 13.046 | 8639.9 |
430 | 2024-04-06 00:48:14 | staple | 3 | 112716 | 785 | 13.733 | 8207.7 |
429 | 2024-04-06 00:42:37 | staple | 3 | 112716 | 785 | 5.810 | 19400.3 |
428 | 2024-04-03 11:41:11 | staple | 1 | 48755 | 6 | 0.983 | 49598.2 |
427 | 2024-03-31 05:50:49 | staple | 1 | 48755 | 6 | 0.986 | 49447.3 |
426 | 2024-03-29 03:30:26 | staple | 1 | 48755 | 6 | 2.000 | 24377.5 |
425 | 2024-03-28 23:41:11 | staple | 1 | 48755 | 6 | 2.376 | 20519.8 |
424 | 2024-03-26 06:45:17 | staple | 2 | 82551 | 69 | 2.670 | 30918.0 |
423 | 2024-02-29 21:57:49 | staple | 2 | 82551 | 69 | 2.610 | 31628.7 |
422 | 2024-02-29 20:12:20 | staple | 3 | 112716 | 785 | 4.953 | 22757.1 |
421 | 2024-02-28 06:24:06 | staple | 2 | 82551 | 69 | 2.936 | 28116.8 |
420 | 2024-02-28 06:12:42 | staple | 2 | 82551 | 69 | 4.830 | 17091.3 |
419 | 2024-02-28 06:11:44 | staple | 3 | 112716 | 785 | 5.860 | 19234.8 |
418 | 2024-02-27 04:30:57 | staple | 3 | 112716 | 785 | 10.593 | 10640.6 |
417 | 2024-02-26 08:48:29 | staple | 3 | 112716 | 785 | 5.376 | 20966.5 |
416 | 2024-02-26 08:48:27 | staple | 2 | 82551 | 69 | 2.393 | 34496.9 |
415 | 2024-02-25 22:24:13 | staple | 1 | 48755 | 6 | 0.966 | 50471.0 |
414 | 2024-01-26 14:53:17 | staple | 1 | 48755 | 6 | 1.673 | 29142.3 |
413 | 2024-01-16 01:04:52 | staple | 1 | 48755 | 6 | 0.810 | 60191.4 |
412 | 2024-01-12 21:11:29 | staple | 3 | 112716 | 785 | 5.750 | 19602.8 |
411 | 2024-01-12 21:11:28 | staple | 2 | 82551 | 69 | 2.640 | 31269.3 |
410 | 2023-12-18 04:36:43 | staple | 1 | 48755 | 6 | 0.810 | 60191.4 |
409 | 2023-12-15 19:12:52 | staple | 2 | 82551 | 69 | 2.296 | 35954.3 |
408 | 2023-12-11 09:58:36 | staple | 1 | 48755 | 6 | 0.843 | 57835.1 |
407 | 2023-12-09 08:33:34 | staple | 3 | 112716 | 785 | 4.750 | 23729.7 |
406 | 2023-12-03 00:46:57 | staple | 3 | 112716 | 785 | 4.970 | 22679.3 |
405 | 2023-12-03 00:46:53 | staple | 2 | 82551 | 69 | 2.190 | 37694.5 |
404 | 2023-11-30 12:45:37 | staple | 3 | 112716 | 785 | 6.640 | 16975.3 |
403 | 2023-11-29 05:26:04 | staple | 2 | 82551 | 69 | 2.560 | 32246.5 |
402 | 2023-11-17 06:01:37 | staple | 1 | 48755 | 6 | 0.750 | 65006.7 |
401 | 2023-11-11 10:28:31 | staple | 1 | 48755 | 6 | 1.500 | 32503.3 |
400 | 2023-11-07 02:10:25 | staple | 1 | 48755 | 6 | 0.750 | 65006.7 |
399 | 2023-11-02 15:56:42 | staple | 2 | 82551 | 69 | 2.530 | 32628.9 |
398 | 2023-11-02 15:56:37 | staple | 3 | 112716 | 785 | 5.656 | 19928.6 |
397 | 2023-10-27 22:03:40 | staple | 1 | 48755 | 6 | 0.860 | 56691.9 |
396 | 2023-10-20 22:34:15 | staple | 1 | 48755 | 6 | 0.873 | 55847.7 |
395 | 2023-10-18 05:00:14 | staple | 1 | 48755 | 6 | 0.763 | 63899.1 |
394 | 2023-10-12 06:53:52 | staple | 1 | 48755 | 6 | 1.736 | 28084.7 |
393 | 2023-10-04 13:11:14 | staple | 1 | 48755 | 6 | 0.856 | 56956.8 |
392 | 2023-09-23 12:18:08 | staple | 1 | 48755 | 6 | 0.826 | 59025.4 |
391 | 2023-09-12 06:36:50 | staple | 1 | 48755 | 6 | 0.763 | 63899.1 |
390 | 2023-09-11 10:02:55 | staple | 3 | 112716 | 785 | 6.220 | 18121.5 |
389 | 2023-09-06 22:51:37 | staple | 3 | 112716 | 785 | 9.310 | 12107.0 |
388 | 2023-08-30 06:03:29 | staple | 1 | 48755 | 6 | 0.856 | 56956.8 |
387 | 2023-08-29 07:50:11 | staple | 2 | 82551 | 69 | 2.220 | 37185.1 |
386 | 2023-08-04 13:57:48 | staple | 1 | 48755 | 6 | 0.876 | 55656.4 |
385 | 2023-05-27 00:56:24 | staple | 1 | 48755 | 6 | 0.733 | 66514.3 |
384 | 2023-05-24 09:22:12 | staple | 3 | 112716 | 785 | 4.653 | 24224.4 |
383 | 2023-05-20 12:39:02 | staple | 3 | 112716 | 785 | 5.313 | 21215.1 |
382 | 2023-05-13 07:50:33 | staple | 2 | 82551 | 69 | 2.203 | 37472.1 |
381 | 2023-04-12 08:54:50 | staple | 1 | 48755 | 6 | 0.796 | 61250.0 |
380 | 2023-03-24 06:26:02 | staple | 3 | 112716 | 785 | 5.420 | 20796.3 |
379 | 2023-03-21 15:40:50 | staple | 1 | 48755 | 6 | 0.766 | 63648.8 |
378 | 2023-03-01 03:39:15 | staple | 3 | 112716 | 785 | 5.626 | 20034.8 |
377 | 2023-02-21 21:44:23 | staple | 2 | 82551 | 69 | 2.126 | 38829.3 |
376 | 2023-01-08 06:58:46 | staple | 1 | 48755 | 6 | 0.810 | 60191.4 |
375 | 2022-12-23 09:13:43 | staple | 1 | 48755 | 6 | 0.843 | 57835.1 |
374 | 2022-12-19 18:45:05 | staple | 1 | 48755 | 6 | 0.766 | 63648.8 |
373 | 2022-12-10 10:53:56 | staple | 3 | 112716 | 785 | 5.326 | 21163.3 |
372 | 2022-12-02 05:40:50 | staple | 2 | 82551 | 69 | 2.093 | 39441.5 |
371 | 2022-10-03 12:45:22 | staple | 1 | 48755 | 6 | 0.763 | 63899.1 |
370 | 2022-09-01 16:41:56 | staple | 2 | 82551 | 69 | 2.170 | 38041.9 |
369 | 2022-08-19 15:43:25 | staple | 1 | 48755 | 6 | 0.750 | 65006.7 |
368 | 2022-08-10 17:27:13 | staple | 1 | 48755 | 6 | 0.813 | 59969.2 |
367 | 2022-08-07 19:33:20 | staple | 1 | 48755 | 6 | 0.843 | 57835.1 |
366 | 2022-08-06 10:51:46 | staple | 1 | 48755 | 6 | 0.766 | 63648.8 |
365 | 2022-08-03 01:12:01 | staple | 1 | 48755 | 6 | 0.750 | 65006.7 |
364 | 2022-08-01 05:49:00 | staple | 1 | 48755 | 6 | 0.766 | 63648.8 |
363 | 2022-07-29 07:51:16 | staple | 1 | 48755 | 6 | 0.763 | 63899.1 |
362 | 2022-07-25 07:35:52 | staple | 1 | 48755 | 6 | 0.763 | 63899.1 |
361 | 2022-07-25 00:21:50 | staple | 3 | 112716 | 785 | 4.893 | 23036.2 |
360 | 2022-07-18 00:07:01 | staple | 1 | 48755 | 6 | 0.750 | 65006.7 |
359 | 2022-07-15 23:47:33 | staple | 1 | 48755 | 6 | 0.750 | 65006.7 |
358 | 2022-07-08 12:08:53 | staple | 2 | 82551 | 69 | 2.216 | 37252.3 |
357 | 2022-07-04 04:04:19 | staple | 2 | 82551 | 69 | 2.173 | 37989.4 |
356 | 2022-07-03 04:17:55 | staple | 1 | 48755 | 6 | 0.780 | 62506.4 |
355 | 2022-06-25 10:22:38 | staple | 1 | 48755 | 6 | 0.813 | 59969.2 |
354 | 2022-06-17 05:19:35 | staple | 1 | 48755 | 6 | 0.766 | 63648.8 |
353 | 2022-06-08 23:47:05 | staple | 1 | 48755 | 6 | 0.750 | 65006.7 |
352 | 2022-06-07 07:34:46 | staple | 1 | 48755 | 6 | 1.106 | 44082.3 |
351 | 2022-06-04 04:52:13 | staple | 1 | 48755 | 6 | 0.766 | 63648.8 |
350 | 2022-05-17 05:04:46 | staple | 1 | 48755 | 6 | 0.750 | 65006.7 |
349 | 2022-05-15 01:16:50 | staple | 1 | 48755 | 6 | 0.796 | 61250.0 |
348 | 2022-04-12 03:57:02 | staple | 1 | 48755 | 6 | 1.560 | 31253.2 |
347 | 2022-01-31 20:41:05 | staple | 1 | 48755 | 6 | 0.763 | 63899.1 |
346 | 2021-12-21 09:44:59 | staple | 1 | 48755 | 6 | 0.876 | 55656.4 |
345 | 2021-11-27 00:54:48 | staple | 1 | 48755 | 6 | 1.266 | 38511.1 |
344 | 2021-10-08 13:45:48 | staple | 1 | 48755 | 6 | 0.843 | 57835.1 |
343 | 2021-10-06 11:37:35 | staple | 1 | 48755 | 6 | 0.876 | 55656.4 |
342 | 2021-09-17 08:10:39 | staple | 1 | 48755 | 6 | 0.890 | 54780.9 |
341 | 2021-09-10 23:36:40 | staple | 1 | 48755 | 6 | 0.906 | 53813.5 |
340 | 2021-09-07 17:23:56 | staple | 1 | 48755 | 6 | 0.843 | 57835.1 |
339 | 2021-07-12 05:09:42 | staple | 1 | 48755 | 6 | 0.780 | 62506.4 |
338 | 2021-06-06 20:15:36 | staple | 1 | 48755 | 6 | 0.920 | 52994.6 |