History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparriest"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
403 | 2024-04-25 07:13:51 | sparriest | 1 | 81242 | 4 | 2.906 | 27956.6 |
402 | 2024-03-31 21:17:17 | sparriest | 1 | 81242 | 4 | 1.576 | 51549.5 |
401 | 2024-03-29 05:17:18 | sparriest | 1 | 81242 | 4 | 2.670 | 30427.7 |
400 | 2024-03-29 01:51:52 | sparriest | 3 | 148641 | 187 | 15.483 | 9600.3 |
399 | 2024-03-28 12:22:48 | sparriest | 1 | 81242 | 4 | 2.733 | 29726.3 |
398 | 2024-03-10 16:24:16 | sparriest | 3 | 148641 | 187 | 17.843 | 8330.5 |
397 | 2024-03-10 08:37:14 | sparriest | 3 | 148641 | 187 | 18.830 | 7893.8 |
396 | 2024-03-10 08:37:16 | sparriest | 2 | 121436 | 23 | 8.923 | 13609.3 |
395 | 2024-02-28 18:42:41 | sparriest | 1 | 81242 | 4 | 1.313 | 61875.1 |
394 | 2024-02-27 07:24:19 | sparriest | 1 | 81242 | 4 | 1.516 | 53589.7 |
393 | 2024-02-26 06:27:13 | sparriest | 3 | 148641 | 187 | 22.673 | 6555.9 |
392 | 2024-02-22 02:26:56 | sparriest | 3 | 148641 | 187 | 9.080 | 16370.2 |
391 | 2024-02-21 10:17:27 | sparriest | 3 | 148641 | 187 | 14.783 | 10054.9 |
390 | 2024-02-21 10:17:27 | sparriest | 2 | 121436 | 23 | 4.576 | 26537.6 |
389 | 2024-02-21 04:49:19 | sparriest | 1 | 81242 | 4 | 1.580 | 51419.0 |
388 | 2024-01-29 16:50:50 | sparriest | 1 | 81242 | 4 | 1.456 | 55798.1 |
387 | 2024-01-25 20:09:38 | sparriest | 1 | 81242 | 4 | 1.376 | 59042.2 |
386 | 2024-01-24 11:57:55 | sparriest | 1 | 81242 | 4 | 4.423 | 18368.1 |
385 | 2024-01-23 23:22:43 | sparriest | 1 | 81242 | 4 | 1.373 | 59171.2 |
384 | 2023-12-16 21:59:37 | sparriest | 1 | 81242 | 4 | 2.576 | 31538.0 |
383 | 2023-12-06 15:26:13 | sparriest | 1 | 81242 | 4 | 2.250 | 36107.6 |
382 | 2023-12-04 07:26:20 | sparriest | 3 | 148641 | 187 | 6.296 | 23608.8 |
381 | 2023-11-21 04:23:23 | sparriest | 1 | 81242 | 4 | 1.326 | 61268.5 |
380 | 2023-11-06 03:21:28 | sparriest | 1 | 81242 | 4 | 1.376 | 59042.2 |
379 | 2023-10-31 03:52:27 | sparriest | 1 | 81242 | 4 | 1.326 | 61268.5 |
378 | 2023-09-07 15:25:59 | sparriest | 1 | 81242 | 4 | 1.220 | 66591.8 |
377 | 2023-09-02 19:26:22 | sparriest | 1 | 81242 | 4 | 1.376 | 59042.2 |
376 | 2023-09-02 06:47:41 | sparriest | 3 | 148641 | 187 | 7.563 | 19653.7 |
375 | 2023-06-15 16:29:16 | sparriest | 3 | 148641 | 187 | 6.470 | 22973.9 |
374 | 2023-06-09 11:26:24 | sparriest | 1 | 81242 | 4 | 1.360 | 59736.8 |
373 | 2023-05-18 06:34:45 | sparriest | 3 | 148641 | 187 | 6.420 | 23152.8 |
372 | 2023-05-15 17:39:12 | sparriest | 3 | 148641 | 187 | 6.703 | 22175.3 |
371 | 2023-04-27 09:58:07 | sparriest | 3 | 148641 | 187 | 6.736 | 22066.7 |
370 | 2023-04-21 12:09:58 | sparriest | 1 | 81242 | 4 | 1.390 | 58447.5 |
369 | 2023-04-03 01:11:44 | sparriest | 3 | 148641 | 187 | 7.986 | 18612.7 |
368 | 2023-03-28 20:05:00 | sparriest | 1 | 81242 | 4 | 1.220 | 66591.8 |
367 | 2023-03-24 16:38:01 | sparriest | 3 | 148641 | 187 | 6.500 | 22867.8 |
366 | 2023-03-03 00:43:03 | sparriest | 3 | 148641 | 187 | 7.126 | 20859.0 |
365 | 2023-02-25 16:45:23 | sparriest | 3 | 148641 | 187 | 6.626 | 22433.0 |
364 | 2023-01-11 17:10:56 | sparriest | 1 | 81242 | 4 | 1.250 | 64993.6 |
363 | 2022-12-08 09:16:40 | sparriest | 1 | 81242 | 4 | 1.360 | 59736.8 |
362 | 2022-12-06 12:19:39 | sparriest | 3 | 148641 | 187 | 6.813 | 21817.3 |
361 | 2022-12-05 02:37:37 | sparriest | 1 | 81242 | 4 | 1.233 | 65889.7 |
360 | 2022-10-17 22:23:09 | sparriest | 1 | 81242 | 4 | 1.280 | 63470.3 |
359 | 2022-09-17 17:38:05 | sparriest | 2 | 121436 | 23 | 3.096 | 39223.5 |
358 | 2022-09-01 11:49:41 | sparriest | 2 | 121436 | 23 | 3.843 | 31599.3 |
357 | 2022-08-20 00:23:06 | sparriest | 2 | 121436 | 23 | 3.220 | 37713.0 |
356 | 2022-08-18 14:05:41 | sparriest | 2 | 121436 | 23 | 3.610 | 33638.8 |
355 | 2022-07-18 03:10:40 | sparriest | 1 | 81242 | 4 | 1.250 | 64993.6 |
354 | 2022-07-15 11:15:07 | sparriest | 2 | 121436 | 23 | 3.533 | 34371.9 |
353 | 2022-06-26 21:41:10 | sparriest | 1 | 81242 | 4 | 1.403 | 57905.9 |
352 | 2022-06-26 00:39:41 | sparriest | 1 | 81242 | 4 | 1.250 | 64993.6 |
351 | 2022-06-11 03:42:02 | sparriest | 1 | 81242 | 4 | 1.393 | 58321.6 |
350 | 2022-06-08 10:22:24 | sparriest | 1 | 81242 | 4 | 1.436 | 56575.2 |
349 | 2022-06-04 13:38:57 | sparriest | 1 | 81242 | 4 | 1.233 | 65889.7 |
348 | 2022-04-15 16:05:28 | sparriest | 3 | 148641 | 187 | 8.703 | 17079.3 |
347 | 2022-03-07 02:37:47 | sparriest | 1 | 81242 | 4 | 1.360 | 59736.8 |
346 | 2022-03-05 09:09:47 | sparriest | 1 | 81242 | 4 | 1.250 | 64993.6 |
345 | 2022-03-03 16:20:32 | sparriest | 1 | 81242 | 4 | 1.640 | 49537.8 |
344 | 2022-02-11 18:18:07 | sparriest | 1 | 81242 | 4 | 1.360 | 59736.8 |
343 | 2021-12-15 22:16:36 | sparriest | 1 | 81242 | 4 | 1.373 | 59171.2 |
342 | 2021-11-06 16:49:45 | sparriest | 1 | 81242 | 4 | 1.466 | 55417.5 |
341 | 2021-07-20 20:10:49 | sparriest | 1 | 81242 | 4 | 1.233 | 65889.7 |
340 | 2021-04-30 23:23:35 | sparriest | 1 | 81242 | 4 | 1.286 | 63174.2 |
339 | 2021-04-18 01:37:55 | sparriest | 1 | 81242 | 4 | 1.453 | 55913.3 |
338 | 2021-03-30 06:30:19 | sparriest | 1 | 81242 | 4 | 1.456 | 55798.1 |
337 | 2021-03-09 02:12:39 | sparriest | 3 | 148641 | 187 | 7.360 | 20195.8 |
336 | 2021-02-12 22:33:09 | sparriest | 3 | 148641 | 187 | 6.733 | 22076.5 |
335 | 2021-02-08 01:16:54 | sparriest | 1 | 81242 | 4 | 1.406 | 57782.4 |
334 | 2020-12-31 18:45:12 | sparriest | 1 | 81242 | 4 | 1.263 | 64324.6 |
333 | 2020-12-15 01:56:11 | sparriest | 1 | 81242 | 4 | 1.296 | 62686.7 |
332 | 2020-11-09 19:44:33 | sparriest | 1 | 81242 | 4 | 1.250 | 64993.6 |
331 | 2020-10-30 11:17:12 | sparriest | 1 | 81242 | 4 | 1.953 | 41598.6 |
330 | 2020-10-28 23:17:18 | sparriest | 3 | 148641 | 187 | 6.750 | 22020.9 |
329 | 2020-09-20 16:49:57 | sparriest | 1 | 81242 | 4 | 1.263 | 64324.6 |
328 | 2020-06-09 21:19:09 | sparriest | 1 | 81242 | 4 | 1.283 | 63321.9 |
327 | 2020-05-23 02:33:50 | sparriest | 1 | 81242 | 4 | 1.250 | 64993.6 |
326 | 2020-03-26 03:40:44 | sparriest | 1 | 81242 | 4 | 1.420 | 57212.7 |
325 | 2020-02-25 20:41:29 | sparriest | 1 | 81242 | 4 | 4.126 | 19690.3 |
324 | 2020-02-20 04:01:35 | sparriest | 1 | 81242 | 4 | 1.516 | 53589.7 |
323 | 2020-02-18 20:35:48 | sparriest | 1 | 81242 | 4 | 1.483 | 54782.2 |
322 | 2020-02-11 04:12:44 | sparriest | 1 | 81242 | 4 | 1.250 | 64993.6 |
321 | 2020-02-04 20:28:33 | sparriest | 1 | 81242 | 4 | 2.983 | 27235.0 |
320 | 2020-02-04 14:40:47 | sparriest | 1 | 81242 | 4 | 2.513 | 32328.7 |
319 | 2020-01-27 22:48:44 | sparriest | 1 | 81242 | 4 | 1.560 | 52078.2 |
318 | 2020-01-25 19:41:11 | sparriest | 1 | 81242 | 4 | 1.500 | 54161.3 |
317 | 2020-01-25 15:38:30 | sparriest | 1 | 81242 | 4 | 1.623 | 50056.7 |
316 | 2020-01-18 04:32:01 | sparriest | 1 | 81242 | 4 | 1.670 | 48647.9 |
315 | 2020-01-12 23:07:46 | sparriest | 1 | 81242 | 4 | 1.420 | 57212.7 |
314 | 2020-01-04 21:14:12 | sparriest | 1 | 81242 | 4 | 1.530 | 53099.3 |
313 | 2019-12-31 10:53:35 | sparriest | 1 | 81242 | 4 | 1.500 | 54161.3 |
312 | 2019-11-22 22:00:16 | sparriest | 3 | 148641 | 187 | 7.170 | 20731.0 |
311 | 2019-11-12 23:59:17 | sparriest | 1 | 81242 | 4 | 1.216 | 66810.9 |
310 | 2019-11-10 22:58:46 | sparriest | 1 | 81242 | 4 | 1.250 | 64993.6 |
309 | 2019-08-09 16:03:28 | sparriest | 1 | 81242 | 4 | 1.343 | 60492.9 |
308 | 2019-04-30 08:22:46 | sparriest | 1 | 81242 | 4 | 1.336 | 60809.9 |
307 | 2019-04-04 00:01:45 | sparriest | 1 | 81242 | 4 | 1.443 | 56300.8 |
306 | 2019-01-08 20:47:12 | sparriest | 1 | 81242 | 4 | 1.223 | 66428.5 |
305 | 2019-01-04 06:19:00 | sparriest | 1 | 81242 | 4 | 1.223 | 66428.5 |
304 | 2018-12-31 22:28:01 | sparriest | 1 | 81242 | 4 | 1.430 | 56812.6 |