History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"secretary"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
160 | 2024-04-30 13:42:02 | secretary | 1 | 81242 | 2 | 3.813 | 21306.6 |
159 | 2024-04-28 11:25:35 | secretary | 1 | 81242 | 2 | 1.530 | 53099.3 |
158 | 2024-04-27 20:57:01 | secretary | 4 | 165329 | 184 | 32.720 | 5052.8 |
157 | 2024-04-27 04:06:47 | secretary | 4 | 165329 | 184 | 41.080 | 4024.6 |
156 | 2024-04-27 04:06:00 | secretary | 4 | 165329 | 184 | 18.503 | 8935.3 |
155 | 2024-04-25 20:39:33 | secretary | 1 | 81242 | 2 | 4.203 | 19329.5 |
154 | 2024-04-24 18:12:32 | secretary | 1 | 81242 | 2 | 1.406 | 57782.4 |
153 | 2024-04-05 13:21:06 | secretary | 1 | 81242 | 2 | 3.750 | 21664.5 |
152 | 2024-04-01 07:55:07 | secretary | 1 | 81242 | 2 | 4.970 | 16346.5 |
151 | 2024-03-29 05:44:02 | secretary | 1 | 81242 | 2 | 4.596 | 17676.7 |
150 | 2024-03-28 22:02:05 | secretary | 1 | 81242 | 2 | 1.673 | 48560.7 |
149 | 2024-03-28 12:01:56 | secretary | 4 | 165329 | 184 | 12.550 | 13173.6 |
148 | 2024-03-23 18:28:31 | secretary | 4 | 165329 | 184 | 42.470 | 3892.8 |
147 | 2024-03-22 07:58:05 | secretary | 3 | 148641 | 37 | 21.640 | 6868.8 |
146 | 2024-03-21 23:10:16 | secretary | 3 | 148641 | 37 | 17.563 | 8463.3 |
145 | 2024-03-21 22:50:40 | secretary | 1 | 81242 | 2 | 1.533 | 52995.4 |
144 | 2024-03-21 03:51:45 | secretary | 4 | 165329 | 184 | 43.330 | 3815.6 |
143 | 2024-03-20 06:21:27 | secretary | 4 | 165329 | 184 | 44.643 | 3703.4 |
142 | 2024-03-20 06:21:28 | secretary | 3 | 148641 | 37 | 20.046 | 7415.0 |
141 | 2024-03-20 06:21:30 | secretary | 2 | 121436 | 8 | 12.593 | 9643.1 |
140 | 2024-03-20 05:58:39 | secretary | 1 | 81242 | 2 | 1.483 | 54782.2 |
139 | 2024-03-08 03:00:55 | secretary | 1 | 81242 | 2 | 1.360 | 59736.8 |
138 | 2024-03-06 10:53:14 | secretary | 1 | 81242 | 2 | 1.720 | 47233.7 |
137 | 2024-02-29 07:58:36 | secretary | 2 | 121436 | 8 | 4.000 | 30359.0 |
136 | 2024-02-27 18:51:35 | secretary | 1 | 81242 | 2 | 1.450 | 56029.0 |
135 | 2024-02-23 02:03:59 | secretary | 3 | 148641 | 37 | 7.890 | 18839.2 |
134 | 2024-02-23 02:03:58 | secretary | 2 | 121436 | 8 | 3.923 | 30954.9 |
133 | 2024-02-22 08:18:20 | secretary | 4 | 165329 | 184 | 27.380 | 6038.3 |
132 | 2024-02-19 01:27:38 | secretary | 1 | 81242 | 2 | 3.250 | 24997.5 |
131 | 2024-02-19 01:19:58 | secretary | 4 | 165329 | 184 | 31.676 | 5219.4 |
130 | 2024-02-19 01:19:57 | secretary | 3 | 148641 | 37 | 20.020 | 7424.6 |
129 | 2024-02-18 12:15:04 | secretary | 4 | 165329 | 184 | 19.610 | 8430.9 |
128 | 2024-02-18 12:15:01 | secretary | 3 | 148641 | 37 | 20.486 | 7255.7 |
127 | 2024-02-18 12:15:03 | secretary | 2 | 121436 | 8 | 11.656 | 10418.3 |
126 | 2024-02-18 05:08:07 | secretary | 1 | 81242 | 2 | 1.860 | 43678.5 |
125 | 2024-02-02 19:37:59 | secretary | 1 | 81242 | 2 | 1.546 | 52549.8 |
124 | 2024-01-28 16:29:43 | secretary | 1 | 81242 | 2 | 1.296 | 62686.7 |
123 | 2024-01-27 06:23:21 | secretary | 1 | 81242 | 2 | 1.656 | 49059.2 |
122 | 2023-12-28 01:11:14 | secretary | 1 | 81242 | 2 | 1.360 | 59736.8 |
121 | 2023-12-24 08:43:27 | secretary | 1 | 81242 | 2 | 1.280 | 63470.3 |
120 | 2023-12-10 11:36:07 | secretary | 1 | 81242 | 2 | 1.263 | 64324.6 |
119 | 2023-09-24 04:25:56 | secretary | 1 | 81242 | 2 | 1.390 | 58447.5 |
118 | 2023-07-20 04:02:59 | secretary | 1 | 81242 | 2 | 1.343 | 60492.9 |
117 | 2023-04-19 18:13:11 | secretary | 1 | 81242 | 2 | 1.296 | 62686.7 |
116 | 2023-02-07 06:51:52 | secretary | 1 | 81242 | 2 | 1.280 | 63470.3 |
115 | 2022-05-20 05:02:10 | secretary | 1 | 81242 | 2 | 1.453 | 55913.3 |
114 | 2022-05-11 16:40:40 | secretary | 1 | 81242 | 2 | 1.623 | 50056.7 |
113 | 2021-06-05 11:45:36 | secretary | 4 | 165329 | 184 | 13.423 | 12316.8 |
112 | 2021-05-11 01:29:06 | secretary | 1 | 81242 | 2 | 1.470 | 55266.7 |
111 | 2021-04-09 18:54:30 | secretary | 1 | 81242 | 2 | 1.466 | 55417.5 |
110 | 2021-02-19 11:58:43 | secretary | 1 | 81242 | 2 | 1.643 | 49447.4 |
109 | 2021-02-17 05:12:51 | secretary | 1 | 81242 | 2 | 2.703 | 30056.2 |
108 | 2020-11-06 22:09:35 | secretary | 1 | 81242 | 2 | 1.516 | 53589.7 |
107 | 2020-10-14 15:23:47 | secretary | 1 | 81242 | 2 | 1.296 | 62686.7 |
106 | 2020-03-24 07:12:36 | secretary | 1 | 81242 | 2 | 1.733 | 46879.4 |
105 | 2020-03-18 02:00:04 | secretary | 1 | 81242 | 2 | 1.470 | 55266.7 |
104 | 2020-02-20 07:33:49 | secretary | 4 | 165329 | 184 | 19.296 | 8568.0 |
103 | 2020-02-15 11:01:32 | secretary | 4 | 165329 | 184 | 38.016 | 4348.9 |
102 | 2020-02-08 18:06:32 | secretary | 1 | 81242 | 2 | 2.500 | 32496.8 |
101 | 2020-02-08 13:44:13 | secretary | 1 | 81242 | 2 | 1.516 | 53589.7 |
100 | 2020-02-05 05:45:41 | secretary | 1 | 81242 | 2 | 4.453 | 18244.3 |
99 | 2020-02-05 00:46:14 | secretary | 3 | 148641 | 37 | 16.186 | 9183.3 |
98 | 2020-02-04 09:31:04 | secretary | 4 | 165329 | 184 | 17.516 | 9438.7 |
97 | 2020-02-04 03:29:47 | secretary | 3 | 148641 | 37 | 8.156 | 18224.7 |
96 | 2020-02-03 18:13:51 | secretary | 3 | 148641 | 37 | 8.550 | 17384.9 |
95 | 2020-02-03 14:57:45 | secretary | 1 | 81242 | 2 | 2.876 | 28248.3 |
94 | 2020-02-02 01:18:31 | secretary | 4 | 165329 | 184 | 15.143 | 10917.8 |
93 | 2020-01-31 05:02:05 | secretary | 4 | 165329 | 184 | 28.640 | 5772.7 |
92 | 2020-01-29 00:17:09 | secretary | 1 | 81242 | 2 | 3.000 | 27080.7 |
91 | 2020-01-28 05:52:19 | secretary | 4 | 165329 | 184 | 26.563 | 6224.0 |
90 | 2020-01-27 22:06:43 | secretary | 4 | 165329 | 184 | 11.283 | 14652.9 |
89 | 2020-01-20 23:25:07 | secretary | 1 | 81242 | 2 | 1.923 | 42247.5 |
88 | 2020-01-12 12:28:49 | secretary | 1 | 81242 | 2 | 1.513 | 53696.0 |
87 | 2020-01-07 02:11:04 | secretary | 1 | 81242 | 2 | 1.623 | 50056.7 |
86 | 2020-01-04 00:24:38 | secretary | 1 | 81242 | 2 | 1.563 | 51978.2 |
85 | 2020-01-03 02:09:32 | secretary | 4 | 165329 | 184 | 16.550 | 9989.7 |
84 | 2020-01-02 20:06:16 | secretary | 4 | 165329 | 184 | 12.220 | 13529.4 |
83 | 2020-01-02 13:57:21 | secretary | 4 | 165329 | 184 | 22.393 | 7383.1 |
82 | 2020-01-02 07:53:37 | secretary | 1 | 81242 | 2 | 1.486 | 54671.6 |
81 | 2019-12-06 16:13:06 | secretary | 1 | 81242 | 2 | 1.406 | 57782.4 |
80 | 2019-09-04 14:03:27 | secretary | 1 | 81242 | 2 | 1.410 | 57618.4 |
79 | 2019-05-23 11:52:32 | secretary | 1 | 81242 | 2 | 1.453 | 55913.3 |
78 | 2019-03-15 03:16:31 | secretary | 1 | 81242 | 2 | 1.250 | 64993.6 |
77 | 2019-01-31 12:17:09 | secretary | 1 | 81242 | 2 | 1.326 | 61268.5 |
76 | 2019-01-16 12:48:02 | secretary | 1 | 81242 | 2 | 1.406 | 57782.4 |
75 | 2018-09-07 20:14:44 | secretary | 1 | 81242 | 2 | 1.340 | 60628.4 |
74 | 2018-09-07 20:02:54 | secretary | 1 | 81242 | 2 | 1.280 | 63470.3 |
73 | 2018-08-30 04:36:48 | secretary | 1 | 81242 | 2 | 1.543 | 52652.0 |
72 | 2018-07-05 21:22:05 | secretary | 1 | 81242 | 2 | 1.246 | 65202.2 |
71 | 2018-04-30 19:59:40 | secretary | 1 | 81242 | 2 | 1.326 | 61268.5 |
70 | 2018-01-29 01:26:42 | secretary | 1 | 81242 | 2 | 1.746 | 46530.4 |
69 | 2017-10-27 12:43:34 | secretary | 1 | 81242 | 2 | 2.710 | 29978.6 |
68 | 2017-10-26 06:56:38 | secretary | 1 | 81242 | 2 | 2.626 | 30937.5 |
67 | 2017-09-11 17:06:53 | secretary | 1 | 81242 | 2 | 1.856 | 43772.6 |
66 | 2017-08-02 01:25:20 | secretary | 4 | 165329 | 184 | 31.063 | 5322.4 |
65 | 2017-05-12 06:18:48 | secretary | 1 | 81242 | 2 | 1.633 | 49750.2 |
64 | 2017-05-07 20:15:23 | secretary | 1 | 81242 | 2 | 1.690 | 48072.2 |
63 | 2017-05-07 20:11:30 | secretary | 1 | 81242 | 2 | 1.623 | 50056.7 |
62 | 2017-05-03 11:51:11 | secretary | 1 | 81242 | 2 | 1.853 | 43843.5 |
61 | 2017-04-17 08:23:22 | secretary | 1 | 81242 | 2 | 1.786 | 45488.2 |