History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"frangipani"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 250 | 2024-04-23 16:08:23 | frangipani | 5 | 173545 | 210 | 63.163 | 2747.6 |
| 249 | 2024-04-21 23:17:12 | frangipani | 3 | 140603 | 4 | 15.576 | 9026.9 |
| 248 | 2024-04-21 23:17:14 | frangipani | 2 | 108824 | 4 | 6.483 | 16786.1 |
| 247 | 2024-04-21 23:14:07 | frangipani | 1 | 67641 | 3 | 4.876 | 13872.2 |
| 246 | 2024-04-21 23:06:47 | frangipani | 5 | 173545 | 210 | 48.253 | 3596.6 |
| 245 | 2024-04-21 14:31:52 | frangipani | 5 | 173545 | 210 | 41.190 | 4213.3 |
| 244 | 2024-04-21 06:02:44 | frangipani | 3 | 140603 | 4 | 26.626 | 5280.7 |
| 243 | 2024-04-21 06:02:41 | frangipani | 5 | 173545 | 210 | 29.110 | 5961.7 |
| 242 | 2024-04-21 06:02:44 | frangipani | 2 | 108824 | 4 | 7.173 | 15171.3 |
| 241 | 2024-04-21 06:02:17 | frangipani | 3 | 140603 | 4 | 20.860 | 6740.3 |
| 240 | 2024-04-21 06:02:20 | frangipani | 2 | 108824 | 4 | 10.860 | 10020.6 |
| 239 | 2024-04-21 05:59:03 | frangipani | 1 | 67641 | 3 | 1.326 | 51011.3 |
| 238 | 2024-04-21 05:59:00 | frangipani | 1 | 67641 | 3 | 1.280 | 52844.5 |
| 237 | 2024-04-20 17:06:37 | frangipani | 4 | 161450 | 22 | 28.503 | 5664.3 |
| 236 | 2024-04-18 19:01:15 | frangipani | 4 | 161450 | 22 | 12.940 | 12476.8 |
| 235 | 2024-04-07 18:55:10 | frangipani | 4 | 161450 | 22 | 32.173 | 5018.2 |
| 234 | 2024-04-07 13:46:30 | frangipani | 4 | 161450 | 22 | 44.720 | 3610.2 |
| 233 | 2024-04-07 13:46:35 | frangipani | 3 | 140603 | 4 | 10.486 | 13408.6 |
| 232 | 2024-04-07 13:46:29 | frangipani | 2 | 108824 | 4 | 13.470 | 8079.0 |
| 231 | 2024-04-07 13:44:53 | frangipani | 1 | 67641 | 3 | 2.966 | 22805.5 |
| 230 | 2024-03-28 03:42:00 | frangipani | 3 | 140603 | 4 | 5.390 | 26085.9 |
| 229 | 2024-03-26 05:55:15 | frangipani | 5 | 173545 | 210 | 43.470 | 3992.3 |
| 228 | 2024-03-21 06:15:51 | frangipani | 5 | 173545 | 210 | 53.893 | 3220.2 |
| 227 | 2024-03-20 20:51:41 | frangipani | 5 | 173545 | 210 | 58.626 | 2960.2 |
| 226 | 2024-03-19 04:18:35 | frangipani | 5 | 173545 | 210 | 30.550 | 5680.7 |
| 225 | 2024-03-19 04:19:03 | frangipani | 1 | 67641 | 3 | 2.563 | 26391.3 |
| 224 | 2024-03-19 04:18:40 | frangipani | 4 | 161450 | 22 | 20.783 | 7768.4 |
| 223 | 2024-03-19 04:18:41 | frangipani | 3 | 140603 | 4 | 15.533 | 9051.9 |
| 222 | 2024-03-19 04:18:37 | frangipani | 2 | 108824 | 4 | 3.126 | 34812.5 |
| 221 | 2024-03-19 04:18:33 | frangipani | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 220 | 2024-03-19 04:18:31 | frangipani | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 219 | 2024-03-09 07:52:14 | frangipani | 4 | 161450 | 22 | 19.190 | 8413.2 |
| 218 | 2024-03-03 07:27:38 | frangipani | 4 | 161450 | 22 | 45.783 | 3526.4 |
| 217 | 2024-03-03 07:27:41 | frangipani | 3 | 140603 | 4 | 9.216 | 15256.4 |
| 216 | 2024-03-03 07:27:38 | frangipani | 2 | 108824 | 4 | 5.123 | 21242.2 |
| 215 | 2024-03-03 06:16:05 | frangipani | 1 | 67641 | 3 | 3.856 | 17541.8 |
| 214 | 2024-03-02 07:50:48 | frangipani | 3 | 140603 | 4 | 15.626 | 8998.0 |
| 213 | 2024-03-02 07:50:47 | frangipani | 2 | 108824 | 4 | 6.313 | 17238.1 |
| 212 | 2024-03-02 00:04:39 | frangipani | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 211 | 2024-02-26 00:22:32 | frangipani | 5 | 173545 | 210 | 42.673 | 4066.9 |
| 210 | 2024-02-23 12:28:36 | frangipani | 5 | 173545 | 210 | 22.170 | 7827.9 |
| 209 | 2024-02-23 06:38:07 | frangipani | 4 | 161450 | 22 | 11.470 | 14075.9 |
| 208 | 2024-02-19 23:00:42 | frangipani | 4 | 161450 | 22 | 31.643 | 5102.2 |
| 207 | 2024-02-19 23:00:42 | frangipani | 3 | 140603 | 4 | 15.580 | 9024.6 |
| 206 | 2024-02-19 23:00:36 | frangipani | 2 | 108824 | 4 | 7.610 | 14300.1 |
| 205 | 2024-02-19 10:22:54 | frangipani | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 204 | 2024-02-19 09:22:43 | frangipani | 4 | 161450 | 22 | 11.953 | 13507.1 |
| 203 | 2024-02-17 23:16:46 | frangipani | 4 | 161450 | 22 | 42.033 | 3841.0 |
| 202 | 2024-02-17 23:16:45 | frangipani | 4 | 161450 | 22 | 13.750 | 11741.8 |
| 201 | 2024-02-17 06:01:45 | frangipani | 5 | 173545 | 210 | 63.426 | 2736.2 |
| 200 | 2024-02-17 06:01:44 | frangipani | 4 | 161450 | 22 | 33.860 | 4768.2 |
| 199 | 2024-02-17 06:01:47 | frangipani | 3 | 140603 | 4 | 11.593 | 12128.3 |
| 198 | 2024-02-17 06:01:46 | frangipani | 2 | 108824 | 4 | 5.483 | 19847.5 |
| 197 | 2024-02-17 01:52:18 | frangipani | 1 | 67641 | 3 | 2.783 | 24305.1 |
| 196 | 2023-12-23 12:37:05 | frangipani | 2 | 108824 | 4 | 2.763 | 39386.2 |
| 195 | 2023-12-08 17:42:39 | frangipani | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 194 | 2023-11-30 03:14:59 | frangipani | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 193 | 2023-11-01 05:00:02 | frangipani | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 192 | 2023-09-23 16:46:01 | frangipani | 2 | 108824 | 4 | 2.703 | 40260.5 |
| 191 | 2023-09-22 17:28:19 | frangipani | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 190 | 2023-07-16 01:47:44 | frangipani | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 189 | 2023-07-01 23:26:23 | frangipani | 2 | 108824 | 4 | 2.923 | 37230.2 |
| 188 | 2023-06-15 05:19:20 | frangipani | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 187 | 2023-06-11 21:51:26 | frangipani | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 186 | 2023-04-13 20:46:52 | frangipani | 1 | 67641 | 3 | 0.966 | 70021.7 |
| 185 | 2023-03-22 03:22:47 | frangipani | 2 | 108824 | 4 | 2.580 | 42179.8 |
| 184 | 2023-02-04 13:41:17 | frangipani | 1 | 67641 | 3 | 0.986 | 68601.4 |
| 183 | 2023-01-04 18:33:41 | frangipani | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 182 | 2022-12-21 17:45:43 | frangipani | 2 | 108824 | 4 | 2.576 | 42245.3 |
| 181 | 2022-12-02 05:49:01 | frangipani | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 180 | 2022-08-19 13:46:17 | frangipani | 2 | 108824 | 4 | 2.610 | 41695.0 |
| 179 | 2022-07-27 08:24:38 | frangipani | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 178 | 2022-07-13 18:21:47 | frangipani | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 177 | 2022-01-20 11:18:27 | frangipani | 1 | 67641 | 3 | 0.966 | 70021.7 |
| 176 | 2022-01-17 04:49:54 | frangipani | 1 | 67641 | 3 | 2.576 | 26258.2 |
| 175 | 2022-01-13 22:02:34 | frangipani | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 174 | 2021-08-26 16:02:49 | frangipani | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 173 | 2021-04-21 05:30:18 | frangipani | 1 | 67641 | 3 | 1.106 | 61158.2 |
| 172 | 2021-04-17 03:56:07 | frangipani | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 171 | 2021-01-29 17:44:13 | frangipani | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 170 | 2021-01-01 09:08:21 | frangipani | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 169 | 2020-12-20 08:33:25 | frangipani | 1 | 67641 | 3 | 1.043 | 64852.3 |
| 168 | 2020-10-17 08:10:00 | frangipani | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 167 | 2020-08-23 23:33:25 | frangipani | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 166 | 2020-04-15 05:29:38 | frangipani | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 165 | 2020-03-26 21:03:51 | frangipani | 2 | 108824 | 4 | 2.860 | 38050.3 |
| 164 | 2020-03-26 05:53:59 | frangipani | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 163 | 2020-03-03 09:24:49 | frangipani | 4 | 161450 | 22 | 9.530 | 16941.2 |
| 162 | 2020-03-03 09:23:43 | frangipani | 3 | 140603 | 4 | 10.783 | 13039.3 |
| 161 | 2020-03-03 09:23:08 | frangipani | 2 | 108824 | 4 | 3.016 | 36082.2 |
| 160 | 2020-03-03 05:18:30 | frangipani | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 159 | 2020-02-19 22:47:28 | frangipani | 2 | 108824 | 4 | 2.843 | 38277.9 |
| 158 | 2020-02-19 22:29:27 | frangipani | 3 | 140603 | 4 | 13.190 | 10659.8 |
| 157 | 2020-02-19 22:25:29 | frangipani | 4 | 161450 | 22 | 15.296 | 10555.0 |
| 156 | 2020-02-19 11:54:05 | frangipani | 1 | 67641 | 3 | 2.686 | 25182.8 |
| 155 | 2020-02-12 01:45:16 | frangipani | 5 | 173545 | 210 | 25.796 | 6727.6 |
| 154 | 2020-02-10 19:50:05 | frangipani | 5 | 173545 | 210 | 20.876 | 8313.1 |
| 153 | 2020-02-08 06:40:07 | frangipani | 5 | 173545 | 210 | 41.520 | 4179.8 |
| 152 | 2020-01-22 20:42:46 | frangipani | 4 | 161450 | 22 | 10.343 | 15609.6 |
| 151 | 2020-01-22 10:08:31 | frangipani | 5 | 173545 | 210 | 18.530 | 9365.6 |