History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"offered"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
377 | 2024-05-01 00:58:38 | offered | 2 | 107671 | 24 | 7.033 | 15309.4 |
376 | 2024-04-30 23:19:50 | offered | 2 | 107671 | 24 | 3.156 | 34116.3 |
375 | 2024-04-29 14:05:52 | offered | 2 | 107671 | 24 | 5.170 | 20826.1 |
374 | 2024-04-29 14:05:35 | offered | 3 | 134027 | 219 | 8.186 | 16372.7 |
373 | 2024-04-28 20:34:28 | offered | 3 | 134027 | 219 | 10.733 | 12487.4 |
372 | 2024-04-28 04:21:17 | offered | 3 | 134027 | 219 | 7.483 | 17910.9 |
371 | 2024-04-25 11:04:16 | offered | 1 | 69583 | 4 | 2.656 | 26198.4 |
370 | 2024-04-10 03:34:20 | offered | 3 | 134027 | 219 | 10.703 | 12522.4 |
369 | 2024-03-30 02:08:20 | offered | 1 | 69583 | 4 | 3.860 | 18026.7 |
368 | 2024-03-29 05:51:45 | offered | 3 | 134027 | 219 | 15.956 | 8399.8 |
367 | 2024-03-29 05:51:46 | offered | 2 | 107671 | 24 | 6.220 | 17310.5 |
366 | 2024-03-28 09:12:34 | offered | 1 | 69583 | 4 | 1.030 | 67556.3 |
365 | 2024-03-25 09:31:53 | offered | 2 | 107671 | 24 | 2.670 | 40326.2 |
364 | 2024-03-25 09:30:25 | offered | 3 | 134027 | 219 | 6.420 | 20876.5 |
363 | 2024-03-20 19:41:19 | offered | 1 | 69583 | 4 | 1.233 | 56433.9 |
362 | 2024-03-20 19:40:47 | offered | 3 | 134027 | 219 | 8.860 | 15127.2 |
361 | 2024-03-20 19:40:48 | offered | 2 | 107671 | 24 | 3.516 | 30623.2 |
360 | 2024-03-20 19:40:30 | offered | 1 | 69583 | 4 | 1.216 | 57222.9 |
359 | 2024-02-28 15:29:02 | offered | 3 | 134027 | 219 | 61.490 | 2179.7 |
358 | 2024-02-28 15:28:57 | offered | 2 | 107671 | 24 | 7.143 | 15073.6 |
357 | 2024-02-27 17:50:28 | offered | 1 | 69583 | 4 | 1.233 | 56433.9 |
356 | 2024-02-26 13:30:43 | offered | 2 | 107671 | 24 | 3.093 | 34811.2 |
355 | 2024-02-26 13:30:31 | offered | 3 | 134027 | 219 | 6.563 | 20421.6 |
354 | 2024-02-22 16:35:26 | offered | 2 | 107671 | 24 | 4.686 | 22977.2 |
353 | 2024-02-22 14:08:39 | offered | 3 | 134027 | 219 | 19.406 | 6906.5 |
352 | 2024-02-18 08:58:59 | offered | 3 | 134027 | 219 | 15.283 | 8769.7 |
351 | 2024-02-18 08:58:55 | offered | 2 | 107671 | 24 | 7.750 | 13893.0 |
350 | 2024-02-18 02:12:01 | offered | 1 | 69583 | 4 | 1.156 | 60192.9 |
349 | 2024-01-18 18:13:16 | offered | 1 | 69583 | 4 | 1.203 | 57841.2 |
348 | 2023-12-11 22:13:55 | offered | 3 | 134027 | 219 | 6.610 | 20276.4 |
347 | 2023-12-07 19:54:40 | offered | 1 | 69583 | 4 | 1.046 | 66522.9 |
346 | 2023-12-04 11:58:32 | offered | 1 | 69583 | 4 | 1.186 | 58670.3 |
345 | 2023-12-02 11:37:23 | offered | 1 | 69583 | 4 | 1.186 | 58670.3 |
344 | 2023-11-12 22:23:20 | offered | 1 | 69583 | 4 | 1.156 | 60192.9 |
343 | 2023-11-06 01:28:23 | offered | 1 | 69583 | 4 | 1.046 | 66522.9 |
342 | 2023-10-12 05:33:56 | offered | 1 | 69583 | 4 | 1.123 | 61961.7 |
341 | 2023-09-22 23:54:18 | offered | 1 | 69583 | 4 | 1.220 | 57035.2 |
340 | 2023-09-22 08:47:42 | offered | 1 | 69583 | 4 | 1.046 | 66522.9 |
339 | 2023-09-11 22:49:30 | offered | 3 | 134027 | 219 | 5.546 | 24166.4 |
338 | 2023-09-08 15:00:52 | offered | 3 | 134027 | 219 | 5.533 | 24223.2 |
337 | 2023-08-22 20:27:26 | offered | 3 | 134027 | 219 | 6.110 | 21935.7 |
336 | 2023-07-18 06:41:44 | offered | 1 | 69583 | 4 | 1.050 | 66269.5 |
335 | 2023-07-14 15:04:23 | offered | 1 | 69583 | 4 | 1.126 | 61796.6 |
334 | 2023-06-23 01:51:39 | offered | 3 | 134027 | 219 | 6.610 | 20276.4 |
333 | 2023-05-26 17:39:22 | offered | 3 | 134027 | 219 | 5.423 | 24714.5 |
332 | 2023-04-20 22:06:04 | offered | 1 | 69583 | 4 | 1.106 | 62914.1 |
331 | 2023-03-23 08:20:12 | offered | 1 | 69583 | 4 | 1.076 | 64668.2 |
330 | 2023-03-06 08:17:57 | offered | 3 | 134027 | 219 | 5.390 | 24865.9 |
329 | 2023-02-11 17:20:24 | offered | 1 | 69583 | 4 | 1.063 | 65459.1 |
328 | 2022-12-13 16:32:32 | offered | 3 | 134027 | 219 | 5.390 | 24865.9 |
327 | 2022-12-09 00:22:13 | offered | 1 | 69583 | 4 | 1.046 | 66522.9 |
326 | 2022-11-21 22:20:10 | offered | 1 | 69583 | 4 | 1.173 | 59320.5 |
325 | 2022-09-22 07:30:02 | offered | 3 | 134027 | 219 | 6.076 | 22058.4 |
324 | 2022-09-07 17:48:51 | offered | 3 | 134027 | 219 | 5.453 | 24578.6 |
323 | 2022-08-28 21:08:36 | offered | 3 | 134027 | 219 | 5.500 | 24368.5 |
322 | 2022-08-11 08:59:25 | offered | 1 | 69583 | 4 | 1.046 | 66522.9 |
321 | 2022-08-08 23:45:10 | offered | 1 | 69583 | 4 | 1.046 | 66522.9 |
320 | 2022-07-31 18:30:06 | offered | 3 | 134027 | 219 | 6.500 | 20619.5 |
319 | 2022-07-21 23:58:09 | offered | 1 | 69583 | 4 | 1.046 | 66522.9 |
318 | 2022-04-17 04:34:42 | offered | 1 | 69583 | 4 | 1.296 | 53690.6 |
317 | 2022-03-24 08:11:08 | offered | 1 | 69583 | 4 | 1.063 | 65459.1 |
316 | 2022-03-06 18:09:02 | offered | 3 | 134027 | 219 | 6.033 | 22215.6 |
315 | 2022-02-18 14:36:28 | offered | 1 | 69583 | 4 | 1.140 | 61037.7 |
314 | 2021-12-31 08:50:57 | offered | 3 | 134027 | 219 | 6.893 | 19443.9 |
313 | 2021-12-03 17:56:20 | offered | 1 | 69583 | 4 | 1.233 | 56433.9 |
312 | 2021-12-01 15:32:11 | offered | 1 | 69583 | 4 | 1.220 | 57035.2 |
311 | 2021-11-30 12:36:41 | offered | 3 | 134027 | 219 | 5.516 | 24297.9 |
310 | 2021-11-30 07:05:43 | offered | 1 | 69583 | 4 | 1.046 | 66522.9 |
309 | 2021-11-14 12:16:12 | offered | 3 | 134027 | 219 | 6.110 | 21935.7 |
308 | 2021-11-13 19:21:05 | offered | 3 | 134027 | 219 | 6.720 | 19944.5 |
307 | 2021-11-13 12:23:22 | offered | 3 | 134027 | 219 | 6.593 | 20328.7 |
306 | 2021-11-12 12:20:57 | offered | 3 | 134027 | 219 | 6.923 | 19359.7 |
305 | 2021-10-30 13:19:57 | offered | 3 | 134027 | 219 | 7.313 | 18327.2 |
304 | 2021-10-29 09:51:48 | offered | 3 | 134027 | 219 | 6.873 | 19500.5 |
303 | 2021-10-28 15:36:43 | offered | 3 | 134027 | 219 | 6.733 | 19906.0 |
302 | 2021-10-27 16:35:24 | offered | 3 | 134027 | 219 | 6.563 | 20421.6 |
301 | 2021-10-27 11:40:34 | offered | 1 | 69583 | 4 | 1.046 | 66522.9 |
300 | 2021-10-14 16:15:37 | offered | 3 | 134027 | 219 | 6.686 | 20045.9 |
299 | 2021-10-09 11:35:55 | offered | 3 | 134027 | 219 | 5.923 | 22628.2 |
298 | 2021-10-08 09:59:49 | offered | 3 | 134027 | 219 | 5.673 | 23625.4 |
297 | 2021-10-07 11:50:40 | offered | 3 | 134027 | 219 | 5.670 | 23637.9 |
296 | 2021-10-06 12:15:30 | offered | 3 | 134027 | 219 | 6.576 | 20381.2 |
295 | 2021-10-05 09:52:00 | offered | 3 | 134027 | 219 | 6.186 | 21666.2 |
294 | 2021-10-04 14:04:19 | offered | 3 | 134027 | 219 | 5.890 | 22755.0 |
293 | 2021-10-03 09:33:22 | offered | 3 | 134027 | 219 | 5.453 | 24578.6 |
292 | 2021-10-02 11:47:06 | offered | 3 | 134027 | 219 | 6.876 | 19492.0 |
291 | 2021-09-30 18:42:43 | offered | 3 | 134027 | 219 | 6.483 | 20673.6 |
290 | 2021-09-29 19:46:46 | offered | 3 | 134027 | 219 | 6.266 | 21389.6 |
289 | 2021-09-28 14:09:35 | offered | 3 | 134027 | 219 | 5.826 | 23005.0 |
288 | 2021-09-27 16:33:39 | offered | 3 | 134027 | 219 | 8.110 | 16526.1 |
287 | 2021-09-18 10:28:44 | offered | 3 | 134027 | 219 | 6.953 | 19276.1 |
286 | 2021-09-17 09:32:41 | offered | 3 | 134027 | 219 | 6.110 | 21935.7 |
285 | 2021-09-16 19:48:28 | offered | 3 | 134027 | 219 | 6.343 | 21129.9 |
284 | 2021-09-15 12:05:02 | offered | 3 | 134027 | 219 | 5.936 | 22578.7 |
283 | 2021-09-14 12:18:04 | offered | 3 | 134027 | 219 | 5.563 | 24092.6 |
282 | 2021-09-08 10:46:58 | offered | 3 | 134027 | 219 | 6.250 | 21444.3 |
281 | 2021-09-07 16:47:28 | offered | 3 | 134027 | 219 | 5.643 | 23751.0 |
280 | 2021-09-06 21:48:15 | offered | 3 | 134027 | 219 | 6.076 | 22058.4 |
279 | 2021-08-17 07:15:29 | offered | 1 | 69583 | 4 | 1.063 | 65459.1 |
278 | 2021-07-28 21:24:26 | offered | 3 | 134027 | 219 | 8.300 | 16147.8 |