History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"upfront"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 226 | 2025-05-22 11:43:29 | upfront | 1 | 69583 | 1 | 9.766 | 7125.0 |
| 225 | 2025-05-16 13:21:28 | upfront | 1 | 69583 | 1 | 2.983 | 23326.5 |
| 224 | 2025-05-15 11:38:13 | upfront | 1 | 69583 | 1 | 1.170 | 59472.6 |
| 223 | 2025-05-10 23:55:06 | upfront | 1 | 69583 | 1 | 5.423 | 12831.1 |
| 222 | 2025-05-06 11:44:41 | upfront | 2 | 107671 | 5 | 16.160 | 6662.8 |
| 221 | 2025-04-27 14:41:13 | upfront | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 220 | 2025-04-20 10:34:16 | upfront | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 219 | 2025-04-18 07:22:00 | upfront | 1 | 69583 | 1 | 8.580 | 8109.9 |
| 218 | 2025-04-14 07:33:20 | upfront | 1 | 69583 | 1 | 5.423 | 12831.1 |
| 217 | 2025-04-11 20:52:48 | upfront | 1 | 69583 | 1 | 5.656 | 12302.5 |
| 216 | 2025-04-11 13:30:53 | upfront | 1 | 69583 | 1 | 6.156 | 11303.3 |
| 215 | 2025-04-10 23:09:48 | upfront | 1 | 69583 | 1 | 4.900 | 14200.6 |
| 214 | 2025-04-09 06:54:57 | upfront | 1 | 69583 | 1 | 5.670 | 12272.1 |
| 213 | 2025-04-06 09:48:08 | upfront | 1 | 69583 | 1 | 2.830 | 24587.6 |
| 212 | 2025-03-31 02:14:34 | upfront | 3 | 134027 | 62 | 31.910 | 4200.2 |
| 211 | 2025-03-27 01:23:35 | upfront | 3 | 134027 | 62 | 40.283 | 3327.1 |
| 210 | 2025-03-26 22:41:43 | upfront | 3 | 134027 | 62 | 16.926 | 7918.4 |
| 209 | 2025-03-22 17:48:50 | upfront | 3 | 134027 | 62 | 15.033 | 8915.5 |
| 208 | 2025-03-22 16:11:39 | upfront | 2 | 107671 | 5 | 3.423 | 31455.2 |
| 207 | 2025-03-22 15:49:45 | upfront | 3 | 134027 | 62 | 31.390 | 4269.7 |
| 206 | 2025-03-20 13:33:01 | upfront | 1 | 69583 | 1 | 6.093 | 11420.2 |
| 205 | 2025-03-13 23:18:13 | upfront | 1 | 69583 | 1 | 5.016 | 13872.2 |
| 204 | 2025-03-13 14:02:37 | upfront | 1 | 69583 | 1 | 3.716 | 18725.2 |
| 203 | 2025-03-08 17:59:05 | upfront | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 202 | 2025-03-06 19:15:41 | upfront | 1 | 69583 | 1 | 8.533 | 8154.6 |
| 201 | 2025-03-01 21:14:08 | upfront | 1 | 69583 | 1 | 2.986 | 23303.1 |
| 200 | 2025-01-27 20:43:56 | upfront | 3 | 134027 | 62 | 6.623 | 20236.6 |
| 199 | 2025-01-27 09:45:39 | upfront | 3 | 134027 | 62 | 32.113 | 4173.6 |
| 198 | 2025-01-26 23:38:53 | upfront | 3 | 134027 | 62 | 6.673 | 20085.0 |
| 197 | 2025-01-26 20:17:14 | upfront | 4 | 151207 | 711 | 58.800 | 2571.5 |
| 196 | 2025-01-26 19:44:36 | upfront | 4 | 151207 | 711 | 62.923 | 2403.0 |
| 195 | 2025-01-26 19:34:21 | upfront | 3 | 134027 | 62 | 23.390 | 5730.1 |
| 194 | 2025-01-26 18:56:16 | upfront | 4 | 151207 | 711 | 56.846 | 2659.9 |
| 193 | 2025-01-26 18:56:16 | upfront | 3 | 134027 | 62 | 42.766 | 3134.0 |
| 192 | 2025-01-26 18:56:17 | upfront | 2 | 107671 | 5 | 19.813 | 5434.4 |
| 191 | 2025-01-26 18:13:15 | upfront | 1 | 69583 | 1 | 2.720 | 25582.0 |
| 190 | 2024-12-14 17:54:08 | upfront | 1 | 69583 | 1 | 4.656 | 14944.8 |
| 189 | 2024-11-20 04:14:04 | upfront | 1 | 69583 | 1 | 5.110 | 13617.0 |
| 188 | 2024-11-07 07:46:12 | upfront | 1 | 69583 | 1 | 5.326 | 13064.8 |
| 187 | 2024-10-22 09:22:24 | upfront | 1 | 69583 | 1 | 4.720 | 14742.2 |
| 186 | 2024-08-23 11:07:47 | upfront | 1 | 69583 | 1 | 10.703 | 6501.3 |
| 185 | 2024-08-22 17:39:16 | upfront | 1 | 69583 | 1 | 14.360 | 4845.6 |
| 184 | 2024-08-15 10:08:52 | upfront | 1 | 69583 | 1 | 5.203 | 13373.6 |
| 183 | 2024-08-12 19:14:27 | upfront | 1 | 69583 | 1 | 7.750 | 8978.5 |
| 182 | 2024-07-31 10:19:03 | upfront | 1 | 69583 | 1 | 1.373 | 50679.5 |
| 181 | 2024-07-30 02:36:28 | upfront | 1 | 69583 | 1 | 4.093 | 17000.5 |
| 180 | 2024-07-22 01:11:27 | upfront | 1 | 69583 | 1 | 4.390 | 15850.3 |
| 179 | 2024-07-17 19:33:13 | upfront | 1 | 69583 | 1 | 4.906 | 14183.2 |
| 178 | 2024-07-15 09:02:00 | upfront | 1 | 69583 | 1 | 3.046 | 22844.1 |
| 177 | 2024-06-29 15:49:51 | upfront | 1 | 69583 | 1 | 4.263 | 16322.5 |
| 176 | 2024-06-20 20:36:11 | upfront | 1 | 69583 | 1 | 2.330 | 29863.9 |
| 175 | 2024-06-14 03:45:27 | upfront | 1 | 69583 | 1 | 2.140 | 32515.4 |
| 174 | 2024-06-05 07:38:09 | upfront | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 173 | 2024-06-02 20:49:26 | upfront | 1 | 69583 | 1 | 5.906 | 11781.7 |
| 172 | 2024-05-12 01:12:15 | upfront | 1 | 69583 | 1 | 2.796 | 24886.6 |
| 171 | 2024-04-11 03:54:51 | upfront | 2 | 107671 | 5 | 3.046 | 35348.3 |
| 170 | 2024-04-11 03:54:03 | upfront | 3 | 134027 | 62 | 8.673 | 15453.4 |
| 169 | 2024-04-10 20:06:59 | upfront | 4 | 151207 | 711 | 28.533 | 5299.4 |
| 168 | 2024-04-10 15:13:20 | upfront | 1 | 69583 | 1 | 3.330 | 20895.8 |
| 167 | 2024-04-10 14:24:30 | upfront | 3 | 134027 | 62 | 10.203 | 13136.0 |
| 166 | 2024-04-09 21:01:40 | upfront | 3 | 134027 | 62 | 17.750 | 7550.8 |
| 165 | 2024-04-09 15:58:49 | upfront | 1 | 69583 | 1 | 2.830 | 24587.6 |
| 164 | 2024-04-09 03:34:03 | upfront | 4 | 151207 | 711 | 41.516 | 3642.1 |
| 163 | 2024-04-09 02:26:33 | upfront | 2 | 107671 | 5 | 7.846 | 13723.0 |
| 162 | 2024-04-09 02:26:09 | upfront | 3 | 134027 | 62 | 8.016 | 16719.9 |
| 161 | 2024-04-08 13:33:43 | upfront | 4 | 151207 | 711 | 17.003 | 8893.0 |
| 160 | 2024-04-08 09:32:11 | upfront | 4 | 151207 | 711 | 27.300 | 5538.7 |
| 159 | 2024-04-08 08:21:07 | upfront | 3 | 134027 | 62 | 8.423 | 15912.0 |
| 158 | 2024-04-08 08:21:07 | upfront | 2 | 107671 | 5 | 3.373 | 31921.4 |
| 157 | 2024-04-08 08:20:57 | upfront | 4 | 151207 | 711 | 10.953 | 13805.1 |
| 156 | 2024-04-08 08:20:45 | upfront | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 155 | 2024-03-29 16:39:14 | upfront | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 154 | 2024-03-28 08:09:05 | upfront | 1 | 69583 | 1 | 1.516 | 45899.1 |
| 153 | 2024-03-08 23:50:41 | upfront | 3 | 134027 | 62 | 18.546 | 7226.7 |
| 152 | 2024-03-06 22:45:55 | upfront | 3 | 134027 | 62 | 14.953 | 8963.2 |
| 151 | 2024-03-06 11:56:46 | upfront | 3 | 134027 | 62 | 13.470 | 9950.0 |
| 150 | 2024-03-06 09:26:53 | upfront | 3 | 134027 | 62 | 14.080 | 9519.0 |
| 149 | 2024-03-06 09:26:47 | upfront | 2 | 107671 | 5 | 8.800 | 12235.3 |
| 148 | 2024-02-05 20:48:42 | upfront | 4 | 151207 | 711 | 16.000 | 9450.4 |
| 147 | 2024-02-05 03:27:38 | upfront | 3 | 134027 | 62 | 6.906 | 19407.3 |
| 146 | 2024-02-05 03:27:30 | upfront | 2 | 107671 | 5 | 5.326 | 20216.1 |
| 145 | 2024-01-27 16:54:39 | upfront | 4 | 151207 | 711 | 10.673 | 14167.2 |
| 144 | 2024-01-01 16:38:13 | upfront | 4 | 151207 | 711 | 9.703 | 15583.5 |
| 143 | 2023-12-28 06:51:34 | upfront | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 142 | 2023-12-18 16:06:53 | upfront | 1 | 69583 | 1 | 1.030 | 67556.3 |
| 141 | 2023-11-25 15:39:09 | upfront | 4 | 151207 | 711 | 10.280 | 14708.9 |
| 140 | 2023-11-20 09:47:57 | upfront | 1 | 69583 | 1 | 1.940 | 35867.5 |
| 139 | 2023-11-19 22:13:03 | upfront | 4 | 151207 | 711 | 9.530 | 15866.4 |
| 138 | 2023-11-04 10:26:31 | upfront | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 137 | 2023-10-17 08:23:01 | upfront | 4 | 151207 | 711 | 15.923 | 9496.1 |
| 136 | 2023-10-17 08:23:00 | upfront | 2 | 107671 | 5 | 5.783 | 18618.5 |
| 135 | 2023-10-15 23:27:43 | upfront | 3 | 134027 | 62 | 5.940 | 22563.5 |
| 134 | 2023-10-10 23:21:30 | upfront | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 133 | 2023-10-05 05:41:19 | upfront | 1 | 69583 | 1 | 1.190 | 58473.1 |
| 132 | 2023-09-23 02:21:23 | upfront | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 131 | 2023-08-24 11:03:01 | upfront | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 130 | 2023-03-27 15:32:09 | upfront | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 129 | 2022-10-25 05:33:48 | upfront | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 128 | 2022-10-21 17:07:25 | upfront | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 127 | 2022-09-18 10:15:46 | upfront | 1 | 69583 | 1 | 1.016 | 68487.2 |