History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"porters"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
446 | 2024-04-27 02:18:00 | porters | 1 | 69583 | 9 | 1.356 | 51314.9 |
445 | 2024-04-03 12:06:40 | porters | 1 | 69583 | 9 | 3.373 | 20629.4 |
444 | 2024-03-03 23:58:22 | porters | 1 | 69583 | 9 | 3.046 | 22844.1 |
443 | 2024-02-21 23:20:30 | porters | 1 | 69583 | 9 | 1.296 | 53690.6 |
442 | 2024-01-18 15:44:19 | porters | 2 | 107671 | 160 | 3.470 | 31029.1 |
441 | 2023-12-21 19:03:18 | porters | 1 | 69583 | 9 | 1.263 | 55093.4 |
440 | 2023-12-06 08:37:57 | porters | 1 | 69583 | 9 | 1.110 | 62687.4 |
439 | 2023-12-01 16:03:48 | porters | 1 | 69583 | 9 | 2.656 | 26198.4 |
438 | 2023-11-24 11:44:34 | porters | 1 | 69583 | 9 | 1.093 | 63662.4 |
437 | 2023-11-21 22:03:01 | porters | 1 | 69583 | 9 | 1.296 | 53690.6 |
436 | 2023-11-17 00:07:13 | porters | 1 | 69583 | 9 | 1.123 | 61961.7 |
435 | 2023-10-24 23:05:29 | porters | 1 | 69583 | 9 | 1.190 | 58473.1 |
434 | 2023-10-04 05:14:57 | porters | 1 | 69583 | 9 | 1.093 | 63662.4 |
433 | 2023-09-24 04:11:35 | porters | 1 | 69583 | 9 | 1.093 | 63662.4 |
432 | 2023-09-23 03:47:38 | porters | 1 | 69583 | 9 | 1.220 | 57035.2 |
431 | 2023-09-20 10:45:54 | porters | 1 | 69583 | 9 | 1.076 | 64668.2 |
430 | 2023-08-29 09:05:18 | porters | 1 | 69583 | 9 | 1.233 | 56433.9 |
429 | 2023-08-25 19:40:25 | porters | 1 | 69583 | 9 | 1.096 | 63488.1 |
428 | 2023-07-10 20:01:11 | porters | 1 | 69583 | 9 | 1.203 | 57841.2 |
427 | 2023-05-12 04:06:32 | porters | 1 | 69583 | 9 | 1.063 | 65459.1 |
426 | 2023-04-16 18:11:33 | porters | 1 | 69583 | 9 | 1.063 | 65459.1 |
425 | 2023-02-08 15:49:45 | porters | 1 | 69583 | 9 | 1.063 | 65459.1 |
424 | 2023-02-05 20:02:29 | porters | 1 | 69583 | 9 | 1.173 | 59320.5 |
423 | 2022-12-06 18:20:01 | porters | 1 | 69583 | 9 | 1.076 | 64668.2 |
422 | 2022-11-30 10:38:58 | porters | 1 | 69583 | 9 | 1.063 | 65459.1 |
421 | 2022-10-23 01:17:49 | porters | 1 | 69583 | 9 | 1.063 | 65459.1 |
420 | 2022-08-02 18:47:39 | porters | 1 | 69583 | 9 | 1.140 | 61037.7 |
419 | 2022-07-31 11:31:27 | porters | 1 | 69583 | 9 | 1.216 | 57222.9 |
418 | 2022-07-03 04:48:22 | porters | 1 | 69583 | 9 | 1.110 | 62687.4 |
417 | 2022-03-25 22:03:24 | porters | 1 | 69583 | 9 | 1.093 | 63662.4 |
416 | 2022-03-23 18:41:21 | porters | 1 | 69583 | 9 | 1.563 | 44518.9 |
415 | 2022-03-19 12:05:17 | porters | 1 | 69583 | 9 | 1.093 | 63662.4 |
414 | 2022-03-16 01:16:07 | porters | 1 | 69583 | 9 | 1.093 | 63662.4 |
413 | 2021-12-29 16:08:17 | porters | 1 | 69583 | 9 | 1.236 | 56296.9 |
412 | 2021-12-07 00:55:59 | porters | 1 | 69583 | 9 | 1.093 | 63662.4 |
411 | 2021-12-05 17:03:28 | porters | 1 | 69583 | 9 | 2.360 | 29484.3 |
410 | 2021-11-03 08:25:49 | porters | 1 | 69583 | 9 | 1.093 | 63662.4 |
409 | 2021-11-01 06:25:21 | porters | 1 | 69583 | 9 | 1.236 | 56296.9 |
408 | 2021-09-20 18:35:13 | porters | 1 | 69583 | 9 | 2.560 | 27180.9 |
407 | 2021-09-05 13:36:48 | porters | 1 | 69583 | 9 | 1.080 | 64428.7 |
406 | 2021-09-01 14:08:17 | porters | 1 | 69583 | 9 | 1.143 | 60877.5 |
405 | 2021-06-19 11:02:55 | porters | 1 | 69583 | 9 | 1.160 | 59985.3 |
404 | 2021-05-31 21:38:03 | porters | 1 | 69583 | 9 | 1.266 | 54962.9 |
403 | 2021-05-25 15:02:38 | porters | 1 | 69583 | 9 | 1.266 | 54962.9 |
402 | 2021-04-29 08:38:49 | porters | 1 | 69583 | 9 | 1.250 | 55666.4 |
401 | 2021-03-28 22:52:46 | porters | 1 | 69583 | 9 | 1.110 | 62687.4 |
400 | 2021-03-01 16:30:38 | porters | 1 | 69583 | 9 | 1.093 | 63662.4 |
399 | 2021-01-12 18:15:59 | porters | 1 | 69583 | 9 | 1.280 | 54361.7 |
398 | 2020-11-30 02:16:50 | porters | 1 | 69583 | 9 | 1.173 | 59320.5 |
397 | 2020-10-22 18:21:38 | porters | 1 | 69583 | 9 | 1.233 | 56433.9 |
396 | 2020-10-22 17:01:49 | porters | 1 | 69583 | 9 | 1.110 | 62687.4 |
395 | 2020-10-08 19:13:12 | porters | 1 | 69583 | 9 | 1.063 | 65459.1 |
394 | 2020-09-07 09:30:15 | porters | 1 | 69583 | 9 | 1.436 | 48456.1 |
393 | 2020-08-29 17:06:50 | porters | 1 | 69583 | 9 | 1.250 | 55666.4 |
392 | 2020-08-26 12:50:07 | porters | 1 | 69583 | 9 | 1.156 | 60192.9 |
391 | 2020-08-17 12:42:55 | porters | 1 | 69583 | 9 | 2.610 | 26660.2 |
390 | 2020-08-08 23:25:56 | porters | 1 | 69583 | 9 | 1.140 | 61037.7 |
389 | 2020-08-01 01:31:33 | porters | 1 | 69583 | 9 | 1.140 | 61037.7 |
388 | 2020-05-25 02:21:34 | porters | 1 | 69583 | 9 | 1.080 | 64428.7 |
387 | 2020-05-22 01:10:10 | porters | 1 | 69583 | 9 | 1.203 | 57841.2 |
386 | 2020-05-09 18:28:33 | porters | 1 | 69583 | 9 | 1.110 | 62687.4 |
385 | 2020-03-27 21:38:25 | porters | 1 | 69583 | 9 | 1.296 | 53690.6 |
384 | 2020-03-26 23:10:14 | porters | 1 | 69583 | 9 | 1.216 | 57222.9 |
383 | 2020-03-23 22:54:49 | porters | 1 | 69583 | 9 | 1.173 | 59320.5 |
382 | 2020-03-21 16:38:46 | porters | 1 | 69583 | 9 | 2.233 | 31161.2 |
381 | 2020-03-19 22:50:15 | porters | 1 | 69583 | 9 | 1.080 | 64428.7 |
380 | 2020-02-29 17:12:32 | porters | 1 | 69583 | 9 | 1.300 | 53525.4 |
379 | 2020-02-25 10:27:56 | porters | 1 | 69583 | 9 | 1.283 | 54234.6 |
378 | 2020-02-25 07:37:38 | porters | 1 | 69583 | 9 | 1.220 | 57035.2 |
377 | 2020-02-23 22:18:29 | porters | 1 | 69583 | 9 | 2.843 | 24475.2 |
376 | 2020-02-22 19:47:00 | porters | 1 | 69583 | 9 | 1.343 | 51811.6 |
375 | 2020-02-18 21:47:58 | porters | 1 | 69583 | 9 | 1.220 | 57035.2 |
374 | 2020-02-11 02:54:42 | porters | 1 | 69583 | 9 | 1.296 | 53690.6 |
373 | 2020-02-10 17:58:39 | porters | 1 | 69583 | 9 | 1.343 | 51811.6 |
372 | 2020-02-10 15:39:42 | porters | 1 | 69583 | 9 | 1.326 | 52475.9 |
371 | 2020-02-02 01:59:53 | porters | 1 | 69583 | 9 | 1.953 | 35628.8 |
370 | 2020-02-02 00:42:55 | porters | 1 | 69583 | 9 | 1.220 | 57035.2 |
369 | 2020-01-30 13:36:25 | porters | 1 | 69583 | 9 | 1.170 | 59472.6 |
368 | 2020-01-27 01:36:43 | porters | 1 | 69583 | 9 | 1.330 | 52318.0 |
367 | 2020-01-22 18:38:28 | porters | 1 | 69583 | 9 | 1.500 | 46388.7 |
366 | 2020-01-22 08:21:04 | porters | 1 | 69583 | 9 | 2.686 | 25905.8 |
365 | 2020-01-13 12:04:42 | porters | 1 | 69583 | 9 | 1.263 | 55093.4 |
364 | 2020-01-13 11:42:20 | porters | 1 | 69583 | 9 | 1.250 | 55666.4 |
363 | 2020-01-13 04:33:15 | porters | 1 | 69583 | 9 | 1.283 | 54234.6 |
362 | 2020-01-10 23:41:47 | porters | 1 | 69583 | 9 | 1.826 | 38106.8 |
361 | 2020-01-03 19:11:18 | porters | 1 | 69583 | 9 | 1.123 | 61961.7 |
360 | 2019-12-27 03:19:29 | porters | 1 | 69583 | 9 | 1.326 | 52475.9 |
359 | 2019-12-26 18:08:55 | porters | 1 | 69583 | 9 | 1.296 | 53690.6 |
358 | 2019-12-26 03:18:16 | porters | 1 | 69583 | 9 | 1.266 | 54962.9 |
357 | 2019-12-23 10:37:53 | porters | 1 | 69583 | 9 | 1.093 | 63662.4 |
356 | 2019-11-19 14:37:08 | porters | 1 | 69583 | 9 | 1.186 | 58670.3 |
355 | 2019-11-08 03:29:07 | porters | 1 | 69583 | 9 | 1.096 | 63488.1 |
354 | 2019-09-01 05:38:32 | porters | 1 | 69583 | 9 | 2.330 | 29863.9 |
353 | 2019-08-17 21:48:43 | porters | 1 | 69583 | 9 | 1.106 | 62914.1 |
352 | 2019-07-09 17:30:17 | porters | 1 | 69583 | 9 | 1.123 | 61961.7 |
351 | 2019-07-06 11:32:59 | porters | 1 | 69583 | 9 | 2.440 | 28517.6 |
350 | 2019-07-03 06:58:36 | porters | 1 | 69583 | 9 | 1.123 | 61961.7 |
349 | 2019-06-24 19:42:06 | porters | 1 | 69583 | 9 | 1.123 | 61961.7 |
348 | 2019-06-20 19:02:42 | porters | 1 | 69583 | 9 | 1.200 | 57985.8 |
347 | 2019-05-18 04:15:32 | porters | 1 | 69583 | 9 | 1.073 | 64849.0 |