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

64 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
defaults124333(None) 
default1147891default_
defats105114552defa__ts
defaulted1443312defaulted
defaulter1343132defaulter
defaulters1442382defaulters
desalts839572desa_lts
faults94513552__faults
assaults843863assaults
beauts86015283be_au_ts
befalls12349123befa_lls
befouls1236053befoul_s
daunts75014083d__aunts
dauts67822243d__au_ts
deals65435343de_a_l_s
dealt65234283de_a_lt_
debacles1335723debacles
debuts93911753de_bu_ts
decals93717713deca_l_s
decants103514443deca_nts
deducts1166593de_ducts
defacers14237993defacers
defaces133213403defa_ces
defamers14258523defamers
defames132812253defa_mes
defangs1235363defa_ngs
defat95426693defa__t_
defaulting1543393defaulting
defeats113511233def_eats
defects134511523def_ects
deficits1447283deficits
defiles114016843def_iles
deflects14336733deflects
defrauds1343243defrau_ds
defrosts1244833defrosts
defuels11296983def_uels
defunds12376753def_unds
defuses114814593def_uses
defuzes20398303def_uzes
degauss933923degau_ss
degusts936063de_gusts
delts65731793de___lts
demasts1089223dema_sts
demounts1135473demounts
depaints1136643depaints
departs104310683depa_rts
derails84216393derail_s
derats74625063dera__ts
desalt7518313desa_lt_
details84214043detail_s
devalues1235853devalues
dewfalls1543073dewfa_lls
epaulets1043733_epaulets
exalts13328313_exa_lts
exults13257633_e_xults
faulds10438963__faulds
fault85428313__fault_
faulty12429363__faulty
gaults74112783__gaults
penults937123pe_nults
refalls103312243refa_lls
results739833re_sults
saults65816173__saults
vaults94511673__vaults

Search took 8 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 Limit146162646.73321708.3
3Display Results64640.0331939.4
 (SQL Overall)178691647.17224915.1
 
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.