History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"handpick"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
223 | 2024-05-11 19:29:46 | handpick | 1 | 82945 | 2 | 4.796 | 17294.6 |
222 | 2024-05-11 19:29:30 | handpick | 3 | 146162 | 34 | 11.013 | 13271.8 |
221 | 2024-05-11 19:29:36 | handpick | 2 | 121059 | 4 | 4.173 | 29010.1 |
220 | 2024-05-11 19:29:28 | handpick | 1 | 82945 | 2 | 2.420 | 34274.8 |
219 | 2024-05-07 10:44:55 | handpick | 2 | 121059 | 4 | 3.470 | 34887.3 |
218 | 2024-05-07 10:43:35 | handpick | 1 | 82945 | 2 | 1.530 | 54212.4 |
217 | 2024-05-07 06:56:53 | handpick | 1 | 82945 | 2 | 1.656 | 50087.6 |
216 | 2024-05-06 03:34:07 | handpick | 3 | 146162 | 34 | 15.626 | 9353.8 |
215 | 2024-05-06 00:49:58 | handpick | 4 | 161609 | 339 | 29.206 | 5533.4 |
214 | 2024-05-05 07:01:40 | handpick | 3 | 146162 | 34 | 7.126 | 20511.1 |
213 | 2024-05-04 08:39:32 | handpick | 3 | 146162 | 34 | 11.720 | 12471.2 |
212 | 2024-05-04 08:39:40 | handpick | 1 | 82945 | 2 | 3.096 | 26791.0 |
211 | 2024-05-04 08:39:23 | handpick | 2 | 121059 | 4 | 4.593 | 26357.3 |
210 | 2024-04-29 20:20:02 | handpick | 4 | 161609 | 339 | 12.500 | 12928.7 |
209 | 2024-04-29 20:20:10 | handpick | 1 | 82945 | 2 | 1.450 | 57203.4 |
208 | 2024-04-29 20:20:06 | handpick | 2 | 121059 | 4 | 3.686 | 32842.9 |
207 | 2024-04-13 09:23:00 | handpick | 2 | 121059 | 4 | 3.640 | 33258.0 |
206 | 2024-04-13 09:22:41 | handpick | 3 | 146162 | 34 | 12.250 | 11931.6 |
205 | 2024-04-13 09:22:20 | handpick | 3 | 146162 | 34 | 7.313 | 19986.6 |
204 | 2024-04-11 00:19:00 | handpick | 3 | 146162 | 34 | 10.000 | 14616.2 |
203 | 2024-04-11 00:19:01 | handpick | 2 | 121059 | 4 | 7.703 | 15715.8 |
202 | 2024-04-11 00:18:56 | handpick | 1 | 82945 | 2 | 2.533 | 32745.8 |
201 | 2024-04-07 02:49:42 | handpick | 1 | 82945 | 2 | 1.856 | 44690.2 |
200 | 2024-04-04 08:01:29 | handpick | 1 | 82945 | 2 | 2.640 | 31418.6 |
199 | 2024-04-02 22:34:52 | handpick | 4 | 161609 | 339 | 34.206 | 4724.6 |
198 | 2024-04-02 05:17:08 | handpick | 4 | 161609 | 339 | 16.250 | 9945.2 |
197 | 2024-03-31 11:36:57 | handpick | 1 | 82945 | 2 | 3.376 | 24569.0 |
196 | 2024-03-31 00:44:02 | handpick | 4 | 161609 | 339 | 31.940 | 5059.8 |
195 | 2024-03-30 20:30:06 | handpick | 4 | 161609 | 339 | 30.300 | 5333.6 |
194 | 2024-03-29 11:18:05 | handpick | 4 | 161609 | 339 | 47.270 | 3418.8 |
193 | 2024-03-29 11:00:32 | handpick | 4 | 161609 | 339 | 24.546 | 6583.9 |
192 | 2024-03-29 11:00:28 | handpick | 1 | 82945 | 2 | 4.390 | 18894.1 |
191 | 2024-03-26 04:10:34 | handpick | 2 | 121059 | 4 | 9.140 | 13245.0 |
190 | 2024-03-26 02:41:21 | handpick | 1 | 82945 | 2 | 4.080 | 20329.7 |
189 | 2024-03-11 07:45:06 | handpick | 1 | 82945 | 2 | 3.373 | 24590.9 |
188 | 2024-03-09 07:20:54 | handpick | 3 | 146162 | 34 | 9.000 | 16240.2 |
187 | 2024-03-07 21:58:33 | handpick | 3 | 146162 | 34 | 7.546 | 19369.5 |
186 | 2024-03-05 23:48:59 | handpick | 3 | 146162 | 34 | 11.093 | 13176.1 |
185 | 2024-03-05 08:42:04 | handpick | 3 | 146162 | 34 | 16.046 | 9108.9 |
184 | 2024-03-04 16:46:05 | handpick | 3 | 146162 | 34 | 14.283 | 10233.3 |
183 | 2024-03-04 16:46:03 | handpick | 2 | 121059 | 4 | 13.313 | 9093.3 |
182 | 2024-03-02 11:15:34 | handpick | 3 | 146162 | 34 | 9.876 | 14799.7 |
181 | 2024-03-02 11:15:32 | handpick | 2 | 121059 | 4 | 4.050 | 29891.1 |
180 | 2024-03-02 11:15:24 | handpick | 1 | 82945 | 2 | 1.576 | 52630.1 |
179 | 2024-03-01 00:43:21 | handpick | 4 | 161609 | 339 | 14.080 | 11477.9 |
178 | 2024-02-28 21:45:48 | handpick | 4 | 161609 | 339 | 13.156 | 12284.1 |
177 | 2024-02-27 06:15:59 | handpick | 4 | 161609 | 339 | 21.436 | 7539.1 |
176 | 2024-02-26 15:46:48 | handpick | 4 | 161609 | 339 | 13.983 | 11557.5 |
175 | 2024-02-26 15:46:44 | handpick | 1 | 82945 | 2 | 1.530 | 54212.4 |
174 | 2024-02-09 18:33:31 | handpick | 1 | 82945 | 2 | 1.470 | 56425.2 |
173 | 2024-02-01 01:17:48 | handpick | 1 | 82945 | 2 | 1.390 | 59672.7 |
172 | 2024-01-30 01:38:09 | handpick | 3 | 146162 | 34 | 8.313 | 17582.3 |
171 | 2024-01-30 01:38:08 | handpick | 2 | 121059 | 4 | 5.593 | 21644.7 |
170 | 2024-01-26 15:33:03 | handpick | 3 | 146162 | 34 | 7.623 | 19173.8 |
169 | 2024-01-26 15:32:59 | handpick | 2 | 121059 | 4 | 8.173 | 14812.1 |
168 | 2024-01-26 15:32:35 | handpick | 2 | 121059 | 4 | 3.580 | 33815.4 |
167 | 2024-01-26 15:32:27 | handpick | 3 | 146162 | 34 | 7.610 | 19206.6 |
166 | 2024-01-26 15:32:19 | handpick | 1 | 82945 | 2 | 1.546 | 53651.4 |
165 | 2024-01-26 10:18:51 | handpick | 4 | 161609 | 339 | 18.300 | 8831.1 |
164 | 2024-01-26 07:45:07 | handpick | 4 | 161609 | 339 | 12.940 | 12489.1 |
163 | 2024-01-20 18:28:14 | handpick | 1 | 82945 | 2 | 1.266 | 65517.4 |
162 | 2024-01-16 14:37:25 | handpick | 1 | 82945 | 2 | 1.313 | 63172.1 |
161 | 2024-01-02 04:47:40 | handpick | 4 | 161609 | 339 | 12.656 | 12769.4 |
160 | 2023-12-24 19:08:01 | handpick | 3 | 146162 | 34 | 7.486 | 19524.7 |
159 | 2023-12-15 12:42:05 | handpick | 1 | 82945 | 2 | 1.766 | 46967.7 |
158 | 2023-11-30 13:43:00 | handpick | 1 | 82945 | 2 | 1.280 | 64800.8 |
157 | 2023-11-09 12:43:20 | handpick | 1 | 82945 | 2 | 1.373 | 60411.5 |
156 | 2023-10-08 00:32:32 | handpick | 4 | 161609 | 339 | 19.033 | 8491.0 |
155 | 2023-09-25 14:34:02 | handpick | 3 | 146162 | 34 | 11.953 | 12228.1 |
154 | 2023-09-16 05:59:35 | handpick | 1 | 82945 | 2 | 1.346 | 61623.3 |
153 | 2023-09-02 22:24:23 | handpick | 1 | 82945 | 2 | 1.436 | 57761.1 |
152 | 2023-07-18 19:02:50 | handpick | 4 | 161609 | 339 | 12.063 | 13397.1 |
151 | 2023-07-06 04:06:25 | handpick | 3 | 146162 | 34 | 7.330 | 19940.2 |
150 | 2023-07-01 06:00:17 | handpick | 1 | 82945 | 2 | 1.310 | 63316.8 |
149 | 2023-05-02 17:20:06 | handpick | 1 | 82945 | 2 | 1.406 | 58993.6 |
148 | 2023-04-12 14:22:06 | handpick | 1 | 82945 | 2 | 1.640 | 50576.2 |
147 | 2023-04-02 00:31:22 | handpick | 4 | 161609 | 339 | 10.673 | 15141.9 |
146 | 2023-03-26 18:55:35 | handpick | 3 | 146162 | 34 | 6.406 | 22816.4 |
145 | 2023-02-02 02:22:41 | handpick | 1 | 82945 | 2 | 1.283 | 64649.3 |
144 | 2022-12-29 01:27:52 | handpick | 1 | 82945 | 2 | 1.373 | 60411.5 |
143 | 2022-12-27 17:37:28 | handpick | 4 | 161609 | 339 | 11.093 | 14568.6 |
142 | 2022-12-24 21:37:17 | handpick | 3 | 146162 | 34 | 6.233 | 23449.7 |
141 | 2022-12-01 17:43:06 | handpick | 1 | 82945 | 2 | 1.250 | 66356.0 |
140 | 2022-08-27 14:02:34 | handpick | 4 | 161609 | 339 | 10.516 | 15367.9 |
139 | 2022-08-26 14:47:36 | handpick | 3 | 146162 | 34 | 6.280 | 23274.2 |
138 | 2022-08-24 06:51:34 | handpick | 3 | 146162 | 34 | 6.436 | 22710.1 |
137 | 2022-08-15 05:21:04 | handpick | 1 | 82945 | 2 | 1.233 | 67270.9 |
136 | 2022-08-14 19:30:36 | handpick | 1 | 82945 | 2 | 1.280 | 64800.8 |
135 | 2022-08-06 20:54:20 | handpick | 1 | 82945 | 2 | 1.296 | 64000.8 |
134 | 2022-07-29 13:16:04 | handpick | 1 | 82945 | 2 | 1.390 | 59672.7 |
133 | 2022-07-27 23:19:51 | handpick | 1 | 82945 | 2 | 1.440 | 57600.7 |
132 | 2022-04-03 15:32:04 | handpick | 1 | 82945 | 2 | 1.266 | 65517.4 |
131 | 2022-04-01 10:29:39 | handpick | 3 | 146162 | 34 | 6.263 | 23337.4 |
130 | 2022-03-22 15:40:57 | handpick | 1 | 82945 | 2 | 1.373 | 60411.5 |
129 | 2022-03-20 12:01:01 | handpick | 1 | 82945 | 2 | 1.296 | 64000.8 |
128 | 2021-11-30 07:18:44 | handpick | 1 | 82945 | 2 | 1.453 | 57085.3 |
127 | 2021-08-10 14:24:29 | handpick | 1 | 82945 | 2 | 1.266 | 65517.4 |
126 | 2021-05-05 03:07:59 | handpick | 1 | 82945 | 2 | 1.373 | 60411.5 |
125 | 2021-04-21 23:36:16 | handpick | 1 | 82945 | 2 | 1.500 | 55296.7 |
124 | 2021-04-03 06:09:23 | handpick | 1 | 82945 | 2 | 1.280 | 64800.8 |