History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"name"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1099 | 2025-05-08 06:36:34 | name | 1 | 13983 | 20 | 0.296 | 47239.9 |
1098 | 2025-05-07 20:00:49 | name | 1 | 13983 | 20 | 1.250 | 11186.4 |
1097 | 2025-05-03 05:32:13 | name | 2 | 29872 | 347 | 2.310 | 12931.6 |
1096 | 2025-05-01 12:17:33 | name | 2 | 29872 | 347 | 3.200 | 9335.0 |
1095 | 2025-05-01 10:01:17 | name | 1 | 13983 | 20 | 1.733 | 8068.7 |
1094 | 2025-04-30 01:20:57 | name | 1 | 13983 | 20 | 0.313 | 44674.1 |
1093 | 2025-04-29 17:16:16 | name | 1 | 13983 | 20 | 0.250 | 55932.0 |
1092 | 2025-04-29 13:46:57 | name | 1 | 13983 | 20 | 1.093 | 12793.2 |
1091 | 2025-04-27 05:58:10 | name | 1 | 13983 | 20 | 0.250 | 55932.0 |
1090 | 2025-04-27 05:50:18 | name | 1 | 13983 | 20 | 0.266 | 52567.7 |
1089 | 2025-04-20 16:04:14 | name | 1 | 13983 | 20 | 0.250 | 55932.0 |
1088 | 2025-04-16 15:47:01 | name | 2 | 29872 | 347 | 4.233 | 7056.9 |
1087 | 2025-04-14 23:53:25 | name | 2 | 29872 | 347 | 4.143 | 7210.2 |
1086 | 2025-04-14 13:39:01 | name | 1 | 13983 | 20 | 0.266 | 52567.7 |
1085 | 2025-04-09 05:37:48 | name | 2 | 29872 | 347 | 3.780 | 7902.6 |
1084 | 2025-04-07 19:20:51 | name | 1 | 13983 | 20 | 0.220 | 63559.1 |
1083 | 2025-03-31 12:19:47 | name | 1 | 13983 | 20 | 0.950 | 14718.9 |
1082 | 2025-03-29 19:30:52 | name | 1 | 13983 | 20 | 0.843 | 16587.2 |
1081 | 2025-03-26 06:13:36 | name | 1 | 13983 | 20 | 0.686 | 20383.4 |
1080 | 2025-03-25 23:05:43 | name | 1 | 13983 | 20 | 1.200 | 11652.5 |
1079 | 2025-03-21 07:12:12 | name | 1 | 13983 | 20 | 0.266 | 52567.7 |
1078 | 2025-03-20 18:59:25 | name | 1 | 13983 | 20 | 0.970 | 14415.5 |
1077 | 2025-03-19 03:49:47 | name | 1 | 13983 | 20 | 0.236 | 59250.0 |
1076 | 2025-03-14 20:21:32 | name | 1 | 13983 | 20 | 0.280 | 49939.3 |
1075 | 2025-03-14 07:35:33 | name | 1 | 13983 | 20 | 0.670 | 20870.1 |
1074 | 2025-03-06 23:28:18 | name | 2 | 29872 | 347 | 4.313 | 6926.0 |
1073 | 2025-03-06 23:04:10 | name | 1 | 13983 | 20 | 0.236 | 59250.0 |
1072 | 2025-03-04 19:17:02 | name | 1 | 13983 | 20 | 1.376 | 10162.1 |
1071 | 2025-03-03 08:46:41 | name | 1 | 13983 | 20 | 0.233 | 60012.9 |
1070 | 2025-02-25 05:47:27 | name | 2 | 29872 | 347 | 3.533 | 8455.1 |
1069 | 2025-02-25 05:26:46 | name | 1 | 13983 | 20 | 0.250 | 55932.0 |
1068 | 2025-02-25 04:33:52 | name | 2 | 29872 | 347 | 4.516 | 6614.7 |
1067 | 2025-02-25 04:10:48 | name | 1 | 13983 | 20 | 0.233 | 60012.9 |
1066 | 2025-02-25 01:10:37 | name | 1 | 13983 | 20 | 1.343 | 10411.8 |
1065 | 2025-02-22 19:59:30 | name | 1 | 13983 | 20 | 0.250 | 55932.0 |
1064 | 2025-02-20 13:48:22 | name | 1 | 13983 | 20 | 0.643 | 21746.5 |
1063 | 2025-02-16 11:22:16 | name | 1 | 13983 | 20 | 1.376 | 10162.1 |
1062 | 2025-02-16 10:39:16 | name | 1 | 13983 | 20 | 1.203 | 11623.4 |
1061 | 2025-02-07 13:13:14 | name | 1 | 13983 | 20 | 1.110 | 12597.3 |
1060 | 2025-02-04 22:53:55 | name | 2 | 29872 | 347 | 6.736 | 4434.7 |
1059 | 2025-02-04 22:16:43 | name | 1 | 13983 | 20 | 0.250 | 55932.0 |
1058 | 2025-01-26 04:53:39 | name | 2 | 29872 | 347 | 4.186 | 7136.2 |
1057 | 2025-01-26 03:56:08 | name | 1 | 13983 | 20 | 0.250 | 55932.0 |
1056 | 2025-01-26 03:41:05 | name | 2 | 29872 | 347 | 6.366 | 4692.4 |
1055 | 2025-01-26 03:27:57 | name | 1 | 13983 | 20 | 0.233 | 60012.9 |
1054 | 2025-01-23 19:29:28 | name | 1 | 13983 | 20 | 1.216 | 11499.2 |
1053 | 2025-01-05 18:47:18 | name | 1 | 13983 | 20 | 0.546 | 25609.9 |
1052 | 2024-12-27 09:06:58 | name | 2 | 29872 | 347 | 6.486 | 4605.6 |
1051 | 2024-12-27 02:01:25 | name | 1 | 13983 | 20 | 0.406 | 34440.9 |
1050 | 2024-12-27 00:16:10 | name | 2 | 29872 | 347 | 5.453 | 5478.1 |
1049 | 2024-12-26 23:20:03 | name | 2 | 29872 | 347 | 1.826 | 16359.3 |
1048 | 2024-12-26 23:00:03 | name | 1 | 13983 | 20 | 0.220 | 63559.1 |
1047 | 2024-12-24 18:39:03 | name | 1 | 13983 | 20 | 1.500 | 9322.0 |
1046 | 2024-12-16 17:22:52 | name | 2 | 29872 | 347 | 3.830 | 7799.5 |
1045 | 2024-12-09 18:53:10 | name | 1 | 13983 | 20 | 1.360 | 10281.6 |
1044 | 2024-12-06 14:26:24 | name | 1 | 13983 | 20 | 0.843 | 16587.2 |
1043 | 2024-11-27 08:01:28 | name | 2 | 29872 | 347 | 4.376 | 6826.3 |
1042 | 2024-11-27 01:23:51 | name | 1 | 13983 | 20 | 1.283 | 10898.7 |
1041 | 2024-11-26 23:31:28 | name | 2 | 29872 | 347 | 2.140 | 13958.9 |
1040 | 2024-11-26 22:05:18 | name | 2 | 29872 | 347 | 6.143 | 4862.8 |
1039 | 2024-11-26 21:23:48 | name | 1 | 13983 | 20 | 0.250 | 55932.0 |
1038 | 2024-11-25 02:13:16 | name | 1 | 13983 | 20 | 0.656 | 21315.5 |
1037 | 2024-11-24 17:59:56 | name | 1 | 13983 | 20 | 1.566 | 8929.1 |
1036 | 2024-11-06 10:50:45 | name | 2 | 29872 | 347 | 3.190 | 9364.3 |
1035 | 2024-11-06 10:50:03 | name | 1 | 13983 | 20 | 1.190 | 11750.4 |
1034 | 2024-10-28 01:44:37 | name | 1 | 13983 | 20 | 0.250 | 55932.0 |
1033 | 2024-10-28 00:05:47 | name | 2 | 29872 | 347 | 3.966 | 7532.0 |
1032 | 2024-10-27 22:39:27 | name | 2 | 29872 | 347 | 1.953 | 15295.4 |
1031 | 2024-10-27 20:53:55 | name | 1 | 13983 | 20 | 0.890 | 15711.2 |
1030 | 2024-10-25 16:28:23 | name | 1 | 13983 | 20 | 0.283 | 49409.9 |
1029 | 2024-10-22 13:19:00 | name | 1 | 13983 | 20 | 0.700 | 19975.7 |
1028 | 2024-10-22 13:17:08 | name | 1 | 13983 | 20 | 1.953 | 7159.8 |
1027 | 2024-10-10 05:47:39 | name | 1 | 13983 | 20 | 0.266 | 52567.7 |
1026 | 2024-10-07 09:16:37 | name | 2 | 29872 | 347 | 5.080 | 5880.3 |
1025 | 2024-10-07 09:02:04 | name | 1 | 13983 | 20 | 2.436 | 5740.1 |
1024 | 2024-10-01 11:50:09 | name | 1 | 13983 | 20 | 2.626 | 5324.8 |
1023 | 2024-09-27 23:12:25 | name | 1 | 13983 | 20 | 1.970 | 7098.0 |
1022 | 2024-09-27 12:56:37 | name | 2 | 29872 | 347 | 6.580 | 4539.8 |
1021 | 2024-09-27 12:00:35 | name | 2 | 29872 | 347 | 3.376 | 8848.3 |
1020 | 2024-09-27 10:56:10 | name | 1 | 13983 | 20 | 1.390 | 10059.7 |
1019 | 2024-09-25 11:26:52 | name | 1 | 13983 | 20 | 0.690 | 20265.2 |
1018 | 2024-09-07 00:34:06 | name | 1 | 13983 | 20 | 1.626 | 8599.6 |
1017 | 2024-08-30 13:15:50 | name | 1 | 13983 | 20 | 2.110 | 6627.0 |
1016 | 2024-08-28 17:18:53 | name | 1 | 13983 | 20 | 0.216 | 64736.1 |
1015 | 2024-08-28 08:34:45 | name | 2 | 29872 | 347 | 4.173 | 7158.4 |
1014 | 2024-08-28 08:11:45 | name | 2 | 29872 | 347 | 7.500 | 3982.9 |
1013 | 2024-08-28 07:33:10 | name | 1 | 13983 | 20 | 0.236 | 59250.0 |
1012 | 2024-08-27 01:44:35 | name | 1 | 13983 | 20 | 2.470 | 5661.1 |
1011 | 2024-08-07 20:56:43 | name | 1 | 13983 | 20 | 0.373 | 37487.9 |
1010 | 2024-08-02 06:06:34 | name | 2 | 29872 | 347 | 2.876 | 10386.6 |
1009 | 2024-08-02 05:16:05 | name | 1 | 13983 | 20 | 0.940 | 14875.5 |
1008 | 2024-07-30 21:54:44 | name | 1 | 13983 | 20 | 0.986 | 14181.5 |
1007 | 2024-07-29 15:06:14 | name | 1 | 13983 | 20 | 0.250 | 55932.0 |
1006 | 2024-07-29 04:42:06 | name | 2 | 29872 | 347 | 1.266 | 23595.6 |
1005 | 2024-07-29 04:27:01 | name | 2 | 29872 | 347 | 4.750 | 6288.8 |
1004 | 2024-07-29 03:22:07 | name | 1 | 13983 | 20 | 1.186 | 11790.1 |
1003 | 2024-07-28 06:15:08 | name | 1 | 13983 | 20 | 1.170 | 11951.3 |
1002 | 2024-07-27 07:30:06 | name | 1 | 13983 | 20 | 0.846 | 16528.4 |
1001 | 2024-07-24 16:11:32 | name | 1 | 13983 | 20 | 1.203 | 11623.4 |
1000 | 2024-07-24 16:05:03 | name | 1 | 13983 | 20 | 1.046 | 13368.1 |