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

349 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
assents7451222(None) 
absents93510721absents
ascents93812551ascents
assent65119951assent_
asserts74311791asserts
assets65617661asse_ts
absent84016992absent_
accents113511232accents
advents11309472advents
agents74816292a_gents
aments85219802a_ments
argents84014852argents
arpents93613082arpents
ascends10388202ascends
ascent84519652ascent_
aspects1146742aspects
aspens85013352aspen_s
assented957512assented
assenter867702assenter
assenters966992assenters
assentor865292assentor
assentors955652assentors
assert64922582assert_
asses55629282asse__s
assess65710462asse_ss
asset55932262asse_t_
assists738472assists
assorts73310152assorts
bassets96414822basse_ts
bassetts10407372bassetts
cassenas10317482cassenas
cassenes103611292cassenes
dissents93411862dissents
resents74221222resents
scents85317022_scents
stents65019452_stents
tassets75012772tasse_ts
wisents10249062wisents
abets75621673a_be_ts
abluents1045463abluents
abseils935973abseils
absence1137703absence
absences1247673absences
absented1156613absented
absentee1067663absentee
absentees1164533absentees
absenter1086773absenter
absenters1156173absenters
absently1345813absently
absinth1244973absinth
absinths1342953absinths
accent105116263accent_
accepts13356353accepts
acescents1345233acescents
achenes12313493achenes
addends10356053addends
adepts9117103a_depts
advects13276013advects
advent102613753advent_
adverts11308513adverts
affects1535393affects
afreets1037013afreets
agenes74720253a_genes
agent65829643a_gent_
aglets73915683agle_ts
ailments1039433ailments
akenes104817343a_kenes
alants67722023a_lants
alerts64418223a_lerts
aliens65619213alien_s
aliments10311093aliments
alkenes114212753alkenes
amassments1444493amassments
ambients1246053ambients
amends94713283a_mends
amens75624843a_men_s
ament76036543a_ment_
amounts937043amounts
ancients1098973ancients
anenst63514983a_nenst
anent54931843a_nent_
anoints7311063anoints
ants47243473a___nts
aplenty1237173aplenty
appends1236393appends
apses76823913apse__s
ardent73022613ardent_
arenas65021993a_renas
arenes64928393a_renes
argent74023663argent_
armets84918353arme_ts
aroints7313133aroints
aroynts1036633aroynts
arpens84814823arpen_s
arpent84822093arpent_
arrests73312683arrests
arsenal739383arsenal
arsenals847733arsenals
arsenate81010483arsenate
arsenates979373arsenates
arsenic939323arsenic
arsenics1056763arsenics
arsenite8119663arsenite
arsenites9149163arsenites
arseno6318913arsen_o
arsenous847533arsenous
arses55733873arse__s
arsines73518813arsines
arsons63917213arson_s
asanas6514113a_sanas
asbestos1044353asbestos
asbestus1042953asbestus
ascend9429733ascen_d
asceses938623asceses
ascesis938373ascesis
ascots85312513a_scots
ashen87818673ashen__
ashes86230613ashe__s
askant10412713askant_
askers105915403aske_rs
askeses1136463askeses
askesis1136123askesis
askings12519173askings
aslant6317753aslant_
aspect10612823aspect_
aspen75216093aspen__
aspers86220313aspe_rs
assails769093assails
assais6711963ass_ais
assaults843863assaults
assays977903ass_ays
assegai843353assegai
assegais943953assegais
assenting1038163assenting
assentive1245743assentive
asserted957903asserted
asserter877573asserter
asserters956393asserters
assertor865723assertor
assertors965973assertors
assesses737383assesses
assignats1044003assignats
assigns836193assigns
assist6314603assist_
assizes1638453assizes
assoils776663assoils
assonants944243assonants
assort64916383assort_
assumes967163assumes
assures7611403assures
asters65631603aste_rs
attends8257593attends
attent62818323attent_
attests7278813attests
audients946353audients
augends935883augends
augments1137833augments
aunts55227633a__unts
avens86419333a_ven_s
averts95715243a_verts
avosets1036663avose_ts
axseeds1533393axseeds
basements1348263basements
basinets1039063basinets
baskets135111833baske_ts
basses85428303basse__s
basset85225383basse_t_
bassett94213863basse_tt
bassinets1146323bassinets
bassists1037183bassists
bassness1096743bassness
bents76033693__bents
besets85718803bese_ts
bisects1137133bisects
brents84717273_brents
casements1348583casements
caskets133910173caske_ts
cassena9287843cassen_a
cassene93111543cassen_e
cassette1047813cassette
cassettes1146703cassettes
cassinas103610633cassinas
cassines103116613cassines
cassinos10309353cassinos
cements112714223cements
cents74730333__cents
clients938093clients
consents102715893consents
cosets85824403cose_ts
cossets95014283cosse_ts
dements103016623dements
dents65031803__dents
descents112511203descents
deserts82513053deserts
desserts9247923desserts
detents83615153detents
disseats93211503disseats
dissects11279243dissects
dissent84018683dissent_
disserts92411813disserts
docents102810803docents
easements11410333easements
eluents738703eluents
essence947673essence
essences1047563essences
esses56422973esse__s
events94814073_events
exsects1655573exsects
exserts1467013exserts
extents142610173extents
fastens105511753fasten_s
foments122912053foments
garments1139963garments
gaskets12348153gaske_ts
gassers84714633gasse_rs
gasses75724783gasse__s
gassings10438403gassings
gents65729613__gents
gerents82612923gerents
gussets837443gusse_ts
haslets102510863hasle_ts
hassels104311013hasse_ls
hastens106214813hasten_s
hausens1077633hausen_s
hents87330743__hents
incents92414533incents
indents83114663indents
insects93710843insects
inserts74013993inserts
insets64016133inse_ts
intents72115703intents
invents102812053invents
islets64513083isle_ts
isseis638563isse_is
laments94314853laments
lasses64827593lasse__s
latents75214313latents
lessens7409383lessen_s
lisente71210703lisente
loments93413473loments
margents11410133margents
masses85028713masse__s
masseurs1034923masseurs
miseats92815783miseats
misseats104011683misseats
missends11368233missends
missent94318713missent_
missets94516573misse_ts
moments113113123moments
nascent9610523nascent_
nauseants943053nauseants
onsets64013543onse_ts
orients7311583orients
osseins736133osseins
osseous736053osseous
parents93418123parents
passant9813943passant_
passels93913023passe_ls
passers94717753passe_rs
passes86030473passe__s
passings11409873passings
patents94815203patents
patients1088763patients
payments1536943payments
pissants1097363pissants
possets94212773posse_ts
presents103315643presents
pschents1544113pschents
raiments1039903raiments
reascents1177403reascents
reasserts945983reasserts
regents83416543regents
relents74018503relents
rents55935183__rents
repents93717623repents
rerents73319423rerents
reseats74319583reseats
resects94115593resects
resends83513713resends
resent63833623resent_
resets65427613rese_ts
rodents8611543rodents
rosets65819953rose_ts
russets738163russe_ts
saints65122423_saints
salients839563salients
sapients1037423sapients
sarments10311963sarments
sarsenets946513sarsenets
sarsens7311393sarsen_s
sarsnets836783sarsnets
sasins64923103sasin_s
sasses64124393sasse__s
savants1038653savants
scants85219723_scants
scenas84114703_scenas
scends95213003_scends
scenes84520353_scenes
scent75831623_scent_
seats54844343__seats
sects75622893__sects
sends65528243__sends
sent46963013__sent_
sente56432873__sente
senti56226703__senti
septs75420603__septs
sets45549503__se_ts
setts55124323__setts
sexts125118383__sexts
sheets93918503_sheets
shends105313773_shends
shent85933503_shent_
shunts95712023_shunts
silents73514493silents
skeets104513253_skeets
skenes104616633_skenes
sklents11348163sklents
slants64819083_slants
sleets64318873_sleets
smelts85412773_smelts
spelts84614643_spelts
spends94714473_spends
spent75532833_spent_
splents93912133splents
stenos63915773_stenos
stent55634513_stent_
stets55423913_ste_ts
stints65119763_stints
stunts65615253_stunts
suets55126103_sue_ts
suints64617783_suints
sweats94814613_sweats
sweets94214433_sweets
talents7312013talents
tangents938713tangents
tassels74510853tasse_ls
tasses64826763tasse__s
tasset65925313tasse_t_
tents56434213__tents
unseats73012853unseats
unsent63820963unsent_
unsets64116163unse_ts
upsends10265293upsends
upsent83314063upsent_
upsets8409683upse_ts
varments1339063varments
vents86125933__vents
wadsets1136443wadse_ts
wisent93516343wisent_

Search took 10 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.1531167915.0
2DLD Change Limit1340273499.25314484.7
3Display Results3493490.1262769.8
 (SQL Overall)1786913499.53218746.4
 
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.