History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"amenities"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
422 | 2024-04-19 17:00:02 | amenities | 3 | 148641 | 101 | 10.780 | 13788.6 |
421 | 2024-04-19 16:59:58 | amenities | 2 | 121436 | 10 | 9.420 | 12891.3 |
420 | 2024-04-19 14:42:15 | amenities | 1 | 81242 | 2 | 1.640 | 49537.8 |
419 | 2024-04-15 01:35:03 | amenities | 1 | 81242 | 2 | 5.046 | 16100.3 |
418 | 2024-04-13 16:40:29 | amenities | 3 | 148641 | 101 | 15.783 | 9417.8 |
417 | 2024-04-10 10:35:56 | amenities | 3 | 148641 | 101 | 26.783 | 5549.8 |
416 | 2024-04-10 10:35:55 | amenities | 2 | 121436 | 10 | 13.486 | 9004.6 |
415 | 2024-04-10 09:08:19 | amenities | 1 | 81242 | 2 | 3.626 | 22405.4 |
414 | 2024-04-04 22:07:34 | amenities | 1 | 81242 | 2 | 1.423 | 57092.1 |
413 | 2024-04-01 09:13:43 | amenities | 1 | 81242 | 2 | 4.720 | 17212.3 |
412 | 2024-03-28 23:16:00 | amenities | 1 | 81242 | 2 | 2.970 | 27354.2 |
411 | 2024-03-22 12:25:10 | amenities | 3 | 148641 | 101 | 26.173 | 5679.2 |
410 | 2024-03-20 21:33:00 | amenities | 3 | 148641 | 101 | 10.016 | 14840.4 |
409 | 2024-03-20 03:26:11 | amenities | 3 | 148641 | 101 | 8.813 | 16866.1 |
408 | 2024-03-20 03:26:10 | amenities | 2 | 121436 | 10 | 8.203 | 14803.9 |
407 | 2024-03-20 03:16:13 | amenities | 1 | 81242 | 2 | 1.326 | 61268.5 |
406 | 2024-03-11 01:26:13 | amenities | 1 | 81242 | 2 | 4.390 | 18506.2 |
405 | 2024-02-27 20:25:56 | amenities | 1 | 81242 | 2 | 1.360 | 59736.8 |
404 | 2024-02-20 23:44:31 | amenities | 1 | 81242 | 2 | 1.500 | 54161.3 |
403 | 2024-02-03 04:19:57 | amenities | 2 | 121436 | 10 | 3.406 | 35653.6 |
402 | 2024-02-02 01:32:17 | amenities | 1 | 81242 | 2 | 1.203 | 67532.8 |
401 | 2024-01-28 17:45:31 | amenities | 1 | 81242 | 2 | 1.326 | 61268.5 |
400 | 2023-12-24 17:46:19 | amenities | 1 | 81242 | 2 | 1.406 | 57782.4 |
399 | 2023-12-17 07:49:41 | amenities | 1 | 81242 | 2 | 1.423 | 57092.1 |
398 | 2023-12-16 18:31:37 | amenities | 2 | 121436 | 10 | 3.593 | 33797.9 |
397 | 2023-12-13 03:47:26 | amenities | 3 | 148641 | 101 | 6.843 | 21721.6 |
396 | 2023-12-01 18:38:51 | amenities | 1 | 81242 | 2 | 1.203 | 67532.8 |
395 | 2023-11-29 00:16:46 | amenities | 1 | 81242 | 2 | 1.873 | 43375.3 |
394 | 2023-11-28 22:47:16 | amenities | 1 | 81242 | 2 | 1.250 | 64993.6 |
393 | 2023-11-10 21:06:39 | amenities | 2 | 121436 | 10 | 3.076 | 39478.5 |
392 | 2023-11-09 13:15:36 | amenities | 1 | 81242 | 2 | 1.233 | 65889.7 |
391 | 2023-11-04 11:20:04 | amenities | 1 | 81242 | 2 | 1.233 | 65889.7 |
390 | 2023-11-01 19:03:53 | amenities | 1 | 81242 | 2 | 1.360 | 59736.8 |
389 | 2023-10-11 11:48:06 | amenities | 1 | 81242 | 2 | 1.233 | 65889.7 |
388 | 2023-09-26 01:50:31 | amenities | 1 | 81242 | 2 | 1.356 | 59913.0 |
387 | 2023-09-12 16:29:44 | amenities | 1 | 81242 | 2 | 1.216 | 66810.9 |
386 | 2023-09-12 10:54:40 | amenities | 3 | 148641 | 101 | 6.673 | 22275.0 |
385 | 2023-08-13 14:11:01 | amenities | 2 | 121436 | 10 | 3.720 | 32644.1 |
384 | 2023-08-06 07:36:48 | amenities | 1 | 81242 | 2 | 1.203 | 67532.8 |
383 | 2023-07-22 10:14:54 | amenities | 1 | 81242 | 2 | 1.393 | 58321.6 |
382 | 2023-06-16 02:41:53 | amenities | 1 | 81242 | 2 | 1.220 | 66591.8 |
381 | 2023-06-06 11:40:22 | amenities | 3 | 148641 | 101 | 7.266 | 20457.1 |
380 | 2023-05-02 13:50:49 | amenities | 1 | 81242 | 2 | 1.250 | 64993.6 |
379 | 2023-04-27 22:11:57 | amenities | 1 | 81242 | 2 | 1.250 | 64993.6 |
378 | 2023-04-25 19:00:05 | amenities | 2 | 121436 | 10 | 4.923 | 24667.1 |
377 | 2023-04-10 18:34:25 | amenities | 1 | 81242 | 2 | 1.236 | 65729.8 |
376 | 2023-03-09 16:30:16 | amenities | 3 | 148641 | 101 | 6.500 | 22867.8 |
375 | 2023-02-23 05:32:10 | amenities | 1 | 81242 | 2 | 1.313 | 61875.1 |
374 | 2023-01-30 06:22:16 | amenities | 2 | 121436 | 10 | 3.313 | 36654.4 |
373 | 2023-01-30 06:11:30 | amenities | 2 | 121436 | 10 | 3.516 | 34538.1 |
372 | 2023-01-13 11:51:51 | amenities | 1 | 81242 | 2 | 1.233 | 65889.7 |
371 | 2023-01-01 19:57:19 | amenities | 1 | 81242 | 2 | 1.266 | 64172.2 |
370 | 2022-12-22 04:21:58 | amenities | 1 | 81242 | 2 | 1.203 | 67532.8 |
369 | 2022-12-12 17:38:28 | amenities | 3 | 148641 | 101 | 6.843 | 21721.6 |
368 | 2022-11-29 08:53:34 | amenities | 1 | 81242 | 2 | 1.203 | 67532.8 |
367 | 2022-11-15 04:09:30 | amenities | 1 | 81242 | 2 | 1.343 | 60492.9 |
366 | 2022-11-12 02:11:46 | amenities | 2 | 121436 | 10 | 3.263 | 37216.1 |
365 | 2022-10-13 01:19:42 | amenities | 1 | 81242 | 2 | 1.216 | 66810.9 |
364 | 2022-10-10 09:45:19 | amenities | 3 | 148641 | 101 | 6.266 | 23721.8 |
363 | 2022-10-03 18:01:31 | amenities | 1 | 81242 | 2 | 1.233 | 65889.7 |
362 | 2022-09-30 05:32:31 | amenities | 1 | 81242 | 2 | 1.220 | 66591.8 |
361 | 2022-09-18 07:45:03 | amenities | 1 | 81242 | 2 | 1.280 | 63470.3 |
360 | 2022-09-14 17:01:48 | amenities | 1 | 81242 | 2 | 1.233 | 65889.7 |
359 | 2022-09-05 00:55:21 | amenities | 1 | 81242 | 2 | 1.343 | 60492.9 |
358 | 2022-08-30 23:42:37 | amenities | 1 | 81242 | 2 | 1.360 | 59736.8 |
357 | 2022-08-24 15:53:08 | amenities | 3 | 148641 | 101 | 6.296 | 23608.8 |
356 | 2022-08-16 22:31:39 | amenities | 1 | 81242 | 2 | 1.216 | 66810.9 |
355 | 2022-07-31 11:58:45 | amenities | 3 | 148641 | 101 | 6.516 | 22811.7 |
354 | 2022-07-10 06:15:40 | amenities | 1 | 81242 | 2 | 1.250 | 64993.6 |
353 | 2022-07-03 23:27:05 | amenities | 1 | 81242 | 2 | 1.220 | 66591.8 |
352 | 2022-06-26 10:59:16 | amenities | 1 | 81242 | 2 | 1.203 | 67532.8 |
351 | 2022-06-02 15:04:40 | amenities | 2 | 121436 | 10 | 3.123 | 38884.4 |
350 | 2022-05-29 12:11:43 | amenities | 1 | 81242 | 2 | 1.406 | 57782.4 |
349 | 2022-05-22 20:39:42 | amenities | 1 | 81242 | 2 | 1.220 | 66591.8 |
348 | 2022-05-20 13:19:01 | amenities | 1 | 81242 | 2 | 1.236 | 65729.8 |
347 | 2022-05-08 20:11:06 | amenities | 1 | 81242 | 2 | 1.296 | 62686.7 |
346 | 2022-04-13 22:52:39 | amenities | 1 | 81242 | 2 | 1.436 | 56575.2 |
345 | 2022-04-11 18:07:37 | amenities | 1 | 81242 | 2 | 1.843 | 44081.4 |
344 | 2022-04-11 00:33:35 | amenities | 3 | 148641 | 101 | 6.173 | 24079.2 |
343 | 2022-04-04 02:01:04 | amenities | 1 | 81242 | 2 | 1.236 | 65729.8 |
342 | 2022-03-21 06:12:08 | amenities | 1 | 81242 | 2 | 1.360 | 59736.8 |
341 | 2022-03-08 16:17:24 | amenities | 3 | 148641 | 101 | 8.346 | 17809.8 |
340 | 2022-02-18 07:16:55 | amenities | 1 | 81242 | 2 | 1.343 | 60492.9 |
339 | 2022-01-09 16:29:33 | amenities | 1 | 81242 | 2 | 1.423 | 57092.1 |
338 | 2021-12-02 08:29:37 | amenities | 3 | 148641 | 101 | 10.610 | 14009.5 |
337 | 2021-11-30 07:01:22 | amenities | 3 | 148641 | 101 | 6.733 | 22076.5 |
336 | 2021-11-13 14:53:37 | amenities | 1 | 81242 | 2 | 1.470 | 55266.7 |
335 | 2021-11-09 21:24:24 | amenities | 1 | 81242 | 2 | 1.376 | 59042.2 |
334 | 2021-11-07 19:30:21 | amenities | 1 | 81242 | 2 | 1.220 | 66591.8 |
333 | 2021-10-30 12:13:41 | amenities | 1 | 81242 | 2 | 1.516 | 53589.7 |
332 | 2021-10-29 09:58:56 | amenities | 1 | 81242 | 2 | 1.653 | 49148.2 |
331 | 2021-10-28 15:22:48 | amenities | 1 | 81242 | 2 | 1.280 | 63470.3 |
330 | 2021-10-27 17:26:08 | amenities | 1 | 81242 | 2 | 1.390 | 58447.5 |
329 | 2021-10-21 12:42:16 | amenities | 1 | 81242 | 2 | 1.203 | 67532.8 |
328 | 2021-10-08 19:09:36 | amenities | 3 | 148641 | 101 | 6.096 | 24383.4 |
327 | 2021-09-27 11:25:53 | amenities | 1 | 81242 | 2 | 1.563 | 51978.2 |
326 | 2021-09-25 08:13:05 | amenities | 1 | 81242 | 2 | 1.390 | 58447.5 |
325 | 2021-09-18 14:16:05 | amenities | 3 | 148641 | 101 | 7.500 | 19818.8 |
324 | 2021-08-25 21:32:03 | amenities | 1 | 81242 | 2 | 1.220 | 66591.8 |
323 | 2021-08-23 17:45:02 | amenities | 1 | 81242 | 2 | 1.313 | 61875.1 |