History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"awardee"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
257 | 2024-05-05 10:51:44 | awardee | 1 | 69583 | 4 | 1.310 | 53116.8 |
256 | 2024-05-05 02:11:41 | awardee | 1 | 69583 | 4 | 1.220 | 57035.2 |
255 | 2024-05-03 20:02:47 | awardee | 3 | 134027 | 112 | 6.970 | 19229.1 |
254 | 2024-05-03 19:02:47 | awardee | 2 | 107671 | 13 | 3.920 | 27467.1 |
253 | 2024-05-01 11:51:00 | awardee | 2 | 107671 | 13 | 11.373 | 9467.2 |
252 | 2024-05-01 11:50:42 | awardee | 1 | 69583 | 4 | 2.140 | 32515.4 |
251 | 2024-04-29 10:28:16 | awardee | 1 | 69583 | 4 | 1.170 | 59472.6 |
250 | 2024-04-29 10:19:26 | awardee | 1 | 69583 | 4 | 1.360 | 51164.0 |
249 | 2024-04-13 18:03:02 | awardee | 3 | 134027 | 112 | 30.613 | 4378.1 |
248 | 2024-04-10 23:24:28 | awardee | 3 | 134027 | 112 | 7.110 | 18850.5 |
247 | 2024-04-02 18:44:58 | awardee | 3 | 134027 | 112 | 9.436 | 14203.8 |
246 | 2024-04-01 16:26:35 | awardee | 3 | 134027 | 112 | 15.186 | 8825.7 |
245 | 2024-04-01 16:26:33 | awardee | 2 | 107671 | 13 | 4.216 | 25538.7 |
244 | 2024-04-01 16:26:20 | awardee | 1 | 69583 | 4 | 4.190 | 16606.9 |
243 | 2024-04-01 16:26:03 | awardee | 3 | 134027 | 112 | 8.530 | 15712.4 |
242 | 2024-04-01 16:26:01 | awardee | 2 | 107671 | 13 | 3.813 | 28237.9 |
241 | 2024-04-01 16:26:00 | awardee | 1 | 69583 | 4 | 2.826 | 24622.4 |
240 | 2024-03-31 04:43:33 | awardee | 1 | 69583 | 4 | 2.873 | 24219.6 |
239 | 2024-03-11 06:42:54 | awardee | 1 | 69583 | 4 | 1.123 | 61961.7 |
238 | 2024-03-11 03:06:09 | awardee | 1 | 69583 | 4 | 2.986 | 23303.1 |
237 | 2024-03-06 04:39:38 | awardee | 3 | 134027 | 112 | 19.750 | 6786.2 |
236 | 2024-03-02 14:17:38 | awardee | 1 | 69583 | 4 | 2.890 | 24077.2 |
235 | 2024-03-02 14:15:53 | awardee | 1 | 69583 | 4 | 1.500 | 46388.7 |
234 | 2024-03-02 12:49:06 | awardee | 3 | 134027 | 112 | 7.096 | 18887.7 |
233 | 2024-03-01 09:33:04 | awardee | 2 | 107671 | 13 | 5.046 | 21337.9 |
232 | 2024-02-28 08:38:26 | awardee | 2 | 107671 | 13 | 7.470 | 14413.8 |
231 | 2024-02-28 08:38:20 | awardee | 3 | 134027 | 112 | 8.156 | 16432.9 |
230 | 2024-02-28 07:27:17 | awardee | 1 | 69583 | 4 | 2.733 | 25460.3 |
229 | 2024-01-27 14:04:27 | awardee | 2 | 107671 | 13 | 3.406 | 31612.2 |
228 | 2024-01-27 14:04:15 | awardee | 3 | 134027 | 112 | 6.703 | 19995.1 |
227 | 2024-01-12 22:53:24 | awardee | 3 | 134027 | 112 | 6.733 | 19906.0 |
226 | 2024-01-12 22:53:26 | awardee | 2 | 107671 | 13 | 3.483 | 30913.3 |
225 | 2023-12-13 09:06:43 | awardee | 1 | 69583 | 4 | 1.170 | 59472.6 |
224 | 2023-12-09 17:31:08 | awardee | 3 | 134027 | 112 | 5.860 | 22871.5 |
223 | 2023-11-27 18:41:16 | awardee | 1 | 69583 | 4 | 2.140 | 32515.4 |
222 | 2023-11-20 15:17:21 | awardee | 1 | 69583 | 4 | 1.200 | 57985.8 |
221 | 2023-11-16 22:09:04 | awardee | 1 | 69583 | 4 | 1.233 | 56433.9 |
220 | 2023-10-26 08:05:51 | awardee | 1 | 69583 | 4 | 1.203 | 57841.2 |
219 | 2023-10-16 20:56:41 | awardee | 1 | 69583 | 4 | 1.296 | 53690.6 |
218 | 2023-10-08 07:17:20 | awardee | 1 | 69583 | 4 | 2.656 | 26198.4 |
217 | 2023-09-27 20:25:17 | awardee | 1 | 69583 | 4 | 1.060 | 65644.3 |
216 | 2023-09-27 07:19:41 | awardee | 1 | 69583 | 4 | 1.233 | 56433.9 |
215 | 2023-09-17 01:16:04 | awardee | 1 | 69583 | 4 | 1.173 | 59320.5 |
214 | 2023-09-11 05:58:37 | awardee | 3 | 134027 | 112 | 5.750 | 23309.0 |
213 | 2023-09-08 19:07:14 | awardee | 3 | 134027 | 112 | 12.466 | 10751.4 |
212 | 2023-09-03 06:05:52 | awardee | 1 | 69583 | 4 | 1.186 | 58670.3 |
211 | 2023-07-27 08:55:57 | awardee | 1 | 69583 | 4 | 1.173 | 59320.5 |
210 | 2023-06-01 15:07:17 | awardee | 3 | 134027 | 112 | 5.953 | 22514.2 |
209 | 2023-04-04 11:00:36 | awardee | 1 | 69583 | 4 | 1.220 | 57035.2 |
208 | 2023-03-09 21:29:26 | awardee | 3 | 134027 | 112 | 5.656 | 23696.4 |
207 | 2022-12-14 04:16:45 | awardee | 3 | 134027 | 112 | 6.500 | 20619.5 |
206 | 2022-12-12 19:50:58 | awardee | 1 | 69583 | 4 | 2.673 | 26031.8 |
205 | 2022-11-18 21:11:36 | awardee | 1 | 69583 | 4 | 1.110 | 62687.4 |
204 | 2022-09-14 06:45:51 | awardee | 1 | 69583 | 4 | 1.093 | 63662.4 |
203 | 2022-09-07 21:24:24 | awardee | 1 | 69583 | 4 | 1.050 | 66269.5 |
202 | 2022-08-28 04:26:29 | awardee | 1 | 69583 | 4 | 1.203 | 57841.2 |
201 | 2022-08-12 14:31:28 | awardee | 1 | 69583 | 4 | 1.076 | 64668.2 |
200 | 2022-08-07 01:25:11 | awardee | 3 | 134027 | 112 | 5.720 | 23431.3 |
199 | 2022-07-10 07:51:10 | awardee | 1 | 69583 | 4 | 1.093 | 63662.4 |
198 | 2022-07-04 00:10:57 | awardee | 1 | 69583 | 4 | 1.063 | 65459.1 |
197 | 2022-04-11 15:05:17 | awardee | 1 | 69583 | 4 | 1.173 | 59320.5 |
196 | 2022-03-10 17:55:18 | awardee | 1 | 69583 | 4 | 1.420 | 49002.1 |
195 | 2021-12-24 02:56:21 | awardee | 1 | 69583 | 4 | 1.110 | 62687.4 |
194 | 2021-12-19 00:36:17 | awardee | 1 | 69583 | 4 | 1.173 | 59320.5 |
193 | 2021-10-24 01:07:49 | awardee | 1 | 69583 | 4 | 1.250 | 55666.4 |
192 | 2021-09-29 03:14:16 | awardee | 1 | 69583 | 4 | 1.050 | 66269.5 |
191 | 2021-09-10 12:11:54 | awardee | 1 | 69583 | 4 | 1.203 | 57841.2 |
190 | 2021-08-08 12:09:34 | awardee | 2 | 107671 | 13 | 2.843 | 37872.3 |
189 | 2021-08-07 22:30:11 | awardee | 1 | 69583 | 4 | 1.310 | 53116.8 |
188 | 2021-06-09 14:57:53 | awardee | 1 | 69583 | 4 | 1.140 | 61037.7 |
187 | 2021-06-06 06:45:28 | awardee | 1 | 69583 | 4 | 1.046 | 66522.9 |
186 | 2021-05-12 07:44:34 | awardee | 1 | 69583 | 4 | 1.250 | 55666.4 |
185 | 2021-04-11 02:34:30 | awardee | 1 | 69583 | 4 | 1.343 | 51811.6 |
184 | 2021-03-10 15:21:53 | awardee | 1 | 69583 | 4 | 1.140 | 61037.7 |
183 | 2021-02-18 04:52:01 | awardee | 1 | 69583 | 4 | 1.076 | 64668.2 |
182 | 2020-12-07 07:43:37 | awardee | 1 | 69583 | 4 | 1.173 | 59320.5 |
181 | 2020-11-08 23:19:08 | awardee | 1 | 69583 | 4 | 1.186 | 58670.3 |
180 | 2020-10-22 19:26:39 | awardee | 1 | 69583 | 4 | 2.393 | 29077.7 |
179 | 2020-08-25 14:39:29 | awardee | 1 | 69583 | 4 | 1.110 | 62687.4 |
178 | 2020-07-20 04:50:35 | awardee | 1 | 69583 | 4 | 1.263 | 55093.4 |
177 | 2020-05-21 03:41:58 | awardee | 1 | 69583 | 4 | 1.063 | 65459.1 |
176 | 2020-03-29 06:24:10 | awardee | 1 | 69583 | 4 | 1.250 | 55666.4 |
175 | 2020-03-28 19:48:06 | awardee | 1 | 69583 | 4 | 1.250 | 55666.4 |
174 | 2020-03-28 11:39:01 | awardee | 1 | 69583 | 4 | 1.203 | 57841.2 |
173 | 2020-03-25 22:12:28 | awardee | 1 | 69583 | 4 | 1.186 | 58670.3 |
172 | 2020-03-25 14:45:52 | awardee | 1 | 69583 | 4 | 3.596 | 19350.1 |
171 | 2020-03-21 06:07:01 | awardee | 1 | 69583 | 4 | 1.080 | 64428.7 |
170 | 2020-03-04 22:02:18 | awardee | 1 | 69583 | 4 | 1.216 | 57222.9 |
169 | 2020-02-25 19:35:14 | awardee | 1 | 69583 | 4 | 2.563 | 27149.0 |
168 | 2020-02-25 15:20:14 | awardee | 1 | 69583 | 4 | 1.250 | 55666.4 |
167 | 2020-02-17 15:01:59 | awardee | 1 | 69583 | 4 | 2.736 | 25432.4 |
166 | 2020-02-17 04:24:08 | awardee | 3 | 134027 | 112 | 11.143 | 12027.9 |
165 | 2020-02-15 04:26:35 | awardee | 1 | 69583 | 4 | 3.453 | 20151.5 |
164 | 2020-02-15 02:17:29 | awardee | 3 | 134027 | 112 | 10.623 | 12616.7 |
163 | 2020-02-04 06:40:50 | awardee | 1 | 69583 | 4 | 1.080 | 64428.7 |
162 | 2020-01-30 10:25:52 | awardee | 1 | 69583 | 4 | 2.673 | 26031.8 |
161 | 2020-01-26 14:48:09 | awardee | 1 | 69583 | 4 | 1.356 | 51314.9 |
160 | 2020-01-24 05:18:29 | awardee | 1 | 69583 | 4 | 1.093 | 63662.4 |
159 | 2020-01-23 18:15:11 | awardee | 1 | 69583 | 4 | 1.703 | 40859.1 |
158 | 2020-01-23 00:47:00 | awardee | 1 | 69583 | 4 | 1.330 | 52318.0 |