History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparser"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
416 | 2024-04-27 16:44:44 | sparser | 1 | 69583 | 6 | 1.623 | 42873.1 |
415 | 2024-04-27 00:33:39 | sparser | 2 | 107671 | 75 | 8.106 | 13282.9 |
414 | 2024-04-26 15:05:56 | sparser | 2 | 107671 | 75 | 3.656 | 29450.5 |
413 | 2024-04-19 05:14:39 | sparser | 1 | 69583 | 6 | 3.266 | 21305.3 |
412 | 2024-04-03 11:21:22 | sparser | 1 | 69583 | 6 | 3.190 | 21812.9 |
411 | 2024-03-30 06:57:00 | sparser | 1 | 69583 | 6 | 4.266 | 16311.1 |
410 | 2024-03-03 12:19:50 | sparser | 1 | 69583 | 6 | 2.923 | 23805.3 |
409 | 2024-01-15 22:39:23 | sparser | 3 | 134027 | 679 | 6.830 | 19623.3 |
408 | 2024-01-15 22:39:21 | sparser | 2 | 107671 | 75 | 3.376 | 31893.1 |
407 | 2024-01-11 10:06:44 | sparser | 1 | 69583 | 6 | 1.266 | 54962.9 |
406 | 2023-12-21 11:09:19 | sparser | 1 | 69583 | 6 | 1.266 | 54962.9 |
405 | 2023-12-16 17:12:33 | sparser | 1 | 69583 | 6 | 1.216 | 57222.9 |
404 | 2023-12-12 02:06:43 | sparser | 2 | 107671 | 75 | 3.220 | 33438.2 |
403 | 2023-11-19 21:15:13 | sparser | 1 | 69583 | 6 | 1.186 | 58670.3 |
402 | 2023-11-16 04:26:35 | sparser | 1 | 69583 | 6 | 1.190 | 58473.1 |
401 | 2023-11-12 16:42:16 | sparser | 1 | 69583 | 6 | 1.233 | 56433.9 |
400 | 2023-11-05 18:55:57 | sparser | 1 | 69583 | 6 | 1.296 | 53690.6 |
399 | 2023-11-01 00:13:05 | sparser | 1 | 69583 | 6 | 1.186 | 58670.3 |
398 | 2023-10-23 01:21:53 | sparser | 1 | 69583 | 6 | 1.250 | 55666.4 |
397 | 2023-10-14 08:57:09 | sparser | 1 | 69583 | 6 | 1.076 | 64668.2 |
396 | 2023-09-27 20:07:41 | sparser | 1 | 69583 | 6 | 1.186 | 58670.3 |
395 | 2023-09-23 03:29:56 | sparser | 1 | 69583 | 6 | 1.670 | 41666.5 |
394 | 2023-09-10 19:33:46 | sparser | 2 | 107671 | 75 | 3.190 | 33752.7 |
393 | 2023-08-27 18:19:26 | sparser | 1 | 69583 | 6 | 1.313 | 52995.4 |
392 | 2023-08-12 02:35:23 | sparser | 1 | 69583 | 6 | 1.266 | 54962.9 |
391 | 2023-06-03 14:29:01 | sparser | 2 | 107671 | 75 | 2.873 | 37476.9 |
390 | 2023-05-25 03:33:10 | sparser | 1 | 69583 | 6 | 1.186 | 58670.3 |
389 | 2023-04-23 12:17:40 | sparser | 1 | 69583 | 6 | 1.076 | 64668.2 |
388 | 2023-03-19 23:08:44 | sparser | 1 | 69583 | 6 | 1.060 | 65644.3 |
387 | 2023-03-08 22:09:57 | sparser | 2 | 107671 | 75 | 2.813 | 38276.2 |
386 | 2023-02-02 18:50:08 | sparser | 1 | 69583 | 6 | 1.173 | 59320.5 |
385 | 2023-01-07 10:00:32 | sparser | 1 | 69583 | 6 | 1.076 | 64668.2 |
384 | 2023-01-07 00:55:43 | sparser | 1 | 69583 | 6 | 1.233 | 56433.9 |
383 | 2023-01-03 16:03:44 | sparser | 1 | 69583 | 6 | 1.060 | 65644.3 |
382 | 2022-12-17 21:29:59 | sparser | 1 | 69583 | 6 | 1.126 | 61796.6 |
381 | 2022-12-13 09:33:26 | sparser | 2 | 107671 | 75 | 3.296 | 32667.2 |
380 | 2022-11-27 10:24:30 | sparser | 1 | 69583 | 6 | 1.093 | 63662.4 |
379 | 2022-11-26 22:52:04 | sparser | 1 | 69583 | 6 | 1.080 | 64428.7 |
378 | 2022-11-19 06:53:59 | sparser | 1 | 69583 | 6 | 1.186 | 58670.3 |
377 | 2022-10-02 04:10:27 | sparser | 1 | 69583 | 6 | 1.310 | 53116.8 |
376 | 2022-09-03 00:58:34 | sparser | 1 | 69583 | 6 | 1.063 | 65459.1 |
375 | 2022-09-02 11:02:34 | sparser | 1 | 69583 | 6 | 1.123 | 61961.7 |
374 | 2022-05-19 17:20:46 | sparser | 1 | 69583 | 6 | 1.186 | 58670.3 |
373 | 2022-04-19 05:49:54 | sparser | 1 | 69583 | 6 | 1.093 | 63662.4 |
372 | 2022-02-03 08:02:02 | sparser | 1 | 69583 | 6 | 1.203 | 57841.2 |
371 | 2022-01-06 11:09:26 | sparser | 1 | 69583 | 6 | 1.233 | 56433.9 |
370 | 2021-12-06 11:45:39 | sparser | 2 | 107671 | 75 | 3.390 | 31761.4 |
369 | 2021-11-23 02:21:11 | sparser | 1 | 69583 | 6 | 1.076 | 64668.2 |
368 | 2021-11-21 00:50:27 | sparser | 1 | 69583 | 6 | 1.123 | 61961.7 |
367 | 2021-11-14 10:07:13 | sparser | 2 | 107671 | 75 | 3.610 | 29825.8 |
366 | 2021-11-07 00:15:09 | sparser | 3 | 134027 | 679 | 5.796 | 23124.1 |
365 | 2021-11-07 00:14:59 | sparser | 2 | 107671 | 75 | 3.093 | 34811.2 |
364 | 2021-11-02 11:57:59 | sparser | 1 | 69583 | 6 | 1.076 | 64668.2 |
363 | 2021-10-19 02:56:48 | sparser | 1 | 69583 | 6 | 1.203 | 57841.2 |
362 | 2021-09-24 02:06:33 | sparser | 1 | 69583 | 6 | 1.250 | 55666.4 |
361 | 2021-09-23 22:36:51 | sparser | 1 | 69583 | 6 | 1.076 | 64668.2 |
360 | 2021-08-26 18:54:42 | sparser | 1 | 69583 | 6 | 1.250 | 55666.4 |
359 | 2021-07-07 17:09:28 | sparser | 1 | 69583 | 6 | 1.093 | 63662.4 |
358 | 2021-05-02 10:21:52 | sparser | 1 | 69583 | 6 | 1.250 | 55666.4 |
357 | 2021-03-31 17:19:40 | sparser | 1 | 69583 | 6 | 1.296 | 53690.6 |
356 | 2021-03-05 10:53:45 | sparser | 1 | 69583 | 6 | 1.096 | 63488.1 |
355 | 2020-12-16 14:32:25 | sparser | 1 | 69583 | 6 | 1.106 | 62914.1 |
354 | 2020-11-20 01:17:39 | sparser | 1 | 69583 | 6 | 1.220 | 57035.2 |
353 | 2020-11-18 04:02:40 | sparser | 1 | 69583 | 6 | 1.156 | 60192.9 |
352 | 2020-10-02 06:49:42 | sparser | 1 | 69583 | 6 | 1.170 | 59472.6 |
351 | 2020-08-31 08:25:05 | sparser | 1 | 69583 | 6 | 1.140 | 61037.7 |
350 | 2020-08-20 20:42:19 | sparser | 1 | 69583 | 6 | 1.203 | 57841.2 |
349 | 2020-06-03 11:44:19 | sparser | 1 | 69583 | 6 | 1.110 | 62687.4 |
348 | 2020-03-21 12:10:26 | sparser | 1 | 69583 | 6 | 1.330 | 52318.0 |
347 | 2020-03-14 06:59:37 | sparser | 1 | 69583 | 6 | 1.096 | 63488.1 |
346 | 2020-03-07 07:25:26 | sparser | 1 | 69583 | 6 | 1.063 | 65459.1 |
345 | 2020-03-01 01:19:43 | sparser | 1 | 69583 | 6 | 1.283 | 54234.6 |
344 | 2020-02-29 12:36:19 | sparser | 1 | 69583 | 6 | 2.876 | 24194.4 |
343 | 2020-02-28 11:41:51 | sparser | 1 | 69583 | 6 | 1.313 | 52995.4 |
342 | 2020-02-25 11:43:02 | sparser | 1 | 69583 | 6 | 1.390 | 50059.7 |
341 | 2020-02-10 14:56:36 | sparser | 3 | 134027 | 679 | 17.046 | 7862.7 |
340 | 2020-02-09 11:42:53 | sparser | 1 | 69583 | 6 | 1.330 | 52318.0 |
339 | 2020-02-08 21:14:57 | sparser | 3 | 134027 | 679 | 16.860 | 7949.4 |
338 | 2020-02-08 11:49:33 | sparser | 1 | 69583 | 6 | 2.300 | 30253.5 |
337 | 2020-02-07 07:41:59 | sparser | 3 | 134027 | 679 | 21.440 | 6251.3 |
336 | 2020-02-07 07:28:48 | sparser | 3 | 134027 | 679 | 17.766 | 7544.0 |
335 | 2020-02-07 01:46:24 | sparser | 3 | 134027 | 679 | 9.233 | 14516.1 |
334 | 2020-02-06 11:37:31 | sparser | 3 | 134027 | 679 | 17.533 | 7644.3 |
333 | 2020-02-05 12:22:22 | sparser | 1 | 69583 | 6 | 1.406 | 49490.0 |
332 | 2020-02-03 16:30:10 | sparser | 1 | 69583 | 6 | 2.610 | 26660.2 |
331 | 2020-01-31 17:10:49 | sparser | 1 | 69583 | 6 | 1.783 | 39025.8 |
330 | 2020-01-31 07:21:19 | sparser | 1 | 69583 | 6 | 4.390 | 15850.3 |
329 | 2020-01-26 17:02:08 | sparser | 2 | 107671 | 75 | 8.390 | 12833.3 |
328 | 2020-01-25 17:38:18 | sparser | 2 | 107671 | 75 | 7.376 | 14597.5 |
327 | 2020-01-16 23:48:27 | sparser | 1 | 69583 | 6 | 1.580 | 44039.9 |
326 | 2020-01-16 20:25:25 | sparser | 1 | 69583 | 6 | 1.233 | 56433.9 |
325 | 2020-01-16 19:29:04 | sparser | 1 | 69583 | 6 | 1.483 | 46920.4 |
324 | 2020-01-13 20:12:55 | sparser | 2 | 107671 | 75 | 3.516 | 30623.2 |
323 | 2020-01-13 14:36:04 | sparser | 3 | 134027 | 679 | 8.763 | 15294.6 |
322 | 2020-01-13 13:40:19 | sparser | 3 | 134027 | 679 | 8.923 | 15020.4 |
321 | 2020-01-13 09:15:59 | sparser | 2 | 107671 | 75 | 7.423 | 14505.1 |
320 | 2020-01-13 09:15:35 | sparser | 3 | 134027 | 679 | 7.796 | 17191.8 |
319 | 2020-01-13 05:22:05 | sparser | 1 | 69583 | 6 | 1.296 | 53690.6 |
318 | 2020-01-08 05:03:21 | sparser | 1 | 69583 | 6 | 1.640 | 42428.7 |
317 | 2020-01-07 14:21:35 | sparser | 1 | 69583 | 6 | 2.936 | 23699.9 |