History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pizzazz"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
5407 | 2024-04-18 22:21:38 | pizzazz | 4 | 151207 | 185 | 11.873 | 12735.4 |
5406 | 2024-04-18 05:35:54 | pizzazz | 3 | 134027 | 19 | 15.610 | 8586.0 |
5405 | 2024-04-17 10:01:58 | pizzazz | 4 | 151207 | 185 | 12.643 | 11959.7 |
5404 | 2024-04-17 10:01:51 | pizzazz | 3 | 134027 | 19 | 6.580 | 20368.8 |
5403 | 2024-04-17 10:01:47 | pizzazz | 2 | 107671 | 10 | 3.483 | 30913.3 |
5402 | 2024-04-17 08:36:38 | pizzazz | 1 | 69583 | 4 | 1.220 | 57035.2 |
5401 | 2024-04-14 17:10:31 | pizzazz | 1 | 69583 | 4 | 3.263 | 21324.9 |
5400 | 2024-04-13 15:04:42 | pizzazz | 4 | 151207 | 185 | 11.923 | 12682.0 |
5399 | 2024-04-13 15:04:34 | pizzazz | 3 | 134027 | 19 | 7.096 | 18887.7 |
5398 | 2024-04-13 15:04:30 | pizzazz | 2 | 107671 | 10 | 3.453 | 31181.9 |
5397 | 2024-04-13 14:06:00 | pizzazz | 1 | 69583 | 4 | 1.250 | 55666.4 |
5396 | 2024-04-11 13:21:14 | pizzazz | 4 | 151207 | 185 | 11.110 | 13610.0 |
5395 | 2024-04-11 05:40:58 | pizzazz | 1 | 69583 | 4 | 1.296 | 53690.6 |
5394 | 2024-04-10 22:51:38 | pizzazz | 4 | 151207 | 185 | 25.080 | 6029.0 |
5393 | 2024-04-10 19:08:26 | pizzazz | 1 | 69583 | 4 | 2.046 | 34009.3 |
5392 | 2024-04-09 16:27:34 | pizzazz | 1 | 69583 | 4 | 1.233 | 56433.9 |
5391 | 2024-04-09 16:26:28 | pizzazz | 1 | 69583 | 4 | 1.093 | 63662.4 |
5390 | 2024-04-09 15:58:18 | pizzazz | 4 | 151207 | 185 | 18.330 | 8249.2 |
5389 | 2024-04-09 15:56:38 | pizzazz | 2 | 107671 | 10 | 8.013 | 13437.0 |
5388 | 2024-04-09 15:53:03 | pizzazz | 1 | 69583 | 4 | 1.406 | 49490.0 |
5387 | 2024-04-03 19:49:59 | pizzazz | 1 | 69583 | 4 | 2.860 | 24329.7 |
5386 | 2024-04-02 17:11:43 | pizzazz | 1 | 69583 | 4 | 1.076 | 64668.2 |
5385 | 2024-03-29 19:03:24 | pizzazz | 1 | 69583 | 4 | 1.486 | 46825.7 |
5384 | 2024-03-29 11:06:24 | pizzazz | 1 | 69583 | 4 | 2.860 | 24329.7 |
5383 | 2024-03-29 08:04:50 | pizzazz | 4 | 151207 | 185 | 20.406 | 7409.9 |
5382 | 2024-03-28 18:55:14 | pizzazz | 4 | 151207 | 185 | 25.470 | 5936.7 |
5381 | 2024-03-28 13:50:22 | pizzazz | 4 | 151207 | 185 | 10.703 | 14127.5 |
5380 | 2024-03-16 00:15:09 | pizzazz | 1 | 69583 | 4 | 1.266 | 54962.9 |
5379 | 2024-03-08 10:34:30 | pizzazz | 1 | 69583 | 4 | 3.873 | 17966.2 |
5378 | 2024-03-07 07:34:35 | pizzazz | 4 | 151207 | 185 | 32.406 | 4666.0 |
5377 | 2024-03-06 04:31:16 | pizzazz | 3 | 134027 | 19 | 21.330 | 6283.5 |
5376 | 2024-03-06 04:31:29 | pizzazz | 1 | 69583 | 4 | 2.763 | 25183.9 |
5375 | 2024-03-06 04:31:18 | pizzazz | 2 | 107671 | 10 | 8.530 | 12622.6 |
5374 | 2024-03-05 10:12:33 | pizzazz | 4 | 151207 | 185 | 21.843 | 6922.4 |
5373 | 2024-03-05 10:12:26 | pizzazz | 3 | 134027 | 19 | 6.203 | 21606.8 |
5372 | 2024-03-05 10:12:19 | pizzazz | 2 | 107671 | 10 | 6.670 | 16142.6 |
5371 | 2024-03-05 08:48:06 | pizzazz | 1 | 69583 | 4 | 1.313 | 52995.4 |
5370 | 2024-03-02 16:01:00 | pizzazz | 1 | 69583 | 4 | 1.093 | 63662.4 |
5369 | 2024-02-28 08:58:10 | pizzazz | 4 | 151207 | 185 | 26.596 | 5685.3 |
5368 | 2024-02-28 04:47:17 | pizzazz | 1 | 69583 | 4 | 1.356 | 51314.9 |
5367 | 2024-02-28 04:42:24 | pizzazz | 2 | 107671 | 10 | 7.343 | 14663.1 |
5366 | 2024-02-28 04:42:01 | pizzazz | 3 | 134027 | 19 | 15.326 | 8745.1 |
5365 | 2024-02-28 04:41:55 | pizzazz | 4 | 151207 | 185 | 20.420 | 7404.8 |
5364 | 2024-02-28 04:41:41 | pizzazz | 1 | 69583 | 4 | 1.296 | 53690.6 |
5363 | 2024-02-26 09:16:30 | pizzazz | 3 | 134027 | 19 | 10.626 | 12613.1 |
5362 | 2024-02-26 09:16:28 | pizzazz | 2 | 107671 | 10 | 3.296 | 32667.2 |
5361 | 2024-02-25 16:15:33 | pizzazz | 4 | 151207 | 185 | 11.110 | 13610.0 |
5360 | 2024-02-25 16:15:32 | pizzazz | 3 | 134027 | 19 | 6.580 | 20368.8 |
5359 | 2024-02-25 16:15:31 | pizzazz | 2 | 107671 | 10 | 3.233 | 33303.7 |
5358 | 2024-02-25 15:47:48 | pizzazz | 1 | 69583 | 4 | 1.093 | 63662.4 |
5357 | 2024-02-21 07:09:43 | pizzazz | 1 | 69583 | 4 | 3.236 | 21502.8 |
5356 | 2024-02-21 06:02:35 | pizzazz | 1 | 69583 | 4 | 2.156 | 32274.1 |
5355 | 2024-02-05 13:06:31 | pizzazz | 1 | 69583 | 4 | 2.436 | 28564.4 |
5354 | 2024-02-02 21:59:41 | pizzazz | 4 | 151207 | 185 | 10.686 | 14150.0 |
5353 | 2024-01-29 02:52:02 | pizzazz | 1 | 69583 | 4 | 1.110 | 62687.4 |
5352 | 2024-01-26 14:15:45 | pizzazz | 4 | 151207 | 185 | 12.266 | 12327.3 |
5351 | 2024-01-26 14:15:39 | pizzazz | 3 | 134027 | 19 | 6.326 | 21186.7 |
5350 | 2024-01-26 14:15:35 | pizzazz | 2 | 107671 | 10 | 3.156 | 34116.3 |
5349 | 2024-01-26 13:10:41 | pizzazz | 1 | 69583 | 4 | 1.296 | 53690.6 |
5348 | 2024-01-26 04:04:48 | pizzazz | 1 | 69583 | 4 | 1.186 | 58670.3 |
5347 | 2024-01-26 01:19:53 | pizzazz | 2 | 107671 | 10 | 3.216 | 33479.8 |
5346 | 2024-01-26 01:19:49 | pizzazz | 3 | 134027 | 19 | 6.280 | 21341.9 |
5345 | 2024-01-25 23:43:50 | pizzazz | 2 | 107671 | 10 | 10.906 | 9872.6 |
5344 | 2024-01-25 23:42:55 | pizzazz | 3 | 134027 | 19 | 13.970 | 9593.9 |
5343 | 2024-01-25 23:40:55 | pizzazz | 4 | 151207 | 185 | 11.326 | 13350.4 |
5342 | 2024-01-24 01:06:18 | pizzazz | 4 | 151207 | 185 | 9.203 | 16430.2 |
5341 | 2024-01-24 01:06:11 | pizzazz | 3 | 134027 | 19 | 6.346 | 21119.9 |
5340 | 2024-01-24 01:06:08 | pizzazz | 2 | 107671 | 10 | 3.093 | 34811.2 |
5339 | 2024-01-24 00:03:07 | pizzazz | 1 | 69583 | 4 | 1.156 | 60192.9 |
5338 | 2024-01-15 11:57:26 | pizzazz | 1 | 69583 | 4 | 2.500 | 27833.2 |
5337 | 2024-01-07 17:17:35 | pizzazz | 1 | 69583 | 4 | 1.063 | 65459.1 |
5336 | 2024-01-02 03:25:40 | pizzazz | 2 | 107671 | 10 | 2.860 | 37647.2 |
5335 | 2023-12-29 05:20:15 | pizzazz | 4 | 151207 | 185 | 10.610 | 14251.4 |
5334 | 2023-12-29 05:20:09 | pizzazz | 3 | 134027 | 19 | 5.876 | 22809.2 |
5333 | 2023-12-29 05:20:05 | pizzazz | 2 | 107671 | 10 | 3.390 | 31761.4 |
5332 | 2023-12-29 04:24:43 | pizzazz | 1 | 69583 | 4 | 1.060 | 65644.3 |
5331 | 2023-12-25 18:39:31 | pizzazz | 3 | 134027 | 19 | 5.906 | 22693.4 |
5330 | 2023-12-15 10:53:20 | pizzazz | 1 | 69583 | 4 | 1.343 | 51811.6 |
5329 | 2023-12-15 10:48:53 | pizzazz | 4 | 151207 | 185 | 13.656 | 11072.6 |
5328 | 2023-12-15 10:48:45 | pizzazz | 3 | 134027 | 19 | 7.970 | 16816.4 |
5327 | 2023-12-15 10:48:41 | pizzazz | 2 | 107671 | 10 | 3.593 | 29966.9 |
5326 | 2023-12-15 09:46:51 | pizzazz | 1 | 69583 | 4 | 1.076 | 64668.2 |
5325 | 2023-12-10 22:58:29 | pizzazz | 1 | 69583 | 4 | 1.106 | 62914.1 |
5324 | 2023-12-10 21:30:02 | pizzazz | 4 | 151207 | 185 | 11.906 | 12700.1 |
5323 | 2023-12-09 06:58:54 | pizzazz | 1 | 69583 | 4 | 1.063 | 65459.1 |
5322 | 2023-12-05 18:44:48 | pizzazz | 1 | 69583 | 4 | 1.236 | 56296.9 |
5321 | 2023-12-02 16:25:06 | pizzazz | 1 | 69583 | 4 | 1.140 | 61037.7 |
5320 | 2023-11-30 04:18:37 | pizzazz | 1 | 69583 | 4 | 1.093 | 63662.4 |
5319 | 2023-11-26 17:12:52 | pizzazz | 1 | 69583 | 4 | 1.093 | 63662.4 |
5318 | 2023-11-16 01:24:03 | pizzazz | 1 | 69583 | 4 | 1.153 | 60349.5 |
5317 | 2023-11-08 11:37:24 | pizzazz | 2 | 107671 | 10 | 2.750 | 39153.1 |
5316 | 2023-11-08 11:36:49 | pizzazz | 3 | 134027 | 19 | 6.250 | 21444.3 |
5315 | 2023-11-08 11:36:04 | pizzazz | 4 | 151207 | 185 | 11.800 | 12814.2 |
5314 | 2023-11-08 11:35:53 | pizzazz | 4 | 151207 | 185 | 12.953 | 11673.5 |
5313 | 2023-11-08 10:03:47 | pizzazz | 1 | 69583 | 4 | 1.063 | 65459.1 |
5312 | 2023-11-08 08:13:48 | pizzazz | 1 | 69583 | 4 | 1.143 | 60877.5 |
5311 | 2023-11-08 03:05:21 | pizzazz | 4 | 151207 | 185 | 9.470 | 15966.9 |
5310 | 2023-11-08 03:05:15 | pizzazz | 3 | 134027 | 19 | 5.500 | 24368.5 |
5309 | 2023-11-08 03:05:12 | pizzazz | 2 | 107671 | 10 | 2.750 | 39153.1 |
5308 | 2023-11-08 02:04:35 | pizzazz | 1 | 69583 | 4 | 1.110 | 62687.4 |