History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pennames"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
309 | 2024-04-07 20:32:45 | pennames | 2 | 121059 | 17 | 14.733 | 8216.9 |
308 | 2024-04-07 19:21:37 | pennames | 3 | 146162 | 158 | 8.266 | 17682.3 |
307 | 2024-04-06 15:21:12 | pennames | 3 | 146162 | 158 | 7.450 | 19619.1 |
306 | 2024-04-06 15:21:13 | pennames | 2 | 121059 | 17 | 3.893 | 31096.6 |
305 | 2024-04-06 15:21:12 | pennames | 1 | 82945 | 2 | 1.516 | 54713.1 |
304 | 2024-04-05 03:14:01 | pennames | 2 | 121059 | 17 | 4.296 | 28179.5 |
303 | 2024-04-05 03:13:57 | pennames | 1 | 82945 | 2 | 1.576 | 52630.1 |
302 | 2024-04-05 03:13:45 | pennames | 3 | 146162 | 158 | 9.296 | 15723.1 |
301 | 2024-04-05 03:13:44 | pennames | 2 | 121059 | 17 | 7.470 | 16206.0 |
300 | 2024-04-05 03:13:38 | pennames | 1 | 82945 | 2 | 1.813 | 45750.1 |
299 | 2024-03-31 09:39:24 | pennames | 3 | 146162 | 158 | 23.813 | 6137.9 |
298 | 2024-03-31 06:26:10 | pennames | 3 | 146162 | 158 | 12.720 | 11490.7 |
297 | 2024-03-31 04:56:02 | pennames | 3 | 146162 | 158 | 17.703 | 8256.3 |
296 | 2024-03-31 04:56:03 | pennames | 2 | 121059 | 17 | 4.656 | 26000.6 |
295 | 2024-03-31 03:57:13 | pennames | 1 | 82945 | 2 | 1.563 | 53067.8 |
294 | 2024-03-30 19:58:55 | pennames | 1 | 82945 | 2 | 5.016 | 16536.1 |
293 | 2024-03-30 04:14:05 | pennames | 1 | 82945 | 2 | 2.640 | 31418.6 |
292 | 2024-03-05 22:20:24 | pennames | 1 | 82945 | 2 | 6.923 | 11981.1 |
291 | 2024-02-29 09:59:27 | pennames | 1 | 82945 | 2 | 1.550 | 53512.9 |
290 | 2024-02-14 23:58:32 | pennames | 2 | 121059 | 17 | 4.483 | 27004.0 |
289 | 2024-02-14 22:02:25 | pennames | 3 | 146162 | 158 | 9.000 | 16240.2 |
288 | 2024-02-07 16:14:31 | pennames | 2 | 121059 | 17 | 3.843 | 31501.2 |
287 | 2024-02-07 16:14:19 | pennames | 3 | 146162 | 158 | 7.516 | 19446.8 |
286 | 2024-02-06 18:58:18 | pennames | 2 | 121059 | 17 | 3.313 | 36540.6 |
285 | 2024-02-06 18:57:22 | pennames | 3 | 146162 | 158 | 7.860 | 18595.7 |
284 | 2024-02-02 00:38:07 | pennames | 3 | 146162 | 158 | 7.330 | 19940.2 |
283 | 2024-01-31 17:23:52 | pennames | 3 | 146162 | 158 | 7.420 | 19698.4 |
282 | 2024-01-31 13:50:27 | pennames | 1 | 82945 | 2 | 2.873 | 28870.5 |
281 | 2024-01-31 07:41:04 | pennames | 1 | 82945 | 2 | 1.640 | 50576.2 |
280 | 2024-01-18 01:37:36 | pennames | 2 | 121059 | 17 | 3.330 | 36354.1 |
279 | 2024-01-03 09:07:54 | pennames | 2 | 121059 | 17 | 3.360 | 36029.5 |
278 | 2023-12-02 09:58:30 | pennames | 3 | 146162 | 158 | 6.313 | 23152.5 |
277 | 2023-11-29 16:27:28 | pennames | 3 | 146162 | 158 | 6.610 | 22112.3 |
276 | 2023-11-26 04:18:15 | pennames | 1 | 82945 | 2 | 1.296 | 64000.8 |
275 | 2023-11-17 18:23:34 | pennames | 1 | 82945 | 2 | 1.310 | 63316.8 |
274 | 2023-11-14 00:51:46 | pennames | 1 | 82945 | 2 | 2.530 | 32784.6 |
273 | 2023-11-09 15:51:41 | pennames | 3 | 146162 | 158 | 6.250 | 23385.9 |
272 | 2023-11-06 20:03:34 | pennames | 1 | 82945 | 2 | 1.406 | 58993.6 |
271 | 2023-10-19 01:52:41 | pennames | 1 | 82945 | 2 | 1.453 | 57085.3 |
270 | 2023-09-29 11:01:13 | pennames | 1 | 82945 | 2 | 1.360 | 60989.0 |
269 | 2023-09-12 19:57:10 | pennames | 1 | 82945 | 2 | 1.296 | 64000.8 |
268 | 2023-09-11 20:12:34 | pennames | 1 | 82945 | 2 | 1.453 | 57085.3 |
267 | 2023-08-11 21:14:26 | pennames | 3 | 146162 | 158 | 8.750 | 16704.2 |
266 | 2023-06-20 23:57:05 | pennames | 1 | 82945 | 2 | 1.343 | 61761.0 |
265 | 2023-05-26 23:56:35 | pennames | 1 | 82945 | 2 | 1.313 | 63172.1 |
264 | 2023-04-28 06:29:52 | pennames | 1 | 82945 | 2 | 1.440 | 57600.7 |
263 | 2023-04-21 04:02:28 | pennames | 3 | 146162 | 158 | 7.546 | 19369.5 |
262 | 2023-04-01 11:08:29 | pennames | 1 | 82945 | 2 | 1.420 | 58412.0 |
261 | 2023-03-20 10:40:38 | pennames | 1 | 82945 | 2 | 1.313 | 63172.1 |
260 | 2023-03-04 09:26:02 | pennames | 1 | 82945 | 2 | 1.313 | 63172.1 |
259 | 2023-01-27 12:54:09 | pennames | 1 | 82945 | 2 | 2.360 | 35146.2 |
258 | 2023-01-26 20:54:26 | pennames | 3 | 146162 | 158 | 6.236 | 23438.4 |
257 | 2023-01-12 22:17:09 | pennames | 1 | 82945 | 2 | 1.423 | 58288.8 |
256 | 2022-11-09 08:51:00 | pennames | 3 | 146162 | 158 | 7.733 | 18901.1 |
255 | 2022-10-31 02:44:47 | pennames | 1 | 82945 | 2 | 1.280 | 64800.8 |
254 | 2022-09-28 17:52:03 | pennames | 1 | 82945 | 2 | 1.470 | 56425.2 |
253 | 2022-09-25 04:39:35 | pennames | 1 | 82945 | 2 | 1.453 | 57085.3 |
252 | 2022-06-19 07:28:04 | pennames | 1 | 82945 | 2 | 1.330 | 62364.7 |
251 | 2022-05-29 05:16:28 | pennames | 1 | 82945 | 2 | 1.453 | 57085.3 |
250 | 2022-05-16 09:24:24 | pennames | 1 | 82945 | 2 | 1.470 | 56425.2 |
249 | 2022-05-15 19:43:24 | pennames | 3 | 146162 | 158 | 6.563 | 22270.6 |
248 | 2022-02-26 19:05:41 | pennames | 1 | 82945 | 2 | 1.310 | 63316.8 |
247 | 2022-01-31 09:55:21 | pennames | 1 | 82945 | 2 | 1.330 | 62364.7 |
246 | 2021-12-15 18:23:13 | pennames | 1 | 82945 | 2 | 1.483 | 55930.5 |
245 | 2021-12-13 17:04:09 | pennames | 1 | 82945 | 2 | 1.436 | 57761.1 |
244 | 2021-10-21 20:08:36 | pennames | 1 | 82945 | 2 | 1.296 | 64000.8 |
243 | 2021-10-14 12:53:50 | pennames | 1 | 82945 | 2 | 1.483 | 55930.5 |
242 | 2021-09-25 01:26:55 | pennames | 1 | 82945 | 2 | 1.313 | 63172.1 |
241 | 2021-07-13 11:55:05 | pennames | 1 | 82945 | 2 | 1.376 | 60279.8 |
240 | 2021-06-03 12:19:11 | pennames | 2 | 121059 | 17 | 6.550 | 18482.3 |
239 | 2021-06-01 02:49:36 | pennames | 1 | 82945 | 2 | 1.486 | 55817.6 |
238 | 2021-05-06 21:38:31 | pennames | 1 | 82945 | 2 | 1.576 | 52630.1 |
237 | 2021-04-14 07:37:53 | pennames | 1 | 82945 | 2 | 2.906 | 28542.7 |
236 | 2021-04-05 04:35:59 | pennames | 1 | 82945 | 2 | 1.313 | 63172.1 |
235 | 2021-03-12 02:59:37 | pennames | 2 | 121059 | 17 | 3.236 | 37410.1 |
234 | 2021-02-10 10:09:59 | pennames | 1 | 82945 | 2 | 1.373 | 60411.5 |
233 | 2021-01-22 22:08:46 | pennames | 2 | 121059 | 17 | 3.236 | 37410.1 |
232 | 2021-01-08 12:18:52 | pennames | 1 | 82945 | 2 | 1.296 | 64000.8 |
231 | 2020-11-25 10:22:58 | pennames | 1 | 82945 | 2 | 1.296 | 64000.8 |
230 | 2020-11-13 07:48:51 | pennames | 1 | 82945 | 2 | 1.403 | 59119.7 |
229 | 2020-11-11 13:43:04 | pennames | 1 | 82945 | 2 | 1.436 | 57761.1 |
228 | 2020-11-03 17:05:27 | pennames | 1 | 82945 | 2 | 1.546 | 53651.4 |
227 | 2020-11-03 00:20:04 | pennames | 2 | 121059 | 17 | 3.890 | 31120.6 |
226 | 2020-10-23 05:41:06 | pennames | 1 | 82945 | 2 | 2.643 | 31382.9 |
225 | 2020-10-07 16:49:42 | pennames | 1 | 82945 | 2 | 1.326 | 62552.8 |
224 | 2020-09-14 07:39:16 | pennames | 1 | 82945 | 2 | 1.296 | 64000.8 |
223 | 2020-06-16 01:18:32 | pennames | 1 | 82945 | 2 | 1.346 | 61623.3 |
222 | 2020-03-30 01:12:00 | pennames | 1 | 82945 | 2 | 1.436 | 57761.1 |
221 | 2020-03-26 03:13:36 | pennames | 1 | 82945 | 2 | 2.190 | 37874.4 |
220 | 2020-03-25 17:23:45 | pennames | 1 | 82945 | 2 | 1.346 | 61623.3 |
219 | 2020-03-21 02:16:32 | pennames | 1 | 82945 | 2 | 1.516 | 54713.1 |
218 | 2020-03-11 10:06:48 | pennames | 1 | 82945 | 2 | 1.453 | 57085.3 |
217 | 2020-02-23 04:30:44 | pennames | 1 | 82945 | 2 | 1.673 | 49578.6 |
216 | 2020-02-23 00:38:44 | pennames | 1 | 82945 | 2 | 3.343 | 24811.5 |
215 | 2020-02-18 02:52:13 | pennames | 1 | 82945 | 2 | 1.563 | 53067.8 |
214 | 2020-02-11 12:53:35 | pennames | 1 | 82945 | 2 | 4.360 | 19024.1 |
213 | 2020-02-11 05:21:14 | pennames | 1 | 82945 | 2 | 2.513 | 33006.4 |
212 | 2020-02-02 21:21:51 | pennames | 1 | 82945 | 2 | 2.143 | 38705.1 |
211 | 2020-01-25 16:11:43 | pennames | 1 | 82945 | 2 | 2.843 | 29175.2 |
210 | 2020-01-25 11:44:43 | pennames | 1 | 82945 | 2 | 3.513 | 23610.9 |