History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"truants"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
413 | 2024-05-04 07:17:09 | truants | 1 | 69583 | 2 | 3.953 | 17602.6 |
412 | 2024-04-30 02:49:40 | truants | 1 | 69583 | 2 | 5.360 | 12981.9 |
411 | 2024-04-30 02:48:50 | truants | 1 | 69583 | 2 | 2.670 | 26061.0 |
410 | 2024-04-06 19:30:08 | truants | 1 | 69583 | 2 | 4.033 | 17253.4 |
409 | 2024-03-20 19:08:27 | truants | 3 | 134027 | 331 | 21.830 | 6139.6 |
408 | 2024-03-20 02:59:44 | truants | 3 | 134027 | 331 | 13.890 | 9649.2 |
407 | 2024-03-19 20:45:52 | truants | 3 | 134027 | 331 | 12.783 | 10484.8 |
406 | 2024-03-18 21:04:50 | truants | 3 | 134027 | 331 | 10.830 | 12375.5 |
405 | 2024-03-18 11:43:59 | truants | 3 | 134027 | 331 | 17.160 | 7810.4 |
404 | 2024-03-18 08:59:35 | truants | 3 | 134027 | 331 | 13.796 | 9714.9 |
403 | 2024-01-21 05:37:47 | truants | 1 | 69583 | 2 | 1.110 | 62687.4 |
402 | 2024-01-12 21:33:24 | truants | 3 | 134027 | 331 | 5.970 | 22450.1 |
401 | 2024-01-09 11:04:40 | truants | 1 | 69583 | 2 | 1.190 | 58473.1 |
400 | 2023-12-22 01:25:30 | truants | 3 | 134027 | 331 | 7.076 | 18941.1 |
399 | 2023-12-07 19:55:56 | truants | 2 | 107671 | 29 | 3.220 | 33438.2 |
398 | 2023-12-06 11:00:15 | truants | 3 | 134027 | 331 | 7.486 | 17903.7 |
397 | 2023-12-05 06:28:35 | truants | 3 | 134027 | 331 | 7.516 | 17832.2 |
396 | 2023-12-03 03:28:31 | truants | 1 | 69583 | 2 | 1.330 | 52318.0 |
395 | 2023-11-30 10:03:50 | truants | 3 | 134027 | 331 | 6.406 | 20922.1 |
394 | 2023-11-21 10:56:51 | truants | 1 | 69583 | 2 | 2.110 | 32977.7 |
393 | 2023-11-20 16:12:17 | truants | 1 | 69583 | 2 | 1.220 | 57035.2 |
392 | 2023-11-10 16:52:03 | truants | 2 | 107671 | 29 | 2.796 | 38508.9 |
391 | 2023-11-10 16:51:54 | truants | 3 | 134027 | 331 | 7.890 | 16986.9 |
390 | 2023-11-07 09:19:39 | truants | 1 | 69583 | 2 | 2.720 | 25582.0 |
389 | 2023-11-07 06:10:51 | truants | 1 | 69583 | 2 | 1.063 | 65459.1 |
388 | 2023-11-01 16:35:29 | truants | 1 | 69583 | 2 | 1.063 | 65459.1 |
387 | 2023-10-17 05:22:38 | truants | 1 | 69583 | 2 | 2.153 | 32319.1 |
386 | 2023-10-04 23:17:45 | truants | 3 | 134027 | 331 | 16.970 | 7897.9 |
385 | 2023-10-03 16:17:57 | truants | 1 | 69583 | 2 | 1.060 | 65644.3 |
384 | 2023-10-01 05:35:10 | truants | 3 | 134027 | 331 | 7.470 | 17942.0 |
383 | 2023-09-28 09:56:07 | truants | 3 | 134027 | 331 | 7.343 | 18252.3 |
382 | 2023-09-22 19:08:43 | truants | 1 | 69583 | 2 | 1.203 | 57841.2 |
381 | 2023-09-07 06:05:03 | truants | 1 | 69583 | 2 | 1.063 | 65459.1 |
380 | 2023-09-03 16:51:34 | truants | 1 | 69583 | 2 | 1.060 | 65644.3 |
379 | 2023-08-29 13:08:07 | truants | 3 | 134027 | 331 | 5.813 | 23056.4 |
378 | 2023-08-25 08:39:21 | truants | 1 | 69583 | 2 | 1.153 | 60349.5 |
377 | 2023-07-28 18:52:20 | truants | 3 | 134027 | 331 | 5.766 | 23244.4 |
376 | 2023-05-28 02:35:53 | truants | 1 | 69583 | 2 | 1.063 | 65459.1 |
375 | 2023-05-16 16:07:03 | truants | 3 | 134027 | 331 | 5.780 | 23188.1 |
374 | 2023-04-26 06:09:56 | truants | 1 | 69583 | 2 | 1.156 | 60192.9 |
373 | 2023-03-24 15:17:05 | truants | 1 | 69583 | 2 | 1.153 | 60349.5 |
372 | 2023-03-04 16:55:44 | truants | 1 | 69583 | 2 | 1.046 | 66522.9 |
371 | 2023-03-02 10:43:18 | truants | 3 | 134027 | 331 | 6.250 | 21444.3 |
370 | 2023-02-26 20:43:58 | truants | 3 | 134027 | 331 | 5.563 | 24092.6 |
369 | 2023-02-22 10:37:48 | truants | 3 | 134027 | 331 | 6.516 | 20568.9 |
368 | 2023-01-10 08:42:52 | truants | 1 | 69583 | 2 | 1.046 | 66522.9 |
367 | 2022-12-22 13:19:09 | truants | 1 | 69583 | 2 | 1.046 | 66522.9 |
366 | 2022-12-02 15:56:53 | truants | 3 | 134027 | 331 | 5.656 | 23696.4 |
365 | 2022-10-20 18:49:52 | truants | 1 | 69583 | 2 | 1.063 | 65459.1 |
364 | 2022-08-05 20:18:54 | truants | 1 | 69583 | 2 | 1.266 | 54962.9 |
363 | 2022-07-10 19:34:07 | truants | 3 | 134027 | 331 | 7.200 | 18614.9 |
362 | 2022-06-22 00:31:39 | truants | 3 | 134027 | 331 | 6.423 | 20866.7 |
361 | 2022-06-13 06:18:23 | truants | 1 | 69583 | 2 | 1.050 | 66269.5 |
360 | 2022-06-11 01:16:55 | truants | 1 | 69583 | 2 | 1.200 | 57985.8 |
359 | 2022-06-09 21:23:03 | truants | 3 | 134027 | 331 | 5.796 | 23124.1 |
358 | 2022-06-06 22:52:02 | truants | 1 | 69583 | 2 | 1.093 | 63662.4 |
357 | 2022-05-11 04:48:08 | truants | 3 | 134027 | 331 | 13.656 | 9814.5 |
356 | 2022-05-10 06:31:53 | truants | 3 | 134027 | 331 | 7.123 | 18816.1 |
355 | 2022-05-09 19:12:05 | truants | 3 | 134027 | 331 | 14.766 | 9076.7 |
354 | 2022-05-08 07:25:25 | truants | 3 | 134027 | 331 | 7.330 | 18284.7 |
353 | 2022-05-07 15:05:52 | truants | 3 | 134027 | 331 | 7.310 | 18334.7 |
352 | 2022-05-06 22:25:05 | truants | 3 | 134027 | 331 | 5.860 | 22871.5 |
351 | 2022-05-06 00:00:09 | truants | 3 | 134027 | 331 | 10.283 | 13033.8 |
350 | 2022-05-05 14:06:50 | truants | 3 | 134027 | 331 | 6.016 | 22278.4 |
349 | 2022-05-04 14:58:56 | truants | 3 | 134027 | 331 | 7.063 | 18975.9 |
348 | 2022-05-04 05:06:08 | truants | 3 | 134027 | 331 | 5.843 | 22938.0 |
347 | 2022-05-03 13:28:59 | truants | 3 | 134027 | 331 | 7.220 | 18563.3 |
346 | 2022-05-02 01:35:06 | truants | 1 | 69583 | 2 | 1.063 | 65459.1 |
345 | 2022-05-01 08:30:45 | truants | 3 | 134027 | 331 | 8.563 | 15651.9 |
344 | 2022-04-27 20:51:17 | truants | 3 | 134027 | 331 | 8.313 | 16122.6 |
343 | 2022-04-27 04:24:16 | truants | 3 | 134027 | 331 | 5.876 | 22809.2 |
342 | 2022-04-26 16:49:12 | truants | 3 | 134027 | 331 | 6.736 | 19897.1 |
341 | 2022-04-26 05:17:34 | truants | 3 | 134027 | 331 | 6.626 | 20227.4 |
340 | 2022-04-26 04:47:15 | truants | 3 | 134027 | 331 | 6.563 | 20421.6 |
339 | 2022-04-25 14:33:48 | truants | 3 | 134027 | 331 | 7.046 | 19021.7 |
338 | 2022-04-24 23:14:50 | truants | 3 | 134027 | 331 | 6.140 | 21828.5 |
337 | 2022-04-23 11:46:19 | truants | 3 | 134027 | 331 | 5.750 | 23309.0 |
336 | 2022-04-23 06:21:05 | truants | 3 | 134027 | 331 | 5.813 | 23056.4 |
335 | 2022-04-22 14:26:28 | truants | 3 | 134027 | 331 | 7.843 | 17088.7 |
334 | 2022-04-21 20:17:27 | truants | 3 | 134027 | 331 | 6.953 | 19276.1 |
333 | 2022-04-21 07:16:48 | truants | 3 | 134027 | 331 | 6.016 | 22278.4 |
332 | 2022-04-20 14:53:33 | truants | 3 | 134027 | 331 | 7.656 | 17506.1 |
331 | 2022-04-20 01:49:01 | truants | 3 | 134027 | 331 | 5.966 | 22465.1 |
330 | 2022-04-19 14:25:43 | truants | 3 | 134027 | 331 | 6.610 | 20276.4 |
329 | 2022-04-18 18:52:12 | truants | 3 | 134027 | 331 | 8.046 | 16657.6 |
328 | 2022-04-18 00:36:42 | truants | 3 | 134027 | 331 | 6.500 | 20619.5 |
327 | 2022-04-17 11:07:54 | truants | 3 | 134027 | 331 | 5.813 | 23056.4 |
326 | 2022-04-16 16:03:29 | truants | 3 | 134027 | 331 | 6.360 | 21073.4 |
325 | 2022-04-15 10:17:14 | truants | 3 | 134027 | 331 | 7.483 | 17910.9 |
324 | 2022-04-12 15:26:26 | truants | 3 | 134027 | 331 | 6.813 | 19672.2 |
323 | 2022-04-12 02:58:45 | truants | 3 | 134027 | 331 | 7.266 | 18445.8 |
322 | 2022-04-11 20:00:03 | truants | 3 | 134027 | 331 | 6.656 | 20136.3 |
321 | 2022-04-11 07:43:21 | truants | 3 | 134027 | 331 | 6.190 | 21652.2 |
320 | 2022-04-10 23:44:19 | truants | 3 | 134027 | 331 | 6.186 | 21666.2 |
319 | 2022-04-10 05:38:22 | truants | 3 | 134027 | 331 | 11.533 | 11621.2 |
318 | 2022-04-09 18:24:48 | truants | 3 | 134027 | 331 | 7.110 | 18850.5 |
317 | 2022-04-09 00:42:56 | truants | 3 | 134027 | 331 | 5.783 | 23176.0 |
316 | 2022-04-08 17:21:04 | truants | 3 | 134027 | 331 | 6.953 | 19276.1 |
315 | 2022-04-07 19:57:19 | truants | 3 | 134027 | 331 | 8.846 | 15151.1 |
314 | 2022-04-06 17:07:24 | truants | 3 | 134027 | 331 | 7.486 | 17903.7 |