History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"deterrent"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
303 | 2024-04-18 16:04:38 | deterrent | 1 | 81242 | 4 | 3.110 | 26122.8 |
302 | 2024-04-18 16:03:42 | deterrent | 1 | 81242 | 4 | 3.953 | 20552.0 |
301 | 2024-04-14 11:19:04 | deterrent | 1 | 81242 | 4 | 2.483 | 32719.3 |
300 | 2024-04-13 14:31:38 | deterrent | 4 | 165329 | 293 | 11.546 | 14319.2 |
299 | 2024-04-11 19:38:31 | deterrent | 4 | 165329 | 293 | 43.050 | 3840.4 |
298 | 2024-04-10 16:36:20 | deterrent | 4 | 165329 | 293 | 42.346 | 3904.2 |
297 | 2024-04-10 16:24:14 | deterrent | 3 | 148641 | 47 | 26.376 | 5635.5 |
296 | 2024-04-10 16:24:05 | deterrent | 2 | 121436 | 15 | 11.813 | 10279.9 |
295 | 2024-04-10 16:23:46 | deterrent | 1 | 81242 | 4 | 1.970 | 41239.6 |
294 | 2024-04-09 20:22:48 | deterrent | 4 | 165329 | 293 | 27.363 | 6042.1 |
293 | 2024-04-04 13:57:55 | deterrent | 1 | 81242 | 4 | 1.373 | 59171.2 |
292 | 2024-04-02 07:57:22 | deterrent | 2 | 121436 | 15 | 4.436 | 27375.1 |
291 | 2024-04-02 07:50:43 | deterrent | 3 | 148641 | 47 | 23.423 | 6345.9 |
290 | 2024-04-01 19:32:49 | deterrent | 4 | 165329 | 293 | 40.113 | 4121.6 |
289 | 2024-04-01 17:27:01 | deterrent | 4 | 165329 | 293 | 36.690 | 4506.1 |
288 | 2024-04-01 09:52:05 | deterrent | 4 | 165329 | 293 | 23.940 | 6906.0 |
287 | 2024-04-01 09:52:08 | deterrent | 3 | 148641 | 47 | 20.533 | 7239.1 |
286 | 2024-04-01 09:52:05 | deterrent | 2 | 121436 | 15 | 8.560 | 14186.4 |
285 | 2024-04-01 09:51:04 | deterrent | 1 | 81242 | 4 | 1.890 | 42985.2 |
284 | 2024-03-07 18:47:40 | deterrent | 1 | 81242 | 4 | 2.703 | 30056.2 |
283 | 2024-03-07 09:48:11 | deterrent | 1 | 81242 | 4 | 6.593 | 12322.5 |
282 | 2024-03-04 21:06:24 | deterrent | 1 | 81242 | 4 | 2.940 | 27633.3 |
281 | 2024-03-02 09:12:24 | deterrent | 1 | 81242 | 4 | 1.580 | 51419.0 |
280 | 2024-02-27 13:19:14 | deterrent | 1 | 81242 | 4 | 1.263 | 64324.6 |
279 | 2024-02-06 07:55:33 | deterrent | 3 | 148641 | 47 | 11.686 | 12719.6 |
278 | 2024-02-06 07:55:37 | deterrent | 2 | 121436 | 15 | 7.466 | 16265.2 |
277 | 2024-02-06 07:55:30 | deterrent | 4 | 165329 | 293 | 12.906 | 12810.2 |
276 | 2024-02-06 07:54:57 | deterrent | 1 | 81242 | 4 | 1.436 | 56575.2 |
275 | 2024-02-06 04:44:25 | deterrent | 1 | 81242 | 4 | 2.420 | 33571.1 |
274 | 2024-01-31 08:04:48 | deterrent | 1 | 81242 | 4 | 1.420 | 57212.7 |
273 | 2024-01-30 14:18:55 | deterrent | 1 | 81242 | 4 | 1.406 | 57782.4 |
272 | 2024-01-27 11:34:31 | deterrent | 1 | 81242 | 4 | 1.390 | 58447.5 |
271 | 2024-01-07 04:42:19 | deterrent | 1 | 81242 | 4 | 1.310 | 62016.8 |
270 | 2023-12-31 20:14:03 | deterrent | 1 | 81242 | 4 | 1.373 | 59171.2 |
269 | 2023-12-26 20:53:32 | deterrent | 1 | 81242 | 4 | 2.263 | 35900.1 |
268 | 2023-10-22 15:36:47 | deterrent | 1 | 81242 | 4 | 1.236 | 65729.8 |
267 | 2023-09-24 22:08:39 | deterrent | 1 | 81242 | 4 | 1.360 | 59736.8 |
266 | 2023-09-21 17:11:33 | deterrent | 1 | 81242 | 4 | 1.250 | 64993.6 |
265 | 2023-08-17 13:57:33 | deterrent | 1 | 81242 | 4 | 2.390 | 33992.5 |
264 | 2023-05-22 10:22:35 | deterrent | 1 | 81242 | 4 | 1.250 | 64993.6 |
263 | 2023-05-19 00:50:09 | deterrent | 1 | 81242 | 4 | 1.500 | 54161.3 |
262 | 2023-05-18 15:25:43 | deterrent | 1 | 81242 | 4 | 1.263 | 64324.6 |
261 | 2023-03-14 02:05:47 | deterrent | 1 | 81242 | 4 | 1.346 | 60358.1 |
260 | 2023-01-28 08:27:59 | deterrent | 1 | 81242 | 4 | 1.220 | 66591.8 |
259 | 2023-01-22 13:53:02 | deterrent | 1 | 81242 | 4 | 1.453 | 55913.3 |
258 | 2022-12-13 13:32:14 | deterrent | 1 | 81242 | 4 | 1.343 | 60492.9 |
257 | 2022-11-10 21:04:26 | deterrent | 1 | 81242 | 4 | 1.373 | 59171.2 |
256 | 2022-09-16 16:22:45 | deterrent | 1 | 81242 | 4 | 1.236 | 65729.8 |
255 | 2022-04-30 04:22:17 | deterrent | 1 | 81242 | 4 | 1.343 | 60492.9 |
254 | 2022-04-29 14:06:32 | deterrent | 1 | 81242 | 4 | 1.703 | 47705.2 |
253 | 2022-01-06 15:36:21 | deterrent | 1 | 81242 | 4 | 1.343 | 60492.9 |
252 | 2022-01-05 19:56:53 | deterrent | 1 | 81242 | 4 | 1.530 | 53099.3 |
251 | 2021-12-15 11:10:35 | deterrent | 4 | 165329 | 293 | 12.643 | 13076.7 |
250 | 2021-11-08 23:43:03 | deterrent | 4 | 165329 | 293 | 11.393 | 14511.5 |
249 | 2021-11-08 04:04:54 | deterrent | 1 | 81242 | 4 | 1.390 | 58447.5 |
248 | 2021-10-27 04:57:58 | deterrent | 4 | 165329 | 293 | 10.703 | 15447.0 |
247 | 2021-10-14 15:00:14 | deterrent | 1 | 81242 | 4 | 1.593 | 50999.4 |
246 | 2021-10-08 19:45:29 | deterrent | 4 | 165329 | 293 | 12.796 | 12920.4 |
245 | 2021-09-14 11:54:49 | deterrent | 1 | 81242 | 4 | 1.250 | 64993.6 |
244 | 2021-08-18 15:49:56 | deterrent | 4 | 165329 | 293 | 10.736 | 15399.5 |
243 | 2021-08-09 17:10:16 | deterrent | 4 | 165329 | 293 | 10.826 | 15271.5 |
242 | 2021-08-02 10:13:05 | deterrent | 4 | 165329 | 293 | 11.440 | 14451.8 |
241 | 2021-07-04 11:33:46 | deterrent | 4 | 165329 | 293 | 11.716 | 14111.4 |
240 | 2021-06-15 20:38:18 | deterrent | 1 | 81242 | 4 | 1.360 | 59736.8 |
239 | 2021-06-10 09:39:42 | deterrent | 1 | 81242 | 4 | 1.266 | 64172.2 |
238 | 2021-05-18 06:03:38 | deterrent | 4 | 165329 | 293 | 12.546 | 13177.8 |
237 | 2021-05-16 09:00:03 | deterrent | 2 | 121436 | 15 | 3.140 | 38673.9 |
236 | 2021-05-13 05:41:31 | deterrent | 1 | 81242 | 4 | 1.420 | 57212.7 |
235 | 2021-05-01 01:31:57 | deterrent | 1 | 81242 | 4 | 1.406 | 57782.4 |
234 | 2021-03-07 22:38:37 | deterrent | 1 | 81242 | 4 | 1.313 | 61875.1 |
233 | 2021-02-28 13:55:14 | deterrent | 1 | 81242 | 4 | 1.470 | 55266.7 |
232 | 2021-02-23 17:27:11 | deterrent | 4 | 165329 | 293 | 12.753 | 12963.9 |
231 | 2021-01-28 22:48:14 | deterrent | 2 | 121436 | 15 | 3.296 | 36843.4 |
230 | 2020-12-11 06:55:36 | deterrent | 1 | 81242 | 4 | 1.280 | 63470.3 |
229 | 2020-12-04 06:49:36 | deterrent | 1 | 81242 | 4 | 1.326 | 61268.5 |
228 | 2020-11-11 05:54:22 | deterrent | 4 | 165329 | 293 | 12.313 | 13427.2 |
227 | 2020-11-09 10:04:34 | deterrent | 2 | 121436 | 15 | 3.346 | 36292.9 |
226 | 2020-10-24 17:52:49 | deterrent | 1 | 81242 | 4 | 2.110 | 38503.3 |
225 | 2020-09-10 04:17:03 | deterrent | 1 | 81242 | 4 | 1.263 | 64324.6 |
224 | 2020-09-06 22:07:35 | deterrent | 1 | 81242 | 4 | 1.220 | 66591.8 |
223 | 2020-08-29 13:52:32 | deterrent | 1 | 81242 | 4 | 1.283 | 63321.9 |
222 | 2020-08-06 20:38:03 | deterrent | 1 | 81242 | 4 | 1.406 | 57782.4 |
221 | 2020-07-20 02:34:05 | deterrent | 1 | 81242 | 4 | 1.376 | 59042.2 |
220 | 2020-07-19 02:34:41 | deterrent | 1 | 81242 | 4 | 1.406 | 57782.4 |
219 | 2020-07-17 10:12:28 | deterrent | 1 | 81242 | 4 | 1.423 | 57092.1 |
218 | 2020-06-14 07:21:12 | deterrent | 1 | 81242 | 4 | 1.440 | 56418.1 |
217 | 2020-06-13 08:19:14 | deterrent | 1 | 81242 | 4 | 1.390 | 58447.5 |
216 | 2020-05-12 15:31:58 | deterrent | 1 | 81242 | 4 | 1.263 | 64324.6 |
215 | 2020-05-04 15:48:28 | deterrent | 1 | 81242 | 4 | 1.296 | 62686.7 |
214 | 2020-03-23 18:04:37 | deterrent | 1 | 81242 | 4 | 1.390 | 58447.5 |
213 | 2020-02-29 21:09:05 | deterrent | 1 | 81242 | 4 | 1.440 | 56418.1 |
212 | 2020-02-29 04:48:49 | deterrent | 1 | 81242 | 4 | 1.453 | 55913.3 |
211 | 2020-02-29 02:54:19 | deterrent | 1 | 81242 | 4 | 3.156 | 25742.1 |
210 | 2020-02-28 16:39:29 | deterrent | 1 | 81242 | 4 | 1.500 | 54161.3 |
209 | 2020-02-27 03:23:02 | deterrent | 4 | 165329 | 293 | 22.140 | 7467.4 |
208 | 2020-02-26 15:11:22 | deterrent | 4 | 165329 | 293 | 16.003 | 10331.1 |
207 | 2020-02-23 22:55:46 | deterrent | 4 | 165329 | 293 | 24.596 | 6721.8 |
206 | 2020-02-21 22:37:15 | deterrent | 4 | 165329 | 293 | 12.736 | 12981.2 |
205 | 2020-02-21 02:08:44 | deterrent | 1 | 81242 | 4 | 3.046 | 26671.7 |
204 | 2020-02-20 07:14:31 | deterrent | 1 | 81242 | 4 | 1.546 | 52549.8 |