History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"centres"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
452 | 2024-04-20 22:31:22 | centres | 3 | 134027 | 654 | 17.816 | 7522.8 |
451 | 2024-04-19 10:09:44 | centres | 3 | 134027 | 654 | 19.050 | 7035.5 |
450 | 2024-04-18 23:26:48 | centres | 3 | 134027 | 654 | 8.873 | 15105.0 |
449 | 2024-04-11 06:35:24 | centres | 3 | 134027 | 654 | 7.626 | 17575.0 |
448 | 2024-03-31 16:30:26 | centres | 3 | 134027 | 654 | 12.486 | 10734.2 |
447 | 2024-03-31 13:48:02 | centres | 1 | 69583 | 5 | 3.800 | 18311.3 |
446 | 2024-03-22 10:59:40 | centres | 2 | 107671 | 69 | 3.563 | 30219.2 |
445 | 2024-03-22 10:59:30 | centres | 3 | 134027 | 654 | 7.500 | 17870.3 |
444 | 2024-03-22 06:43:05 | centres | 2 | 107671 | 69 | 7.310 | 14729.3 |
443 | 2024-03-21 19:46:15 | centres | 2 | 107671 | 69 | 5.093 | 21141.0 |
442 | 2024-03-21 19:45:00 | centres | 3 | 134027 | 654 | 7.093 | 18895.7 |
441 | 2024-03-20 23:16:54 | centres | 3 | 134027 | 654 | 8.750 | 15317.4 |
440 | 2024-03-20 19:06:25 | centres | 3 | 134027 | 654 | 15.250 | 8788.7 |
439 | 2024-03-19 15:43:23 | centres | 3 | 134027 | 654 | 20.206 | 6633.0 |
438 | 2024-03-19 03:48:22 | centres | 3 | 134027 | 654 | 9.110 | 14712.1 |
437 | 2024-03-07 14:18:43 | centres | 1 | 69583 | 5 | 1.310 | 53116.8 |
436 | 2024-02-05 18:09:45 | centres | 2 | 107671 | 69 | 3.393 | 31733.3 |
435 | 2024-02-05 18:09:01 | centres | 3 | 134027 | 654 | 7.080 | 18930.4 |
434 | 2024-02-05 14:33:23 | centres | 3 | 134027 | 654 | 10.953 | 12236.6 |
433 | 2024-02-05 00:29:27 | centres | 3 | 134027 | 654 | 10.483 | 12785.2 |
432 | 2024-01-28 23:13:22 | centres | 3 | 134027 | 654 | 12.050 | 11122.6 |
431 | 2024-01-21 17:28:18 | centres | 1 | 69583 | 5 | 2.283 | 30478.8 |
430 | 2024-01-17 07:56:07 | centres | 3 | 134027 | 654 | 6.970 | 19229.1 |
429 | 2024-01-17 07:56:09 | centres | 2 | 107671 | 69 | 3.420 | 31482.7 |
428 | 2024-01-06 10:37:37 | centres | 3 | 134027 | 654 | 6.360 | 21073.4 |
427 | 2024-01-06 10:37:36 | centres | 2 | 107671 | 69 | 3.203 | 33615.7 |
426 | 2024-01-03 12:22:31 | centres | 2 | 107671 | 69 | 3.580 | 30075.7 |
425 | 2023-12-13 15:08:06 | centres | 1 | 69583 | 5 | 1.296 | 53690.6 |
424 | 2023-12-10 19:18:34 | centres | 3 | 134027 | 654 | 8.436 | 15887.5 |
423 | 2023-12-09 13:36:09 | centres | 3 | 134027 | 654 | 7.186 | 18651.1 |
422 | 2023-12-09 13:36:10 | centres | 2 | 107671 | 69 | 3.436 | 31336.1 |
421 | 2023-11-16 23:03:42 | centres | 1 | 69583 | 5 | 1.266 | 54962.9 |
420 | 2023-11-11 07:14:12 | centres | 1 | 69583 | 5 | 1.203 | 57841.2 |
419 | 2023-11-02 02:54:33 | centres | 3 | 134027 | 654 | 6.966 | 19240.2 |
418 | 2023-11-02 02:54:33 | centres | 2 | 107671 | 69 | 3.530 | 30501.7 |
417 | 2023-11-02 00:43:52 | centres | 1 | 69583 | 5 | 1.890 | 36816.4 |
416 | 2023-10-31 13:46:06 | centres | 1 | 69583 | 5 | 1.233 | 56433.9 |
415 | 2023-10-24 07:44:51 | centres | 1 | 69583 | 5 | 1.216 | 57222.9 |
414 | 2023-10-19 05:31:58 | centres | 1 | 69583 | 5 | 1.123 | 61961.7 |
413 | 2023-10-15 03:17:28 | centres | 1 | 69583 | 5 | 1.143 | 60877.5 |
412 | 2023-10-07 10:52:46 | centres | 2 | 107671 | 69 | 3.046 | 35348.3 |
411 | 2023-10-07 06:52:59 | centres | 1 | 69583 | 5 | 1.203 | 57841.2 |
410 | 2023-09-28 14:24:22 | centres | 1 | 69583 | 5 | 1.360 | 51164.0 |
409 | 2023-09-27 18:31:32 | centres | 3 | 134027 | 654 | 8.190 | 16364.7 |
408 | 2023-09-25 16:30:17 | centres | 1 | 69583 | 5 | 1.126 | 61796.6 |
407 | 2023-09-23 08:09:13 | centres | 1 | 69583 | 5 | 1.063 | 65459.1 |
406 | 2023-09-11 18:42:02 | centres | 3 | 134027 | 654 | 7.123 | 18816.1 |
405 | 2023-09-10 04:17:46 | centres | 3 | 134027 | 654 | 5.813 | 23056.4 |
404 | 2023-07-18 10:41:28 | centres | 2 | 107671 | 69 | 2.890 | 37256.4 |
403 | 2023-07-15 02:21:29 | centres | 3 | 134027 | 654 | 7.923 | 16916.2 |
402 | 2023-06-30 22:15:11 | centres | 1 | 69583 | 5 | 1.190 | 58473.1 |
401 | 2023-06-02 08:34:55 | centres | 3 | 134027 | 654 | 5.810 | 23068.3 |
400 | 2023-03-30 18:01:17 | centres | 2 | 107671 | 69 | 3.313 | 32499.5 |
399 | 2023-03-28 04:42:40 | centres | 1 | 69583 | 5 | 1.220 | 57035.2 |
398 | 2023-03-08 04:30:12 | centres | 3 | 134027 | 654 | 5.800 | 23108.1 |
397 | 2022-12-29 04:28:56 | centres | 2 | 107671 | 69 | 2.830 | 38046.3 |
396 | 2022-12-23 00:49:36 | centres | 1 | 69583 | 5 | 1.060 | 65644.3 |
395 | 2022-12-14 10:43:54 | centres | 3 | 134027 | 654 | 7.190 | 18640.8 |
394 | 2022-12-08 08:13:49 | centres | 3 | 134027 | 654 | 6.733 | 19906.0 |
393 | 2022-11-03 04:20:36 | centres | 3 | 134027 | 654 | 6.546 | 20474.6 |
392 | 2022-10-28 12:28:48 | centres | 3 | 134027 | 654 | 10.376 | 12917.0 |
391 | 2022-09-29 08:36:57 | centres | 3 | 134027 | 654 | 5.890 | 22755.0 |
390 | 2022-09-25 21:20:33 | centres | 1 | 69583 | 5 | 1.110 | 62687.4 |
389 | 2022-09-12 09:15:19 | centres | 1 | 69583 | 5 | 1.203 | 57841.2 |
388 | 2022-09-04 17:00:44 | centres | 3 | 134027 | 654 | 5.873 | 22820.9 |
387 | 2022-08-29 16:10:09 | centres | 2 | 107671 | 69 | 2.890 | 37256.4 |
386 | 2022-08-28 11:31:59 | centres | 1 | 69583 | 5 | 1.266 | 54962.9 |
385 | 2022-08-16 12:24:03 | centres | 3 | 134027 | 654 | 6.156 | 21771.8 |
384 | 2022-08-05 15:15:11 | centres | 3 | 134027 | 654 | 5.843 | 22938.0 |
383 | 2022-08-03 07:12:00 | centres | 3 | 134027 | 654 | 6.140 | 21828.5 |
382 | 2022-06-01 00:04:20 | centres | 3 | 134027 | 654 | 5.876 | 22809.2 |
381 | 2022-05-30 15:52:41 | centres | 1 | 69583 | 5 | 1.093 | 63662.4 |
380 | 2022-05-27 10:19:38 | centres | 1 | 69583 | 5 | 1.096 | 63488.1 |
379 | 2022-05-08 10:29:41 | centres | 1 | 69583 | 5 | 1.080 | 64428.7 |
378 | 2022-05-02 02:32:11 | centres | 3 | 134027 | 654 | 6.233 | 21502.8 |
377 | 2022-03-28 18:10:17 | centres | 2 | 107671 | 69 | 3.716 | 28975.0 |
376 | 2022-03-06 23:32:17 | centres | 3 | 134027 | 654 | 5.890 | 22755.0 |
375 | 2022-02-16 01:29:18 | centres | 1 | 69583 | 5 | 1.110 | 62687.4 |
374 | 2022-01-27 09:47:48 | centres | 1 | 69583 | 5 | 1.170 | 59472.6 |
373 | 2021-12-11 10:09:32 | centres | 2 | 107671 | 69 | 3.106 | 34665.5 |
372 | 2021-11-26 23:18:42 | centres | 1 | 69583 | 5 | 1.266 | 54962.9 |
371 | 2021-11-14 17:50:58 | centres | 1 | 69583 | 5 | 2.406 | 28920.6 |
370 | 2021-10-14 16:52:53 | centres | 1 | 69583 | 5 | 2.546 | 27330.3 |
369 | 2021-09-25 19:48:22 | centres | 1 | 69583 | 5 | 1.250 | 55666.4 |
368 | 2021-09-23 16:28:34 | centres | 1 | 69583 | 5 | 2.046 | 34009.3 |
367 | 2021-08-15 04:37:22 | centres | 1 | 69583 | 5 | 1.080 | 64428.7 |
366 | 2021-07-26 03:04:22 | centres | 3 | 134027 | 654 | 5.923 | 22628.2 |
365 | 2021-06-22 16:42:07 | centres | 3 | 134027 | 654 | 6.310 | 21240.4 |
364 | 2021-06-10 07:41:21 | centres | 3 | 134027 | 654 | 6.703 | 19995.1 |
363 | 2021-06-07 03:46:46 | centres | 1 | 69583 | 5 | 1.313 | 52995.4 |
362 | 2021-06-05 09:34:18 | centres | 1 | 69583 | 5 | 1.250 | 55666.4 |
361 | 2021-06-04 06:26:38 | centres | 3 | 134027 | 654 | 11.656 | 11498.5 |
360 | 2021-05-18 06:54:26 | centres | 3 | 134027 | 654 | 6.686 | 20045.9 |
359 | 2021-05-14 13:05:59 | centres | 1 | 69583 | 5 | 1.236 | 56296.9 |
358 | 2021-05-11 09:09:40 | centres | 1 | 69583 | 5 | 1.326 | 52475.9 |
357 | 2021-05-09 09:24:48 | centres | 3 | 134027 | 654 | 7.250 | 18486.5 |
356 | 2021-05-07 12:23:49 | centres | 3 | 134027 | 654 | 6.796 | 19721.5 |
355 | 2021-05-05 09:59:20 | centres | 1 | 69583 | 5 | 1.280 | 54361.7 |
354 | 2021-05-05 06:46:12 | centres | 3 | 134027 | 654 | 7.156 | 18729.3 |
353 | 2021-04-16 14:25:54 | centres | 3 | 134027 | 654 | 7.046 | 19021.7 |