History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"schoolworks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
143 | 2024-04-30 23:48:55 | schoolworks | 5 | 164607 | 173 | 16.313 | 10090.5 |
142 | 2024-04-30 16:42:47 | schoolworks | 3 | 121633 | 12 | 10.826 | 11235.3 |
141 | 2024-04-17 18:31:05 | schoolworks | 1 | 49908 | 2 | 0.796 | 62698.5 |
140 | 2024-03-30 15:19:43 | schoolworks | 4 | 148819 | 42 | 22.580 | 6590.7 |
139 | 2024-03-26 16:43:43 | schoolworks | 2 | 86808 | 4 | 2.796 | 31047.2 |
138 | 2024-03-26 16:32:15 | schoolworks | 1 | 49908 | 2 | 0.826 | 60421.3 |
137 | 2024-03-21 11:29:20 | schoolworks | 4 | 148819 | 42 | 19.813 | 7511.2 |
136 | 2024-03-13 00:28:28 | schoolworks | 4 | 148819 | 42 | 18.533 | 8029.9 |
135 | 2024-03-13 00:28:23 | schoolworks | 1 | 49908 | 2 | 2.906 | 17174.1 |
134 | 2024-03-13 00:27:58 | schoolworks | 3 | 121633 | 12 | 14.966 | 8127.3 |
133 | 2024-03-13 00:28:04 | schoolworks | 2 | 86808 | 4 | 2.876 | 30183.6 |
132 | 2024-03-13 00:28:02 | schoolworks | 1 | 49908 | 2 | 1.923 | 25953.2 |
131 | 2024-03-13 00:27:26 | schoolworks | 2 | 86808 | 4 | 5.593 | 15520.8 |
130 | 2024-03-09 12:07:14 | schoolworks | 2 | 86808 | 4 | 2.140 | 40564.5 |
129 | 2024-03-06 19:52:19 | schoolworks | 3 | 121633 | 12 | 12.156 | 10006.0 |
128 | 2024-03-06 19:52:19 | schoolworks | 2 | 86808 | 4 | 6.300 | 13779.0 |
127 | 2024-03-06 17:33:05 | schoolworks | 1 | 49908 | 2 | 1.736 | 28748.8 |
126 | 2024-02-26 07:15:25 | schoolworks | 5 | 164607 | 173 | 44.346 | 3711.9 |
125 | 2024-02-20 09:49:37 | schoolworks | 5 | 164607 | 173 | 15.546 | 10588.4 |
124 | 2024-02-18 20:52:57 | schoolworks | 1 | 49908 | 2 | 2.720 | 18348.5 |
123 | 2024-02-12 16:12:18 | schoolworks | 4 | 148819 | 42 | 22.703 | 6555.0 |
122 | 2024-02-11 15:46:18 | schoolworks | 4 | 148819 | 42 | 30.626 | 4859.2 |
121 | 2024-02-10 13:49:59 | schoolworks | 1 | 49908 | 2 | 0.966 | 51664.6 |
120 | 2024-02-10 11:59:13 | schoolworks | 4 | 148819 | 42 | 13.753 | 10820.8 |
119 | 2024-02-09 13:04:04 | schoolworks | 4 | 148819 | 42 | 16.033 | 9282.0 |
118 | 2024-02-09 00:05:39 | schoolworks | 4 | 148819 | 42 | 22.250 | 6688.5 |
117 | 2024-02-09 00:05:42 | schoolworks | 2 | 86808 | 4 | 5.343 | 16247.1 |
116 | 2024-02-09 00:04:48 | schoolworks | 1 | 49908 | 2 | 1.843 | 27079.8 |
115 | 2024-02-09 00:00:07 | schoolworks | 1 | 49908 | 2 | 2.313 | 21577.2 |
114 | 2024-01-29 11:52:54 | schoolworks | 3 | 121633 | 12 | 4.563 | 26656.4 |
113 | 2024-01-20 23:07:38 | schoolworks | 1 | 49908 | 2 | 0.750 | 66544.0 |
112 | 2024-01-10 06:24:45 | schoolworks | 5 | 164607 | 173 | 13.080 | 12584.6 |
111 | 2023-12-16 13:14:18 | schoolworks | 1 | 49908 | 2 | 0.826 | 60421.3 |
110 | 2023-11-27 22:26:59 | schoolworks | 2 | 86808 | 4 | 2.093 | 41475.4 |
109 | 2023-11-25 10:06:12 | schoolworks | 1 | 49908 | 2 | 0.860 | 58032.6 |
108 | 2023-11-24 23:07:08 | schoolworks | 1 | 49908 | 2 | 0.843 | 59202.8 |
107 | 2023-11-17 12:05:40 | schoolworks | 1 | 49908 | 2 | 0.766 | 65154.0 |
106 | 2023-11-08 20:29:10 | schoolworks | 3 | 121633 | 12 | 4.966 | 24493.2 |
105 | 2023-10-31 23:43:03 | schoolworks | 1 | 49908 | 2 | 0.936 | 53320.5 |
104 | 2023-10-17 15:28:48 | schoolworks | 5 | 164607 | 173 | 14.783 | 11134.9 |
103 | 2023-09-15 19:37:35 | schoolworks | 1 | 49908 | 2 | 1.813 | 27527.9 |
102 | 2023-09-05 00:18:56 | schoolworks | 1 | 49908 | 2 | 0.843 | 59202.8 |
101 | 2023-08-27 23:28:46 | schoolworks | 2 | 86808 | 4 | 2.013 | 43123.7 |
100 | 2023-08-13 09:25:20 | schoolworks | 3 | 121633 | 12 | 4.390 | 27706.8 |
99 | 2023-07-29 14:17:54 | schoolworks | 5 | 164607 | 173 | 17.923 | 9184.1 |
98 | 2023-06-10 14:07:24 | schoolworks | 1 | 49908 | 2 | 0.736 | 67809.8 |
97 | 2023-05-11 18:09:03 | schoolworks | 2 | 86808 | 4 | 2.530 | 34311.5 |
96 | 2023-04-26 09:39:35 | schoolworks | 3 | 121633 | 12 | 4.860 | 25027.4 |
95 | 2023-04-05 22:37:20 | schoolworks | 5 | 164607 | 173 | 12.296 | 13387.0 |
94 | 2023-03-30 02:19:22 | schoolworks | 1 | 49908 | 2 | 0.750 | 66544.0 |
93 | 2023-03-15 08:31:25 | schoolworks | 5 | 164607 | 173 | 15.156 | 10860.8 |
92 | 2023-02-16 14:00:28 | schoolworks | 2 | 86808 | 4 | 2.280 | 38073.7 |
91 | 2023-02-06 16:46:12 | schoolworks | 5 | 164607 | 173 | 15.046 | 10940.2 |
90 | 2023-02-01 07:31:49 | schoolworks | 3 | 121633 | 12 | 4.326 | 28116.7 |
89 | 2023-01-12 15:40:28 | schoolworks | 1 | 49908 | 2 | 0.733 | 68087.3 |
88 | 2023-01-03 01:34:26 | schoolworks | 5 | 164607 | 173 | 26.143 | 6296.4 |
87 | 2022-11-28 14:55:27 | schoolworks | 2 | 86808 | 4 | 2.013 | 43123.7 |
86 | 2022-11-13 18:09:05 | schoolworks | 3 | 121633 | 12 | 4.360 | 27897.5 |
85 | 2022-11-02 13:10:48 | schoolworks | 1 | 49908 | 2 | 0.843 | 59202.8 |
84 | 2022-09-06 20:18:47 | schoolworks | 5 | 164607 | 173 | 12.453 | 13218.3 |
83 | 2022-07-05 10:05:33 | schoolworks | 2 | 86808 | 4 | 2.030 | 42762.6 |
82 | 2022-06-22 14:41:45 | schoolworks | 1 | 49908 | 2 | 0.763 | 65410.2 |
81 | 2022-06-20 08:39:38 | schoolworks | 1 | 49908 | 2 | 0.783 | 63739.5 |
80 | 2022-05-12 23:57:58 | schoolworks | 3 | 121633 | 12 | 5.376 | 22625.2 |
79 | 2022-03-30 05:20:51 | schoolworks | 5 | 164607 | 173 | 14.546 | 11316.3 |
78 | 2022-03-12 18:19:30 | schoolworks | 1 | 49908 | 2 | 0.936 | 53320.5 |
77 | 2021-05-13 23:09:22 | schoolworks | 1 | 49908 | 2 | 1.703 | 29305.9 |
76 | 2021-01-26 18:03:39 | schoolworks | 1 | 49908 | 2 | 0.856 | 58303.7 |
75 | 2020-11-10 09:52:32 | schoolworks | 1 | 49908 | 2 | 0.763 | 65410.2 |
74 | 2020-10-12 09:07:41 | schoolworks | 1 | 49908 | 2 | 0.763 | 65410.2 |
73 | 2020-07-31 19:53:13 | schoolworks | 1 | 49908 | 2 | 0.783 | 63739.5 |
72 | 2020-03-27 05:24:39 | schoolworks | 1 | 49908 | 2 | 0.843 | 59202.8 |
71 | 2020-03-13 21:00:32 | schoolworks | 1 | 49908 | 2 | 0.763 | 65410.2 |
70 | 2020-02-25 17:27:04 | schoolworks | 1 | 49908 | 2 | 1.860 | 26832.3 |
69 | 2020-02-15 05:26:17 | schoolworks | 1 | 49908 | 2 | 1.000 | 49908.0 |
68 | 2020-02-05 07:03:53 | schoolworks | 1 | 49908 | 2 | 0.873 | 57168.4 |
67 | 2020-01-25 01:21:24 | schoolworks | 1 | 49908 | 2 | 1.920 | 25993.8 |
66 | 2020-01-19 21:46:02 | schoolworks | 1 | 49908 | 2 | 0.936 | 53320.5 |
65 | 2020-01-13 00:55:22 | schoolworks | 1 | 49908 | 2 | 0.873 | 57168.4 |
64 | 2019-11-20 06:27:32 | schoolworks | 1 | 49908 | 2 | 1.013 | 49267.5 |
63 | 2019-08-02 21:30:28 | schoolworks | 1 | 49908 | 2 | 0.776 | 64314.4 |
62 | 2019-03-15 16:32:21 | schoolworks | 1 | 49908 | 2 | 0.726 | 68743.8 |
61 | 2018-10-27 07:22:03 | schoolworks | 1 | 49908 | 2 | 0.813 | 61387.5 |
60 | 2018-06-27 21:58:03 | schoolworks | 1 | 49908 | 2 | 0.770 | 64815.6 |
59 | 2018-04-12 08:32:38 | schoolworks | 1 | 49908 | 2 | 0.806 | 61920.6 |
58 | 2018-01-03 13:02:03 | schoolworks | 1 | 49908 | 2 | 1.066 | 46818.0 |
57 | 2017-12-04 05:40:08 | schoolworks | 1 | 49908 | 2 | 1.010 | 49413.9 |
56 | 2017-11-07 09:37:22 | schoolworks | 1 | 49908 | 2 | 1.263 | 39515.4 |
55 | 2017-05-19 06:19:44 | schoolworks | 1 | 49908 | 2 | 1.010 | 49413.9 |
54 | 2016-12-06 11:59:43 | schoolworks | 1 | 49908 | 2 | 1.263 | 39515.4 |
53 | 2016-12-06 11:58:25 | schoolworks | 1 | 49908 | 2 | 1.046 | 47713.2 |
52 | 2016-11-25 08:21:33 | schoolworks | 1 | 49908 | 2 | 1.253 | 39830.8 |
51 | 2016-11-23 20:26:26 | schoolworks | 1 | 49908 | 2 | 1.306 | 38214.4 |
50 | 2016-11-23 19:15:25 | schoolworks | 1 | 49908 | 2 | 1.050 | 47531.4 |
49 | 2016-11-23 19:10:12 | schoolworks | 1 | 49908 | 2 | 1.070 | 46643.0 |
48 | 2016-10-19 13:58:08 | schoolworks | 5 | 164607 | 173 | 24.336 | 6763.9 |
47 | 2016-10-19 09:57:56 | schoolworks | 2 | 86808 | 4 | 6.520 | 13314.1 |
46 | 2016-10-18 16:22:58 | schoolworks | 3 | 121633 | 12 | 8.080 | 15053.6 |
45 | 2016-10-18 09:34:05 | schoolworks | 4 | 148819 | 42 | 13.373 | 11128.3 |
44 | 2016-10-15 01:54:27 | schoolworks | 1 | 49908 | 2 | 1.196 | 41729.1 |