History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prompters"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 206 | 2024-04-17 21:11:03 | prompters | 3 | 148641 | 142 | 13.720 | 10833.9 |
| 205 | 2024-04-17 13:54:54 | prompters | 3 | 148641 | 142 | 18.016 | 8250.5 |
| 204 | 2024-04-15 23:40:08 | prompters | 3 | 148641 | 142 | 30.753 | 4833.4 |
| 203 | 2024-04-15 23:40:04 | prompters | 2 | 121436 | 16 | 13.813 | 8791.4 |
| 202 | 2024-04-15 22:09:55 | prompters | 1 | 81242 | 3 | 3.093 | 26266.4 |
| 201 | 2024-03-31 17:40:49 | prompters | 1 | 81242 | 3 | 4.813 | 16879.7 |
| 200 | 2024-03-31 10:48:10 | prompters | 3 | 148641 | 142 | 11.126 | 13359.8 |
| 199 | 2024-03-31 06:30:41 | prompters | 3 | 148641 | 142 | 16.906 | 8792.2 |
| 198 | 2024-03-31 06:30:40 | prompters | 2 | 121436 | 16 | 6.843 | 17746.0 |
| 197 | 2024-03-29 21:17:19 | prompters | 1 | 81242 | 3 | 4.690 | 17322.4 |
| 196 | 2024-03-29 20:49:12 | prompters | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 195 | 2024-03-28 16:24:37 | prompters | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 194 | 2024-03-20 18:09:08 | prompters | 1 | 81242 | 3 | 2.220 | 36595.5 |
| 193 | 2024-03-11 06:04:01 | prompters | 3 | 148641 | 142 | 31.660 | 4694.9 |
| 192 | 2024-03-11 06:04:01 | prompters | 2 | 121436 | 16 | 17.610 | 6895.9 |
| 191 | 2024-03-11 02:48:04 | prompters | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 190 | 2024-02-28 11:47:12 | prompters | 1 | 81242 | 3 | 1.800 | 45134.4 |
| 189 | 2024-02-27 13:51:33 | prompters | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 188 | 2024-02-01 07:46:05 | prompters | 2 | 121436 | 16 | 4.923 | 24667.1 |
| 187 | 2024-01-29 08:57:14 | prompters | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 186 | 2024-01-28 08:57:43 | prompters | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 185 | 2023-12-25 21:02:12 | prompters | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 184 | 2023-12-18 05:57:14 | prompters | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 183 | 2023-12-07 04:46:03 | prompters | 2 | 121436 | 16 | 3.453 | 35168.3 |
| 182 | 2023-12-03 05:24:02 | prompters | 3 | 148641 | 142 | 6.216 | 23912.6 |
| 181 | 2023-12-03 05:23:59 | prompters | 2 | 121436 | 16 | 3.186 | 38115.5 |
| 180 | 2023-11-15 19:46:45 | prompters | 1 | 81242 | 3 | 1.766 | 46003.4 |
| 179 | 2023-11-10 23:48:29 | prompters | 2 | 121436 | 16 | 3.110 | 39046.9 |
| 178 | 2023-11-10 05:04:43 | prompters | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 177 | 2023-11-07 18:59:10 | prompters | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 176 | 2023-10-24 22:55:45 | prompters | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 175 | 2023-10-11 10:48:51 | prompters | 1 | 81242 | 3 | 1.300 | 62493.8 |
| 174 | 2023-10-05 07:28:41 | prompters | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 173 | 2023-09-11 03:01:14 | prompters | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 172 | 2023-08-15 00:54:42 | prompters | 2 | 121436 | 16 | 3.140 | 38673.9 |
| 171 | 2023-08-01 07:23:34 | prompters | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 170 | 2023-07-17 21:17:45 | prompters | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 169 | 2023-07-16 13:47:43 | prompters | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 168 | 2023-04-29 19:51:45 | prompters | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 167 | 2023-04-28 03:39:08 | prompters | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 166 | 2023-04-27 10:08:34 | prompters | 2 | 121436 | 16 | 3.110 | 39046.9 |
| 165 | 2023-04-05 03:22:39 | prompters | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 164 | 2023-03-19 20:05:36 | prompters | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 163 | 2023-02-19 14:19:55 | prompters | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 162 | 2023-01-31 05:32:07 | prompters | 2 | 121436 | 16 | 3.313 | 36654.4 |
| 161 | 2022-12-23 11:47:40 | prompters | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 160 | 2022-12-19 21:00:20 | prompters | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 159 | 2022-12-17 21:32:48 | prompters | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 158 | 2022-11-11 10:25:33 | prompters | 2 | 121436 | 16 | 3.470 | 34996.0 |
| 157 | 2022-08-27 01:48:38 | prompters | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 156 | 2022-08-24 17:53:55 | prompters | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 155 | 2022-08-19 17:59:54 | prompters | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 154 | 2022-07-19 02:27:05 | prompters | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 153 | 2022-05-17 09:55:38 | prompters | 2 | 121436 | 16 | 3.906 | 31089.6 |
| 152 | 2022-04-15 19:29:03 | prompters | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 151 | 2022-04-08 05:19:53 | prompters | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 150 | 2022-04-06 03:00:11 | prompters | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 149 | 2022-01-20 13:25:17 | prompters | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 148 | 2022-01-06 11:08:48 | prompters | 1 | 81242 | 3 | 1.440 | 56418.1 |
| 147 | 2021-09-30 07:16:51 | prompters | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 146 | 2021-06-30 21:48:49 | prompters | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 145 | 2021-04-12 12:57:14 | prompters | 3 | 148641 | 142 | 10.093 | 14727.1 |
| 144 | 2021-03-30 20:44:34 | prompters | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 143 | 2021-02-23 18:05:11 | prompters | 2 | 121436 | 16 | 3.186 | 38115.5 |
| 142 | 2021-02-19 09:07:14 | prompters | 3 | 148641 | 142 | 6.296 | 23608.8 |
| 141 | 2020-12-26 11:30:02 | prompters | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 140 | 2020-11-12 17:03:30 | prompters | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 139 | 2020-10-31 20:22:23 | prompters | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 138 | 2020-10-05 08:14:37 | prompters | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 137 | 2020-09-22 18:07:48 | prompters | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 136 | 2020-08-09 09:21:27 | prompters | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 135 | 2020-08-03 13:12:41 | prompters | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 134 | 2020-07-29 20:05:10 | prompters | 1 | 81242 | 3 | 1.403 | 57905.9 |
| 133 | 2020-06-21 01:37:27 | prompters | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 132 | 2020-06-17 21:46:18 | prompters | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 131 | 2020-06-14 13:19:27 | prompters | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 130 | 2020-06-13 12:34:48 | prompters | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 129 | 2020-06-12 13:32:19 | prompters | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 128 | 2020-03-28 17:44:20 | prompters | 1 | 81242 | 3 | 1.593 | 50999.4 |
| 127 | 2020-03-27 01:19:03 | prompters | 1 | 81242 | 3 | 1.450 | 56029.0 |
| 126 | 2020-03-23 03:23:31 | prompters | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 125 | 2020-03-20 08:13:15 | prompters | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 124 | 2020-03-07 07:07:32 | prompters | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 123 | 2020-02-28 22:24:45 | prompters | 1 | 81242 | 3 | 1.703 | 47705.2 |
| 122 | 2020-02-20 16:30:27 | prompters | 1 | 81242 | 3 | 2.110 | 38503.3 |
| 121 | 2020-02-19 09:21:45 | prompters | 1 | 81242 | 3 | 2.296 | 35384.1 |
| 120 | 2020-02-11 13:52:48 | prompters | 1 | 81242 | 3 | 1.596 | 50903.5 |
| 119 | 2020-02-04 06:32:04 | prompters | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 118 | 2020-02-03 15:17:21 | prompters | 1 | 81242 | 3 | 2.406 | 33766.4 |
| 117 | 2020-02-03 03:51:34 | prompters | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 116 | 2020-01-29 00:23:38 | prompters | 1 | 81242 | 3 | 3.233 | 25129.0 |
| 115 | 2020-01-28 19:35:07 | prompters | 1 | 81242 | 3 | 2.313 | 35124.1 |
| 114 | 2020-01-21 21:45:19 | prompters | 1 | 81242 | 3 | 1.656 | 49059.2 |
| 113 | 2020-01-16 07:26:15 | prompters | 1 | 81242 | 3 | 4.813 | 16879.7 |
| 112 | 2020-01-11 20:23:38 | prompters | 1 | 81242 | 3 | 3.203 | 25364.3 |
| 111 | 2020-01-03 06:54:27 | prompters | 1 | 81242 | 3 | 1.703 | 47705.2 |
| 110 | 2019-12-30 23:32:14 | prompters | 1 | 81242 | 3 | 1.533 | 52995.4 |
| 109 | 2019-12-30 17:37:33 | prompters | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 108 | 2019-12-04 08:17:53 | prompters | 1 | 81242 | 3 | 1.310 | 62016.8 |
| 107 | 2019-09-05 04:49:30 | prompters | 1 | 81242 | 3 | 1.203 | 67532.8 |