History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"absentees"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
421 | 2024-04-27 09:34:09 | absentees | 1 | 81242 | 3 | 1.593 | 50999.4 |
420 | 2024-04-26 13:18:48 | absentees | 3 | 148641 | 39 | 12.346 | 12039.6 |
419 | 2024-04-25 21:07:32 | absentees | 1 | 81242 | 3 | 1.563 | 51978.2 |
418 | 2024-04-25 11:24:15 | absentees | 4 | 165329 | 367 | 26.720 | 6187.5 |
417 | 2024-04-25 11:22:19 | absentees | 3 | 148641 | 39 | 23.076 | 6441.4 |
416 | 2024-04-25 11:22:20 | absentees | 2 | 121436 | 10 | 13.800 | 8799.7 |
415 | 2024-04-25 10:42:00 | absentees | 1 | 81242 | 3 | 3.313 | 24522.2 |
414 | 2024-04-07 07:27:44 | absentees | 1 | 81242 | 3 | 4.046 | 20079.6 |
413 | 2024-04-05 00:50:51 | absentees | 1 | 81242 | 3 | 1.436 | 56575.2 |
412 | 2024-03-30 00:23:24 | absentees | 1 | 81242 | 3 | 1.513 | 53696.0 |
411 | 2024-03-26 15:48:49 | absentees | 1 | 81242 | 3 | 1.470 | 55266.7 |
410 | 2024-03-22 02:52:47 | absentees | 3 | 148641 | 39 | 24.486 | 6070.4 |
409 | 2024-03-19 20:10:13 | absentees | 3 | 148641 | 39 | 22.186 | 6699.8 |
408 | 2024-03-19 20:10:10 | absentees | 2 | 121436 | 10 | 8.470 | 14337.2 |
407 | 2024-03-18 12:27:57 | absentees | 4 | 165329 | 367 | 20.936 | 7896.9 |
406 | 2024-03-15 16:21:03 | absentees | 4 | 165329 | 367 | 29.643 | 5577.3 |
405 | 2024-03-15 16:21:11 | absentees | 2 | 121436 | 10 | 4.283 | 28353.0 |
404 | 2024-03-15 16:21:02 | absentees | 3 | 148641 | 39 | 11.656 | 12752.3 |
403 | 2024-03-15 16:00:06 | absentees | 1 | 81242 | 3 | 1.470 | 55266.7 |
402 | 2024-03-02 14:46:53 | absentees | 4 | 165329 | 367 | 34.786 | 4752.7 |
401 | 2024-03-02 14:46:53 | absentees | 3 | 148641 | 39 | 12.096 | 12288.4 |
400 | 2024-03-02 14:46:50 | absentees | 2 | 121436 | 10 | 7.216 | 16828.7 |
399 | 2024-03-02 13:58:07 | absentees | 1 | 81242 | 3 | 1.343 | 60492.9 |
398 | 2024-02-28 23:18:07 | absentees | 1 | 81242 | 3 | 1.423 | 57092.1 |
397 | 2024-02-26 14:41:35 | absentees | 1 | 81242 | 3 | 1.513 | 53696.0 |
396 | 2024-02-25 06:48:53 | absentees | 1 | 81242 | 3 | 1.376 | 59042.2 |
395 | 2024-02-13 09:24:17 | absentees | 4 | 165329 | 367 | 28.223 | 5858.0 |
394 | 2024-02-08 12:11:10 | absentees | 4 | 165329 | 367 | 23.906 | 6915.8 |
393 | 2024-02-06 16:08:03 | absentees | 3 | 148641 | 39 | 17.346 | 8569.2 |
392 | 2024-02-06 16:08:06 | absentees | 2 | 121436 | 10 | 6.063 | 20029.0 |
391 | 2024-02-05 16:32:57 | absentees | 1 | 81242 | 3 | 2.923 | 27794.0 |
390 | 2024-01-29 21:09:22 | absentees | 1 | 81242 | 3 | 1.466 | 55417.5 |
389 | 2024-01-25 23:44:28 | absentees | 1 | 81242 | 3 | 3.016 | 26937.0 |
388 | 2024-01-18 11:39:30 | absentees | 4 | 165329 | 367 | 11.563 | 14298.1 |
387 | 2024-01-16 01:32:49 | absentees | 3 | 148641 | 39 | 7.046 | 21095.8 |
386 | 2024-01-10 05:43:50 | absentees | 2 | 121436 | 10 | 3.016 | 40263.9 |
385 | 2023-12-26 14:32:34 | absentees | 4 | 165329 | 367 | 27.173 | 6084.3 |
384 | 2023-12-26 07:23:30 | absentees | 1 | 81242 | 3 | 1.203 | 67532.8 |
383 | 2023-12-15 08:54:50 | absentees | 4 | 165329 | 367 | 12.770 | 12946.7 |
382 | 2023-11-29 08:21:21 | absentees | 1 | 81242 | 3 | 1.373 | 59171.2 |
381 | 2023-11-01 06:59:43 | absentees | 1 | 81242 | 3 | 1.220 | 66591.8 |
380 | 2023-10-28 23:25:26 | absentees | 4 | 165329 | 367 | 13.436 | 12304.9 |
379 | 2023-10-24 06:41:31 | absentees | 3 | 148641 | 39 | 7.030 | 21143.8 |
378 | 2023-10-18 11:40:40 | absentees | 2 | 121436 | 10 | 3.063 | 39646.1 |
377 | 2023-10-13 21:39:59 | absentees | 1 | 81242 | 3 | 1.280 | 63470.3 |
376 | 2023-08-09 21:27:03 | absentees | 1 | 81242 | 3 | 1.250 | 64993.6 |
375 | 2023-08-06 04:35:05 | absentees | 4 | 165329 | 367 | 10.486 | 15766.6 |
374 | 2023-08-03 21:53:41 | absentees | 3 | 148641 | 39 | 6.030 | 24650.2 |
373 | 2023-07-29 20:58:33 | absentees | 1 | 81242 | 3 | 1.216 | 66810.9 |
372 | 2023-07-29 13:08:35 | absentees | 2 | 121436 | 10 | 3.203 | 37913.2 |
371 | 2023-05-08 10:10:31 | absentees | 1 | 81242 | 3 | 1.233 | 65889.7 |
370 | 2023-04-17 22:03:24 | absentees | 4 | 165329 | 367 | 10.330 | 16004.7 |
369 | 2023-04-12 02:17:31 | absentees | 3 | 148641 | 39 | 5.873 | 25309.2 |
368 | 2023-04-10 14:22:03 | absentees | 1 | 81242 | 3 | 1.186 | 68500.8 |
367 | 2023-04-05 19:18:29 | absentees | 2 | 121436 | 10 | 2.970 | 40887.5 |
366 | 2023-03-03 11:10:53 | absentees | 1 | 81242 | 3 | 1.190 | 68270.6 |
365 | 2023-01-23 01:35:28 | absentees | 4 | 165329 | 367 | 12.156 | 13600.6 |
364 | 2023-01-17 05:24:46 | absentees | 3 | 148641 | 39 | 6.000 | 24773.5 |
363 | 2023-01-14 05:31:21 | absentees | 4 | 165329 | 367 | 12.546 | 13177.8 |
362 | 2023-01-02 23:13:30 | absentees | 2 | 121436 | 10 | 3.593 | 33797.9 |
361 | 2022-12-27 12:53:26 | absentees | 1 | 81242 | 3 | 1.220 | 66591.8 |
360 | 2022-12-25 06:08:52 | absentees | 1 | 81242 | 3 | 1.203 | 67532.8 |
359 | 2022-12-10 11:10:05 | absentees | 4 | 165329 | 367 | 10.220 | 16177.0 |
358 | 2022-11-02 20:00:14 | absentees | 4 | 165329 | 367 | 10.546 | 15676.9 |
357 | 2022-10-28 12:47:19 | absentees | 3 | 148641 | 39 | 7.233 | 20550.4 |
356 | 2022-09-15 17:46:44 | absentees | 1 | 81242 | 3 | 1.250 | 64993.6 |
355 | 2022-09-06 08:11:11 | absentees | 2 | 121436 | 10 | 2.970 | 40887.5 |
354 | 2022-09-03 23:14:15 | absentees | 1 | 81242 | 3 | 1.250 | 64993.6 |
353 | 2022-07-17 19:48:08 | absentees | 1 | 81242 | 3 | 1.313 | 61875.1 |
352 | 2022-05-27 01:18:40 | absentees | 3 | 148641 | 39 | 6.080 | 24447.5 |
351 | 2022-05-18 03:22:49 | absentees | 4 | 165329 | 367 | 11.826 | 13980.1 |
350 | 2022-05-09 00:53:49 | absentees | 1 | 81242 | 3 | 1.250 | 64993.6 |
349 | 2022-03-13 05:27:57 | absentees | 1 | 81242 | 3 | 1.220 | 66591.8 |
348 | 2022-01-21 00:38:31 | absentees | 1 | 81242 | 3 | 1.280 | 63470.3 |
347 | 2022-01-17 18:12:51 | absentees | 1 | 81242 | 3 | 1.436 | 56575.2 |
346 | 2022-01-14 11:29:05 | absentees | 1 | 81242 | 3 | 1.373 | 59171.2 |
345 | 2022-01-03 03:08:20 | absentees | 1 | 81242 | 3 | 1.300 | 62493.8 |
344 | 2021-11-03 13:12:11 | absentees | 1 | 81242 | 3 | 1.436 | 56575.2 |
343 | 2021-10-11 09:12:08 | absentees | 1 | 81242 | 3 | 1.220 | 66591.8 |
342 | 2021-07-09 20:40:47 | absentees | 1 | 81242 | 3 | 1.470 | 55266.7 |
341 | 2021-05-14 09:22:06 | absentees | 3 | 148641 | 39 | 6.983 | 21286.1 |
340 | 2021-04-06 00:09:36 | absentees | 1 | 81242 | 3 | 1.266 | 64172.2 |
339 | 2021-04-01 19:57:37 | absentees | 1 | 81242 | 3 | 1.403 | 57905.9 |
338 | 2021-03-17 04:46:19 | absentees | 3 | 148641 | 39 | 6.156 | 24145.7 |
337 | 2021-02-20 03:24:49 | absentees | 3 | 148641 | 39 | 7.003 | 21225.3 |
336 | 2021-02-13 17:55:07 | absentees | 4 | 165329 | 367 | 10.830 | 15265.8 |
335 | 2021-01-27 03:59:24 | absentees | 3 | 148641 | 39 | 6.876 | 21617.4 |
334 | 2021-01-03 21:12:44 | absentees | 1 | 81242 | 3 | 1.233 | 65889.7 |
333 | 2020-12-28 14:36:18 | absentees | 1 | 81242 | 3 | 1.283 | 63321.9 |
332 | 2020-12-21 13:45:40 | absentees | 4 | 165329 | 367 | 10.703 | 15447.0 |
331 | 2020-12-20 22:02:11 | absentees | 1 | 81242 | 3 | 1.250 | 64993.6 |
330 | 2020-12-06 22:25:32 | absentees | 1 | 81242 | 3 | 1.236 | 65729.8 |
329 | 2020-11-18 18:31:19 | absentees | 1 | 81242 | 3 | 1.440 | 56418.1 |
328 | 2020-11-07 14:44:51 | absentees | 3 | 148641 | 39 | 7.283 | 20409.3 |
327 | 2020-11-03 02:41:30 | absentees | 1 | 81242 | 3 | 1.343 | 60492.9 |
326 | 2020-11-02 10:20:04 | absentees | 4 | 165329 | 367 | 11.953 | 13831.6 |
325 | 2020-11-02 10:19:57 | absentees | 3 | 148641 | 39 | 7.190 | 20673.3 |
324 | 2020-11-02 10:19:53 | absentees | 2 | 121436 | 10 | 3.203 | 37913.2 |
323 | 2020-11-02 10:19:51 | absentees | 1 | 81242 | 3 | 1.250 | 64993.6 |
322 | 2020-10-31 01:12:39 | absentees | 1 | 81242 | 3 | 1.513 | 53696.0 |