Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “crosslets” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
crosslets114518(None) 
crosslet1049601crosslet_
corselets1147312corselets
corslets1038272c_orslets
cossets95014282c_oss_ets
cressets10309102cress_ets
crosscuts1343812crosscuts
crossers103912712cross_ers
crosses94220802cross_e_s
crossest1012012122cross_est
crossness1137092crossness
brooklets1543683brooklets
classless1143843classless
closets94611603clo_s_ets
cloudlets1242823cloudlets
collets93517903c_o_llets
corselet10414573corselet_
corsets94819803c_ors_ets
corslet9318063c_orslet_
cosets85824403c_o_s_ets
cosset84125863c_oss_et_
costless10310003c_ostless
couplets12389873c_ouplets
crassest103411523crass_est
crassness1136213crassness
cresses94219813cress_e_s
cresset93319943cress_et_
crestless1146783crestless
crochets15359833cro_chets
crockets16339543cro_ckets
croissants1252643croissants
cropless1237793cro_pless
croquets1955213cro_quets
crosiers103312083cro_siers
crossarms1343973crossarms
crossbars1344433crossbars
crossbeam1543383crossbeam
crossbeams1652443crossbeams
crossbows1643073crossbows
crossbreds1542923crossbreds
crosscut1245253crosscut_
crosse85216313cross_e__
crossed105313903cross_e_d
crosser95015473cross_e_r
crosshead1543813crosshead
crossheads1643243crossheads
crossings12217163crossings
crossly1277273crossl__y
crossovers1593563crossovers
crossties1139023crossties
crosstrees1244463crosstrees
crossways1743413crossways
crotchets16396303crotchets
crownets13407673cro_wnets
crownless1443423crownless
crowsteps1642533crowsteps
crusets93811043cr_us_ets
crustless1155403crustless
droplets1136063dro_plets
drosses84513823dross_e_s
drossiest1036523drossiest
froglets1235263fro_glets
frontlets1244233frontlets
frostless1235743frostless
grassless1034303grassless
grossers94410973gross_ers
grosses84517683gross_e_s
grossest93810093gross_est
grossness1045973grossness
lossless835473_lossless
possets94212773_poss_ets
prosses94019513pross_e_s
prossies101515233prossie_s
rassles73513923_rassle_s
rootlets8308653_rootlets
rosets65819953_ro_s_ets
russets738163_russ_ets
wrassles11376713wrassle_s
wristlets1244473wristlets

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.423422437.4
2DLD Change Limit148641798.15618224.7
3Display Results79790.0302633.3
 (SQL Overall)178691798.60920756.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.