History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trucking"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
410 | 2024-04-19 07:03:06 | trucking | 1 | 82945 | 9 | 1.643 | 50483.9 |
409 | 2024-04-05 10:13:08 | trucking | 3 | 146162 | 379 | 10.266 | 14237.5 |
408 | 2024-04-04 21:56:30 | trucking | 1 | 82945 | 9 | 2.076 | 39954.2 |
407 | 2024-03-31 18:49:35 | trucking | 3 | 146162 | 379 | 8.020 | 18224.7 |
406 | 2024-03-31 08:26:16 | trucking | 2 | 121059 | 59 | 3.656 | 33112.4 |
405 | 2024-03-31 08:26:16 | trucking | 1 | 82945 | 9 | 1.420 | 58412.0 |
404 | 2024-03-31 08:25:49 | trucking | 3 | 146162 | 379 | 8.296 | 17618.4 |
403 | 2024-03-31 05:58:49 | trucking | 3 | 146162 | 379 | 22.780 | 6416.2 |
402 | 2024-03-31 05:58:49 | trucking | 2 | 121059 | 59 | 11.546 | 10484.9 |
401 | 2024-03-29 23:42:17 | trucking | 1 | 82945 | 9 | 6.236 | 13301.0 |
400 | 2024-03-29 20:16:59 | trucking | 1 | 82945 | 9 | 1.873 | 44284.6 |
399 | 2024-03-01 13:15:32 | trucking | 1 | 82945 | 9 | 1.596 | 51970.6 |
398 | 2024-02-28 12:04:52 | trucking | 1 | 82945 | 9 | 1.516 | 54713.1 |
397 | 2024-01-29 11:26:54 | trucking | 1 | 82945 | 9 | 1.530 | 54212.4 |
396 | 2023-12-29 04:57:18 | trucking | 1 | 82945 | 9 | 1.263 | 65673.0 |
395 | 2023-12-26 23:49:19 | trucking | 3 | 146162 | 379 | 7.360 | 19859.0 |
394 | 2023-12-25 06:09:00 | trucking | 1 | 82945 | 9 | 1.296 | 64000.8 |
393 | 2023-11-20 16:45:55 | trucking | 1 | 82945 | 9 | 1.263 | 65673.0 |
392 | 2023-11-18 14:41:30 | trucking | 1 | 82945 | 9 | 1.403 | 59119.7 |
391 | 2023-11-02 21:47:46 | trucking | 1 | 82945 | 9 | 2.983 | 27805.9 |
390 | 2023-10-12 18:51:43 | trucking | 1 | 82945 | 9 | 1.280 | 64800.8 |
389 | 2023-10-10 12:46:51 | trucking | 3 | 146162 | 379 | 7.346 | 19896.8 |
388 | 2023-10-06 20:53:02 | trucking | 1 | 82945 | 9 | 1.486 | 55817.6 |
387 | 2023-10-06 20:40:09 | trucking | 3 | 146162 | 379 | 8.826 | 16560.4 |
386 | 2023-10-06 04:18:41 | trucking | 1 | 82945 | 9 | 3.296 | 25165.4 |
385 | 2023-10-01 23:47:18 | trucking | 1 | 82945 | 9 | 2.780 | 29836.3 |
384 | 2023-10-01 07:55:27 | trucking | 3 | 146162 | 379 | 7.546 | 19369.5 |
383 | 2023-09-28 06:53:32 | trucking | 3 | 146162 | 379 | 6.266 | 23326.2 |
382 | 2023-08-19 00:45:22 | trucking | 3 | 146162 | 379 | 7.003 | 20871.3 |
381 | 2023-08-08 03:04:45 | trucking | 1 | 82945 | 9 | 1.283 | 64649.3 |
380 | 2023-07-18 02:12:33 | trucking | 1 | 82945 | 9 | 1.393 | 59544.1 |
379 | 2023-07-08 22:18:46 | trucking | 3 | 146162 | 379 | 6.140 | 23804.9 |
378 | 2023-06-09 10:10:04 | trucking | 1 | 82945 | 9 | 1.250 | 66356.0 |
377 | 2023-06-06 18:17:29 | trucking | 3 | 146162 | 379 | 7.000 | 20880.3 |
376 | 2023-06-05 11:15:47 | trucking | 3 | 146162 | 379 | 6.123 | 23871.0 |
375 | 2023-06-01 11:44:37 | trucking | 3 | 146162 | 379 | 6.860 | 21306.4 |
374 | 2023-05-28 20:45:03 | trucking | 3 | 146162 | 379 | 7.360 | 19859.0 |
373 | 2023-05-27 20:09:36 | trucking | 3 | 146162 | 379 | 7.890 | 18525.0 |
372 | 2023-05-04 18:30:57 | trucking | 1 | 82945 | 9 | 1.343 | 61761.0 |
371 | 2023-04-21 00:29:04 | trucking | 1 | 82945 | 9 | 1.483 | 55930.5 |
370 | 2023-03-31 09:46:52 | trucking | 3 | 146162 | 379 | 7.390 | 19778.3 |
369 | 2023-03-25 22:55:04 | trucking | 1 | 82945 | 9 | 1.483 | 55930.5 |
368 | 2023-02-26 20:37:21 | trucking | 1 | 82945 | 9 | 1.390 | 59672.7 |
367 | 2023-02-11 02:41:06 | trucking | 1 | 82945 | 9 | 1.266 | 65517.4 |
366 | 2022-12-28 11:16:26 | trucking | 3 | 146162 | 379 | 12.300 | 11883.1 |
365 | 2022-12-25 07:54:49 | trucking | 1 | 82945 | 9 | 2.470 | 33581.0 |
364 | 2022-11-05 09:18:49 | trucking | 3 | 146162 | 379 | 6.830 | 21400.0 |
363 | 2022-11-04 04:37:45 | trucking | 3 | 146162 | 379 | 7.906 | 18487.5 |
362 | 2022-11-03 14:32:03 | trucking | 3 | 146162 | 379 | 7.110 | 20557.2 |
361 | 2022-11-02 14:43:31 | trucking | 3 | 146162 | 379 | 8.080 | 18089.4 |
360 | 2022-11-01 17:04:44 | trucking | 3 | 146162 | 379 | 8.000 | 18270.3 |
359 | 2022-10-31 12:51:27 | trucking | 3 | 146162 | 379 | 7.950 | 18385.2 |
358 | 2022-10-06 09:43:25 | trucking | 1 | 82945 | 9 | 1.343 | 61761.0 |
357 | 2022-09-11 01:21:55 | trucking | 1 | 82945 | 9 | 1.376 | 60279.8 |
356 | 2022-09-08 23:21:55 | trucking | 1 | 82945 | 9 | 1.266 | 65517.4 |
355 | 2022-08-30 14:14:03 | trucking | 3 | 146162 | 379 | 6.313 | 23152.5 |
354 | 2022-07-14 09:55:19 | trucking | 3 | 146162 | 379 | 6.140 | 23804.9 |
353 | 2022-06-17 10:12:53 | trucking | 3 | 146162 | 379 | 6.296 | 23215.1 |
352 | 2022-06-08 14:02:34 | trucking | 1 | 82945 | 9 | 1.233 | 67270.9 |
351 | 2022-04-15 20:50:46 | trucking | 1 | 82945 | 9 | 1.440 | 57600.7 |
350 | 2022-02-04 06:44:38 | trucking | 1 | 82945 | 9 | 1.263 | 65673.0 |
349 | 2022-01-09 10:28:37 | trucking | 1 | 82945 | 9 | 1.563 | 53067.8 |
348 | 2021-11-09 12:30:19 | trucking | 1 | 82945 | 9 | 2.423 | 34232.4 |
347 | 2021-11-07 13:26:52 | trucking | 1 | 82945 | 9 | 1.483 | 55930.5 |
346 | 2021-10-24 14:52:54 | trucking | 1 | 82945 | 9 | 1.263 | 65673.0 |
345 | 2021-09-27 01:28:21 | trucking | 3 | 146162 | 379 | 6.906 | 21164.5 |
344 | 2021-09-26 14:27:30 | trucking | 3 | 146162 | 379 | 6.813 | 21453.4 |
343 | 2021-09-25 21:12:51 | trucking | 3 | 146162 | 379 | 6.266 | 23326.2 |
342 | 2021-09-25 13:55:31 | trucking | 3 | 146162 | 379 | 9.376 | 15589.0 |
341 | 2021-09-24 13:13:09 | trucking | 3 | 146162 | 379 | 6.080 | 24039.8 |
340 | 2021-09-24 02:16:01 | trucking | 3 | 146162 | 379 | 6.220 | 23498.7 |
339 | 2021-09-23 14:59:06 | trucking | 3 | 146162 | 379 | 7.140 | 20470.9 |
338 | 2021-09-23 07:38:38 | trucking | 3 | 146162 | 379 | 8.326 | 17554.9 |
337 | 2021-09-22 12:48:38 | trucking | 3 | 146162 | 379 | 7.326 | 19951.1 |
336 | 2021-09-21 21:30:41 | trucking | 3 | 146162 | 379 | 13.843 | 10558.5 |
335 | 2021-09-21 09:17:12 | trucking | 3 | 146162 | 379 | 7.220 | 20244.0 |
334 | 2021-09-20 20:45:51 | trucking | 3 | 146162 | 379 | 6.203 | 23563.1 |
333 | 2021-09-20 19:58:15 | trucking | 1 | 82945 | 9 | 1.483 | 55930.5 |
332 | 2021-09-20 10:25:08 | trucking | 3 | 146162 | 379 | 7.343 | 19904.9 |
331 | 2021-09-19 12:29:58 | trucking | 3 | 146162 | 379 | 6.436 | 22710.1 |
330 | 2021-09-05 21:44:46 | trucking | 3 | 146162 | 379 | 6.080 | 24039.8 |
329 | 2021-09-03 18:35:26 | trucking | 3 | 146162 | 379 | 7.216 | 20255.3 |
328 | 2021-09-01 04:53:17 | trucking | 1 | 82945 | 9 | 1.280 | 64800.8 |
327 | 2021-07-13 21:54:16 | trucking | 1 | 82945 | 9 | 1.266 | 65517.4 |
326 | 2021-05-26 09:38:22 | trucking | 1 | 82945 | 9 | 1.516 | 54713.1 |
325 | 2021-05-26 09:30:01 | trucking | 1 | 82945 | 9 | 1.263 | 65673.0 |
324 | 2021-05-10 20:49:42 | trucking | 3 | 146162 | 379 | 6.250 | 23385.9 |
323 | 2021-04-30 10:43:16 | trucking | 1 | 82945 | 9 | 1.420 | 58412.0 |
322 | 2021-04-10 14:44:06 | trucking | 1 | 82945 | 9 | 1.436 | 57761.1 |
321 | 2021-03-29 20:57:56 | trucking | 1 | 82945 | 9 | 1.280 | 64800.8 |
320 | 2021-02-25 08:09:50 | trucking | 1 | 82945 | 9 | 1.300 | 63803.8 |
319 | 2021-01-24 06:07:38 | trucking | 3 | 146162 | 379 | 6.203 | 23563.1 |
318 | 2021-01-13 12:44:12 | trucking | 1 | 82945 | 9 | 2.796 | 29665.6 |
317 | 2020-12-28 11:24:18 | trucking | 1 | 82945 | 9 | 1.280 | 64800.8 |
316 | 2020-12-21 08:20:12 | trucking | 2 | 121059 | 59 | 3.250 | 37248.9 |
315 | 2020-11-28 23:26:23 | trucking | 3 | 146162 | 379 | 6.313 | 23152.5 |
314 | 2020-11-06 00:05:44 | trucking | 3 | 146162 | 379 | 6.436 | 22710.1 |
313 | 2020-11-05 13:28:55 | trucking | 1 | 82945 | 9 | 1.376 | 60279.8 |
312 | 2020-11-03 07:32:35 | trucking | 1 | 82945 | 9 | 1.546 | 53651.4 |
311 | 2020-10-31 19:14:41 | trucking | 1 | 82945 | 9 | 1.406 | 58993.6 |