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 “cloudlets” 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.

44 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
cloudlets124282(None) 
cloudless1243151cloudless
cloudlet1145501cloudlet_
cloudiest1235582cloudiest
couplets12389872c_ouplets
bloodless1234513bloodless
caudles103912813c_audle_s
cloddiest1334633cloddiest
closets94611603clo__sets
clouded11348833cloud_e_d
cloudier1135053cloudie_r
cloudiness1344113cloudiness
cloudland1371953cloudland
cloudlands1471713cloudlands
cloudlessly1752073cloudlessly
cloudlike1642553cloudlike
clouds94612353cloud___s
clouters10399803clou_ters
clouts87017203clou___ts
clowders14357473clowd_ers
clueless1035883cl_ueless
coddlers12359173c_oddlers
coddles114213593c_oddle_s
collets93517903c_o_llets
cordless11299963c_ordless
corslets1038273c_orslets
couldest1148353c_ouldest
coulees9315513c_ou_lees
couplers123311323c_ouplers
couples115317053c_ouple_s
couplet114717943c_ouplet_
crosslets1145183crosslets
culets85518513c__u_lets
cullets94015613c__ullets
cutlets94113653c__utlets
doublets11257363_doublets
flourless1243533flourless
lordless9277483_lordless
loudens8368053_loud_ens
loudest839933_loud_est
loudliest1035773_loudliest
loudness937013_loudness
outlets73616363__outlets
roundlets10175293_roundlets

Search took 7 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 Limit148641446.37323323.6
3Display Results44440.0331333.3
 (SQL Overall)178691446.82926166.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.