History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"twang"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
367 | 2024-03-07 06:39:02 | twang | 1 | 28756 | 5 | 1.106 | 26000.0 |
366 | 2024-02-28 13:07:44 | twang | 2 | 53800 | 91 | 1.546 | 34799.5 |
365 | 2024-02-28 13:07:41 | twang | 3 | 83667 | 938 | 3.640 | 22985.4 |
364 | 2024-02-28 07:23:52 | twang | 3 | 83667 | 938 | 6.080 | 13761.0 |
363 | 2024-02-28 07:23:53 | twang | 2 | 53800 | 91 | 3.580 | 15027.9 |
362 | 2024-02-28 07:23:47 | twang | 1 | 28756 | 5 | 1.550 | 18552.3 |
361 | 2024-02-03 23:29:59 | twang | 1 | 28756 | 5 | 0.436 | 65954.1 |
360 | 2024-01-31 10:14:24 | twang | 2 | 53800 | 91 | 1.576 | 34137.1 |
359 | 2024-01-31 10:13:52 | twang | 3 | 83667 | 938 | 3.906 | 21420.1 |
358 | 2024-01-31 01:16:03 | twang | 2 | 53800 | 91 | 1.546 | 34799.5 |
357 | 2024-01-31 01:15:23 | twang | 3 | 83667 | 938 | 4.000 | 20916.8 |
356 | 2024-01-29 19:42:37 | twang | 3 | 83667 | 938 | 3.830 | 21845.2 |
355 | 2024-01-29 04:46:01 | twang | 1 | 28756 | 5 | 0.436 | 65954.1 |
354 | 2024-01-19 23:07:01 | twang | 3 | 83667 | 938 | 3.923 | 21327.3 |
353 | 2024-01-15 20:59:32 | twang | 3 | 83667 | 938 | 3.906 | 21420.1 |
352 | 2024-01-05 01:23:30 | twang | 3 | 83667 | 938 | 3.703 | 22594.4 |
351 | 2024-01-05 01:23:28 | twang | 2 | 53800 | 91 | 1.643 | 32745.0 |
350 | 2023-12-27 08:32:45 | twang | 1 | 28756 | 5 | 0.440 | 65354.5 |
349 | 2023-12-10 20:02:05 | twang | 2 | 53800 | 91 | 1.610 | 33416.1 |
348 | 2023-12-06 09:44:24 | twang | 2 | 53800 | 91 | 1.550 | 34709.7 |
347 | 2023-11-26 05:46:17 | twang | 1 | 28756 | 5 | 0.483 | 59536.2 |
346 | 2023-11-21 19:54:13 | twang | 1 | 28756 | 5 | 0.453 | 63479.0 |
345 | 2023-11-18 16:11:11 | twang | 1 | 28756 | 5 | 0.483 | 59536.2 |
344 | 2023-11-16 01:26:02 | twang | 3 | 83667 | 938 | 3.610 | 23176.5 |
343 | 2023-11-11 14:38:30 | twang | 3 | 83667 | 938 | 3.593 | 23286.1 |
342 | 2023-11-08 03:07:34 | twang | 3 | 83667 | 938 | 3.470 | 24111.5 |
341 | 2023-10-31 11:34:02 | twang | 1 | 28756 | 5 | 0.500 | 57512.0 |
340 | 2023-10-20 11:38:55 | twang | 1 | 28756 | 5 | 0.453 | 63479.0 |
339 | 2023-10-18 18:36:21 | twang | 1 | 28756 | 5 | 0.483 | 59536.2 |
338 | 2023-10-11 16:01:19 | twang | 1 | 28756 | 5 | 0.436 | 65954.1 |
337 | 2023-10-03 16:13:20 | twang | 1 | 28756 | 5 | 0.436 | 65954.1 |
336 | 2023-09-26 21:27:59 | twang | 1 | 28756 | 5 | 0.483 | 59536.2 |
335 | 2023-09-14 02:43:19 | twang | 1 | 28756 | 5 | 0.466 | 61708.2 |
334 | 2023-09-03 03:38:49 | twang | 2 | 53800 | 91 | 1.373 | 39184.3 |
333 | 2023-08-13 09:42:25 | twang | 1 | 28756 | 5 | 0.466 | 61708.2 |
332 | 2023-08-12 22:57:37 | twang | 3 | 83667 | 938 | 3.376 | 24782.9 |
331 | 2023-05-21 08:01:29 | twang | 2 | 53800 | 91 | 1.343 | 40059.6 |
330 | 2023-05-16 09:32:10 | twang | 1 | 28756 | 5 | 0.440 | 65354.5 |
329 | 2023-04-27 05:33:19 | twang | 3 | 83667 | 938 | 3.250 | 25743.7 |
328 | 2023-04-21 02:08:52 | twang | 1 | 28756 | 5 | 0.420 | 68466.7 |
327 | 2023-03-24 10:04:37 | twang | 1 | 28756 | 5 | 0.423 | 67981.1 |
326 | 2023-03-14 15:04:23 | twang | 1 | 28756 | 5 | 0.470 | 61183.0 |
325 | 2023-02-26 01:38:43 | twang | 2 | 53800 | 91 | 1.483 | 36277.8 |
324 | 2023-02-03 23:02:26 | twang | 3 | 83667 | 938 | 3.266 | 25617.6 |
323 | 2023-01-30 22:36:33 | twang | 3 | 83667 | 938 | 3.156 | 26510.5 |
322 | 2023-01-02 00:03:22 | twang | 1 | 28756 | 5 | 0.420 | 68466.7 |
321 | 2022-12-24 17:57:55 | twang | 3 | 83667 | 938 | 3.623 | 23093.3 |
320 | 2022-12-11 11:20:23 | twang | 3 | 83667 | 938 | 3.690 | 22674.0 |
319 | 2022-12-05 14:34:47 | twang | 2 | 53800 | 91 | 1.330 | 40451.1 |
318 | 2022-11-26 07:49:55 | twang | 3 | 83667 | 938 | 3.673 | 22778.9 |
317 | 2022-11-12 05:30:58 | twang | 3 | 83667 | 938 | 3.626 | 23074.2 |
316 | 2022-10-27 08:08:00 | twang | 3 | 83667 | 938 | 3.576 | 23396.8 |
315 | 2022-09-26 07:53:24 | twang | 1 | 28756 | 5 | 0.423 | 67981.1 |
314 | 2022-09-01 03:07:25 | twang | 1 | 28756 | 5 | 0.483 | 59536.2 |
313 | 2022-08-27 17:31:06 | twang | 3 | 83667 | 938 | 3.486 | 24000.9 |
312 | 2022-07-26 19:28:11 | twang | 3 | 83667 | 938 | 3.330 | 25125.2 |
311 | 2022-06-26 09:52:36 | twang | 3 | 83667 | 938 | 3.190 | 26227.9 |
310 | 2022-06-14 23:11:26 | twang | 3 | 83667 | 938 | 3.203 | 26121.4 |
309 | 2022-05-11 07:26:00 | twang | 1 | 28756 | 5 | 0.500 | 57512.0 |
308 | 2022-05-09 03:01:05 | twang | 1 | 28756 | 5 | 0.466 | 61708.2 |
307 | 2022-04-11 12:10:06 | twang | 2 | 53800 | 91 | 2.093 | 25704.7 |
306 | 2022-04-10 18:39:50 | twang | 1 | 28756 | 5 | 0.500 | 57512.0 |
305 | 2022-01-23 18:26:17 | twang | 1 | 28756 | 5 | 0.483 | 59536.2 |
304 | 2021-12-22 04:28:16 | twang | 1 | 28756 | 5 | 0.516 | 55728.7 |
303 | 2021-11-10 20:24:11 | twang | 1 | 28756 | 5 | 0.440 | 65354.5 |
302 | 2021-10-20 21:45:13 | twang | 1 | 28756 | 5 | 0.466 | 61708.2 |
301 | 2021-09-21 08:25:12 | twang | 1 | 28756 | 5 | 0.483 | 59536.2 |
300 | 2021-09-20 22:02:32 | twang | 1 | 28756 | 5 | 0.500 | 57512.0 |
299 | 2021-09-20 04:49:14 | twang | 1 | 28756 | 5 | 0.423 | 67981.1 |
298 | 2021-09-13 18:01:23 | twang | 1 | 28756 | 5 | 0.486 | 59168.7 |
297 | 2021-06-15 17:15:41 | twang | 1 | 28756 | 5 | 1.016 | 28303.1 |
296 | 2021-05-24 10:36:51 | twang | 2 | 53800 | 91 | 1.360 | 39558.8 |
295 | 2021-04-27 14:15:43 | twang | 2 | 53800 | 91 | 3.046 | 17662.5 |
294 | 2021-04-04 16:48:52 | twang | 1 | 28756 | 5 | 0.516 | 55728.7 |
293 | 2021-03-25 11:19:59 | twang | 1 | 28756 | 5 | 0.483 | 59536.2 |
292 | 2021-02-05 20:03:38 | twang | 2 | 53800 | 91 | 1.486 | 36204.6 |
291 | 2021-02-05 09:35:34 | twang | 1 | 28756 | 5 | 0.436 | 65954.1 |
290 | 2021-01-08 15:42:48 | twang | 1 | 28756 | 5 | 0.453 | 63479.0 |
289 | 2020-10-27 06:31:51 | twang | 1 | 28756 | 5 | 0.440 | 65354.5 |
288 | 2020-10-25 13:02:30 | twang | 1 | 28756 | 5 | 0.500 | 57512.0 |
287 | 2020-09-17 11:35:49 | twang | 1 | 28756 | 5 | 0.466 | 61708.2 |
286 | 2020-08-22 13:09:40 | twang | 1 | 28756 | 5 | 0.546 | 52666.7 |
285 | 2020-03-25 23:00:42 | twang | 1 | 28756 | 5 | 0.500 | 57512.0 |
284 | 2020-03-25 16:09:02 | twang | 1 | 28756 | 5 | 0.923 | 31154.9 |
283 | 2020-03-25 07:57:11 | twang | 1 | 28756 | 5 | 0.530 | 54256.6 |
282 | 2020-03-23 19:56:13 | twang | 1 | 28756 | 5 | 1.046 | 27491.4 |
281 | 2020-03-22 20:59:04 | twang | 1 | 28756 | 5 | 0.483 | 59536.2 |
280 | 2020-03-22 05:53:23 | twang | 1 | 28756 | 5 | 0.436 | 65954.1 |
279 | 2020-03-22 04:47:44 | twang | 1 | 28756 | 5 | 0.500 | 57512.0 |
278 | 2020-03-20 20:22:36 | twang | 1 | 28756 | 5 | 0.470 | 61183.0 |
277 | 2020-03-17 21:54:54 | twang | 1 | 28756 | 5 | 0.486 | 59168.7 |
276 | 2020-02-28 00:23:45 | twang | 1 | 28756 | 5 | 0.513 | 56054.6 |
275 | 2020-02-25 01:18:18 | twang | 1 | 28756 | 5 | 1.046 | 27491.4 |
274 | 2020-02-13 06:44:28 | twang | 1 | 28756 | 5 | 1.563 | 18398.0 |
273 | 2020-02-05 14:50:09 | twang | 1 | 28756 | 5 | 0.470 | 61183.0 |
272 | 2020-02-04 06:40:10 | twang | 1 | 28756 | 5 | 0.500 | 57512.0 |
271 | 2020-02-03 02:52:10 | twang | 1 | 28756 | 5 | 1.606 | 17905.4 |
270 | 2020-01-30 18:14:54 | twang | 1 | 28756 | 5 | 0.500 | 57512.0 |
269 | 2020-01-27 07:18:45 | twang | 1 | 28756 | 5 | 0.546 | 52666.7 |
268 | 2020-01-21 19:57:00 | twang | 1 | 28756 | 5 | 0.530 | 54256.6 |