History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"campus"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1122 | 2024-04-27 05:31:03 | campus | 1 | 48755 | 5 | 0.940 | 51867.0 |
| 1121 | 2024-04-27 02:38:25 | campus | 2 | 82551 | 71 | 9.643 | 8560.7 |
| 1120 | 2024-04-26 17:50:17 | campus | 2 | 82551 | 71 | 2.906 | 28407.1 |
| 1119 | 2024-04-26 15:58:17 | campus | 3 | 112716 | 720 | 5.250 | 21469.7 |
| 1118 | 2024-04-26 15:58:19 | campus | 2 | 82551 | 71 | 2.486 | 33206.4 |
| 1117 | 2024-04-26 15:58:11 | campus | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 1116 | 2024-04-26 15:57:45 | campus | 3 | 112716 | 720 | 7.000 | 16102.3 |
| 1115 | 2024-04-25 19:28:34 | campus | 2 | 82551 | 71 | 2.813 | 29346.2 |
| 1114 | 2024-04-25 19:28:09 | campus | 3 | 112716 | 720 | 6.876 | 16392.7 |
| 1113 | 2024-04-24 16:29:07 | campus | 3 | 112716 | 720 | 20.316 | 5548.1 |
| 1112 | 2024-04-22 11:56:21 | campus | 3 | 112716 | 720 | 7.843 | 14371.5 |
| 1111 | 2024-04-22 07:57:31 | campus | 3 | 112716 | 720 | 12.313 | 9154.2 |
| 1110 | 2024-04-16 08:24:42 | campus | 1 | 48755 | 5 | 1.326 | 36768.5 |
| 1109 | 2024-04-16 07:30:58 | campus | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 1108 | 2024-04-16 07:30:41 | campus | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 1107 | 2024-04-16 07:25:11 | campus | 1 | 48755 | 5 | 0.970 | 50262.9 |
| 1106 | 2024-03-27 00:36:50 | campus | 2 | 82551 | 71 | 2.703 | 30540.5 |
| 1105 | 2024-03-27 00:36:45 | campus | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 1104 | 2024-03-27 00:36:18 | campus | 3 | 112716 | 720 | 5.906 | 19085.0 |
| 1103 | 2024-03-25 03:20:39 | campus | 3 | 112716 | 720 | 5.766 | 19548.4 |
| 1102 | 2024-03-24 09:38:51 | campus | 3 | 112716 | 720 | 6.940 | 16241.5 |
| 1101 | 2024-03-23 01:03:43 | campus | 3 | 112716 | 720 | 6.093 | 18499.3 |
| 1100 | 2024-03-21 02:09:52 | campus | 3 | 112716 | 720 | 15.783 | 7141.6 |
| 1099 | 2024-03-20 02:23:19 | campus | 3 | 112716 | 720 | 5.250 | 21469.7 |
| 1098 | 2024-03-16 17:08:48 | campus | 3 | 112716 | 720 | 12.906 | 8733.6 |
| 1097 | 2024-03-15 19:58:52 | campus | 3 | 112716 | 720 | 4.890 | 23050.3 |
| 1096 | 2024-03-14 04:48:40 | campus | 3 | 112716 | 720 | 19.360 | 5822.1 |
| 1095 | 2024-03-12 01:40:36 | campus | 3 | 112716 | 720 | 6.096 | 18490.2 |
| 1094 | 2024-03-11 02:32:01 | campus | 3 | 112716 | 720 | 6.106 | 18459.9 |
| 1093 | 2024-03-10 11:44:22 | campus | 3 | 112716 | 720 | 15.063 | 7483.0 |
| 1092 | 2024-03-09 09:08:48 | campus | 3 | 112716 | 720 | 4.736 | 23799.8 |
| 1091 | 2024-03-08 23:33:24 | campus | 3 | 112716 | 720 | 11.140 | 10118.1 |
| 1090 | 2024-03-08 16:44:44 | campus | 3 | 112716 | 720 | 13.140 | 8578.1 |
| 1089 | 2024-03-07 22:42:43 | campus | 3 | 112716 | 720 | 13.016 | 8659.8 |
| 1088 | 2024-03-07 20:58:49 | campus | 3 | 112716 | 720 | 9.360 | 12042.3 |
| 1087 | 2024-03-07 14:06:55 | campus | 3 | 112716 | 720 | 5.393 | 20900.4 |
| 1086 | 2024-03-07 02:48:15 | campus | 1 | 48755 | 5 | 1.906 | 25579.7 |
| 1085 | 2024-03-06 22:33:14 | campus | 3 | 112716 | 720 | 7.986 | 14114.2 |
| 1084 | 2024-03-06 21:41:31 | campus | 3 | 112716 | 720 | 12.140 | 9284.7 |
| 1083 | 2024-03-05 20:19:03 | campus | 3 | 112716 | 720 | 12.813 | 8797.0 |
| 1082 | 2024-02-29 08:09:54 | campus | 3 | 112716 | 720 | 9.843 | 11451.4 |
| 1081 | 2024-02-28 10:32:47 | campus | 3 | 112716 | 720 | 15.643 | 7205.5 |
| 1080 | 2024-02-28 06:34:45 | campus | 3 | 112716 | 720 | 7.220 | 15611.6 |
| 1079 | 2024-02-27 16:37:49 | campus | 3 | 112716 | 720 | 5.330 | 21147.5 |
| 1078 | 2024-02-26 17:29:48 | campus | 3 | 112716 | 720 | 6.250 | 18034.6 |
| 1077 | 2024-02-25 12:02:47 | campus | 2 | 82551 | 71 | 2.953 | 27955.0 |
| 1076 | 2024-02-25 12:02:27 | campus | 3 | 112716 | 720 | 6.326 | 17817.9 |
| 1075 | 2024-02-25 09:01:46 | campus | 3 | 112716 | 720 | 5.970 | 18880.4 |
| 1074 | 2024-02-24 12:15:20 | campus | 3 | 112716 | 720 | 4.860 | 23192.6 |
| 1073 | 2024-02-23 17:24:44 | campus | 3 | 112716 | 720 | 5.563 | 20261.7 |
| 1072 | 2024-02-09 18:01:20 | campus | 3 | 112716 | 720 | 4.983 | 22620.1 |
| 1071 | 2024-02-08 00:22:10 | campus | 3 | 112716 | 720 | 22.656 | 4975.1 |
| 1070 | 2024-02-04 20:14:26 | campus | 2 | 82551 | 71 | 8.453 | 9765.9 |
| 1069 | 2024-02-04 20:13:41 | campus | 3 | 112716 | 720 | 6.436 | 17513.4 |
| 1068 | 2024-02-04 12:46:22 | campus | 3 | 112716 | 720 | 18.156 | 6208.2 |
| 1067 | 2024-02-03 14:44:14 | campus | 3 | 112716 | 720 | 11.033 | 10216.3 |
| 1066 | 2024-02-01 19:23:52 | campus | 3 | 112716 | 720 | 6.283 | 17939.8 |
| 1065 | 2024-01-26 06:11:14 | campus | 2 | 82551 | 71 | 3.013 | 27398.3 |
| 1064 | 2024-01-23 12:11:03 | campus | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 1063 | 2024-01-12 19:03:55 | campus | 3 | 112716 | 720 | 5.766 | 19548.4 |
| 1062 | 2023-12-30 12:25:01 | campus | 3 | 112716 | 720 | 4.830 | 23336.6 |
| 1061 | 2023-12-25 13:28:48 | campus | 3 | 112716 | 720 | 4.970 | 22679.3 |
| 1060 | 2023-12-21 07:31:34 | campus | 3 | 112716 | 720 | 5.720 | 19705.6 |
| 1059 | 2023-12-03 06:18:50 | campus | 3 | 112716 | 720 | 5.470 | 20606.2 |
| 1058 | 2023-12-03 06:18:43 | campus | 3 | 112716 | 720 | 6.000 | 18786.0 |
| 1057 | 2023-12-02 04:45:40 | campus | 3 | 112716 | 720 | 5.093 | 22131.6 |
| 1056 | 2023-11-29 22:04:52 | campus | 2 | 82551 | 71 | 2.173 | 37989.4 |
| 1055 | 2023-11-29 03:45:35 | campus | 2 | 82551 | 71 | 3.096 | 26663.8 |
| 1054 | 2023-11-19 03:03:41 | campus | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 1053 | 2023-11-17 00:35:04 | campus | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 1052 | 2023-11-15 08:43:20 | campus | 3 | 112716 | 720 | 5.690 | 19809.5 |
| 1051 | 2023-11-12 03:33:15 | campus | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 1050 | 2023-11-10 18:24:03 | campus | 3 | 112716 | 720 | 5.563 | 20261.7 |
| 1049 | 2023-11-10 06:07:45 | campus | 3 | 112716 | 720 | 5.686 | 19823.4 |
| 1048 | 2023-11-09 19:29:50 | campus | 3 | 112716 | 720 | 5.453 | 20670.5 |
| 1047 | 2023-11-09 02:56:03 | campus | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 1046 | 2023-11-07 16:38:50 | campus | 3 | 112716 | 720 | 5.796 | 19447.2 |
| 1045 | 2023-11-06 16:34:18 | campus | 3 | 112716 | 720 | 6.063 | 18590.8 |
| 1044 | 2023-11-06 13:01:02 | campus | 2 | 82551 | 71 | 3.110 | 26543.7 |
| 1043 | 2023-11-06 02:26:53 | campus | 3 | 112716 | 720 | 5.546 | 20323.8 |
| 1042 | 2023-11-05 18:39:47 | campus | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 1041 | 2023-11-05 17:07:59 | campus | 3 | 112716 | 720 | 5.313 | 21215.1 |
| 1040 | 2023-11-04 23:33:35 | campus | 2 | 82551 | 71 | 2.296 | 35954.3 |
| 1039 | 2023-11-04 16:01:35 | campus | 3 | 112716 | 720 | 5.296 | 21283.2 |
| 1038 | 2023-11-04 07:02:32 | campus | 3 | 112716 | 720 | 4.703 | 23966.8 |
| 1037 | 2023-11-03 16:49:30 | campus | 3 | 112716 | 720 | 5.563 | 20261.7 |
| 1036 | 2023-11-03 02:02:36 | campus | 3 | 112716 | 720 | 4.970 | 22679.3 |
| 1035 | 2023-11-02 15:55:20 | campus | 3 | 112716 | 720 | 5.376 | 20966.5 |
| 1034 | 2023-11-02 00:37:22 | campus | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 1033 | 2023-11-01 15:56:02 | campus | 3 | 112716 | 720 | 5.563 | 20261.7 |
| 1032 | 2023-11-01 14:35:27 | campus | 3 | 112716 | 720 | 4.750 | 23729.7 |
| 1031 | 2023-11-01 14:34:57 | campus | 2 | 82551 | 71 | 2.453 | 33653.1 |
| 1030 | 2023-11-01 05:00:05 | campus | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 1029 | 2023-10-31 21:08:58 | campus | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 1028 | 2023-10-31 18:53:42 | campus | 3 | 112716 | 720 | 5.516 | 20434.4 |
| 1027 | 2023-10-31 15:11:03 | campus | 3 | 112716 | 720 | 4.953 | 22757.1 |
| 1026 | 2023-10-30 19:00:39 | campus | 3 | 112716 | 720 | 6.140 | 18357.7 |
| 1025 | 2023-10-30 15:27:34 | campus | 3 | 112716 | 720 | 4.876 | 23116.5 |
| 1024 | 2023-10-29 15:02:43 | campus | 3 | 112716 | 720 | 7.440 | 15150.0 |
| 1023 | 2023-10-28 23:19:34 | campus | 3 | 112716 | 720 | 6.780 | 16624.8 |