History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"zarzuela"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
168 | 2024-04-28 20:37:21 | zarzuela | 1 | 82945 | 2 | 1.436 | 57761.1 |
167 | 2024-04-28 20:37:11 | zarzuela | 2 | 121059 | 2 | 3.563 | 33976.7 |
166 | 2024-04-28 20:36:53 | zarzuela | 3 | 146162 | 4 | 12.186 | 11994.3 |
165 | 2024-04-13 03:32:29 | zarzuela | 1 | 82945 | 2 | 1.890 | 43886.2 |
164 | 2024-04-13 03:32:25 | zarzuela | 1 | 82945 | 2 | 1.406 | 58993.6 |
163 | 2024-04-13 03:32:23 | zarzuela | 1 | 82945 | 2 | 1.423 | 58288.8 |
162 | 2024-04-13 03:32:17 | zarzuela | 3 | 146162 | 4 | 7.076 | 20656.0 |
161 | 2024-04-10 22:50:31 | zarzuela | 4 | 161609 | 139 | 41.316 | 3911.5 |
160 | 2024-04-09 22:20:53 | zarzuela | 4 | 161609 | 139 | 13.110 | 12327.2 |
159 | 2024-04-09 02:21:43 | zarzuela | 4 | 161609 | 139 | 17.500 | 9234.8 |
158 | 2024-04-03 06:41:54 | zarzuela | 4 | 161609 | 139 | 30.066 | 5375.1 |
157 | 2024-04-03 06:41:48 | zarzuela | 3 | 146162 | 4 | 24.800 | 5893.6 |
156 | 2024-04-01 18:42:22 | zarzuela | 4 | 161609 | 139 | 33.816 | 4779.1 |
155 | 2024-04-01 16:23:04 | zarzuela | 3 | 146162 | 4 | 24.140 | 6054.8 |
154 | 2024-04-01 16:23:16 | zarzuela | 2 | 121059 | 2 | 8.733 | 13862.2 |
153 | 2024-04-01 16:23:00 | zarzuela | 4 | 161609 | 139 | 18.096 | 8930.6 |
152 | 2024-04-01 16:22:58 | zarzuela | 2 | 121059 | 2 | 4.326 | 27984.0 |
151 | 2024-04-01 16:22:55 | zarzuela | 1 | 82945 | 2 | 1.563 | 53067.8 |
150 | 2024-03-06 23:18:15 | zarzuela | 4 | 161609 | 139 | 32.953 | 4904.2 |
149 | 2024-03-06 04:09:03 | zarzuela | 4 | 161609 | 139 | 34.546 | 4678.1 |
148 | 2024-03-06 01:55:18 | zarzuela | 3 | 146162 | 4 | 16.563 | 8824.6 |
147 | 2024-03-06 01:55:14 | zarzuela | 4 | 161609 | 139 | 14.690 | 11001.3 |
146 | 2024-03-06 01:55:16 | zarzuela | 2 | 121059 | 2 | 7.110 | 17026.6 |
145 | 2024-03-06 01:55:12 | zarzuela | 1 | 82945 | 2 | 3.110 | 26670.4 |
144 | 2024-02-26 00:42:42 | zarzuela | 3 | 146162 | 4 | 14.736 | 9918.7 |
143 | 2024-02-26 00:42:34 | zarzuela | 2 | 121059 | 2 | 8.393 | 14423.8 |
142 | 2024-02-26 00:42:30 | zarzuela | 1 | 82945 | 2 | 1.670 | 49667.7 |
141 | 2024-02-25 02:57:47 | zarzuela | 1 | 82945 | 2 | 1.313 | 63172.1 |
140 | 2024-02-21 04:11:41 | zarzuela | 1 | 82945 | 2 | 1.466 | 56579.1 |
139 | 2024-02-10 10:23:52 | zarzuela | 3 | 146162 | 4 | 15.033 | 9722.7 |
138 | 2024-02-10 10:23:48 | zarzuela | 2 | 121059 | 2 | 9.576 | 12641.9 |
137 | 2024-02-10 09:49:28 | zarzuela | 1 | 82945 | 2 | 1.233 | 67270.9 |
136 | 2024-02-05 17:55:37 | zarzuela | 4 | 161609 | 139 | 14.063 | 11491.8 |
135 | 2024-02-05 01:52:52 | zarzuela | 4 | 161609 | 139 | 29.266 | 5522.1 |
134 | 2024-02-01 03:53:08 | zarzuela | 4 | 161609 | 139 | 13.420 | 12042.4 |
133 | 2024-02-01 03:53:20 | zarzuela | 1 | 82945 | 2 | 1.486 | 55817.6 |
132 | 2024-02-01 03:52:48 | zarzuela | 2 | 121059 | 2 | 3.780 | 32026.2 |
131 | 2024-02-01 03:52:36 | zarzuela | 2 | 121059 | 2 | 4.466 | 27106.8 |
130 | 2024-02-01 03:52:27 | zarzuela | 3 | 146162 | 4 | 11.250 | 12992.2 |
129 | 2024-02-01 03:52:24 | zarzuela | 4 | 161609 | 139 | 14.033 | 11516.4 |
128 | 2024-02-01 03:52:28 | zarzuela | 3 | 146162 | 4 | 9.156 | 15963.5 |
127 | 2024-01-18 21:43:43 | zarzuela | 1 | 82945 | 2 | 1.470 | 56425.2 |
126 | 2024-01-17 22:54:21 | zarzuela | 3 | 146162 | 4 | 7.046 | 20744.0 |
125 | 2023-12-25 21:20:20 | zarzuela | 4 | 161609 | 139 | 11.610 | 13919.8 |
124 | 2023-12-07 10:24:54 | zarzuela | 1 | 82945 | 2 | 1.266 | 65517.4 |
123 | 2023-12-04 16:44:36 | zarzuela | 1 | 82945 | 2 | 1.263 | 65673.0 |
122 | 2023-11-25 13:41:47 | zarzuela | 1 | 82945 | 2 | 1.453 | 57085.3 |
121 | 2023-10-27 22:38:45 | zarzuela | 3 | 146162 | 4 | 7.266 | 20115.9 |
120 | 2023-09-30 22:47:45 | zarzuela | 4 | 161609 | 139 | 14.406 | 11218.2 |
119 | 2023-09-27 09:48:58 | zarzuela | 4 | 161609 | 139 | 13.266 | 12182.2 |
118 | 2023-09-11 07:40:52 | zarzuela | 1 | 82945 | 2 | 1.563 | 53067.8 |
117 | 2023-09-02 21:00:42 | zarzuela | 1 | 82945 | 2 | 1.373 | 60411.5 |
116 | 2023-08-06 08:08:33 | zarzuela | 3 | 146162 | 4 | 6.890 | 21213.6 |
115 | 2023-07-07 10:56:14 | zarzuela | 4 | 161609 | 139 | 10.376 | 15575.3 |
114 | 2023-06-23 06:55:29 | zarzuela | 1 | 82945 | 2 | 1.266 | 65517.4 |
113 | 2023-04-16 14:33:55 | zarzuela | 3 | 146162 | 4 | 5.936 | 24623.0 |
112 | 2023-04-04 12:58:15 | zarzuela | 1 | 82945 | 2 | 1.360 | 60989.0 |
111 | 2023-03-28 14:16:43 | zarzuela | 4 | 161609 | 139 | 10.220 | 15813.0 |
110 | 2023-03-10 02:28:46 | zarzuela | 1 | 82945 | 2 | 1.360 | 60989.0 |
109 | 2023-01-23 12:32:43 | zarzuela | 3 | 146162 | 4 | 7.436 | 19656.0 |
108 | 2023-01-11 15:14:15 | zarzuela | 1 | 82945 | 2 | 1.220 | 67987.7 |
107 | 2022-12-24 17:50:40 | zarzuela | 4 | 161609 | 139 | 11.143 | 14503.2 |
106 | 2022-11-03 21:42:25 | zarzuela | 3 | 146162 | 4 | 6.250 | 23385.9 |
105 | 2022-10-20 09:57:44 | zarzuela | 1 | 82945 | 2 | 1.220 | 67987.7 |
104 | 2022-09-14 14:09:32 | zarzuela | 1 | 82945 | 2 | 1.216 | 68211.3 |
103 | 2022-08-24 16:40:19 | zarzuela | 4 | 161609 | 139 | 12.453 | 12977.5 |
102 | 2022-05-17 10:06:08 | zarzuela | 3 | 146162 | 4 | 8.203 | 17818.1 |
101 | 2022-05-03 20:19:18 | zarzuela | 1 | 82945 | 2 | 1.486 | 55817.6 |
100 | 2022-03-13 23:01:54 | zarzuela | 1 | 82945 | 2 | 1.266 | 65517.4 |
99 | 2022-01-22 19:09:34 | zarzuela | 1 | 82945 | 2 | 1.266 | 65517.4 |
98 | 2022-01-20 14:41:07 | zarzuela | 1 | 82945 | 2 | 1.360 | 60989.0 |
97 | 2021-11-22 11:57:00 | zarzuela | 1 | 82945 | 2 | 1.516 | 54713.1 |
96 | 2021-10-06 03:28:58 | zarzuela | 1 | 82945 | 2 | 1.236 | 67107.6 |
95 | 2021-09-28 15:48:59 | zarzuela | 1 | 82945 | 2 | 2.706 | 30652.3 |
94 | 2021-09-03 22:04:23 | zarzuela | 1 | 82945 | 2 | 1.406 | 58993.6 |
93 | 2021-09-01 15:36:30 | zarzuela | 1 | 82945 | 2 | 1.233 | 67270.9 |
92 | 2021-08-17 08:43:12 | zarzuela | 1 | 82945 | 2 | 1.233 | 67270.9 |
91 | 2021-05-26 13:36:18 | zarzuela | 1 | 82945 | 2 | 1.483 | 55930.5 |
90 | 2021-05-04 22:47:22 | zarzuela | 1 | 82945 | 2 | 1.483 | 55930.5 |
89 | 2021-04-03 00:51:33 | zarzuela | 1 | 82945 | 2 | 1.343 | 61761.0 |
88 | 2021-02-21 03:34:03 | zarzuela | 1 | 82945 | 2 | 1.313 | 63172.1 |
87 | 2021-02-11 11:54:04 | zarzuela | 1 | 82945 | 2 | 1.250 | 66356.0 |
86 | 2020-10-18 05:18:13 | zarzuela | 1 | 82945 | 2 | 1.360 | 60989.0 |
85 | 2020-05-10 21:23:36 | zarzuela | 1 | 82945 | 2 | 1.283 | 64649.3 |
84 | 2020-03-30 02:48:32 | zarzuela | 1 | 82945 | 2 | 1.423 | 58288.8 |
83 | 2020-03-29 01:07:25 | zarzuela | 1 | 82945 | 2 | 1.813 | 45750.1 |
82 | 2020-03-28 23:57:23 | zarzuela | 1 | 82945 | 2 | 1.533 | 54106.3 |
81 | 2020-03-28 00:02:13 | zarzuela | 1 | 82945 | 2 | 1.436 | 57761.1 |
80 | 2020-03-27 16:29:38 | zarzuela | 1 | 82945 | 2 | 1.423 | 58288.8 |
79 | 2020-02-20 01:06:52 | zarzuela | 1 | 82945 | 2 | 2.140 | 38759.3 |
78 | 2020-02-12 14:59:48 | zarzuela | 1 | 82945 | 2 | 3.126 | 26533.9 |
77 | 2020-01-30 16:53:05 | zarzuela | 1 | 82945 | 2 | 2.656 | 31229.3 |
76 | 2020-01-22 01:50:35 | zarzuela | 1 | 82945 | 2 | 1.563 | 53067.8 |
75 | 2020-01-17 11:26:27 | zarzuela | 1 | 82945 | 2 | 1.626 | 51011.7 |
74 | 2020-01-08 09:54:17 | zarzuela | 1 | 82945 | 2 | 1.563 | 53067.8 |
73 | 2019-12-20 06:19:54 | zarzuela | 1 | 82945 | 2 | 1.450 | 57203.4 |
72 | 2018-12-09 17:28:51 | zarzuela | 1 | 82945 | 2 | 1.463 | 56695.1 |
71 | 2018-11-20 18:11:14 | zarzuela | 1 | 82945 | 2 | 1.233 | 67270.9 |
70 | 2018-11-11 03:56:03 | zarzuela | 1 | 82945 | 2 | 1.303 | 63656.9 |
69 | 2018-07-21 13:04:31 | zarzuela | 1 | 82945 | 2 | 1.226 | 67655.0 |