History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rob"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2268 | 2025-06-04 16:00:20 | rob | 1 | 5146 | 25 | 0.593 | 8677.9 |
2267 | 2025-06-01 15:37:03 | rob | 2 | 14084 | 423 | 1.906 | 7389.3 |
2266 | 2025-05-31 22:53:48 | rob | 2 | 14084 | 423 | 1.096 | 12850.4 |
2265 | 2025-05-30 12:48:37 | rob | 2 | 14084 | 423 | 1.703 | 8270.1 |
2264 | 2025-05-30 09:27:01 | rob | 1 | 5146 | 25 | 0.186 | 27666.7 |
2263 | 2025-05-29 15:41:03 | rob | 1 | 5146 | 25 | 0.263 | 19566.5 |
2262 | 2025-05-29 12:06:12 | rob | 1 | 5146 | 25 | 0.186 | 27666.7 |
2261 | 2025-05-29 04:33:02 | rob | 1 | 5146 | 25 | 0.190 | 27084.2 |
2260 | 2025-05-29 01:13:27 | rob | 1 | 5146 | 25 | 0.500 | 10292.0 |
2259 | 2025-05-28 19:32:44 | rob | 2 | 14084 | 423 | 0.530 | 26573.6 |
2258 | 2025-05-28 17:41:56 | rob | 1 | 5146 | 25 | 0.090 | 57177.8 |
2257 | 2025-05-25 08:07:57 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2256 | 2025-05-22 02:41:53 | rob | 2 | 14084 | 423 | 2.686 | 5243.5 |
2255 | 2025-05-16 09:53:09 | rob | 1 | 5146 | 25 | 0.720 | 7147.2 |
2254 | 2025-05-11 22:27:01 | rob | 1 | 5146 | 25 | 0.236 | 21805.1 |
2253 | 2025-05-09 03:34:26 | rob | 1 | 5146 | 25 | 0.170 | 30270.6 |
2252 | 2025-05-06 14:43:51 | rob | 1 | 5146 | 25 | 0.406 | 12674.9 |
2251 | 2025-05-06 12:14:48 | rob | 2 | 14084 | 423 | 1.126 | 12508.0 |
2250 | 2025-05-02 16:02:18 | rob | 1 | 5146 | 25 | 0.203 | 25349.8 |
2249 | 2025-04-30 11:34:32 | rob | 1 | 5146 | 25 | 0.110 | 46781.8 |
2248 | 2025-04-29 22:45:34 | rob | 2 | 14084 | 423 | 0.873 | 16132.9 |
2247 | 2025-04-29 13:27:44 | rob | 1 | 5146 | 25 | 0.090 | 57177.8 |
2246 | 2025-04-28 18:32:33 | rob | 2 | 14084 | 423 | 0.420 | 33533.3 |
2245 | 2025-04-28 12:50:11 | rob | 2 | 14084 | 423 | 0.703 | 20034.1 |
2244 | 2025-04-28 02:05:01 | rob | 1 | 5146 | 25 | 0.216 | 23824.1 |
2243 | 2025-04-27 10:09:43 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2242 | 2025-04-26 12:24:52 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2241 | 2025-04-25 20:30:19 | rob | 2 | 14084 | 423 | 2.846 | 4948.7 |
2240 | 2025-04-18 15:23:56 | rob | 2 | 14084 | 423 | 2.123 | 6634.0 |
2239 | 2025-04-17 19:47:12 | rob | 2 | 14084 | 423 | 1.360 | 10355.9 |
2238 | 2025-04-17 00:14:41 | rob | 2 | 14084 | 423 | 0.390 | 36112.8 |
2237 | 2025-04-14 09:22:01 | rob | 1 | 5146 | 25 | 0.683 | 7534.4 |
2236 | 2025-04-06 05:06:10 | rob | 1 | 5146 | 25 | 0.456 | 11285.1 |
2235 | 2025-04-03 15:49:14 | rob | 1 | 5146 | 25 | 0.190 | 27084.2 |
2234 | 2025-03-28 14:54:20 | rob | 2 | 14084 | 423 | 1.200 | 11736.7 |
2233 | 2025-03-26 14:08:47 | rob | 1 | 5146 | 25 | 0.110 | 46781.8 |
2232 | 2025-03-14 19:40:58 | rob | 1 | 5146 | 25 | 0.610 | 8436.1 |
2231 | 2025-03-06 18:59:35 | rob | 2 | 14084 | 423 | 1.140 | 12354.4 |
2230 | 2025-03-06 17:42:03 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2229 | 2025-03-05 03:37:33 | rob | 1 | 5146 | 25 | 0.516 | 9972.9 |
2228 | 2025-03-04 09:12:24 | rob | 1 | 5146 | 25 | 0.296 | 17385.1 |
2227 | 2025-03-02 10:54:19 | rob | 2 | 14084 | 423 | 1.780 | 7912.4 |
2226 | 2025-02-27 15:12:23 | rob | 2 | 14084 | 423 | 3.220 | 4373.9 |
2225 | 2025-02-26 05:17:54 | rob | 1 | 5146 | 25 | 0.190 | 27084.2 |
2224 | 2025-02-24 11:41:25 | rob | 1 | 5146 | 25 | 0.110 | 46781.8 |
2223 | 2025-02-23 10:51:24 | rob | 2 | 14084 | 423 | 1.110 | 12688.3 |
2222 | 2025-02-23 10:40:47 | rob | 2 | 14084 | 423 | 0.856 | 16453.3 |
2221 | 2025-02-23 03:00:22 | rob | 1 | 5146 | 25 | 0.186 | 27666.7 |
2220 | 2025-02-22 19:55:10 | rob | 2 | 14084 | 423 | 1.263 | 11151.2 |
2219 | 2025-02-20 09:58:13 | rob | 2 | 14084 | 423 | 1.670 | 8433.5 |
2218 | 2025-02-16 11:51:19 | rob | 1 | 5146 | 25 | 0.466 | 11042.9 |
2217 | 2025-02-04 15:11:18 | rob | 1 | 5146 | 25 | 0.403 | 12769.2 |
2216 | 2025-02-01 18:40:46 | rob | 1 | 5146 | 25 | 0.186 | 27666.7 |
2215 | 2025-01-25 07:03:19 | rob | 1 | 5146 | 25 | 0.110 | 46781.8 |
2214 | 2025-01-24 02:36:46 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2213 | 2025-01-19 05:26:17 | rob | 2 | 14084 | 423 | 3.190 | 4415.0 |
2212 | 2025-01-18 05:25:57 | rob | 1 | 5146 | 25 | 0.203 | 25349.8 |
2211 | 2025-01-17 11:30:39 | rob | 2 | 14084 | 423 | 2.406 | 5853.7 |
2210 | 2025-01-05 14:37:39 | rob | 2 | 14084 | 423 | 1.156 | 12183.4 |
2209 | 2025-01-05 14:29:20 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2208 | 2025-01-02 14:36:13 | rob | 1 | 5146 | 25 | 0.203 | 25349.8 |
2207 | 2024-12-28 00:15:01 | rob | 1 | 5146 | 25 | 0.610 | 8436.1 |
2206 | 2024-12-26 01:57:27 | rob | 2 | 14084 | 423 | 1.766 | 7975.1 |
2205 | 2024-12-26 01:48:53 | rob | 1 | 5146 | 25 | 0.516 | 9972.9 |
2204 | 2024-12-25 01:23:43 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2203 | 2024-12-18 04:06:39 | rob | 2 | 14084 | 423 | 2.640 | 5334.8 |
2202 | 2024-12-06 09:25:32 | rob | 1 | 5146 | 25 | 0.110 | 46781.8 |
2201 | 2024-12-03 04:33:18 | rob | 1 | 5146 | 25 | 0.203 | 25349.8 |
2200 | 2024-11-25 23:42:50 | rob | 1 | 5146 | 25 | 0.516 | 9972.9 |
2199 | 2024-11-25 08:36:49 | rob | 2 | 14084 | 423 | 0.860 | 16376.7 |
2198 | 2024-11-24 22:23:28 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2197 | 2024-11-19 06:24:12 | rob | 2 | 14084 | 423 | 1.890 | 7451.9 |
2196 | 2024-11-18 01:04:13 | rob | 2 | 14084 | 423 | 2.923 | 4818.3 |
2195 | 2024-11-06 09:34:50 | rob | 2 | 14084 | 423 | 0.390 | 36112.8 |
2194 | 2024-11-06 07:37:34 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2193 | 2024-11-02 11:29:11 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2192 | 2024-11-02 01:04:43 | rob | 1 | 5146 | 25 | 0.296 | 17385.1 |
2191 | 2024-10-26 23:31:33 | rob | 1 | 5146 | 25 | 0.203 | 25349.8 |
2190 | 2024-10-25 22:25:42 | rob | 1 | 5146 | 25 | 0.610 | 8436.1 |
2189 | 2024-10-21 01:28:02 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2188 | 2024-10-18 09:24:46 | rob | 2 | 14084 | 423 | 2.140 | 6581.3 |
2187 | 2024-10-13 08:12:37 | rob | 1 | 5146 | 25 | 0.236 | 21805.1 |
2186 | 2024-10-07 05:45:29 | rob | 2 | 14084 | 423 | 5.060 | 2783.4 |
2185 | 2024-10-07 05:04:51 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2184 | 2024-10-03 08:37:30 | rob | 1 | 5146 | 25 | 0.716 | 7187.2 |
2183 | 2024-10-03 07:30:00 | rob | 1 | 5146 | 25 | 1.233 | 4173.6 |
2182 | 2024-09-26 19:32:59 | rob | 2 | 14084 | 423 | 2.550 | 5523.1 |
2181 | 2024-09-26 19:24:19 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2180 | 2024-09-25 17:17:37 | rob | 1 | 5146 | 25 | 0.110 | 46781.8 |
2179 | 2024-09-13 20:24:10 | rob | 1 | 5146 | 25 | 1.283 | 4010.9 |
2178 | 2024-09-08 06:36:46 | rob | 2 | 14084 | 423 | 2.953 | 4769.4 |
2177 | 2024-09-07 04:27:28 | rob | 2 | 14084 | 423 | 3.690 | 3816.8 |
2176 | 2024-09-07 03:52:14 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2175 | 2024-09-04 17:41:39 | rob | 2 | 14084 | 423 | 1.610 | 8747.8 |
2174 | 2024-09-02 19:54:30 | rob | 1 | 5146 | 25 | 0.623 | 8260.0 |
2173 | 2024-08-30 09:43:31 | rob | 1 | 5146 | 25 | 0.186 | 27666.7 |
2172 | 2024-08-27 18:22:04 | rob | 1 | 5146 | 25 | 0.080 | 64325.0 |
2171 | 2024-08-27 05:37:31 | rob | 2 | 14084 | 423 | 2.906 | 4846.5 |
2170 | 2024-08-26 16:15:00 | rob | 2 | 14084 | 423 | 1.610 | 8747.8 |
2169 | 2024-08-26 16:14:55 | rob | 1 | 5146 | 25 | 0.813 | 6329.6 |