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

197 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
accept12321063(None) 
accent105116261accent
accepts13356361accepts
accede1138302accede
accents113511232accents
accepted15105402accepted
acceptee14105742acceptee
accepter14144952accepter
acceptor14114912acceptor
access1037682access
accost101112262accost
adept81219642a_dept
ascent84519652ascent
clept95725772_clept
crept95125892_crept
except1797652except
incept102712762incept
reaccept1465122reaccept
recept103319082recept
yclept1336012yclept
abet610547943a_be_t
abject17137703abject
ablest84721833ablest
abrupt1039943abrupt
absent84016993absent
acaleph1453443acaleph
acceded1336113acceded
acceder1235363acceder
accedes1237723accedes
accented13107793accented
accentor12106133accentor
acceptant1545033acceptant
acceptees15113713acceptees
accepters15114623accepters
accepting1695813accepting
acceptive1845083acceptive
acceptors15114803acceptors
accident13148183accident
accord1178843accord
accosts11107993accosts
account11109043account
accredit1344843accredit
accrete1137843accrete
accrue1035823accrue
accurst1146243accurst
accuse103411033accuse
ace59656833a_ce__
aced79540883a_ce_d
acerb9312763a_cerb
aces67645093a_ce_s
acescent1248013acescent
aceta74017353a_ceta
ache96829823ache__
ached119227833ache_d
achene11313813achene
aches106132293ache_s
achiest12315193achiest
ackee115825373acke_e
ackees124914583ackees
acme86924323acme__
acmes96020653acme_s
acne66625873acne__
acned87520673acne_d
acnes75922623acne_s
acquest1837173acquest
acquit17610323acquit
acre67330773acre__
acred87126353acre_d
acres76327763acre_s
act59557843a_c__t
acted88521733acte_d
acutest94410603acutest
adapt81218553a_dapt
adepts9117103a_depts
adopt81219743a_dopt
advect12309123advect
advent102613753advent
advert103215783advert
affect1448903affect
afreet9315153afreet
agent65829643a_gent
aglet65534143agle_t
airest63825263airest
albeit8314343albeit
aleph10311393a_leph
alert54740663a_lert
ament76036543a_ment
ancient9514733ancient
anent54931843a_nent
apt57352543a___pt
aptest82917513aptest
arced88224163arce_d
ardent73022613ardent
arepa75615563a_repa
argent74023663argent
armet76739453arme_t
arpent84822093arpent
arrest63722633arrest
ascend9429733ascend
ascents93812553ascents
ascot76522513asc_ot
aspect10612823aspect
assent65119953assent
assert64922583assert
asset55932263asse_t
attempt1145373attempt
attent62818323attent
attest62618613attest
avert86029493a_vert
avocet11412683avoce_t
bewept13410323bewept
bicep115413543bicep_
biceps12447713biceps
cachepot1744993cachepot
cachet134526413cachet
cadent94120363cadent
cadet85339343cade_t
cajeput1845053cajeput
caret75360563care_t
carpet104530093carpet
caveat11417723caveat
celt65646713__celt
cent67451013__cent
cep75736333__cep_
cepe84926653__cepe
ceps86125953__ceps
chapt125827643_chapt
cheat105732453_cheat
chert105232103_chert
chest104926143_chest
clapt98027173_clapt
cleat76335063_cleat
cleft106222853_cleft
clepe94617383_clepe
clipt96324273_clipt
coapt96131533_coapt
coempt12311033_coempt
compt116328223_compt
concept133314443concept
coopt95929853_coopt
crepe95520723_crepe
crepy124812703_crepy
crest74632693_crest
crypt123715233_crypt
deceit93018213deceit
decent94023703decent
discept12310623discept
docent92918683docent
excepts1885203excepts
excerpt1845943excerpt
facet106038523face_t
faucet115816553fauce_t
iciest82914743iciest
incent83320723incent
incepts11238293incepts
incest82918743incest
inept73622153_inept
jacket194720673jacke_t
kept106232953__kept
laciest93819043laciest
lancet84223573lance_t
lept66440883__lept
lucent8313823lucent
nascent9610523nascent
nicest82315663nicest
nocent83217413nocent
occiput1344763occiput
occult1038433occult
occupy1543153occupy
octet7324063octe_t
oncet74626543once_t
paciest112917813paciest
packet144726503packe_t
percept133112523percept
precept133112513precept
rachet115028973rache_t
raciest92820013raciest
racket125229423racke_t
reaccent1278573reaccent
reaccepts1583213reaccepts
receipt1159253receipt
recent83630853recent
recepts113010273recepts
sachet114725773sache_t
saucepot1243943saucepot
scent75831623_scent
script105717903script
sculpt104412693sculpt
sept65844363__sept
slept75728103_slept
swept105720603_swept
tacet75840023tace_t
tacket124627493tacke_t
unkept123710873unkept
unwept11389813unwept
wackest164710863wackest
wept95635053__wept

Search took 9 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.376475242.0
2DLD Change Limit1127161977.75014544.0
3Display Results1971970.0633127.0
 (SQL Overall)1786911978.18921820.9
 
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.