History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"whitecap"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
178 | 2024-04-27 17:48:41 | whitecap | 1 | 82945 | 2 | 2.903 | 28572.2 |
177 | 2024-04-07 17:08:56 | whitecap | 1 | 82945 | 2 | 1.576 | 52630.1 |
176 | 2024-04-03 15:37:50 | whitecap | 3 | 146162 | 27 | 14.453 | 10112.9 |
175 | 2024-04-03 15:37:42 | whitecap | 4 | 161609 | 162 | 19.546 | 8268.1 |
174 | 2024-04-02 22:45:42 | whitecap | 4 | 161609 | 162 | 38.626 | 4183.9 |
173 | 2024-04-01 06:12:56 | whitecap | 4 | 161609 | 162 | 16.846 | 9593.3 |
172 | 2024-04-01 06:12:57 | whitecap | 3 | 146162 | 27 | 13.233 | 11045.3 |
171 | 2024-04-01 06:12:58 | whitecap | 2 | 121059 | 2 | 9.406 | 12870.4 |
170 | 2024-04-01 06:10:03 | whitecap | 1 | 82945 | 2 | 2.470 | 33581.0 |
169 | 2024-04-01 06:08:43 | whitecap | 4 | 161609 | 162 | 17.283 | 9350.7 |
168 | 2024-04-01 06:08:44 | whitecap | 3 | 146162 | 27 | 7.986 | 18302.3 |
167 | 2024-04-01 06:08:36 | whitecap | 1 | 82945 | 2 | 3.610 | 22976.5 |
166 | 2024-03-30 04:00:44 | whitecap | 1 | 82945 | 2 | 3.233 | 25655.7 |
165 | 2024-03-08 21:30:09 | whitecap | 2 | 121059 | 2 | 8.690 | 13930.8 |
164 | 2024-03-08 21:29:17 | whitecap | 1 | 82945 | 2 | 4.450 | 18639.3 |
163 | 2024-03-08 00:10:05 | whitecap | 1 | 82945 | 2 | 1.470 | 56425.2 |
162 | 2024-03-05 13:51:33 | whitecap | 2 | 121059 | 2 | 3.173 | 38152.9 |
161 | 2024-03-02 06:45:34 | whitecap | 1 | 82945 | 2 | 3.046 | 27230.8 |
160 | 2024-03-02 01:23:05 | whitecap | 2 | 121059 | 2 | 6.203 | 19516.2 |
159 | 2024-03-02 01:22:59 | whitecap | 1 | 82945 | 2 | 3.080 | 26930.2 |
158 | 2024-03-01 23:58:59 | whitecap | 3 | 146162 | 27 | 15.343 | 9526.3 |
157 | 2024-02-27 23:11:37 | whitecap | 4 | 161609 | 162 | 25.266 | 6396.3 |
156 | 2024-02-27 23:11:37 | whitecap | 3 | 146162 | 27 | 17.860 | 8183.8 |
155 | 2024-02-27 23:11:06 | whitecap | 1 | 82945 | 2 | 5.580 | 14864.7 |
154 | 2024-02-16 22:05:04 | whitecap | 1 | 82945 | 2 | 1.640 | 50576.2 |
153 | 2024-02-09 20:00:03 | whitecap | 2 | 121059 | 2 | 3.483 | 34757.1 |
152 | 2024-02-09 19:59:31 | whitecap | 3 | 146162 | 27 | 7.623 | 19173.8 |
151 | 2024-02-09 19:59:25 | whitecap | 4 | 161609 | 162 | 12.953 | 12476.6 |
150 | 2024-02-09 00:36:25 | whitecap | 3 | 146162 | 27 | 9.423 | 15511.2 |
149 | 2024-02-06 15:46:02 | whitecap | 2 | 121059 | 2 | 3.876 | 31233.0 |
148 | 2024-02-06 12:58:05 | whitecap | 4 | 161609 | 162 | 13.640 | 11848.2 |
147 | 2024-02-01 10:12:24 | whitecap | 2 | 121059 | 2 | 3.690 | 32807.3 |
146 | 2024-01-30 19:24:08 | whitecap | 1 | 82945 | 2 | 1.423 | 58288.8 |
145 | 2024-01-26 01:01:28 | whitecap | 4 | 161609 | 162 | 13.203 | 12240.3 |
144 | 2024-01-26 00:59:59 | whitecap | 4 | 161609 | 162 | 19.500 | 8287.6 |
143 | 2024-01-26 01:00:14 | whitecap | 1 | 82945 | 2 | 3.643 | 22768.3 |
142 | 2024-01-26 01:00:03 | whitecap | 2 | 121059 | 2 | 3.923 | 30858.8 |
141 | 2024-01-17 11:33:56 | whitecap | 3 | 146162 | 27 | 6.233 | 23449.7 |
140 | 2024-01-11 20:23:29 | whitecap | 1 | 82945 | 2 | 1.330 | 62364.7 |
139 | 2024-01-06 03:08:04 | whitecap | 3 | 146162 | 27 | 6.596 | 22159.2 |
138 | 2024-01-02 18:40:48 | whitecap | 4 | 161609 | 162 | 25.910 | 6237.3 |
137 | 2023-12-11 13:10:51 | whitecap | 1 | 82945 | 2 | 1.220 | 67987.7 |
136 | 2023-11-12 20:19:11 | whitecap | 3 | 146162 | 27 | 6.076 | 24055.6 |
135 | 2023-10-30 21:53:07 | whitecap | 1 | 82945 | 2 | 1.436 | 57761.1 |
134 | 2023-10-23 13:41:31 | whitecap | 4 | 161609 | 162 | 14.656 | 11026.8 |
133 | 2023-10-23 13:41:20 | whitecap | 2 | 121059 | 2 | 7.393 | 16374.8 |
132 | 2023-10-23 13:41:16 | whitecap | 3 | 146162 | 27 | 7.550 | 19359.2 |
131 | 2023-10-20 19:01:37 | whitecap | 1 | 82945 | 2 | 1.326 | 62552.8 |
130 | 2023-09-26 22:25:16 | whitecap | 1 | 82945 | 2 | 2.233 | 37145.1 |
129 | 2023-08-15 03:45:49 | whitecap | 3 | 146162 | 27 | 6.780 | 21557.8 |
128 | 2023-07-24 14:05:20 | whitecap | 1 | 82945 | 2 | 1.360 | 60989.0 |
127 | 2023-04-26 22:52:47 | whitecap | 3 | 146162 | 27 | 5.906 | 24748.1 |
126 | 2023-04-25 13:39:13 | whitecap | 1 | 82945 | 2 | 1.233 | 67270.9 |
125 | 2023-02-15 17:21:36 | whitecap | 1 | 82945 | 2 | 1.203 | 68948.5 |
124 | 2023-02-01 09:56:12 | whitecap | 3 | 146162 | 27 | 10.576 | 13820.2 |
123 | 2022-12-13 19:34:17 | whitecap | 1 | 82945 | 2 | 1.203 | 68948.5 |
122 | 2022-11-13 15:19:23 | whitecap | 3 | 146162 | 27 | 6.796 | 21507.1 |
121 | 2022-08-22 19:55:52 | whitecap | 1 | 82945 | 2 | 1.220 | 67987.7 |
120 | 2022-06-17 06:24:12 | whitecap | 3 | 146162 | 27 | 5.970 | 24482.7 |
119 | 2022-04-30 21:11:13 | whitecap | 3 | 146162 | 27 | 5.890 | 24815.3 |
118 | 2022-04-10 04:58:36 | whitecap | 1 | 82945 | 2 | 1.236 | 67107.6 |
117 | 2022-04-06 09:45:41 | whitecap | 3 | 146162 | 27 | 6.690 | 21847.8 |
116 | 2022-02-18 06:26:59 | whitecap | 3 | 146162 | 27 | 6.343 | 23043.0 |
115 | 2022-01-08 03:05:04 | whitecap | 1 | 82945 | 2 | 1.280 | 64800.8 |
114 | 2022-01-06 01:42:06 | whitecap | 1 | 82945 | 2 | 1.436 | 57761.1 |
113 | 2021-11-18 16:42:47 | whitecap | 1 | 82945 | 2 | 1.346 | 61623.3 |
112 | 2021-01-29 14:06:09 | whitecap | 4 | 161609 | 162 | 10.876 | 14859.2 |
111 | 2021-01-07 18:42:06 | whitecap | 1 | 82945 | 2 | 1.250 | 66356.0 |
110 | 2020-11-14 23:02:03 | whitecap | 1 | 82945 | 2 | 1.250 | 66356.0 |
109 | 2020-10-27 08:53:25 | whitecap | 1 | 82945 | 2 | 1.356 | 61168.9 |
108 | 2020-10-22 08:23:46 | whitecap | 1 | 82945 | 2 | 1.220 | 67987.7 |
107 | 2020-10-17 06:19:03 | whitecap | 1 | 82945 | 2 | 1.403 | 59119.7 |
106 | 2020-03-28 06:17:11 | whitecap | 1 | 82945 | 2 | 1.466 | 56579.1 |
105 | 2020-03-23 12:00:38 | whitecap | 1 | 82945 | 2 | 1.376 | 60279.8 |
104 | 2020-03-03 01:14:41 | whitecap | 1 | 82945 | 2 | 2.860 | 29001.7 |
103 | 2020-03-02 22:55:07 | whitecap | 1 | 82945 | 2 | 1.420 | 58412.0 |
102 | 2020-03-01 02:27:28 | whitecap | 1 | 82945 | 2 | 2.563 | 32362.5 |
101 | 2020-02-13 08:20:05 | whitecap | 1 | 82945 | 2 | 1.533 | 54106.3 |
100 | 2020-02-09 23:56:29 | whitecap | 1 | 82945 | 2 | 1.360 | 60989.0 |
99 | 2020-02-05 21:08:15 | whitecap | 1 | 82945 | 2 | 1.716 | 48336.2 |
98 | 2020-02-02 03:32:44 | whitecap | 1 | 82945 | 2 | 1.530 | 54212.4 |
97 | 2020-01-27 23:19:34 | whitecap | 1 | 82945 | 2 | 2.283 | 36331.6 |
96 | 2020-01-24 11:09:49 | whitecap | 1 | 82945 | 2 | 3.266 | 25396.5 |
95 | 2020-01-15 04:00:20 | whitecap | 1 | 82945 | 2 | 1.326 | 62552.8 |
94 | 2020-01-04 20:17:54 | whitecap | 1 | 82945 | 2 | 1.420 | 58412.0 |
93 | 2020-01-02 13:05:33 | whitecap | 1 | 82945 | 2 | 1.390 | 59672.7 |
92 | 2019-11-22 14:09:30 | whitecap | 4 | 161609 | 162 | 10.063 | 16059.7 |
91 | 2019-11-06 22:53:47 | whitecap | 1 | 82945 | 2 | 1.250 | 66356.0 |
90 | 2019-07-17 19:39:32 | whitecap | 1 | 82945 | 2 | 1.273 | 65157.1 |
89 | 2019-07-14 11:21:56 | whitecap | 3 | 146162 | 27 | 5.970 | 24482.7 |
88 | 2019-06-09 19:22:19 | whitecap | 1 | 82945 | 2 | 1.366 | 60721.1 |
87 | 2019-02-27 22:53:07 | whitecap | 1 | 82945 | 2 | 1.400 | 59246.4 |
86 | 2019-02-24 03:54:30 | whitecap | 2 | 121059 | 2 | 3.060 | 39561.8 |
85 | 2019-02-24 03:48:46 | whitecap | 1 | 82945 | 2 | 1.200 | 69120.8 |
84 | 2019-01-27 16:05:42 | whitecap | 1 | 82945 | 2 | 1.180 | 70292.4 |
83 | 2019-01-20 13:56:51 | whitecap | 1 | 82945 | 2 | 1.200 | 69120.8 |
82 | 2018-10-18 01:46:35 | whitecap | 1 | 82945 | 2 | 1.386 | 59844.9 |
81 | 2018-08-15 00:59:22 | whitecap | 1 | 82945 | 2 | 1.456 | 56967.7 |
80 | 2018-07-26 22:00:26 | whitecap | 1 | 82945 | 2 | 1.196 | 69352.0 |
79 | 2018-07-02 05:00:29 | whitecap | 4 | 161609 | 162 | 20.600 | 7845.1 |