History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"effectives"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
195 | 2024-04-26 05:31:51 | effectives | 1 | 67641 | 2 | 1.640 | 41244.5 |
194 | 2024-04-19 13:43:59 | effectives | 1 | 67641 | 2 | 1.216 | 55625.8 |
193 | 2024-04-13 18:03:46 | effectives | 1 | 67641 | 2 | 1.640 | 41244.5 |
192 | 2024-04-08 10:18:00 | effectives | 3 | 140603 | 37 | 23.676 | 5938.6 |
191 | 2024-04-07 23:08:12 | effectives | 1 | 67641 | 2 | 2.376 | 28468.4 |
190 | 2024-04-07 16:45:09 | effectives | 4 | 161450 | 150 | 28.046 | 5756.6 |
189 | 2024-04-06 23:00:53 | effectives | 4 | 161450 | 150 | 35.033 | 4608.5 |
188 | 2024-04-06 11:50:36 | effectives | 3 | 140603 | 37 | 10.280 | 13677.3 |
187 | 2024-04-06 07:01:29 | effectives | 1 | 67641 | 2 | 1.856 | 36444.5 |
186 | 2024-04-04 03:08:31 | effectives | 4 | 161450 | 150 | 22.923 | 7043.1 |
185 | 2024-04-03 10:06:06 | effectives | 3 | 140603 | 37 | 12.110 | 11610.5 |
184 | 2024-04-01 20:05:20 | effectives | 4 | 161450 | 150 | 25.503 | 6330.6 |
183 | 2024-04-01 20:05:21 | effectives | 2 | 108824 | 8 | 10.453 | 10410.8 |
182 | 2024-04-01 20:01:46 | effectives | 1 | 67641 | 2 | 3.813 | 17739.6 |
181 | 2024-04-01 19:59:41 | effectives | 4 | 161450 | 150 | 27.733 | 5821.6 |
180 | 2024-04-01 19:59:41 | effectives | 2 | 108824 | 8 | 10.420 | 10443.8 |
179 | 2024-04-01 19:59:37 | effectives | 3 | 140603 | 37 | 9.440 | 14894.4 |
178 | 2024-04-01 19:59:34 | effectives | 1 | 67641 | 2 | 2.283 | 29628.1 |
177 | 2024-04-01 19:59:28 | effectives | 1 | 67641 | 2 | 2.580 | 26217.4 |
176 | 2024-03-05 19:23:35 | effectives | 4 | 161450 | 150 | 30.580 | 5279.6 |
175 | 2024-03-05 14:39:19 | effectives | 1 | 67641 | 2 | 1.080 | 62630.6 |
174 | 2024-03-03 07:19:33 | effectives | 3 | 140603 | 37 | 7.313 | 19226.4 |
173 | 2024-03-03 02:45:49 | effectives | 3 | 140603 | 37 | 13.313 | 10561.3 |
172 | 2024-03-03 02:45:46 | effectives | 2 | 108824 | 8 | 10.423 | 10440.8 |
171 | 2024-03-03 02:34:48 | effectives | 1 | 67641 | 2 | 1.126 | 60071.9 |
170 | 2024-03-01 08:57:29 | effectives | 1 | 67641 | 2 | 1.186 | 57032.9 |
169 | 2024-03-01 08:57:29 | effectives | 1 | 67641 | 2 | 1.156 | 58513.0 |
168 | 2024-02-26 19:10:51 | effectives | 4 | 161450 | 150 | 23.173 | 6967.2 |
167 | 2024-02-20 17:12:25 | effectives | 4 | 161450 | 150 | 19.940 | 8096.8 |
166 | 2024-02-20 17:12:27 | effectives | 3 | 140603 | 37 | 13.720 | 10248.0 |
165 | 2024-02-20 17:12:28 | effectives | 2 | 108824 | 8 | 3.280 | 33178.0 |
164 | 2024-02-20 05:40:51 | effectives | 1 | 67641 | 2 | 1.123 | 60232.4 |
163 | 2024-01-31 00:11:39 | effectives | 1 | 67641 | 2 | 1.126 | 60071.9 |
162 | 2024-01-30 02:39:33 | effectives | 1 | 67641 | 2 | 1.126 | 60071.9 |
161 | 2024-01-29 18:07:42 | effectives | 1 | 67641 | 2 | 2.030 | 33320.7 |
160 | 2024-01-28 17:18:07 | effectives | 1 | 67641 | 2 | 1.000 | 67641.0 |
159 | 2024-01-26 16:58:30 | effectives | 2 | 108824 | 8 | 2.700 | 40305.2 |
158 | 2023-12-25 22:45:24 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
157 | 2023-12-14 10:09:50 | effectives | 1 | 67641 | 2 | 1.046 | 64666.3 |
156 | 2023-12-14 08:32:14 | effectives | 1 | 67641 | 2 | 1.110 | 60937.8 |
155 | 2023-11-05 11:36:36 | effectives | 2 | 108824 | 8 | 2.453 | 44363.6 |
154 | 2023-10-29 22:48:20 | effectives | 1 | 67641 | 2 | 0.986 | 68601.4 |
153 | 2023-10-13 11:35:54 | effectives | 1 | 67641 | 2 | 1.000 | 67641.0 |
152 | 2023-09-27 17:31:02 | effectives | 1 | 67641 | 2 | 1.050 | 64420.0 |
151 | 2023-09-14 01:24:05 | effectives | 1 | 67641 | 2 | 1.360 | 49736.0 |
150 | 2023-08-11 13:57:49 | effectives | 2 | 108824 | 8 | 2.500 | 43529.6 |
149 | 2023-08-09 02:02:04 | effectives | 1 | 67641 | 2 | 1.126 | 60071.9 |
148 | 2023-07-23 14:42:56 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
147 | 2023-05-09 18:36:53 | effectives | 1 | 67641 | 2 | 1.000 | 67641.0 |
146 | 2023-04-25 04:55:43 | effectives | 2 | 108824 | 8 | 2.420 | 44968.6 |
145 | 2023-03-24 11:09:01 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
144 | 2023-03-02 10:49:46 | effectives | 1 | 67641 | 2 | 1.030 | 65670.9 |
143 | 2023-01-29 17:51:47 | effectives | 2 | 108824 | 8 | 2.466 | 44129.8 |
142 | 2022-12-26 12:36:20 | effectives | 1 | 67641 | 2 | 0.966 | 70021.7 |
141 | 2022-11-23 02:18:51 | effectives | 1 | 67641 | 2 | 1.016 | 66575.8 |
140 | 2022-11-12 13:39:37 | effectives | 2 | 108824 | 8 | 2.796 | 38921.3 |
139 | 2022-09-14 12:30:36 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
138 | 2022-08-28 19:31:19 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
137 | 2022-08-18 12:02:24 | effectives | 1 | 67641 | 2 | 1.016 | 66575.8 |
136 | 2022-07-26 04:41:06 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
135 | 2022-07-15 18:58:28 | effectives | 1 | 67641 | 2 | 1.096 | 61716.2 |
134 | 2022-07-01 07:56:44 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
133 | 2022-05-12 23:51:07 | effectives | 2 | 108824 | 8 | 2.593 | 41968.4 |
132 | 2022-05-01 16:14:22 | effectives | 1 | 67641 | 2 | 0.970 | 69733.0 |
131 | 2022-03-19 02:49:36 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
130 | 2022-02-26 02:48:35 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
129 | 2022-02-22 16:52:29 | effectives | 1 | 67641 | 2 | 1.063 | 63632.2 |
128 | 2021-10-30 11:24:17 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
127 | 2021-10-29 22:18:28 | effectives | 1 | 67641 | 2 | 1.156 | 58513.0 |
126 | 2021-10-29 06:50:59 | effectives | 1 | 67641 | 2 | 1.076 | 62863.4 |
125 | 2021-10-28 19:35:30 | effectives | 1 | 67641 | 2 | 1.186 | 57032.9 |
124 | 2021-10-28 17:17:42 | effectives | 1 | 67641 | 2 | 1.170 | 57812.8 |
123 | 2021-10-27 21:49:51 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
122 | 2021-10-27 01:42:59 | effectives | 1 | 67641 | 2 | 1.000 | 67641.0 |
121 | 2021-07-18 11:46:18 | effectives | 1 | 67641 | 2 | 1.076 | 62863.4 |
120 | 2021-04-15 18:12:36 | effectives | 1 | 67641 | 2 | 1.173 | 57665.0 |
119 | 2021-04-11 22:07:57 | effectives | 1 | 67641 | 2 | 1.093 | 61885.6 |
118 | 2020-12-25 22:33:15 | effectives | 1 | 67641 | 2 | 1.030 | 65670.9 |
117 | 2020-10-22 03:30:08 | effectives | 1 | 67641 | 2 | 1.000 | 67641.0 |
116 | 2020-10-09 07:49:12 | effectives | 1 | 67641 | 2 | 0.966 | 70021.7 |
115 | 2020-09-22 02:52:25 | effectives | 1 | 67641 | 2 | 0.983 | 68810.8 |
114 | 2020-06-05 10:08:38 | effectives | 1 | 67641 | 2 | 1.153 | 58665.2 |
113 | 2020-03-25 20:58:11 | effectives | 1 | 67641 | 2 | 1.096 | 61716.2 |
112 | 2020-02-29 23:57:03 | effectives | 1 | 67641 | 2 | 1.140 | 59334.2 |
111 | 2020-02-27 01:08:27 | effectives | 1 | 67641 | 2 | 2.456 | 27541.1 |
110 | 2020-02-08 04:56:56 | effectives | 1 | 67641 | 2 | 1.173 | 57665.0 |
109 | 2020-02-03 13:39:04 | effectives | 1 | 67641 | 2 | 1.060 | 63812.3 |
108 | 2020-02-03 09:29:21 | effectives | 1 | 67641 | 2 | 2.563 | 26391.3 |
107 | 2020-01-30 02:15:28 | effectives | 1 | 67641 | 2 | 2.500 | 27056.4 |
106 | 2020-01-29 10:00:52 | effectives | 1 | 67641 | 2 | 2.046 | 33060.1 |
105 | 2020-01-18 18:18:38 | effectives | 1 | 67641 | 2 | 1.016 | 66575.8 |
104 | 2020-01-07 14:22:19 | effectives | 1 | 67641 | 2 | 3.970 | 17038.0 |
103 | 2020-01-05 03:11:24 | effectives | 1 | 67641 | 2 | 1.186 | 57032.9 |
102 | 2019-12-31 14:17:51 | effectives | 1 | 67641 | 2 | 1.030 | 65670.9 |
101 | 2019-11-25 03:18:41 | effectives | 1 | 67641 | 2 | 1.016 | 66575.8 |
100 | 2019-08-26 09:20:19 | effectives | 1 | 67641 | 2 | 1.060 | 63812.3 |
99 | 2019-06-04 12:02:32 | effectives | 1 | 67641 | 2 | 0.996 | 67912.7 |
98 | 2019-05-17 07:57:46 | effectives | 1 | 67641 | 2 | 1.063 | 63632.2 |
97 | 2019-04-07 14:45:31 | effectives | 1 | 67641 | 2 | 1.060 | 63812.3 |
96 | 2019-03-30 06:00:27 | effectives | 1 | 67641 | 2 | 0.986 | 68601.4 |