History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"goldfish"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
300 | 2024-05-02 19:23:46 | goldfish | 1 | 82945 | 1 | 1.406 | 58993.6 |
299 | 2024-04-14 01:05:30 | goldfish | 4 | 161609 | 415 | 40.770 | 3963.9 |
298 | 2024-04-10 20:37:59 | goldfish | 4 | 161609 | 415 | 36.893 | 4380.5 |
297 | 2024-04-10 13:23:21 | goldfish | 4 | 161609 | 415 | 15.076 | 10719.6 |
296 | 2024-04-10 13:23:10 | goldfish | 2 | 121059 | 11 | 5.733 | 21116.2 |
295 | 2024-04-10 07:22:56 | goldfish | 3 | 146162 | 73 | 11.283 | 12954.2 |
294 | 2024-04-09 00:10:12 | goldfish | 2 | 121059 | 11 | 9.216 | 13135.7 |
293 | 2024-04-08 09:02:26 | goldfish | 1 | 82945 | 1 | 3.640 | 22787.1 |
292 | 2024-04-08 04:23:35 | goldfish | 2 | 121059 | 11 | 5.560 | 21773.2 |
291 | 2024-04-08 04:22:06 | goldfish | 3 | 146162 | 73 | 8.436 | 17326.0 |
290 | 2024-04-07 17:33:53 | goldfish | 3 | 146162 | 73 | 18.423 | 7933.7 |
289 | 2024-04-07 07:16:43 | goldfish | 3 | 146162 | 73 | 30.936 | 4724.7 |
288 | 2024-04-05 09:53:11 | goldfish | 3 | 146162 | 73 | 20.330 | 7189.5 |
287 | 2024-03-31 13:38:09 | goldfish | 4 | 161609 | 415 | 47.563 | 3397.8 |
286 | 2024-03-31 07:01:42 | goldfish | 4 | 161609 | 415 | 31.096 | 5197.1 |
285 | 2024-03-31 07:01:24 | goldfish | 4 | 161609 | 415 | 28.080 | 5755.3 |
284 | 2024-03-31 07:01:34 | goldfish | 1 | 82945 | 1 | 1.750 | 47397.1 |
283 | 2024-03-31 07:01:25 | goldfish | 1 | 82945 | 1 | 4.780 | 17352.5 |
282 | 2024-03-15 23:27:50 | goldfish | 1 | 82945 | 1 | 3.170 | 26165.6 |
281 | 2024-03-11 18:48:55 | goldfish | 4 | 161609 | 415 | 14.940 | 10817.2 |
280 | 2024-03-10 23:49:31 | goldfish | 2 | 121059 | 11 | 7.156 | 16917.1 |
279 | 2024-03-09 21:48:53 | goldfish | 1 | 82945 | 1 | 4.406 | 18825.5 |
278 | 2024-03-09 03:53:27 | goldfish | 2 | 121059 | 11 | 4.000 | 30264.8 |
277 | 2024-03-09 01:07:41 | goldfish | 2 | 121059 | 11 | 14.533 | 8329.9 |
276 | 2024-03-08 22:42:29 | goldfish | 1 | 82945 | 1 | 2.983 | 27805.9 |
275 | 2024-03-08 00:12:56 | goldfish | 3 | 146162 | 73 | 11.016 | 13268.2 |
274 | 2024-03-07 18:18:10 | goldfish | 3 | 146162 | 73 | 9.093 | 16074.1 |
273 | 2024-03-05 08:43:24 | goldfish | 3 | 146162 | 73 | 9.030 | 16186.3 |
272 | 2024-03-04 20:25:12 | goldfish | 3 | 146162 | 73 | 10.546 | 13859.5 |
271 | 2024-02-28 15:58:22 | goldfish | 4 | 161609 | 415 | 17.406 | 9284.7 |
270 | 2024-02-28 14:11:02 | goldfish | 4 | 161609 | 415 | 11.983 | 13486.5 |
269 | 2024-02-28 14:10:57 | goldfish | 1 | 82945 | 1 | 1.546 | 53651.4 |
268 | 2024-02-11 00:53:28 | goldfish | 1 | 82945 | 1 | 4.453 | 18626.8 |
267 | 2024-02-09 13:20:29 | goldfish | 1 | 82945 | 1 | 1.310 | 63316.8 |
266 | 2024-02-09 13:19:44 | goldfish | 1 | 82945 | 1 | 1.656 | 50087.6 |
265 | 2024-02-08 21:35:38 | goldfish | 1 | 82945 | 1 | 1.673 | 49578.6 |
264 | 2024-02-08 09:26:53 | goldfish | 2 | 121059 | 11 | 3.876 | 31233.0 |
263 | 2024-02-08 09:05:32 | goldfish | 1 | 82945 | 1 | 1.533 | 54106.3 |
262 | 2024-02-07 17:59:19 | goldfish | 1 | 82945 | 1 | 1.576 | 52630.1 |
261 | 2024-02-06 12:36:36 | goldfish | 2 | 121059 | 11 | 3.843 | 31501.2 |
260 | 2024-02-06 12:36:01 | goldfish | 3 | 146162 | 73 | 6.580 | 22213.1 |
259 | 2024-02-06 06:51:10 | goldfish | 4 | 161609 | 415 | 13.343 | 12111.9 |
258 | 2024-02-04 20:25:22 | goldfish | 4 | 161609 | 415 | 18.643 | 8668.6 |
257 | 2024-02-04 20:25:16 | goldfish | 3 | 146162 | 73 | 8.763 | 16679.4 |
256 | 2024-01-29 22:58:51 | goldfish | 3 | 146162 | 73 | 13.923 | 10497.9 |
255 | 2024-01-29 11:41:02 | goldfish | 2 | 121059 | 11 | 3.610 | 33534.3 |
254 | 2024-01-29 11:40:57 | goldfish | 3 | 146162 | 73 | 6.983 | 20931.1 |
253 | 2024-01-29 11:40:53 | goldfish | 1 | 82945 | 1 | 1.376 | 60279.8 |
252 | 2024-01-27 16:26:35 | goldfish | 4 | 161609 | 415 | 18.623 | 8677.9 |
251 | 2024-01-27 16:26:39 | goldfish | 4 | 161609 | 415 | 14.123 | 11443.0 |
250 | 2024-01-25 10:53:27 | goldfish | 1 | 82945 | 1 | 1.326 | 62552.8 |
249 | 2024-01-10 09:30:58 | goldfish | 3 | 146162 | 73 | 6.860 | 21306.4 |
248 | 2024-01-05 07:32:46 | goldfish | 3 | 146162 | 73 | 6.796 | 21507.1 |
247 | 2024-01-05 07:32:49 | goldfish | 2 | 121059 | 11 | 3.516 | 34430.9 |
246 | 2023-12-27 20:10:36 | goldfish | 4 | 161609 | 415 | 12.253 | 13189.3 |
245 | 2023-12-24 17:46:17 | goldfish | 4 | 161609 | 415 | 12.076 | 13382.7 |
244 | 2023-12-05 08:39:50 | goldfish | 4 | 161609 | 415 | 15.623 | 10344.3 |
243 | 2023-11-29 23:32:53 | goldfish | 1 | 82945 | 1 | 1.436 | 57761.1 |
242 | 2023-11-27 22:56:08 | goldfish | 1 | 82945 | 1 | 1.343 | 61761.0 |
241 | 2023-11-21 21:16:31 | goldfish | 1 | 82945 | 1 | 1.406 | 58993.6 |
240 | 2023-11-20 10:57:23 | goldfish | 1 | 82945 | 1 | 1.220 | 67987.7 |
239 | 2023-11-18 23:59:15 | goldfish | 1 | 82945 | 1 | 1.263 | 65673.0 |
238 | 2023-11-14 08:33:41 | goldfish | 1 | 82945 | 1 | 3.093 | 26817.0 |
237 | 2023-11-12 15:12:55 | goldfish | 4 | 161609 | 415 | 18.453 | 8757.9 |
236 | 2023-10-22 21:15:12 | goldfish | 1 | 82945 | 1 | 2.983 | 27805.9 |
235 | 2023-10-19 02:59:04 | goldfish | 1 | 82945 | 1 | 1.280 | 64800.8 |
234 | 2023-10-18 09:18:10 | goldfish | 3 | 146162 | 73 | 6.890 | 21213.6 |
233 | 2023-10-14 05:53:41 | goldfish | 1 | 82945 | 1 | 1.406 | 58993.6 |
232 | 2023-09-21 08:30:03 | goldfish | 1 | 82945 | 1 | 1.390 | 59672.7 |
231 | 2023-09-06 16:58:11 | goldfish | 1 | 82945 | 1 | 1.360 | 60989.0 |
230 | 2023-08-15 17:22:20 | goldfish | 4 | 161609 | 415 | 10.670 | 15146.1 |
229 | 2023-08-06 10:14:13 | goldfish | 1 | 82945 | 1 | 1.236 | 67107.6 |
228 | 2023-08-05 08:00:07 | goldfish | 1 | 82945 | 1 | 1.343 | 61761.0 |
227 | 2023-08-04 12:45:37 | goldfish | 1 | 82945 | 1 | 1.436 | 57761.1 |
226 | 2023-08-03 12:46:12 | goldfish | 1 | 82945 | 1 | 1.266 | 65517.4 |
225 | 2023-08-02 11:10:56 | goldfish | 1 | 82945 | 1 | 1.390 | 59672.7 |
224 | 2023-07-29 23:17:14 | goldfish | 3 | 146162 | 73 | 6.800 | 21494.4 |
223 | 2023-07-09 00:35:52 | goldfish | 1 | 82945 | 1 | 1.376 | 60279.8 |
222 | 2023-07-08 09:32:30 | goldfish | 1 | 82945 | 1 | 1.250 | 66356.0 |
221 | 2023-07-07 03:05:48 | goldfish | 1 | 82945 | 1 | 1.216 | 68211.3 |
220 | 2023-07-06 15:01:27 | goldfish | 1 | 82945 | 1 | 1.236 | 67107.6 |
219 | 2023-07-05 01:44:19 | goldfish | 1 | 82945 | 1 | 1.296 | 64000.8 |
218 | 2023-07-04 09:17:57 | goldfish | 1 | 82945 | 1 | 1.216 | 68211.3 |
217 | 2023-07-03 20:09:51 | goldfish | 1 | 82945 | 1 | 1.280 | 64800.8 |
216 | 2023-07-03 01:38:02 | goldfish | 1 | 82945 | 1 | 1.250 | 66356.0 |
215 | 2023-07-02 08:31:48 | goldfish | 1 | 82945 | 1 | 1.250 | 66356.0 |
214 | 2023-07-01 21:36:56 | goldfish | 1 | 82945 | 1 | 1.250 | 66356.0 |
213 | 2023-07-01 04:17:59 | goldfish | 1 | 82945 | 1 | 1.390 | 59672.7 |
212 | 2023-06-30 08:20:08 | goldfish | 1 | 82945 | 1 | 1.233 | 67270.9 |
211 | 2023-06-29 20:09:12 | goldfish | 1 | 82945 | 1 | 1.373 | 60411.5 |
210 | 2023-06-29 02:22:50 | goldfish | 1 | 82945 | 1 | 1.250 | 66356.0 |
209 | 2023-06-28 13:42:18 | goldfish | 1 | 82945 | 1 | 1.280 | 64800.8 |
208 | 2023-06-27 21:18:05 | goldfish | 1 | 82945 | 1 | 1.280 | 64800.8 |
207 | 2023-06-27 02:51:21 | goldfish | 1 | 82945 | 1 | 2.486 | 33364.8 |
206 | 2023-06-26 14:18:26 | goldfish | 1 | 82945 | 1 | 1.390 | 59672.7 |
205 | 2023-06-25 14:17:08 | goldfish | 1 | 82945 | 1 | 1.296 | 64000.8 |
204 | 2023-06-24 22:21:44 | goldfish | 1 | 82945 | 1 | 1.300 | 63803.8 |
203 | 2023-06-24 08:34:12 | goldfish | 1 | 82945 | 1 | 1.266 | 65517.4 |
202 | 2023-06-23 13:19:16 | goldfish | 1 | 82945 | 1 | 1.360 | 60989.0 |
201 | 2023-06-22 08:53:20 | goldfish | 1 | 82945 | 1 | 1.373 | 60411.5 |