History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"campaigns"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 178 | 2024-04-19 11:47:25 | campaigns | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 177 | 2024-04-13 13:20:32 | campaigns | 1 | 81242 | 3 | 1.513 | 53696.0 |
| 176 | 2024-04-11 02:35:51 | campaigns | 1 | 81242 | 3 | 2.813 | 28880.9 |
| 175 | 2024-04-10 07:03:19 | campaigns | 1 | 81242 | 3 | 1.780 | 45641.6 |
| 174 | 2024-04-07 15:44:08 | campaigns | 4 | 165329 | 367 | 35.880 | 4607.8 |
| 173 | 2024-04-07 12:44:50 | campaigns | 4 | 165329 | 367 | 31.673 | 5219.9 |
| 172 | 2024-04-06 08:27:47 | campaigns | 4 | 165329 | 367 | 27.033 | 6115.8 |
| 171 | 2024-04-06 07:09:36 | campaigns | 1 | 81242 | 3 | 1.610 | 50460.9 |
| 170 | 2024-03-23 20:42:57 | campaigns | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 169 | 2024-03-20 20:21:29 | campaigns | 3 | 148641 | 47 | 18.503 | 8033.3 |
| 168 | 2024-03-20 20:21:16 | campaigns | 2 | 121436 | 12 | 4.530 | 26807.1 |
| 167 | 2024-03-20 04:14:46 | campaigns | 3 | 148641 | 47 | 17.626 | 8433.1 |
| 166 | 2024-03-20 04:14:46 | campaigns | 2 | 121436 | 12 | 6.860 | 17702.0 |
| 165 | 2024-03-20 00:36:23 | campaigns | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 164 | 2024-03-11 02:43:23 | campaigns | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 163 | 2024-03-08 01:05:49 | campaigns | 1 | 81242 | 3 | 4.936 | 16459.1 |
| 162 | 2024-03-02 04:57:51 | campaigns | 1 | 81242 | 3 | 4.893 | 16603.7 |
| 161 | 2024-02-28 23:34:02 | campaigns | 1 | 81242 | 3 | 1.610 | 50460.9 |
| 160 | 2024-02-07 12:41:02 | campaigns | 1 | 81242 | 3 | 3.080 | 26377.3 |
| 159 | 2024-02-05 13:24:22 | campaigns | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 158 | 2024-02-04 07:52:15 | campaigns | 1 | 81242 | 3 | 6.533 | 12435.6 |
| 157 | 2024-01-29 19:23:35 | campaigns | 1 | 81242 | 3 | 1.403 | 57905.9 |
| 156 | 2023-12-20 01:53:47 | campaigns | 1 | 81242 | 3 | 1.300 | 62493.8 |
| 155 | 2023-12-11 17:37:54 | campaigns | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 154 | 2023-12-03 19:52:47 | campaigns | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 153 | 2023-12-01 01:30:07 | campaigns | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 152 | 2023-11-27 10:55:14 | campaigns | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 151 | 2023-10-25 09:04:27 | campaigns | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 150 | 2023-10-17 17:53:56 | campaigns | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 149 | 2023-10-07 07:11:56 | campaigns | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 148 | 2023-08-03 08:12:15 | campaigns | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 147 | 2023-07-31 20:27:18 | campaigns | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 146 | 2023-07-24 17:27:42 | campaigns | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 145 | 2023-06-16 00:22:31 | campaigns | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 144 | 2023-04-30 02:25:22 | campaigns | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 143 | 2023-04-12 10:31:31 | campaigns | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 142 | 2023-02-22 22:29:41 | campaigns | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 141 | 2022-12-23 11:21:13 | campaigns | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 140 | 2022-12-20 06:15:28 | campaigns | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 139 | 2022-09-14 09:51:18 | campaigns | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 138 | 2022-09-03 23:38:00 | campaigns | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 137 | 2022-08-28 06:19:54 | campaigns | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 136 | 2022-08-19 17:29:22 | campaigns | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 135 | 2022-04-17 03:58:44 | campaigns | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 134 | 2022-04-15 00:47:17 | campaigns | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 133 | 2022-04-08 18:28:35 | campaigns | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 132 | 2022-01-10 17:26:09 | campaigns | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 131 | 2021-12-18 06:06:46 | campaigns | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 130 | 2021-11-08 20:13:37 | campaigns | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 129 | 2021-10-11 02:19:59 | campaigns | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 128 | 2021-09-22 17:57:11 | campaigns | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 127 | 2021-09-22 01:45:47 | campaigns | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 126 | 2021-09-21 21:07:29 | campaigns | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 125 | 2021-09-21 03:56:09 | campaigns | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 124 | 2021-09-14 22:03:57 | campaigns | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 123 | 2021-09-04 12:47:10 | campaigns | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 122 | 2021-05-31 12:18:07 | campaigns | 1 | 81242 | 3 | 1.533 | 52995.4 |
| 121 | 2021-03-01 07:23:04 | campaigns | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 120 | 2020-11-25 00:19:19 | campaigns | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 119 | 2020-11-05 00:53:50 | campaigns | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 118 | 2020-08-26 08:14:45 | campaigns | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 117 | 2020-08-22 08:15:18 | campaigns | 1 | 81242 | 3 | 1.610 | 50460.9 |
| 116 | 2020-08-16 15:57:12 | campaigns | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 115 | 2020-07-27 11:35:11 | campaigns | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 114 | 2020-05-12 10:45:13 | campaigns | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 113 | 2020-03-28 17:35:43 | campaigns | 1 | 81242 | 3 | 1.513 | 53696.0 |
| 112 | 2020-03-22 10:36:15 | campaigns | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 111 | 2020-02-28 04:49:40 | campaigns | 1 | 81242 | 3 | 1.513 | 53696.0 |
| 110 | 2020-02-09 19:27:35 | campaigns | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 109 | 2020-02-08 17:57:42 | campaigns | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 108 | 2020-02-04 17:40:10 | campaigns | 1 | 81242 | 3 | 2.453 | 33119.4 |
| 107 | 2020-02-03 02:10:29 | campaigns | 1 | 81242 | 3 | 3.343 | 24302.1 |
| 106 | 2020-01-28 00:49:52 | campaigns | 1 | 81242 | 3 | 2.453 | 33119.4 |
| 105 | 2020-01-25 12:58:16 | campaigns | 1 | 81242 | 3 | 3.063 | 26523.7 |
| 104 | 2020-01-20 18:07:37 | campaigns | 1 | 81242 | 3 | 5.093 | 15951.7 |
| 103 | 2020-01-20 17:05:28 | campaigns | 1 | 81242 | 3 | 1.860 | 43678.5 |
| 102 | 2020-01-15 15:30:37 | campaigns | 1 | 81242 | 3 | 3.093 | 26266.4 |
| 101 | 2020-01-04 12:13:14 | campaigns | 1 | 81242 | 3 | 3.250 | 24997.5 |
| 100 | 2020-01-02 06:57:43 | campaigns | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 99 | 2019-11-09 10:37:18 | campaigns | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 98 | 2019-08-26 14:11:09 | campaigns | 1 | 81242 | 3 | 1.213 | 66976.1 |
| 97 | 2019-08-22 15:32:02 | campaigns | 1 | 81242 | 3 | 1.243 | 65359.6 |
| 96 | 2019-08-20 01:27:04 | campaigns | 1 | 81242 | 3 | 1.193 | 68098.9 |
| 95 | 2019-08-17 07:44:20 | campaigns | 1 | 81242 | 3 | 1.310 | 62016.8 |
| 94 | 2019-08-12 18:21:27 | campaigns | 1 | 81242 | 3 | 1.183 | 68674.6 |
| 93 | 2019-08-08 04:57:39 | campaigns | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 92 | 2019-08-08 00:54:07 | campaigns | 1 | 81242 | 3 | 1.300 | 62493.8 |
| 91 | 2019-08-02 01:57:21 | campaigns | 1 | 81242 | 3 | 1.403 | 57905.9 |
| 90 | 2019-07-25 16:26:05 | campaigns | 1 | 81242 | 3 | 1.276 | 63669.3 |
| 89 | 2019-07-22 16:26:11 | campaigns | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 88 | 2019-07-18 04:00:06 | campaigns | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 87 | 2019-04-28 20:39:14 | campaigns | 1 | 81242 | 3 | 1.480 | 54893.2 |
| 86 | 2019-03-07 21:37:10 | campaigns | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 85 | 2019-01-24 20:03:22 | campaigns | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 84 | 2019-01-10 15:04:30 | campaigns | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 83 | 2019-01-05 13:31:04 | campaigns | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 82 | 2019-01-01 02:37:32 | campaigns | 1 | 81242 | 3 | 1.243 | 65359.6 |
| 81 | 2018-12-30 11:57:20 | campaigns | 1 | 81242 | 3 | 1.336 | 60809.9 |
| 80 | 2018-12-19 10:04:21 | campaigns | 1 | 81242 | 3 | 1.306 | 62206.7 |
| 79 | 2018-12-15 06:27:02 | campaigns | 1 | 81242 | 3 | 1.373 | 59171.2 |