History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"col"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2121 | 2024-03-10 11:49:34 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2120 | 2024-03-04 23:52:11 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2119 | 2024-03-02 16:18:13 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2118 | 2024-03-02 13:32:03 | col | 1 | 5146 | 29 | 0.203 | 25349.8 |
2117 | 2024-02-28 11:18:36 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2116 | 2024-02-25 16:35:49 | col | 1 | 5146 | 29 | 0.186 | 27666.7 |
2115 | 2024-02-25 16:06:12 | col | 1 | 5146 | 29 | 0.170 | 30270.6 |
2114 | 2024-02-24 19:19:55 | col | 2 | 14084 | 485 | 0.436 | 32302.8 |
2113 | 2024-02-24 05:51:49 | col | 2 | 14084 | 485 | 0.373 | 37758.7 |
2112 | 2024-02-21 06:00:48 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2111 | 2024-01-28 12:03:55 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2110 | 2024-01-26 07:34:01 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2109 | 2024-01-21 23:29:53 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2108 | 2024-01-21 15:59:27 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2107 | 2024-01-18 21:28:12 | col | 2 | 14084 | 485 | 0.326 | 43202.5 |
2106 | 2024-01-01 06:22:07 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2105 | 2023-12-25 13:19:20 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2104 | 2023-12-11 18:39:22 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2103 | 2023-11-26 18:10:16 | col | 2 | 14084 | 485 | 0.330 | 42678.8 |
2102 | 2023-11-23 13:20:41 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2101 | 2023-11-16 23:24:43 | col | 2 | 14084 | 485 | 0.360 | 39122.2 |
2100 | 2023-11-11 02:14:25 | col | 2 | 14084 | 485 | 0.330 | 42678.8 |
2099 | 2023-11-09 21:31:05 | col | 2 | 14084 | 485 | 0.373 | 37758.7 |
2098 | 2023-11-08 11:58:35 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2097 | 2023-11-07 23:56:49 | col | 1 | 5146 | 29 | 0.063 | 81682.5 |
2096 | 2023-11-07 10:15:08 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2095 | 2023-11-07 10:04:59 | col | 1 | 5146 | 29 | 0.203 | 25349.8 |
2094 | 2023-11-06 15:28:43 | col | 1 | 5146 | 29 | 0.063 | 81682.5 |
2093 | 2023-11-05 16:56:08 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2092 | 2023-10-26 07:15:46 | col | 2 | 14084 | 485 | 0.813 | 17323.5 |
2091 | 2023-10-25 20:40:24 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2090 | 2023-10-25 02:37:45 | col | 2 | 14084 | 485 | 0.330 | 42678.8 |
2089 | 2023-10-20 03:10:44 | col | 2 | 14084 | 485 | 0.406 | 34689.7 |
2088 | 2023-10-19 14:28:36 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2087 | 2023-10-18 01:14:02 | col | 2 | 14084 | 485 | 0.406 | 34689.7 |
2086 | 2023-10-16 19:04:00 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2085 | 2023-10-14 03:16:26 | col | 2 | 14084 | 485 | 0.330 | 42678.8 |
2084 | 2023-10-10 11:48:45 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2083 | 2023-10-04 05:07:47 | col | 2 | 14084 | 485 | 0.376 | 37457.4 |
2082 | 2023-10-03 08:45:09 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2081 | 2023-09-26 21:43:38 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2080 | 2023-09-25 19:09:31 | col | 1 | 5146 | 29 | 0.060 | 85766.7 |
2079 | 2023-09-25 14:46:55 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2078 | 2023-09-23 11:21:39 | col | 2 | 14084 | 485 | 0.703 | 20034.1 |
2077 | 2023-09-18 22:54:08 | col | 1 | 5146 | 29 | 0.090 | 57177.8 |
2076 | 2023-09-12 05:35:59 | col | 2 | 14084 | 485 | 0.360 | 39122.2 |
2075 | 2023-09-10 12:40:35 | col | 1 | 5146 | 29 | 0.173 | 29745.7 |
2074 | 2023-08-17 23:53:10 | col | 2 | 14084 | 485 | 0.390 | 36112.8 |
2073 | 2023-07-24 10:04:37 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2072 | 2023-07-23 10:15:09 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2071 | 2023-07-16 19:51:54 | col | 1 | 5146 | 29 | 0.170 | 30270.6 |
2070 | 2023-07-08 12:12:12 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2069 | 2023-06-21 17:35:38 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2068 | 2023-04-30 16:40:39 | col | 2 | 14084 | 485 | 0.343 | 41061.2 |
2067 | 2023-04-22 13:54:39 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2066 | 2023-03-31 13:14:53 | col | 2 | 14084 | 485 | 0.390 | 36112.8 |
2065 | 2023-03-26 22:30:33 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2064 | 2023-03-19 11:39:03 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2063 | 2023-03-12 12:18:51 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2062 | 2023-02-10 23:23:40 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2061 | 2023-02-06 06:53:39 | col | 2 | 14084 | 485 | 0.326 | 43202.5 |
2060 | 2023-01-17 08:37:44 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2059 | 2022-12-14 09:57:32 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2058 | 2022-12-11 06:07:39 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2057 | 2022-12-08 06:55:25 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2056 | 2022-11-26 19:18:00 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2055 | 2022-11-24 21:01:07 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2054 | 2022-11-22 18:42:19 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2053 | 2022-11-19 21:31:24 | col | 2 | 14084 | 485 | 0.326 | 43202.5 |
2052 | 2022-09-19 12:33:30 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2051 | 2022-09-18 09:50:26 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2050 | 2022-09-12 07:29:43 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2049 | 2022-09-10 08:23:07 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2048 | 2022-09-09 09:57:27 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2047 | 2022-09-03 12:04:59 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2046 | 2022-09-01 09:07:27 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2045 | 2022-08-23 13:58:26 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2044 | 2022-08-14 22:02:02 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2043 | 2022-08-14 06:55:51 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2042 | 2022-08-10 01:04:24 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2041 | 2022-08-06 10:46:17 | col | 1 | 5146 | 29 | 0.063 | 81682.5 |
2040 | 2022-08-06 04:22:15 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2039 | 2022-08-05 23:22:33 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2038 | 2022-07-30 06:45:15 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2037 | 2022-07-28 22:15:03 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2036 | 2022-07-17 17:47:33 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2035 | 2022-07-17 16:26:03 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2034 | 2022-07-10 01:35:46 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2033 | 2022-07-09 20:38:05 | col | 1 | 5146 | 29 | 0.156 | 32987.2 |
2032 | 2022-07-03 13:02:45 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2031 | 2022-07-02 13:52:05 | col | 1 | 5146 | 29 | 0.096 | 53604.2 |
2030 | 2022-06-26 00:02:03 | col | 1 | 5146 | 29 | 0.200 | 25730.0 |
2029 | 2022-06-24 18:57:47 | col | 1 | 5146 | 29 | 0.186 | 27666.7 |
2028 | 2022-06-23 10:29:02 | col | 2 | 14084 | 485 | 0.330 | 42678.8 |
2027 | 2022-06-16 13:02:59 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |
2026 | 2022-06-15 20:41:55 | col | 1 | 5146 | 29 | 0.096 | 53604.2 |
2025 | 2022-06-08 20:14:55 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2024 | 2022-05-25 16:18:31 | col | 1 | 5146 | 29 | 0.080 | 64325.0 |
2023 | 2022-05-18 10:49:56 | col | 1 | 5146 | 29 | 0.093 | 55333.3 |
2022 | 2022-04-01 11:53:02 | col | 1 | 5146 | 29 | 0.076 | 67710.5 |