History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"entrants"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
350 | 2024-04-26 09:56:34 | entrants | 2 | 121059 | 20 | 8.513 | 14220.5 |
349 | 2024-04-26 09:44:33 | entrants | 3 | 146162 | 155 | 7.563 | 19325.9 |
348 | 2024-04-26 02:15:48 | entrants | 2 | 121059 | 20 | 5.640 | 21464.4 |
347 | 2024-04-25 22:24:01 | entrants | 3 | 146162 | 155 | 11.516 | 12692.1 |
346 | 2024-04-25 20:42:41 | entrants | 3 | 146162 | 155 | 21.533 | 6787.8 |
345 | 2024-04-25 14:54:00 | entrants | 3 | 146162 | 155 | 7.190 | 20328.5 |
344 | 2024-04-25 14:53:56 | entrants | 2 | 121059 | 20 | 3.656 | 33112.4 |
343 | 2024-04-24 19:39:59 | entrants | 3 | 146162 | 155 | 17.173 | 8511.2 |
342 | 2024-04-24 19:39:59 | entrants | 2 | 121059 | 20 | 6.860 | 17647.1 |
341 | 2024-04-24 18:35:05 | entrants | 1 | 82945 | 3 | 1.453 | 57085.3 |
340 | 2024-04-01 01:23:55 | entrants | 1 | 82945 | 3 | 3.203 | 25896.0 |
339 | 2024-03-25 22:33:21 | entrants | 2 | 121059 | 20 | 3.216 | 37642.7 |
338 | 2024-03-24 02:54:55 | entrants | 3 | 146162 | 155 | 9.376 | 15589.0 |
337 | 2024-03-24 02:54:54 | entrants | 2 | 121059 | 20 | 3.890 | 31120.6 |
336 | 2024-03-24 02:54:55 | entrants | 1 | 82945 | 3 | 1.516 | 54713.1 |
335 | 2024-03-09 19:18:51 | entrants | 1 | 82945 | 3 | 1.736 | 47779.4 |
334 | 2024-03-09 19:18:34 | entrants | 3 | 146162 | 155 | 9.486 | 15408.2 |
333 | 2024-03-08 14:44:10 | entrants | 3 | 146162 | 155 | 16.766 | 8717.8 |
332 | 2024-03-02 10:54:56 | entrants | 2 | 121059 | 20 | 4.300 | 28153.3 |
331 | 2024-03-02 05:42:01 | entrants | 3 | 146162 | 155 | 12.376 | 11810.1 |
330 | 2024-02-29 21:11:30 | entrants | 1 | 82945 | 3 | 1.486 | 55817.6 |
329 | 2024-02-26 12:19:39 | entrants | 2 | 121059 | 20 | 3.313 | 36540.6 |
328 | 2024-02-25 23:00:07 | entrants | 3 | 146162 | 155 | 26.236 | 5571.0 |
327 | 2024-02-22 16:15:33 | entrants | 3 | 146162 | 155 | 13.360 | 10940.3 |
326 | 2024-02-22 14:21:15 | entrants | 2 | 121059 | 20 | 7.970 | 15189.3 |
325 | 2024-02-22 06:57:28 | entrants | 1 | 82945 | 3 | 1.266 | 65517.4 |
324 | 2024-02-12 21:56:58 | entrants | 1 | 82945 | 3 | 1.483 | 55930.5 |
323 | 2024-02-04 10:59:55 | entrants | 1 | 82945 | 3 | 4.733 | 17524.8 |
322 | 2024-01-09 03:14:30 | entrants | 2 | 121059 | 20 | 3.186 | 37997.2 |
321 | 2023-12-13 09:57:38 | entrants | 1 | 82945 | 3 | 1.343 | 61761.0 |
320 | 2023-12-09 23:01:12 | entrants | 1 | 82945 | 3 | 1.280 | 64800.8 |
319 | 2023-11-30 07:18:33 | entrants | 1 | 82945 | 3 | 1.266 | 65517.4 |
318 | 2023-11-19 09:26:38 | entrants | 1 | 82945 | 3 | 1.283 | 64649.3 |
317 | 2023-10-20 17:02:39 | entrants | 1 | 82945 | 3 | 1.263 | 65673.0 |
316 | 2023-10-17 20:35:37 | entrants | 2 | 121059 | 20 | 3.626 | 33386.4 |
315 | 2023-09-15 14:52:12 | entrants | 1 | 82945 | 3 | 1.533 | 54106.3 |
314 | 2023-09-14 20:06:42 | entrants | 1 | 82945 | 3 | 1.266 | 65517.4 |
313 | 2023-08-06 09:07:49 | entrants | 1 | 82945 | 3 | 1.280 | 64800.8 |
312 | 2023-07-28 10:04:21 | entrants | 2 | 121059 | 20 | 3.123 | 38763.7 |
311 | 2023-07-01 11:57:28 | entrants | 1 | 82945 | 3 | 1.876 | 44213.8 |
310 | 2023-04-21 11:29:00 | entrants | 1 | 82945 | 3 | 1.313 | 63172.1 |
309 | 2023-04-08 00:27:24 | entrants | 1 | 82945 | 3 | 1.250 | 66356.0 |
308 | 2023-04-07 11:55:25 | entrants | 2 | 121059 | 20 | 3.080 | 39304.9 |
307 | 2023-01-29 10:12:21 | entrants | 1 | 82945 | 3 | 1.233 | 67270.9 |
306 | 2023-01-05 07:46:07 | entrants | 1 | 82945 | 3 | 1.233 | 67270.9 |
305 | 2023-01-04 19:51:32 | entrants | 2 | 121059 | 20 | 3.076 | 39356.0 |
304 | 2022-12-18 20:17:51 | entrants | 1 | 82945 | 3 | 2.813 | 29486.3 |
303 | 2022-11-27 13:39:04 | entrants | 1 | 82945 | 3 | 1.250 | 66356.0 |
302 | 2022-11-18 11:05:14 | entrants | 1 | 82945 | 3 | 1.330 | 62364.7 |
301 | 2022-09-18 02:06:40 | entrants | 1 | 82945 | 3 | 1.343 | 61761.0 |
300 | 2022-09-08 16:00:55 | entrants | 2 | 121059 | 20 | 3.110 | 38925.7 |
299 | 2022-07-22 17:39:46 | entrants | 1 | 82945 | 3 | 1.436 | 57761.1 |
298 | 2022-07-20 10:03:16 | entrants | 1 | 82945 | 3 | 1.250 | 66356.0 |
297 | 2022-06-08 06:26:44 | entrants | 1 | 82945 | 3 | 1.403 | 59119.7 |
296 | 2022-04-21 18:52:25 | entrants | 1 | 82945 | 3 | 1.500 | 55296.7 |
295 | 2022-03-25 15:33:28 | entrants | 2 | 121059 | 20 | 3.266 | 37066.4 |
294 | 2022-03-24 19:06:08 | entrants | 2 | 121059 | 20 | 3.860 | 31362.4 |
293 | 2022-03-23 19:10:21 | entrants | 2 | 121059 | 20 | 4.423 | 27370.3 |
292 | 2022-03-23 06:36:28 | entrants | 2 | 121059 | 20 | 3.373 | 35890.6 |
291 | 2022-03-22 22:34:59 | entrants | 2 | 121059 | 20 | 3.936 | 30756.9 |
290 | 2022-03-13 13:26:02 | entrants | 1 | 82945 | 3 | 1.483 | 55930.5 |
289 | 2022-02-24 19:41:27 | entrants | 1 | 82945 | 3 | 1.890 | 43886.2 |
288 | 2022-01-21 14:32:16 | entrants | 2 | 121059 | 20 | 3.610 | 33534.3 |
287 | 2022-01-20 12:49:36 | entrants | 2 | 121059 | 20 | 3.720 | 32542.7 |
286 | 2022-01-19 19:21:58 | entrants | 2 | 121059 | 20 | 3.190 | 37949.5 |
285 | 2022-01-18 19:43:14 | entrants | 2 | 121059 | 20 | 3.830 | 31608.1 |
284 | 2022-01-13 13:09:32 | entrants | 2 | 121059 | 20 | 3.846 | 31476.6 |
283 | 2022-01-13 03:12:36 | entrants | 2 | 121059 | 20 | 6.343 | 19085.4 |
282 | 2022-01-12 10:23:12 | entrants | 2 | 121059 | 20 | 3.296 | 36729.1 |
281 | 2022-01-11 07:49:46 | entrants | 2 | 121059 | 20 | 8.393 | 14423.8 |
280 | 2022-01-10 18:29:18 | entrants | 2 | 121059 | 20 | 3.656 | 33112.4 |
279 | 2022-01-10 03:50:21 | entrants | 2 | 121059 | 20 | 3.766 | 32145.2 |
278 | 2022-01-09 16:34:51 | entrants | 2 | 121059 | 20 | 3.283 | 36874.5 |
277 | 2022-01-08 21:59:04 | entrants | 2 | 121059 | 20 | 3.876 | 31233.0 |
276 | 2022-01-08 06:31:03 | entrants | 2 | 121059 | 20 | 4.173 | 29010.1 |
275 | 2022-01-07 14:31:09 | entrants | 2 | 121059 | 20 | 4.140 | 29241.3 |
274 | 2022-01-06 23:23:34 | entrants | 2 | 121059 | 20 | 3.920 | 30882.4 |
273 | 2022-01-06 05:50:05 | entrants | 2 | 121059 | 20 | 3.360 | 36029.5 |
272 | 2022-01-05 16:26:22 | entrants | 2 | 121059 | 20 | 3.420 | 35397.4 |
271 | 2022-01-05 07:43:29 | entrants | 2 | 121059 | 20 | 3.420 | 35397.4 |
270 | 2022-01-04 17:01:22 | entrants | 2 | 121059 | 20 | 4.063 | 29795.5 |
269 | 2022-01-04 05:32:07 | entrants | 2 | 121059 | 20 | 3.673 | 32959.2 |
268 | 2022-01-03 15:57:17 | entrants | 2 | 121059 | 20 | 3.953 | 30624.6 |
267 | 2021-12-27 07:28:46 | entrants | 1 | 82945 | 3 | 1.296 | 64000.8 |
266 | 2021-12-25 21:06:20 | entrants | 1 | 82945 | 3 | 1.483 | 55930.5 |
265 | 2021-12-23 18:03:08 | entrants | 1 | 82945 | 3 | 1.436 | 57761.1 |
264 | 2021-12-17 14:18:21 | entrants | 2 | 121059 | 20 | 3.953 | 30624.6 |
263 | 2021-12-16 17:28:01 | entrants | 2 | 121059 | 20 | 3.470 | 34887.3 |
262 | 2021-12-15 20:06:53 | entrants | 2 | 121059 | 20 | 3.640 | 33258.0 |
261 | 2021-12-11 00:20:46 | entrants | 2 | 121059 | 20 | 3.860 | 31362.4 |
260 | 2021-12-10 01:04:50 | entrants | 2 | 121059 | 20 | 3.466 | 34927.6 |
259 | 2021-12-09 00:59:56 | entrants | 2 | 121059 | 20 | 3.546 | 34139.6 |
258 | 2021-12-08 00:10:42 | entrants | 2 | 121059 | 20 | 3.733 | 32429.4 |
257 | 2021-11-20 00:05:53 | entrants | 1 | 82945 | 3 | 1.346 | 61623.3 |
256 | 2021-11-12 08:54:12 | entrants | 1 | 82945 | 3 | 1.610 | 51518.6 |
255 | 2021-10-26 15:28:10 | entrants | 1 | 82945 | 3 | 1.530 | 54212.4 |
254 | 2021-09-27 00:10:50 | entrants | 2 | 121059 | 20 | 3.110 | 38925.7 |
253 | 2021-09-26 05:42:40 | entrants | 2 | 121059 | 20 | 3.140 | 38553.8 |
252 | 2021-09-21 16:21:33 | entrants | 1 | 82945 | 3 | 1.263 | 65673.0 |
251 | 2021-09-20 21:06:28 | entrants | 2 | 121059 | 20 | 3.203 | 37795.5 |