History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roof"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1072 | 2025-11-01 07:47:19 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1071 | 2025-10-21 19:29:26 | roof | 2 | 29872 | 201 | 4.436 | 6734.0 |
| 1070 | 2025-10-20 12:23:19 | roof | 1 | 13983 | 14 | 0.563 | 24836.6 |
| 1069 | 2025-10-09 23:42:21 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1068 | 2025-10-05 01:28:57 | roof | 1 | 13983 | 14 | 0.596 | 23461.4 |
| 1067 | 2025-10-03 22:33:06 | roof | 2 | 29872 | 201 | 0.813 | 36742.9 |
| 1066 | 2025-10-01 10:49:25 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1065 | 2025-09-27 02:19:46 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
| 1064 | 2025-09-25 10:23:19 | roof | 1 | 13983 | 14 | 0.483 | 28950.3 |
| 1063 | 2025-09-25 00:14:39 | roof | 1 | 13983 | 14 | 1.156 | 12096.0 |
| 1062 | 2025-09-24 00:08:55 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
| 1061 | 2025-09-22 22:00:12 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1060 | 2025-09-20 05:02:16 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1059 | 2025-09-16 21:16:40 | roof | 1 | 13983 | 14 | 0.516 | 27098.8 |
| 1058 | 2025-09-15 19:18:14 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
| 1057 | 2025-09-13 13:15:54 | roof | 1 | 13983 | 14 | 0.516 | 27098.8 |
| 1056 | 2025-09-10 05:41:54 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
| 1055 | 2025-09-08 05:06:40 | roof | 2 | 29872 | 201 | 0.890 | 33564.0 |
| 1054 | 2025-09-07 21:49:37 | roof | 1 | 13983 | 14 | 0.283 | 49409.9 |
| 1053 | 2025-09-06 22:54:46 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1052 | 2025-09-03 15:37:50 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1051 | 2025-09-02 12:26:55 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
| 1050 | 2025-09-01 06:19:56 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
| 1049 | 2025-08-31 08:11:06 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
| 1048 | 2025-08-28 00:47:01 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1047 | 2025-08-27 16:23:06 | roof | 1 | 13983 | 14 | 0.936 | 14939.1 |
| 1046 | 2025-08-24 17:37:15 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1045 | 2025-08-23 20:43:10 | roof | 1 | 13983 | 14 | 0.263 | 53167.3 |
| 1044 | 2025-08-18 23:08:40 | roof | 1 | 13983 | 14 | 1.830 | 7641.0 |
| 1043 | 2025-08-18 00:30:03 | roof | 1 | 13983 | 14 | 1.046 | 13368.1 |
| 1042 | 2025-08-14 15:45:19 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
| 1041 | 2025-08-09 13:31:35 | roof | 1 | 13983 | 14 | 1.156 | 12096.0 |
| 1040 | 2025-08-09 13:26:26 | roof | 1 | 13983 | 14 | 0.546 | 25609.9 |
| 1039 | 2025-08-07 21:57:55 | roof | 1 | 13983 | 14 | 0.263 | 53167.3 |
| 1038 | 2025-08-04 13:42:12 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1037 | 2025-08-04 06:23:52 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
| 1036 | 2025-08-01 22:28:30 | roof | 2 | 29872 | 201 | 3.643 | 8199.8 |
| 1035 | 2025-07-27 19:01:41 | roof | 1 | 13983 | 14 | 0.690 | 20265.2 |
| 1034 | 2025-07-27 03:07:07 | roof | 1 | 13983 | 14 | 1.360 | 10281.6 |
| 1033 | 2025-07-26 17:48:58 | roof | 1 | 13983 | 14 | 0.686 | 20383.4 |
| 1032 | 2025-07-25 22:17:00 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1031 | 2025-07-24 18:21:27 | roof | 1 | 13983 | 14 | 1.500 | 9322.0 |
| 1030 | 2025-07-22 04:42:20 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1029 | 2025-07-20 01:09:50 | roof | 2 | 29872 | 201 | 0.923 | 32364.0 |
| 1028 | 2025-07-17 23:00:09 | roof | 1 | 13983 | 14 | 1.220 | 11461.5 |
| 1027 | 2025-07-14 05:01:46 | roof | 1 | 13983 | 14 | 1.203 | 11623.4 |
| 1026 | 2025-07-12 04:29:16 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
| 1025 | 2025-07-11 17:26:52 | roof | 2 | 29872 | 201 | 4.313 | 6926.0 |
| 1024 | 2025-07-09 13:39:21 | roof | 2 | 29872 | 201 | 1.266 | 23595.6 |
| 1023 | 2025-07-09 12:23:37 | roof | 1 | 13983 | 14 | 0.843 | 16587.2 |
| 1022 | 2025-07-08 20:05:44 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
| 1021 | 2025-07-08 11:47:37 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
| 1020 | 2025-07-07 12:33:20 | roof | 1 | 13983 | 14 | 0.936 | 14939.1 |
| 1019 | 2025-07-05 17:04:26 | roof | 1 | 13983 | 14 | 1.860 | 7517.7 |
| 1018 | 2025-07-02 12:20:24 | roof | 1 | 13983 | 14 | 1.373 | 10184.3 |
| 1017 | 2025-07-02 06:47:47 | roof | 1 | 13983 | 14 | 0.686 | 20383.4 |
| 1016 | 2025-06-28 19:30:41 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 1015 | 2025-06-27 17:42:02 | roof | 1 | 13983 | 14 | 0.283 | 49409.9 |
| 1014 | 2025-06-27 15:32:44 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
| 1013 | 2025-06-21 21:39:58 | roof | 1 | 13983 | 14 | 0.983 | 14224.8 |
| 1012 | 2025-06-20 06:53:14 | roof | 1 | 13983 | 14 | 1.263 | 11071.3 |
| 1011 | 2025-06-12 04:24:20 | roof | 2 | 29872 | 201 | 4.780 | 6249.4 |
| 1010 | 2025-06-10 19:03:13 | roof | 2 | 29872 | 201 | 4.423 | 6753.8 |
| 1009 | 2025-06-08 12:19:09 | roof | 1 | 13983 | 14 | 1.640 | 8526.2 |
| 1008 | 2025-06-02 15:52:01 | roof | 2 | 29872 | 201 | 4.110 | 7268.1 |
| 1007 | 2025-06-02 11:49:10 | roof | 1 | 13983 | 14 | 1.110 | 12597.3 |
| 1006 | 2025-06-02 05:01:36 | roof | 2 | 29872 | 201 | 4.860 | 6146.5 |
| 1005 | 2025-06-01 01:27:03 | roof | 1 | 13983 | 14 | 1.483 | 9428.9 |
| 1004 | 2025-05-31 20:11:56 | roof | 2 | 29872 | 201 | 5.000 | 5974.4 |
| 1003 | 2025-05-28 18:41:28 | roof | 1 | 13983 | 14 | 0.216 | 64736.1 |
| 1002 | 2025-05-27 14:32:07 | roof | 1 | 13983 | 14 | 1.826 | 7657.7 |
| 1001 | 2025-05-26 18:37:14 | roof | 1 | 13983 | 14 | 1.030 | 13575.7 |
| 1000 | 2025-05-26 13:25:57 | roof | 1 | 13983 | 14 | 1.810 | 7725.4 |
| 999 | 2025-05-26 11:22:27 | roof | 1 | 13983 | 14 | 0.703 | 19890.5 |
| 998 | 2025-05-23 17:51:17 | roof | 1 | 13983 | 14 | 2.063 | 6778.0 |
| 997 | 2025-05-20 21:39:24 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 996 | 2025-05-15 23:09:01 | roof | 1 | 13983 | 14 | 1.203 | 11623.4 |
| 995 | 2025-05-11 23:18:43 | roof | 1 | 13983 | 14 | 0.686 | 20383.4 |
| 994 | 2025-05-11 03:05:47 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
| 993 | 2025-05-10 21:16:25 | roof | 2 | 29872 | 201 | 4.283 | 6974.6 |
| 992 | 2025-05-09 11:43:25 | roof | 1 | 13983 | 14 | 0.263 | 53167.3 |
| 991 | 2025-05-04 10:54:43 | roof | 1 | 13983 | 14 | 0.686 | 20383.4 |
| 990 | 2025-05-02 16:14:48 | roof | 2 | 29872 | 201 | 6.110 | 4889.0 |
| 989 | 2025-05-02 11:41:09 | roof | 1 | 13983 | 14 | 0.686 | 20383.4 |
| 988 | 2025-05-02 05:25:17 | roof | 2 | 29872 | 201 | 4.063 | 7352.2 |
| 987 | 2025-04-30 14:11:58 | roof | 2 | 29872 | 201 | 7.016 | 4257.7 |
| 986 | 2025-04-29 06:59:44 | roof | 1 | 13983 | 14 | 0.670 | 20870.1 |
| 985 | 2025-04-28 04:21:16 | roof | 2 | 29872 | 201 | 4.796 | 6228.5 |
| 984 | 2025-04-27 08:57:56 | roof | 2 | 29872 | 201 | 0.966 | 30923.4 |
| 983 | 2025-04-26 16:26:31 | roof | 1 | 13983 | 14 | 0.970 | 14415.5 |
| 982 | 2025-04-19 18:49:44 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
| 981 | 2025-04-14 22:46:55 | roof | 1 | 13983 | 14 | 0.736 | 18998.6 |
| 980 | 2025-04-06 11:05:20 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
| 979 | 2025-04-01 06:45:29 | roof | 2 | 29872 | 201 | 4.686 | 6374.7 |
| 978 | 2025-03-31 18:06:49 | roof | 2 | 29872 | 201 | 4.563 | 6546.6 |
| 977 | 2025-03-31 07:01:59 | roof | 2 | 29872 | 201 | 3.360 | 8890.5 |
| 976 | 2025-03-30 09:24:33 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
| 975 | 2025-03-29 16:54:51 | roof | 2 | 29872 | 201 | 3.580 | 8344.1 |
| 974 | 2025-03-29 07:55:34 | roof | 1 | 13983 | 14 | 0.890 | 15711.2 |
| 973 | 2025-03-28 05:23:32 | roof | 2 | 29872 | 201 | 1.343 | 22242.7 |