History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oldies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1111 | 2024-04-27 13:06:48 | oldies | 3 | 112716 | 1066 | 6.313 | 17854.6 |
| 1110 | 2024-04-23 03:52:15 | oldies | 3 | 112716 | 1066 | 16.970 | 6642.1 |
| 1109 | 2024-04-10 11:59:48 | oldies | 1 | 48755 | 2 | 1.046 | 46610.9 |
| 1108 | 2024-04-08 14:02:43 | oldies | 1 | 48755 | 2 | 0.830 | 58741.0 |
| 1107 | 2024-03-30 20:01:48 | oldies | 3 | 112716 | 1066 | 11.563 | 9748.0 |
| 1106 | 2024-03-30 12:29:30 | oldies | 3 | 112716 | 1066 | 5.813 | 19390.3 |
| 1105 | 2024-03-29 09:01:58 | oldies | 2 | 82551 | 76 | 3.546 | 23280.0 |
| 1104 | 2024-03-29 02:59:55 | oldies | 2 | 82551 | 76 | 2.796 | 29524.7 |
| 1103 | 2024-03-29 02:59:55 | oldies | 1 | 48755 | 2 | 0.970 | 50262.9 |
| 1102 | 2024-03-29 02:59:24 | oldies | 3 | 112716 | 1066 | 5.673 | 19868.9 |
| 1101 | 2024-03-29 02:47:21 | oldies | 3 | 112716 | 1066 | 7.220 | 15611.6 |
| 1100 | 2024-03-28 23:40:16 | oldies | 1 | 48755 | 2 | 0.983 | 49598.2 |
| 1099 | 2024-03-12 07:15:22 | oldies | 2 | 82551 | 76 | 4.033 | 20468.9 |
| 1098 | 2024-03-09 17:22:21 | oldies | 3 | 112716 | 1066 | 6.236 | 18075.0 |
| 1097 | 2024-03-08 13:16:00 | oldies | 3 | 112716 | 1066 | 17.560 | 6418.9 |
| 1096 | 2024-03-01 00:07:52 | oldies | 2 | 82551 | 76 | 5.516 | 14965.7 |
| 1095 | 2024-02-29 04:18:40 | oldies | 3 | 112716 | 1066 | 11.766 | 9579.8 |
| 1094 | 2024-02-29 00:42:52 | oldies | 2 | 82551 | 76 | 5.530 | 14927.8 |
| 1093 | 2024-02-29 00:42:48 | oldies | 3 | 112716 | 1066 | 6.500 | 17340.9 |
| 1092 | 2024-02-27 17:07:05 | oldies | 1 | 48755 | 2 | 1.483 | 32875.9 |
| 1091 | 2024-02-27 13:14:58 | oldies | 2 | 82551 | 76 | 2.500 | 33020.4 |
| 1090 | 2024-02-26 09:24:25 | oldies | 2 | 82551 | 76 | 2.190 | 37694.5 |
| 1089 | 2024-02-26 09:24:00 | oldies | 3 | 112716 | 1066 | 5.846 | 19280.9 |
| 1088 | 2024-02-22 01:07:40 | oldies | 3 | 112716 | 1066 | 15.873 | 7101.1 |
| 1087 | 2024-02-21 18:13:36 | oldies | 3 | 112716 | 1066 | 10.703 | 10531.3 |
| 1086 | 2024-02-21 06:47:22 | oldies | 3 | 112716 | 1066 | 9.143 | 12328.1 |
| 1085 | 2024-01-18 10:13:19 | oldies | 3 | 112716 | 1066 | 5.516 | 20434.4 |
| 1084 | 2023-12-29 00:37:10 | oldies | 3 | 112716 | 1066 | 5.983 | 18839.4 |
| 1083 | 2023-12-23 23:10:26 | oldies | 1 | 48755 | 2 | 0.736 | 66243.2 |
| 1082 | 2023-12-22 11:35:29 | oldies | 1 | 48755 | 2 | 0.736 | 66243.2 |
| 1081 | 2023-12-21 07:05:02 | oldies | 2 | 82551 | 76 | 2.220 | 37185.1 |
| 1080 | 2023-12-20 18:34:39 | oldies | 1 | 48755 | 2 | 0.750 | 65006.7 |
| 1079 | 2023-12-18 19:34:30 | oldies | 3 | 112716 | 1066 | 4.796 | 23502.1 |
| 1078 | 2023-11-28 00:25:07 | oldies | 3 | 112716 | 1066 | 5.456 | 20659.1 |
| 1077 | 2023-11-26 14:49:03 | oldies | 3 | 112716 | 1066 | 6.563 | 17174.5 |
| 1076 | 2023-11-26 07:17:15 | oldies | 2 | 82551 | 76 | 2.093 | 39441.5 |
| 1075 | 2023-11-25 11:53:49 | oldies | 3 | 112716 | 1066 | 4.906 | 22975.1 |
| 1074 | 2023-11-22 15:58:33 | oldies | 2 | 82551 | 76 | 2.686 | 30733.8 |
| 1073 | 2023-11-22 08:14:59 | oldies | 3 | 112716 | 1066 | 5.546 | 20323.8 |
| 1072 | 2023-11-18 11:06:01 | oldies | 1 | 48755 | 2 | 0.843 | 57835.1 |
| 1071 | 2023-11-17 03:43:10 | oldies | 3 | 112716 | 1066 | 6.313 | 17854.6 |
| 1070 | 2023-11-16 21:10:34 | oldies | 3 | 112716 | 1066 | 4.736 | 23799.8 |
| 1069 | 2023-11-13 22:38:57 | oldies | 1 | 48755 | 2 | 1.703 | 28628.9 |
| 1068 | 2023-11-12 12:20:05 | oldies | 3 | 112716 | 1066 | 6.906 | 16321.5 |
| 1067 | 2023-11-11 14:38:00 | oldies | 3 | 112716 | 1066 | 5.156 | 21861.1 |
| 1066 | 2023-11-09 09:15:50 | oldies | 3 | 112716 | 1066 | 5.000 | 22543.2 |
| 1065 | 2023-11-07 09:51:25 | oldies | 3 | 112716 | 1066 | 19.906 | 5662.4 |
| 1064 | 2023-11-07 09:51:03 | oldies | 3 | 112716 | 1066 | 6.643 | 16967.6 |
| 1063 | 2023-11-06 21:48:45 | oldies | 3 | 112716 | 1066 | 7.186 | 15685.5 |
| 1062 | 2023-11-05 22:39:53 | oldies | 3 | 112716 | 1066 | 4.750 | 23729.7 |
| 1061 | 2023-11-04 22:09:19 | oldies | 3 | 112716 | 1066 | 4.700 | 23982.1 |
| 1060 | 2023-11-04 09:11:35 | oldies | 2 | 82551 | 76 | 2.170 | 38041.9 |
| 1059 | 2023-11-04 09:11:08 | oldies | 1 | 48755 | 2 | 0.736 | 66243.2 |
| 1058 | 2023-11-03 22:32:54 | oldies | 3 | 112716 | 1066 | 4.843 | 23274.0 |
| 1057 | 2023-11-03 04:28:36 | oldies | 3 | 112716 | 1066 | 9.640 | 11692.5 |
| 1056 | 2023-11-02 23:07:50 | oldies | 3 | 112716 | 1066 | 4.796 | 23502.1 |
| 1055 | 2023-11-01 22:46:53 | oldies | 3 | 112716 | 1066 | 5.030 | 22408.7 |
| 1054 | 2023-11-01 07:36:50 | oldies | 3 | 112716 | 1066 | 4.670 | 24136.2 |
| 1053 | 2023-10-31 20:47:35 | oldies | 3 | 112716 | 1066 | 10.546 | 10688.0 |
| 1052 | 2023-10-31 18:35:12 | oldies | 3 | 112716 | 1066 | 5.906 | 19085.0 |
| 1051 | 2023-10-31 07:33:11 | oldies | 3 | 112716 | 1066 | 6.813 | 16544.3 |
| 1050 | 2023-10-30 18:41:55 | oldies | 3 | 112716 | 1066 | 5.453 | 20670.5 |
| 1049 | 2023-10-30 07:18:38 | oldies | 3 | 112716 | 1066 | 5.046 | 22337.7 |
| 1048 | 2023-10-29 07:40:36 | oldies | 3 | 112716 | 1066 | 5.546 | 20323.8 |
| 1047 | 2023-10-28 19:33:06 | oldies | 1 | 48755 | 2 | 0.826 | 59025.4 |
| 1046 | 2023-10-28 07:21:32 | oldies | 3 | 112716 | 1066 | 5.390 | 20912.1 |
| 1045 | 2023-10-27 07:35:38 | oldies | 3 | 112716 | 1066 | 5.296 | 21283.2 |
| 1044 | 2023-10-26 18:26:31 | oldies | 3 | 112716 | 1066 | 5.920 | 19039.9 |
| 1043 | 2023-10-26 07:38:05 | oldies | 3 | 112716 | 1066 | 10.326 | 10915.7 |
| 1042 | 2023-10-26 07:00:49 | oldies | 3 | 112716 | 1066 | 5.606 | 20106.3 |
| 1041 | 2023-10-25 18:28:07 | oldies | 3 | 112716 | 1066 | 6.236 | 18075.0 |
| 1040 | 2023-10-25 10:50:35 | oldies | 3 | 112716 | 1066 | 5.360 | 21029.1 |
| 1039 | 2023-10-25 07:30:38 | oldies | 3 | 112716 | 1066 | 5.656 | 19928.6 |
| 1038 | 2023-10-24 18:23:25 | oldies | 3 | 112716 | 1066 | 5.970 | 18880.4 |
| 1037 | 2023-10-24 07:59:52 | oldies | 3 | 112716 | 1066 | 4.780 | 23580.8 |
| 1036 | 2023-10-23 18:20:22 | oldies | 3 | 112716 | 1066 | 7.063 | 15958.7 |
| 1035 | 2023-10-23 06:33:34 | oldies | 3 | 112716 | 1066 | 4.953 | 22757.1 |
| 1034 | 2023-10-23 01:49:46 | oldies | 1 | 48755 | 2 | 0.736 | 66243.2 |
| 1033 | 2023-10-22 20:10:54 | oldies | 3 | 112716 | 1066 | 5.593 | 20153.0 |
| 1032 | 2023-10-22 19:00:38 | oldies | 3 | 112716 | 1066 | 11.080 | 10172.9 |
| 1031 | 2023-10-22 13:36:11 | oldies | 3 | 112716 | 1066 | 5.500 | 20493.8 |
| 1030 | 2023-10-22 06:26:33 | oldies | 3 | 112716 | 1066 | 5.360 | 21029.1 |
| 1029 | 2023-10-21 20:42:33 | oldies | 3 | 112716 | 1066 | 5.576 | 20214.5 |
| 1028 | 2023-10-21 06:49:20 | oldies | 3 | 112716 | 1066 | 9.390 | 12003.8 |
| 1027 | 2023-10-20 18:33:32 | oldies | 3 | 112716 | 1066 | 4.796 | 23502.1 |
| 1026 | 2023-10-20 08:59:48 | oldies | 3 | 112716 | 1066 | 5.046 | 22337.7 |
| 1025 | 2023-10-20 06:45:00 | oldies | 3 | 112716 | 1066 | 10.470 | 10765.6 |
| 1024 | 2023-10-19 12:02:45 | oldies | 3 | 112716 | 1066 | 5.376 | 20966.5 |
| 1023 | 2023-10-18 23:09:34 | oldies | 3 | 112716 | 1066 | 5.640 | 19985.1 |
| 1022 | 2023-10-18 11:23:21 | oldies | 3 | 112716 | 1066 | 5.170 | 21801.9 |
| 1021 | 2023-10-17 14:40:00 | oldies | 3 | 112716 | 1066 | 5.330 | 21147.5 |
| 1020 | 2023-10-17 12:03:03 | oldies | 3 | 112716 | 1066 | 5.000 | 22543.2 |
| 1019 | 2023-10-17 05:02:23 | oldies | 3 | 112716 | 1066 | 12.580 | 8959.9 |
| 1018 | 2023-10-17 02:47:37 | oldies | 3 | 112716 | 1066 | 5.000 | 22543.2 |
| 1017 | 2023-10-16 02:54:43 | oldies | 3 | 112716 | 1066 | 13.140 | 8578.1 |
| 1016 | 2023-10-15 15:12:22 | oldies | 3 | 112716 | 1066 | 4.580 | 24610.5 |
| 1015 | 2023-10-15 04:05:20 | oldies | 3 | 112716 | 1066 | 4.890 | 23050.3 |
| 1014 | 2023-10-14 20:33:00 | oldies | 3 | 112716 | 1066 | 4.733 | 23814.9 |
| 1013 | 2023-10-14 12:19:32 | oldies | 3 | 112716 | 1066 | 5.516 | 20434.4 |
| 1012 | 2023-10-14 01:42:31 | oldies | 3 | 112716 | 1066 | 4.810 | 23433.7 |