History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"segregant"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
148 | 2024-05-13 12:39:07 | segregant | 1 | 81242 | 2 | 1.983 | 40969.2 |
147 | 2024-05-13 12:39:04 | segregant | 1 | 81242 | 2 | 3.560 | 22820.8 |
146 | 2024-05-12 14:01:44 | segregant | 3 | 148641 | 19 | 24.220 | 6137.1 |
145 | 2024-05-12 14:00:38 | segregant | 2 | 121436 | 4 | 4.313 | 28155.8 |
144 | 2024-05-12 14:00:26 | segregant | 1 | 81242 | 2 | 4.406 | 18438.9 |
143 | 2024-05-12 06:58:09 | segregant | 3 | 148641 | 19 | 23.766 | 6254.4 |
142 | 2024-05-12 06:58:08 | segregant | 2 | 121436 | 4 | 11.296 | 10750.4 |
141 | 2024-05-12 06:57:31 | segregant | 1 | 81242 | 2 | 4.956 | 16392.7 |
140 | 2024-05-12 06:57:06 | segregant | 3 | 148641 | 19 | 21.750 | 6834.1 |
139 | 2024-05-12 06:57:05 | segregant | 2 | 121436 | 4 | 9.423 | 12887.2 |
138 | 2024-05-12 06:56:57 | segregant | 1 | 81242 | 2 | 3.190 | 25467.7 |
137 | 2024-05-12 06:56:52 | segregant | 1 | 81242 | 2 | 2.720 | 29868.4 |
136 | 2024-05-03 07:34:13 | segregant | 4 | 165329 | 130 | 27.173 | 6084.3 |
135 | 2024-04-28 13:13:02 | segregant | 4 | 165329 | 130 | 43.566 | 3794.9 |
134 | 2024-04-27 22:42:40 | segregant | 4 | 165329 | 130 | 40.160 | 4116.8 |
133 | 2024-04-27 03:04:58 | segregant | 4 | 165329 | 130 | 32.173 | 5138.7 |
132 | 2024-04-13 15:35:41 | segregant | 1 | 81242 | 2 | 1.576 | 51549.5 |
131 | 2024-04-12 22:13:52 | segregant | 1 | 81242 | 2 | 1.406 | 57782.4 |
130 | 2024-04-10 21:33:15 | segregant | 1 | 81242 | 2 | 1.580 | 51419.0 |
129 | 2024-04-02 04:47:42 | segregant | 4 | 165329 | 130 | 14.826 | 11151.3 |
128 | 2024-03-27 10:16:45 | segregant | 3 | 148641 | 19 | 12.643 | 11756.8 |
127 | 2024-03-27 10:07:05 | segregant | 4 | 165329 | 130 | 14.376 | 11500.3 |
126 | 2024-03-27 10:07:02 | segregant | 2 | 121436 | 4 | 8.093 | 15005.1 |
125 | 2024-03-23 18:28:56 | segregant | 3 | 148641 | 19 | 23.313 | 6375.9 |
124 | 2024-03-22 00:37:22 | segregant | 4 | 165329 | 130 | 30.893 | 5351.7 |
123 | 2024-03-22 00:37:21 | segregant | 3 | 148641 | 19 | 19.470 | 7634.4 |
122 | 2024-03-22 00:37:20 | segregant | 2 | 121436 | 4 | 7.030 | 17274.0 |
121 | 2024-03-22 00:36:50 | segregant | 1 | 81242 | 2 | 1.470 | 55266.7 |
120 | 2024-03-19 20:47:37 | segregant | 1 | 81242 | 2 | 1.513 | 53696.0 |
119 | 2024-03-10 18:21:50 | segregant | 1 | 81242 | 2 | 4.966 | 16359.6 |
118 | 2024-03-05 12:26:30 | segregant | 1 | 81242 | 2 | 1.530 | 53099.3 |
117 | 2024-02-20 23:14:22 | segregant | 4 | 165329 | 130 | 13.813 | 11969.1 |
116 | 2024-02-20 23:14:21 | segregant | 3 | 148641 | 19 | 7.500 | 19818.8 |
115 | 2024-02-20 23:14:19 | segregant | 2 | 121436 | 4 | 3.470 | 34996.0 |
114 | 2024-02-20 16:02:15 | segregant | 1 | 81242 | 2 | 1.403 | 57905.9 |
113 | 2024-02-02 01:05:57 | segregant | 1 | 81242 | 2 | 1.436 | 56575.2 |
112 | 2024-01-27 02:02:31 | segregant | 1 | 81242 | 2 | 1.390 | 58447.5 |
111 | 2024-01-25 05:28:39 | segregant | 1 | 81242 | 2 | 1.250 | 64993.6 |
110 | 2023-12-12 14:29:04 | segregant | 1 | 81242 | 2 | 3.016 | 26937.0 |
109 | 2023-11-22 15:55:50 | segregant | 1 | 81242 | 2 | 1.453 | 55913.3 |
108 | 2023-09-08 11:20:27 | segregant | 1 | 81242 | 2 | 1.263 | 64324.6 |
107 | 2023-06-15 11:29:10 | segregant | 1 | 81242 | 2 | 1.390 | 58447.5 |
106 | 2023-04-01 12:12:23 | segregant | 1 | 81242 | 2 | 1.250 | 64993.6 |
105 | 2023-01-14 15:22:13 | segregant | 1 | 81242 | 2 | 1.233 | 65889.7 |
104 | 2022-11-08 01:42:23 | segregant | 1 | 81242 | 2 | 1.440 | 56418.1 |
103 | 2022-06-28 04:14:31 | segregant | 1 | 81242 | 2 | 1.326 | 61268.5 |
102 | 2022-03-18 06:31:53 | segregant | 1 | 81242 | 2 | 1.266 | 64172.2 |
101 | 2021-05-01 04:38:29 | segregant | 1 | 81242 | 2 | 1.626 | 49964.3 |
100 | 2021-03-18 17:39:23 | segregant | 1 | 81242 | 2 | 1.283 | 63321.9 |
99 | 2020-12-30 21:51:51 | segregant | 1 | 81242 | 2 | 1.283 | 63321.9 |
98 | 2020-11-04 23:58:06 | segregant | 1 | 81242 | 2 | 1.390 | 58447.5 |
97 | 2020-10-16 10:29:18 | segregant | 1 | 81242 | 2 | 1.280 | 63470.3 |
96 | 2020-03-29 00:01:17 | segregant | 1 | 81242 | 2 | 2.546 | 31909.7 |
95 | 2020-03-24 11:10:57 | segregant | 1 | 81242 | 2 | 1.576 | 51549.5 |
94 | 2020-02-19 17:30:46 | segregant | 1 | 81242 | 2 | 3.596 | 22592.3 |
93 | 2020-02-08 22:01:58 | segregant | 1 | 81242 | 2 | 1.440 | 56418.1 |
92 | 2020-02-05 21:51:00 | segregant | 1 | 81242 | 2 | 1.563 | 51978.2 |
91 | 2020-02-03 10:09:25 | segregant | 1 | 81242 | 2 | 3.563 | 22801.6 |
90 | 2020-02-02 04:21:36 | segregant | 1 | 81242 | 2 | 2.250 | 36107.6 |
89 | 2020-02-02 02:31:53 | segregant | 1 | 81242 | 2 | 2.470 | 32891.5 |
88 | 2020-01-19 20:53:07 | segregant | 1 | 81242 | 2 | 1.656 | 49059.2 |
87 | 2020-01-07 01:20:09 | segregant | 1 | 81242 | 2 | 1.673 | 48560.7 |
86 | 2020-01-04 22:31:04 | segregant | 1 | 81242 | 2 | 3.093 | 26266.4 |
85 | 2019-12-12 02:56:48 | segregant | 1 | 81242 | 2 | 1.330 | 61084.2 |
84 | 2019-09-10 09:23:14 | segregant | 1 | 81242 | 2 | 1.250 | 64993.6 |
83 | 2019-07-22 23:38:56 | segregant | 1 | 81242 | 2 | 1.253 | 64838.0 |
82 | 2019-06-14 13:06:08 | segregant | 1 | 81242 | 2 | 1.340 | 60628.4 |
81 | 2019-05-26 06:02:38 | segregant | 1 | 81242 | 2 | 1.630 | 49841.7 |
80 | 2019-01-22 14:25:49 | segregant | 1 | 81242 | 2 | 2.806 | 28953.0 |
79 | 2018-09-04 23:21:01 | segregant | 1 | 81242 | 2 | 1.366 | 59474.4 |
78 | 2018-05-05 15:19:43 | segregant | 1 | 81242 | 2 | 1.283 | 63321.9 |
77 | 2018-01-08 00:39:04 | segregant | 1 | 81242 | 2 | 1.693 | 47987.0 |
76 | 2018-01-06 05:35:12 | segregant | 1 | 81242 | 2 | 1.743 | 46610.4 |
75 | 2017-07-18 05:49:22 | segregant | 1 | 81242 | 2 | 1.806 | 44984.5 |
74 | 2017-07-12 05:34:29 | segregant | 1 | 81242 | 2 | 2.830 | 28707.4 |
73 | 2016-11-27 18:51:43 | segregant | 1 | 81242 | 2 | 1.993 | 40763.7 |
72 | 2016-09-15 02:44:12 | segregant | 1 | 81242 | 2 | 1.926 | 42181.7 |
71 | 2016-09-05 16:46:03 | segregant | 1 | 81242 | 2 | 1.730 | 46960.7 |
70 | 2016-08-29 00:51:38 | segregant | 1 | 81242 | 2 | 2.013 | 40358.7 |
69 | 2016-08-21 11:40:44 | segregant | 1 | 81242 | 2 | 2.110 | 38503.3 |
68 | 2016-08-04 18:59:17 | segregant | 1 | 81242 | 2 | 2.010 | 40418.9 |
67 | 2016-07-31 22:55:11 | segregant | 2 | 121436 | 4 | 10.693 | 11356.6 |
66 | 2016-07-20 23:42:57 | segregant | 4 | 165329 | 130 | 25.023 | 6607.1 |
65 | 2016-07-02 18:48:53 | segregant | 1 | 81242 | 2 | 1.790 | 45386.6 |
64 | 2016-04-08 08:41:22 | segregant | 1 | 81242 | 2 | 2.073 | 39190.5 |
63 | 2016-01-25 21:33:04 | segregant | 1 | 81242 | 2 | 1.493 | 54415.3 |
62 | 2016-01-17 08:42:06 | segregant | 1 | 81242 | 2 | 1.516 | 53589.7 |
61 | 2015-12-31 22:25:59 | segregant | 1 | 81242 | 2 | 1.440 | 56418.1 |
60 | 2015-10-21 19:31:38 | segregant | 1 | 81242 | 2 | 1.803 | 45059.3 |
59 | 2015-09-30 05:53:13 | segregant | 1 | 81242 | 2 | 1.493 | 54415.3 |
58 | 2015-09-14 16:11:39 | segregant | 1 | 81242 | 2 | 3.423 | 23734.2 |
57 | 2015-08-30 19:06:16 | segregant | 1 | 81242 | 2 | 1.523 | 53343.4 |
56 | 2015-08-28 16:20:51 | segregant | 1 | 81242 | 2 | 1.533 | 52995.4 |
55 | 2015-08-25 02:56:25 | segregant | 1 | 81242 | 2 | 1.520 | 53448.7 |
54 | 2015-08-08 05:49:27 | segregant | 1 | 81242 | 2 | 1.506 | 53945.6 |
53 | 2015-06-24 14:58:58 | segregant | 1 | 81242 | 2 | 3.300 | 24618.8 |
52 | 2015-06-02 13:00:09 | segregant | 2 | 121436 | 4 | 4.423 | 27455.6 |
51 | 2015-06-02 12:56:07 | segregant | 1 | 81242 | 2 | 1.666 | 48764.7 |
50 | 2015-05-28 07:57:02 | segregant | 2 | 121436 | 4 | 4.376 | 27750.5 |
49 | 2015-05-28 07:50:25 | segregant | 4 | 165329 | 130 | 31.290 | 5283.8 |