History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"constrained"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 222 | 2024-05-08 15:45:56 | constrained | 3 | 121633 | 31 | 16.640 | 7309.7 |
| 221 | 2024-05-07 18:46:53 | constrained | 4 | 148819 | 134 | 28.016 | 5311.9 |
| 220 | 2024-05-05 22:37:31 | constrained | 4 | 148819 | 134 | 14.576 | 10209.9 |
| 219 | 2024-05-05 22:37:27 | constrained | 3 | 121633 | 31 | 8.190 | 14851.4 |
| 218 | 2024-05-05 22:29:23 | constrained | 2 | 86808 | 10 | 5.330 | 16286.7 |
| 217 | 2024-05-05 22:28:11 | constrained | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 216 | 2024-04-29 13:31:58 | constrained | 1 | 49908 | 1 | 1.906 | 26184.7 |
| 215 | 2024-04-25 19:40:40 | constrained | 1 | 49908 | 1 | 1.920 | 25993.8 |
| 214 | 2024-04-15 21:37:02 | constrained | 1 | 49908 | 1 | 1.450 | 34419.3 |
| 213 | 2024-04-04 09:38:19 | constrained | 4 | 148819 | 134 | 26.000 | 5723.8 |
| 212 | 2024-03-24 18:21:24 | constrained | 3 | 121633 | 31 | 13.516 | 8999.2 |
| 211 | 2024-03-24 18:21:05 | constrained | 2 | 86808 | 10 | 6.453 | 13452.3 |
| 210 | 2024-03-24 17:26:34 | constrained | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 209 | 2024-03-23 03:40:43 | constrained | 1 | 49908 | 1 | 0.920 | 54247.8 |
| 208 | 2024-03-22 03:25:54 | constrained | 2 | 86808 | 10 | 5.843 | 14856.8 |
| 207 | 2024-03-22 02:11:46 | constrained | 1 | 49908 | 1 | 0.906 | 55086.1 |
| 206 | 2024-03-21 07:52:42 | constrained | 3 | 121633 | 31 | 12.003 | 10133.5 |
| 205 | 2024-03-20 23:58:23 | constrained | 4 | 148819 | 134 | 25.203 | 5904.8 |
| 204 | 2024-03-19 18:10:26 | constrained | 3 | 121633 | 31 | 13.156 | 9245.4 |
| 203 | 2024-03-19 18:10:14 | constrained | 2 | 86808 | 10 | 5.376 | 16147.3 |
| 202 | 2024-03-19 15:59:29 | constrained | 4 | 148819 | 134 | 23.250 | 6400.8 |
| 201 | 2024-03-18 18:16:52 | constrained | 4 | 148819 | 134 | 34.220 | 4348.9 |
| 200 | 2024-03-18 18:16:57 | constrained | 3 | 121633 | 31 | 17.580 | 6918.8 |
| 199 | 2024-03-18 18:16:54 | constrained | 2 | 86808 | 10 | 5.170 | 16790.7 |
| 198 | 2024-03-18 17:31:20 | constrained | 1 | 49908 | 1 | 1.923 | 25953.2 |
| 197 | 2024-03-17 01:30:47 | constrained | 1 | 49908 | 1 | 0.920 | 54247.8 |
| 196 | 2024-03-07 12:17:26 | constrained | 3 | 121633 | 31 | 5.236 | 23230.1 |
| 195 | 2024-03-03 12:24:43 | constrained | 3 | 121633 | 31 | 17.283 | 7037.7 |
| 194 | 2024-02-23 06:28:38 | constrained | 3 | 121633 | 31 | 6.343 | 19175.9 |
| 193 | 2024-02-23 06:28:39 | constrained | 2 | 86808 | 10 | 2.656 | 32683.7 |
| 192 | 2024-02-21 23:50:30 | constrained | 4 | 148819 | 134 | 11.406 | 13047.4 |
| 191 | 2024-02-20 01:38:45 | constrained | 2 | 86808 | 10 | 4.610 | 18830.4 |
| 190 | 2024-02-19 20:39:03 | constrained | 3 | 121633 | 31 | 8.296 | 14661.6 |
| 189 | 2024-02-19 16:41:22 | constrained | 1 | 49908 | 1 | 0.826 | 60421.3 |
| 188 | 2024-02-19 01:17:10 | constrained | 4 | 148819 | 134 | 24.550 | 6061.9 |
| 187 | 2024-02-17 02:39:35 | constrained | 3 | 121633 | 31 | 19.220 | 6328.5 |
| 186 | 2024-02-17 02:39:37 | constrained | 4 | 148819 | 134 | 16.486 | 9027.0 |
| 185 | 2024-02-17 02:39:33 | constrained | 2 | 86808 | 10 | 5.670 | 15310.1 |
| 184 | 2024-02-17 02:23:49 | constrained | 3 | 121633 | 31 | 6.563 | 18533.1 |
| 183 | 2024-02-17 02:23:48 | constrained | 2 | 86808 | 10 | 4.220 | 20570.6 |
| 182 | 2024-02-17 00:27:29 | constrained | 1 | 49908 | 1 | 1.920 | 25993.8 |
| 181 | 2024-02-16 21:01:06 | constrained | 1 | 49908 | 1 | 1.000 | 49908.0 |
| 180 | 2024-02-15 21:57:53 | constrained | 4 | 148819 | 134 | 50.236 | 2962.4 |
| 179 | 2024-02-15 13:40:41 | constrained | 4 | 148819 | 134 | 11.596 | 12833.6 |
| 178 | 2024-02-15 13:40:40 | constrained | 3 | 121633 | 31 | 10.203 | 11921.3 |
| 177 | 2024-02-15 13:40:42 | constrained | 2 | 86808 | 10 | 2.766 | 31383.9 |
| 176 | 2024-02-15 13:40:19 | constrained | 1 | 49908 | 1 | 0.826 | 60421.3 |
| 175 | 2024-02-13 09:27:13 | constrained | 1 | 49908 | 1 | 1.110 | 44962.2 |
| 174 | 2023-12-29 14:07:25 | constrained | 1 | 49908 | 1 | 0.783 | 63739.5 |
| 173 | 2023-12-09 00:38:53 | constrained | 1 | 49908 | 1 | 0.906 | 55086.1 |
| 172 | 2023-11-29 14:55:19 | constrained | 1 | 49908 | 1 | 0.766 | 65154.0 |
| 171 | 2023-11-26 18:47:59 | constrained | 3 | 121633 | 31 | 5.343 | 22764.9 |
| 170 | 2023-10-18 06:44:23 | constrained | 1 | 49908 | 1 | 0.763 | 65410.2 |
| 169 | 2023-09-24 16:49:34 | constrained | 1 | 49908 | 1 | 0.856 | 58303.7 |
| 168 | 2023-08-26 07:33:44 | constrained | 3 | 121633 | 31 | 5.236 | 23230.1 |
| 167 | 2023-08-14 02:28:08 | constrained | 1 | 49908 | 1 | 0.813 | 61387.5 |
| 166 | 2023-07-26 09:43:14 | constrained | 1 | 49908 | 1 | 0.813 | 61387.5 |
| 165 | 2023-05-12 23:36:54 | constrained | 1 | 49908 | 1 | 0.783 | 63739.5 |
| 164 | 2023-05-10 20:09:19 | constrained | 3 | 121633 | 31 | 4.500 | 27029.6 |
| 163 | 2023-03-27 01:23:28 | constrained | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 162 | 2023-03-09 03:27:51 | constrained | 1 | 49908 | 1 | 0.766 | 65154.0 |
| 161 | 2023-02-19 18:47:51 | constrained | 3 | 121633 | 31 | 5.143 | 23650.2 |
| 160 | 2022-12-28 19:44:36 | constrained | 1 | 49908 | 1 | 0.766 | 65154.0 |
| 159 | 2022-12-02 06:35:39 | constrained | 3 | 121633 | 31 | 4.450 | 27333.3 |
| 158 | 2022-11-18 15:21:30 | constrained | 1 | 49908 | 1 | 1.000 | 49908.0 |
| 157 | 2022-09-17 11:48:53 | constrained | 1 | 49908 | 1 | 0.783 | 63739.5 |
| 156 | 2022-07-10 23:31:15 | constrained | 3 | 121633 | 31 | 4.483 | 27132.1 |
| 155 | 2022-07-09 16:10:40 | constrained | 1 | 49908 | 1 | 0.843 | 59202.8 |
| 154 | 2022-07-04 08:29:39 | constrained | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 153 | 2022-07-01 00:02:42 | constrained | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 152 | 2022-03-01 14:15:20 | constrained | 1 | 49908 | 1 | 1.063 | 46950.1 |
| 151 | 2022-02-28 14:52:42 | constrained | 1 | 49908 | 1 | 1.060 | 47083.0 |
| 150 | 2022-02-27 10:59:35 | constrained | 1 | 49908 | 1 | 0.906 | 55086.1 |
| 149 | 2021-12-12 05:36:59 | constrained | 1 | 49908 | 1 | 0.813 | 61387.5 |
| 148 | 2021-11-03 14:58:06 | constrained | 1 | 49908 | 1 | 0.936 | 53320.5 |
| 147 | 2021-10-19 10:09:45 | constrained | 1 | 49908 | 1 | 0.783 | 63739.5 |
| 146 | 2021-09-11 12:01:34 | constrained | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 145 | 2021-09-09 09:52:59 | constrained | 1 | 49908 | 1 | 0.910 | 54844.0 |
| 144 | 2021-08-24 21:42:19 | constrained | 1 | 49908 | 1 | 0.830 | 60130.1 |
| 143 | 2021-08-22 17:01:22 | constrained | 1 | 49908 | 1 | 0.783 | 63739.5 |
| 142 | 2021-07-21 06:08:45 | constrained | 1 | 49908 | 1 | 0.873 | 57168.4 |
| 141 | 2021-05-02 22:49:54 | constrained | 1 | 49908 | 1 | 0.970 | 51451.5 |
| 140 | 2021-04-18 09:47:46 | constrained | 1 | 49908 | 1 | 0.893 | 55888.0 |
| 139 | 2021-04-14 18:19:03 | constrained | 1 | 49908 | 1 | 0.953 | 52369.4 |
| 138 | 2020-12-28 13:05:12 | constrained | 1 | 49908 | 1 | 0.813 | 61387.5 |
| 137 | 2020-10-29 09:20:40 | constrained | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 136 | 2020-09-13 14:39:07 | constrained | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 135 | 2020-06-17 17:20:53 | constrained | 1 | 49908 | 1 | 0.796 | 62698.5 |
| 134 | 2020-06-04 01:13:22 | constrained | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 133 | 2020-05-20 07:26:24 | constrained | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 132 | 2020-03-24 04:26:09 | constrained | 1 | 49908 | 1 | 0.936 | 53320.5 |
| 131 | 2020-03-15 14:45:05 | constrained | 1 | 49908 | 1 | 0.810 | 61614.8 |
| 130 | 2020-02-28 10:02:30 | constrained | 1 | 49908 | 1 | 2.076 | 24040.5 |
| 129 | 2020-02-17 08:15:37 | constrained | 1 | 49908 | 1 | 0.826 | 60421.3 |
| 128 | 2020-02-12 19:03:10 | constrained | 1 | 49908 | 1 | 1.000 | 49908.0 |
| 127 | 2020-02-12 14:06:31 | constrained | 1 | 49908 | 1 | 2.030 | 24585.2 |
| 126 | 2020-02-11 03:02:06 | constrained | 1 | 49908 | 1 | 0.970 | 51451.5 |
| 125 | 2020-01-31 17:47:56 | constrained | 1 | 49908 | 1 | 2.060 | 24227.2 |
| 124 | 2020-01-30 05:54:12 | constrained | 1 | 49908 | 1 | 1.766 | 28260.5 |
| 123 | 2020-01-30 02:34:22 | constrained | 1 | 49908 | 1 | 0.970 | 51451.5 |