History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"passerines"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
169 | 2024-04-28 07:54:39 | passerines | 3 | 140603 | 36 | 6.563 | 21423.6 |
168 | 2024-04-26 15:23:28 | passerines | 1 | 67641 | 2 | 1.220 | 55443.4 |
167 | 2024-04-25 15:33:32 | passerines | 1 | 67641 | 2 | 1.186 | 57032.9 |
166 | 2024-04-21 06:40:27 | passerines | 1 | 67641 | 2 | 1.096 | 61716.2 |
165 | 2024-04-19 13:48:32 | passerines | 1 | 67641 | 2 | 1.233 | 54858.9 |
164 | 2024-04-10 03:57:39 | passerines | 1 | 67641 | 2 | 1.216 | 55625.8 |
163 | 2024-04-06 07:15:45 | passerines | 1 | 67641 | 2 | 1.936 | 34938.5 |
162 | 2024-03-25 00:06:43 | passerines | 1 | 67641 | 2 | 1.033 | 65480.2 |
161 | 2024-03-15 09:36:56 | passerines | 4 | 161450 | 368 | 40.393 | 3997.0 |
160 | 2024-03-15 09:36:52 | passerines | 3 | 140603 | 36 | 16.330 | 8610.1 |
159 | 2024-03-15 09:36:52 | passerines | 2 | 108824 | 3 | 10.860 | 10020.6 |
158 | 2024-03-15 07:24:54 | passerines | 1 | 67641 | 2 | 1.153 | 58665.2 |
157 | 2024-03-10 22:58:16 | passerines | 1 | 67641 | 2 | 1.016 | 66575.8 |
156 | 2024-03-08 21:01:15 | passerines | 1 | 67641 | 2 | 1.126 | 60071.9 |
155 | 2024-03-02 05:46:03 | passerines | 1 | 67641 | 2 | 2.813 | 24045.9 |
154 | 2024-02-20 00:48:11 | passerines | 1 | 67641 | 2 | 3.486 | 19403.6 |
153 | 2024-02-10 12:28:51 | passerines | 4 | 161450 | 368 | 37.410 | 4315.7 |
152 | 2024-02-10 12:28:55 | passerines | 3 | 140603 | 36 | 21.830 | 6440.8 |
151 | 2024-02-10 12:28:56 | passerines | 2 | 108824 | 3 | 3.830 | 28413.6 |
150 | 2024-02-09 20:46:59 | passerines | 1 | 67641 | 2 | 1.203 | 56226.9 |
149 | 2024-02-08 09:00:42 | passerines | 1 | 67641 | 2 | 1.686 | 40119.2 |
148 | 2024-02-06 03:20:14 | passerines | 1 | 67641 | 2 | 1.173 | 57665.0 |
147 | 2024-01-20 23:50:22 | passerines | 1 | 67641 | 2 | 1.046 | 64666.3 |
146 | 2024-01-09 02:44:08 | passerines | 1 | 67641 | 2 | 1.046 | 64666.3 |
145 | 2023-12-21 13:16:58 | passerines | 1 | 67641 | 2 | 1.016 | 66575.8 |
144 | 2023-12-20 02:03:28 | passerines | 3 | 140603 | 36 | 6.283 | 22378.3 |
143 | 2023-10-14 16:19:00 | passerines | 1 | 67641 | 2 | 1.186 | 57032.9 |
142 | 2023-10-08 02:21:46 | passerines | 1 | 67641 | 2 | 1.046 | 64666.3 |
141 | 2023-10-06 23:20:09 | passerines | 1 | 67641 | 2 | 1.170 | 57812.8 |
140 | 2023-09-20 14:31:33 | passerines | 3 | 140603 | 36 | 6.406 | 21948.6 |
139 | 2023-08-27 05:39:37 | passerines | 1 | 67641 | 2 | 1.153 | 58665.2 |
138 | 2023-08-04 18:19:27 | passerines | 1 | 67641 | 2 | 1.030 | 65670.9 |
137 | 2023-06-27 06:54:19 | passerines | 3 | 140603 | 36 | 6.216 | 22619.5 |
136 | 2023-05-06 11:20:32 | passerines | 1 | 67641 | 2 | 1.016 | 66575.8 |
135 | 2023-04-28 22:14:48 | passerines | 1 | 67641 | 2 | 1.033 | 65480.2 |
134 | 2023-03-22 21:37:38 | passerines | 3 | 140603 | 36 | 5.360 | 26231.9 |
133 | 2023-02-27 04:43:32 | passerines | 1 | 67641 | 2 | 1.156 | 58513.0 |
132 | 2022-12-28 23:51:02 | passerines | 1 | 67641 | 2 | 1.126 | 60071.9 |
131 | 2022-12-26 08:40:52 | passerines | 1 | 67641 | 2 | 1.123 | 60232.4 |
130 | 2022-12-22 05:38:15 | passerines | 3 | 140603 | 36 | 6.143 | 22888.3 |
129 | 2022-09-13 06:17:46 | passerines | 1 | 67641 | 2 | 1.080 | 62630.6 |
128 | 2022-08-25 02:03:50 | passerines | 1 | 67641 | 2 | 1.173 | 57665.0 |
127 | 2022-08-21 03:21:08 | passerines | 3 | 140603 | 36 | 5.533 | 25411.7 |
126 | 2022-07-03 11:26:06 | passerines | 1 | 67641 | 2 | 1.016 | 66575.8 |
125 | 2022-04-24 08:10:24 | passerines | 1 | 67641 | 2 | 1.030 | 65670.9 |
124 | 2022-03-21 05:30:24 | passerines | 1 | 67641 | 2 | 1.030 | 65670.9 |
123 | 2022-01-01 13:59:08 | passerines | 1 | 67641 | 2 | 1.076 | 62863.4 |
122 | 2021-09-15 20:35:14 | passerines | 1 | 67641 | 2 | 2.313 | 29243.8 |
121 | 2021-06-12 11:28:08 | passerines | 1 | 67641 | 2 | 1.156 | 58513.0 |
120 | 2021-03-13 01:35:11 | passerines | 1 | 67641 | 2 | 1.030 | 65670.9 |
119 | 2021-02-25 08:00:59 | passerines | 1 | 67641 | 2 | 1.076 | 62863.4 |
118 | 2021-02-01 21:05:05 | passerines | 1 | 67641 | 2 | 1.126 | 60071.9 |
117 | 2021-01-05 12:07:50 | passerines | 1 | 67641 | 2 | 1.046 | 64666.3 |
116 | 2020-12-05 22:24:17 | passerines | 1 | 67641 | 2 | 1.110 | 60937.8 |
115 | 2020-11-12 22:45:52 | passerines | 1 | 67641 | 2 | 1.030 | 65670.9 |
114 | 2020-10-19 18:24:39 | passerines | 1 | 67641 | 2 | 1.156 | 58513.0 |
113 | 2020-10-18 07:24:51 | passerines | 1 | 67641 | 2 | 1.330 | 50857.9 |
112 | 2020-08-21 09:14:48 | passerines | 1 | 67641 | 2 | 1.063 | 63632.2 |
111 | 2020-05-10 21:04:26 | passerines | 1 | 67641 | 2 | 1.060 | 63812.3 |
110 | 2020-03-26 06:29:08 | passerines | 1 | 67641 | 2 | 2.453 | 27574.8 |
109 | 2020-02-25 14:19:34 | passerines | 1 | 67641 | 2 | 1.390 | 48662.6 |
108 | 2020-02-25 11:35:02 | passerines | 1 | 67641 | 2 | 3.736 | 18105.2 |
107 | 2020-02-24 01:08:06 | passerines | 1 | 67641 | 2 | 3.830 | 17660.8 |
106 | 2020-02-19 08:13:06 | passerines | 1 | 67641 | 2 | 1.266 | 53428.9 |
105 | 2020-02-18 19:25:47 | passerines | 1 | 67641 | 2 | 1.296 | 52192.1 |
104 | 2020-02-04 12:54:28 | passerines | 1 | 67641 | 2 | 2.360 | 28661.4 |
103 | 2020-02-04 09:35:08 | passerines | 1 | 67641 | 2 | 1.313 | 51516.4 |
102 | 2020-02-02 10:19:29 | passerines | 1 | 67641 | 2 | 2.406 | 28113.5 |
101 | 2020-01-30 07:46:39 | passerines | 1 | 67641 | 2 | 1.266 | 53428.9 |
100 | 2020-01-23 05:10:48 | passerines | 1 | 67641 | 2 | 1.296 | 52192.1 |
99 | 2020-01-23 04:19:09 | passerines | 1 | 67641 | 2 | 1.326 | 51011.3 |
98 | 2020-01-17 12:31:43 | passerines | 1 | 67641 | 2 | 2.453 | 27574.8 |
97 | 2020-01-11 21:11:21 | passerines | 1 | 67641 | 2 | 1.080 | 62630.6 |
96 | 2020-01-01 11:07:10 | passerines | 1 | 67641 | 2 | 1.420 | 47634.5 |
95 | 2019-12-31 05:26:50 | passerines | 1 | 67641 | 2 | 1.313 | 51516.4 |
94 | 2019-11-01 12:07:47 | passerines | 1 | 67641 | 2 | 1.126 | 60071.9 |
93 | 2019-10-29 07:24:20 | passerines | 1 | 67641 | 2 | 1.156 | 58513.0 |
92 | 2019-07-28 05:04:13 | passerines | 1 | 67641 | 2 | 1.030 | 65670.9 |
91 | 2019-07-24 21:14:51 | passerines | 1 | 67641 | 2 | 0.993 | 68117.8 |
90 | 2019-04-20 21:09:47 | passerines | 1 | 67641 | 2 | 1.010 | 66971.3 |
89 | 2019-01-30 21:41:45 | passerines | 1 | 67641 | 2 | 1.090 | 62056.0 |
88 | 2019-01-19 21:10:47 | passerines | 1 | 67641 | 2 | 1.253 | 53983.2 |
87 | 2018-12-28 15:58:16 | passerines | 1 | 67641 | 2 | 1.033 | 65480.2 |
86 | 2018-11-28 08:46:51 | passerines | 1 | 67641 | 2 | 0.983 | 68810.8 |
85 | 2018-09-01 07:06:07 | passerines | 1 | 67641 | 2 | 1.036 | 65290.5 |
84 | 2018-06-23 15:03:19 | passerines | 1 | 67641 | 2 | 1.106 | 61158.2 |
83 | 2018-06-14 20:16:55 | passerines | 1 | 67641 | 2 | 1.086 | 62284.5 |
82 | 2018-06-02 16:13:29 | passerines | 1 | 67641 | 2 | 1.080 | 62630.6 |
81 | 2018-05-08 03:43:01 | passerines | 1 | 67641 | 2 | 1.106 | 61158.2 |
80 | 2018-04-27 14:17:29 | passerines | 1 | 67641 | 2 | 1.053 | 64236.5 |
79 | 2018-04-25 01:30:21 | passerines | 1 | 67641 | 2 | 1.083 | 62457.1 |
78 | 2018-04-20 22:29:01 | passerines | 1 | 67641 | 2 | 1.020 | 66314.7 |
77 | 2018-04-19 14:55:21 | passerines | 1 | 67641 | 2 | 2.063 | 32787.7 |
76 | 2018-03-18 21:18:08 | passerines | 1 | 67641 | 2 | 1.356 | 49882.7 |
75 | 2017-10-17 09:07:22 | passerines | 1 | 67641 | 2 | 2.046 | 33060.1 |
74 | 2017-08-03 02:31:49 | passerines | 1 | 67641 | 2 | 1.336 | 50629.5 |
73 | 2017-07-27 10:48:43 | passerines | 1 | 67641 | 2 | 1.476 | 45827.2 |
72 | 2017-07-18 04:01:40 | passerines | 1 | 67641 | 2 | 1.486 | 45518.8 |
71 | 2017-06-21 06:08:47 | passerines | 1 | 67641 | 2 | 1.326 | 51011.3 |
70 | 2017-05-18 21:31:42 | passerines | 1 | 67641 | 2 | 1.620 | 41753.7 |