History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pros"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1179 | 2024-05-01 18:18:04 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1178 | 2024-04-30 07:09:02 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1177 | 2024-04-28 07:27:20 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1176 | 2024-04-27 11:09:08 | pros | 2 | 29872 | 406 | 1.826 | 16359.3 |
| 1175 | 2024-04-15 10:49:36 | pros | 1 | 13983 | 26 | 0.470 | 29751.1 |
| 1174 | 2024-04-11 15:27:59 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1173 | 2024-04-11 15:27:58 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1172 | 2024-04-11 15:20:33 | pros | 1 | 13983 | 26 | 0.236 | 59250.0 |
| 1171 | 2024-04-11 15:04:14 | pros | 1 | 13983 | 26 | 0.546 | 25609.9 |
| 1170 | 2024-04-07 08:14:52 | pros | 2 | 29872 | 406 | 1.313 | 22751.0 |
| 1169 | 2024-04-02 21:44:49 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1168 | 2024-04-01 15:40:19 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1167 | 2024-03-31 00:53:25 | pros | 1 | 13983 | 26 | 0.826 | 16928.6 |
| 1166 | 2024-03-31 00:50:55 | pros | 2 | 29872 | 406 | 1.406 | 21246.1 |
| 1165 | 2024-03-31 00:45:09 | pros | 2 | 29872 | 406 | 2.233 | 13377.5 |
| 1164 | 2024-03-30 23:48:12 | pros | 1 | 13983 | 26 | 0.263 | 53167.3 |
| 1163 | 2024-03-28 13:04:37 | pros | 2 | 29872 | 406 | 0.953 | 31345.2 |
| 1162 | 2024-03-26 19:08:55 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1161 | 2024-03-16 08:06:03 | pros | 1 | 13983 | 26 | 0.653 | 21413.5 |
| 1160 | 2024-03-02 14:27:34 | pros | 2 | 29872 | 406 | 2.923 | 10219.6 |
| 1159 | 2024-03-02 13:49:40 | pros | 1 | 13983 | 26 | 0.266 | 52567.7 |
| 1158 | 2024-02-25 16:29:24 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1157 | 2024-02-18 00:13:48 | pros | 1 | 13983 | 26 | 1.530 | 9139.2 |
| 1156 | 2024-01-26 11:04:53 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1155 | 2024-01-20 00:36:54 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1154 | 2024-01-16 05:24:28 | pros | 2 | 29872 | 406 | 0.983 | 30388.6 |
| 1153 | 2024-01-01 00:37:03 | pros | 1 | 13983 | 26 | 0.216 | 64736.1 |
| 1152 | 2023-12-30 03:56:43 | pros | 1 | 13983 | 26 | 0.203 | 68881.8 |
| 1151 | 2023-12-28 19:43:31 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1150 | 2023-12-17 07:48:23 | pros | 2 | 29872 | 406 | 0.766 | 38997.4 |
| 1149 | 2023-12-09 15:16:20 | pros | 2 | 29872 | 406 | 0.846 | 35309.7 |
| 1148 | 2023-12-03 00:50:09 | pros | 1 | 13983 | 26 | 0.263 | 53167.3 |
| 1147 | 2023-11-25 05:39:10 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1146 | 2023-11-24 11:42:55 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1145 | 2023-11-24 01:47:19 | pros | 2 | 29872 | 406 | 0.750 | 39829.3 |
| 1144 | 2023-11-22 14:15:24 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1143 | 2023-11-18 04:50:13 | pros | 1 | 13983 | 26 | 0.203 | 68881.8 |
| 1142 | 2023-11-14 15:23:29 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1141 | 2023-11-11 20:42:30 | pros | 1 | 13983 | 26 | 0.236 | 59250.0 |
| 1140 | 2023-11-07 08:18:38 | pros | 1 | 13983 | 26 | 0.236 | 59250.0 |
| 1139 | 2023-11-02 07:34:47 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1138 | 2023-10-28 16:53:52 | pros | 2 | 29872 | 406 | 0.763 | 39150.7 |
| 1137 | 2023-10-27 07:57:22 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1136 | 2023-10-19 21:34:15 | pros | 1 | 13983 | 26 | 0.216 | 64736.1 |
| 1135 | 2023-10-19 20:56:14 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1134 | 2023-10-18 07:29:07 | pros | 2 | 29872 | 406 | 0.830 | 35990.4 |
| 1133 | 2023-10-16 19:17:33 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1132 | 2023-10-12 06:06:37 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1131 | 2023-10-03 23:15:21 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1130 | 2023-09-24 06:58:38 | pros | 1 | 13983 | 26 | 0.200 | 69915.0 |
| 1129 | 2023-09-07 05:11:43 | pros | 2 | 29872 | 406 | 0.813 | 36742.9 |
| 1128 | 2023-08-14 03:41:00 | pros | 1 | 13983 | 26 | 0.216 | 64736.1 |
| 1127 | 2023-08-05 11:19:31 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1126 | 2023-05-28 15:55:51 | pros | 2 | 29872 | 406 | 0.860 | 34734.9 |
| 1125 | 2023-05-18 04:34:47 | pros | 1 | 13983 | 26 | 0.236 | 59250.0 |
| 1124 | 2023-05-14 08:41:36 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1123 | 2023-04-24 07:01:02 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1122 | 2023-03-11 03:58:51 | pros | 2 | 29872 | 406 | 0.733 | 40753.1 |
| 1121 | 2023-03-07 23:32:51 | pros | 1 | 13983 | 26 | 0.203 | 68881.8 |
| 1120 | 2023-03-07 16:56:56 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1119 | 2023-02-06 15:23:34 | pros | 2 | 29872 | 406 | 0.826 | 36164.6 |
| 1118 | 2023-01-11 22:16:01 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1117 | 2023-01-02 22:07:09 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1116 | 2022-12-31 15:37:30 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1115 | 2022-12-29 06:55:05 | pros | 1 | 13983 | 26 | 0.236 | 59250.0 |
| 1114 | 2022-12-29 05:15:23 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1113 | 2022-12-27 20:45:32 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1112 | 2022-12-25 08:57:25 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1111 | 2022-12-22 15:38:33 | pros | 1 | 13983 | 26 | 0.423 | 33056.7 |
| 1110 | 2022-12-21 06:35:12 | pros | 2 | 29872 | 406 | 0.860 | 34734.9 |
| 1109 | 2022-12-16 15:19:38 | pros | 2 | 29872 | 406 | 0.736 | 40587.0 |
| 1108 | 2022-11-06 17:42:49 | pros | 2 | 29872 | 406 | 0.733 | 40753.1 |
| 1107 | 2022-11-04 07:55:40 | pros | 2 | 29872 | 406 | 0.810 | 36879.0 |
| 1106 | 2022-10-21 18:08:27 | pros | 2 | 29872 | 406 | 0.736 | 40587.0 |
| 1105 | 2022-09-26 01:22:15 | pros | 2 | 29872 | 406 | 0.750 | 39829.3 |
| 1104 | 2022-09-24 08:58:16 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1103 | 2022-09-20 18:42:26 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1102 | 2022-09-20 01:04:17 | pros | 1 | 13983 | 26 | 0.250 | 55932.0 |
| 1101 | 2022-09-18 17:24:03 | pros | 1 | 13983 | 26 | 0.200 | 69915.0 |
| 1100 | 2022-09-16 20:04:14 | pros | 1 | 13983 | 26 | 0.203 | 68881.8 |
| 1099 | 2022-09-11 23:39:42 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1098 | 2022-09-03 01:54:36 | pros | 1 | 13983 | 26 | 0.203 | 68881.8 |
| 1097 | 2022-08-26 00:50:20 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1096 | 2022-08-23 21:06:10 | pros | 1 | 13983 | 26 | 0.236 | 59250.0 |
| 1095 | 2022-08-17 13:02:22 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1094 | 2022-08-14 11:59:21 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1093 | 2022-08-10 03:35:05 | pros | 2 | 29872 | 406 | 0.720 | 41488.9 |
| 1092 | 2022-08-09 06:20:52 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1091 | 2022-08-06 17:32:52 | pros | 1 | 13983 | 26 | 0.216 | 64736.1 |
| 1090 | 2022-07-29 22:36:06 | pros | 1 | 13983 | 26 | 0.216 | 64736.1 |
| 1089 | 2022-07-17 20:22:25 | pros | 1 | 13983 | 26 | 0.203 | 68881.8 |
| 1088 | 2022-07-12 10:48:01 | pros | 1 | 13983 | 26 | 0.236 | 59250.0 |
| 1087 | 2022-07-11 14:48:14 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1086 | 2022-07-11 00:07:41 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1085 | 2022-07-09 07:07:08 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |
| 1084 | 2022-07-08 14:53:15 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1083 | 2022-07-07 21:51:53 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1082 | 2022-07-06 09:17:03 | pros | 1 | 13983 | 26 | 0.233 | 60012.9 |
| 1081 | 2022-07-05 11:59:46 | pros | 1 | 13983 | 26 | 0.216 | 64736.1 |
| 1080 | 2022-07-03 09:44:14 | pros | 1 | 13983 | 26 | 0.220 | 63559.1 |