History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piercers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
262 | 2024-04-27 20:30:06 | piercers | 1 | 82945 | 4 | 3.563 | 23279.5 |
261 | 2024-04-22 23:56:06 | piercers | 2 | 121059 | 16 | 3.250 | 37248.9 |
260 | 2024-03-31 19:26:37 | piercers | 2 | 121059 | 16 | 10.156 | 11919.9 |
259 | 2024-03-31 19:26:31 | piercers | 1 | 82945 | 4 | 4.876 | 17010.9 |
258 | 2024-03-31 19:26:16 | piercers | 2 | 121059 | 16 | 7.970 | 15189.3 |
257 | 2024-03-31 09:52:41 | piercers | 3 | 146162 | 186 | 20.843 | 7012.5 |
256 | 2024-03-31 00:14:36 | piercers | 3 | 146162 | 186 | 10.626 | 13755.1 |
255 | 2024-03-31 00:14:33 | piercers | 2 | 121059 | 16 | 12.266 | 9869.5 |
254 | 2024-03-31 00:02:47 | piercers | 1 | 82945 | 4 | 2.750 | 30161.8 |
253 | 2024-03-30 20:40:25 | piercers | 1 | 82945 | 4 | 4.830 | 17172.9 |
252 | 2024-03-26 07:17:19 | piercers | 1 | 82945 | 4 | 1.486 | 55817.6 |
251 | 2024-03-07 00:05:28 | piercers | 1 | 82945 | 4 | 3.280 | 25288.1 |
250 | 2024-03-06 00:45:25 | piercers | 1 | 82945 | 4 | 3.313 | 25036.2 |
249 | 2024-03-01 09:48:26 | piercers | 1 | 82945 | 4 | 4.656 | 17814.6 |
248 | 2024-02-29 18:00:43 | piercers | 1 | 82945 | 4 | 1.563 | 53067.8 |
247 | 2024-02-11 20:20:12 | piercers | 3 | 146162 | 186 | 10.250 | 14259.7 |
246 | 2024-02-09 19:50:54 | piercers | 3 | 146162 | 186 | 14.123 | 10349.2 |
245 | 2024-02-06 06:51:38 | piercers | 2 | 121059 | 16 | 3.390 | 35710.6 |
244 | 2024-02-06 06:51:22 | piercers | 3 | 146162 | 186 | 7.623 | 19173.8 |
243 | 2024-01-31 16:02:12 | piercers | 2 | 121059 | 16 | 3.436 | 35232.5 |
242 | 2024-01-31 15:59:36 | piercers | 3 | 146162 | 186 | 6.406 | 22816.4 |
241 | 2024-01-31 08:41:59 | piercers | 2 | 121059 | 16 | 5.173 | 23402.1 |
240 | 2024-01-31 08:41:39 | piercers | 3 | 146162 | 186 | 7.686 | 19016.7 |
239 | 2024-01-30 15:19:16 | piercers | 1 | 82945 | 4 | 2.953 | 28088.4 |
238 | 2024-01-11 01:10:28 | piercers | 3 | 146162 | 186 | 7.266 | 20115.9 |
237 | 2024-01-11 01:10:26 | piercers | 2 | 121059 | 16 | 6.720 | 18014.7 |
236 | 2024-01-09 05:56:45 | piercers | 1 | 82945 | 4 | 1.313 | 63172.1 |
235 | 2024-01-04 00:52:02 | piercers | 3 | 146162 | 186 | 6.766 | 21602.4 |
234 | 2023-12-21 10:43:28 | piercers | 1 | 82945 | 4 | 1.313 | 63172.1 |
233 | 2023-12-19 08:49:21 | piercers | 1 | 82945 | 4 | 1.406 | 58993.6 |
232 | 2023-12-18 02:53:10 | piercers | 1 | 82945 | 4 | 1.406 | 58993.6 |
231 | 2023-12-16 19:49:34 | piercers | 2 | 121059 | 16 | 3.546 | 34139.6 |
230 | 2023-11-17 02:38:34 | piercers | 1 | 82945 | 4 | 1.420 | 58412.0 |
229 | 2023-11-03 22:46:20 | piercers | 1 | 82945 | 4 | 1.250 | 66356.0 |
228 | 2023-10-19 07:02:18 | piercers | 1 | 82945 | 4 | 1.313 | 63172.1 |
227 | 2023-10-14 15:22:41 | piercers | 3 | 146162 | 186 | 16.220 | 9011.2 |
226 | 2023-10-09 15:23:09 | piercers | 3 | 146162 | 186 | 7.266 | 20115.9 |
225 | 2023-10-08 22:26:28 | piercers | 1 | 82945 | 4 | 1.470 | 56425.2 |
224 | 2023-10-08 13:45:28 | piercers | 1 | 82945 | 4 | 1.280 | 64800.8 |
223 | 2023-09-16 23:46:11 | piercers | 2 | 121059 | 16 | 3.436 | 35232.5 |
222 | 2023-09-15 11:29:49 | piercers | 1 | 82945 | 4 | 1.390 | 59672.7 |
221 | 2023-08-30 18:13:04 | piercers | 1 | 82945 | 4 | 1.406 | 58993.6 |
220 | 2023-08-04 23:59:38 | piercers | 1 | 82945 | 4 | 1.280 | 64800.8 |
219 | 2023-07-20 12:16:22 | piercers | 3 | 146162 | 186 | 7.843 | 18636.0 |
218 | 2023-06-16 11:44:35 | piercers | 2 | 121059 | 16 | 3.173 | 38152.9 |
217 | 2023-05-02 18:29:04 | piercers | 1 | 82945 | 4 | 1.296 | 64000.8 |
216 | 2023-05-02 06:36:29 | piercers | 1 | 82945 | 4 | 1.330 | 62364.7 |
215 | 2023-03-31 18:06:41 | piercers | 3 | 146162 | 186 | 6.826 | 21412.5 |
214 | 2023-03-14 14:39:52 | piercers | 2 | 121059 | 16 | 3.406 | 35542.9 |
213 | 2023-02-21 03:03:52 | piercers | 1 | 82945 | 4 | 1.313 | 63172.1 |
212 | 2023-02-04 09:58:24 | piercers | 3 | 146162 | 186 | 7.110 | 20557.2 |
211 | 2023-01-09 06:41:46 | piercers | 1 | 82945 | 4 | 1.250 | 66356.0 |
210 | 2022-12-28 10:54:26 | piercers | 3 | 146162 | 186 | 7.720 | 18932.9 |
209 | 2022-12-20 04:27:50 | piercers | 1 | 82945 | 4 | 1.436 | 57761.1 |
208 | 2022-12-19 07:36:40 | piercers | 3 | 146162 | 186 | 6.250 | 23385.9 |
207 | 2022-12-18 06:18:43 | piercers | 2 | 121059 | 16 | 5.046 | 23991.1 |
206 | 2022-11-25 10:08:06 | piercers | 1 | 82945 | 4 | 1.423 | 58288.8 |
205 | 2022-11-08 19:16:13 | piercers | 3 | 146162 | 186 | 7.250 | 20160.3 |
204 | 2022-09-04 02:11:47 | piercers | 1 | 82945 | 4 | 1.233 | 67270.9 |
203 | 2022-08-31 08:59:14 | piercers | 1 | 82945 | 4 | 1.250 | 66356.0 |
202 | 2022-08-28 22:47:50 | piercers | 1 | 82945 | 4 | 1.296 | 64000.8 |
201 | 2022-08-28 14:18:21 | piercers | 3 | 146162 | 186 | 6.486 | 22535.0 |
200 | 2022-08-10 20:12:08 | piercers | 2 | 121059 | 16 | 3.170 | 38189.0 |
199 | 2022-04-24 10:29:59 | piercers | 1 | 82945 | 4 | 1.266 | 65517.4 |
198 | 2022-04-07 19:45:01 | piercers | 1 | 82945 | 4 | 1.513 | 54821.5 |
197 | 2022-03-28 23:05:02 | piercers | 2 | 121059 | 16 | 4.033 | 30017.1 |
196 | 2022-01-07 08:38:48 | piercers | 1 | 82945 | 4 | 1.530 | 54212.4 |
195 | 2021-12-29 11:15:47 | piercers | 1 | 82945 | 4 | 3.346 | 24789.3 |
194 | 2021-11-09 15:35:31 | piercers | 1 | 82945 | 4 | 1.390 | 59672.7 |
193 | 2021-09-27 05:09:26 | piercers | 1 | 82945 | 4 | 1.470 | 56425.2 |
192 | 2021-09-19 15:06:15 | piercers | 1 | 82945 | 4 | 1.280 | 64800.8 |
191 | 2021-09-13 12:06:13 | piercers | 1 | 82945 | 4 | 1.313 | 63172.1 |
190 | 2021-09-12 17:57:43 | piercers | 1 | 82945 | 4 | 1.280 | 64800.8 |
189 | 2021-09-10 02:19:57 | piercers | 1 | 82945 | 4 | 1.283 | 64649.3 |
188 | 2021-09-07 21:25:20 | piercers | 1 | 82945 | 4 | 1.423 | 58288.8 |
187 | 2021-06-08 12:32:28 | piercers | 1 | 82945 | 4 | 1.420 | 58412.0 |
186 | 2021-04-27 19:01:53 | piercers | 1 | 82945 | 4 | 1.436 | 57761.1 |
185 | 2021-03-27 19:00:54 | piercers | 1 | 82945 | 4 | 1.436 | 57761.1 |
184 | 2021-03-09 12:21:59 | piercers | 1 | 82945 | 4 | 1.436 | 57761.1 |
183 | 2021-01-26 07:34:01 | piercers | 1 | 82945 | 4 | 1.470 | 56425.2 |
182 | 2021-01-11 02:47:31 | piercers | 1 | 82945 | 4 | 1.280 | 64800.8 |
181 | 2020-12-01 20:52:29 | piercers | 1 | 82945 | 4 | 1.283 | 64649.3 |
180 | 2020-11-04 00:17:05 | piercers | 1 | 82945 | 4 | 1.593 | 52068.4 |
179 | 2020-11-01 04:35:43 | piercers | 1 | 82945 | 4 | 1.436 | 57761.1 |
178 | 2020-10-23 14:11:11 | piercers | 1 | 82945 | 4 | 1.453 | 57085.3 |
177 | 2020-08-24 15:30:12 | piercers | 1 | 82945 | 4 | 1.313 | 63172.1 |
176 | 2020-08-09 04:23:02 | piercers | 1 | 82945 | 4 | 1.330 | 62364.7 |
175 | 2020-08-05 23:02:31 | piercers | 1 | 82945 | 4 | 1.310 | 63316.8 |
174 | 2020-08-04 23:49:41 | piercers | 1 | 82945 | 4 | 1.296 | 64000.8 |
173 | 2020-05-20 03:13:50 | piercers | 1 | 82945 | 4 | 1.423 | 58288.8 |
172 | 2020-04-27 23:51:12 | piercers | 1 | 82945 | 4 | 1.283 | 64649.3 |
171 | 2020-03-23 07:48:34 | piercers | 1 | 82945 | 4 | 1.560 | 53169.9 |
170 | 2020-02-13 08:26:40 | piercers | 1 | 82945 | 4 | 1.563 | 53067.8 |
169 | 2020-02-12 19:41:54 | piercers | 1 | 82945 | 4 | 2.703 | 30686.3 |
168 | 2020-02-11 07:45:22 | piercers | 1 | 82945 | 4 | 1.466 | 56579.1 |
167 | 2020-02-07 01:55:07 | piercers | 1 | 82945 | 4 | 1.640 | 50576.2 |
166 | 2020-02-02 03:52:59 | piercers | 1 | 82945 | 4 | 1.516 | 54713.1 |
165 | 2020-01-30 03:24:13 | piercers | 1 | 82945 | 4 | 2.516 | 32967.0 |
164 | 2020-01-28 19:41:01 | piercers | 1 | 82945 | 4 | 2.173 | 38170.7 |
163 | 2020-01-22 05:42:09 | piercers | 1 | 82945 | 4 | 3.923 | 21143.3 |