History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparker"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
421 | 2024-04-30 19:14:41 | sparker | 1 | 69583 | 12 | 1.096 | 63488.1 |
420 | 2024-04-20 23:29:17 | sparker | 1 | 69583 | 12 | 5.266 | 13213.6 |
419 | 2024-04-20 23:27:00 | sparker | 2 | 107671 | 100 | 12.813 | 8403.3 |
418 | 2024-04-20 22:14:44 | sparker | 3 | 134027 | 769 | 21.483 | 6238.7 |
417 | 2024-04-19 05:14:40 | sparker | 1 | 69583 | 12 | 3.703 | 18791.0 |
416 | 2024-04-17 16:07:02 | sparker | 3 | 134027 | 769 | 6.890 | 19452.4 |
415 | 2024-04-16 15:35:38 | sparker | 3 | 134027 | 769 | 10.876 | 12323.2 |
414 | 2024-04-13 18:27:33 | sparker | 3 | 134027 | 769 | 20.296 | 6603.6 |
413 | 2024-04-13 18:03:50 | sparker | 2 | 107671 | 100 | 6.796 | 15843.3 |
412 | 2024-04-13 01:16:37 | sparker | 2 | 107671 | 100 | 2.860 | 37647.2 |
411 | 2024-04-13 01:14:21 | sparker | 3 | 134027 | 769 | 8.233 | 16279.2 |
410 | 2024-04-13 01:14:05 | sparker | 1 | 69583 | 12 | 1.376 | 50569.0 |
409 | 2024-04-13 01:09:12 | sparker | 3 | 134027 | 769 | 7.516 | 17832.2 |
408 | 2024-04-13 01:09:00 | sparker | 2 | 107671 | 100 | 6.533 | 16481.1 |
407 | 2024-04-12 22:30:04 | sparker | 2 | 107671 | 100 | 3.486 | 30886.7 |
406 | 2024-04-03 11:21:25 | sparker | 1 | 69583 | 12 | 1.440 | 48321.5 |
405 | 2024-03-30 06:57:03 | sparker | 1 | 69583 | 12 | 1.420 | 49002.1 |
404 | 2024-03-20 19:59:27 | sparker | 1 | 69583 | 12 | 1.580 | 44039.9 |
403 | 2024-03-11 01:53:44 | sparker | 1 | 69583 | 12 | 2.813 | 24736.2 |
402 | 2024-02-26 18:05:11 | sparker | 3 | 134027 | 769 | 11.156 | 12013.9 |
401 | 2024-02-22 04:44:45 | sparker | 3 | 134027 | 769 | 8.280 | 16186.8 |
400 | 2024-02-21 14:36:25 | sparker | 2 | 107671 | 100 | 10.313 | 10440.3 |
399 | 2024-02-21 09:06:42 | sparker | 3 | 134027 | 769 | 17.626 | 7603.9 |
398 | 2024-02-19 19:33:54 | sparker | 3 | 134027 | 769 | 14.360 | 9333.4 |
397 | 2024-02-19 19:33:55 | sparker | 2 | 107671 | 100 | 3.780 | 28484.4 |
396 | 2024-02-19 12:50:34 | sparker | 1 | 69583 | 12 | 1.186 | 58670.3 |
395 | 2024-01-16 22:49:58 | sparker | 1 | 69583 | 12 | 1.266 | 54962.9 |
394 | 2023-12-15 06:40:57 | sparker | 3 | 134027 | 769 | 6.923 | 19359.7 |
393 | 2023-12-15 03:24:34 | sparker | 1 | 69583 | 12 | 1.173 | 59320.5 |
392 | 2023-12-12 20:21:15 | sparker | 2 | 107671 | 100 | 2.923 | 36835.8 |
391 | 2023-12-07 23:21:36 | sparker | 1 | 69583 | 12 | 1.126 | 61796.6 |
390 | 2023-12-07 23:21:34 | sparker | 1 | 69583 | 12 | 1.190 | 58473.1 |
389 | 2023-12-07 22:06:52 | sparker | 1 | 69583 | 12 | 1.220 | 57035.2 |
388 | 2023-11-19 21:14:41 | sparker | 1 | 69583 | 12 | 1.186 | 58670.3 |
387 | 2023-11-10 07:03:41 | sparker | 1 | 69583 | 12 | 1.076 | 64668.2 |
386 | 2023-11-01 01:02:42 | sparker | 1 | 69583 | 12 | 1.203 | 57841.2 |
385 | 2023-10-30 05:03:55 | sparker | 1 | 69583 | 12 | 1.110 | 62687.4 |
384 | 2023-10-15 20:31:36 | sparker | 1 | 69583 | 12 | 1.093 | 63662.4 |
383 | 2023-10-01 13:17:56 | sparker | 1 | 69583 | 12 | 1.296 | 53690.6 |
382 | 2023-09-29 22:05:28 | sparker | 1 | 69583 | 12 | 1.313 | 52995.4 |
381 | 2023-09-23 10:41:24 | sparker | 1 | 69583 | 12 | 1.266 | 54962.9 |
380 | 2023-09-13 12:38:41 | sparker | 3 | 134027 | 769 | 5.923 | 22628.2 |
379 | 2023-09-13 01:04:11 | sparker | 2 | 107671 | 100 | 2.906 | 37051.3 |
378 | 2023-07-29 11:47:19 | sparker | 1 | 69583 | 12 | 1.076 | 64668.2 |
377 | 2023-06-25 08:53:37 | sparker | 1 | 69583 | 12 | 1.080 | 64428.7 |
376 | 2023-06-16 01:18:25 | sparker | 2 | 107671 | 100 | 2.843 | 37872.3 |
375 | 2023-06-07 08:35:35 | sparker | 3 | 134027 | 769 | 6.733 | 19906.0 |
374 | 2023-04-26 20:01:50 | sparker | 1 | 69583 | 12 | 1.110 | 62687.4 |
373 | 2023-03-14 08:29:01 | sparker | 2 | 107671 | 100 | 3.423 | 31455.2 |
372 | 2023-03-11 23:09:53 | sparker | 3 | 134027 | 769 | 5.813 | 23056.4 |
371 | 2023-02-24 04:21:10 | sparker | 1 | 69583 | 12 | 1.326 | 52475.9 |
370 | 2023-02-20 20:47:28 | sparker | 1 | 69583 | 12 | 1.220 | 57035.2 |
369 | 2023-02-14 21:12:44 | sparker | 1 | 69583 | 12 | 1.063 | 65459.1 |
368 | 2022-12-17 00:27:10 | sparker | 2 | 107671 | 100 | 3.220 | 33438.2 |
367 | 2022-12-15 08:24:31 | sparker | 3 | 134027 | 769 | 5.750 | 23309.0 |
366 | 2022-12-13 02:36:48 | sparker | 1 | 69583 | 12 | 1.080 | 64428.7 |
365 | 2022-10-20 10:54:16 | sparker | 1 | 69583 | 12 | 1.203 | 57841.2 |
364 | 2022-08-19 04:04:05 | sparker | 1 | 69583 | 12 | 1.080 | 64428.7 |
363 | 2022-08-15 17:07:37 | sparker | 3 | 134027 | 769 | 6.623 | 20236.6 |
362 | 2022-08-15 17:07:18 | sparker | 2 | 107671 | 100 | 2.860 | 37647.2 |
361 | 2022-08-12 18:05:53 | sparker | 2 | 107671 | 100 | 2.860 | 37647.2 |
360 | 2022-08-06 10:46:09 | sparker | 1 | 69583 | 12 | 1.096 | 63488.1 |
359 | 2022-08-04 03:27:33 | sparker | 3 | 134027 | 769 | 6.203 | 21606.8 |
358 | 2022-07-19 08:45:27 | sparker | 3 | 134027 | 769 | 5.780 | 23188.1 |
357 | 2022-07-19 08:45:08 | sparker | 2 | 107671 | 100 | 2.843 | 37872.3 |
356 | 2022-07-17 23:08:12 | sparker | 1 | 69583 | 12 | 1.220 | 57035.2 |
355 | 2022-07-03 15:51:14 | sparker | 1 | 69583 | 12 | 1.080 | 64428.7 |
354 | 2022-07-03 02:59:52 | sparker | 1 | 69583 | 12 | 1.076 | 64668.2 |
353 | 2022-06-11 14:52:03 | sparker | 1 | 69583 | 12 | 1.203 | 57841.2 |
352 | 2022-06-11 04:14:11 | sparker | 3 | 134027 | 769 | 5.890 | 22755.0 |
351 | 2022-06-08 23:04:16 | sparker | 1 | 69583 | 12 | 1.216 | 57222.9 |
350 | 2022-06-08 00:27:08 | sparker | 1 | 69583 | 12 | 1.110 | 62687.4 |
349 | 2022-04-25 03:27:48 | sparker | 3 | 134027 | 769 | 6.093 | 21996.9 |
348 | 2022-04-07 13:19:47 | sparker | 1 | 69583 | 12 | 1.220 | 57035.2 |
347 | 2022-03-12 01:07:16 | sparker | 3 | 134027 | 769 | 6.376 | 21020.5 |
346 | 2022-02-07 07:30:43 | sparker | 1 | 69583 | 12 | 1.093 | 63662.4 |
345 | 2022-01-09 03:03:12 | sparker | 1 | 69583 | 12 | 1.123 | 61961.7 |
344 | 2022-01-06 23:30:05 | sparker | 1 | 69583 | 12 | 1.266 | 54962.9 |
343 | 2021-12-05 03:35:37 | sparker | 1 | 69583 | 12 | 1.140 | 61037.7 |
342 | 2021-12-04 15:33:04 | sparker | 1 | 69583 | 12 | 1.173 | 59320.5 |
341 | 2021-12-04 04:20:59 | sparker | 1 | 69583 | 12 | 1.186 | 58670.3 |
340 | 2021-12-03 11:43:30 | sparker | 1 | 69583 | 12 | 1.076 | 64668.2 |
339 | 2021-12-03 02:00:15 | sparker | 1 | 69583 | 12 | 1.376 | 50569.0 |
338 | 2021-12-02 18:59:16 | sparker | 1 | 69583 | 12 | 1.453 | 47889.2 |
337 | 2021-11-28 23:30:55 | sparker | 1 | 69583 | 12 | 1.126 | 61796.6 |
336 | 2021-11-28 16:02:21 | sparker | 1 | 69583 | 12 | 1.233 | 56433.9 |
335 | 2021-11-28 03:04:37 | sparker | 1 | 69583 | 12 | 1.156 | 60192.9 |
334 | 2021-11-27 10:18:51 | sparker | 1 | 69583 | 12 | 1.123 | 61961.7 |
333 | 2021-11-26 22:07:29 | sparker | 1 | 69583 | 12 | 1.406 | 49490.0 |
332 | 2021-11-26 09:14:13 | sparker | 1 | 69583 | 12 | 1.220 | 57035.2 |
331 | 2021-11-25 18:08:16 | sparker | 1 | 69583 | 12 | 1.296 | 53690.6 |
330 | 2021-11-25 06:17:49 | sparker | 1 | 69583 | 12 | 1.266 | 54962.9 |
329 | 2021-11-18 22:20:45 | sparker | 1 | 69583 | 12 | 1.280 | 54361.7 |
328 | 2021-11-18 10:06:23 | sparker | 1 | 69583 | 12 | 1.093 | 63662.4 |
327 | 2021-11-17 21:11:33 | sparker | 1 | 69583 | 12 | 1.093 | 63662.4 |
326 | 2021-11-17 13:30:09 | sparker | 1 | 69583 | 12 | 1.233 | 56433.9 |
325 | 2021-11-07 00:16:33 | sparker | 1 | 69583 | 12 | 1.283 | 54234.6 |
324 | 2021-11-05 05:40:25 | sparker | 1 | 69583 | 12 | 1.250 | 55666.4 |
323 | 2021-10-15 00:10:51 | sparker | 1 | 69583 | 12 | 1.076 | 64668.2 |
322 | 2021-10-14 08:56:15 | sparker | 1 | 69583 | 12 | 1.220 | 57035.2 |