History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"burglary"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
463 | 2024-05-04 01:37:33 | burglary | 1 | 82945 | 3 | 1.500 | 55296.7 |
462 | 2024-04-29 10:29:54 | burglary | 4 | 161609 | 441 | 17.156 | 9420.0 |
461 | 2024-04-29 06:15:31 | burglary | 1 | 82945 | 3 | 2.356 | 35205.9 |
460 | 2024-04-28 15:43:09 | burglary | 4 | 161609 | 441 | 15.140 | 10674.3 |
459 | 2024-04-27 12:42:13 | burglary | 4 | 161609 | 441 | 12.000 | 13467.4 |
458 | 2024-04-27 05:55:14 | burglary | 4 | 161609 | 441 | 20.406 | 7919.7 |
457 | 2024-04-26 23:25:20 | burglary | 1 | 82945 | 3 | 2.186 | 37943.7 |
456 | 2024-04-26 23:24:55 | burglary | 4 | 161609 | 441 | 13.846 | 11671.9 |
455 | 2024-04-18 23:34:35 | burglary | 3 | 146162 | 50 | 25.783 | 5668.9 |
454 | 2024-04-06 09:22:21 | burglary | 3 | 146162 | 50 | 15.843 | 9225.7 |
453 | 2024-04-05 15:13:14 | burglary | 2 | 121059 | 4 | 12.110 | 9996.6 |
452 | 2024-04-05 11:53:52 | burglary | 1 | 82945 | 3 | 7.796 | 10639.4 |
451 | 2024-04-05 11:53:15 | burglary | 2 | 121059 | 4 | 9.656 | 12537.2 |
450 | 2024-04-05 06:52:47 | burglary | 3 | 146162 | 50 | 22.190 | 6586.8 |
449 | 2024-04-04 22:18:40 | burglary | 1 | 82945 | 3 | 3.280 | 25288.1 |
448 | 2024-04-04 22:18:04 | burglary | 3 | 146162 | 50 | 19.423 | 7525.2 |
447 | 2024-04-03 11:25:22 | burglary | 1 | 82945 | 3 | 3.220 | 25759.3 |
446 | 2024-04-02 08:35:35 | burglary | 2 | 121059 | 4 | 3.860 | 31362.4 |
445 | 2024-04-02 08:35:33 | burglary | 1 | 82945 | 3 | 1.483 | 55930.5 |
444 | 2024-04-02 08:35:22 | burglary | 3 | 146162 | 50 | 7.063 | 20694.0 |
443 | 2024-03-29 19:43:16 | burglary | 3 | 146162 | 50 | 18.033 | 8105.3 |
442 | 2024-03-29 19:43:16 | burglary | 2 | 121059 | 4 | 9.250 | 13087.5 |
441 | 2024-03-29 19:43:11 | burglary | 1 | 82945 | 3 | 3.200 | 25920.3 |
440 | 2024-03-28 18:41:21 | burglary | 4 | 161609 | 441 | 37.783 | 4277.3 |
439 | 2024-03-27 01:10:45 | burglary | 4 | 161609 | 441 | 13.266 | 12182.2 |
438 | 2024-03-26 21:06:41 | burglary | 4 | 161609 | 441 | 14.970 | 10795.5 |
437 | 2024-03-26 12:21:48 | burglary | 4 | 161609 | 441 | 14.080 | 11477.9 |
436 | 2024-03-26 06:54:02 | burglary | 4 | 161609 | 441 | 14.470 | 11168.6 |
435 | 2024-03-26 04:00:18 | burglary | 1 | 82945 | 3 | 3.280 | 25288.1 |
434 | 2024-03-26 03:56:11 | burglary | 4 | 161609 | 441 | 20.173 | 8011.2 |
433 | 2024-03-26 03:56:13 | burglary | 2 | 121059 | 4 | 12.156 | 9958.8 |
432 | 2024-03-26 03:24:10 | burglary | 1 | 82945 | 3 | 1.420 | 58412.0 |
431 | 2024-03-25 16:20:20 | burglary | 2 | 121059 | 4 | 3.156 | 38358.4 |
430 | 2024-03-05 19:15:23 | burglary | 3 | 146162 | 50 | 15.846 | 9223.9 |
429 | 2024-03-04 02:04:22 | burglary | 3 | 146162 | 50 | 14.330 | 10199.7 |
428 | 2024-03-04 02:03:33 | burglary | 1 | 82945 | 3 | 1.546 | 53651.4 |
427 | 2024-03-04 02:03:24 | burglary | 2 | 121059 | 4 | 3.826 | 31641.1 |
426 | 2024-03-03 20:37:27 | burglary | 1 | 82945 | 3 | 1.923 | 43133.1 |
425 | 2024-03-02 20:17:37 | burglary | 1 | 82945 | 3 | 4.720 | 17573.1 |
424 | 2024-03-02 20:17:37 | burglary | 2 | 121059 | 4 | 4.436 | 27290.1 |
423 | 2024-02-26 20:50:24 | burglary | 4 | 161609 | 441 | 12.673 | 12752.2 |
422 | 2024-02-26 20:50:26 | burglary | 2 | 121059 | 4 | 4.140 | 29241.3 |
421 | 2024-02-26 20:50:20 | burglary | 3 | 146162 | 50 | 7.796 | 18748.3 |
420 | 2024-02-26 20:50:12 | burglary | 1 | 82945 | 3 | 1.296 | 64000.8 |
419 | 2024-02-22 14:21:53 | burglary | 2 | 121059 | 4 | 4.266 | 28377.6 |
418 | 2024-02-15 17:10:16 | burglary | 4 | 161609 | 441 | 16.216 | 9966.0 |
417 | 2024-02-14 12:18:58 | burglary | 4 | 161609 | 441 | 27.190 | 5943.7 |
416 | 2024-02-12 15:33:34 | burglary | 3 | 146162 | 50 | 18.920 | 7725.3 |
415 | 2024-02-12 15:06:25 | burglary | 4 | 161609 | 441 | 28.313 | 5707.9 |
414 | 2024-02-12 00:24:12 | burglary | 3 | 146162 | 50 | 15.343 | 9526.3 |
413 | 2024-02-12 00:12:06 | burglary | 4 | 161609 | 441 | 29.376 | 5501.4 |
412 | 2024-02-11 10:29:59 | burglary | 4 | 161609 | 441 | 39.066 | 4136.8 |
411 | 2024-02-11 10:30:06 | burglary | 3 | 146162 | 50 | 25.750 | 5676.2 |
410 | 2024-02-11 10:30:08 | burglary | 2 | 121059 | 4 | 4.966 | 24377.6 |
409 | 2024-02-02 14:26:39 | burglary | 1 | 82945 | 3 | 1.296 | 64000.8 |
408 | 2024-01-09 04:33:24 | burglary | 1 | 82945 | 3 | 1.406 | 58993.6 |
407 | 2024-01-06 20:16:25 | burglary | 1 | 82945 | 3 | 1.296 | 64000.8 |
406 | 2023-12-01 14:39:29 | burglary | 2 | 121059 | 4 | 3.843 | 31501.2 |
405 | 2023-11-15 04:07:51 | burglary | 1 | 82945 | 3 | 1.466 | 56579.1 |
404 | 2023-11-04 19:47:51 | burglary | 1 | 82945 | 3 | 1.423 | 58288.8 |
403 | 2023-10-30 11:32:22 | burglary | 1 | 82945 | 3 | 1.423 | 58288.8 |
402 | 2023-10-11 00:22:19 | burglary | 1 | 82945 | 3 | 1.313 | 63172.1 |
401 | 2023-10-05 06:29:12 | burglary | 1 | 82945 | 3 | 1.280 | 64800.8 |
400 | 2023-09-30 22:28:07 | burglary | 1 | 82945 | 3 | 1.376 | 60279.8 |
399 | 2023-08-30 00:29:04 | burglary | 2 | 121059 | 4 | 3.530 | 34294.3 |
398 | 2023-08-23 05:46:42 | burglary | 1 | 82945 | 3 | 1.296 | 64000.8 |
397 | 2023-06-04 07:39:49 | burglary | 1 | 82945 | 3 | 1.373 | 60411.5 |
396 | 2023-05-23 14:37:48 | burglary | 1 | 82945 | 3 | 1.296 | 64000.8 |
395 | 2023-05-16 21:34:32 | burglary | 2 | 121059 | 4 | 3.080 | 39304.9 |
394 | 2023-03-20 19:54:15 | burglary | 1 | 82945 | 3 | 1.360 | 60989.0 |
393 | 2023-02-23 08:11:08 | burglary | 2 | 121059 | 4 | 3.310 | 36573.7 |
392 | 2023-02-05 08:48:19 | burglary | 1 | 82945 | 3 | 1.453 | 57085.3 |
391 | 2023-01-07 16:13:43 | burglary | 1 | 82945 | 3 | 1.233 | 67270.9 |
390 | 2022-12-05 15:30:08 | burglary | 2 | 121059 | 4 | 3.076 | 39356.0 |
389 | 2022-10-04 13:52:21 | burglary | 1 | 82945 | 3 | 1.263 | 65673.0 |
388 | 2022-10-04 08:51:31 | burglary | 1 | 82945 | 3 | 1.283 | 64649.3 |
387 | 2022-06-29 06:50:59 | burglary | 2 | 121059 | 4 | 3.156 | 38358.4 |
386 | 2022-05-30 23:33:57 | burglary | 1 | 82945 | 3 | 1.236 | 67107.6 |
385 | 2022-05-21 19:38:44 | burglary | 1 | 82945 | 3 | 1.266 | 65517.4 |
384 | 2022-03-02 00:53:18 | burglary | 2 | 121059 | 4 | 3.750 | 32282.4 |
383 | 2022-02-07 11:45:52 | burglary | 1 | 82945 | 3 | 1.233 | 67270.9 |
382 | 2022-01-26 09:07:14 | burglary | 1 | 82945 | 3 | 1.250 | 66356.0 |
381 | 2021-12-13 19:55:13 | burglary | 1 | 82945 | 3 | 1.280 | 64800.8 |
380 | 2021-10-03 10:34:02 | burglary | 1 | 82945 | 3 | 1.250 | 66356.0 |
379 | 2021-06-27 07:19:38 | burglary | 1 | 82945 | 3 | 1.266 | 65517.4 |
378 | 2021-03-26 10:10:10 | burglary | 1 | 82945 | 3 | 1.360 | 60989.0 |
377 | 2021-03-22 00:52:39 | burglary | 1 | 82945 | 3 | 1.436 | 57761.1 |
376 | 2020-12-19 04:13:28 | burglary | 1 | 82945 | 3 | 1.266 | 65517.4 |
375 | 2020-11-09 08:22:46 | burglary | 1 | 82945 | 3 | 1.310 | 63316.8 |
374 | 2020-10-02 14:46:02 | burglary | 1 | 82945 | 3 | 1.250 | 66356.0 |
373 | 2020-09-15 00:18:17 | burglary | 1 | 82945 | 3 | 1.300 | 63803.8 |
372 | 2020-05-27 15:59:32 | burglary | 1 | 82945 | 3 | 1.296 | 64000.8 |
371 | 2020-03-24 06:07:33 | burglary | 1 | 82945 | 3 | 1.720 | 48223.8 |
370 | 2020-02-29 01:16:50 | burglary | 1 | 82945 | 3 | 1.453 | 57085.3 |
369 | 2020-02-15 15:01:21 | burglary | 1 | 82945 | 3 | 1.283 | 64649.3 |
368 | 2020-02-12 10:58:27 | burglary | 1 | 82945 | 3 | 1.593 | 52068.4 |
367 | 2020-02-05 02:47:11 | burglary | 1 | 82945 | 3 | 1.750 | 47397.1 |
366 | 2020-01-30 09:36:37 | burglary | 1 | 82945 | 3 | 1.576 | 52630.1 |
365 | 2020-01-30 04:59:27 | burglary | 1 | 82945 | 3 | 1.593 | 52068.4 |
364 | 2020-01-29 23:05:47 | burglary | 1 | 82945 | 3 | 1.686 | 49196.3 |