History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prospecting"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
287 | 2024-05-25 17:56:15 | prospecting | 3 | 121633 | 35 | 11.876 | 10241.9 |
286 | 2024-05-24 22:37:31 | prospecting | 3 | 121633 | 35 | 10.253 | 11863.2 |
285 | 2024-05-24 14:00:27 | prospecting | 3 | 121633 | 35 | 14.686 | 8282.2 |
284 | 2024-05-24 13:59:56 | prospecting | 2 | 86808 | 8 | 6.186 | 14033.0 |
283 | 2024-05-24 13:59:04 | prospecting | 1 | 49908 | 2 | 3.483 | 14329.0 |
282 | 2024-05-21 01:49:07 | prospecting | 4 | 148819 | 183 | 33.156 | 4488.4 |
281 | 2024-05-20 14:57:35 | prospecting | 4 | 148819 | 183 | 30.220 | 4924.5 |
280 | 2024-05-20 14:00:50 | prospecting | 4 | 148819 | 183 | 31.690 | 4696.1 |
279 | 2024-05-17 11:41:23 | prospecting | 4 | 148819 | 183 | 33.753 | 4409.1 |
278 | 2024-05-15 19:01:15 | prospecting | 3 | 121633 | 35 | 16.500 | 7371.7 |
277 | 2024-05-15 19:00:53 | prospecting | 2 | 86808 | 8 | 9.890 | 8777.4 |
276 | 2024-05-15 18:58:44 | prospecting | 1 | 49908 | 2 | 2.470 | 20205.7 |
275 | 2024-05-14 15:41:30 | prospecting | 3 | 121633 | 35 | 9.360 | 12995.0 |
274 | 2024-05-14 15:41:14 | prospecting | 4 | 148819 | 183 | 23.313 | 6383.5 |
273 | 2024-05-14 15:41:28 | prospecting | 2 | 86808 | 8 | 6.470 | 13417.0 |
272 | 2024-05-14 15:26:24 | prospecting | 1 | 49908 | 2 | 0.906 | 55086.1 |
271 | 2024-05-13 17:00:30 | prospecting | 3 | 121633 | 35 | 13.530 | 8989.9 |
270 | 2024-05-13 17:00:37 | prospecting | 2 | 86808 | 8 | 5.906 | 14698.3 |
269 | 2024-05-13 16:58:23 | prospecting | 1 | 49908 | 2 | 1.983 | 25167.9 |
268 | 2024-05-08 08:47:52 | prospecting | 2 | 86808 | 8 | 5.343 | 16247.1 |
267 | 2024-05-08 08:47:20 | prospecting | 1 | 49908 | 2 | 1.860 | 26832.3 |
266 | 2024-04-22 15:29:35 | prospecting | 3 | 121633 | 35 | 7.220 | 16846.7 |
265 | 2024-04-22 00:26:49 | prospecting | 1 | 49908 | 2 | 1.796 | 27788.4 |
264 | 2024-04-22 00:26:26 | prospecting | 3 | 121633 | 35 | 23.313 | 5217.4 |
263 | 2024-04-22 00:26:25 | prospecting | 2 | 86808 | 8 | 5.356 | 16207.6 |
262 | 2024-04-22 00:26:00 | prospecting | 1 | 49908 | 2 | 1.030 | 48454.4 |
261 | 2024-04-18 14:51:04 | prospecting | 4 | 148819 | 183 | 33.986 | 4378.8 |
260 | 2024-04-18 07:57:31 | prospecting | 4 | 148819 | 183 | 31.346 | 4747.6 |
259 | 2024-04-18 07:57:40 | prospecting | 4 | 148819 | 183 | 11.986 | 12416.1 |
258 | 2024-04-17 05:59:03 | prospecting | 4 | 148819 | 183 | 31.816 | 4677.5 |
257 | 2024-04-11 21:02:44 | prospecting | 4 | 148819 | 183 | 29.173 | 5101.3 |
256 | 2024-04-11 21:02:43 | prospecting | 3 | 121633 | 35 | 19.346 | 6287.2 |
255 | 2024-04-11 21:02:52 | prospecting | 2 | 86808 | 8 | 3.673 | 23634.1 |
254 | 2024-04-11 21:00:19 | prospecting | 1 | 49908 | 2 | 1.530 | 32619.6 |
253 | 2024-04-10 13:51:52 | prospecting | 2 | 86808 | 8 | 6.330 | 13713.7 |
252 | 2024-04-10 13:24:16 | prospecting | 1 | 49908 | 2 | 1.516 | 32920.8 |
251 | 2024-04-07 20:25:12 | prospecting | 2 | 86808 | 8 | 4.530 | 19162.9 |
250 | 2024-04-07 20:24:24 | prospecting | 1 | 49908 | 2 | 2.063 | 24192.0 |
249 | 2024-03-27 09:25:05 | prospecting | 1 | 49908 | 2 | 0.860 | 58032.6 |
248 | 2024-03-18 15:14:48 | prospecting | 3 | 121633 | 35 | 9.766 | 12454.7 |
247 | 2024-03-18 15:14:08 | prospecting | 2 | 86808 | 8 | 4.656 | 18644.3 |
246 | 2024-03-18 14:51:17 | prospecting | 1 | 49908 | 2 | 0.783 | 63739.5 |
245 | 2024-03-18 13:04:50 | prospecting | 3 | 121633 | 35 | 24.623 | 4939.8 |
244 | 2024-03-17 01:46:20 | prospecting | 3 | 121633 | 35 | 11.263 | 10799.3 |
243 | 2024-03-16 22:27:29 | prospecting | 4 | 148819 | 183 | 22.596 | 6586.1 |
242 | 2024-03-16 17:04:33 | prospecting | 3 | 121633 | 35 | 8.156 | 14913.3 |
241 | 2024-03-15 22:20:11 | prospecting | 4 | 148819 | 183 | 12.156 | 12242.4 |
240 | 2024-03-15 11:01:14 | prospecting | 4 | 148819 | 183 | 12.190 | 12208.3 |
239 | 2024-03-15 11:01:16 | prospecting | 3 | 121633 | 35 | 8.190 | 14851.4 |
238 | 2024-03-15 11:01:15 | prospecting | 2 | 86808 | 8 | 2.986 | 29071.7 |
237 | 2024-03-15 09:59:10 | prospecting | 1 | 49908 | 2 | 0.843 | 59202.8 |
236 | 2024-03-13 17:38:57 | prospecting | 2 | 86808 | 8 | 4.233 | 20507.4 |
235 | 2024-03-11 12:01:22 | prospecting | 1 | 49908 | 2 | 2.970 | 16804.0 |
234 | 2024-03-05 16:36:23 | prospecting | 1 | 49908 | 2 | 1.703 | 29305.9 |
233 | 2024-02-28 08:44:50 | prospecting | 1 | 49908 | 2 | 1.000 | 49908.0 |
232 | 2024-02-15 01:40:28 | prospecting | 3 | 121633 | 35 | 10.643 | 11428.5 |
231 | 2024-02-15 01:40:30 | prospecting | 2 | 86808 | 8 | 5.796 | 14977.2 |
230 | 2024-02-12 11:51:25 | prospecting | 4 | 148819 | 183 | 11.720 | 12697.9 |
229 | 2024-02-11 22:42:18 | prospecting | 1 | 49908 | 2 | 3.203 | 15581.6 |
228 | 2024-02-11 05:52:21 | prospecting | 4 | 148819 | 183 | 11.486 | 12956.6 |
227 | 2024-02-09 19:07:08 | prospecting | 1 | 49908 | 2 | 1.873 | 26646.0 |
226 | 2024-02-04 14:03:13 | prospecting | 4 | 148819 | 183 | 19.656 | 7571.2 |
225 | 2024-02-04 14:03:05 | prospecting | 2 | 86808 | 8 | 14.780 | 5873.3 |
224 | 2024-02-04 14:03:06 | prospecting | 3 | 121633 | 35 | 6.420 | 18946.0 |
223 | 2024-02-04 13:11:10 | prospecting | 3 | 121633 | 35 | 12.343 | 9854.4 |
222 | 2024-02-04 13:11:01 | prospecting | 4 | 148819 | 183 | 19.533 | 7618.9 |
221 | 2024-02-04 13:11:07 | prospecting | 2 | 86808 | 8 | 3.140 | 27645.9 |
220 | 2024-02-04 11:02:02 | prospecting | 1 | 49908 | 2 | 0.906 | 55086.1 |
219 | 2024-02-04 11:01:57 | prospecting | 1 | 49908 | 2 | 0.873 | 57168.4 |
218 | 2024-01-05 04:28:10 | prospecting | 1 | 49908 | 2 | 0.860 | 58032.6 |
217 | 2023-12-21 22:45:16 | prospecting | 1 | 49908 | 2 | 0.906 | 55086.1 |
216 | 2023-11-26 12:04:16 | prospecting | 2 | 86808 | 8 | 2.063 | 42078.5 |
215 | 2023-11-22 06:35:28 | prospecting | 4 | 148819 | 183 | 8.716 | 17074.2 |
214 | 2023-11-22 06:35:26 | prospecting | 3 | 121633 | 35 | 4.796 | 25361.3 |
213 | 2023-11-22 06:35:23 | prospecting | 2 | 86808 | 8 | 2.456 | 35345.3 |
212 | 2023-11-02 02:37:00 | prospecting | 1 | 49908 | 2 | 0.860 | 58032.6 |
211 | 2023-10-28 08:14:56 | prospecting | 4 | 148819 | 183 | 18.936 | 7859.1 |
210 | 2023-10-28 08:14:44 | prospecting | 3 | 121633 | 35 | 14.876 | 8176.5 |
209 | 2023-10-28 08:14:50 | prospecting | 2 | 86808 | 8 | 8.110 | 10703.8 |
208 | 2023-10-25 21:04:41 | prospecting | 1 | 49908 | 2 | 0.763 | 65410.2 |
207 | 2023-10-21 18:02:07 | prospecting | 1 | 49908 | 2 | 0.796 | 62698.5 |
206 | 2023-10-13 23:35:27 | prospecting | 1 | 49908 | 2 | 0.876 | 56972.6 |
205 | 2023-10-10 01:44:35 | prospecting | 1 | 49908 | 2 | 0.903 | 55269.1 |
204 | 2023-08-25 22:44:52 | prospecting | 2 | 86808 | 8 | 2.453 | 35388.5 |
203 | 2023-08-06 06:33:29 | prospecting | 1 | 49908 | 2 | 0.766 | 65154.0 |
202 | 2023-06-03 19:58:13 | prospecting | 1 | 49908 | 2 | 0.733 | 68087.3 |
201 | 2023-05-11 05:31:00 | prospecting | 2 | 86808 | 8 | 2.096 | 41416.0 |
200 | 2023-05-05 09:16:04 | prospecting | 1 | 49908 | 2 | 0.750 | 66544.0 |
199 | 2023-03-01 03:17:34 | prospecting | 1 | 49908 | 2 | 0.810 | 61614.8 |
198 | 2023-02-16 06:39:33 | prospecting | 2 | 86808 | 8 | 2.313 | 37530.5 |
197 | 2023-01-25 08:25:25 | prospecting | 1 | 49908 | 2 | 0.843 | 59202.8 |
196 | 2023-01-21 16:17:04 | prospecting | 1 | 49908 | 2 | 0.843 | 59202.8 |
195 | 2022-12-24 01:58:49 | prospecting | 1 | 49908 | 2 | 0.846 | 58992.9 |
194 | 2022-11-28 12:56:59 | prospecting | 2 | 86808 | 8 | 2.080 | 41734.6 |
193 | 2022-09-10 13:16:32 | prospecting | 1 | 49908 | 2 | 0.763 | 65410.2 |
192 | 2022-09-08 14:39:14 | prospecting | 1 | 49908 | 2 | 0.780 | 63984.6 |
191 | 2022-09-08 10:34:09 | prospecting | 1 | 49908 | 2 | 0.796 | 62698.5 |
190 | 2022-07-06 00:15:01 | prospecting | 2 | 86808 | 8 | 2.140 | 40564.5 |
189 | 2022-04-18 15:15:08 | prospecting | 1 | 49908 | 2 | 0.923 | 54071.5 |
188 | 2022-04-17 11:02:12 | prospecting | 1 | 49908 | 2 | 0.830 | 60130.1 |