History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"companies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
291 | 2024-04-05 10:59:49 | companies | 1 | 81242 | 2 | 3.110 | 26122.8 |
290 | 2024-03-29 22:58:15 | companies | 2 | 121436 | 12 | 12.750 | 9524.4 |
289 | 2024-03-29 22:06:35 | companies | 1 | 81242 | 2 | 3.530 | 23014.7 |
288 | 2024-03-29 10:16:14 | companies | 1 | 81242 | 2 | 1.580 | 51419.0 |
287 | 2024-03-29 08:59:01 | companies | 2 | 121436 | 12 | 12.720 | 9546.9 |
286 | 2024-03-28 19:24:56 | companies | 3 | 148641 | 108 | 15.956 | 9315.7 |
285 | 2024-03-27 12:41:07 | companies | 3 | 148641 | 108 | 8.970 | 16570.9 |
284 | 2024-03-27 12:41:01 | companies | 2 | 121436 | 12 | 12.796 | 9490.2 |
283 | 2024-03-27 08:46:41 | companies | 1 | 81242 | 2 | 1.466 | 55417.5 |
282 | 2024-03-07 11:42:48 | companies | 1 | 81242 | 2 | 3.170 | 25628.4 |
281 | 2024-02-29 06:57:30 | companies | 1 | 81242 | 2 | 2.920 | 27822.6 |
280 | 2024-02-27 20:52:38 | companies | 1 | 81242 | 2 | 1.466 | 55417.5 |
279 | 2024-02-26 12:07:31 | companies | 1 | 81242 | 2 | 1.530 | 53099.3 |
278 | 2024-02-17 02:31:27 | companies | 3 | 148641 | 108 | 11.953 | 12435.5 |
277 | 2024-02-16 12:21:12 | companies | 3 | 148641 | 108 | 10.283 | 14455.0 |
276 | 2024-02-08 20:18:46 | companies | 3 | 148641 | 108 | 17.923 | 8293.3 |
275 | 2024-02-08 20:18:44 | companies | 2 | 121436 | 12 | 8.890 | 13659.8 |
274 | 2024-02-06 13:49:46 | companies | 1 | 81242 | 2 | 1.953 | 41598.6 |
273 | 2024-02-01 11:17:28 | companies | 1 | 81242 | 2 | 1.266 | 64172.2 |
272 | 2023-12-30 19:33:25 | companies | 2 | 121436 | 12 | 3.186 | 38115.5 |
271 | 2023-12-28 19:21:36 | companies | 3 | 148641 | 108 | 7.076 | 21006.4 |
270 | 2023-12-12 17:08:47 | companies | 3 | 148641 | 108 | 6.516 | 22811.7 |
269 | 2023-12-12 17:08:49 | companies | 2 | 121436 | 12 | 3.593 | 33797.9 |
268 | 2023-12-03 18:08:07 | companies | 3 | 148641 | 108 | 7.670 | 19379.5 |
267 | 2023-12-03 18:08:05 | companies | 2 | 121436 | 12 | 7.236 | 16782.2 |
266 | 2023-11-29 08:24:37 | companies | 1 | 81242 | 2 | 1.360 | 59736.8 |
265 | 2023-11-27 06:33:56 | companies | 3 | 148641 | 108 | 6.703 | 22175.3 |
264 | 2023-11-27 06:33:53 | companies | 2 | 121436 | 12 | 3.500 | 34696.0 |
263 | 2023-11-14 05:11:13 | companies | 1 | 81242 | 2 | 1.253 | 64838.0 |
262 | 2023-11-11 03:28:14 | companies | 1 | 81242 | 2 | 1.296 | 62686.7 |
261 | 2023-11-10 02:02:43 | companies | 1 | 81242 | 2 | 1.436 | 56575.2 |
260 | 2023-10-27 23:56:16 | companies | 1 | 81242 | 2 | 1.343 | 60492.9 |
259 | 2023-10-20 04:10:11 | companies | 1 | 81242 | 2 | 1.500 | 54161.3 |
258 | 2023-10-18 01:05:32 | companies | 1 | 81242 | 2 | 1.373 | 59171.2 |
257 | 2023-10-14 04:08:05 | companies | 1 | 81242 | 2 | 1.250 | 64993.6 |
256 | 2023-10-04 05:48:17 | companies | 1 | 81242 | 2 | 1.266 | 64172.2 |
255 | 2023-10-02 22:33:05 | companies | 2 | 121436 | 12 | 3.093 | 39261.6 |
254 | 2023-09-23 12:29:41 | companies | 1 | 81242 | 2 | 1.250 | 64993.6 |
253 | 2023-09-14 16:31:30 | companies | 1 | 81242 | 2 | 1.233 | 65889.7 |
252 | 2023-09-12 05:41:04 | companies | 1 | 81242 | 2 | 1.310 | 62016.8 |
251 | 2023-08-11 17:47:09 | companies | 1 | 81242 | 2 | 1.406 | 57782.4 |
250 | 2023-07-14 06:15:26 | companies | 2 | 121436 | 12 | 3.783 | 32100.4 |
249 | 2023-06-16 08:25:05 | companies | 1 | 81242 | 2 | 1.280 | 63470.3 |
248 | 2023-05-04 05:14:08 | companies | 1 | 81242 | 2 | 1.330 | 61084.2 |
247 | 2023-03-31 00:03:22 | companies | 1 | 81242 | 2 | 1.250 | 64993.6 |
246 | 2023-03-30 15:39:18 | companies | 2 | 121436 | 12 | 3.313 | 36654.4 |
245 | 2023-01-21 23:41:38 | companies | 1 | 81242 | 2 | 1.250 | 64993.6 |
244 | 2023-01-17 12:50:50 | companies | 3 | 148641 | 108 | 10.216 | 14549.8 |
243 | 2023-01-13 09:54:36 | companies | 1 | 81242 | 2 | 1.390 | 58447.5 |
242 | 2023-01-04 23:57:16 | companies | 3 | 148641 | 108 | 7.093 | 20956.0 |
241 | 2022-12-26 06:21:58 | companies | 2 | 121436 | 12 | 3.280 | 37023.2 |
240 | 2022-12-14 08:26:12 | companies | 3 | 148641 | 108 | 6.080 | 24447.5 |
239 | 2022-11-08 16:00:29 | companies | 3 | 148641 | 108 | 6.156 | 24145.7 |
238 | 2022-10-26 02:54:22 | companies | 1 | 81242 | 2 | 1.280 | 63470.3 |
237 | 2022-10-11 08:21:26 | companies | 1 | 81242 | 2 | 1.250 | 64993.6 |
236 | 2022-10-05 15:28:17 | companies | 3 | 148641 | 108 | 7.076 | 21006.4 |
235 | 2022-08-25 13:04:45 | companies | 2 | 121436 | 12 | 3.140 | 38673.9 |
234 | 2022-07-15 10:56:58 | companies | 3 | 148641 | 108 | 6.093 | 24395.4 |
233 | 2022-06-20 23:28:06 | companies | 1 | 81242 | 2 | 1.330 | 61084.2 |
232 | 2022-06-16 13:15:11 | companies | 1 | 81242 | 2 | 1.263 | 64324.6 |
231 | 2022-06-14 08:50:01 | companies | 1 | 81242 | 2 | 1.250 | 64993.6 |
230 | 2022-04-06 20:07:27 | companies | 2 | 121436 | 12 | 3.640 | 33361.5 |
229 | 2022-03-05 05:22:48 | companies | 1 | 81242 | 2 | 1.453 | 55913.3 |
228 | 2022-02-17 14:24:21 | companies | 1 | 81242 | 2 | 1.826 | 44491.8 |
227 | 2021-12-08 21:07:57 | companies | 1 | 81242 | 2 | 1.440 | 56418.1 |
226 | 2021-11-21 11:29:02 | companies | 1 | 81242 | 2 | 1.296 | 62686.7 |
225 | 2021-10-14 04:58:39 | companies | 1 | 81242 | 2 | 1.436 | 56575.2 |
224 | 2021-09-05 21:19:52 | companies | 1 | 81242 | 2 | 1.470 | 55266.7 |
223 | 2021-08-18 14:43:12 | companies | 1 | 81242 | 2 | 1.453 | 55913.3 |
222 | 2021-08-17 02:57:38 | companies | 1 | 81242 | 2 | 1.250 | 64993.6 |
221 | 2021-05-31 15:06:08 | companies | 1 | 81242 | 2 | 1.436 | 56575.2 |
220 | 2021-05-24 22:10:28 | companies | 1 | 81242 | 2 | 1.470 | 55266.7 |
219 | 2021-05-17 22:22:49 | companies | 1 | 81242 | 2 | 1.546 | 52549.8 |
218 | 2021-05-01 08:35:41 | companies | 1 | 81242 | 2 | 2.266 | 35852.6 |
217 | 2021-04-28 07:22:47 | companies | 1 | 81242 | 2 | 1.483 | 54782.2 |
216 | 2021-02-14 15:41:58 | companies | 1 | 81242 | 2 | 1.266 | 64172.2 |
215 | 2021-01-11 11:02:04 | companies | 1 | 81242 | 2 | 1.513 | 53696.0 |
214 | 2020-11-18 13:02:30 | companies | 1 | 81242 | 2 | 1.406 | 57782.4 |
213 | 2020-11-15 00:06:10 | companies | 1 | 81242 | 2 | 2.373 | 34236.0 |
212 | 2020-09-29 11:38:23 | companies | 1 | 81242 | 2 | 1.250 | 64993.6 |
211 | 2020-08-22 04:05:37 | companies | 1 | 81242 | 2 | 1.296 | 62686.7 |
210 | 2020-08-10 08:24:54 | companies | 1 | 81242 | 2 | 1.436 | 56575.2 |
209 | 2020-08-03 02:43:50 | companies | 1 | 81242 | 2 | 1.313 | 61875.1 |
208 | 2020-05-09 02:59:55 | companies | 1 | 81242 | 2 | 1.453 | 55913.3 |
207 | 2020-03-27 07:51:19 | companies | 1 | 81242 | 2 | 1.453 | 55913.3 |
206 | 2020-03-25 02:55:43 | companies | 1 | 81242 | 2 | 1.516 | 53589.7 |
205 | 2020-03-21 20:15:51 | companies | 1 | 81242 | 2 | 1.263 | 64324.6 |
204 | 2020-02-26 02:59:53 | companies | 1 | 81242 | 2 | 1.686 | 48186.2 |
203 | 2020-02-18 03:11:17 | companies | 1 | 81242 | 2 | 1.640 | 49537.8 |
202 | 2020-02-14 18:56:22 | companies | 3 | 148641 | 108 | 15.406 | 9648.3 |
201 | 2020-02-13 05:11:46 | companies | 1 | 81242 | 2 | 1.593 | 50999.4 |
200 | 2020-02-12 15:36:38 | companies | 1 | 81242 | 2 | 3.233 | 25129.0 |
199 | 2020-02-09 09:34:32 | companies | 1 | 81242 | 2 | 1.576 | 51549.5 |
198 | 2020-02-06 13:40:57 | companies | 1 | 81242 | 2 | 1.330 | 61084.2 |
197 | 2020-02-03 16:07:30 | companies | 1 | 81242 | 2 | 3.513 | 23126.1 |
196 | 2020-02-01 12:36:03 | companies | 1 | 81242 | 2 | 1.606 | 50586.6 |
195 | 2020-02-01 02:59:22 | companies | 1 | 81242 | 2 | 1.516 | 53589.7 |
194 | 2020-01-22 12:26:27 | companies | 1 | 81242 | 2 | 1.470 | 55266.7 |
193 | 2020-01-22 01:28:36 | companies | 1 | 81242 | 2 | 1.513 | 53696.0 |
192 | 2020-01-15 23:47:27 | companies | 1 | 81242 | 2 | 1.360 | 59736.8 |