History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affiances"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
285 | 2024-05-25 20:11:30 | affiances | 1 | 81242 | 3 | 5.000 | 16248.4 |
284 | 2024-05-18 04:49:29 | affiances | 3 | 148641 | 49 | 16.156 | 9200.4 |
283 | 2024-05-17 13:09:18 | affiances | 3 | 148641 | 49 | 18.596 | 7993.2 |
282 | 2024-05-17 13:09:19 | affiances | 2 | 121436 | 10 | 12.343 | 9838.5 |
281 | 2024-05-17 12:36:24 | affiances | 4 | 165329 | 310 | 17.016 | 9716.1 |
280 | 2024-05-17 12:35:52 | affiances | 1 | 81242 | 3 | 1.530 | 53099.3 |
279 | 2024-05-15 02:22:23 | affiances | 4 | 165329 | 310 | 46.206 | 3578.1 |
278 | 2024-05-14 02:40:45 | affiances | 4 | 165329 | 310 | 13.126 | 12595.5 |
277 | 2024-04-28 10:55:32 | affiances | 1 | 81242 | 3 | 1.610 | 50460.9 |
276 | 2024-04-28 10:10:59 | affiances | 1 | 81242 | 3 | 1.376 | 59042.2 |
275 | 2024-04-18 20:08:04 | affiances | 2 | 121436 | 10 | 3.406 | 35653.6 |
274 | 2024-04-13 13:00:52 | affiances | 1 | 81242 | 3 | 1.330 | 61084.2 |
273 | 2024-04-12 10:42:56 | affiances | 4 | 165329 | 310 | 46.266 | 3573.4 |
272 | 2024-04-10 15:30:30 | affiances | 4 | 165329 | 310 | 48.473 | 3410.7 |
271 | 2024-04-10 15:30:31 | affiances | 3 | 148641 | 49 | 14.110 | 10534.4 |
270 | 2024-04-10 15:30:32 | affiances | 2 | 121436 | 10 | 8.550 | 14203.0 |
269 | 2024-04-10 14:36:12 | affiances | 1 | 81242 | 3 | 1.406 | 57782.4 |
268 | 2024-04-01 17:53:00 | affiances | 2 | 121436 | 10 | 12.216 | 9940.7 |
267 | 2024-04-01 17:52:59 | affiances | 3 | 148641 | 49 | 8.283 | 17945.3 |
266 | 2024-04-01 14:32:39 | affiances | 1 | 81242 | 3 | 2.313 | 35124.1 |
265 | 2024-03-29 05:50:15 | affiances | 1 | 81242 | 3 | 3.546 | 22910.9 |
264 | 2024-03-11 17:01:35 | affiances | 4 | 165329 | 310 | 40.143 | 4118.5 |
263 | 2024-03-11 08:53:15 | affiances | 2 | 121436 | 10 | 8.160 | 14881.9 |
262 | 2024-03-11 08:52:10 | affiances | 1 | 81242 | 3 | 4.656 | 17448.9 |
261 | 2024-03-10 12:43:55 | affiances | 2 | 121436 | 10 | 13.326 | 9112.7 |
260 | 2024-03-10 12:27:50 | affiances | 1 | 81242 | 3 | 1.516 | 53589.7 |
259 | 2024-03-10 12:27:29 | affiances | 4 | 165329 | 310 | 14.610 | 11316.2 |
258 | 2024-03-10 10:38:21 | affiances | 4 | 165329 | 310 | 15.330 | 10784.7 |
257 | 2024-03-10 03:32:33 | affiances | 4 | 165329 | 310 | 31.093 | 5317.2 |
256 | 2024-03-10 03:32:31 | affiances | 3 | 148641 | 49 | 23.613 | 6294.9 |
255 | 2024-03-10 03:32:30 | affiances | 2 | 121436 | 10 | 12.110 | 10027.7 |
254 | 2024-03-10 03:26:43 | affiances | 1 | 81242 | 3 | 1.453 | 55913.3 |
253 | 2024-03-07 22:08:20 | affiances | 1 | 81242 | 3 | 1.403 | 57905.9 |
252 | 2024-02-27 15:58:30 | affiances | 1 | 81242 | 3 | 1.403 | 57905.9 |
251 | 2024-02-08 07:38:10 | affiances | 1 | 81242 | 3 | 1.483 | 54782.2 |
250 | 2024-02-07 23:28:53 | affiances | 4 | 165329 | 310 | 38.783 | 4262.9 |
249 | 2024-02-06 10:04:49 | affiances | 3 | 148641 | 49 | 7.483 | 19863.8 |
248 | 2024-02-06 10:04:42 | affiances | 4 | 165329 | 310 | 13.330 | 12402.8 |
247 | 2024-02-06 10:04:45 | affiances | 2 | 121436 | 10 | 3.753 | 32357.0 |
246 | 2024-02-06 04:11:45 | affiances | 1 | 81242 | 3 | 1.393 | 58321.6 |
245 | 2024-02-05 20:31:38 | affiances | 1 | 81242 | 3 | 1.390 | 58447.5 |
244 | 2024-01-31 23:56:32 | affiances | 1 | 81242 | 3 | 1.453 | 55913.3 |
243 | 2024-01-27 02:46:15 | affiances | 1 | 81242 | 3 | 1.360 | 59736.8 |
242 | 2024-01-27 02:45:27 | affiances | 1 | 81242 | 3 | 1.406 | 57782.4 |
241 | 2024-01-07 03:28:01 | affiances | 1 | 81242 | 3 | 1.483 | 54782.2 |
240 | 2023-12-13 17:11:20 | affiances | 2 | 121436 | 10 | 3.280 | 37023.2 |
239 | 2023-11-30 23:25:52 | affiances | 1 | 81242 | 3 | 1.203 | 67532.8 |
238 | 2023-10-27 09:47:13 | affiances | 1 | 81242 | 3 | 1.236 | 65729.8 |
237 | 2023-10-06 09:11:48 | affiances | 1 | 81242 | 3 | 1.220 | 66591.8 |
236 | 2023-09-15 12:30:01 | affiances | 1 | 81242 | 3 | 1.406 | 57782.4 |
235 | 2023-09-15 06:14:11 | affiances | 1 | 81242 | 3 | 1.313 | 61875.1 |
234 | 2023-09-13 07:24:44 | affiances | 2 | 121436 | 10 | 2.923 | 41545.0 |
233 | 2023-07-16 05:12:00 | affiances | 1 | 81242 | 3 | 1.220 | 66591.8 |
232 | 2023-07-04 16:40:19 | affiances | 1 | 81242 | 3 | 1.360 | 59736.8 |
231 | 2023-06-10 05:28:30 | affiances | 2 | 121436 | 10 | 2.573 | 47196.3 |
230 | 2023-04-12 03:37:24 | affiances | 1 | 81242 | 3 | 1.203 | 67532.8 |
229 | 2023-04-11 11:39:38 | affiances | 1 | 81242 | 3 | 1.203 | 67532.8 |
228 | 2023-03-12 23:48:57 | affiances | 2 | 121436 | 10 | 2.876 | 42223.9 |
227 | 2023-02-02 23:40:44 | affiances | 1 | 81242 | 3 | 1.310 | 62016.8 |
226 | 2022-12-23 04:07:12 | affiances | 1 | 81242 | 3 | 1.186 | 68500.8 |
225 | 2022-12-15 17:26:12 | affiances | 2 | 121436 | 10 | 3.296 | 36843.4 |
224 | 2022-12-02 14:54:30 | affiances | 1 | 81242 | 3 | 1.186 | 68500.8 |
223 | 2022-08-23 00:27:42 | affiances | 1 | 81242 | 3 | 1.220 | 66591.8 |
222 | 2022-08-16 23:55:08 | affiances | 3 | 148641 | 49 | 5.766 | 25778.9 |
221 | 2022-08-05 17:13:54 | affiances | 2 | 121436 | 10 | 2.940 | 41304.8 |
220 | 2022-08-03 07:18:47 | affiances | 2 | 121436 | 10 | 2.970 | 40887.5 |
219 | 2022-07-29 09:54:17 | affiances | 1 | 81242 | 3 | 1.453 | 55913.3 |
218 | 2022-07-27 01:43:23 | affiances | 1 | 81242 | 3 | 1.200 | 67701.7 |
217 | 2022-04-22 08:09:13 | affiances | 1 | 81242 | 3 | 1.376 | 59042.2 |
216 | 2022-03-19 21:33:52 | affiances | 2 | 121436 | 10 | 3.123 | 38884.4 |
215 | 2022-03-15 09:50:36 | affiances | 1 | 81242 | 3 | 1.813 | 44810.8 |
214 | 2022-01-09 09:36:17 | affiances | 1 | 81242 | 3 | 1.406 | 57782.4 |
213 | 2022-01-06 03:41:48 | affiances | 1 | 81242 | 3 | 1.403 | 57905.9 |
212 | 2022-01-05 06:49:30 | affiances | 1 | 81242 | 3 | 1.280 | 63470.3 |
211 | 2021-10-10 12:31:08 | affiances | 1 | 81242 | 3 | 1.406 | 57782.4 |
210 | 2021-09-30 00:35:19 | affiances | 1 | 81242 | 3 | 1.216 | 66810.9 |
209 | 2021-06-30 14:54:08 | affiances | 1 | 81242 | 3 | 1.420 | 57212.7 |
208 | 2021-04-13 02:53:39 | affiances | 1 | 81242 | 3 | 1.220 | 66591.8 |
207 | 2021-03-30 11:56:50 | affiances | 1 | 81242 | 3 | 1.283 | 63321.9 |
206 | 2021-03-26 03:32:36 | affiances | 1 | 81242 | 3 | 2.486 | 32679.8 |
205 | 2021-03-21 17:57:19 | affiances | 1 | 81242 | 3 | 1.393 | 58321.6 |
204 | 2021-03-19 08:22:20 | affiances | 1 | 81242 | 3 | 1.280 | 63470.3 |
203 | 2021-03-18 06:48:32 | affiances | 1 | 81242 | 3 | 1.343 | 60492.9 |
202 | 2021-03-17 20:54:56 | affiances | 1 | 81242 | 3 | 2.813 | 28880.9 |
201 | 2021-03-17 09:13:58 | affiances | 1 | 81242 | 3 | 2.906 | 27956.6 |
200 | 2021-03-16 14:24:10 | affiances | 1 | 81242 | 3 | 1.440 | 56418.1 |
199 | 2021-03-15 19:50:17 | affiances | 1 | 81242 | 3 | 1.233 | 65889.7 |
198 | 2021-02-11 20:39:01 | affiances | 1 | 81242 | 3 | 1.266 | 64172.2 |
197 | 2021-01-26 22:04:01 | affiances | 1 | 81242 | 3 | 1.250 | 64993.6 |
196 | 2020-12-18 21:34:01 | affiances | 1 | 81242 | 3 | 1.220 | 66591.8 |
195 | 2020-11-18 09:51:36 | affiances | 1 | 81242 | 3 | 1.343 | 60492.9 |
194 | 2020-11-10 08:54:07 | affiances | 3 | 148641 | 49 | 6.470 | 22973.9 |
193 | 2020-10-29 23:00:56 | affiances | 1 | 81242 | 3 | 1.233 | 65889.7 |
192 | 2020-10-15 01:11:05 | affiances | 1 | 81242 | 3 | 1.250 | 64993.6 |
191 | 2020-10-05 08:38:16 | affiances | 1 | 81242 | 3 | 1.393 | 58321.6 |
190 | 2020-09-14 19:54:55 | affiances | 1 | 81242 | 3 | 1.373 | 59171.2 |
189 | 2020-09-12 10:16:17 | affiances | 1 | 81242 | 3 | 1.203 | 67532.8 |
188 | 2020-07-27 11:29:31 | affiances | 1 | 81242 | 3 | 1.403 | 57905.9 |
187 | 2020-07-23 16:51:05 | affiances | 1 | 81242 | 3 | 1.280 | 63470.3 |
186 | 2020-06-08 13:30:17 | affiances | 1 | 81242 | 3 | 1.250 | 64993.6 |