History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bandora"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
379 | 2024-04-05 23:50:42 | bandora | 2 | 107671 | 18 | 15.373 | 7003.9 |
378 | 2024-04-05 17:14:54 | bandora | 2 | 107671 | 18 | 4.000 | 26917.8 |
377 | 2024-04-05 08:25:46 | bandora | 2 | 107671 | 18 | 3.656 | 29450.5 |
376 | 2024-04-01 16:50:47 | bandora | 3 | 134027 | 173 | 12.546 | 10682.8 |
375 | 2024-04-01 16:12:49 | bandora | 2 | 107671 | 18 | 5.326 | 20216.1 |
374 | 2024-04-01 16:05:57 | bandora | 2 | 107671 | 18 | 8.156 | 13201.4 |
373 | 2024-04-01 16:05:49 | bandora | 1 | 69583 | 4 | 1.296 | 53690.6 |
372 | 2024-04-01 16:05:37 | bandora | 3 | 134027 | 173 | 7.123 | 18816.1 |
371 | 2024-03-29 22:37:36 | bandora | 3 | 134027 | 173 | 24.113 | 5558.3 |
370 | 2024-03-29 07:21:03 | bandora | 3 | 134027 | 173 | 15.736 | 8517.2 |
369 | 2024-03-29 07:11:22 | bandora | 3 | 134027 | 173 | 20.940 | 6400.5 |
368 | 2024-03-29 06:35:52 | bandora | 3 | 134027 | 173 | 19.516 | 6867.5 |
367 | 2024-03-26 15:24:39 | bandora | 1 | 69583 | 4 | 1.750 | 39761.7 |
366 | 2023-12-19 20:58:31 | bandora | 1 | 69583 | 4 | 1.266 | 54962.9 |
365 | 2023-12-16 14:24:45 | bandora | 1 | 69583 | 4 | 2.720 | 25582.0 |
364 | 2023-12-07 09:47:34 | bandora | 1 | 69583 | 4 | 1.076 | 64668.2 |
363 | 2023-12-07 09:07:49 | bandora | 2 | 107671 | 18 | 2.876 | 37437.8 |
362 | 2023-12-02 12:06:01 | bandora | 1 | 69583 | 4 | 1.390 | 50059.7 |
361 | 2023-11-18 12:33:39 | bandora | 1 | 69583 | 4 | 1.453 | 47889.2 |
360 | 2023-11-05 06:17:33 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
359 | 2023-10-13 14:53:55 | bandora | 1 | 69583 | 4 | 1.203 | 57841.2 |
358 | 2023-10-07 07:31:58 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
357 | 2023-09-03 22:49:35 | bandora | 2 | 107671 | 18 | 3.236 | 33272.9 |
356 | 2023-08-03 17:14:34 | bandora | 1 | 69583 | 4 | 1.203 | 57841.2 |
355 | 2023-08-01 14:27:49 | bandora | 1 | 69583 | 4 | 1.220 | 57035.2 |
354 | 2023-04-30 18:32:18 | bandora | 1 | 69583 | 4 | 1.220 | 57035.2 |
353 | 2023-04-24 05:07:23 | bandora | 1 | 69583 | 4 | 1.063 | 65459.1 |
352 | 2023-03-22 11:29:45 | bandora | 1 | 69583 | 4 | 1.186 | 58670.3 |
351 | 2023-02-25 16:07:26 | bandora | 1 | 69583 | 4 | 1.106 | 62914.1 |
350 | 2023-01-15 13:03:20 | bandora | 1 | 69583 | 4 | 1.186 | 58670.3 |
349 | 2023-01-14 10:04:54 | bandora | 2 | 107671 | 18 | 2.826 | 38100.1 |
348 | 2022-12-22 08:11:12 | bandora | 1 | 69583 | 4 | 1.186 | 58670.3 |
347 | 2022-11-22 07:52:13 | bandora | 3 | 134027 | 173 | 6.063 | 22105.7 |
346 | 2022-10-22 03:49:35 | bandora | 3 | 134027 | 173 | 6.296 | 21287.6 |
345 | 2022-10-16 03:39:32 | bandora | 2 | 107671 | 18 | 2.890 | 37256.4 |
344 | 2022-09-24 07:13:54 | bandora | 1 | 69583 | 4 | 1.076 | 64668.2 |
343 | 2022-09-20 17:01:07 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
342 | 2022-09-10 11:43:46 | bandora | 1 | 69583 | 4 | 1.173 | 59320.5 |
341 | 2022-09-09 04:52:29 | bandora | 3 | 134027 | 173 | 5.830 | 22989.2 |
340 | 2022-09-07 01:00:41 | bandora | 1 | 69583 | 4 | 1.096 | 63488.1 |
339 | 2022-08-15 15:54:21 | bandora | 1 | 69583 | 4 | 1.203 | 57841.2 |
338 | 2022-08-09 16:29:06 | bandora | 1 | 69583 | 4 | 1.200 | 57985.8 |
337 | 2022-07-18 09:50:38 | bandora | 1 | 69583 | 4 | 1.063 | 65459.1 |
336 | 2022-07-17 21:34:18 | bandora | 1 | 69583 | 4 | 1.280 | 54361.7 |
335 | 2022-07-02 08:09:03 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
334 | 2022-06-16 20:00:25 | bandora | 1 | 69583 | 4 | 1.076 | 64668.2 |
333 | 2022-06-15 18:57:25 | bandora | 1 | 69583 | 4 | 1.173 | 59320.5 |
332 | 2022-06-08 13:40:49 | bandora | 1 | 69583 | 4 | 1.080 | 64428.7 |
331 | 2022-06-01 18:03:52 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
330 | 2022-06-01 11:36:04 | bandora | 1 | 69583 | 4 | 2.470 | 28171.3 |
329 | 2022-05-25 14:56:33 | bandora | 1 | 69583 | 4 | 1.373 | 50679.5 |
328 | 2022-05-25 04:19:25 | bandora | 1 | 69583 | 4 | 1.110 | 62687.4 |
327 | 2022-05-21 17:42:46 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
326 | 2022-05-17 09:49:37 | bandora | 2 | 107671 | 18 | 3.720 | 28943.8 |
325 | 2022-05-15 04:57:24 | bandora | 2 | 107671 | 18 | 3.343 | 32207.9 |
324 | 2022-04-18 03:43:29 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
323 | 2022-04-01 16:11:52 | bandora | 3 | 134027 | 173 | 5.750 | 23309.0 |
322 | 2022-02-10 01:43:11 | bandora | 1 | 69583 | 4 | 1.076 | 64668.2 |
321 | 2022-01-13 20:42:36 | bandora | 1 | 69583 | 4 | 1.360 | 51164.0 |
320 | 2022-01-12 12:18:10 | bandora | 2 | 107671 | 18 | 3.500 | 30763.1 |
319 | 2022-01-11 17:27:46 | bandora | 1 | 69583 | 4 | 1.140 | 61037.7 |
318 | 2021-11-07 22:44:41 | bandora | 1 | 69583 | 4 | 1.190 | 58473.1 |
317 | 2021-11-05 15:43:07 | bandora | 1 | 69583 | 4 | 1.203 | 57841.2 |
316 | 2021-11-02 09:41:47 | bandora | 1 | 69583 | 4 | 1.186 | 58670.3 |
315 | 2021-11-02 07:15:00 | bandora | 2 | 107671 | 18 | 2.970 | 36252.9 |
314 | 2021-10-05 19:36:40 | bandora | 1 | 69583 | 4 | 1.156 | 60192.9 |
313 | 2021-09-29 01:48:25 | bandora | 1 | 69583 | 4 | 1.233 | 56433.9 |
312 | 2021-09-28 02:12:40 | bandora | 1 | 69583 | 4 | 1.220 | 57035.2 |
311 | 2021-09-24 11:49:59 | bandora | 1 | 69583 | 4 | 1.190 | 58473.1 |
310 | 2021-08-02 14:14:20 | bandora | 1 | 69583 | 4 | 1.263 | 55093.4 |
309 | 2021-07-25 19:53:39 | bandora | 2 | 107671 | 18 | 2.830 | 38046.3 |
308 | 2021-05-24 08:41:20 | bandora | 1 | 69583 | 4 | 1.263 | 55093.4 |
307 | 2021-05-16 06:51:21 | bandora | 2 | 107671 | 18 | 3.686 | 29210.8 |
306 | 2021-05-01 05:53:50 | bandora | 1 | 69583 | 4 | 1.266 | 54962.9 |
305 | 2021-04-27 11:45:25 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
304 | 2021-04-20 21:03:13 | bandora | 1 | 69583 | 4 | 1.126 | 61796.6 |
303 | 2021-03-27 14:59:01 | bandora | 1 | 69583 | 4 | 1.236 | 56296.9 |
302 | 2021-02-18 06:59:35 | bandora | 2 | 107671 | 18 | 2.860 | 37647.2 |
301 | 2021-01-16 07:08:39 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
300 | 2021-01-10 21:25:06 | bandora | 1 | 69583 | 4 | 1.203 | 57841.2 |
299 | 2020-12-31 06:28:03 | bandora | 2 | 107671 | 18 | 2.936 | 36672.7 |
298 | 2020-10-31 23:01:55 | bandora | 3 | 134027 | 173 | 6.110 | 21935.7 |
297 | 2020-10-31 00:25:38 | bandora | 1 | 69583 | 4 | 1.203 | 57841.2 |
296 | 2020-10-29 21:53:22 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
295 | 2020-10-21 05:22:36 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
294 | 2020-10-20 17:58:55 | bandora | 1 | 69583 | 4 | 1.233 | 56433.9 |
293 | 2020-10-16 16:51:31 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
292 | 2020-10-13 17:35:56 | bandora | 2 | 107671 | 18 | 2.953 | 36461.6 |
291 | 2020-09-28 21:59:42 | bandora | 1 | 69583 | 4 | 1.106 | 62914.1 |
290 | 2020-09-05 11:54:35 | bandora | 1 | 69583 | 4 | 1.390 | 50059.7 |
289 | 2020-09-05 05:47:58 | bandora | 2 | 107671 | 18 | 3.030 | 35535.0 |
288 | 2020-09-01 11:51:54 | bandora | 2 | 107671 | 18 | 2.953 | 36461.6 |
287 | 2020-08-18 08:39:15 | bandora | 1 | 69583 | 4 | 1.236 | 56296.9 |
286 | 2020-08-15 11:33:43 | bandora | 1 | 69583 | 4 | 1.266 | 54962.9 |
285 | 2020-07-27 05:40:50 | bandora | 2 | 107671 | 18 | 2.986 | 36058.6 |
284 | 2020-07-16 15:29:02 | bandora | 1 | 69583 | 4 | 1.236 | 56296.9 |
283 | 2020-04-14 21:36:11 | bandora | 1 | 69583 | 4 | 1.140 | 61037.7 |
282 | 2020-04-10 18:08:13 | bandora | 1 | 69583 | 4 | 1.093 | 63662.4 |
281 | 2020-03-29 06:50:53 | bandora | 1 | 69583 | 4 | 1.343 | 51811.6 |
280 | 2020-03-29 02:50:13 | bandora | 1 | 69583 | 4 | 1.313 | 52995.4 |