History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"phalanx"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 238 | 2024-04-26 17:15:37 | phalanx | 4 | 151207 | 1050 | 22.063 | 6853.4 |
| 237 | 2024-04-26 12:52:44 | phalanx | 1 | 69583 | 1 | 3.046 | 22844.1 |
| 236 | 2024-04-25 20:08:06 | phalanx | 4 | 151207 | 1050 | 16.360 | 9242.5 |
| 235 | 2024-04-20 07:34:46 | phalanx | 4 | 151207 | 1050 | 12.940 | 11685.2 |
| 234 | 2024-04-07 21:33:42 | phalanx | 1 | 69583 | 1 | 3.330 | 20895.8 |
| 233 | 2024-04-03 03:29:13 | phalanx | 3 | 134027 | 81 | 22.033 | 6083.0 |
| 232 | 2024-04-01 20:26:05 | phalanx | 3 | 134027 | 81 | 16.576 | 8085.6 |
| 231 | 2024-04-01 13:09:03 | phalanx | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 230 | 2024-04-01 08:19:45 | phalanx | 2 | 107671 | 4 | 7.203 | 14948.1 |
| 229 | 2024-03-31 22:50:06 | phalanx | 4 | 151207 | 1050 | 31.720 | 4766.9 |
| 228 | 2024-03-31 13:58:14 | phalanx | 3 | 134027 | 81 | 16.313 | 8216.0 |
| 227 | 2024-03-31 12:48:11 | phalanx | 3 | 134027 | 81 | 19.670 | 6813.8 |
| 226 | 2024-03-31 09:59:51 | phalanx | 3 | 134027 | 81 | 20.956 | 6395.6 |
| 225 | 2024-03-31 09:59:49 | phalanx | 2 | 107671 | 4 | 4.500 | 23926.9 |
| 224 | 2024-03-30 07:03:36 | phalanx | 4 | 151207 | 1050 | 27.173 | 5564.6 |
| 223 | 2024-03-29 13:24:07 | phalanx | 4 | 151207 | 1050 | 31.423 | 4812.0 |
| 222 | 2024-03-25 08:18:57 | phalanx | 4 | 151207 | 1050 | 22.830 | 6623.2 |
| 221 | 2024-03-22 05:08:00 | phalanx | 1 | 69583 | 1 | 1.330 | 52318.0 |
| 220 | 2024-03-22 05:07:01 | phalanx | 4 | 151207 | 1050 | 22.470 | 6729.3 |
| 219 | 2024-03-22 05:07:02 | phalanx | 3 | 134027 | 81 | 7.296 | 18369.9 |
| 218 | 2024-03-22 05:07:01 | phalanx | 2 | 107671 | 4 | 3.470 | 31029.1 |
| 217 | 2024-03-01 03:38:16 | phalanx | 3 | 134027 | 81 | 9.873 | 13575.1 |
| 216 | 2024-02-28 06:50:29 | phalanx | 4 | 151207 | 1050 | 19.593 | 7717.4 |
| 215 | 2024-02-28 06:04:03 | phalanx | 4 | 151207 | 1050 | 35.690 | 4236.7 |
| 214 | 2024-02-28 06:04:03 | phalanx | 3 | 134027 | 81 | 13.783 | 9724.1 |
| 213 | 2024-02-28 05:59:35 | phalanx | 1 | 69583 | 1 | 2.656 | 26198.4 |
| 212 | 2024-02-09 22:31:31 | phalanx | 1 | 69583 | 1 | 4.046 | 17198.0 |
| 211 | 2024-02-05 14:08:02 | phalanx | 4 | 151207 | 1050 | 19.563 | 7729.2 |
| 210 | 2024-02-05 11:12:51 | phalanx | 4 | 151207 | 1050 | 12.563 | 12035.9 |
| 209 | 2024-01-27 07:06:45 | phalanx | 4 | 151207 | 1050 | 15.236 | 9924.3 |
| 208 | 2024-01-27 06:46:27 | phalanx | 4 | 151207 | 1050 | 11.283 | 13401.3 |
| 207 | 2024-01-26 16:14:08 | phalanx | 1 | 69583 | 1 | 2.453 | 28366.5 |
| 206 | 2024-01-11 07:52:39 | phalanx | 2 | 107671 | 4 | 2.940 | 36622.8 |
| 205 | 2024-01-02 19:23:14 | phalanx | 4 | 151207 | 1050 | 11.753 | 12865.4 |
| 204 | 2023-12-23 00:33:21 | phalanx | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 203 | 2023-12-16 06:36:36 | phalanx | 4 | 151207 | 1050 | 10.813 | 13983.8 |
| 202 | 2023-12-10 19:56:24 | phalanx | 3 | 134027 | 81 | 6.796 | 19721.5 |
| 201 | 2023-12-10 19:56:22 | phalanx | 2 | 107671 | 4 | 3.296 | 32667.2 |
| 200 | 2023-12-09 09:41:01 | phalanx | 4 | 151207 | 1050 | 11.173 | 13533.2 |
| 199 | 2023-12-08 04:03:10 | phalanx | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 198 | 2023-11-25 08:56:56 | phalanx | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 197 | 2023-11-11 06:18:04 | phalanx | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 196 | 2023-11-10 15:49:07 | phalanx | 4 | 151207 | 1050 | 18.626 | 8118.1 |
| 195 | 2023-11-04 01:57:02 | phalanx | 4 | 151207 | 1050 | 13.170 | 11481.2 |
| 194 | 2023-10-19 16:20:49 | phalanx | 2 | 107671 | 4 | 3.250 | 33129.5 |
| 193 | 2023-10-14 13:11:57 | phalanx | 4 | 151207 | 1050 | 13.750 | 10996.9 |
| 192 | 2023-10-13 16:47:44 | phalanx | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 191 | 2023-10-11 08:04:42 | phalanx | 1 | 69583 | 1 | 1.563 | 44518.9 |
| 190 | 2023-10-08 14:19:09 | phalanx | 4 | 151207 | 1050 | 10.283 | 14704.6 |
| 189 | 2023-10-05 17:20:45 | phalanx | 4 | 151207 | 1050 | 13.436 | 11253.9 |
| 188 | 2023-09-28 09:40:01 | phalanx | 4 | 151207 | 1050 | 14.343 | 10542.2 |
| 187 | 2023-09-24 21:18:43 | phalanx | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 186 | 2023-09-24 19:18:54 | phalanx | 4 | 151207 | 1050 | 20.893 | 7237.2 |
| 185 | 2023-09-16 17:27:53 | phalanx | 4 | 151207 | 1050 | 12.533 | 12064.7 |
| 184 | 2023-09-14 11:00:53 | phalanx | 1 | 69583 | 1 | 1.216 | 57222.9 |
| 183 | 2023-09-05 07:12:40 | phalanx | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 182 | 2023-08-07 00:29:50 | phalanx | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 181 | 2023-07-31 03:48:33 | phalanx | 2 | 107671 | 4 | 2.733 | 39396.6 |
| 180 | 2023-06-30 00:27:45 | phalanx | 4 | 151207 | 1050 | 12.360 | 12233.6 |
| 179 | 2023-06-23 00:49:57 | phalanx | 4 | 151207 | 1050 | 12.093 | 12503.7 |
| 178 | 2023-05-07 08:57:22 | phalanx | 1 | 69583 | 1 | 1.060 | 65644.3 |
| 177 | 2023-04-24 05:13:35 | phalanx | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 176 | 2023-04-20 22:22:36 | phalanx | 4 | 151207 | 1050 | 9.763 | 15487.8 |
| 175 | 2023-04-06 13:54:12 | phalanx | 2 | 107671 | 4 | 3.110 | 34620.9 |
| 174 | 2023-03-31 15:07:45 | phalanx | 4 | 151207 | 1050 | 11.906 | 12700.1 |
| 173 | 2023-03-25 23:21:17 | phalanx | 4 | 151207 | 1050 | 16.876 | 8959.9 |
| 172 | 2023-03-21 09:31:59 | phalanx | 4 | 151207 | 1050 | 9.530 | 15866.4 |
| 171 | 2023-02-28 14:00:01 | phalanx | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 170 | 2023-01-04 10:16:23 | phalanx | 2 | 107671 | 4 | 2.736 | 39353.4 |
| 169 | 2022-12-24 23:03:34 | phalanx | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 168 | 2022-12-22 09:41:05 | phalanx | 4 | 151207 | 1050 | 10.580 | 14291.8 |
| 167 | 2022-12-20 13:36:07 | phalanx | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 166 | 2022-09-12 15:08:00 | phalanx | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 165 | 2022-09-07 08:58:11 | phalanx | 2 | 107671 | 4 | 3.046 | 35348.3 |
| 164 | 2022-08-24 07:11:28 | phalanx | 4 | 151207 | 1050 | 9.690 | 15604.4 |
| 163 | 2022-08-19 11:50:08 | phalanx | 4 | 151207 | 1050 | 9.766 | 15483.0 |
| 162 | 2022-07-20 20:08:54 | phalanx | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 161 | 2022-07-20 06:50:49 | phalanx | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 160 | 2022-07-17 02:45:34 | phalanx | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 159 | 2022-02-17 03:18:25 | phalanx | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 158 | 2021-10-10 11:56:45 | phalanx | 1 | 69583 | 1 | 2.373 | 29322.8 |
| 157 | 2021-07-29 12:13:31 | phalanx | 4 | 151207 | 1050 | 10.000 | 15120.7 |
| 156 | 2021-06-26 07:54:45 | phalanx | 4 | 151207 | 1050 | 11.220 | 13476.6 |
| 155 | 2021-06-07 18:44:57 | phalanx | 4 | 151207 | 1050 | 10.283 | 14704.6 |
| 154 | 2021-06-04 13:58:34 | phalanx | 4 | 151207 | 1050 | 9.890 | 15288.9 |
| 153 | 2021-03-25 09:29:46 | phalanx | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 152 | 2021-03-05 12:38:27 | phalanx | 4 | 151207 | 1050 | 9.830 | 15382.2 |
| 151 | 2021-02-01 21:52:46 | phalanx | 4 | 151207 | 1050 | 13.906 | 10873.5 |
| 150 | 2021-01-08 12:13:44 | phalanx | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 149 | 2020-11-30 20:10:42 | phalanx | 4 | 151207 | 1050 | 10.173 | 14863.6 |
| 148 | 2020-10-21 04:18:30 | phalanx | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 147 | 2020-10-20 15:32:18 | phalanx | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 146 | 2020-10-20 09:39:58 | phalanx | 1 | 69583 | 1 | 1.060 | 65644.3 |
| 145 | 2020-10-18 23:37:40 | phalanx | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 144 | 2020-03-29 05:50:56 | phalanx | 1 | 69583 | 1 | 1.263 | 55093.4 |
| 143 | 2020-03-28 21:22:18 | phalanx | 1 | 69583 | 1 | 1.406 | 49490.0 |
| 142 | 2020-03-23 22:12:33 | phalanx | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 141 | 2020-03-23 21:51:58 | phalanx | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 140 | 2020-03-20 20:27:34 | phalanx | 1 | 69583 | 1 | 1.090 | 63837.6 |
| 139 | 2020-03-07 20:17:59 | phalanx | 1 | 69583 | 1 | 1.126 | 61796.6 |