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

142 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
except179765(None) 
excepts1885201excepts
excerpt1845941excerpt
accept123210622accept
exceed1636172exceed
excel1437742exce_l
excels1536662excels
excepted2055232excepted
excerpts1943742excerpts
excess1546052excess
exempt1737452exempt
exert124624142ex_ert
expect1758902expect
expert15515352expert
exsect1558502exsect
exsert13414362exsert
extent132714912extent
incept102712752incept
percept133112522percept
recept103319072recept
accent105116263accent
accepts13356353accepts
adept81219643_adept
ascent84519653ascent
bewept13410323bewept
bicep115413543bicep_
biceps12447713biceps
celt65646713__celt
cent67451013__cent
cep75736333__cep_
cepe84926653__cepe
ceps86125953__ceps
clept95725773_clept
concept133314443concept
crept95125893_crept
deceit93018213deceit
decent94023703decent
descent102616293descent
discept12310623discept
docent92918683docent
ebbet93517293ebbe_t
echt95722903e_c_ht
eclat7523603e_clat
effect1437443effect
egest65222343e_gest
egret63327313egre_t
eject145016043e_ject
eldest72912683eldest
elect74327033e_lect
eluent6315483eluent
emcee9315943emce_e
emceed1136283emceed
emcees1037813emcees
emmet94221383emme_t
encrypt1445323encrypt
encyst1136203encyst
enrapt8313013enrapt
eocene8311613eocene
erect74129333e_rect
erupt74220063e_rupt
escape103811663escape
escheat12410403escheat
escort84616483escort
escot75320083esc_ot
event85924443e_vent
evert84929513e_vert
exact143516933ex_act
exactest1745453exactest
exalt123018533ex_alt
exceeds1733843exceeds
excepting2145873excepting
exception2046853exception
exceptive2345683exceptive
excerpted2153873excerpted
excerpter2063903excerpter
excerptor2063653excerptor
excide1638423excide
exciple1874683exciple
excise1538553excise
excite15310883excite
excreta1674623excreta
excrete1667163excrete
excuse1537423excuse
exec135313943ex_e_c
execs14539723ex_ecs
execute1636783execute
exed125420593ex_e_d
exempts1844023exempts
exerts133712293ex_erts
exes116530813ex_e_s
exeunt1338703exeunt
exhort16410803exhort
exigent1539513exigent
exist124618943ex_ist
exit114428673ex__it
expat14313813ex_pat
expects1866883expects
expel1448233expe_l
expels1547173expels
expend16247503expend
experts1659063experts
expo1349183ex__po
export15412183export
exsects1655573exsects
exserts1467013exserts
extant132714753extant
extend14267523extend
extents142610173extents
extern1348473extern
extort13513973extort
exult122814123ex_ult
facet106038523face_t
incent83320723incent
incepts11238283incepts
incest82918743incest
inept73622153_inept
kept106232943__kept
lept66440883__lept
lucent8313823lucent
nicest82315663nicest
nocent83217413nocent
oncet74626543once_t
oxcart1539523oxcart
percent113520603percent
percepts14247643percepts
precept133112513precept
reaccept1465123reaccept
receipt1159253receipt
recent83630853recent
recepts113010263recepts
scent75831623_scent
sept65844363__sept
sexiest142112223sexiest
sextet13916873sexte_t
slept75728103_slept
swept105720603_swept
tacet75840023tace_t
tercet83624913terce_t
unkept123710873unkept
unwept11389813unwept
wept95635053__wept
yclept1336013yclept

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 Filter1786911127160.203880251.2
2DLD Change Limit1127161426.00018786.0
3Display Results1421420.0463087.0
 (SQL Overall)1786911426.24928595.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.