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

93 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
default114789(None) 
defaults1243331defaults
dealt65234282de_a_lt
defat95426692defa__t
defaulted1443312defaulted
defaulter1343132defaulter
desalt7518312desa_lt
fault85428312__fault
assault747413assault
beaut75135213be_au_t
befall114410643befa_ll
befalls12349123befalls
befoul1137253befoul_
befouls1236053befouls
daunt65929083d__aunt
daut56443563d__au_t
deadly113811473de_adly
deafest112911513deafest
deafly13389123de_afly
deal56347413de_a_l_
deals65435343de_a_ls
dearly104615323de_arly
debacle1237443debacle
debauch15134423debauch
debut86024143de_bu_t
decal85523233deca_l_
decals93717713deca_ls
decant93524223deca_nt
dedal75719023deda_l_
deduct10610793de_duct
deface123113863defa_ce
defaced142910973defaced
defacer132810363defacer
defaces133213403defaces
defame123212433defa_me
defamed14309833defamed
defamer132710323defamer
defames132812253defames
defang1137753defa_ng
defangs1235363defangs
defats105114553defa_ts
defaulters1442383defaulters
defaulting1543393defaulting
defeat103817163def_eat
defect124816173def_ect
deffest14308803deffest
defiant11311923defiant
deficit1339673deficit
defile105216663def_ile
deflect13399973deflect
defraud1243913defrau_d
defrauds1343243defrauds
defrost1139553defrost
deft85540223def___t
deftest112611713deftest
deftly1336533def_tly
defuel10348933def_uel
defuels11296983defuels
defunct1345773defunct
defund11447983def_und
defuse105712723def_use
defuze19487843def_uze
degauss933923degauss
degust8310253de_gust
delt57855273de___lt
demast9517063dema_st
demount1049743demount
depaint10314593depaint
depart94720563depa_rt
derail74218813derail_
derails84216393derails
derat65044083dera__t
desalts839573desa_lts
detail74516433detail_
details84214043details
devalue1136013devalue
devout10712993devou_t
dewfall1453763dewfa_ll
dewfalls1543073dewfalls
epaulet939513_epaulet
exalt123018533_exa_lt
exult122814123_e_xult
fauld95214493__fauld
faults94513553__faults
faulty12429363__faulty
gault65128483__gault
penult8314653pe_nult
refall94314393refa_ll
refalls103312243refalls
refelt94521423ref_elt
result6318223re_sult
sault55834963__sault
vault85823763__vault

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 Filter1786911340270.390458182.1
2DLD Change Limit134027936.40620922.1
3Display Results93930.0332818.2
 (SQL Overall)178691936.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.