History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lookalikes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
164 | 2024-04-30 12:02:28 | lookalikes | 1 | 67641 | 2 | 1.190 | 56841.2 |
163 | 2024-04-28 14:48:01 | lookalikes | 1 | 67641 | 2 | 2.360 | 28661.4 |
162 | 2024-04-28 13:33:50 | lookalikes | 4 | 161450 | 118 | 38.003 | 4248.3 |
161 | 2024-04-28 13:33:47 | lookalikes | 3 | 140603 | 7 | 15.080 | 9323.8 |
160 | 2024-04-28 13:33:48 | lookalikes | 2 | 108824 | 2 | 12.140 | 8964.1 |
159 | 2024-04-28 12:19:26 | lookalikes | 1 | 67641 | 2 | 1.046 | 64666.3 |
158 | 2024-04-07 22:43:39 | lookalikes | 1 | 67641 | 2 | 1.220 | 55443.4 |
157 | 2024-04-05 20:19:22 | lookalikes | 1 | 67641 | 2 | 1.093 | 61885.6 |
156 | 2024-03-30 23:11:13 | lookalikes | 1 | 67641 | 2 | 1.173 | 57665.0 |
155 | 2024-02-27 17:02:51 | lookalikes | 1 | 67641 | 2 | 1.063 | 63632.2 |
154 | 2024-02-18 22:34:58 | lookalikes | 1 | 67641 | 2 | 1.250 | 54112.8 |
153 | 2024-01-31 01:00:51 | lookalikes | 1 | 67641 | 2 | 1.000 | 67641.0 |
152 | 2024-01-29 03:22:49 | lookalikes | 1 | 67641 | 2 | 1.156 | 58513.0 |
151 | 2024-01-26 23:43:03 | lookalikes | 1 | 67641 | 2 | 1.143 | 59178.5 |
150 | 2024-01-26 23:42:59 | lookalikes | 1 | 67641 | 2 | 1.156 | 58513.0 |
149 | 2023-12-02 03:12:43 | lookalikes | 1 | 67641 | 2 | 1.013 | 66773.0 |
148 | 2023-11-23 16:08:14 | lookalikes | 1 | 67641 | 2 | 1.140 | 59334.2 |
147 | 2023-09-10 03:34:27 | lookalikes | 1 | 67641 | 2 | 1.016 | 66575.8 |
146 | 2023-06-23 11:45:13 | lookalikes | 1 | 67641 | 2 | 0.983 | 68810.8 |
145 | 2023-04-07 07:31:30 | lookalikes | 1 | 67641 | 2 | 0.986 | 68601.4 |
144 | 2023-01-30 15:39:06 | lookalikes | 1 | 67641 | 2 | 0.966 | 70021.7 |
143 | 2022-11-28 14:21:55 | lookalikes | 1 | 67641 | 2 | 1.140 | 59334.2 |
142 | 2022-10-20 08:20:00 | lookalikes | 1 | 67641 | 2 | 1.143 | 59178.5 |
141 | 2022-07-24 16:24:47 | lookalikes | 1 | 67641 | 2 | 1.233 | 54858.9 |
140 | 2022-07-22 08:51:26 | lookalikes | 1 | 67641 | 2 | 0.953 | 70976.9 |
139 | 2022-05-16 11:15:10 | lookalikes | 1 | 67641 | 2 | 1.203 | 56226.9 |
138 | 2020-11-04 16:18:23 | lookalikes | 1 | 67641 | 2 | 1.000 | 67641.0 |
137 | 2020-10-27 04:50:23 | lookalikes | 1 | 67641 | 2 | 1.030 | 65670.9 |
136 | 2020-03-12 04:18:41 | lookalikes | 1 | 67641 | 2 | 1.093 | 61885.6 |
135 | 2020-03-01 17:04:09 | lookalikes | 1 | 67641 | 2 | 2.076 | 32582.4 |
134 | 2020-02-27 14:56:34 | lookalikes | 1 | 67641 | 2 | 1.203 | 56226.9 |
133 | 2020-02-19 21:20:05 | lookalikes | 1 | 67641 | 2 | 2.563 | 26391.3 |
132 | 2020-02-08 21:58:24 | lookalikes | 1 | 67641 | 2 | 1.936 | 34938.5 |
131 | 2020-02-06 01:29:56 | lookalikes | 1 | 67641 | 2 | 1.216 | 55625.8 |
130 | 2020-02-05 00:06:56 | lookalikes | 1 | 67641 | 2 | 1.126 | 60071.9 |
129 | 2020-01-18 15:42:23 | lookalikes | 1 | 67641 | 2 | 1.250 | 54112.8 |
128 | 2020-01-11 15:28:36 | lookalikes | 1 | 67641 | 2 | 1.143 | 59178.5 |
127 | 2020-01-05 04:46:31 | lookalikes | 1 | 67641 | 2 | 1.126 | 60071.9 |
126 | 2019-11-30 13:22:57 | lookalikes | 1 | 67641 | 2 | 1.156 | 58513.0 |
125 | 2019-08-29 01:09:24 | lookalikes | 1 | 67641 | 2 | 1.070 | 63215.9 |
124 | 2019-08-25 23:04:37 | lookalikes | 1 | 67641 | 2 | 1.063 | 63632.2 |
123 | 2019-05-10 13:17:54 | lookalikes | 1 | 67641 | 2 | 1.033 | 65480.2 |
122 | 2019-03-27 10:50:20 | lookalikes | 1 | 67641 | 2 | 1.000 | 67641.0 |
121 | 2019-01-05 00:23:30 | lookalikes | 1 | 67641 | 2 | 1.130 | 59859.3 |
120 | 2019-01-01 16:24:36 | lookalikes | 1 | 67641 | 2 | 1.103 | 61324.6 |
119 | 2018-08-08 15:32:57 | lookalikes | 1 | 67641 | 2 | 1.000 | 67641.0 |
118 | 2018-05-13 06:08:06 | lookalikes | 1 | 67641 | 2 | 1.203 | 56226.9 |
117 | 2018-05-05 12:08:18 | lookalikes | 1 | 67641 | 2 | 0.973 | 69518.0 |
116 | 2018-01-12 21:08:43 | lookalikes | 1 | 67641 | 2 | 1.363 | 49626.6 |
115 | 2017-11-08 21:07:08 | lookalikes | 1 | 67641 | 2 | 1.430 | 47301.4 |
114 | 2017-09-05 07:14:05 | lookalikes | 1 | 67641 | 2 | 1.270 | 53260.6 |
113 | 2017-02-09 01:00:04 | lookalikes | 1 | 67641 | 2 | 1.640 | 41244.5 |
112 | 2017-02-09 00:57:29 | lookalikes | 1 | 67641 | 2 | 1.313 | 51516.4 |
111 | 2017-01-04 16:08:18 | lookalikes | 1 | 67641 | 2 | 1.210 | 55901.7 |
110 | 2016-12-28 20:31:21 | lookalikes | 1 | 67641 | 2 | 3.446 | 19628.8 |
109 | 2016-10-02 06:52:37 | lookalikes | 1 | 67641 | 2 | 1.353 | 49993.3 |
108 | 2016-08-16 23:17:49 | lookalikes | 4 | 161450 | 118 | 14.250 | 11329.8 |
107 | 2016-08-01 09:19:09 | lookalikes | 1 | 67641 | 2 | 1.546 | 43752.3 |
106 | 2016-07-18 07:48:30 | lookalikes | 2 | 108824 | 2 | 4.746 | 22929.6 |
105 | 2016-07-17 07:33:21 | lookalikes | 3 | 140603 | 7 | 7.943 | 17701.5 |
104 | 2016-07-13 23:33:56 | lookalikes | 1 | 67641 | 2 | 1.706 | 39648.9 |
103 | 2016-07-10 08:24:03 | lookalikes | 4 | 161450 | 118 | 19.456 | 8298.2 |
102 | 2016-07-08 12:44:49 | lookalikes | 2 | 108824 | 2 | 10.456 | 10407.8 |
101 | 2016-07-08 00:27:42 | lookalikes | 3 | 140603 | 7 | 10.350 | 13584.8 |
100 | 2016-07-06 23:32:17 | lookalikes | 4 | 161450 | 118 | 14.056 | 11486.2 |
99 | 2016-07-04 22:51:42 | lookalikes | 1 | 67641 | 2 | 1.703 | 39718.7 |
98 | 2016-06-16 16:02:47 | lookalikes | 1 | 67641 | 2 | 3.093 | 21869.1 |
97 | 2016-06-08 23:24:14 | lookalikes | 1 | 67641 | 2 | 1.540 | 43922.7 |
96 | 2016-06-07 08:21:28 | lookalikes | 1 | 67641 | 2 | 1.570 | 43083.4 |
95 | 2016-05-21 12:37:48 | lookalikes | 1 | 67641 | 2 | 3.326 | 20337.0 |
94 | 2016-05-19 08:52:54 | lookalikes | 1 | 67641 | 2 | 2.013 | 33602.1 |
93 | 2016-05-04 22:28:34 | lookalikes | 1 | 67641 | 2 | 1.130 | 59859.3 |
92 | 2016-04-27 04:23:23 | lookalikes | 1 | 67641 | 2 | 1.130 | 59859.3 |
91 | 2016-03-03 10:21:05 | lookalikes | 1 | 67641 | 2 | 1.133 | 59700.8 |
90 | 2016-02-06 11:19:10 | lookalikes | 1 | 67641 | 2 | 1.063 | 63632.2 |
89 | 2015-12-16 02:31:27 | lookalikes | 1 | 67641 | 2 | 1.233 | 54858.9 |
88 | 2015-11-28 12:18:55 | lookalikes | 2 | 108824 | 2 | 3.060 | 35563.4 |
87 | 2015-11-28 12:18:49 | lookalikes | 3 | 140603 | 7 | 6.520 | 21564.9 |
86 | 2015-11-20 19:26:48 | lookalikes | 4 | 161450 | 118 | 23.016 | 7014.7 |
85 | 2015-11-20 19:20:57 | lookalikes | 1 | 67641 | 2 | 1.070 | 63215.9 |
84 | 2015-11-16 21:23:25 | lookalikes | 1 | 67641 | 2 | 1.280 | 52844.5 |
83 | 2015-06-29 04:30:33 | lookalikes | 1 | 67641 | 2 | 2.180 | 31028.0 |
82 | 2015-05-28 00:47:38 | lookalikes | 1 | 67641 | 2 | 1.283 | 52721.0 |
81 | 2015-05-28 00:41:57 | lookalikes | 1 | 67641 | 2 | 1.350 | 50104.4 |
80 | 2015-05-26 00:56:24 | lookalikes | 4 | 161450 | 118 | 17.690 | 9126.6 |
79 | 2015-04-19 07:47:07 | lookalikes | 1 | 67641 | 2 | 1.306 | 51792.5 |
78 | 2015-04-15 18:14:18 | lookalikes | 1 | 67641 | 2 | 1.293 | 52313.2 |
77 | 2015-04-05 10:14:15 | lookalikes | 2 | 108824 | 2 | 3.776 | 28819.9 |
76 | 2015-04-05 09:44:57 | lookalikes | 3 | 140603 | 7 | 7.593 | 18517.5 |
75 | 2015-04-04 19:29:20 | lookalikes | 1 | 67641 | 2 | 2.916 | 23196.5 |
74 | 2015-03-19 00:00:13 | lookalikes | 4 | 161450 | 118 | 29.016 | 5564.2 |
73 | 2015-03-17 02:01:46 | lookalikes | 4 | 161450 | 118 | 18.260 | 8841.7 |
72 | 2015-03-15 12:59:25 | lookalikes | 4 | 161450 | 118 | 17.953 | 8992.9 |
71 | 2015-03-06 18:36:04 | lookalikes | 4 | 161450 | 118 | 18.996 | 8499.2 |
70 | 2015-03-06 18:26:18 | lookalikes | 1 | 67641 | 2 | 1.390 | 48662.6 |
69 | 2015-02-08 22:47:51 | lookalikes | 1 | 67641 | 2 | 1.230 | 54992.7 |
68 | 2015-01-20 02:35:44 | lookalikes | 1 | 67641 | 2 | 1.316 | 51398.9 |
67 | 2015-01-19 04:05:46 | lookalikes | 1 | 67641 | 2 | 2.636 | 25660.5 |
66 | 2015-01-18 19:28:07 | lookalikes | 1 | 67641 | 2 | 1.800 | 37578.3 |
65 | 2015-01-18 04:40:51 | lookalikes | 1 | 67641 | 2 | 1.270 | 53260.6 |