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 “cornets” with Change Limit: [1] [2] [3]

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

80 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
cornets9482057(None) 
carnets93918401carnets
corneas94717001corneas
cornels94716661cornels
corners94723311corners
cornet84436731cornet_
coronets103814361coronets
corsets94819801corsets
corvets124715021corvets
hornets104113551hornets
bonnets94812802bonnets
burnets93813262burnets
carets85330772car_ets
carnet84732872carnet_
carneys124310542carneys
carpets113915332carpets
cermets1139712cermets
cobnuts1135352cobnuts
coiners93620752coiners
collets93517902collets
comets105823582co_mets
cones76457422co_ne_s
coneys115218422co_neys
connects123010562connects
conners94023112conners
contes84432912co_ntes
coquets18399892coquets
corbels113813592corbels
corders104520882corders
corers85231072cor_ers
cores76361852cor_e_s
corkers134118852corkers
cormels113813372cormels
cornea84018932corne_a
corneal94414502corneal
corned95224522corne_d
corneitis1146492corneitis
cornel84020052corne_l
corneous10310032corneous
corner84625622corne_r
cornetcy1544302cornetcy
cornetist1149762cornetist
corniest102117302corniest
corns76034762corn__s
cornus84816562corn_us
cornute939642cornute
cornuto937032cornuto
cornutos1046052cornutos
coronels104012152coronels
coroners104016232coroners
coronet94227172coronet_
corrects1259572corrects
corses84433462corse_s
corset85636222corset_
corslets1038272corslets
corvees124613792corvees
corves115122522corve_s
corvet114626932corvet_
cosets85824402co_sets
cossets95014282cossets
counts84618272coun_ts
covets114819642co_vets
coyness1277322coyness
crones84729242crone_s
crownets13407672crownets
cruets85314952c_ruets
curets84922342cur_ets
curvets12399912curvets
cygnets1333812cygnets
forgets113813792forgets
garnets84115402garnets
gorgets94711782gorgets
gurnets84010792gurnets
hornet94926432hornet_
nonets64118702no_nets
scorners10228492scorners
sonnets74211992sonnets
sorbets93012512sorbets
sorners73416872sorners
worsets105512842worsets

Search took 6 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 Filter1786911076710.393454684.5
2DLD Change Limit107671805.29620330.6
3Display Results80800.0136153.8
 (SQL Overall)178691805.70231338.3
 
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.