History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"phonolite"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
294 | 2024-05-07 01:48:58 | phonolite | 4 | 165329 | 315 | 13.173 | 12550.6 |
293 | 2024-05-07 00:58:39 | phonolite | 2 | 121436 | 4 | 9.796 | 12396.5 |
292 | 2024-05-06 22:08:28 | phonolite | 1 | 81242 | 2 | 1.453 | 55913.3 |
291 | 2024-04-29 18:35:55 | phonolite | 3 | 148641 | 36 | 15.733 | 9447.7 |
290 | 2024-04-29 18:32:22 | phonolite | 2 | 121436 | 4 | 4.826 | 25162.9 |
289 | 2024-04-29 18:31:54 | phonolite | 1 | 81242 | 2 | 1.423 | 57092.1 |
288 | 2024-04-29 18:30:41 | phonolite | 1 | 81242 | 2 | 1.406 | 57782.4 |
287 | 2024-04-28 01:19:20 | phonolite | 4 | 165329 | 315 | 47.300 | 3495.3 |
286 | 2024-04-23 10:16:46 | phonolite | 4 | 165329 | 315 | 27.220 | 6073.8 |
285 | 2024-04-21 00:13:20 | phonolite | 4 | 165329 | 315 | 44.846 | 3686.6 |
284 | 2024-04-17 05:51:30 | phonolite | 4 | 165329 | 315 | 42.750 | 3867.3 |
283 | 2024-04-17 01:39:23 | phonolite | 4 | 165329 | 315 | 14.326 | 11540.5 |
282 | 2024-04-16 11:27:28 | phonolite | 3 | 148641 | 36 | 14.970 | 9929.3 |
281 | 2024-04-16 09:01:16 | phonolite | 4 | 165329 | 315 | 43.736 | 3780.2 |
280 | 2024-04-16 09:01:08 | phonolite | 3 | 148641 | 36 | 31.580 | 4706.8 |
279 | 2024-04-16 09:01:08 | phonolite | 2 | 121436 | 4 | 13.563 | 8953.5 |
278 | 2024-04-16 07:14:16 | phonolite | 1 | 81242 | 2 | 1.546 | 52549.8 |
277 | 2024-04-09 21:27:12 | phonolite | 1 | 81242 | 2 | 1.453 | 55913.3 |
276 | 2024-04-09 21:26:01 | phonolite | 1 | 81242 | 2 | 1.750 | 46424.0 |
275 | 2024-04-08 04:55:29 | phonolite | 1 | 81242 | 2 | 1.406 | 57782.4 |
274 | 2024-04-03 13:46:47 | phonolite | 1 | 81242 | 2 | 1.376 | 59042.2 |
273 | 2024-04-01 11:02:00 | phonolite | 1 | 81242 | 2 | 3.250 | 24997.5 |
272 | 2024-03-30 12:22:43 | phonolite | 1 | 81242 | 2 | 1.436 | 56575.2 |
271 | 2024-03-28 05:36:20 | phonolite | 4 | 165329 | 315 | 10.390 | 15912.3 |
270 | 2024-03-27 20:19:56 | phonolite | 1 | 81242 | 2 | 1.550 | 52414.2 |
269 | 2024-03-27 20:19:40 | phonolite | 3 | 148641 | 36 | 16.890 | 8800.5 |
268 | 2024-03-27 20:19:42 | phonolite | 2 | 121436 | 4 | 8.253 | 14714.2 |
267 | 2024-03-27 20:19:33 | phonolite | 1 | 81242 | 2 | 3.296 | 24648.7 |
266 | 2024-03-16 22:33:07 | phonolite | 2 | 121436 | 4 | 13.266 | 9153.9 |
265 | 2024-03-16 01:29:42 | phonolite | 4 | 165329 | 315 | 41.736 | 3961.3 |
264 | 2024-03-15 22:11:15 | phonolite | 4 | 165329 | 315 | 46.203 | 3578.3 |
263 | 2024-03-15 16:26:13 | phonolite | 4 | 165329 | 315 | 28.123 | 5878.8 |
262 | 2024-03-15 13:59:45 | phonolite | 4 | 165329 | 315 | 37.110 | 4455.1 |
261 | 2024-03-15 13:59:39 | phonolite | 3 | 148641 | 36 | 24.093 | 6169.5 |
260 | 2024-03-15 13:59:40 | phonolite | 2 | 121436 | 4 | 10.673 | 11377.9 |
259 | 2024-03-15 13:44:47 | phonolite | 1 | 81242 | 2 | 1.330 | 61084.2 |
258 | 2024-03-01 19:07:37 | phonolite | 1 | 81242 | 2 | 4.670 | 17396.6 |
257 | 2024-02-28 11:28:54 | phonolite | 1 | 81242 | 2 | 1.360 | 59736.8 |
256 | 2024-02-23 14:33:09 | phonolite | 1 | 81242 | 2 | 1.453 | 55913.3 |
255 | 2024-01-07 21:47:25 | phonolite | 1 | 81242 | 2 | 1.406 | 57782.4 |
254 | 2024-01-05 19:03:46 | phonolite | 1 | 81242 | 2 | 1.513 | 53696.0 |
253 | 2024-01-01 19:27:18 | phonolite | 4 | 165329 | 315 | 11.626 | 14220.6 |
252 | 2023-12-24 15:04:09 | phonolite | 1 | 81242 | 2 | 1.343 | 60492.9 |
251 | 2023-12-24 05:16:16 | phonolite | 1 | 81242 | 2 | 1.406 | 57782.4 |
250 | 2023-11-30 13:20:05 | phonolite | 2 | 121436 | 4 | 3.373 | 36002.4 |
249 | 2023-11-19 17:09:24 | phonolite | 1 | 81242 | 2 | 2.686 | 30246.5 |
248 | 2023-10-29 23:01:04 | phonolite | 4 | 165329 | 315 | 23.470 | 7044.3 |
247 | 2023-10-25 04:59:32 | phonolite | 4 | 165329 | 315 | 15.080 | 10963.5 |
246 | 2023-10-17 16:49:29 | phonolite | 4 | 165329 | 315 | 23.393 | 7067.5 |
245 | 2023-10-13 08:18:59 | phonolite | 4 | 165329 | 315 | 13.533 | 12216.7 |
244 | 2023-10-12 04:51:08 | phonolite | 1 | 81242 | 2 | 1.203 | 67532.8 |
243 | 2023-10-11 01:45:40 | phonolite | 4 | 165329 | 315 | 11.203 | 14757.6 |
242 | 2023-10-08 06:18:48 | phonolite | 4 | 165329 | 315 | 10.470 | 15790.7 |
241 | 2023-09-30 06:26:53 | phonolite | 4 | 165329 | 315 | 10.313 | 16031.1 |
240 | 2023-09-16 21:14:37 | phonolite | 1 | 81242 | 2 | 1.796 | 45235.0 |
239 | 2023-08-29 12:09:17 | phonolite | 2 | 121436 | 4 | 3.033 | 40038.2 |
238 | 2023-08-15 23:02:17 | phonolite | 1 | 81242 | 2 | 1.293 | 62832.2 |
237 | 2023-08-07 22:03:21 | phonolite | 1 | 81242 | 2 | 1.266 | 64172.2 |
236 | 2023-07-24 11:03:01 | phonolite | 4 | 165329 | 315 | 10.373 | 15938.4 |
235 | 2023-07-18 17:18:15 | phonolite | 4 | 165329 | 315 | 10.780 | 15336.6 |
234 | 2023-05-16 07:36:03 | phonolite | 2 | 121436 | 4 | 3.500 | 34696.0 |
233 | 2023-05-06 01:08:13 | phonolite | 1 | 81242 | 2 | 1.330 | 61084.2 |
232 | 2023-04-09 11:33:35 | phonolite | 1 | 81242 | 2 | 1.233 | 65889.7 |
231 | 2023-04-02 00:39:14 | phonolite | 4 | 165329 | 315 | 10.313 | 16031.1 |
230 | 2023-03-01 14:35:53 | phonolite | 1 | 81242 | 2 | 2.626 | 30937.5 |
229 | 2023-02-23 16:37:13 | phonolite | 2 | 121436 | 4 | 3.250 | 37364.9 |
228 | 2022-12-28 21:35:59 | phonolite | 4 | 165329 | 315 | 10.330 | 16004.7 |
227 | 2022-12-25 23:25:45 | phonolite | 1 | 81242 | 2 | 1.186 | 68500.8 |
226 | 2022-12-19 18:11:35 | phonolite | 1 | 81242 | 2 | 1.203 | 67532.8 |
225 | 2022-12-07 09:47:05 | phonolite | 1 | 81242 | 2 | 1.186 | 68500.8 |
224 | 2022-12-05 00:41:17 | phonolite | 2 | 121436 | 4 | 3.000 | 40478.7 |
223 | 2022-09-01 14:01:16 | phonolite | 1 | 81242 | 2 | 1.216 | 66810.9 |
222 | 2022-08-29 04:55:15 | phonolite | 4 | 165329 | 315 | 12.766 | 12950.7 |
221 | 2022-07-24 10:04:19 | phonolite | 1 | 81242 | 2 | 1.326 | 61268.5 |
220 | 2022-07-12 07:12:13 | phonolite | 2 | 121436 | 4 | 3.060 | 39685.0 |
219 | 2022-04-16 23:30:36 | phonolite | 1 | 81242 | 2 | 1.390 | 58447.5 |
218 | 2022-04-14 19:04:12 | phonolite | 1 | 81242 | 2 | 1.783 | 45564.8 |
217 | 2022-03-02 16:15:08 | phonolite | 1 | 81242 | 2 | 1.220 | 66591.8 |
216 | 2022-01-28 10:38:05 | phonolite | 3 | 148641 | 36 | 6.123 | 24275.8 |
215 | 2022-01-27 23:10:04 | phonolite | 3 | 148641 | 36 | 7.313 | 20325.6 |
214 | 2022-01-27 04:36:18 | phonolite | 3 | 148641 | 36 | 6.423 | 23142.0 |
213 | 2022-01-26 22:05:23 | phonolite | 3 | 148641 | 36 | 6.030 | 24650.2 |
212 | 2022-01-26 11:00:09 | phonolite | 3 | 148641 | 36 | 7.436 | 19989.4 |
211 | 2022-01-26 01:40:26 | phonolite | 3 | 148641 | 36 | 7.500 | 19818.8 |
210 | 2022-01-25 13:49:10 | phonolite | 1 | 81242 | 2 | 1.436 | 56575.2 |
209 | 2022-01-25 10:58:34 | phonolite | 3 | 148641 | 36 | 15.203 | 9777.1 |
208 | 2022-01-25 04:54:11 | phonolite | 3 | 148641 | 36 | 7.313 | 20325.6 |
207 | 2022-01-24 14:16:02 | phonolite | 3 | 148641 | 36 | 6.466 | 22988.1 |
206 | 2022-01-23 19:28:03 | phonolite | 3 | 148641 | 36 | 8.970 | 16570.9 |
205 | 2022-01-23 05:52:59 | phonolite | 3 | 148641 | 36 | 6.563 | 22648.3 |
204 | 2022-01-22 17:00:42 | phonolite | 3 | 148641 | 36 | 6.296 | 23608.8 |
203 | 2022-01-21 23:37:02 | phonolite | 3 | 148641 | 36 | 6.063 | 24516.1 |
202 | 2022-01-17 15:55:36 | phonolite | 3 | 148641 | 36 | 7.420 | 20032.5 |
201 | 2022-01-17 01:08:19 | phonolite | 3 | 148641 | 36 | 7.266 | 20457.1 |
200 | 2022-01-16 09:56:28 | phonolite | 3 | 148641 | 36 | 7.283 | 20409.3 |
199 | 2022-01-16 00:18:24 | phonolite | 3 | 148641 | 36 | 7.236 | 20541.9 |
198 | 2022-01-15 15:26:01 | phonolite | 3 | 148641 | 36 | 15.783 | 9417.8 |
197 | 2022-01-15 04:17:26 | phonolite | 3 | 148641 | 36 | 7.343 | 20242.5 |
196 | 2022-01-14 16:31:50 | phonolite | 3 | 148641 | 36 | 7.470 | 19898.4 |
195 | 2022-01-14 03:55:32 | phonolite | 3 | 148641 | 36 | 6.986 | 21277.0 |