History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affray"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
345 | 2024-05-07 03:26:11 | affray | 1 | 48755 | 2 | 1.966 | 24799.1 |
344 | 2024-05-06 22:18:59 | affray | 1 | 48755 | 2 | 0.890 | 54780.9 |
343 | 2024-05-06 02:23:09 | affray | 2 | 82551 | 10 | 2.733 | 30205.3 |
342 | 2024-05-06 02:22:45 | affray | 3 | 112716 | 162 | 12.766 | 8829.4 |
341 | 2024-05-03 23:15:57 | affray | 2 | 82551 | 10 | 2.813 | 29346.2 |
340 | 2024-05-02 11:07:13 | affray | 3 | 112716 | 162 | 15.483 | 7280.0 |
339 | 2024-05-01 16:55:09 | affray | 2 | 82551 | 10 | 2.610 | 31628.7 |
338 | 2024-05-01 16:54:45 | affray | 3 | 112716 | 162 | 7.830 | 14395.4 |
337 | 2024-05-01 16:42:32 | affray | 3 | 112716 | 162 | 9.830 | 11466.5 |
336 | 2024-05-01 11:57:27 | affray | 2 | 82551 | 10 | 2.420 | 34112.0 |
335 | 2024-05-01 11:57:23 | affray | 1 | 48755 | 2 | 0.860 | 56691.9 |
334 | 2024-05-01 11:57:11 | affray | 3 | 112716 | 162 | 7.750 | 14544.0 |
333 | 2024-05-01 08:58:12 | affray | 3 | 112716 | 162 | 5.530 | 20382.6 |
332 | 2024-04-30 09:09:47 | affray | 1 | 48755 | 2 | 2.530 | 19270.8 |
331 | 2024-04-05 21:25:55 | affray | 3 | 112716 | 162 | 9.766 | 11541.7 |
330 | 2024-04-05 21:25:54 | affray | 1 | 48755 | 2 | 0.876 | 55656.4 |
329 | 2024-04-05 21:25:48 | affray | 2 | 82551 | 10 | 2.703 | 30540.5 |
328 | 2024-04-03 15:22:00 | affray | 2 | 82551 | 10 | 3.406 | 24236.9 |
327 | 2024-04-01 09:49:44 | affray | 1 | 48755 | 2 | 1.923 | 25353.6 |
326 | 2024-04-01 09:49:29 | affray | 2 | 82551 | 10 | 3.656 | 22579.6 |
325 | 2024-03-30 19:36:14 | affray | 3 | 112716 | 162 | 11.750 | 9592.9 |
324 | 2024-03-29 08:32:11 | affray | 3 | 112716 | 162 | 7.736 | 14570.3 |
323 | 2024-03-29 06:10:32 | affray | 3 | 112716 | 162 | 10.530 | 10704.3 |
322 | 2024-03-29 06:10:31 | affray | 2 | 82551 | 10 | 8.093 | 10200.3 |
321 | 2024-03-29 06:10:28 | affray | 1 | 48755 | 2 | 2.750 | 17729.1 |
320 | 2024-03-10 12:35:11 | affray | 1 | 48755 | 2 | 2.423 | 20121.7 |
319 | 2024-03-10 03:29:24 | affray | 2 | 82551 | 10 | 2.940 | 28078.6 |
318 | 2024-03-10 03:28:46 | affray | 3 | 112716 | 162 | 14.893 | 7568.4 |
317 | 2024-03-07 01:22:04 | affray | 1 | 48755 | 2 | 0.876 | 55656.4 |
316 | 2024-03-06 23:06:16 | affray | 3 | 112716 | 162 | 13.016 | 8659.8 |
315 | 2024-03-06 15:51:21 | affray | 2 | 82551 | 10 | 3.250 | 25400.3 |
314 | 2024-03-06 15:08:58 | affray | 1 | 48755 | 2 | 1.906 | 25579.7 |
313 | 2024-03-05 23:45:50 | affray | 3 | 112716 | 162 | 11.016 | 10232.0 |
312 | 2024-02-28 01:34:46 | affray | 3 | 112716 | 162 | 8.610 | 13091.3 |
311 | 2024-02-28 01:34:47 | affray | 2 | 82551 | 10 | 2.953 | 27955.0 |
310 | 2024-02-28 01:34:42 | affray | 1 | 48755 | 2 | 1.546 | 31536.2 |
309 | 2023-12-26 08:29:30 | affray | 2 | 82551 | 10 | 2.063 | 40015.0 |
308 | 2023-12-26 08:29:24 | affray | 3 | 112716 | 162 | 4.516 | 24959.3 |
307 | 2023-12-25 09:11:50 | affray | 3 | 112716 | 162 | 9.160 | 12305.2 |
306 | 2023-12-13 05:59:58 | affray | 1 | 48755 | 2 | 0.826 | 59025.4 |
305 | 2023-11-28 16:58:37 | affray | 3 | 112716 | 162 | 5.220 | 21593.1 |
304 | 2023-11-23 22:32:43 | affray | 1 | 48755 | 2 | 0.766 | 63648.8 |
303 | 2023-11-12 22:11:57 | affray | 1 | 48755 | 2 | 0.830 | 58741.0 |
302 | 2023-11-03 15:12:48 | affray | 1 | 48755 | 2 | 0.860 | 56691.9 |
301 | 2023-10-25 02:00:50 | affray | 1 | 48755 | 2 | 0.750 | 65006.7 |
300 | 2023-10-20 23:15:37 | affray | 1 | 48755 | 2 | 0.796 | 61250.0 |
299 | 2023-10-20 16:26:16 | affray | 1 | 48755 | 2 | 1.686 | 28917.6 |
298 | 2023-10-17 05:57:31 | affray | 1 | 48755 | 2 | 1.796 | 27146.4 |
297 | 2023-10-13 11:36:12 | affray | 1 | 48755 | 2 | 1.716 | 28412.0 |
296 | 2023-10-05 06:14:49 | affray | 1 | 48755 | 2 | 0.813 | 59969.2 |
295 | 2023-10-03 09:36:38 | affray | 3 | 112716 | 162 | 12.563 | 8972.1 |
294 | 2023-10-01 00:15:46 | affray | 3 | 112716 | 162 | 6.016 | 18736.0 |
293 | 2023-09-29 10:35:30 | affray | 1 | 48755 | 2 | 0.826 | 59025.4 |
292 | 2023-09-26 06:58:52 | affray | 3 | 112716 | 162 | 4.690 | 24033.3 |
291 | 2023-09-24 13:15:16 | affray | 1 | 48755 | 2 | 0.843 | 57835.1 |
290 | 2023-09-12 20:19:42 | affray | 1 | 48755 | 2 | 1.686 | 28917.6 |
289 | 2023-07-27 05:47:15 | affray | 1 | 48755 | 2 | 0.843 | 57835.1 |
288 | 2023-07-05 18:56:38 | affray | 3 | 112716 | 162 | 4.533 | 24865.7 |
287 | 2023-06-26 14:25:34 | affray | 1 | 48755 | 2 | 0.750 | 65006.7 |
286 | 2023-04-24 10:06:27 | affray | 1 | 48755 | 2 | 0.766 | 63648.8 |
285 | 2023-04-20 14:33:39 | affray | 1 | 48755 | 2 | 0.750 | 65006.7 |
284 | 2023-03-31 13:48:05 | affray | 3 | 112716 | 162 | 5.140 | 21929.2 |
283 | 2023-03-25 18:19:03 | affray | 3 | 112716 | 162 | 4.516 | 24959.3 |
282 | 2023-03-07 13:15:14 | affray | 1 | 48755 | 2 | 0.750 | 65006.7 |
281 | 2023-02-14 21:25:12 | affray | 1 | 48755 | 2 | 0.810 | 60191.4 |
280 | 2023-01-18 04:05:39 | affray | 3 | 112716 | 162 | 5.233 | 21539.5 |
279 | 2022-12-24 12:51:51 | affray | 3 | 112716 | 162 | 4.923 | 22895.8 |
278 | 2022-12-21 09:18:37 | affray | 3 | 112716 | 162 | 4.860 | 23192.6 |
277 | 2022-12-13 02:14:57 | affray | 1 | 48755 | 2 | 0.733 | 66514.3 |
276 | 2022-12-04 06:52:11 | affray | 3 | 112716 | 162 | 8.063 | 13979.4 |
275 | 2022-11-15 14:47:16 | affray | 1 | 48755 | 2 | 0.843 | 57835.1 |
274 | 2022-10-28 10:53:29 | affray | 3 | 112716 | 162 | 4.546 | 24794.5 |
273 | 2022-08-22 08:41:16 | affray | 3 | 112716 | 162 | 4.576 | 24632.0 |
272 | 2022-08-17 20:17:01 | affray | 1 | 48755 | 2 | 1.046 | 46610.9 |
271 | 2022-08-15 11:30:22 | affray | 1 | 48755 | 2 | 0.750 | 65006.7 |
270 | 2022-07-19 01:18:45 | affray | 1 | 48755 | 2 | 0.783 | 62266.9 |
269 | 2022-04-06 10:14:37 | affray | 1 | 48755 | 2 | 0.766 | 63648.8 |
268 | 2022-03-14 17:56:31 | affray | 1 | 48755 | 2 | 0.936 | 52088.7 |
267 | 2022-01-11 08:03:04 | affray | 3 | 112716 | 162 | 5.610 | 20092.0 |
266 | 2022-01-10 00:11:16 | affray | 1 | 48755 | 2 | 0.856 | 56956.8 |
265 | 2022-01-03 18:47:59 | affray | 1 | 48755 | 2 | 0.860 | 56691.9 |
264 | 2021-11-27 13:32:48 | affray | 1 | 48755 | 2 | 0.920 | 52994.6 |
263 | 2021-11-08 05:41:15 | affray | 1 | 48755 | 2 | 0.763 | 63899.1 |
262 | 2021-11-07 16:59:59 | affray | 1 | 48755 | 2 | 0.860 | 56691.9 |
261 | 2021-11-06 05:01:55 | affray | 1 | 48755 | 2 | 0.750 | 65006.7 |
260 | 2021-10-08 11:02:32 | affray | 1 | 48755 | 2 | 0.733 | 66514.3 |
259 | 2021-08-24 17:27:18 | affray | 1 | 48755 | 2 | 0.733 | 66514.3 |
258 | 2021-07-06 22:58:54 | affray | 1 | 48755 | 2 | 0.843 | 57835.1 |
257 | 2021-05-20 16:35:19 | affray | 1 | 48755 | 2 | 0.906 | 53813.5 |
256 | 2021-04-28 05:04:20 | affray | 1 | 48755 | 2 | 0.860 | 56691.9 |
255 | 2021-02-18 03:29:56 | affray | 1 | 48755 | 2 | 0.766 | 63648.8 |
254 | 2021-01-11 09:33:32 | affray | 1 | 48755 | 2 | 0.783 | 62266.9 |
253 | 2020-11-14 10:34:04 | affray | 1 | 48755 | 2 | 0.766 | 63648.8 |
252 | 2020-11-14 00:05:25 | affray | 1 | 48755 | 2 | 0.846 | 57630.0 |
251 | 2020-10-29 23:57:33 | affray | 1 | 48755 | 2 | 0.750 | 65006.7 |
250 | 2020-10-24 18:56:08 | affray | 1 | 48755 | 2 | 0.750 | 65006.7 |
249 | 2020-10-21 23:51:55 | affray | 1 | 48755 | 2 | 0.813 | 59969.2 |
248 | 2020-09-06 00:27:36 | affray | 1 | 48755 | 2 | 0.783 | 62266.9 |
247 | 2020-08-09 19:01:43 | affray | 1 | 48755 | 2 | 0.780 | 62506.4 |
246 | 2020-06-02 08:13:42 | affray | 1 | 48755 | 2 | 1.013 | 48129.3 |