History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affiancing"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 257 | 2025-12-31 22:44:15 | affiancing | 1 | 67641 | 1 | 1.486 | 45518.8 |
| 256 | 2025-12-08 05:11:47 | affiancing | 1 | 67641 | 1 | 1.013 | 66773.0 |
| 255 | 2025-12-08 01:44:20 | affiancing | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 254 | 2025-11-27 11:15:37 | affiancing | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 253 | 2025-11-25 05:08:05 | affiancing | 4 | 161450 | 102 | 11.063 | 14593.7 |
| 252 | 2025-11-18 10:48:06 | affiancing | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 251 | 2025-11-16 10:42:45 | affiancing | 1 | 67641 | 1 | 3.906 | 17317.2 |
| 250 | 2025-11-14 02:39:37 | affiancing | 4 | 161450 | 102 | 19.563 | 8252.8 |
| 249 | 2025-11-12 23:19:11 | affiancing | 4 | 161450 | 102 | 11.110 | 14532.0 |
| 248 | 2025-10-17 08:49:32 | affiancing | 4 | 161450 | 102 | 9.266 | 17423.9 |
| 247 | 2025-10-16 00:04:12 | affiancing | 3 | 140603 | 13 | 5.186 | 27112.0 |
| 246 | 2025-10-14 23:23:00 | affiancing | 4 | 161450 | 102 | 9.436 | 17110.0 |
| 245 | 2025-10-13 06:48:03 | affiancing | 4 | 161450 | 102 | 9.076 | 17788.7 |
| 244 | 2025-10-11 21:29:58 | affiancing | 3 | 140603 | 13 | 5.310 | 26478.9 |
| 243 | 2025-10-08 05:46:12 | affiancing | 2 | 108824 | 1 | 2.796 | 38921.3 |
| 242 | 2025-10-08 05:46:00 | affiancing | 4 | 161450 | 102 | 11.983 | 13473.3 |
| 241 | 2025-10-08 05:45:52 | affiancing | 3 | 140603 | 13 | 6.216 | 22619.5 |
| 240 | 2025-10-07 18:56:50 | affiancing | 1 | 67641 | 1 | 1.013 | 66773.0 |
| 239 | 2025-08-17 15:46:27 | affiancing | 1 | 67641 | 1 | 2.750 | 24596.7 |
| 238 | 2025-08-15 19:50:35 | affiancing | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 237 | 2025-07-25 12:29:23 | affiancing | 1 | 67641 | 1 | 4.906 | 13787.4 |
| 236 | 2025-07-24 23:42:15 | affiancing | 1 | 67641 | 1 | 4.156 | 16275.5 |
| 235 | 2025-07-24 05:25:52 | affiancing | 1 | 67641 | 1 | 5.626 | 12022.9 |
| 234 | 2025-07-18 07:37:14 | affiancing | 1 | 67641 | 1 | 2.703 | 25024.4 |
| 233 | 2025-06-27 14:31:38 | affiancing | 3 | 140603 | 13 | 26.733 | 5259.5 |
| 232 | 2025-06-27 02:52:19 | affiancing | 2 | 108824 | 1 | 10.280 | 10586.0 |
| 231 | 2025-06-27 01:16:57 | affiancing | 3 | 140603 | 13 | 30.736 | 4574.5 |
| 230 | 2025-06-24 11:50:00 | affiancing | 1 | 67641 | 1 | 5.673 | 11923.3 |
| 229 | 2025-06-15 00:17:35 | affiancing | 3 | 140603 | 13 | 34.986 | 4018.8 |
| 228 | 2025-06-14 20:21:30 | affiancing | 2 | 108824 | 1 | 13.546 | 8033.7 |
| 227 | 2025-06-14 19:55:56 | affiancing | 3 | 140603 | 13 | 40.800 | 3446.2 |
| 226 | 2025-06-13 04:25:43 | affiancing | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 225 | 2025-04-29 03:41:36 | affiancing | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 224 | 2025-04-20 04:17:15 | affiancing | 1 | 67641 | 1 | 2.843 | 23792.1 |
| 223 | 2025-04-11 00:49:54 | affiancing | 1 | 67641 | 1 | 3.343 | 20233.6 |
| 222 | 2025-03-08 23:38:23 | affiancing | 1 | 67641 | 1 | 6.376 | 10608.7 |
| 221 | 2025-02-28 05:51:58 | affiancing | 1 | 67641 | 1 | 5.186 | 13043.0 |
| 220 | 2025-02-09 03:15:29 | affiancing | 1 | 67641 | 1 | 2.936 | 23038.5 |
| 219 | 2025-01-09 09:39:48 | affiancing | 2 | 108824 | 1 | 14.580 | 7463.9 |
| 218 | 2025-01-09 09:38:47 | affiancing | 1 | 67641 | 1 | 4.763 | 14201.3 |
| 217 | 2025-01-03 01:59:30 | affiancing | 2 | 108824 | 1 | 11.796 | 9225.5 |
| 216 | 2025-01-03 01:58:20 | affiancing | 3 | 140603 | 13 | 34.390 | 4088.5 |
| 215 | 2025-01-03 01:55:47 | affiancing | 1 | 67641 | 1 | 6.906 | 9794.5 |
| 214 | 2025-01-02 22:36:01 | affiancing | 3 | 140603 | 13 | 33.083 | 4250.0 |
| 213 | 2024-12-28 08:18:04 | affiancing | 1 | 67641 | 1 | 0.986 | 68601.4 |
| 212 | 2024-12-27 23:20:33 | affiancing | 3 | 140603 | 13 | 44.986 | 3125.5 |
| 211 | 2024-12-27 23:20:31 | affiancing | 3 | 140603 | 13 | 45.706 | 3076.2 |
| 210 | 2024-12-27 23:20:32 | affiancing | 2 | 108824 | 1 | 13.953 | 7799.3 |
| 209 | 2024-12-27 21:35:52 | affiancing | 1 | 67641 | 1 | 5.470 | 12365.8 |
| 208 | 2024-11-27 11:33:31 | affiancing | 1 | 67641 | 1 | 1.106 | 61158.2 |
| 207 | 2024-11-26 20:50:55 | affiancing | 3 | 140603 | 13 | 45.000 | 3124.5 |
| 206 | 2024-11-21 07:11:11 | affiancing | 3 | 140603 | 13 | 32.423 | 4336.5 |
| 205 | 2024-11-20 06:53:11 | affiancing | 3 | 140603 | 13 | 38.813 | 3622.6 |
| 204 | 2024-11-20 06:53:13 | affiancing | 2 | 108824 | 1 | 21.296 | 5110.1 |
| 203 | 2024-11-20 06:10:37 | affiancing | 1 | 67641 | 1 | 1.013 | 66773.0 |
| 202 | 2024-10-08 11:36:08 | affiancing | 3 | 140603 | 13 | 48.063 | 2925.4 |
| 201 | 2024-10-08 11:36:04 | affiancing | 2 | 108824 | 1 | 16.470 | 6607.4 |
| 200 | 2024-10-08 11:35:28 | affiancing | 1 | 67641 | 1 | 6.563 | 10306.4 |
| 199 | 2024-10-03 11:51:38 | affiancing | 3 | 140603 | 13 | 39.083 | 3597.5 |
| 198 | 2024-10-03 11:51:23 | affiancing | 3 | 140603 | 13 | 33.546 | 4191.3 |
| 197 | 2024-10-03 11:51:28 | affiancing | 2 | 108824 | 1 | 24.360 | 4467.3 |
| 196 | 2024-10-03 11:51:04 | affiancing | 1 | 67641 | 1 | 4.970 | 13609.9 |
| 195 | 2024-10-01 23:37:59 | affiancing | 2 | 108824 | 1 | 22.066 | 4931.8 |
| 194 | 2024-10-01 23:37:07 | affiancing | 1 | 67641 | 1 | 4.330 | 15621.5 |
| 193 | 2024-09-27 05:24:55 | affiancing | 3 | 140603 | 13 | 41.613 | 3378.8 |
| 192 | 2024-09-24 00:44:36 | affiancing | 3 | 140603 | 13 | 39.546 | 3555.4 |
| 191 | 2024-09-22 15:25:29 | affiancing | 3 | 140603 | 13 | 45.753 | 3073.1 |
| 190 | 2024-09-22 04:20:06 | affiancing | 3 | 140603 | 13 | 59.500 | 2363.1 |
| 189 | 2024-09-12 09:39:14 | affiancing | 3 | 140603 | 13 | 31.563 | 4454.7 |
| 188 | 2024-08-23 15:43:40 | affiancing | 4 | 161450 | 102 | 80.816 | 1997.7 |
| 187 | 2024-08-23 15:43:43 | affiancing | 3 | 140603 | 13 | 45.723 | 3075.1 |
| 186 | 2024-08-23 15:43:44 | affiancing | 2 | 108824 | 1 | 27.550 | 3950.1 |
| 185 | 2024-08-23 15:11:57 | affiancing | 1 | 67641 | 1 | 3.876 | 17451.2 |
| 184 | 2024-08-22 19:09:38 | affiancing | 2 | 108824 | 1 | 20.140 | 5403.4 |
| 183 | 2024-08-22 19:09:00 | affiancing | 1 | 67641 | 1 | 2.406 | 28113.5 |
| 182 | 2024-08-19 13:07:38 | affiancing | 1 | 67641 | 1 | 5.313 | 12731.2 |
| 181 | 2024-08-08 09:04:35 | affiancing | 3 | 140603 | 13 | 18.093 | 7771.1 |
| 180 | 2024-08-08 09:04:36 | affiancing | 2 | 108824 | 1 | 10.970 | 9920.1 |
| 179 | 2024-08-08 08:57:24 | affiancing | 1 | 67641 | 1 | 2.186 | 30942.8 |
| 178 | 2024-07-20 13:01:59 | affiancing | 3 | 140603 | 13 | 18.360 | 7658.1 |
| 177 | 2024-07-17 11:01:18 | affiancing | 3 | 140603 | 13 | 29.520 | 4763.0 |
| 176 | 2024-07-16 16:33:16 | affiancing | 1 | 67641 | 1 | 6.000 | 11273.5 |
| 175 | 2024-07-16 16:21:08 | affiancing | 1 | 67641 | 1 | 4.983 | 13574.4 |
| 174 | 2024-07-15 09:06:30 | affiancing | 3 | 140603 | 13 | 24.046 | 5847.3 |
| 173 | 2024-07-14 13:16:48 | affiancing | 4 | 161450 | 102 | 48.473 | 3330.7 |
| 172 | 2024-07-14 10:12:14 | affiancing | 4 | 161450 | 102 | 63.010 | 2562.3 |
| 171 | 2024-07-13 04:40:01 | affiancing | 3 | 140603 | 13 | 12.093 | 11626.8 |
| 170 | 2024-07-12 11:20:42 | affiancing | 4 | 161450 | 102 | 47.316 | 3412.2 |
| 169 | 2024-07-12 11:20:46 | affiancing | 3 | 140603 | 13 | 30.596 | 4595.5 |
| 168 | 2024-07-12 11:20:43 | affiancing | 2 | 108824 | 1 | 7.966 | 13661.1 |
| 167 | 2024-07-12 09:29:08 | affiancing | 1 | 67641 | 1 | 1.220 | 55443.4 |
| 166 | 2024-07-11 23:00:47 | affiancing | 1 | 67641 | 1 | 2.763 | 24481.0 |
| 165 | 2024-06-14 12:19:21 | affiancing | 1 | 67641 | 1 | 3.826 | 17679.3 |
| 164 | 2024-06-14 07:59:26 | affiancing | 3 | 140603 | 13 | 23.686 | 5936.1 |
| 163 | 2024-06-14 07:55:20 | affiancing | 1 | 67641 | 1 | 2.766 | 24454.4 |
| 162 | 2024-06-13 11:26:50 | affiancing | 2 | 108824 | 1 | 13.456 | 8087.4 |
| 161 | 2024-06-13 11:26:40 | affiancing | 3 | 140603 | 13 | 11.143 | 12618.1 |
| 160 | 2024-06-13 11:26:07 | affiancing | 1 | 67641 | 1 | 5.236 | 12918.4 |
| 159 | 2024-06-12 15:32:11 | affiancing | 4 | 161450 | 102 | 28.940 | 5578.8 |
| 158 | 2024-06-12 11:27:07 | affiancing | 4 | 161450 | 102 | 46.236 | 3491.9 |