History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"climbers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
332 | 2024-04-30 01:17:21 | climbers | 1 | 82945 | 5 | 2.250 | 36864.4 |
331 | 2024-04-29 02:21:34 | climbers | 1 | 82945 | 5 | 3.173 | 26140.9 |
330 | 2024-04-05 07:30:17 | climbers | 1 | 82945 | 5 | 1.843 | 45005.4 |
329 | 2024-03-30 02:02:36 | climbers | 1 | 82945 | 5 | 6.376 | 13008.9 |
328 | 2024-03-30 01:46:54 | climbers | 2 | 121059 | 45 | 12.703 | 9530.0 |
327 | 2024-03-30 00:49:03 | climbers | 2 | 121059 | 45 | 6.283 | 19267.7 |
326 | 2024-03-30 00:00:31 | climbers | 1 | 82945 | 5 | 1.686 | 49196.3 |
325 | 2024-03-12 18:34:16 | climbers | 2 | 121059 | 45 | 8.376 | 14453.1 |
324 | 2024-03-12 18:33:51 | climbers | 1 | 82945 | 5 | 1.656 | 50087.6 |
323 | 2024-03-12 18:33:32 | climbers | 3 | 146162 | 313 | 8.470 | 17256.4 |
322 | 2024-03-10 03:47:49 | climbers | 3 | 146162 | 313 | 14.033 | 10415.6 |
321 | 2024-03-08 19:04:48 | climbers | 3 | 146162 | 313 | 11.983 | 12197.4 |
320 | 2024-03-07 11:34:50 | climbers | 2 | 121059 | 45 | 8.953 | 13521.6 |
319 | 2024-03-07 02:52:01 | climbers | 3 | 146162 | 313 | 24.673 | 5924.0 |
318 | 2024-03-06 12:46:36 | climbers | 3 | 146162 | 313 | 8.953 | 16325.5 |
317 | 2024-03-06 12:46:31 | climbers | 2 | 121059 | 45 | 11.656 | 10386.0 |
316 | 2024-03-06 00:13:13 | climbers | 3 | 146162 | 313 | 24.436 | 5981.4 |
315 | 2024-03-06 00:13:13 | climbers | 2 | 121059 | 45 | 12.873 | 9404.1 |
314 | 2024-03-06 00:10:03 | climbers | 1 | 82945 | 5 | 3.420 | 24252.9 |
313 | 2024-03-01 14:33:49 | climbers | 1 | 82945 | 5 | 3.703 | 22399.4 |
312 | 2024-02-29 21:46:35 | climbers | 1 | 82945 | 5 | 2.873 | 28870.5 |
311 | 2024-01-05 01:42:26 | climbers | 3 | 146162 | 313 | 6.173 | 23677.6 |
310 | 2023-12-24 06:56:32 | climbers | 1 | 82945 | 5 | 1.266 | 65517.4 |
309 | 2023-12-03 23:02:52 | climbers | 1 | 82945 | 5 | 1.423 | 58288.8 |
308 | 2023-12-02 02:27:42 | climbers | 1 | 82945 | 5 | 1.516 | 54713.1 |
307 | 2023-11-24 20:03:42 | climbers | 1 | 82945 | 5 | 1.356 | 61168.9 |
306 | 2023-11-20 14:40:14 | climbers | 1 | 82945 | 5 | 1.376 | 60279.8 |
305 | 2023-11-04 17:22:27 | climbers | 1 | 82945 | 5 | 1.266 | 65517.4 |
304 | 2023-10-20 15:56:14 | climbers | 1 | 82945 | 5 | 1.516 | 54713.1 |
303 | 2023-10-13 14:13:09 | climbers | 1 | 82945 | 5 | 1.483 | 55930.5 |
302 | 2023-10-11 10:44:15 | climbers | 3 | 146162 | 313 | 7.013 | 20841.6 |
301 | 2023-10-11 01:35:20 | climbers | 1 | 82945 | 5 | 1.580 | 52496.8 |
300 | 2023-09-23 01:19:07 | climbers | 1 | 82945 | 5 | 3.060 | 27106.2 |
299 | 2023-09-16 17:45:50 | climbers | 1 | 82945 | 5 | 1.500 | 55296.7 |
298 | 2023-08-06 05:26:07 | climbers | 1 | 82945 | 5 | 1.250 | 66356.0 |
297 | 2023-08-05 00:12:50 | climbers | 1 | 82945 | 5 | 1.436 | 57761.1 |
296 | 2023-07-21 12:18:39 | climbers | 3 | 146162 | 313 | 6.236 | 23438.4 |
295 | 2023-04-30 22:03:14 | climbers | 1 | 82945 | 5 | 1.406 | 58993.6 |
294 | 2023-04-27 12:36:04 | climbers | 1 | 82945 | 5 | 1.326 | 62552.8 |
293 | 2023-04-02 06:50:43 | climbers | 3 | 146162 | 313 | 7.253 | 20151.9 |
292 | 2023-02-23 15:51:42 | climbers | 1 | 82945 | 5 | 1.283 | 64649.3 |
291 | 2023-01-18 21:36:07 | climbers | 1 | 82945 | 5 | 1.263 | 65673.0 |
290 | 2022-12-29 05:44:26 | climbers | 3 | 146162 | 313 | 6.876 | 21256.8 |
289 | 2022-12-29 02:17:15 | climbers | 3 | 146162 | 313 | 7.516 | 19446.8 |
288 | 2022-12-20 22:13:08 | climbers | 1 | 82945 | 5 | 1.250 | 66356.0 |
287 | 2022-11-26 03:32:52 | climbers | 1 | 82945 | 5 | 1.280 | 64800.8 |
286 | 2022-11-13 00:38:12 | climbers | 3 | 146162 | 313 | 6.063 | 24107.2 |
285 | 2022-10-26 10:08:09 | climbers | 3 | 146162 | 313 | 7.110 | 20557.2 |
284 | 2022-10-01 04:53:38 | climbers | 1 | 82945 | 5 | 1.420 | 58412.0 |
283 | 2022-09-29 06:57:02 | climbers | 3 | 146162 | 313 | 6.670 | 21913.3 |
282 | 2022-09-01 23:12:37 | climbers | 1 | 82945 | 5 | 1.436 | 57761.1 |
281 | 2022-08-30 17:04:31 | climbers | 1 | 82945 | 5 | 1.250 | 66356.0 |
280 | 2022-08-28 21:30:44 | climbers | 3 | 146162 | 313 | 6.110 | 23921.8 |
279 | 2022-06-26 16:29:56 | climbers | 1 | 82945 | 5 | 1.280 | 64800.8 |
278 | 2022-06-06 23:26:20 | climbers | 1 | 82945 | 5 | 1.296 | 64000.8 |
277 | 2022-04-17 08:35:36 | climbers | 1 | 82945 | 5 | 1.280 | 64800.8 |
276 | 2022-03-25 22:03:03 | climbers | 3 | 146162 | 313 | 6.796 | 21507.1 |
275 | 2022-02-23 14:34:19 | climbers | 1 | 82945 | 5 | 1.766 | 46967.7 |
274 | 2022-01-15 05:55:27 | climbers | 1 | 82945 | 5 | 1.420 | 58412.0 |
273 | 2022-01-13 01:26:50 | climbers | 1 | 82945 | 5 | 1.486 | 55817.6 |
272 | 2021-12-16 14:05:51 | climbers | 1 | 82945 | 5 | 1.280 | 64800.8 |
271 | 2021-12-08 17:06:26 | climbers | 1 | 82945 | 5 | 1.563 | 53067.8 |
270 | 2021-12-07 17:52:48 | climbers | 1 | 82945 | 5 | 1.453 | 57085.3 |
269 | 2021-12-06 22:52:47 | climbers | 1 | 82945 | 5 | 1.440 | 57600.7 |
268 | 2021-12-05 16:08:59 | climbers | 1 | 82945 | 5 | 1.780 | 46598.3 |
267 | 2021-11-23 12:25:16 | climbers | 1 | 82945 | 5 | 1.313 | 63172.1 |
266 | 2021-11-19 23:02:53 | climbers | 1 | 82945 | 5 | 1.410 | 58826.2 |
265 | 2021-11-15 10:22:14 | climbers | 1 | 82945 | 5 | 1.390 | 59672.7 |
264 | 2021-09-11 14:18:11 | climbers | 1 | 82945 | 5 | 1.406 | 58993.6 |
263 | 2021-08-27 03:27:38 | climbers | 1 | 82945 | 5 | 1.283 | 64649.3 |
262 | 2021-08-12 14:17:20 | climbers | 1 | 82945 | 5 | 1.390 | 59672.7 |
261 | 2021-07-06 06:58:58 | climbers | 1 | 82945 | 5 | 1.423 | 58288.8 |
260 | 2021-05-05 01:20:13 | climbers | 1 | 82945 | 5 | 1.466 | 56579.1 |
259 | 2021-05-02 04:55:03 | climbers | 1 | 82945 | 5 | 1.533 | 54106.3 |
258 | 2021-04-20 17:25:23 | climbers | 1 | 82945 | 5 | 1.470 | 56425.2 |
257 | 2021-03-23 09:39:45 | climbers | 1 | 82945 | 5 | 1.626 | 51011.7 |
256 | 2021-02-17 05:19:02 | climbers | 1 | 82945 | 5 | 1.436 | 57761.1 |
255 | 2021-02-02 12:11:11 | climbers | 1 | 82945 | 5 | 1.296 | 64000.8 |
254 | 2021-02-01 19:15:00 | climbers | 1 | 82945 | 5 | 1.296 | 64000.8 |
253 | 2021-01-27 23:23:38 | climbers | 1 | 82945 | 5 | 1.280 | 64800.8 |
252 | 2020-10-31 14:57:01 | climbers | 1 | 82945 | 5 | 1.440 | 57600.7 |
251 | 2020-10-27 20:41:20 | climbers | 1 | 82945 | 5 | 1.313 | 63172.1 |
250 | 2020-08-01 16:00:24 | climbers | 1 | 82945 | 5 | 1.343 | 61761.0 |
249 | 2020-07-26 01:36:35 | climbers | 1 | 82945 | 5 | 1.360 | 60989.0 |
248 | 2020-04-30 04:40:14 | climbers | 1 | 82945 | 5 | 1.313 | 63172.1 |
247 | 2020-04-01 01:37:13 | climbers | 1 | 82945 | 5 | 1.280 | 64800.8 |
246 | 2020-03-24 15:49:48 | climbers | 1 | 82945 | 5 | 2.766 | 29987.3 |
245 | 2020-03-22 10:51:40 | climbers | 1 | 82945 | 5 | 1.703 | 48705.2 |
244 | 2020-03-05 21:10:29 | climbers | 1 | 82945 | 5 | 1.546 | 53651.4 |
243 | 2020-02-29 16:52:59 | climbers | 1 | 82945 | 5 | 1.576 | 52630.1 |
242 | 2020-02-27 13:17:19 | climbers | 1 | 82945 | 5 | 1.530 | 54212.4 |
241 | 2020-02-11 17:51:37 | climbers | 1 | 82945 | 5 | 1.530 | 54212.4 |
240 | 2020-02-09 14:32:41 | climbers | 1 | 82945 | 5 | 1.673 | 49578.6 |
239 | 2020-02-01 13:49:52 | climbers | 1 | 82945 | 5 | 2.203 | 37650.9 |
238 | 2020-02-01 07:36:08 | climbers | 1 | 82945 | 5 | 1.440 | 57600.7 |
237 | 2020-01-29 06:06:40 | climbers | 1 | 82945 | 5 | 1.640 | 50576.2 |
236 | 2020-01-29 00:22:42 | climbers | 1 | 82945 | 5 | 3.033 | 27347.5 |
235 | 2020-01-28 19:55:11 | climbers | 1 | 82945 | 5 | 2.923 | 28376.7 |
234 | 2020-01-28 06:46:26 | climbers | 1 | 82945 | 5 | 2.343 | 35401.2 |
233 | 2020-01-22 04:40:13 | climbers | 1 | 82945 | 5 | 1.403 | 59119.7 |