History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gunrunners"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
165 | 2024-05-02 16:39:02 | gunrunners | 1 | 67641 | 2 | 1.296 | 52192.1 |
164 | 2024-04-29 17:50:27 | gunrunners | 1 | 67641 | 2 | 1.733 | 39031.2 |
163 | 2024-04-29 13:24:22 | gunrunners | 1 | 67641 | 2 | 2.123 | 31861.0 |
162 | 2024-04-27 06:39:20 | gunrunners | 4 | 161450 | 76 | 38.363 | 4208.5 |
161 | 2024-04-26 10:01:24 | gunrunners | 4 | 161450 | 76 | 36.206 | 4459.2 |
160 | 2024-04-23 11:56:00 | gunrunners | 1 | 67641 | 2 | 1.563 | 43276.4 |
159 | 2024-04-13 18:09:37 | gunrunners | 1 | 67641 | 2 | 1.296 | 52192.1 |
158 | 2024-04-10 20:50:34 | gunrunners | 1 | 67641 | 2 | 4.563 | 14823.8 |
157 | 2024-03-28 10:36:55 | gunrunners | 1 | 67641 | 2 | 1.093 | 61885.6 |
156 | 2024-03-19 16:18:13 | gunrunners | 2 | 108824 | 4 | 10.466 | 10397.9 |
155 | 2024-03-19 16:16:24 | gunrunners | 3 | 140603 | 13 | 7.876 | 17852.1 |
154 | 2024-03-19 15:22:43 | gunrunners | 1 | 67641 | 2 | 1.750 | 38652.0 |
153 | 2024-03-19 06:28:07 | gunrunners | 2 | 108824 | 4 | 11.000 | 9893.1 |
152 | 2024-03-19 06:27:58 | gunrunners | 1 | 67641 | 2 | 3.766 | 17961.0 |
151 | 2024-03-06 16:02:12 | gunrunners | 1 | 67641 | 2 | 2.533 | 26703.9 |
150 | 2024-03-05 22:16:12 | gunrunners | 4 | 161450 | 76 | 29.703 | 5435.5 |
149 | 2024-03-05 05:06:06 | gunrunners | 4 | 161450 | 76 | 32.143 | 5022.9 |
148 | 2024-03-03 15:13:33 | gunrunners | 2 | 108824 | 4 | 10.063 | 10814.3 |
147 | 2024-03-03 13:26:35 | gunrunners | 1 | 67641 | 2 | 1.000 | 67641.0 |
146 | 2024-02-27 22:29:38 | gunrunners | 2 | 108824 | 4 | 5.813 | 18720.8 |
145 | 2024-02-27 12:06:12 | gunrunners | 5 | 173545 | 953 | 23.766 | 7302.2 |
144 | 2024-02-26 18:43:31 | gunrunners | 5 | 173545 | 953 | 32.906 | 5274.0 |
143 | 2024-02-26 18:43:34 | gunrunners | 4 | 161450 | 76 | 26.330 | 6131.8 |
142 | 2024-02-26 18:43:30 | gunrunners | 3 | 140603 | 13 | 13.393 | 10498.2 |
141 | 2024-02-26 18:43:32 | gunrunners | 2 | 108824 | 4 | 3.406 | 31950.7 |
140 | 2024-02-26 18:43:27 | gunrunners | 1 | 67641 | 2 | 1.233 | 54858.9 |
139 | 2024-01-27 18:06:35 | gunrunners | 1 | 67641 | 2 | 0.970 | 69733.0 |
138 | 2024-01-27 18:06:31 | gunrunners | 1 | 67641 | 2 | 1.000 | 67641.0 |
137 | 2024-01-10 11:12:02 | gunrunners | 1 | 67641 | 2 | 1.016 | 66575.8 |
136 | 2023-12-20 08:58:22 | gunrunners | 4 | 161450 | 76 | 10.170 | 15875.1 |
135 | 2023-11-29 05:11:17 | gunrunners | 1 | 67641 | 2 | 1.110 | 60937.8 |
134 | 2023-11-25 20:48:44 | gunrunners | 2 | 108824 | 4 | 2.626 | 41441.0 |
133 | 2023-11-04 01:10:05 | gunrunners | 1 | 67641 | 2 | 1.156 | 58513.0 |
132 | 2023-10-16 00:22:51 | gunrunners | 1 | 67641 | 2 | 1.110 | 60937.8 |
131 | 2023-10-01 06:24:58 | gunrunners | 4 | 161450 | 76 | 10.453 | 15445.3 |
130 | 2023-09-30 01:32:03 | gunrunners | 1 | 67641 | 2 | 1.050 | 64420.0 |
129 | 2023-09-28 04:06:05 | gunrunners | 4 | 161450 | 76 | 13.126 | 12300.0 |
128 | 2023-09-20 17:56:42 | gunrunners | 4 | 161450 | 76 | 10.783 | 14972.6 |
127 | 2023-08-26 13:07:23 | gunrunners | 1 | 67641 | 2 | 1.110 | 60937.8 |
126 | 2023-08-26 01:55:58 | gunrunners | 2 | 108824 | 4 | 2.533 | 42962.5 |
125 | 2023-06-30 09:35:47 | gunrunners | 4 | 161450 | 76 | 9.626 | 16772.3 |
124 | 2023-05-29 06:57:46 | gunrunners | 1 | 67641 | 2 | 0.966 | 70021.7 |
123 | 2023-05-12 14:14:23 | gunrunners | 2 | 108824 | 4 | 2.580 | 42179.8 |
122 | 2023-05-09 14:02:02 | gunrunners | 1 | 67641 | 2 | 1.063 | 63632.2 |
121 | 2023-03-22 15:45:34 | gunrunners | 1 | 67641 | 2 | 0.970 | 69733.0 |
120 | 2023-03-21 15:20:03 | gunrunners | 4 | 161450 | 76 | 9.703 | 16639.2 |
119 | 2023-02-17 11:34:59 | gunrunners | 2 | 108824 | 4 | 2.516 | 43252.8 |
118 | 2023-01-09 02:12:30 | gunrunners | 1 | 67641 | 2 | 0.956 | 70754.2 |
117 | 2022-12-20 02:11:08 | gunrunners | 4 | 161450 | 76 | 9.360 | 17248.9 |
116 | 2022-12-17 19:03:49 | gunrunners | 1 | 67641 | 2 | 0.983 | 68810.8 |
115 | 2022-11-30 13:16:33 | gunrunners | 2 | 108824 | 4 | 2.860 | 38050.3 |
114 | 2022-10-06 23:52:18 | gunrunners | 1 | 67641 | 2 | 1.106 | 61158.2 |
113 | 2022-08-17 15:51:39 | gunrunners | 4 | 161450 | 76 | 9.190 | 17568.0 |
112 | 2022-07-08 11:20:48 | gunrunners | 2 | 108824 | 4 | 3.000 | 36274.7 |
111 | 2022-07-04 06:37:36 | gunrunners | 1 | 67641 | 2 | 0.966 | 70021.7 |
110 | 2022-07-03 02:13:46 | gunrunners | 3 | 140603 | 13 | 6.470 | 21731.5 |
109 | 2022-05-23 03:47:56 | gunrunners | 1 | 67641 | 2 | 0.986 | 68601.4 |
108 | 2022-05-20 22:34:34 | gunrunners | 1 | 67641 | 2 | 1.000 | 67641.0 |
107 | 2022-02-17 10:55:03 | gunrunners | 1 | 67641 | 2 | 1.140 | 59334.2 |
106 | 2022-01-20 17:28:43 | gunrunners | 1 | 67641 | 2 | 1.140 | 59334.2 |
105 | 2022-01-17 11:00:01 | gunrunners | 1 | 67641 | 2 | 1.016 | 66575.8 |
104 | 2022-01-14 04:14:55 | gunrunners | 1 | 67641 | 2 | 0.983 | 68810.8 |
103 | 2021-10-29 12:57:22 | gunrunners | 1 | 67641 | 2 | 1.080 | 62630.6 |
102 | 2021-09-14 03:44:14 | gunrunners | 1 | 67641 | 2 | 0.970 | 69733.0 |
101 | 2021-09-02 12:47:05 | gunrunners | 1 | 67641 | 2 | 0.966 | 70021.7 |
100 | 2021-05-21 03:45:37 | gunrunners | 1 | 67641 | 2 | 1.063 | 63632.2 |
99 | 2021-05-09 07:29:18 | gunrunners | 1 | 67641 | 2 | 1.203 | 56226.9 |
98 | 2021-03-24 01:40:33 | gunrunners | 1 | 67641 | 2 | 1.170 | 57812.8 |
97 | 2021-02-02 11:33:26 | gunrunners | 1 | 67641 | 2 | 1.096 | 61716.2 |
96 | 2021-01-28 05:12:18 | gunrunners | 1 | 67641 | 2 | 1.000 | 67641.0 |
95 | 2020-12-27 21:44:08 | gunrunners | 1 | 67641 | 2 | 0.983 | 68810.8 |
94 | 2020-08-27 09:38:10 | gunrunners | 1 | 67641 | 2 | 1.076 | 62863.4 |
93 | 2020-04-24 19:44:42 | gunrunners | 1 | 67641 | 2 | 1.016 | 66575.8 |
92 | 2020-02-28 02:25:06 | gunrunners | 1 | 67641 | 2 | 1.220 | 55443.4 |
91 | 2020-02-11 19:54:50 | gunrunners | 1 | 67641 | 2 | 2.546 | 26567.6 |
90 | 2020-02-11 03:37:23 | gunrunners | 1 | 67641 | 2 | 1.140 | 59334.2 |
89 | 2020-01-22 00:09:59 | gunrunners | 1 | 67641 | 2 | 1.186 | 57032.9 |
88 | 2020-01-17 06:45:06 | gunrunners | 1 | 67641 | 2 | 1.063 | 63632.2 |
87 | 2020-01-11 00:20:20 | gunrunners | 1 | 67641 | 2 | 1.280 | 52844.5 |
86 | 2019-12-25 18:05:00 | gunrunners | 1 | 67641 | 2 | 0.970 | 69733.0 |
85 | 2019-09-24 23:30:21 | gunrunners | 1 | 67641 | 2 | 1.033 | 65480.2 |
84 | 2019-06-03 15:04:46 | gunrunners | 1 | 67641 | 2 | 1.150 | 58818.3 |
83 | 2019-01-28 00:50:23 | gunrunners | 1 | 67641 | 2 | 2.116 | 31966.4 |
82 | 2018-09-07 02:16:13 | gunrunners | 1 | 67641 | 2 | 1.506 | 44914.3 |
81 | 2018-03-24 23:47:07 | gunrunners | 1 | 67641 | 2 | 1.373 | 49265.1 |
80 | 2018-01-03 16:02:09 | gunrunners | 1 | 67641 | 2 | 1.776 | 38086.1 |
79 | 2017-11-09 18:02:40 | gunrunners | 1 | 67641 | 2 | 1.903 | 35544.4 |
78 | 2017-09-15 00:39:47 | gunrunners | 4 | 161450 | 76 | 15.356 | 10513.8 |
77 | 2017-08-27 08:00:11 | gunrunners | 5 | 173545 | 953 | 23.533 | 7374.5 |
76 | 2017-08-16 18:41:47 | gunrunners | 5 | 173545 | 953 | 32.366 | 5362.0 |
75 | 2017-08-02 00:06:33 | gunrunners | 5 | 173545 | 953 | 19.896 | 8722.6 |
74 | 2017-07-29 10:23:28 | gunrunners | 5 | 173545 | 953 | 20.463 | 8480.9 |
73 | 2017-07-22 01:47:46 | gunrunners | 5 | 173545 | 953 | 28.393 | 6112.2 |
72 | 2017-07-19 00:27:59 | gunrunners | 5 | 173545 | 953 | 24.956 | 6954.0 |
71 | 2017-07-12 20:23:57 | gunrunners | 5 | 173545 | 953 | 20.276 | 8559.1 |
70 | 2017-07-12 15:20:45 | gunrunners | 5 | 173545 | 953 | 29.293 | 5924.5 |
69 | 2017-05-25 16:09:02 | gunrunners | 5 | 173545 | 953 | 22.416 | 7742.0 |
68 | 2017-05-19 10:45:02 | gunrunners | 5 | 173545 | 953 | 26.843 | 6465.2 |
67 | 2017-03-23 19:56:15 | gunrunners | 4 | 161450 | 76 | 12.433 | 12985.6 |
66 | 2017-02-15 14:16:51 | gunrunners | 5 | 173545 | 953 | 25.750 | 6739.6 |