History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pam"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2243 | 2024-04-17 19:08:46 | pam | 2 | 14084 | 516 | 2.030 | 6937.9 |
2242 | 2024-04-17 09:30:31 | pam | 2 | 14084 | 516 | 1.063 | 13249.3 |
2241 | 2024-04-12 21:12:24 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2240 | 2024-04-11 14:21:00 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2239 | 2024-04-11 14:15:50 | pam | 1 | 5146 | 31 | 0.203 | 25349.8 |
2238 | 2024-04-09 00:36:52 | pam | 1 | 5146 | 31 | 0.140 | 36757.1 |
2237 | 2024-04-07 16:15:16 | pam | 2 | 14084 | 516 | 0.750 | 18778.7 |
2236 | 2024-04-07 02:44:41 | pam | 2 | 14084 | 516 | 0.423 | 33295.5 |
2235 | 2024-04-07 02:06:58 | pam | 1 | 5146 | 31 | 0.280 | 18378.6 |
2234 | 2024-04-06 01:52:29 | pam | 2 | 14084 | 516 | 0.703 | 20034.1 |
2233 | 2024-04-04 19:20:45 | pam | 2 | 14084 | 516 | 0.466 | 30223.2 |
2232 | 2024-04-04 03:11:05 | pam | 2 | 14084 | 516 | 0.466 | 30223.2 |
2231 | 2024-04-03 12:57:42 | pam | 2 | 14084 | 516 | 0.936 | 15047.0 |
2230 | 2024-04-02 18:01:52 | pam | 1 | 5146 | 31 | 0.346 | 14872.8 |
2229 | 2024-04-02 13:52:39 | pam | 2 | 14084 | 516 | 0.513 | 27454.2 |
2228 | 2024-04-01 19:30:11 | pam | 2 | 14084 | 516 | 0.453 | 31090.5 |
2227 | 2024-04-01 04:49:38 | pam | 1 | 5146 | 31 | 0.313 | 16440.9 |
2226 | 2024-04-01 04:49:12 | pam | 2 | 14084 | 516 | 1.330 | 10589.5 |
2225 | 2024-03-31 16:21:38 | pam | 2 | 14084 | 516 | 0.486 | 28979.4 |
2224 | 2024-03-31 04:54:00 | pam | 2 | 14084 | 516 | 1.373 | 10257.8 |
2223 | 2024-03-30 23:10:55 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2222 | 2024-03-26 18:34:51 | pam | 1 | 5146 | 31 | 0.110 | 46781.8 |
2221 | 2024-03-12 19:48:53 | pam | 2 | 14084 | 516 | 0.483 | 29159.4 |
2220 | 2024-03-11 03:11:42 | pam | 2 | 14084 | 516 | 0.393 | 35837.2 |
2219 | 2024-03-05 13:39:18 | pam | 1 | 5146 | 31 | 0.106 | 48547.2 |
2218 | 2024-03-02 16:07:11 | pam | 1 | 5146 | 31 | 0.203 | 25349.8 |
2217 | 2024-02-29 17:17:46 | pam | 1 | 5146 | 31 | 0.203 | 25349.8 |
2216 | 2024-02-28 10:31:08 | pam | 1 | 5146 | 31 | 0.516 | 9972.9 |
2215 | 2024-02-25 15:30:51 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2214 | 2024-02-11 10:32:35 | pam | 2 | 14084 | 516 | 1.000 | 14084.0 |
2213 | 2024-02-04 14:32:34 | pam | 2 | 14084 | 516 | 0.843 | 16707.0 |
2212 | 2024-02-04 14:30:08 | pam | 2 | 14084 | 516 | 0.860 | 16376.7 |
2211 | 2024-02-01 10:07:55 | pam | 1 | 5146 | 31 | 0.173 | 29745.7 |
2210 | 2024-01-27 18:42:15 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2209 | 2024-01-26 10:57:31 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2208 | 2024-01-24 17:35:35 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2207 | 2024-01-24 15:22:21 | pam | 2 | 14084 | 516 | 0.326 | 43202.5 |
2206 | 2024-01-23 23:24:33 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2205 | 2024-01-20 15:46:19 | pam | 2 | 14084 | 516 | 0.373 | 37758.7 |
2204 | 2024-01-13 03:32:45 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2203 | 2024-01-06 23:34:19 | pam | 1 | 5146 | 31 | 0.080 | 64325.0 |
2202 | 2024-01-02 11:09:14 | pam | 2 | 14084 | 516 | 0.326 | 43202.5 |
2201 | 2023-12-07 17:55:52 | pam | 1 | 5146 | 31 | 0.080 | 64325.0 |
2200 | 2023-12-07 17:55:52 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2199 | 2023-11-30 10:43:27 | pam | 2 | 14084 | 516 | 0.766 | 18386.4 |
2198 | 2023-11-21 22:22:52 | pam | 2 | 14084 | 516 | 0.390 | 36112.8 |
2197 | 2023-11-21 01:09:16 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2196 | 2023-11-20 23:45:15 | pam | 2 | 14084 | 516 | 0.343 | 41061.2 |
2195 | 2023-11-20 00:13:19 | pam | 2 | 14084 | 516 | 0.326 | 43202.5 |
2194 | 2023-11-18 18:54:58 | pam | 2 | 14084 | 516 | 0.376 | 37457.4 |
2193 | 2023-11-18 02:25:39 | pam | 2 | 14084 | 516 | 0.346 | 40705.2 |
2192 | 2023-11-17 13:26:36 | pam | 2 | 14084 | 516 | 0.343 | 41061.2 |
2191 | 2023-11-16 17:32:00 | pam | 2 | 14084 | 516 | 0.326 | 43202.5 |
2190 | 2023-11-15 14:11:19 | pam | 2 | 14084 | 516 | 0.343 | 41061.2 |
2189 | 2023-11-14 18:58:11 | pam | 2 | 14084 | 516 | 0.376 | 37457.4 |
2188 | 2023-11-13 20:28:50 | pam | 2 | 14084 | 516 | 0.436 | 32302.8 |
2187 | 2023-11-12 04:53:21 | pam | 2 | 14084 | 516 | 0.326 | 43202.5 |
2186 | 2023-11-09 00:15:07 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2185 | 2023-11-07 13:55:33 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2184 | 2023-10-31 23:09:58 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2183 | 2023-10-28 23:28:24 | pam | 2 | 14084 | 516 | 0.500 | 28168.0 |
2182 | 2023-10-26 04:07:13 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2181 | 2023-10-26 03:28:07 | pam | 2 | 14084 | 516 | 0.330 | 42678.8 |
2180 | 2023-10-25 07:29:52 | pam | 2 | 14084 | 516 | 0.420 | 33533.3 |
2179 | 2023-10-25 03:10:53 | pam | 2 | 14084 | 516 | 0.750 | 18778.7 |
2178 | 2023-10-24 12:55:01 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2177 | 2023-10-20 12:56:28 | pam | 2 | 14084 | 516 | 0.436 | 32302.8 |
2176 | 2023-10-19 18:51:00 | pam | 1 | 5146 | 31 | 0.080 | 64325.0 |
2175 | 2023-10-17 00:50:43 | pam | 2 | 14084 | 516 | 0.406 | 34689.7 |
2174 | 2023-10-16 22:00:11 | pam | 1 | 5146 | 31 | 0.096 | 53604.2 |
2173 | 2023-10-10 22:30:13 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2172 | 2023-10-07 10:07:21 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2171 | 2023-10-04 13:04:13 | pam | 2 | 14084 | 516 | 0.373 | 37758.7 |
2170 | 2023-10-03 09:03:40 | pam | 1 | 5146 | 31 | 0.080 | 64325.0 |
2169 | 2023-09-29 05:28:10 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2168 | 2023-09-25 11:27:32 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2167 | 2023-09-22 12:40:49 | pam | 2 | 14084 | 516 | 0.346 | 40705.2 |
2166 | 2023-09-19 13:01:57 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2165 | 2023-09-18 20:45:19 | pam | 2 | 14084 | 516 | 0.326 | 43202.5 |
2164 | 2023-09-15 16:36:06 | pam | 2 | 14084 | 516 | 0.326 | 43202.5 |
2163 | 2023-09-10 15:30:44 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2162 | 2023-09-07 18:45:23 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2161 | 2023-08-15 16:16:47 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2160 | 2023-07-16 19:16:30 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2159 | 2023-07-11 08:13:01 | pam | 2 | 14084 | 516 | 0.340 | 41423.5 |
2158 | 2023-07-01 01:42:24 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2157 | 2023-06-25 23:44:44 | pam | 1 | 5146 | 31 | 0.096 | 53604.2 |
2156 | 2023-06-09 11:01:21 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2155 | 2023-04-13 19:36:41 | pam | 2 | 14084 | 516 | 0.373 | 37758.7 |
2154 | 2023-04-08 09:41:05 | pam | 2 | 14084 | 516 | 0.373 | 37758.7 |
2153 | 2023-03-31 15:09:01 | pam | 2 | 14084 | 516 | 0.373 | 37758.7 |
2152 | 2023-03-28 14:58:41 | pam | 1 | 5146 | 31 | 0.156 | 32987.2 |
2151 | 2023-03-28 08:23:44 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2150 | 2023-03-26 23:11:51 | pam | 1 | 5146 | 31 | 0.076 | 67710.5 |
2149 | 2023-02-20 08:23:14 | pam | 2 | 14084 | 516 | 0.393 | 35837.2 |
2148 | 2023-01-18 16:31:00 | pam | 2 | 14084 | 516 | 0.326 | 43202.5 |
2147 | 2023-01-11 15:23:51 | pam | 1 | 5146 | 31 | 0.080 | 64325.0 |
2146 | 2022-12-31 10:37:12 | pam | 2 | 14084 | 516 | 0.376 | 37457.4 |
2145 | 2022-12-23 03:59:17 | pam | 1 | 5146 | 31 | 0.093 | 55333.3 |
2144 | 2022-12-22 23:34:29 | pam | 2 | 14084 | 516 | 0.373 | 37758.7 |