History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"perspex"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 230 | 2025-11-30 07:23:48 | perspex | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 229 | 2025-11-25 11:36:00 | perspex | 1 | 69583 | 1 | 8.000 | 8697.9 |
| 228 | 2025-11-23 06:58:40 | perspex | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 227 | 2025-11-20 23:20:55 | perspex | 1 | 69583 | 1 | 2.516 | 27656.2 |
| 226 | 2025-11-17 13:47:01 | perspex | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 225 | 2025-11-11 15:05:26 | perspex | 1 | 69583 | 1 | 1.406 | 49490.0 |
| 224 | 2025-11-10 04:08:27 | perspex | 1 | 69583 | 1 | 1.263 | 55093.4 |
| 223 | 2025-11-04 11:28:26 | perspex | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 222 | 2025-10-27 18:22:31 | perspex | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 221 | 2025-10-22 18:11:57 | perspex | 1 | 69583 | 1 | 2.550 | 27287.5 |
| 220 | 2025-10-13 13:55:23 | perspex | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 219 | 2025-10-07 10:17:43 | perspex | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 218 | 2025-09-28 04:08:09 | perspex | 1 | 69583 | 1 | 1.300 | 53525.4 |
| 217 | 2025-09-25 14:20:19 | perspex | 1 | 69583 | 1 | 5.876 | 11841.9 |
| 216 | 2025-09-13 06:13:34 | perspex | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 215 | 2025-09-07 15:18:05 | perspex | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 214 | 2025-09-07 00:24:42 | perspex | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 213 | 2025-08-27 09:23:36 | perspex | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 212 | 2025-08-25 07:46:28 | perspex | 3 | 134027 | 115 | 26.016 | 5151.7 |
| 211 | 2025-08-23 21:42:59 | perspex | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 210 | 2025-08-22 23:06:05 | perspex | 1 | 69583 | 1 | 4.513 | 15418.3 |
| 209 | 2025-08-20 07:08:55 | perspex | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 208 | 2025-08-10 05:15:22 | perspex | 2 | 107671 | 5 | 6.673 | 16135.3 |
| 207 | 2025-08-09 15:22:33 | perspex | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 206 | 2025-08-05 05:48:49 | perspex | 1 | 69583 | 1 | 2.796 | 24886.6 |
| 205 | 2025-08-05 00:31:17 | perspex | 1 | 69583 | 1 | 3.140 | 22160.2 |
| 204 | 2025-08-02 23:13:16 | perspex | 2 | 107671 | 5 | 8.643 | 12457.6 |
| 203 | 2025-08-02 23:11:43 | perspex | 3 | 134027 | 115 | 22.940 | 5842.5 |
| 202 | 2025-07-31 05:50:59 | perspex | 1 | 69583 | 1 | 1.360 | 51164.0 |
| 201 | 2025-07-24 15:28:52 | perspex | 1 | 69583 | 1 | 6.470 | 10754.7 |
| 200 | 2025-07-22 07:37:02 | perspex | 1 | 69583 | 1 | 3.843 | 18106.4 |
| 199 | 2025-07-10 18:49:32 | perspex | 1 | 69583 | 1 | 6.403 | 10867.2 |
| 198 | 2025-07-10 02:02:22 | perspex | 1 | 69583 | 1 | 2.970 | 23428.6 |
| 197 | 2025-07-05 14:24:59 | perspex | 1 | 69583 | 1 | 6.410 | 10855.4 |
| 196 | 2025-06-27 10:06:51 | perspex | 1 | 69583 | 1 | 6.403 | 10867.2 |
| 195 | 2025-06-21 22:04:45 | perspex | 1 | 69583 | 1 | 3.233 | 21522.7 |
| 194 | 2025-06-20 11:56:23 | perspex | 1 | 69583 | 1 | 9.110 | 7638.1 |
| 193 | 2025-06-13 11:17:47 | perspex | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 192 | 2025-06-02 00:11:55 | perspex | 1 | 69583 | 1 | 7.500 | 9277.7 |
| 191 | 2025-06-01 23:07:53 | perspex | 1 | 69583 | 1 | 3.233 | 21522.7 |
| 190 | 2025-05-29 04:56:04 | perspex | 1 | 69583 | 1 | 4.280 | 16257.7 |
| 189 | 2025-05-28 11:40:20 | perspex | 1 | 69583 | 1 | 1.403 | 49595.9 |
| 188 | 2025-05-28 08:32:24 | perspex | 1 | 69583 | 1 | 4.360 | 15959.4 |
| 187 | 2025-05-21 22:37:29 | perspex | 1 | 69583 | 1 | 5.983 | 11630.1 |
| 186 | 2025-05-18 20:04:48 | perspex | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 185 | 2025-05-18 16:31:42 | perspex | 1 | 69583 | 1 | 3.263 | 21324.9 |
| 184 | 2025-05-03 02:52:07 | perspex | 1 | 69583 | 1 | 5.953 | 11688.7 |
| 183 | 2025-05-02 14:33:29 | perspex | 1 | 69583 | 1 | 2.656 | 26198.4 |
| 182 | 2025-05-02 03:02:51 | perspex | 1 | 69583 | 1 | 5.983 | 11630.1 |
| 181 | 2025-05-02 00:34:46 | perspex | 1 | 69583 | 1 | 4.220 | 16488.9 |
| 180 | 2025-04-27 04:42:50 | perspex | 3 | 134027 | 115 | 18.813 | 7124.2 |
| 179 | 2025-04-26 11:25:55 | perspex | 3 | 134027 | 115 | 45.566 | 2941.4 |
| 178 | 2025-04-26 11:14:02 | perspex | 2 | 107671 | 5 | 8.593 | 12530.1 |
| 177 | 2025-04-24 23:03:48 | perspex | 1 | 69583 | 1 | 3.063 | 22717.3 |
| 176 | 2025-04-20 04:50:04 | perspex | 1 | 69583 | 1 | 3.440 | 20227.6 |
| 175 | 2025-04-12 11:01:02 | perspex | 2 | 107671 | 5 | 20.610 | 5224.2 |
| 174 | 2025-03-26 15:52:49 | perspex | 1 | 69583 | 1 | 3.296 | 21111.3 |
| 173 | 2025-03-19 22:38:26 | perspex | 1 | 69583 | 1 | 4.966 | 14011.9 |
| 172 | 2025-03-14 04:30:31 | perspex | 1 | 69583 | 1 | 2.640 | 26357.2 |
| 171 | 2025-03-10 18:58:21 | perspex | 3 | 134027 | 115 | 40.796 | 3285.3 |
| 170 | 2025-03-10 12:44:56 | perspex | 3 | 134027 | 115 | 36.703 | 3651.7 |
| 169 | 2025-03-10 04:55:31 | perspex | 3 | 134027 | 115 | 78.160 | 1714.8 |
| 168 | 2025-03-10 04:55:27 | perspex | 2 | 107671 | 5 | 26.016 | 4138.6 |
| 167 | 2025-03-10 04:43:29 | perspex | 1 | 69583 | 1 | 5.440 | 12791.0 |
| 166 | 2025-03-09 06:12:03 | perspex | 1 | 69583 | 1 | 5.313 | 13096.7 |
| 165 | 2025-02-28 16:57:03 | perspex | 1 | 69583 | 1 | 7.530 | 9240.8 |
| 164 | 2025-02-25 20:20:26 | perspex | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 163 | 2025-01-27 19:05:07 | perspex | 3 | 134027 | 115 | 32.250 | 4155.9 |
| 162 | 2025-01-26 16:09:05 | perspex | 3 | 134027 | 115 | 30.593 | 4381.0 |
| 161 | 2025-01-26 01:03:56 | perspex | 3 | 134027 | 115 | 46.280 | 2896.0 |
| 160 | 2025-01-25 21:24:55 | perspex | 3 | 134027 | 115 | 6.766 | 19808.9 |
| 159 | 2025-01-24 21:03:52 | perspex | 1 | 69583 | 1 | 5.143 | 13529.7 |
| 158 | 2025-01-19 11:13:18 | perspex | 1 | 69583 | 1 | 5.076 | 13708.2 |
| 157 | 2025-01-14 04:08:49 | perspex | 1 | 69583 | 1 | 2.766 | 25156.5 |
| 156 | 2025-01-04 13:57:51 | perspex | 2 | 107671 | 5 | 2.986 | 36058.6 |
| 155 | 2024-12-28 06:05:12 | perspex | 2 | 107671 | 5 | 11.970 | 8995.1 |
| 154 | 2024-12-23 14:37:09 | perspex | 3 | 134027 | 115 | 34.423 | 3893.5 |
| 153 | 2024-12-21 08:28:14 | perspex | 3 | 134027 | 115 | 6.766 | 19808.9 |
| 152 | 2024-12-21 00:56:41 | perspex | 3 | 134027 | 115 | 49.470 | 2709.3 |
| 151 | 2024-12-21 00:02:38 | perspex | 3 | 134027 | 115 | 24.953 | 5371.2 |
| 150 | 2024-12-21 00:02:34 | perspex | 2 | 107671 | 5 | 17.500 | 6152.6 |
| 149 | 2024-12-21 00:01:25 | perspex | 1 | 69583 | 1 | 7.516 | 9258.0 |
| 148 | 2024-11-20 21:48:42 | perspex | 1 | 69583 | 1 | 5.233 | 13297.0 |
| 147 | 2024-11-16 03:11:53 | perspex | 1 | 69583 | 1 | 6.173 | 11272.2 |
| 146 | 2024-11-08 21:08:43 | perspex | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 145 | 2024-10-19 07:03:19 | perspex | 1 | 69583 | 1 | 3.093 | 22496.9 |
| 144 | 2024-10-03 00:47:08 | perspex | 1 | 69583 | 1 | 8.686 | 8010.9 |
| 143 | 2024-09-21 12:54:56 | perspex | 1 | 69583 | 1 | 6.346 | 10964.9 |
| 142 | 2024-08-29 11:01:17 | perspex | 1 | 69583 | 1 | 14.110 | 4931.5 |
| 141 | 2024-08-25 17:34:58 | perspex | 1 | 69583 | 1 | 6.360 | 10940.7 |
| 140 | 2024-08-13 17:55:31 | perspex | 1 | 69583 | 1 | 4.970 | 14000.6 |
| 139 | 2024-08-06 15:14:54 | perspex | 1 | 69583 | 1 | 1.936 | 35941.6 |
| 138 | 2024-08-06 15:14:53 | perspex | 1 | 69583 | 1 | 2.486 | 27989.9 |
| 137 | 2024-07-29 14:11:02 | perspex | 1 | 69583 | 1 | 5.736 | 12130.9 |
| 136 | 2024-07-25 19:15:36 | perspex | 1 | 69583 | 1 | 3.360 | 20709.2 |
| 135 | 2024-07-23 20:59:15 | perspex | 1 | 69583 | 1 | 3.516 | 19790.4 |
| 134 | 2024-07-20 01:36:39 | perspex | 1 | 69583 | 1 | 3.170 | 21950.5 |
| 133 | 2024-07-18 04:20:50 | perspex | 1 | 69583 | 1 | 4.953 | 14048.7 |
| 132 | 2024-07-06 13:11:16 | perspex | 1 | 69583 | 1 | 4.296 | 16197.2 |
| 131 | 2024-06-20 19:24:23 | perspex | 3 | 134027 | 115 | 23.326 | 5745.8 |