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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
excepts188520(None) 
except1797651except_
excerpts1943741excerpts
accepts13356352accepts
exceeds1733842exceeds
excels1536662exce_ls
excepted2055232excepted
excerpt1845942excerpt_
excess1546052exce_ss
exempts1844022exempts
exerts133712292ex_erts
expects1866882expects
experts1659062experts
exsects1655572exsects
exserts1467012exserts
extents142610172extents
incepts11238282incepts
percepts14247642percepts
recepts113010262recepts
accents113511233accents
accept123210623accept_
adepts9117103_adepts
ascents93812553ascents
biceps12447713bicep_s
celts75325783__celts
cents74730333__cents
cepes94424463__cepes
ceps86125953__cep_s
concepts143110303concepts
deceits102810883deceits
descents112511203descents
discepts1336743discepts
docents102810803docents
ebbets10376833ebbe_ts
ecesis84611203e_cesis
eclats8313033e_clats
effects1535283effects
egests74411253e_gests
egrets72712243egre_ts
ejects15409953e_jects
elects83315003e_lects
eluents738703eluents
emcees1037813emce_es
emmets10349153emme_ts
encrypts1542983encrypts
encysts1244313encysts
erects84116183e_rects
erupts8348903e_rupts
escapes113811673escapes
escheats1346253escheats
escorts9418403escorts
escots84211743esc_ots
events94814073e_vents
everts94514893e_verts
exacts15359613ex_acts
exalts13328313ex_alts
exceed1636173exce_ed
excel1437743exce__l
excepting2145873excepting
exception2046853exception
exceptions2146863exceptions
exceptive2345683exceptive
excerpted2153873excerpted
excerpter2063903excerpter
excerpters2143183excerpters
excerptor2063653excerptor
excerptors2163463excerptors
excesses1736753excesses
excides1738343excides
exciple1874683exciple
exciples1964773exciples
excises1638933excises
excite15310883exc_ite
excites16310633excites
excreta1674623excreta
excrete1667163excrete
excretes1787573excretes
excuses1638903excuses
execs14539723ex_e_cs
execute1636783execute
executes1736533executes
exempt1737453exempt_
exert124624143ex_ert_
exes116530813ex_e__s
exhorts1746313exhorts
exists134710913ex_ists
exits125515913ex__its
expats1537683ex_pats
expect1758903expect_
expels1547173expe_ls
expends17217083expends
expert15515353expert_
exports1647983exports
expos1449203ex__pos
exsect1558503exsect_
exsert13414363exsert_
extends15227113extends
extent132714913extent_
externs1438233externs
extorts1447753extorts
exults13257633ex_ults
facets116316653face_ts
incents92414533incents
incept102712753incept_
incests92711383incests
oxcarts1634313oxcarts
percents122713373percents
percept133112523percept_
precepts14268893precepts
reaccepts1583213reaccepts
receipts1274693receipts
recept103319073recept_
scents85317023_scents
septs75420603__septs
sextets1497143sexte_ts
tercets93512443terce_ts

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.1401276364.3
2DLD Change Limit1340271166.53320515.4
3Display Results1161160.0462521.7
 (SQL Overall)1786911166.71926594.9
 
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.