History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"specimens"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
140 | 2024-06-06 18:15:04 | specimens | 1 | 81242 | 2 | 5.033 | 16141.9 |
139 | 2024-06-06 17:55:37 | specimens | 4 | 165329 | 320 | 13.906 | 11889.0 |
138 | 2024-06-06 17:01:31 | specimens | 4 | 165329 | 320 | 33.113 | 4992.9 |
137 | 2024-06-06 12:48:06 | specimens | 1 | 81242 | 2 | 4.453 | 18244.3 |
136 | 2024-06-05 21:08:05 | specimens | 4 | 165329 | 320 | 47.846 | 3455.4 |
135 | 2024-06-05 21:08:04 | specimens | 2 | 121436 | 3 | 20.220 | 6005.7 |
134 | 2024-06-05 21:07:58 | specimens | 3 | 148641 | 28 | 15.390 | 9658.3 |
133 | 2024-06-05 16:22:26 | specimens | 1 | 81242 | 2 | 4.950 | 16412.5 |
132 | 2024-06-04 12:48:44 | specimens | 1 | 81242 | 2 | 1.673 | 48560.7 |
131 | 2024-05-13 16:37:17 | specimens | 4 | 165329 | 320 | 28.890 | 5722.7 |
130 | 2024-05-13 16:37:19 | specimens | 2 | 121436 | 3 | 9.813 | 12375.0 |
129 | 2024-05-13 16:36:43 | specimens | 1 | 81242 | 2 | 1.670 | 48647.9 |
128 | 2024-05-10 02:22:44 | specimens | 3 | 148641 | 28 | 19.910 | 7465.6 |
127 | 2024-05-10 02:22:41 | specimens | 2 | 121436 | 3 | 7.486 | 16221.7 |
126 | 2024-05-10 00:59:06 | specimens | 1 | 81242 | 2 | 1.420 | 57212.7 |
125 | 2024-05-07 07:35:23 | specimens | 4 | 165329 | 320 | 36.830 | 4489.0 |
124 | 2024-05-07 01:21:19 | specimens | 1 | 81242 | 2 | 3.173 | 25604.2 |
123 | 2024-05-07 00:57:42 | specimens | 3 | 148641 | 28 | 20.173 | 7368.3 |
122 | 2024-05-06 09:39:31 | specimens | 4 | 165329 | 320 | 32.753 | 5047.8 |
121 | 2024-05-06 09:39:40 | specimens | 3 | 148641 | 28 | 18.923 | 7855.0 |
120 | 2024-05-06 09:39:34 | specimens | 2 | 121436 | 3 | 5.716 | 21244.9 |
119 | 2024-05-06 09:32:20 | specimens | 1 | 81242 | 2 | 3.110 | 26122.8 |
118 | 2024-04-18 22:31:58 | specimens | 1 | 81242 | 2 | 1.266 | 64172.2 |
117 | 2024-04-11 12:34:30 | specimens | 1 | 81242 | 2 | 1.390 | 58447.5 |
116 | 2024-04-01 07:04:03 | specimens | 1 | 81242 | 2 | 1.533 | 52995.4 |
115 | 2024-03-25 18:43:38 | specimens | 1 | 81242 | 2 | 1.500 | 54161.3 |
114 | 2024-03-18 20:41:17 | specimens | 1 | 81242 | 2 | 1.406 | 57782.4 |
113 | 2024-03-12 19:00:10 | specimens | 1 | 81242 | 2 | 1.296 | 62686.7 |
112 | 2024-03-12 05:11:42 | specimens | 1 | 81242 | 2 | 1.610 | 50460.9 |
111 | 2024-03-09 18:48:33 | specimens | 3 | 148641 | 28 | 23.093 | 6436.6 |
110 | 2024-03-09 18:48:32 | specimens | 2 | 121436 | 3 | 8.563 | 14181.5 |
109 | 2024-03-09 18:37:25 | specimens | 1 | 81242 | 2 | 1.390 | 58447.5 |
108 | 2024-03-02 00:18:28 | specimens | 1 | 81242 | 2 | 1.720 | 47233.7 |
107 | 2024-02-29 10:26:49 | specimens | 4 | 165329 | 320 | 20.860 | 7925.6 |
106 | 2024-02-29 10:26:58 | specimens | 3 | 148641 | 28 | 8.203 | 18120.3 |
105 | 2024-02-29 10:26:52 | specimens | 2 | 121436 | 3 | 7.266 | 16712.9 |
104 | 2024-02-29 03:44:22 | specimens | 1 | 81242 | 2 | 1.420 | 57212.7 |
103 | 2024-02-23 22:18:45 | specimens | 3 | 148641 | 28 | 7.626 | 19491.3 |
102 | 2024-02-23 22:18:46 | specimens | 2 | 121436 | 3 | 3.810 | 31873.0 |
101 | 2024-02-23 22:18:24 | specimens | 1 | 81242 | 2 | 1.280 | 63470.3 |
100 | 2024-02-07 02:29:58 | specimens | 1 | 81242 | 2 | 1.296 | 62686.7 |
99 | 2024-02-02 02:44:15 | specimens | 1 | 81242 | 2 | 1.250 | 64993.6 |
98 | 2024-01-31 20:16:40 | specimens | 1 | 81242 | 2 | 1.376 | 59042.2 |
97 | 2024-01-24 16:53:24 | specimens | 1 | 81242 | 2 | 1.576 | 51549.5 |
96 | 2023-12-30 08:07:58 | specimens | 1 | 81242 | 2 | 1.296 | 62686.7 |
95 | 2023-12-16 10:54:39 | specimens | 1 | 81242 | 2 | 1.406 | 57782.4 |
94 | 2023-12-14 20:12:13 | specimens | 1 | 81242 | 2 | 1.530 | 53099.3 |
93 | 2023-10-01 13:47:08 | specimens | 1 | 81242 | 2 | 1.330 | 61084.2 |
92 | 2023-07-29 04:31:52 | specimens | 1 | 81242 | 2 | 1.250 | 64993.6 |
91 | 2023-04-25 17:58:59 | specimens | 1 | 81242 | 2 | 1.250 | 64993.6 |
90 | 2023-02-17 15:04:16 | specimens | 1 | 81242 | 2 | 1.500 | 54161.3 |
89 | 2022-12-14 23:29:04 | specimens | 1 | 81242 | 2 | 1.250 | 64993.6 |
88 | 2022-08-23 09:03:51 | specimens | 1 | 81242 | 2 | 1.250 | 64993.6 |
87 | 2021-06-09 03:01:59 | specimens | 1 | 81242 | 2 | 1.466 | 55417.5 |
86 | 2021-04-14 10:53:02 | specimens | 1 | 81242 | 2 | 1.423 | 57092.1 |
85 | 2021-03-29 14:39:16 | specimens | 1 | 81242 | 2 | 1.423 | 57092.1 |
84 | 2021-03-18 02:37:35 | specimens | 1 | 81242 | 2 | 1.406 | 57782.4 |
83 | 2021-02-20 23:49:40 | specimens | 1 | 81242 | 2 | 1.403 | 57905.9 |
82 | 2020-10-21 21:08:59 | specimens | 1 | 81242 | 2 | 1.610 | 50460.9 |
81 | 2020-03-25 21:14:05 | specimens | 1 | 81242 | 2 | 1.390 | 58447.5 |
80 | 2020-03-25 13:04:00 | specimens | 1 | 81242 | 2 | 1.670 | 48647.9 |
79 | 2020-03-23 01:53:08 | specimens | 1 | 81242 | 2 | 1.593 | 50999.4 |
78 | 2020-03-04 21:21:13 | specimens | 1 | 81242 | 2 | 1.343 | 60492.9 |
77 | 2020-02-12 12:02:34 | specimens | 1 | 81242 | 2 | 2.486 | 32679.8 |
76 | 2020-02-05 23:13:07 | specimens | 1 | 81242 | 2 | 1.436 | 56575.2 |
75 | 2020-02-04 00:13:49 | specimens | 1 | 81242 | 2 | 2.906 | 27956.6 |
74 | 2020-01-31 07:21:03 | specimens | 1 | 81242 | 2 | 1.530 | 53099.3 |
73 | 2020-01-28 06:25:46 | specimens | 1 | 81242 | 2 | 1.466 | 55417.5 |
72 | 2020-01-19 12:53:37 | specimens | 1 | 81242 | 2 | 3.376 | 24064.6 |
71 | 2020-01-15 23:55:16 | specimens | 1 | 81242 | 2 | 2.656 | 30588.1 |
70 | 2020-01-03 13:09:18 | specimens | 1 | 81242 | 2 | 1.500 | 54161.3 |
69 | 2019-12-31 11:06:42 | specimens | 1 | 81242 | 2 | 4.686 | 17337.2 |
68 | 2019-12-08 22:25:40 | specimens | 1 | 81242 | 2 | 1.266 | 64172.2 |
67 | 2019-09-06 23:40:14 | specimens | 1 | 81242 | 2 | 1.216 | 66810.9 |
66 | 2019-07-23 19:41:58 | specimens | 1 | 81242 | 2 | 1.203 | 67532.8 |
65 | 2019-05-22 19:45:18 | specimens | 1 | 81242 | 2 | 1.466 | 55417.5 |
64 | 2019-02-26 19:00:35 | specimens | 1 | 81242 | 2 | 1.230 | 66050.4 |
63 | 2019-02-24 22:24:22 | specimens | 1 | 81242 | 2 | 1.373 | 59171.2 |
62 | 2019-01-25 11:22:52 | specimens | 1 | 81242 | 2 | 1.393 | 58321.6 |
61 | 2019-01-21 07:11:36 | specimens | 1 | 81242 | 2 | 1.226 | 66265.9 |
60 | 2018-11-08 11:04:02 | specimens | 1 | 81242 | 2 | 1.290 | 62978.3 |
59 | 2018-09-19 15:20:20 | specimens | 1 | 81242 | 2 | 1.440 | 56418.1 |
58 | 2018-06-17 15:23:28 | specimens | 1 | 81242 | 2 | 1.270 | 63970.1 |
57 | 2017-06-24 16:26:28 | specimens | 1 | 81242 | 2 | 1.723 | 47151.5 |
56 | 2017-06-12 04:57:45 | specimens | 1 | 81242 | 2 | 1.673 | 48560.7 |
55 | 2016-12-24 01:36:26 | specimens | 1 | 81242 | 2 | 1.556 | 52212.1 |
54 | 2016-12-08 10:10:36 | specimens | 1 | 81242 | 2 | 2.046 | 39707.7 |
53 | 2016-12-07 06:47:36 | specimens | 1 | 81242 | 2 | 2.063 | 39380.5 |
52 | 2016-11-03 09:10:32 | specimens | 1 | 81242 | 2 | 1.773 | 45821.8 |
51 | 2016-10-16 11:48:37 | specimens | 1 | 81242 | 2 | 1.980 | 41031.3 |
50 | 2016-08-26 12:18:57 | specimens | 1 | 81242 | 2 | 1.670 | 48647.9 |
49 | 2016-08-18 08:55:11 | specimens | 2 | 121436 | 3 | 4.260 | 28506.1 |
48 | 2016-07-17 20:40:35 | specimens | 3 | 148641 | 28 | 17.266 | 8608.9 |
47 | 2016-07-14 23:21:41 | specimens | 3 | 148641 | 28 | 12.553 | 11841.1 |
46 | 2016-07-12 01:20:14 | specimens | 2 | 121436 | 3 | 6.050 | 20072.1 |
45 | 2016-07-10 11:19:04 | specimens | 1 | 81242 | 2 | 1.770 | 45899.4 |
44 | 2016-06-26 19:05:58 | specimens | 4 | 165329 | 320 | 25.410 | 6506.5 |
43 | 2016-06-20 12:42:18 | specimens | 1 | 81242 | 2 | 2.280 | 35632.5 |
42 | 2016-02-26 08:33:33 | specimens | 1 | 81242 | 2 | 1.880 | 43213.8 |
41 | 2015-12-29 17:58:25 | specimens | 1 | 81242 | 2 | 2.373 | 34236.0 |