History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tumour"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 321 | 2024-12-23 03:38:13 | tumour | 3 | 112716 | 218 | 26.033 | 4329.7 |
| 320 | 2024-12-21 02:55:27 | tumour | 3 | 112716 | 218 | 23.423 | 4812.2 |
| 319 | 2024-12-19 10:57:42 | tumour | 3 | 112716 | 218 | 35.240 | 3198.5 |
| 318 | 2024-12-18 11:14:07 | tumour | 1 | 48755 | 5 | 2.310 | 21106.1 |
| 317 | 2024-12-18 00:18:50 | tumour | 3 | 112716 | 218 | 22.546 | 4999.4 |
| 316 | 2024-12-16 13:46:51 | tumour | 1 | 48755 | 5 | 3.143 | 15512.2 |
| 315 | 2024-12-11 00:45:41 | tumour | 1 | 48755 | 5 | 3.953 | 12333.7 |
| 314 | 2024-12-10 19:08:16 | tumour | 1 | 48755 | 5 | 4.280 | 11391.4 |
| 313 | 2024-11-18 02:22:12 | tumour | 2 | 82551 | 19 | 11.720 | 7043.6 |
| 312 | 2024-11-18 02:16:16 | tumour | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 311 | 2024-11-12 20:41:20 | tumour | 3 | 112716 | 218 | 12.720 | 8861.3 |
| 310 | 2024-11-10 20:21:29 | tumour | 1 | 48755 | 5 | 2.000 | 24377.5 |
| 309 | 2024-11-10 17:05:44 | tumour | 3 | 112716 | 218 | 31.486 | 3579.9 |
| 308 | 2024-11-10 17:05:46 | tumour | 2 | 82551 | 19 | 18.283 | 4515.2 |
| 307 | 2024-11-10 14:05:34 | tumour | 1 | 48755 | 5 | 0.910 | 53576.9 |
| 306 | 2024-11-10 09:15:27 | tumour | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 305 | 2024-10-15 17:12:35 | tumour | 1 | 48755 | 5 | 5.656 | 8620.0 |
| 304 | 2024-10-10 22:24:23 | tumour | 2 | 82551 | 19 | 13.126 | 6289.1 |
| 303 | 2024-10-10 22:24:27 | tumour | 1 | 48755 | 5 | 5.563 | 8764.2 |
| 302 | 2024-10-10 22:20:10 | tumour | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 301 | 2024-10-10 22:20:07 | tumour | 2 | 82551 | 19 | 2.563 | 32208.7 |
| 300 | 2024-09-25 13:20:17 | tumour | 3 | 112716 | 218 | 42.863 | 2629.7 |
| 299 | 2024-09-22 08:43:47 | tumour | 3 | 112716 | 218 | 45.313 | 2487.5 |
| 298 | 2024-09-22 08:43:45 | tumour | 2 | 82551 | 19 | 9.456 | 8730.0 |
| 297 | 2024-09-13 18:59:33 | tumour | 3 | 112716 | 218 | 18.236 | 6181.0 |
| 296 | 2024-09-10 00:02:46 | tumour | 2 | 82551 | 19 | 17.470 | 4725.3 |
| 295 | 2024-09-10 00:02:44 | tumour | 1 | 48755 | 5 | 9.936 | 4906.9 |
| 294 | 2024-09-09 21:42:15 | tumour | 3 | 112716 | 218 | 20.003 | 5635.0 |
| 293 | 2024-09-09 21:42:13 | tumour | 2 | 82551 | 19 | 9.423 | 8760.6 |
| 292 | 2024-09-09 21:42:02 | tumour | 1 | 48755 | 5 | 8.330 | 5852.9 |
| 291 | 2024-09-09 15:06:02 | tumour | 1 | 48755 | 5 | 7.763 | 6280.4 |
| 290 | 2024-09-03 02:45:30 | tumour | 1 | 48755 | 5 | 5.576 | 8743.7 |
| 289 | 2024-08-30 17:58:11 | tumour | 1 | 48755 | 5 | 7.483 | 6515.4 |
| 288 | 2024-08-16 09:02:31 | tumour | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 287 | 2024-08-11 11:56:23 | tumour | 3 | 112716 | 218 | 17.936 | 6284.3 |
| 286 | 2024-08-11 10:07:44 | tumour | 3 | 112716 | 218 | 20.546 | 5486.0 |
| 285 | 2024-08-09 06:05:26 | tumour | 3 | 112716 | 218 | 19.190 | 5873.7 |
| 284 | 2024-08-08 23:25:27 | tumour | 1 | 48755 | 5 | 1.266 | 38511.1 |
| 283 | 2024-08-08 02:26:47 | tumour | 1 | 48755 | 5 | 4.530 | 10762.7 |
| 282 | 2024-08-08 02:22:04 | tumour | 3 | 112716 | 218 | 22.393 | 5033.5 |
| 281 | 2024-08-08 02:22:09 | tumour | 2 | 82551 | 19 | 9.173 | 8999.3 |
| 280 | 2024-08-03 02:18:58 | tumour | 1 | 48755 | 5 | 2.750 | 17729.1 |
| 279 | 2024-08-02 02:44:47 | tumour | 1 | 48755 | 5 | 3.330 | 14641.1 |
| 278 | 2024-07-31 06:31:17 | tumour | 1 | 48755 | 5 | 4.500 | 10834.4 |
| 277 | 2024-07-30 21:22:32 | tumour | 1 | 48755 | 5 | 2.796 | 17437.4 |
| 276 | 2024-07-29 19:26:37 | tumour | 1 | 48755 | 5 | 1.860 | 26212.4 |
| 275 | 2024-07-16 22:28:46 | tumour | 1 | 48755 | 5 | 3.000 | 16251.7 |
| 274 | 2024-07-10 00:07:09 | tumour | 1 | 48755 | 5 | 2.140 | 22782.7 |
| 273 | 2024-07-07 15:05:04 | tumour | 1 | 48755 | 5 | 4.170 | 11691.8 |
| 272 | 2024-07-02 17:38:57 | tumour | 1 | 48755 | 5 | 4.173 | 11683.4 |
| 271 | 2024-07-02 02:29:47 | tumour | 1 | 48755 | 5 | 2.940 | 16583.3 |
| 270 | 2024-06-30 20:44:59 | tumour | 1 | 48755 | 5 | 5.126 | 9511.3 |
| 269 | 2024-06-29 15:38:55 | tumour | 1 | 48755 | 5 | 3.080 | 15829.5 |
| 268 | 2024-06-23 09:05:40 | tumour | 1 | 48755 | 5 | 3.486 | 13985.9 |
| 267 | 2024-06-20 04:34:17 | tumour | 1 | 48755 | 5 | 3.423 | 14243.4 |
| 266 | 2024-06-08 03:00:40 | tumour | 1 | 48755 | 5 | 2.783 | 17518.9 |
| 265 | 2024-05-29 20:58:07 | tumour | 1 | 48755 | 5 | 1.686 | 28917.6 |
| 264 | 2024-05-06 04:38:55 | tumour | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 263 | 2024-04-06 00:31:28 | tumour | 2 | 82551 | 19 | 6.550 | 12603.2 |
| 262 | 2024-04-05 00:17:37 | tumour | 2 | 82551 | 19 | 4.953 | 16666.9 |
| 261 | 2024-04-05 00:17:30 | tumour | 1 | 48755 | 5 | 1.796 | 27146.4 |
| 260 | 2024-04-05 00:17:18 | tumour | 2 | 82551 | 19 | 4.953 | 16666.9 |
| 259 | 2024-04-05 00:17:17 | tumour | 1 | 48755 | 5 | 1.046 | 46610.9 |
| 258 | 2024-04-02 01:09:55 | tumour | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 257 | 2024-04-01 04:47:40 | tumour | 3 | 112716 | 218 | 17.720 | 6360.9 |
| 256 | 2024-03-30 23:54:39 | tumour | 3 | 112716 | 218 | 12.953 | 8701.9 |
| 255 | 2024-03-30 20:05:57 | tumour | 3 | 112716 | 218 | 14.220 | 7926.6 |
| 254 | 2024-03-30 07:15:52 | tumour | 3 | 112716 | 218 | 14.563 | 7739.9 |
| 253 | 2024-03-30 07:15:56 | tumour | 2 | 82551 | 19 | 7.343 | 11242.1 |
| 252 | 2024-03-30 07:15:51 | tumour | 1 | 48755 | 5 | 0.940 | 51867.0 |
| 251 | 2023-12-22 20:02:23 | tumour | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 250 | 2023-12-19 17:22:55 | tumour | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 249 | 2023-11-23 09:39:26 | tumour | 2 | 82551 | 19 | 3.126 | 26407.9 |
| 248 | 2023-11-23 09:39:13 | tumour | 3 | 112716 | 218 | 5.423 | 20784.8 |
| 247 | 2023-11-09 12:53:42 | tumour | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 246 | 2023-11-08 14:34:54 | tumour | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 245 | 2023-11-06 13:23:20 | tumour | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 244 | 2023-11-05 07:45:19 | tumour | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 243 | 2023-10-29 16:27:04 | tumour | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 242 | 2023-10-19 19:24:43 | tumour | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 241 | 2023-10-11 22:26:33 | tumour | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 240 | 2023-10-10 15:59:46 | tumour | 1 | 48755 | 5 | 1.470 | 33166.7 |
| 239 | 2023-09-28 14:23:44 | tumour | 3 | 112716 | 218 | 5.610 | 20092.0 |
| 238 | 2023-09-28 14:23:42 | tumour | 2 | 82551 | 19 | 2.046 | 40347.5 |
| 237 | 2023-09-25 03:37:41 | tumour | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 236 | 2023-09-12 05:31:58 | tumour | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 235 | 2023-08-06 09:06:07 | tumour | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 234 | 2023-06-24 22:51:39 | tumour | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 233 | 2023-05-02 19:36:16 | tumour | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 232 | 2023-02-23 11:10:26 | tumour | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 231 | 2023-02-13 11:47:06 | tumour | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 230 | 2022-12-20 21:01:29 | tumour | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 229 | 2022-09-24 12:20:18 | tumour | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 228 | 2022-09-20 22:04:11 | tumour | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 227 | 2022-09-01 10:37:17 | tumour | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 226 | 2022-08-30 02:16:19 | tumour | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 225 | 2022-04-23 12:14:49 | tumour | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 224 | 2022-04-20 01:29:14 | tumour | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 223 | 2022-04-14 16:06:53 | tumour | 1 | 48755 | 5 | 1.156 | 42175.6 |
| 222 | 2022-01-12 12:58:24 | tumour | 1 | 48755 | 5 | 0.846 | 57630.0 |