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

77 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
cigarets114547(None) 
cigaret10413001cigaret_
aigrets82810532aig_rets
cabarets12268462cabarets
carets85330772c__arets
cigarette1243782cigarette
cigarettes1343332cigarettes
cigars9910722cigar__s
clarets94111102c_larets
imarets9138642_imarets
minarets1048842minarets
aiglets84012913aig_lets
aigret73720023aig_ret_
bogarts1047743bogar_ts
cabaret112519043cabaret_
cadets96316513c__adets
carats85929023c__arats
carers85133963c__arers
cares77369183c__are_s
caress85720263c__aress
caret75360563c__aret_
carnets93918403c__arnets
carpets113915333c__arpets
cartes86239473c__artes
carts78946293c__ar_ts
cellarets11246063cellarets
chalets122813473c_halets
chares115631803c_hare_s
charts115823093c_har_ts
chevrets16255323chevrets
chivarees1744383chivarees
cicorees1246413cicorees
cigar8911803cigar___
circlets1235663circlets
cires74932913ci__re_s
citadels1142843citadels
cithrens13355933cithrens
citrates102315093citrates
civets115212543ci__vets
claret84026573c_laret_
clearers10349303clearers
clearest1038653clearest
coffrets1645363coffrets
collarets11327333collarets
coparents1347973coparents
curares94916853curare_s
curets84922343c__urets
cygnets1333813cyg_nets
digress938323dig_ress
egrets72712243_eg_rets
figurers12254873figurers
figures11239113figure_s
filarees1187643filarees
gargets94614573__gargets
garnets84115403__garnets
garrets84413623__garrets
gigabits1243533gigabits
giglets93211553gig_lets
imaret81121233_imaret_
lazarets1744803lazarets
ligaments1246203ligaments
ligases82310713ligase_s
ligates82318383ligate_s
ligures8269893ligure_s
migrants1138183migrants
migrates111112853migrates
minaret9520683minaret_
piglets103311793pig_lets
pugarees11195493pugarees
regrets83212923reg_rets
signets83311503sig_nets
starets73515923_starets
sugarers936303sugarers
tabarets10287233tabarets
tigress836093tig_ress
vilayets1443073vilayets
wiglets113411423wig_lets

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 Filter1786911461620.406440125.6
2DLD Change Limit146162776.45322650.2
3Display Results77770.0302566.7
 (SQL Overall)178691776.88925938.6
 
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.