History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"occupier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
470 | 2024-04-30 19:28:00 | occupier | 1 | 82945 | 4 | 1.440 | 57600.7 |
469 | 2024-04-30 16:15:17 | occupier | 3 | 146162 | 41 | 7.390 | 19778.3 |
468 | 2024-04-29 16:56:50 | occupier | 3 | 146162 | 41 | 7.203 | 20291.8 |
467 | 2024-04-29 15:02:13 | occupier | 1 | 82945 | 4 | 1.486 | 55817.6 |
466 | 2024-04-28 10:53:57 | occupier | 3 | 146162 | 41 | 20.860 | 7006.8 |
465 | 2024-04-28 02:54:58 | occupier | 1 | 82945 | 4 | 2.406 | 34474.2 |
464 | 2024-04-28 02:32:57 | occupier | 4 | 161609 | 503 | 25.113 | 6435.3 |
463 | 2024-04-28 02:32:54 | occupier | 2 | 121059 | 5 | 12.986 | 9322.3 |
462 | 2024-04-28 00:45:19 | occupier | 4 | 161609 | 503 | 27.266 | 5927.1 |
461 | 2024-04-27 11:23:28 | occupier | 1 | 82945 | 4 | 2.423 | 34232.4 |
460 | 2024-04-26 21:10:30 | occupier | 1 | 82945 | 4 | 3.233 | 25655.7 |
459 | 2024-04-26 16:25:12 | occupier | 1 | 82945 | 4 | 1.420 | 58412.0 |
458 | 2024-04-26 10:59:36 | occupier | 1 | 82945 | 4 | 1.640 | 50576.2 |
457 | 2024-04-25 13:38:21 | occupier | 1 | 82945 | 4 | 1.466 | 56579.1 |
456 | 2024-04-25 09:58:46 | occupier | 2 | 121059 | 5 | 3.623 | 33414.0 |
455 | 2024-04-25 02:48:38 | occupier | 1 | 82945 | 4 | 2.343 | 35401.2 |
454 | 2024-04-24 13:36:54 | occupier | 1 | 82945 | 4 | 4.766 | 17403.5 |
453 | 2024-04-24 01:20:24 | occupier | 1 | 82945 | 4 | 5.126 | 16181.2 |
452 | 2024-04-23 13:24:44 | occupier | 1 | 82945 | 4 | 1.470 | 56425.2 |
451 | 2024-04-22 18:59:52 | occupier | 1 | 82945 | 4 | 3.420 | 24252.9 |
450 | 2024-04-22 08:05:52 | occupier | 1 | 82945 | 4 | 4.626 | 17930.2 |
449 | 2024-04-21 18:55:31 | occupier | 1 | 82945 | 4 | 3.250 | 25521.5 |
448 | 2024-04-21 07:44:54 | occupier | 1 | 82945 | 4 | 4.940 | 16790.5 |
447 | 2024-04-20 19:06:08 | occupier | 1 | 82945 | 4 | 1.936 | 42843.5 |
446 | 2024-04-18 23:35:27 | occupier | 3 | 146162 | 41 | 25.860 | 5652.0 |
445 | 2024-04-18 23:35:25 | occupier | 2 | 121059 | 5 | 6.733 | 17979.9 |
444 | 2024-04-18 22:51:01 | occupier | 1 | 82945 | 4 | 1.453 | 57085.3 |
443 | 2024-04-18 22:48:42 | occupier | 1 | 82945 | 4 | 1.453 | 57085.3 |
442 | 2024-04-16 16:52:16 | occupier | 1 | 82945 | 4 | 1.876 | 44213.8 |
441 | 2024-04-15 16:38:22 | occupier | 1 | 82945 | 4 | 2.593 | 31988.0 |
440 | 2024-04-14 16:30:48 | occupier | 1 | 82945 | 4 | 1.670 | 49667.7 |
439 | 2024-04-14 07:07:18 | occupier | 1 | 82945 | 4 | 4.423 | 18753.1 |
438 | 2024-04-13 16:44:28 | occupier | 1 | 82945 | 4 | 1.453 | 57085.3 |
437 | 2024-04-08 14:28:43 | occupier | 1 | 82945 | 4 | 2.563 | 32362.5 |
436 | 2024-04-05 18:57:32 | occupier | 1 | 82945 | 4 | 3.406 | 24352.6 |
435 | 2024-04-05 18:55:44 | occupier | 3 | 146162 | 41 | 16.533 | 8840.6 |
434 | 2024-04-05 18:55:44 | occupier | 2 | 121059 | 5 | 7.376 | 16412.6 |
433 | 2024-04-04 23:59:07 | occupier | 1 | 82945 | 4 | 1.873 | 44284.6 |
432 | 2024-04-04 03:20:40 | occupier | 1 | 82945 | 4 | 1.906 | 43517.8 |
431 | 2024-04-03 11:35:33 | occupier | 4 | 161609 | 503 | 20.470 | 7894.9 |
430 | 2024-04-03 02:41:20 | occupier | 1 | 82945 | 4 | 1.593 | 52068.4 |
429 | 2024-04-02 22:25:25 | occupier | 1 | 82945 | 4 | 3.266 | 25396.5 |
428 | 2024-04-01 20:11:53 | occupier | 1 | 82945 | 4 | 5.033 | 16480.2 |
427 | 2024-04-01 09:39:25 | occupier | 1 | 82945 | 4 | 3.220 | 25759.3 |
426 | 2024-04-01 09:38:19 | occupier | 3 | 146162 | 41 | 21.720 | 6729.4 |
425 | 2024-03-31 21:50:08 | occupier | 1 | 82945 | 4 | 1.406 | 58993.6 |
424 | 2024-03-31 19:00:57 | occupier | 4 | 161609 | 503 | 28.876 | 5596.7 |
423 | 2024-03-30 17:56:43 | occupier | 1 | 82945 | 4 | 1.706 | 48619.6 |
422 | 2024-03-30 03:41:42 | occupier | 4 | 161609 | 503 | 27.440 | 5889.5 |
421 | 2024-03-28 18:39:55 | occupier | 4 | 161609 | 503 | 29.736 | 5434.8 |
420 | 2024-03-28 09:34:17 | occupier | 1 | 82945 | 4 | 1.546 | 53651.4 |
419 | 2024-03-28 09:33:49 | occupier | 4 | 161609 | 503 | 12.550 | 12877.2 |
418 | 2024-03-28 09:33:51 | occupier | 3 | 146162 | 41 | 7.453 | 19611.2 |
417 | 2024-03-28 09:33:41 | occupier | 2 | 121059 | 5 | 6.860 | 17647.1 |
416 | 2024-03-26 12:33:54 | occupier | 1 | 82945 | 4 | 3.096 | 26791.0 |
415 | 2024-03-26 01:44:04 | occupier | 1 | 82945 | 4 | 5.016 | 16536.1 |
414 | 2024-03-25 10:13:16 | occupier | 1 | 82945 | 4 | 1.483 | 55930.5 |
413 | 2024-03-24 20:37:29 | occupier | 1 | 82945 | 4 | 1.310 | 63316.8 |
412 | 2024-03-23 20:53:51 | occupier | 1 | 82945 | 4 | 1.266 | 65517.4 |
411 | 2024-03-22 20:39:19 | occupier | 1 | 82945 | 4 | 1.610 | 51518.6 |
410 | 2024-03-22 06:29:29 | occupier | 2 | 121059 | 5 | 3.373 | 35890.6 |
409 | 2024-03-22 05:38:30 | occupier | 1 | 82945 | 4 | 3.326 | 24938.4 |
408 | 2024-03-21 15:58:25 | occupier | 1 | 82945 | 4 | 3.546 | 23391.1 |
407 | 2024-03-21 05:17:40 | occupier | 1 | 82945 | 4 | 3.750 | 22118.7 |
406 | 2024-03-20 15:34:30 | occupier | 1 | 82945 | 4 | 1.420 | 58412.0 |
405 | 2024-03-20 05:19:23 | occupier | 1 | 82945 | 4 | 1.486 | 55817.6 |
404 | 2024-03-18 17:12:32 | occupier | 1 | 82945 | 4 | 1.470 | 56425.2 |
403 | 2024-03-18 14:14:17 | occupier | 2 | 121059 | 5 | 7.720 | 15681.2 |
402 | 2024-03-17 07:04:12 | occupier | 1 | 82945 | 4 | 1.280 | 64800.8 |
401 | 2024-03-16 21:02:15 | occupier | 1 | 82945 | 4 | 1.500 | 55296.7 |
400 | 2024-03-16 09:33:06 | occupier | 1 | 82945 | 4 | 1.310 | 63316.8 |
399 | 2024-03-15 21:00:49 | occupier | 1 | 82945 | 4 | 1.453 | 57085.3 |
398 | 2024-03-14 15:45:58 | occupier | 1 | 82945 | 4 | 1.530 | 54212.4 |
397 | 2024-03-13 15:48:50 | occupier | 1 | 82945 | 4 | 2.483 | 33405.2 |
396 | 2024-03-12 15:10:07 | occupier | 1 | 82945 | 4 | 1.440 | 57600.7 |
395 | 2024-03-11 20:04:27 | occupier | 1 | 82945 | 4 | 2.126 | 39014.6 |
394 | 2024-03-11 16:42:04 | occupier | 1 | 82945 | 4 | 1.640 | 50576.2 |
393 | 2024-03-10 22:02:34 | occupier | 1 | 82945 | 4 | 1.420 | 58412.0 |
392 | 2024-03-10 17:58:58 | occupier | 1 | 82945 | 4 | 3.873 | 21416.2 |
391 | 2024-03-09 19:34:43 | occupier | 1 | 82945 | 4 | 1.906 | 43517.8 |
390 | 2024-03-08 03:46:41 | occupier | 2 | 121059 | 5 | 7.280 | 16629.0 |
389 | 2024-03-08 03:46:44 | occupier | 1 | 82945 | 4 | 1.563 | 53067.8 |
388 | 2024-03-07 17:06:38 | occupier | 1 | 82945 | 4 | 1.436 | 57761.1 |
387 | 2024-03-07 08:09:26 | occupier | 1 | 82945 | 4 | 1.640 | 50576.2 |
386 | 2024-03-06 17:15:00 | occupier | 1 | 82945 | 4 | 1.673 | 49578.6 |
385 | 2024-03-06 15:46:11 | occupier | 1 | 82945 | 4 | 3.266 | 25396.5 |
384 | 2024-03-06 15:45:36 | occupier | 2 | 121059 | 5 | 6.110 | 19813.3 |
383 | 2024-03-06 15:42:15 | occupier | 1 | 82945 | 4 | 1.640 | 50576.2 |
382 | 2024-03-06 15:03:40 | occupier | 3 | 146162 | 41 | 8.890 | 16441.2 |
381 | 2024-03-06 07:37:53 | occupier | 1 | 82945 | 4 | 3.250 | 25521.5 |
380 | 2024-03-05 17:06:26 | occupier | 1 | 82945 | 4 | 1.580 | 52496.8 |
379 | 2024-03-05 10:59:21 | occupier | 1 | 82945 | 4 | 1.483 | 55930.5 |
378 | 2024-03-04 22:12:44 | occupier | 1 | 82945 | 4 | 4.783 | 17341.6 |
377 | 2024-03-04 21:19:32 | occupier | 1 | 82945 | 4 | 1.953 | 42470.6 |
376 | 2024-03-04 09:31:34 | occupier | 1 | 82945 | 4 | 4.313 | 19231.4 |
375 | 2024-03-04 08:12:49 | occupier | 3 | 146162 | 41 | 12.733 | 11479.0 |
374 | 2024-03-04 08:04:10 | occupier | 4 | 161609 | 503 | 28.723 | 5626.5 |
373 | 2024-03-03 21:56:46 | occupier | 1 | 82945 | 4 | 1.296 | 64000.8 |
372 | 2024-03-03 21:17:38 | occupier | 1 | 82945 | 4 | 1.546 | 53651.4 |
371 | 2024-03-03 00:32:44 | occupier | 1 | 82945 | 4 | 1.453 | 57085.3 |