History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yellowfin"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
195 | 2024-05-17 09:39:49 | yellowfin | 4 | 165329 | 70 | 31.733 | 5210.0 |
194 | 2024-05-15 21:17:44 | yellowfin | 4 | 165329 | 70 | 20.266 | 8157.9 |
193 | 2024-05-15 16:05:59 | yellowfin | 4 | 165329 | 70 | 31.953 | 5174.1 |
192 | 2024-05-13 23:06:19 | yellowfin | 4 | 165329 | 70 | 40.703 | 4061.8 |
191 | 2024-05-07 06:36:10 | yellowfin | 1 | 81242 | 2 | 4.673 | 17385.4 |
190 | 2024-05-05 22:57:06 | yellowfin | 5 | 174418 | 472 | 27.830 | 6267.3 |
189 | 2024-05-05 18:32:40 | yellowfin | 5 | 174418 | 472 | 52.630 | 3314.0 |
188 | 2024-05-05 18:32:44 | yellowfin | 3 | 148641 | 18 | 24.643 | 6031.8 |
187 | 2024-05-05 18:32:47 | yellowfin | 4 | 165329 | 70 | 14.733 | 11221.7 |
186 | 2024-05-05 18:32:51 | yellowfin | 2 | 121436 | 3 | 4.296 | 28267.2 |
185 | 2024-05-05 18:32:35 | yellowfin | 1 | 81242 | 2 | 1.686 | 48186.2 |
184 | 2024-04-23 04:00:51 | yellowfin | 2 | 121436 | 3 | 7.576 | 16029.0 |
183 | 2024-04-20 21:08:22 | yellowfin | 4 | 165329 | 70 | 15.736 | 10506.4 |
182 | 2024-04-20 21:08:23 | yellowfin | 3 | 148641 | 18 | 12.500 | 11891.3 |
181 | 2024-04-20 21:08:17 | yellowfin | 4 | 165329 | 70 | 16.126 | 10252.3 |
180 | 2024-04-20 21:08:16 | yellowfin | 2 | 121436 | 3 | 8.330 | 14578.2 |
179 | 2024-04-20 21:07:56 | yellowfin | 1 | 81242 | 2 | 3.470 | 23412.7 |
178 | 2024-04-18 15:11:30 | yellowfin | 3 | 148641 | 18 | 15.140 | 9817.8 |
177 | 2024-04-14 19:38:41 | yellowfin | 4 | 165329 | 70 | 29.673 | 5571.7 |
176 | 2024-04-14 19:38:49 | yellowfin | 3 | 148641 | 18 | 20.956 | 7093.0 |
175 | 2024-04-12 05:35:49 | yellowfin | 3 | 148641 | 18 | 28.220 | 5267.2 |
174 | 2024-04-12 00:15:09 | yellowfin | 4 | 165329 | 70 | 34.156 | 4840.4 |
173 | 2024-04-12 00:15:12 | yellowfin | 3 | 148641 | 18 | 30.893 | 4811.5 |
172 | 2024-04-12 00:15:17 | yellowfin | 2 | 121436 | 3 | 10.173 | 11937.1 |
171 | 2024-04-12 00:00:41 | yellowfin | 1 | 81242 | 2 | 2.440 | 33295.9 |
170 | 2024-04-11 23:49:23 | yellowfin | 1 | 81242 | 2 | 2.376 | 34192.8 |
169 | 2024-04-06 16:13:17 | yellowfin | 1 | 81242 | 2 | 2.953 | 27511.7 |
168 | 2024-03-29 19:28:47 | yellowfin | 1 | 81242 | 2 | 2.690 | 30201.5 |
167 | 2024-03-15 13:32:27 | yellowfin | 2 | 121436 | 3 | 8.783 | 13826.3 |
166 | 2024-03-15 11:14:32 | yellowfin | 1 | 81242 | 2 | 1.610 | 50460.9 |
165 | 2024-03-12 00:20:14 | yellowfin | 1 | 81242 | 2 | 3.936 | 20640.8 |
164 | 2024-03-06 12:40:19 | yellowfin | 3 | 148641 | 18 | 14.423 | 10305.8 |
163 | 2024-03-06 12:40:23 | yellowfin | 2 | 121436 | 3 | 9.156 | 13263.0 |
162 | 2024-03-06 12:39:55 | yellowfin | 1 | 81242 | 2 | 2.903 | 27985.5 |
161 | 2024-03-04 13:19:10 | yellowfin | 4 | 165329 | 70 | 30.253 | 5464.9 |
160 | 2024-03-02 05:51:12 | yellowfin | 5 | 174418 | 472 | 27.610 | 6317.2 |
159 | 2024-03-01 10:33:51 | yellowfin | 4 | 165329 | 70 | 23.033 | 7177.9 |
158 | 2024-02-26 17:21:28 | yellowfin | 4 | 165329 | 70 | 30.423 | 5434.3 |
157 | 2024-02-26 16:36:30 | yellowfin | 4 | 165329 | 70 | 36.533 | 4525.5 |
156 | 2024-02-26 16:25:33 | yellowfin | 5 | 174418 | 472 | 33.266 | 5243.1 |
155 | 2024-02-26 16:25:27 | yellowfin | 4 | 165329 | 70 | 34.003 | 4862.2 |
154 | 2024-02-26 16:25:31 | yellowfin | 3 | 148641 | 18 | 16.860 | 8816.2 |
153 | 2024-02-26 16:25:29 | yellowfin | 2 | 121436 | 3 | 12.283 | 9886.5 |
152 | 2024-02-26 16:25:15 | yellowfin | 1 | 81242 | 2 | 2.236 | 36333.6 |
151 | 2024-01-31 21:41:32 | yellowfin | 1 | 81242 | 2 | 1.330 | 61084.2 |
150 | 2024-01-31 21:41:27 | yellowfin | 1 | 81242 | 2 | 2.656 | 30588.1 |
149 | 2024-01-27 01:27:17 | yellowfin | 1 | 81242 | 2 | 1.360 | 59736.8 |
148 | 2023-12-29 20:00:19 | yellowfin | 1 | 81242 | 2 | 1.373 | 59171.2 |
147 | 2023-12-26 03:28:00 | yellowfin | 1 | 81242 | 2 | 2.453 | 33119.4 |
146 | 2023-12-11 21:00:53 | yellowfin | 1 | 81242 | 2 | 1.406 | 57782.4 |
145 | 2023-10-20 01:20:30 | yellowfin | 1 | 81242 | 2 | 1.220 | 66591.8 |
144 | 2023-10-14 17:40:10 | yellowfin | 1 | 81242 | 2 | 1.390 | 58447.5 |
143 | 2023-08-09 23:20:50 | yellowfin | 1 | 81242 | 2 | 1.343 | 60492.9 |
142 | 2023-05-21 06:33:22 | yellowfin | 1 | 81242 | 2 | 1.283 | 63321.9 |
141 | 2023-05-09 11:00:16 | yellowfin | 1 | 81242 | 2 | 1.233 | 65889.7 |
140 | 2023-03-02 13:11:56 | yellowfin | 1 | 81242 | 2 | 1.203 | 67532.8 |
139 | 2022-12-26 18:34:43 | yellowfin | 1 | 81242 | 2 | 1.173 | 69260.0 |
138 | 2022-12-02 14:20:10 | yellowfin | 1 | 81242 | 2 | 1.170 | 69437.6 |
137 | 2022-09-15 06:56:11 | yellowfin | 1 | 81242 | 2 | 1.393 | 58321.6 |
136 | 2022-06-05 14:25:47 | yellowfin | 1 | 81242 | 2 | 1.216 | 66810.9 |
135 | 2021-09-22 23:40:50 | yellowfin | 1 | 81242 | 2 | 1.393 | 58321.6 |
134 | 2021-09-19 19:02:42 | yellowfin | 1 | 81242 | 2 | 2.403 | 33808.6 |
133 | 2021-05-17 08:06:23 | yellowfin | 1 | 81242 | 2 | 1.453 | 55913.3 |
132 | 2021-05-07 03:40:12 | yellowfin | 1 | 81242 | 2 | 1.390 | 58447.5 |
131 | 2021-04-06 21:55:31 | yellowfin | 5 | 174418 | 472 | 17.516 | 9957.6 |
130 | 2021-02-14 19:58:35 | yellowfin | 5 | 174418 | 472 | 15.750 | 11074.2 |
129 | 2021-01-20 22:36:42 | yellowfin | 1 | 81242 | 2 | 1.393 | 58321.6 |
128 | 2021-01-14 05:27:36 | yellowfin | 1 | 81242 | 2 | 1.250 | 64993.6 |
127 | 2021-01-10 18:26:33 | yellowfin | 1 | 81242 | 2 | 1.263 | 64324.6 |
126 | 2020-11-02 03:14:06 | yellowfin | 1 | 81242 | 2 | 1.486 | 54671.6 |
125 | 2020-09-27 10:20:43 | yellowfin | 1 | 81242 | 2 | 1.326 | 61268.5 |
124 | 2020-09-14 03:43:51 | yellowfin | 1 | 81242 | 2 | 1.233 | 65889.7 |
123 | 2020-04-25 20:38:55 | yellowfin | 1 | 81242 | 2 | 1.216 | 66810.9 |
122 | 2020-03-29 05:43:09 | yellowfin | 1 | 81242 | 2 | 1.360 | 59736.8 |
121 | 2020-03-28 11:13:53 | yellowfin | 5 | 174418 | 472 | 40.736 | 4281.7 |
120 | 2020-02-25 22:54:14 | yellowfin | 5 | 174418 | 472 | 20.940 | 8329.4 |
119 | 2020-02-23 10:26:21 | yellowfin | 5 | 174418 | 472 | 24.986 | 6980.6 |
118 | 2020-02-17 01:02:36 | yellowfin | 3 | 148641 | 18 | 8.983 | 16546.9 |
117 | 2020-02-16 19:39:26 | yellowfin | 2 | 121436 | 3 | 8.310 | 14613.2 |
116 | 2020-02-15 13:24:30 | yellowfin | 1 | 81242 | 2 | 3.140 | 25873.2 |
115 | 2020-02-15 12:07:25 | yellowfin | 4 | 165329 | 70 | 15.780 | 10477.1 |
114 | 2020-02-11 14:27:02 | yellowfin | 1 | 81242 | 2 | 2.923 | 27794.0 |
113 | 2020-02-11 02:39:20 | yellowfin | 4 | 165329 | 70 | 13.860 | 11928.5 |
112 | 2020-01-24 23:54:07 | yellowfin | 5 | 174418 | 472 | 34.266 | 5090.1 |
111 | 2020-01-24 23:54:04 | yellowfin | 5 | 174418 | 472 | 32.750 | 5325.7 |
110 | 2020-01-24 18:26:21 | yellowfin | 5 | 174418 | 472 | 26.110 | 6680.1 |
109 | 2020-01-24 17:37:10 | yellowfin | 5 | 174418 | 472 | 20.733 | 8412.6 |
108 | 2020-01-24 16:59:26 | yellowfin | 5 | 174418 | 472 | 34.020 | 5126.9 |
107 | 2020-01-24 12:04:03 | yellowfin | 5 | 174418 | 472 | 37.266 | 4680.4 |
106 | 2020-01-24 11:57:59 | yellowfin | 2 | 121436 | 3 | 11.263 | 10781.9 |
105 | 2020-01-24 11:57:16 | yellowfin | 3 | 148641 | 18 | 18.656 | 7967.5 |
104 | 2020-01-24 11:33:24 | yellowfin | 4 | 165329 | 70 | 14.000 | 11809.2 |
103 | 2020-01-24 08:08:00 | yellowfin | 1 | 81242 | 2 | 1.486 | 54671.6 |
102 | 2020-01-21 22:00:49 | yellowfin | 3 | 148641 | 18 | 17.373 | 8555.9 |
101 | 2020-01-21 20:30:49 | yellowfin | 4 | 165329 | 70 | 15.800 | 10463.9 |
100 | 2020-01-15 09:06:10 | yellowfin | 2 | 121436 | 3 | 4.423 | 27455.6 |
99 | 2020-01-15 02:57:16 | yellowfin | 1 | 81242 | 2 | 1.656 | 49059.2 |
98 | 2020-01-10 10:15:57 | yellowfin | 3 | 148641 | 18 | 14.733 | 10089.0 |
97 | 2020-01-10 10:15:49 | yellowfin | 4 | 165329 | 70 | 14.800 | 11170.9 |
96 | 2020-01-10 10:15:45 | yellowfin | 2 | 121436 | 3 | 5.736 | 21170.9 |