History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"whitefaces"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
191 | 2024-05-11 12:18:06 | whitefaces | 4 | 161450 | 76 | 23.126 | 6981.3 |
190 | 2024-05-09 06:30:18 | whitefaces | 4 | 161450 | 76 | 27.160 | 5944.4 |
189 | 2024-05-09 03:53:36 | whitefaces | 1 | 67641 | 2 | 1.080 | 62630.6 |
188 | 2024-05-07 11:58:12 | whitefaces | 4 | 161450 | 76 | 30.016 | 5378.8 |
187 | 2024-05-07 11:58:16 | whitefaces | 2 | 108824 | 3 | 6.250 | 17411.8 |
186 | 2024-05-07 11:58:06 | whitefaces | 1 | 67641 | 2 | 2.126 | 31816.1 |
185 | 2024-05-07 11:49:15 | whitefaces | 4 | 161450 | 76 | 33.550 | 4812.2 |
184 | 2024-05-07 11:48:51 | whitefaces | 2 | 108824 | 3 | 4.703 | 23139.3 |
183 | 2024-05-07 11:24:07 | whitefaces | 5 | 173545 | 500 | 27.220 | 6375.6 |
182 | 2024-05-07 11:20:59 | whitefaces | 1 | 67641 | 2 | 1.080 | 62630.6 |
181 | 2024-05-05 03:15:56 | whitefaces | 1 | 67641 | 2 | 0.986 | 68601.4 |
180 | 2024-05-03 14:14:45 | whitefaces | 1 | 67641 | 2 | 1.093 | 61885.6 |
179 | 2024-05-01 23:10:25 | whitefaces | 3 | 140603 | 12 | 6.220 | 22605.0 |
178 | 2024-04-27 17:33:04 | whitefaces | 1 | 67641 | 2 | 1.233 | 54858.9 |
177 | 2024-04-12 17:34:41 | whitefaces | 1 | 67641 | 2 | 1.030 | 65670.9 |
176 | 2024-04-12 17:34:40 | whitefaces | 1 | 67641 | 2 | 0.970 | 69733.0 |
175 | 2024-04-12 00:21:18 | whitefaces | 4 | 161450 | 76 | 23.893 | 6757.2 |
174 | 2024-04-06 23:27:39 | whitefaces | 4 | 161450 | 76 | 20.233 | 7979.5 |
173 | 2024-03-15 05:29:17 | whitefaces | 3 | 140603 | 12 | 18.160 | 7742.5 |
172 | 2024-03-15 05:29:17 | whitefaces | 2 | 108824 | 3 | 10.233 | 10634.6 |
171 | 2024-03-15 05:26:16 | whitefaces | 1 | 67641 | 2 | 3.720 | 18183.1 |
170 | 2024-03-14 20:30:59 | whitefaces | 5 | 173545 | 500 | 66.330 | 2616.4 |
169 | 2024-03-12 01:47:53 | whitefaces | 5 | 173545 | 500 | 29.206 | 5942.1 |
168 | 2024-03-11 17:22:53 | whitefaces | 4 | 161450 | 76 | 26.050 | 6197.7 |
167 | 2024-03-11 09:06:15 | whitefaces | 4 | 161450 | 76 | 37.236 | 4335.9 |
166 | 2024-03-10 17:07:48 | whitefaces | 4 | 161450 | 76 | 40.673 | 3969.5 |
165 | 2024-03-10 17:07:47 | whitefaces | 5 | 173545 | 500 | 29.126 | 5958.4 |
164 | 2024-03-10 17:07:49 | whitefaces | 2 | 108824 | 3 | 9.373 | 11610.4 |
163 | 2024-03-10 15:56:29 | whitefaces | 1 | 67641 | 2 | 1.156 | 58513.0 |
162 | 2024-02-22 04:10:57 | whitefaces | 3 | 140603 | 12 | 7.576 | 18559.0 |
161 | 2024-02-21 10:50:40 | whitefaces | 3 | 140603 | 12 | 9.046 | 15543.1 |
160 | 2024-02-21 10:50:40 | whitefaces | 2 | 108824 | 3 | 5.220 | 20847.5 |
159 | 2024-02-21 07:47:38 | whitefaces | 3 | 140603 | 12 | 7.453 | 18865.3 |
158 | 2024-02-21 05:11:21 | whitefaces | 2 | 108824 | 3 | 3.920 | 27761.2 |
157 | 2024-02-21 00:50:54 | whitefaces | 1 | 67641 | 2 | 2.173 | 31127.9 |
156 | 2024-02-20 21:56:10 | whitefaces | 4 | 161450 | 76 | 10.110 | 15969.3 |
155 | 2024-02-20 21:08:33 | whitefaces | 1 | 67641 | 2 | 1.140 | 59334.2 |
154 | 2024-02-16 00:33:23 | whitefaces | 1 | 67641 | 2 | 1.343 | 50365.6 |
153 | 2024-02-15 20:14:41 | whitefaces | 2 | 108824 | 3 | 2.486 | 43774.7 |
152 | 2024-02-15 02:48:24 | whitefaces | 4 | 161450 | 76 | 10.503 | 15371.8 |
151 | 2024-02-15 02:48:08 | whitefaces | 4 | 161450 | 76 | 9.263 | 17429.6 |
150 | 2024-02-06 17:00:30 | whitefaces | 4 | 161450 | 76 | 56.440 | 2860.6 |
149 | 2024-02-06 17:00:35 | whitefaces | 2 | 108824 | 3 | 10.173 | 10697.3 |
148 | 2024-02-06 12:59:07 | whitefaces | 1 | 67641 | 2 | 1.110 | 60937.8 |
147 | 2024-02-06 12:59:05 | whitefaces | 1 | 67641 | 2 | 0.970 | 69733.0 |
146 | 2024-01-30 15:27:42 | whitefaces | 1 | 67641 | 2 | 1.076 | 62863.4 |
145 | 2024-01-20 12:12:11 | whitefaces | 1 | 67641 | 2 | 1.063 | 63632.2 |
144 | 2024-01-06 02:14:34 | whitefaces | 1 | 67641 | 2 | 0.970 | 69733.0 |
143 | 2024-01-03 02:53:42 | whitefaces | 1 | 67641 | 2 | 1.093 | 61885.6 |
142 | 2023-12-27 09:37:01 | whitefaces | 5 | 173545 | 500 | 16.703 | 10390.0 |
141 | 2023-12-21 16:57:29 | whitefaces | 3 | 140603 | 12 | 6.606 | 21284.1 |
140 | 2023-12-19 01:49:27 | whitefaces | 1 | 67641 | 2 | 1.046 | 64666.3 |
139 | 2023-12-18 01:52:01 | whitefaces | 5 | 173545 | 500 | 16.236 | 10688.9 |
138 | 2023-12-12 13:57:01 | whitefaces | 5 | 173545 | 500 | 22.096 | 7854.1 |
137 | 2023-11-24 02:47:10 | whitefaces | 1 | 67641 | 2 | 1.076 | 62863.4 |
136 | 2023-11-22 07:51:35 | whitefaces | 1 | 67641 | 2 | 0.950 | 71201.1 |
135 | 2023-11-17 18:06:26 | whitefaces | 1 | 67641 | 2 | 1.076 | 62863.4 |
134 | 2023-11-16 20:34:20 | whitefaces | 1 | 67641 | 2 | 1.110 | 60937.8 |
133 | 2023-11-15 21:15:06 | whitefaces | 2 | 108824 | 3 | 2.750 | 39572.4 |
132 | 2023-11-12 05:35:03 | whitefaces | 5 | 173545 | 500 | 14.733 | 11779.3 |
131 | 2023-09-21 23:23:40 | whitefaces | 3 | 140603 | 12 | 5.186 | 27112.0 |
130 | 2023-09-04 00:22:07 | whitefaces | 1 | 67641 | 2 | 0.970 | 69733.0 |
129 | 2023-08-16 21:57:47 | whitefaces | 2 | 108824 | 3 | 2.486 | 43774.7 |
128 | 2023-08-15 11:29:24 | whitefaces | 5 | 173545 | 500 | 14.873 | 11668.5 |
127 | 2023-07-15 06:52:38 | whitefaces | 1 | 67641 | 2 | 0.953 | 70976.9 |
126 | 2023-06-26 07:20:25 | whitefaces | 3 | 140603 | 12 | 5.780 | 24325.8 |
125 | 2023-05-09 05:58:10 | whitefaces | 4 | 161450 | 76 | 9.080 | 17780.8 |
124 | 2023-04-29 14:46:41 | whitefaces | 5 | 173545 | 500 | 17.670 | 9821.4 |
123 | 2023-04-28 20:25:53 | whitefaces | 2 | 108824 | 3 | 2.500 | 43529.6 |
122 | 2023-03-24 06:49:30 | whitefaces | 3 | 140603 | 12 | 5.733 | 24525.2 |
121 | 2023-02-24 05:47:01 | whitefaces | 1 | 67641 | 2 | 0.953 | 70976.9 |
120 | 2023-02-03 09:07:18 | whitefaces | 5 | 173545 | 500 | 14.326 | 12114.0 |
119 | 2023-02-03 08:03:52 | whitefaces | 2 | 108824 | 3 | 2.436 | 44673.2 |
118 | 2023-01-31 22:25:33 | whitefaces | 1 | 67641 | 2 | 1.033 | 65480.2 |
117 | 2023-01-21 00:51:39 | whitefaces | 5 | 173545 | 500 | 15.190 | 11425.0 |
116 | 2022-12-23 01:16:55 | whitefaces | 3 | 140603 | 12 | 5.783 | 24313.2 |
115 | 2022-12-22 20:06:09 | whitefaces | 1 | 67641 | 2 | 0.983 | 68810.8 |
114 | 2022-12-13 04:21:25 | whitefaces | 5 | 173545 | 500 | 14.893 | 11652.8 |
113 | 2022-12-06 22:43:46 | whitefaces | 5 | 173545 | 500 | 17.156 | 10115.7 |
112 | 2022-11-16 07:01:47 | whitefaces | 5 | 173545 | 500 | 14.546 | 11930.8 |
111 | 2022-11-13 20:24:08 | whitefaces | 2 | 108824 | 3 | 5.203 | 20915.6 |
110 | 2022-11-09 18:26:16 | whitefaces | 5 | 173545 | 500 | 17.423 | 9960.7 |
109 | 2022-09-05 04:47:18 | whitefaces | 1 | 67641 | 2 | 0.970 | 69733.0 |
108 | 2022-09-04 14:27:33 | whitefaces | 4 | 161450 | 76 | 10.893 | 14821.4 |
107 | 2022-09-01 05:33:13 | whitefaces | 2 | 108824 | 3 | 2.500 | 43529.6 |
106 | 2022-09-01 05:31:26 | whitefaces | 4 | 161450 | 76 | 10.453 | 15445.3 |
105 | 2022-08-21 17:47:21 | whitefaces | 3 | 140603 | 12 | 5.140 | 27354.7 |
104 | 2022-08-18 13:48:25 | whitefaces | 1 | 67641 | 2 | 0.983 | 68810.8 |
103 | 2022-08-01 18:26:19 | whitefaces | 5 | 173545 | 500 | 15.706 | 11049.6 |
102 | 2022-06-19 09:26:21 | whitefaces | 5 | 173545 | 500 | 14.440 | 12018.4 |
101 | 2022-06-17 20:15:30 | whitefaces | 2 | 108824 | 3 | 2.610 | 41695.0 |
100 | 2022-05-20 00:05:13 | whitefaces | 1 | 67641 | 2 | 0.950 | 71201.1 |
99 | 2022-05-10 07:28:43 | whitefaces | 1 | 67641 | 2 | 1.000 | 67641.0 |
98 | 2022-03-21 14:23:08 | whitefaces | 3 | 140603 | 12 | 5.703 | 24654.2 |
97 | 2022-03-19 11:05:24 | whitefaces | 3 | 140603 | 12 | 5.140 | 27354.7 |
96 | 2022-02-22 03:49:09 | whitefaces | 1 | 67641 | 2 | 1.046 | 64666.3 |
95 | 2022-01-31 22:12:11 | whitefaces | 5 | 173545 | 500 | 22.783 | 7617.3 |
94 | 2022-01-12 00:42:18 | whitefaces | 1 | 67641 | 2 | 1.110 | 60937.8 |
93 | 2021-12-23 07:00:40 | whitefaces | 3 | 140603 | 12 | 5.343 | 26315.4 |
92 | 2021-11-26 15:56:55 | whitefaces | 1 | 67641 | 2 | 1.063 | 63632.2 |