History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piggy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
400 | 2024-04-10 16:02:03 | piggy | 2 | 53800 | 70 | 5.533 | 9723.5 |
399 | 2024-04-10 16:02:00 | piggy | 2 | 53800 | 70 | 4.546 | 11834.6 |
398 | 2024-04-03 07:18:50 | piggy | 1 | 28756 | 6 | 0.516 | 55728.7 |
397 | 2024-03-31 03:05:37 | piggy | 1 | 28756 | 6 | 1.923 | 14953.7 |
396 | 2024-03-29 02:50:53 | piggy | 1 | 28756 | 6 | 0.640 | 44931.3 |
395 | 2024-03-29 02:03:32 | piggy | 1 | 28756 | 6 | 0.576 | 49923.6 |
394 | 2024-03-15 22:30:25 | piggy | 1 | 28756 | 6 | 1.343 | 21411.8 |
393 | 2024-03-05 20:52:11 | piggy | 3 | 83667 | 713 | 14.156 | 5910.4 |
392 | 2024-03-04 02:43:57 | piggy | 3 | 83667 | 713 | 4.046 | 20678.9 |
391 | 2024-03-04 02:43:55 | piggy | 2 | 53800 | 70 | 1.606 | 33499.4 |
390 | 2024-03-04 02:43:20 | piggy | 1 | 28756 | 6 | 0.483 | 59536.2 |
389 | 2024-03-01 00:14:08 | piggy | 1 | 28756 | 6 | 0.610 | 47141.0 |
388 | 2024-02-27 23:11:32 | piggy | 3 | 83667 | 713 | 4.516 | 18526.8 |
387 | 2024-02-27 23:01:24 | piggy | 3 | 83667 | 713 | 4.453 | 18788.9 |
386 | 2024-02-27 23:01:22 | piggy | 2 | 53800 | 70 | 1.763 | 30516.2 |
385 | 2024-02-27 20:38:20 | piggy | 1 | 28756 | 6 | 0.516 | 55728.7 |
384 | 2024-02-02 22:20:51 | piggy | 1 | 28756 | 6 | 0.516 | 55728.7 |
383 | 2024-01-28 20:04:44 | piggy | 1 | 28756 | 6 | 0.450 | 63902.2 |
382 | 2024-01-28 18:43:21 | piggy | 1 | 28756 | 6 | 0.483 | 59536.2 |
381 | 2024-01-22 06:12:41 | piggy | 1 | 28756 | 6 | 0.500 | 57512.0 |
380 | 2024-01-10 03:47:03 | piggy | 3 | 83667 | 713 | 3.283 | 25484.9 |
379 | 2024-01-10 03:47:00 | piggy | 2 | 53800 | 70 | 1.576 | 34137.1 |
378 | 2023-12-25 05:09:03 | piggy | 2 | 53800 | 70 | 1.686 | 31909.8 |
377 | 2023-12-25 05:08:58 | piggy | 3 | 83667 | 713 | 4.080 | 20506.6 |
376 | 2023-12-11 23:14:48 | piggy | 2 | 53800 | 70 | 1.360 | 39558.8 |
375 | 2023-11-16 21:15:22 | piggy | 1 | 28756 | 6 | 0.470 | 61183.0 |
374 | 2023-11-16 11:35:09 | piggy | 1 | 28756 | 6 | 0.486 | 59168.7 |
373 | 2023-11-12 13:26:17 | piggy | 1 | 28756 | 6 | 0.466 | 61708.2 |
372 | 2023-11-03 17:31:02 | piggy | 3 | 83667 | 713 | 3.860 | 21675.4 |
371 | 2023-11-03 07:11:37 | piggy | 1 | 28756 | 6 | 0.436 | 65954.1 |
370 | 2023-11-02 08:13:46 | piggy | 2 | 53800 | 70 | 1.813 | 29674.6 |
369 | 2023-11-01 07:46:53 | piggy | 3 | 83667 | 713 | 4.186 | 19987.3 |
368 | 2023-10-28 02:07:19 | piggy | 1 | 28756 | 6 | 0.576 | 49923.6 |
367 | 2023-10-26 00:14:49 | piggy | 2 | 53800 | 70 | 1.703 | 31591.3 |
366 | 2023-10-26 00:14:45 | piggy | 3 | 83667 | 713 | 5.280 | 15846.0 |
365 | 2023-10-24 19:39:19 | piggy | 1 | 28756 | 6 | 0.500 | 57512.0 |
364 | 2023-10-19 19:18:35 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
363 | 2023-10-19 00:35:00 | piggy | 1 | 28756 | 6 | 0.440 | 65354.5 |
362 | 2023-10-13 14:51:50 | piggy | 1 | 28756 | 6 | 0.436 | 65954.1 |
361 | 2023-10-05 01:53:49 | piggy | 1 | 28756 | 6 | 0.513 | 56054.6 |
360 | 2023-09-26 18:31:16 | piggy | 3 | 83667 | 713 | 4.093 | 20441.5 |
359 | 2023-09-26 18:31:18 | piggy | 2 | 53800 | 70 | 1.906 | 28226.7 |
358 | 2023-09-24 10:05:18 | piggy | 1 | 28756 | 6 | 0.450 | 63902.2 |
357 | 2023-09-12 18:37:06 | piggy | 1 | 28756 | 6 | 0.470 | 61183.0 |
356 | 2023-09-10 16:21:28 | piggy | 2 | 53800 | 70 | 1.576 | 34137.1 |
355 | 2023-09-03 15:49:21 | piggy | 1 | 28756 | 6 | 0.500 | 57512.0 |
354 | 2023-06-23 03:20:49 | piggy | 1 | 28756 | 6 | 0.500 | 57512.0 |
353 | 2023-06-02 11:13:05 | piggy | 2 | 53800 | 70 | 1.330 | 40451.1 |
352 | 2023-05-17 23:17:06 | piggy | 2 | 53800 | 70 | 1.530 | 35163.4 |
351 | 2023-03-30 21:32:14 | piggy | 2 | 53800 | 70 | 1.406 | 38264.6 |
350 | 2023-03-10 11:04:54 | piggy | 2 | 53800 | 70 | 1.343 | 40059.6 |
349 | 2023-02-25 09:24:28 | piggy | 1 | 28756 | 6 | 0.423 | 67981.1 |
348 | 2023-02-07 21:57:08 | piggy | 1 | 28756 | 6 | 0.423 | 67981.1 |
347 | 2022-12-15 18:11:49 | piggy | 2 | 53800 | 70 | 1.343 | 40059.6 |
346 | 2022-12-06 03:29:56 | piggy | 1 | 28756 | 6 | 0.436 | 65954.1 |
345 | 2022-11-01 13:30:05 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
344 | 2022-08-05 04:33:56 | piggy | 2 | 53800 | 70 | 1.373 | 39184.3 |
343 | 2022-08-02 20:01:33 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
342 | 2022-07-05 15:38:39 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
341 | 2022-03-28 02:44:24 | piggy | 1 | 28756 | 6 | 0.500 | 57512.0 |
340 | 2022-03-25 21:43:51 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
339 | 2022-03-01 05:23:35 | piggy | 1 | 28756 | 6 | 0.436 | 65954.1 |
338 | 2022-02-25 19:20:52 | piggy | 1 | 28756 | 6 | 0.483 | 59536.2 |
337 | 2021-12-29 17:01:39 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
336 | 2021-11-04 05:20:01 | piggy | 1 | 28756 | 6 | 0.483 | 59536.2 |
335 | 2021-11-03 08:31:37 | piggy | 1 | 28756 | 6 | 0.466 | 61708.2 |
334 | 2021-10-31 19:24:03 | piggy | 1 | 28756 | 6 | 0.436 | 65954.1 |
333 | 2021-09-25 00:03:40 | piggy | 1 | 28756 | 6 | 0.500 | 57512.0 |
332 | 2021-09-22 21:29:08 | piggy | 1 | 28756 | 6 | 0.436 | 65954.1 |
331 | 2021-09-05 14:49:10 | piggy | 1 | 28756 | 6 | 0.483 | 59536.2 |
330 | 2021-07-18 03:23:11 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
329 | 2021-05-27 23:58:47 | piggy | 1 | 28756 | 6 | 0.500 | 57512.0 |
328 | 2021-05-02 06:21:55 | piggy | 1 | 28756 | 6 | 0.470 | 61183.0 |
327 | 2021-04-15 09:19:41 | piggy | 1 | 28756 | 6 | 1.063 | 27051.7 |
326 | 2021-03-31 12:52:19 | piggy | 1 | 28756 | 6 | 0.530 | 54256.6 |
325 | 2021-01-15 05:02:48 | piggy | 1 | 28756 | 6 | 0.440 | 65354.5 |
324 | 2021-01-10 04:20:26 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
323 | 2021-01-05 16:49:57 | piggy | 1 | 28756 | 6 | 0.436 | 65954.1 |
322 | 2020-12-16 11:04:23 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
321 | 2020-11-17 02:39:20 | piggy | 1 | 28756 | 6 | 0.470 | 61183.0 |
320 | 2020-11-08 22:50:50 | piggy | 3 | 83667 | 713 | 3.343 | 25027.5 |
319 | 2020-11-02 09:15:11 | piggy | 1 | 28756 | 6 | 1.046 | 27491.4 |
318 | 2020-11-01 14:51:28 | piggy | 1 | 28756 | 6 | 0.500 | 57512.0 |
317 | 2020-10-13 20:06:08 | piggy | 1 | 28756 | 6 | 0.483 | 59536.2 |
316 | 2020-10-04 08:44:35 | piggy | 1 | 28756 | 6 | 0.466 | 61708.2 |
315 | 2020-08-27 06:30:47 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
314 | 2020-08-27 00:50:20 | piggy | 1 | 28756 | 6 | 0.423 | 67981.1 |
313 | 2020-07-29 02:30:00 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
312 | 2020-06-14 00:56:47 | piggy | 1 | 28756 | 6 | 0.516 | 55728.7 |
311 | 2020-06-13 10:41:30 | piggy | 1 | 28756 | 6 | 0.436 | 65954.1 |
310 | 2020-05-24 14:28:11 | piggy | 1 | 28756 | 6 | 0.560 | 51350.0 |
309 | 2020-03-25 16:50:28 | piggy | 1 | 28756 | 6 | 0.483 | 59536.2 |
308 | 2020-03-23 15:21:01 | piggy | 1 | 28756 | 6 | 0.546 | 52666.7 |
307 | 2020-03-23 08:56:32 | piggy | 1 | 28756 | 6 | 0.516 | 55728.7 |
306 | 2020-03-23 04:29:22 | piggy | 1 | 28756 | 6 | 1.013 | 28387.0 |
305 | 2020-03-21 05:41:49 | piggy | 1 | 28756 | 6 | 0.656 | 43835.4 |
304 | 2020-03-18 07:53:43 | piggy | 1 | 28756 | 6 | 0.466 | 61708.2 |
303 | 2020-03-18 03:48:24 | piggy | 1 | 28756 | 6 | 0.453 | 63479.0 |
302 | 2020-03-09 10:59:00 | piggy | 1 | 28756 | 6 | 0.486 | 59168.7 |
301 | 2020-02-26 17:58:05 | piggy | 1 | 28756 | 6 | 0.500 | 57512.0 |