History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"kayak"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
401 | 2024-03-13 14:29:31 | kayak | 1 | 28756 | 4 | 0.516 | 55728.7 |
400 | 2024-03-07 23:31:30 | kayak | 3 | 83667 | 576 | 9.030 | 9265.4 |
399 | 2024-03-07 08:04:18 | kayak | 3 | 83667 | 576 | 13.533 | 6182.4 |
398 | 2024-03-07 08:04:18 | kayak | 2 | 53800 | 47 | 5.046 | 10661.9 |
397 | 2024-03-07 07:30:09 | kayak | 1 | 28756 | 4 | 1.110 | 25906.3 |
396 | 2024-03-07 03:48:32 | kayak | 1 | 28756 | 4 | 1.220 | 23570.5 |
395 | 2024-02-26 01:38:19 | kayak | 1 | 28756 | 4 | 0.530 | 54256.6 |
394 | 2024-02-03 17:46:23 | kayak | 1 | 28756 | 4 | 0.483 | 59536.2 |
393 | 2024-01-29 05:32:19 | kayak | 1 | 28756 | 4 | 0.500 | 57512.0 |
392 | 2024-01-26 23:51:53 | kayak | 1 | 28756 | 4 | 0.530 | 54256.6 |
391 | 2024-01-06 05:33:23 | kayak | 3 | 83667 | 576 | 3.470 | 24111.5 |
390 | 2024-01-06 05:33:24 | kayak | 2 | 53800 | 47 | 1.500 | 35866.7 |
389 | 2024-01-05 03:49:03 | kayak | 3 | 83667 | 576 | 3.280 | 25508.2 |
388 | 2023-12-22 20:27:46 | kayak | 2 | 53800 | 47 | 1.390 | 38705.0 |
387 | 2023-12-14 15:41:57 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
386 | 2023-12-07 18:17:48 | kayak | 3 | 83667 | 576 | 3.906 | 21420.1 |
385 | 2023-12-07 18:17:44 | kayak | 3 | 83667 | 576 | 3.906 | 21420.1 |
384 | 2023-12-06 00:17:21 | kayak | 3 | 83667 | 576 | 4.030 | 20761.0 |
383 | 2023-12-06 00:17:16 | kayak | 2 | 53800 | 47 | 1.546 | 34799.5 |
382 | 2023-11-26 16:17:01 | kayak | 1 | 28756 | 4 | 0.466 | 61708.2 |
381 | 2023-11-23 15:29:29 | kayak | 1 | 28756 | 4 | 0.440 | 65354.5 |
380 | 2023-11-15 11:46:20 | kayak | 1 | 28756 | 4 | 0.420 | 68466.7 |
379 | 2023-11-08 11:42:36 | kayak | 1 | 28756 | 4 | 0.423 | 67981.1 |
378 | 2023-10-30 06:52:52 | kayak | 3 | 83667 | 576 | 4.376 | 19119.5 |
377 | 2023-10-28 20:43:23 | kayak | 1 | 28756 | 4 | 0.500 | 57512.0 |
376 | 2023-10-28 03:27:05 | kayak | 1 | 28756 | 4 | 0.483 | 59536.2 |
375 | 2023-10-20 01:51:45 | kayak | 1 | 28756 | 4 | 0.920 | 31256.5 |
374 | 2023-10-20 01:45:12 | kayak | 3 | 83667 | 576 | 4.123 | 20292.7 |
373 | 2023-10-13 11:37:16 | kayak | 3 | 83667 | 576 | 3.686 | 22698.6 |
372 | 2023-10-13 09:13:55 | kayak | 1 | 28756 | 4 | 0.470 | 61183.0 |
371 | 2023-10-05 19:35:35 | kayak | 1 | 28756 | 4 | 0.420 | 68466.7 |
370 | 2023-10-01 04:29:27 | kayak | 2 | 53800 | 47 | 1.830 | 29398.9 |
369 | 2023-10-01 00:43:04 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
368 | 2023-09-26 03:02:06 | kayak | 1 | 28756 | 4 | 0.453 | 63479.0 |
367 | 2023-09-23 12:42:01 | kayak | 2 | 53800 | 47 | 1.356 | 39675.5 |
366 | 2023-09-14 09:30:35 | kayak | 1 | 28756 | 4 | 0.500 | 57512.0 |
365 | 2023-07-28 07:04:49 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
364 | 2023-07-24 22:51:05 | kayak | 3 | 83667 | 576 | 3.263 | 25641.1 |
363 | 2023-07-05 01:07:21 | kayak | 1 | 28756 | 4 | 0.423 | 67981.1 |
362 | 2023-07-04 16:27:21 | kayak | 2 | 53800 | 47 | 1.593 | 33772.8 |
361 | 2023-04-25 13:59:19 | kayak | 1 | 28756 | 4 | 0.486 | 59168.7 |
360 | 2023-04-04 06:40:35 | kayak | 3 | 83667 | 576 | 3.190 | 26227.9 |
359 | 2023-03-25 05:23:46 | kayak | 2 | 53800 | 47 | 1.330 | 40451.1 |
358 | 2023-03-15 00:57:11 | kayak | 1 | 28756 | 4 | 0.466 | 61708.2 |
357 | 2023-02-15 19:09:52 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
356 | 2023-02-01 17:18:15 | kayak | 3 | 83667 | 576 | 3.596 | 23266.7 |
355 | 2023-01-03 06:42:12 | kayak | 3 | 83667 | 576 | 3.140 | 26645.5 |
354 | 2022-12-23 20:56:06 | kayak | 2 | 53800 | 47 | 1.330 | 40451.1 |
353 | 2022-12-16 22:47:32 | kayak | 3 | 83667 | 576 | 3.563 | 23482.2 |
352 | 2022-12-13 19:46:16 | kayak | 1 | 28756 | 4 | 0.420 | 68466.7 |
351 | 2022-11-26 21:56:31 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
350 | 2022-11-17 18:15:52 | kayak | 3 | 83667 | 576 | 3.110 | 26902.6 |
349 | 2022-11-02 17:22:22 | kayak | 3 | 83667 | 576 | 3.530 | 23701.7 |
348 | 2022-10-30 19:58:29 | kayak | 3 | 83667 | 576 | 3.796 | 22040.8 |
347 | 2022-10-30 08:51:07 | kayak | 3 | 83667 | 576 | 3.156 | 26510.5 |
346 | 2022-10-05 05:50:49 | kayak | 3 | 83667 | 576 | 3.173 | 26368.4 |
345 | 2022-09-19 18:41:31 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
344 | 2022-09-18 13:51:22 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
343 | 2022-09-10 05:51:15 | kayak | 3 | 83667 | 576 | 3.190 | 26227.9 |
342 | 2022-08-22 17:14:27 | kayak | 2 | 53800 | 47 | 1.373 | 39184.3 |
341 | 2022-08-18 09:18:29 | kayak | 1 | 28756 | 4 | 0.486 | 59168.7 |
340 | 2022-07-30 19:15:11 | kayak | 1 | 28756 | 4 | 0.466 | 61708.2 |
339 | 2022-07-10 04:26:37 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
338 | 2022-07-02 16:04:51 | kayak | 1 | 28756 | 4 | 0.423 | 67981.1 |
337 | 2022-04-09 00:34:37 | kayak | 1 | 28756 | 4 | 0.530 | 54256.6 |
336 | 2022-04-06 22:46:26 | kayak | 3 | 83667 | 576 | 3.546 | 23594.8 |
335 | 2022-04-05 06:15:03 | kayak | 1 | 28756 | 4 | 0.420 | 68466.7 |
334 | 2022-04-01 19:14:26 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
333 | 2022-03-20 07:09:47 | kayak | 2 | 53800 | 47 | 1.326 | 40573.2 |
332 | 2022-03-18 03:02:13 | kayak | 2 | 53800 | 47 | 1.703 | 31591.3 |
331 | 2022-01-12 17:46:40 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
330 | 2022-01-10 13:56:38 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
329 | 2022-01-08 12:03:56 | kayak | 1 | 28756 | 4 | 0.483 | 59536.2 |
328 | 2022-01-05 06:51:32 | kayak | 1 | 28756 | 4 | 0.563 | 51076.4 |
327 | 2021-12-21 09:31:00 | kayak | 1 | 28756 | 4 | 0.500 | 57512.0 |
326 | 2021-12-05 05:35:12 | kayak | 2 | 53800 | 47 | 1.390 | 38705.0 |
325 | 2021-11-04 13:52:27 | kayak | 1 | 28756 | 4 | 0.500 | 57512.0 |
324 | 2021-11-02 12:46:02 | kayak | 1 | 28756 | 4 | 0.470 | 61183.0 |
323 | 2021-10-04 16:54:03 | kayak | 1 | 28756 | 4 | 0.500 | 57512.0 |
322 | 2021-09-14 04:38:57 | kayak | 1 | 28756 | 4 | 0.470 | 61183.0 |
321 | 2021-09-10 23:38:07 | kayak | 1 | 28756 | 4 | 0.486 | 59168.7 |
320 | 2021-06-26 20:32:07 | kayak | 1 | 28756 | 4 | 0.470 | 61183.0 |
319 | 2021-06-10 02:43:03 | kayak | 1 | 28756 | 4 | 0.500 | 57512.0 |
318 | 2021-05-23 18:47:46 | kayak | 1 | 28756 | 4 | 0.500 | 57512.0 |
317 | 2021-05-21 04:48:43 | kayak | 1 | 28756 | 4 | 0.483 | 59536.2 |
316 | 2021-05-13 15:34:44 | kayak | 1 | 28756 | 4 | 0.500 | 57512.0 |
315 | 2021-03-07 16:17:24 | kayak | 1 | 28756 | 4 | 0.516 | 55728.7 |
314 | 2021-02-02 12:11:04 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
313 | 2021-01-31 17:52:35 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
312 | 2021-01-06 18:28:54 | kayak | 1 | 28756 | 4 | 0.483 | 59536.2 |
311 | 2020-12-03 21:17:25 | kayak | 1 | 28756 | 4 | 0.440 | 65354.5 |
310 | 2020-11-05 16:40:52 | kayak | 1 | 28756 | 4 | 0.500 | 57512.0 |
309 | 2020-11-03 07:14:04 | kayak | 1 | 28756 | 4 | 0.453 | 63479.0 |
308 | 2020-10-09 03:13:16 | kayak | 1 | 28756 | 4 | 0.486 | 59168.7 |
307 | 2020-09-29 22:29:54 | kayak | 1 | 28756 | 4 | 0.466 | 61708.2 |
306 | 2020-09-26 09:56:22 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
305 | 2020-09-07 08:34:21 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
304 | 2020-08-26 02:14:32 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
303 | 2020-08-22 22:46:13 | kayak | 1 | 28756 | 4 | 0.436 | 65954.1 |
302 | 2020-08-19 17:45:41 | kayak | 1 | 28756 | 4 | 0.453 | 63479.0 |