History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bassett"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
393 | 2024-04-30 07:18:53 | bassett | 1 | 69583 | 4 | 1.390 | 50059.7 |
392 | 2024-04-27 04:36:12 | bassett | 1 | 69583 | 4 | 2.063 | 33729.0 |
391 | 2024-04-22 02:04:53 | bassett | 3 | 134027 | 180 | 25.173 | 5324.2 |
390 | 2024-04-20 22:43:19 | bassett | 3 | 134027 | 180 | 24.440 | 5483.9 |
389 | 2024-04-20 01:42:59 | bassett | 3 | 134027 | 180 | 15.326 | 8745.1 |
388 | 2024-04-13 12:27:44 | bassett | 2 | 107671 | 18 | 3.220 | 33438.2 |
387 | 2024-04-13 10:45:44 | bassett | 3 | 134027 | 180 | 8.203 | 16338.8 |
386 | 2024-04-13 04:27:12 | bassett | 2 | 107671 | 18 | 8.360 | 12879.3 |
385 | 2024-04-13 04:27:00 | bassett | 3 | 134027 | 180 | 7.813 | 17154.4 |
384 | 2024-04-13 01:23:49 | bassett | 2 | 107671 | 18 | 3.923 | 27446.1 |
383 | 2024-04-13 01:19:57 | bassett | 1 | 69583 | 4 | 1.250 | 55666.4 |
382 | 2024-04-13 01:19:41 | bassett | 3 | 134027 | 180 | 7.703 | 17399.3 |
381 | 2024-04-13 00:23:05 | bassett | 1 | 69583 | 4 | 1.846 | 37693.9 |
380 | 2024-04-10 16:47:34 | bassett | 1 | 69583 | 4 | 1.716 | 40549.5 |
379 | 2024-04-06 19:33:15 | bassett | 1 | 69583 | 4 | 2.690 | 25867.3 |
378 | 2024-03-25 03:54:06 | bassett | 2 | 107671 | 18 | 3.406 | 31612.2 |
377 | 2024-03-24 04:46:04 | bassett | 2 | 107671 | 18 | 2.846 | 37832.4 |
376 | 2024-03-11 01:44:05 | bassett | 2 | 107671 | 18 | 14.703 | 7323.1 |
375 | 2024-03-10 22:58:36 | bassett | 3 | 134027 | 180 | 7.516 | 17832.2 |
374 | 2024-03-10 18:55:23 | bassett | 3 | 134027 | 180 | 13.670 | 9804.5 |
373 | 2024-03-09 00:20:43 | bassett | 3 | 134027 | 180 | 14.863 | 9017.5 |
372 | 2024-03-09 00:20:44 | bassett | 2 | 107671 | 18 | 9.220 | 11678.0 |
371 | 2024-03-08 21:27:16 | bassett | 1 | 69583 | 4 | 1.500 | 46388.7 |
370 | 2024-03-06 06:00:14 | bassett | 1 | 69583 | 4 | 4.263 | 16322.5 |
369 | 2024-02-07 04:36:41 | bassett | 1 | 69583 | 4 | 1.186 | 58670.3 |
368 | 2024-02-02 04:39:28 | bassett | 2 | 107671 | 18 | 3.046 | 35348.3 |
367 | 2024-02-02 04:39:16 | bassett | 3 | 134027 | 180 | 6.966 | 19240.2 |
366 | 2024-02-01 21:09:12 | bassett | 2 | 107671 | 18 | 3.126 | 34443.7 |
365 | 2024-02-01 20:52:01 | bassett | 3 | 134027 | 180 | 6.466 | 20728.0 |
364 | 2024-02-01 02:23:20 | bassett | 2 | 107671 | 18 | 2.920 | 36873.6 |
363 | 2024-02-01 02:23:04 | bassett | 3 | 134027 | 180 | 6.953 | 19276.1 |
362 | 2024-02-01 01:07:00 | bassett | 3 | 134027 | 180 | 6.860 | 19537.5 |
361 | 2024-01-07 22:36:33 | bassett | 1 | 69583 | 4 | 1.126 | 61796.6 |
360 | 2023-12-25 18:21:04 | bassett | 1 | 69583 | 4 | 1.233 | 56433.9 |
359 | 2023-12-25 11:04:20 | bassett | 1 | 69583 | 4 | 1.153 | 60349.5 |
358 | 2023-12-16 21:54:31 | bassett | 1 | 69583 | 4 | 1.313 | 52995.4 |
357 | 2023-12-15 18:23:48 | bassett | 1 | 69583 | 4 | 1.096 | 63488.1 |
356 | 2023-12-02 15:28:11 | bassett | 2 | 107671 | 18 | 3.220 | 33438.2 |
355 | 2023-11-20 08:15:03 | bassett | 3 | 134027 | 180 | 7.610 | 17612.0 |
354 | 2023-11-20 07:28:53 | bassett | 1 | 69583 | 4 | 1.140 | 61037.7 |
353 | 2023-11-20 03:20:48 | bassett | 3 | 134027 | 180 | 6.123 | 21889.1 |
352 | 2023-11-08 10:15:11 | bassett | 3 | 134027 | 180 | 6.220 | 21547.7 |
351 | 2023-11-06 03:24:13 | bassett | 1 | 69583 | 4 | 1.266 | 54962.9 |
350 | 2023-11-05 21:59:14 | bassett | 1 | 69583 | 4 | 1.203 | 57841.2 |
349 | 2023-10-13 07:03:22 | bassett | 1 | 69583 | 4 | 1.203 | 57841.2 |
348 | 2023-09-22 23:36:10 | bassett | 1 | 69583 | 4 | 1.123 | 61961.7 |
347 | 2023-09-22 01:57:49 | bassett | 1 | 69583 | 4 | 1.203 | 57841.2 |
346 | 2023-09-01 06:57:43 | bassett | 2 | 107671 | 18 | 2.766 | 38926.6 |
345 | 2023-08-24 00:39:51 | bassett | 1 | 69583 | 4 | 2.186 | 31831.2 |
344 | 2023-08-12 15:09:42 | bassett | 3 | 134027 | 180 | 5.673 | 23625.4 |
343 | 2023-08-08 15:01:19 | bassett | 1 | 69583 | 4 | 1.983 | 35089.8 |
342 | 2023-05-19 14:11:06 | bassett | 2 | 107671 | 18 | 2.890 | 37256.4 |
341 | 2023-05-10 08:12:35 | bassett | 1 | 69583 | 4 | 1.203 | 57841.2 |
340 | 2023-05-08 18:57:23 | bassett | 1 | 69583 | 4 | 1.063 | 65459.1 |
339 | 2023-05-06 20:28:41 | bassett | 1 | 69583 | 4 | 1.173 | 59320.5 |
338 | 2023-04-22 01:45:26 | bassett | 3 | 134027 | 180 | 5.813 | 23056.4 |
337 | 2023-02-28 12:57:29 | bassett | 2 | 107671 | 18 | 2.800 | 38453.9 |
336 | 2023-02-26 02:20:18 | bassett | 1 | 69583 | 4 | 1.063 | 65459.1 |
335 | 2023-02-10 21:34:19 | bassett | 3 | 134027 | 180 | 5.956 | 22502.9 |
334 | 2023-01-25 15:01:37 | bassett | 3 | 134027 | 180 | 5.846 | 22926.3 |
333 | 2023-01-24 12:29:56 | bassett | 1 | 69583 | 4 | 1.063 | 65459.1 |
332 | 2022-12-22 20:10:17 | bassett | 1 | 69583 | 4 | 1.060 | 65644.3 |
331 | 2022-12-12 17:54:40 | bassett | 3 | 134027 | 180 | 13.516 | 9916.2 |
330 | 2022-12-12 16:01:50 | bassett | 3 | 134027 | 180 | 5.623 | 23835.5 |
329 | 2022-12-08 17:30:44 | bassett | 2 | 107671 | 18 | 2.830 | 38046.3 |
328 | 2022-11-05 21:11:09 | bassett | 3 | 134027 | 180 | 6.846 | 19577.4 |
327 | 2022-10-10 04:08:42 | bassett | 1 | 69583 | 4 | 1.093 | 63662.4 |
326 | 2022-09-10 11:28:54 | bassett | 1 | 69583 | 4 | 1.076 | 64668.2 |
325 | 2022-09-06 23:43:09 | bassett | 1 | 69583 | 4 | 1.076 | 64668.2 |
324 | 2022-09-04 20:20:53 | bassett | 1 | 69583 | 4 | 1.076 | 64668.2 |
323 | 2022-09-01 15:11:16 | bassett | 1 | 69583 | 4 | 1.203 | 57841.2 |
322 | 2022-07-17 02:55:20 | bassett | 2 | 107671 | 18 | 2.876 | 37437.8 |
321 | 2022-06-23 13:21:11 | bassett | 1 | 69583 | 4 | 1.190 | 58473.1 |
320 | 2022-06-19 19:33:59 | bassett | 1 | 69583 | 4 | 1.096 | 63488.1 |
319 | 2022-05-12 08:02:57 | bassett | 3 | 134027 | 180 | 5.813 | 23056.4 |
318 | 2022-04-18 02:35:48 | bassett | 1 | 69583 | 4 | 1.080 | 64428.7 |
317 | 2022-03-04 02:58:20 | bassett | 1 | 69583 | 4 | 1.330 | 52318.0 |
316 | 2022-02-28 17:10:33 | bassett | 1 | 69583 | 4 | 1.593 | 43680.5 |
315 | 2022-02-25 09:48:14 | bassett | 2 | 107671 | 18 | 3.046 | 35348.3 |
314 | 2022-01-11 20:24:25 | bassett | 3 | 134027 | 180 | 5.953 | 22514.2 |
313 | 2022-01-11 15:27:55 | bassett | 1 | 69583 | 4 | 1.140 | 61037.7 |
312 | 2022-01-09 12:06:36 | bassett | 1 | 69583 | 4 | 1.296 | 53690.6 |
311 | 2021-12-08 03:57:36 | bassett | 2 | 107671 | 18 | 3.390 | 31761.4 |
310 | 2021-11-17 03:45:57 | bassett | 1 | 69583 | 4 | 1.093 | 63662.4 |
309 | 2021-11-03 13:49:05 | bassett | 1 | 69583 | 4 | 1.093 | 63662.4 |
308 | 2021-10-22 11:01:43 | bassett | 3 | 134027 | 180 | 6.423 | 20866.7 |
307 | 2021-09-20 22:40:22 | bassett | 1 | 69583 | 4 | 1.126 | 61796.6 |
306 | 2021-09-18 18:30:23 | bassett | 1 | 69583 | 4 | 1.216 | 57222.9 |
305 | 2021-09-01 07:22:04 | bassett | 1 | 69583 | 4 | 1.500 | 46388.7 |
304 | 2021-08-10 21:51:34 | bassett | 1 | 69583 | 4 | 1.140 | 61037.7 |
303 | 2021-05-22 16:22:23 | bassett | 1 | 69583 | 4 | 1.250 | 55666.4 |
302 | 2021-05-06 15:28:04 | bassett | 1 | 69583 | 4 | 1.266 | 54962.9 |
301 | 2021-04-23 15:08:25 | bassett | 1 | 69583 | 4 | 1.250 | 55666.4 |
300 | 2021-03-25 18:14:57 | bassett | 1 | 69583 | 4 | 1.263 | 55093.4 |
299 | 2021-02-27 03:13:36 | bassett | 1 | 69583 | 4 | 1.250 | 55666.4 |
298 | 2021-01-31 09:56:57 | bassett | 1 | 69583 | 4 | 1.080 | 64428.7 |
297 | 2021-01-08 23:26:57 | bassett | 1 | 69583 | 4 | 1.160 | 59985.3 |
296 | 2020-11-23 19:54:31 | bassett | 1 | 69583 | 4 | 1.080 | 64428.7 |
295 | 2020-11-03 00:43:21 | bassett | 1 | 69583 | 4 | 1.110 | 62687.4 |
294 | 2020-11-01 06:40:30 | bassett | 1 | 69583 | 4 | 1.123 | 61961.7 |