History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"postcodes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
463 | 2025-08-29 16:15:37 | postcodes | 1 | 81242 | 2 | 1.390 | 58447.5 |
462 | 2025-08-29 13:32:28 | postcodes | 1 | 81242 | 2 | 1.610 | 50460.9 |
461 | 2025-08-28 14:00:09 | postcodes | 1 | 81242 | 2 | 1.466 | 55417.5 |
460 | 2025-08-28 13:27:51 | postcodes | 1 | 81242 | 2 | 1.296 | 62686.7 |
459 | 2025-07-25 10:13:59 | postcodes | 1 | 81242 | 2 | 5.846 | 13897.0 |
458 | 2025-07-25 04:32:32 | postcodes | 1 | 81242 | 2 | 3.326 | 24426.3 |
457 | 2025-07-15 08:53:31 | postcodes | 1 | 81242 | 2 | 7.486 | 10852.5 |
456 | 2025-07-14 20:36:00 | postcodes | 1 | 81242 | 2 | 7.406 | 10969.8 |
455 | 2025-07-08 16:21:36 | postcodes | 1 | 81242 | 2 | 7.093 | 11453.8 |
454 | 2025-07-08 15:27:43 | postcodes | 1 | 81242 | 2 | 6.546 | 12410.9 |
453 | 2025-07-08 00:49:52 | postcodes | 3 | 148641 | 53 | 54.550 | 2724.9 |
452 | 2025-06-27 08:40:19 | postcodes | 1 | 81242 | 2 | 4.500 | 18053.8 |
451 | 2025-06-24 10:43:41 | postcodes | 1 | 81242 | 2 | 8.656 | 9385.6 |
450 | 2025-06-18 13:44:26 | postcodes | 1 | 81242 | 2 | 7.033 | 11551.5 |
449 | 2025-06-16 14:32:39 | postcodes | 1 | 81242 | 2 | 9.843 | 8253.8 |
448 | 2025-06-14 18:09:45 | postcodes | 1 | 81242 | 2 | 11.003 | 7383.6 |
447 | 2025-06-10 04:08:02 | postcodes | 1 | 81242 | 2 | 3.330 | 24397.0 |
446 | 2025-06-08 19:04:49 | postcodes | 3 | 148641 | 53 | 28.580 | 5200.9 |
445 | 2025-06-08 14:50:55 | postcodes | 1 | 81242 | 2 | 8.453 | 9611.0 |
444 | 2025-05-29 14:13:19 | postcodes | 1 | 81242 | 2 | 9.893 | 8212.1 |
443 | 2025-05-29 09:15:40 | postcodes | 1 | 81242 | 2 | 5.000 | 16248.4 |
442 | 2025-05-18 08:25:07 | postcodes | 3 | 148641 | 53 | 27.643 | 5377.2 |
441 | 2025-05-17 14:21:11 | postcodes | 1 | 81242 | 2 | 3.626 | 22405.4 |
440 | 2025-05-13 09:51:04 | postcodes | 1 | 81242 | 2 | 1.423 | 57092.1 |
439 | 2025-05-08 14:38:51 | postcodes | 1 | 81242 | 2 | 8.390 | 9683.2 |
438 | 2025-05-02 10:20:14 | postcodes | 1 | 81242 | 2 | 7.736 | 10501.8 |
437 | 2025-04-28 09:25:48 | postcodes | 1 | 81242 | 2 | 3.623 | 22424.0 |
436 | 2025-04-02 13:25:54 | postcodes | 1 | 81242 | 2 | 6.236 | 13027.9 |
435 | 2025-03-29 16:44:14 | postcodes | 1 | 81242 | 2 | 4.110 | 19766.9 |
434 | 2025-03-29 12:49:05 | postcodes | 1 | 81242 | 2 | 4.000 | 20310.5 |
433 | 2025-03-29 00:19:22 | postcodes | 3 | 148641 | 53 | 20.283 | 7328.4 |
432 | 2025-03-28 21:56:18 | postcodes | 4 | 165329 | 435 | 62.053 | 2664.3 |
431 | 2025-03-27 15:35:49 | postcodes | 1 | 81242 | 2 | 3.360 | 24179.2 |
430 | 2025-03-26 21:59:08 | postcodes | 4 | 165329 | 435 | 60.130 | 2749.5 |
429 | 2025-03-24 18:59:48 | postcodes | 4 | 165329 | 435 | 11.796 | 14015.7 |
428 | 2025-03-24 04:24:15 | postcodes | 2 | 121436 | 7 | 20.360 | 5964.4 |
427 | 2025-03-23 17:33:04 | postcodes | 3 | 148641 | 53 | 23.156 | 6419.1 |
426 | 2025-03-23 11:55:20 | postcodes | 1 | 81242 | 2 | 6.123 | 13268.3 |
425 | 2025-03-22 04:30:02 | postcodes | 1 | 81242 | 2 | 6.890 | 11791.3 |
424 | 2025-03-15 03:22:34 | postcodes | 1 | 81242 | 2 | 3.486 | 23305.2 |
423 | 2025-03-14 17:29:54 | postcodes | 1 | 81242 | 2 | 3.906 | 20799.3 |
422 | 2025-03-13 01:35:15 | postcodes | 3 | 148641 | 53 | 29.613 | 5019.5 |
421 | 2025-03-08 10:08:28 | postcodes | 3 | 148641 | 53 | 40.300 | 3688.4 |
420 | 2025-03-07 20:18:40 | postcodes | 3 | 148641 | 53 | 37.063 | 4010.5 |
419 | 2025-03-03 12:04:29 | postcodes | 3 | 148641 | 53 | 47.876 | 3104.7 |
418 | 2025-03-01 02:34:28 | postcodes | 3 | 148641 | 53 | 50.180 | 2962.2 |
417 | 2025-02-24 17:17:57 | postcodes | 1 | 81242 | 2 | 1.530 | 53099.3 |
416 | 2025-02-17 12:20:41 | postcodes | 2 | 121436 | 7 | 9.076 | 13379.9 |
415 | 2025-02-08 01:52:23 | postcodes | 1 | 81242 | 2 | 3.610 | 22504.7 |
414 | 2025-01-27 22:49:49 | postcodes | 1 | 81242 | 2 | 8.890 | 9138.6 |
413 | 2025-01-27 03:47:52 | postcodes | 1 | 81242 | 2 | 3.690 | 22016.8 |
412 | 2025-01-15 00:19:55 | postcodes | 1 | 81242 | 2 | 3.390 | 23965.2 |
411 | 2025-01-09 17:21:15 | postcodes | 2 | 121436 | 7 | 3.423 | 35476.5 |
410 | 2025-01-03 16:01:38 | postcodes | 1 | 81242 | 2 | 4.280 | 18981.8 |
409 | 2024-12-20 06:06:26 | postcodes | 2 | 121436 | 7 | 16.536 | 7343.7 |
408 | 2024-12-20 05:06:26 | postcodes | 1 | 81242 | 2 | 1.390 | 58447.5 |
407 | 2024-12-18 12:58:57 | postcodes | 3 | 148641 | 53 | 39.080 | 3803.5 |
406 | 2024-12-18 08:37:25 | postcodes | 3 | 148641 | 53 | 34.686 | 4285.3 |
405 | 2024-12-16 08:31:35 | postcodes | 3 | 148641 | 53 | 35.360 | 4203.6 |
404 | 2024-12-16 08:27:22 | postcodes | 3 | 148641 | 53 | 34.650 | 4289.8 |
403 | 2024-12-07 18:21:11 | postcodes | 1 | 81242 | 2 | 7.530 | 10789.1 |
402 | 2024-12-04 01:02:30 | postcodes | 3 | 148641 | 53 | 6.236 | 23836.0 |
401 | 2024-11-29 01:29:18 | postcodes | 2 | 121436 | 7 | 17.750 | 6841.5 |
400 | 2024-11-26 23:40:34 | postcodes | 2 | 121436 | 7 | 29.436 | 4125.4 |
399 | 2024-11-26 23:38:48 | postcodes | 1 | 81242 | 2 | 3.233 | 25129.0 |
398 | 2024-11-16 01:32:24 | postcodes | 3 | 148641 | 53 | 34.923 | 4256.2 |
397 | 2024-11-11 19:12:46 | postcodes | 4 | 165329 | 435 | 86.786 | 1905.0 |
396 | 2024-11-11 14:53:44 | postcodes | 4 | 165329 | 435 | 74.970 | 2205.3 |
395 | 2024-11-11 12:36:38 | postcodes | 3 | 148641 | 53 | 18.126 | 8200.4 |
394 | 2024-11-11 08:41:21 | postcodes | 4 | 165329 | 435 | 49.860 | 3315.9 |
393 | 2024-11-10 20:31:31 | postcodes | 4 | 165329 | 435 | 63.926 | 2586.3 |
392 | 2024-11-10 20:31:33 | postcodes | 3 | 148641 | 53 | 22.753 | 6532.8 |
391 | 2024-11-10 14:45:51 | postcodes | 1 | 81242 | 2 | 1.436 | 56575.2 |
390 | 2024-10-31 17:54:11 | postcodes | 1 | 81242 | 2 | 3.406 | 23852.6 |
389 | 2024-10-28 09:00:35 | postcodes | 1 | 81242 | 2 | 9.123 | 8905.2 |
388 | 2024-10-26 16:07:28 | postcodes | 1 | 81242 | 2 | 6.860 | 11842.9 |
387 | 2024-10-21 05:48:21 | postcodes | 1 | 81242 | 2 | 6.940 | 11706.3 |
386 | 2024-10-09 12:30:53 | postcodes | 1 | 81242 | 2 | 7.140 | 11378.4 |
385 | 2024-09-25 02:47:53 | postcodes | 1 | 81242 | 2 | 9.953 | 8162.6 |
384 | 2024-09-05 04:48:42 | postcodes | 1 | 81242 | 2 | 12.346 | 6580.4 |
383 | 2024-08-19 18:59:33 | postcodes | 1 | 81242 | 2 | 5.546 | 14648.8 |
382 | 2024-08-12 00:49:39 | postcodes | 1 | 81242 | 2 | 5.826 | 13944.7 |
381 | 2024-08-07 07:31:04 | postcodes | 1 | 81242 | 2 | 2.593 | 31331.3 |
380 | 2024-07-29 19:18:43 | postcodes | 1 | 81242 | 2 | 5.046 | 16100.3 |
379 | 2024-07-23 19:48:29 | postcodes | 2 | 121436 | 7 | 11.906 | 10199.6 |
378 | 2024-07-23 19:48:25 | postcodes | 1 | 81242 | 2 | 1.546 | 52549.8 |
377 | 2024-07-20 22:30:52 | postcodes | 2 | 121436 | 7 | 18.733 | 6482.5 |
376 | 2024-07-20 22:25:48 | postcodes | 1 | 81242 | 2 | 5.343 | 15205.3 |
375 | 2024-07-19 04:18:23 | postcodes | 4 | 165329 | 435 | 44.596 | 3707.3 |
374 | 2024-07-17 01:46:02 | postcodes | 1 | 81242 | 2 | 6.483 | 12531.5 |
373 | 2024-07-12 16:03:25 | postcodes | 2 | 121436 | 7 | 17.453 | 6957.9 |
372 | 2024-07-12 16:01:08 | postcodes | 1 | 81242 | 2 | 5.970 | 13608.4 |
371 | 2024-07-09 22:54:07 | postcodes | 4 | 165329 | 435 | 68.770 | 2404.1 |
370 | 2024-07-06 03:23:41 | postcodes | 1 | 81242 | 2 | 4.953 | 16402.6 |
369 | 2024-07-06 02:28:02 | postcodes | 4 | 165329 | 435 | 62.516 | 2644.6 |
368 | 2024-07-06 02:25:54 | postcodes | 1 | 81242 | 2 | 5.953 | 13647.2 |
367 | 2024-07-04 06:03:24 | postcodes | 3 | 148641 | 53 | 23.863 | 6228.9 |
366 | 2024-07-02 20:20:24 | postcodes | 3 | 148641 | 53 | 34.596 | 4296.5 |
365 | 2024-07-01 02:28:25 | postcodes | 4 | 165329 | 435 | 63.736 | 2594.0 |
364 | 2024-06-30 21:49:55 | postcodes | 4 | 165329 | 435 | 45.023 | 3672.1 |