History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yoghourt"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
179 | 2024-04-15 22:12:11 | yoghourt | 3 | 146162 | 9 | 11.046 | 13232.1 |
178 | 2024-04-15 22:12:06 | yoghourt | 4 | 161609 | 109 | 14.300 | 11301.3 |
177 | 2024-04-15 22:12:10 | yoghourt | 1 | 82945 | 3 | 1.500 | 55296.7 |
176 | 2024-04-15 22:12:04 | yoghourt | 2 | 121059 | 5 | 4.203 | 28803.0 |
175 | 2024-04-11 05:50:16 | yoghourt | 4 | 161609 | 109 | 12.000 | 13467.4 |
174 | 2024-04-10 14:17:55 | yoghourt | 2 | 121059 | 5 | 3.050 | 39691.5 |
173 | 2024-04-08 12:27:17 | yoghourt | 4 | 161609 | 109 | 17.846 | 9055.8 |
172 | 2024-04-08 12:27:06 | yoghourt | 3 | 146162 | 9 | 14.470 | 10101.0 |
171 | 2024-04-08 12:27:12 | yoghourt | 1 | 82945 | 3 | 1.656 | 50087.6 |
170 | 2024-04-08 12:27:08 | yoghourt | 2 | 121059 | 5 | 4.096 | 29555.4 |
169 | 2024-04-05 04:42:39 | yoghourt | 2 | 121059 | 5 | 13.846 | 8743.2 |
168 | 2024-04-05 04:42:40 | yoghourt | 3 | 146162 | 9 | 8.610 | 16975.8 |
167 | 2024-04-05 04:42:28 | yoghourt | 1 | 82945 | 3 | 3.250 | 25521.5 |
166 | 2024-03-31 00:52:52 | yoghourt | 3 | 146162 | 9 | 19.236 | 7598.4 |
165 | 2024-03-31 00:52:50 | yoghourt | 2 | 121059 | 5 | 7.860 | 15401.9 |
164 | 2024-03-30 02:32:31 | yoghourt | 1 | 82945 | 3 | 1.343 | 61761.0 |
163 | 2024-03-29 02:02:36 | yoghourt | 4 | 161609 | 109 | 45.923 | 3519.1 |
162 | 2024-03-28 23:27:50 | yoghourt | 4 | 161609 | 109 | 15.190 | 10639.2 |
161 | 2024-03-22 10:48:38 | yoghourt | 1 | 82945 | 3 | 1.483 | 55930.5 |
160 | 2024-03-15 22:41:38 | yoghourt | 4 | 161609 | 109 | 26.110 | 6189.5 |
159 | 2024-03-14 19:48:54 | yoghourt | 3 | 146162 | 9 | 11.500 | 12709.7 |
158 | 2024-03-14 19:48:52 | yoghourt | 2 | 121059 | 5 | 3.936 | 30756.9 |
157 | 2024-03-14 19:48:47 | yoghourt | 1 | 82945 | 3 | 3.000 | 27648.3 |
156 | 2024-03-14 19:48:32 | yoghourt | 4 | 161609 | 109 | 14.296 | 11304.5 |
155 | 2024-03-09 00:25:12 | yoghourt | 4 | 161609 | 109 | 38.270 | 4222.9 |
154 | 2024-03-08 08:12:25 | yoghourt | 4 | 161609 | 109 | 23.640 | 6836.3 |
153 | 2024-03-03 20:45:42 | yoghourt | 3 | 146162 | 9 | 7.610 | 19206.6 |
152 | 2024-03-03 20:45:45 | yoghourt | 1 | 82945 | 3 | 1.516 | 54713.1 |
151 | 2024-03-03 20:45:40 | yoghourt | 2 | 121059 | 5 | 3.796 | 31891.2 |
150 | 2024-03-02 06:43:39 | yoghourt | 4 | 161609 | 109 | 18.953 | 8526.8 |
149 | 2024-02-26 21:09:41 | yoghourt | 1 | 82945 | 3 | 3.013 | 27529.0 |
148 | 2024-02-26 15:20:54 | yoghourt | 3 | 146162 | 9 | 12.190 | 11990.3 |
147 | 2024-02-26 15:20:52 | yoghourt | 2 | 121059 | 5 | 6.060 | 19976.7 |
146 | 2024-02-26 12:07:56 | yoghourt | 4 | 161609 | 109 | 13.843 | 11674.4 |
145 | 2024-02-23 08:29:19 | yoghourt | 4 | 161609 | 109 | 11.643 | 13880.4 |
144 | 2024-02-23 08:29:20 | yoghourt | 3 | 146162 | 9 | 7.250 | 20160.3 |
143 | 2024-02-23 08:29:21 | yoghourt | 2 | 121059 | 5 | 3.860 | 31362.4 |
142 | 2024-02-23 04:38:00 | yoghourt | 1 | 82945 | 3 | 1.280 | 64800.8 |
141 | 2024-02-07 22:26:08 | yoghourt | 3 | 146162 | 9 | 16.206 | 9019.0 |
140 | 2024-02-07 22:26:07 | yoghourt | 2 | 121059 | 5 | 7.000 | 17294.1 |
139 | 2024-02-07 22:26:09 | yoghourt | 1 | 82945 | 3 | 4.766 | 17403.5 |
138 | 2024-02-07 22:24:37 | yoghourt | 4 | 161609 | 109 | 62.643 | 2579.8 |
137 | 2024-02-07 12:57:54 | yoghourt | 3 | 146162 | 9 | 11.220 | 13026.9 |
136 | 2024-02-07 12:57:58 | yoghourt | 2 | 121059 | 5 | 3.466 | 34927.6 |
135 | 2024-02-07 12:56:54 | yoghourt | 1 | 82945 | 3 | 1.390 | 59672.7 |
134 | 2024-02-06 00:01:58 | yoghourt | 4 | 161609 | 109 | 22.080 | 7319.2 |
133 | 2024-01-31 03:17:36 | yoghourt | 1 | 82945 | 3 | 1.423 | 58288.8 |
132 | 2024-01-27 13:10:41 | yoghourt | 1 | 82945 | 3 | 1.406 | 58993.6 |
131 | 2024-01-27 13:09:21 | yoghourt | 2 | 121059 | 5 | 3.546 | 34139.6 |
130 | 2024-01-27 13:09:17 | yoghourt | 3 | 146162 | 9 | 7.296 | 20033.2 |
129 | 2024-01-26 15:55:35 | yoghourt | 3 | 146162 | 9 | 8.046 | 18165.8 |
128 | 2024-01-26 15:55:39 | yoghourt | 2 | 121059 | 5 | 3.906 | 30993.1 |
127 | 2024-01-26 15:55:11 | yoghourt | 1 | 82945 | 3 | 1.403 | 59119.7 |
126 | 2024-01-25 20:15:15 | yoghourt | 4 | 161609 | 109 | 21.580 | 7488.8 |
125 | 2024-01-23 03:02:29 | yoghourt | 4 | 161609 | 109 | 27.300 | 5919.7 |
124 | 2024-01-23 03:02:27 | yoghourt | 2 | 121059 | 5 | 7.156 | 16917.1 |
123 | 2024-01-23 03:02:21 | yoghourt | 3 | 146162 | 9 | 8.576 | 17043.1 |
122 | 2024-01-23 02:11:14 | yoghourt | 1 | 82945 | 3 | 1.236 | 67107.6 |
121 | 2023-12-18 11:47:24 | yoghourt | 1 | 82945 | 3 | 1.220 | 67987.7 |
120 | 2023-12-05 18:00:54 | yoghourt | 2 | 121059 | 5 | 3.153 | 38394.9 |
119 | 2023-11-30 13:42:11 | yoghourt | 4 | 161609 | 109 | 25.723 | 6282.7 |
118 | 2023-10-24 14:06:30 | yoghourt | 1 | 82945 | 3 | 1.360 | 60989.0 |
117 | 2023-10-06 11:18:24 | yoghourt | 1 | 82945 | 3 | 1.343 | 61761.0 |
116 | 2023-09-02 10:40:34 | yoghourt | 2 | 121059 | 5 | 2.986 | 40542.2 |
115 | 2023-08-28 20:57:55 | yoghourt | 4 | 161609 | 109 | 11.516 | 14033.4 |
114 | 2023-08-01 23:39:55 | yoghourt | 1 | 82945 | 3 | 1.343 | 61761.0 |
113 | 2023-05-17 13:06:11 | yoghourt | 2 | 121059 | 5 | 2.966 | 40815.6 |
112 | 2023-05-14 04:06:10 | yoghourt | 4 | 161609 | 109 | 10.110 | 15985.1 |
111 | 2023-04-27 10:06:47 | yoghourt | 1 | 82945 | 3 | 1.390 | 59672.7 |
110 | 2023-02-26 18:20:06 | yoghourt | 2 | 121059 | 5 | 3.096 | 39101.7 |
109 | 2023-02-20 10:57:28 | yoghourt | 4 | 161609 | 109 | 9.936 | 16265.0 |
108 | 2023-02-17 05:02:24 | yoghourt | 1 | 82945 | 3 | 1.220 | 67987.7 |
107 | 2022-12-16 06:05:31 | yoghourt | 1 | 82945 | 3 | 2.406 | 34474.2 |
106 | 2022-12-08 15:03:52 | yoghourt | 2 | 121059 | 5 | 2.970 | 40760.6 |
105 | 2022-12-02 15:39:34 | yoghourt | 4 | 161609 | 109 | 9.873 | 16368.8 |
104 | 2022-09-30 16:00:32 | yoghourt | 4 | 161609 | 109 | 9.986 | 16183.6 |
103 | 2022-08-30 05:49:09 | yoghourt | 4 | 161609 | 109 | 9.876 | 16363.8 |
102 | 2022-08-22 12:02:03 | yoghourt | 1 | 82945 | 3 | 1.216 | 68211.3 |
101 | 2022-08-20 02:12:06 | yoghourt | 1 | 82945 | 3 | 1.216 | 68211.3 |
100 | 2022-07-24 06:11:04 | yoghourt | 2 | 121059 | 5 | 2.983 | 40583.0 |
99 | 2022-07-10 21:12:46 | yoghourt | 4 | 161609 | 109 | 9.983 | 16188.4 |
98 | 2022-04-25 02:28:28 | yoghourt | 1 | 82945 | 3 | 1.233 | 67270.9 |
97 | 2021-05-02 05:25:40 | yoghourt | 1 | 82945 | 3 | 1.283 | 64649.3 |
96 | 2021-03-31 11:59:49 | yoghourt | 1 | 82945 | 3 | 1.343 | 61761.0 |
95 | 2021-03-05 06:42:19 | yoghourt | 1 | 82945 | 3 | 1.250 | 66356.0 |
94 | 2020-10-31 21:54:07 | yoghourt | 1 | 82945 | 3 | 1.423 | 58288.8 |
93 | 2020-10-26 05:59:56 | yoghourt | 1 | 82945 | 3 | 1.220 | 67987.7 |
92 | 2020-10-26 03:02:35 | yoghourt | 1 | 82945 | 3 | 2.763 | 30019.9 |
91 | 2020-03-28 16:11:03 | yoghourt | 1 | 82945 | 3 | 1.390 | 59672.7 |
90 | 2020-03-24 18:51:46 | yoghourt | 1 | 82945 | 3 | 1.513 | 54821.5 |
89 | 2020-02-24 20:08:35 | yoghourt | 1 | 82945 | 3 | 2.860 | 29001.7 |
88 | 2020-02-20 01:19:50 | yoghourt | 1 | 82945 | 3 | 1.436 | 57761.1 |
87 | 2020-02-18 02:13:59 | yoghourt | 1 | 82945 | 3 | 3.140 | 26415.6 |
86 | 2020-02-10 00:17:37 | yoghourt | 1 | 82945 | 3 | 1.343 | 61761.0 |
85 | 2020-01-30 15:01:30 | yoghourt | 1 | 82945 | 3 | 2.656 | 31229.3 |
84 | 2020-01-27 23:19:53 | yoghourt | 1 | 82945 | 3 | 1.453 | 57085.3 |
83 | 2020-01-23 11:08:45 | yoghourt | 1 | 82945 | 3 | 2.860 | 29001.7 |
82 | 2020-01-22 08:24:44 | yoghourt | 1 | 82945 | 3 | 3.046 | 27230.8 |
81 | 2020-01-16 15:54:36 | yoghourt | 1 | 82945 | 3 | 1.546 | 53651.4 |
80 | 2020-01-02 14:29:41 | yoghourt | 1 | 82945 | 3 | 1.860 | 44594.1 |