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

402 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
absent8401699(None) 
absents93510721absents
assent65119951assent
abet610547942ab_e_t
abject17137702abject
ablest84721832ablest
abluent939622abluent
abseil837182abseil
absence1137692absence
absented1156612absented
absentee1067662absentee
absenter1086772absenter
absently1345812absently
absinth1244972absinth
accent105116262accent
advent102613752advent
agent65829642a_gent
ambient11310082ambient
ament76036542a_ment
anent54931842a_nent
ardent73022612ardent
argent74023662argent
arpent84822092arpent
arseno6318912arseno
ascent84519652ascent
assents74512222assents
assert64922572assert
asset55932262asse_t
attent62818322attent
basest84720492basest
bent67759912_b_ent
blent76230952_blent
brent75734132_brent
resent63833622resent
sent46963012__sent
unsent63820962unsent
upsent83314062upsent
wisent93516342wisent
abaft10318063ab_aft
abase76023483abase__
abased96514993abase_d
abasement1348333abasement
abaser86414343abase_r
abasers95311973abasers
abases85720773abase_s
abashment1646023abashment
abasing10610673abasing
abbe87627183abbe__
abbes96723523abbe_s
abbess10509773abbess
abbey125714933abbe_y
abbeys13538423abbeys
abbot9318453ab_bot
abducent13105703abducent
abduct11108543abduct
abeam9316533ab_eam
abed79734133ab_e_d
abele76323253ab_ele
abetment1248233abetment
abets75621673ab_ets
abeyant1248083abeyant
abhenry1543333abhenry
ablaut8313263ablaut
able66340533able__
abled86926833able_d
ableist9311773ableist
abler75624313able_r
ables75935543able_s
ablins8316193ablins
abluents1045463abluents
aboon74918703aboon_
abort76133583ab_ort
abound9239863abound
about75229083ab_out
abreact11310823abreact
abreast9311273abreast
abrupt1039943abrupt
abs59356073abs___
abscess1133903abscess
abscond1244503abscond
abseils935973abseils
absences1247673absences
absentees1164533absentees
absenters1156173absenters
absenting1236993absenting
absinthe1342643absinthe
absinths1342953absinths
absolvent1454093absolvent
absonant1047043absonant
absorb1038003absorb
absorbent1345023absorbent
abstinent1145923abstinent
absurd935903absurd
abuse77119563abuse__
abused95614273abuse_d
abuser85413683abuse_r
abusers94710553abusers
abuses85119103abuse_s
abusing1049113abusing
abut66834953ab__ut
abutment1247223abutment
abvolt11169833abvolt
abwatt11410673abwatt
abye97921003abye__
abyes105518533abye_s
abying124410413abying
accents113511233accents
accept123210623accept
acescent1248003acescent
achene11313813achene
addend9458453addend
adept81219643a_dept
admen84516183admen_
advect12309123advect
advents11309473advents
advert103215773advert
affect1448903affect
afreet9315153afreet
agene65621583a_gene
agents74816293a_gents
aglet65534143agle_t
ailment9314233ailment
airest63825263airest
akene95818663a_kene
alant55742293a_lant
albeit8314343albeit
albescent1345453albescent
alert54740653a_lert
alien56425583alien_
aliens65619213aliens
aliment9316703aliment
alkene104114003alkene
ambients1246053ambients
amen66733153a_men_
amend85717753a_mend
amens75624843a_mens
aments85219803a_ments
amount8414483amount
ancient9514733ancient
anenst63514983a_nenst
anoint6423633anoint
ant37270783a___nt
aplenty1237173aplenty
append1138273append
apse67725383apse__
apses76823913apse_s
aptest82917513aptest
arena55323813a_rena
arene55329413a_rene
argents84014853argents
arisen65316793arisen_
armet76739453arme_t
aroint6328153aroint
aroynt9312893aroynt
arpen74418043arpen_
arpens84814823arpens
arpents93613083arpents
arrant6623253arrant
arrest63722633arrest
arse46539273arse__
arsenal739383arsenal
arsenate81010483arsenate
arsenic939323arsenic
arsenite8119663arsenite
arses55733873arse_s
arsine64021043arsine
arsino64113513arsino
arson55118833arson_
arsons63917213arsons
asana5315483a_sana
ascend9429733ascend
ascents93812553ascents
ascot76522513a_scot
asea46327183a_se_a
ashen87818673ashen_
askant10412713askant
aslant6317753aslant
aspect10612823aspect
aspen75216093aspen_
aspens85013353aspens
assented957513assented
assenter867703assenter
assentor865293assentor
asserts74311793asserts
asses55629283asse_s
assess65710463assess
assets65617663assets
assist6314593assist
assort64916373assort
attend7258973attend
attest62618613attest
audient8312303audient
augend837633augend
augment10910203augment
aunt46553653a__unt
avant86224663a_vant
avaunt959603avaunt
avens86419333a_vens
avert86029493a_vert
avoset9315673avose_t
axmen145112273axmen_
axseed1456993axseed
babiest114414753babiest
bannet84925333bannet
barest85327693barest
basalt83519583basalt
base64847023base__
based85331583base_d
basely114412313basely
basement12311493basement
basenji1641943basenji
baser74828923base_r
bases75644353base_s
basin75026923basin_
basinet9318933basinet
basing95427663basing
basins85722763basins
basket125722913basket
basset85225383basset
bassett94213863bassett
bast66362413bas__t
bawsunt1244723bawsunt
beat66168303_b_eat
been65335783_been_
beet66457543_b_eet
belt65754033_b_elt
ben56554923_b_en_
bend76435263_b_end
bene66439493_b_ene
bens65945703_b_ens
bento75922953_b_ento
bents76033693_b_ents
beset76739133_beset
besot76429713_besot
best66355323_b_est
bet58376673_b_e_t
bint67355033_b_int
biont7727163_biont
bisect10312873bisect
bleat75737003_bleat
blend85317453_blend
blest76431723_blest
blet66247673_ble_t
blunt75525023_blunt
brant74742173_brant
bren65629563_bren_
brens75823363_brens
brents84717273_brents
brunt75728753_brunt
bunt65850853_b_unt
burnt75230323_burnt
cabinet11318903cabinet
cablet104429463cable_t
cabmen123610653cabmen_
cadent94120353cadent
candent10417363candent
cassena9287843cassena
cassene93111543cassene
cement103321663cement
cent67451013__cent
client8316343client
cogent9321003cogent
consent93723113consent
coset75748843cose_t
decent94023703decent
dement93825143dement
dent57158413__dent
descent102616293descent
desert72725493desert
detent73624483detent
dissent84018683dissent
distent84120853distent
docent92918683docent
ebbet93517293ebbe_t
eluent6315483eluent
event85924443_event
exsect1558503exsect
exsert13414363exsert
extent132714913extent
fabbest1438033fabbest
falsest10310013falsest
fluent9313933fluent
foment113718303foment
gabfest1336453gabfest
garment10315233garment
gent56954393__gent
gerent73223093gerent
hausen9610383hausen_
hausens1077633hausens
hent76656383__hent
hosen85623883hosen_
incent83320723incent
indent73021243indent
insect83916583insect
insert64325253insert
inset54430863inse_t
intent63122773intent
invent93316363invent
kent86846963__kent
labret8320223labre_t
lambent113711303lambent
lament85024943lament
latent64124303latent
lent46360533__lent
lisente71210703lisente
loment84021473loment
lucent8313823lucent
margent10316693margent
miseat82925703miseat
missent94318713missent
moment103319683moment
nascent9610523nascent
nauseant845743nauseant
nocent83217413nocent
obento837893ob_ento
object17135803object
objet141213143obje_t
obscene1145243obscene
obsess845943obsess
obtect10129633obtect
obtest81213013obtest
obvert11412993obvert
onset54730173onse_t
orient6322533orient
owsen84210193owsen_
parent83230423parent
passant9813943passant
patent84524923patent
patient9617073patient
payment14310703payment
pent66559073__pent
ponent82821593ponent
potent84223353potent
present94022723present
rabbet103818653rabbe_t
raiment9315413raiment
reblent9614253reblent
recent83630853recent
regent74127673regent
relent64431853relent
rent46661243__rent
repent84728873repent
rerent63832453rerent
reseat64131493reseat
resect84424703resect
resend75016773resend
resents74221223resents
reset55051863rese_t
rident7520193rident
risen54621883risen_
rodent7519243rodent
roset55945243rose_t
salient7419763salient
sapient9415333sapient
sarment9318763sarment
sarsen6314233sarsen_
sarsenet8412943sarsenet
sarsens7311393sarsens
sarsnet7314813sarsnet
scent75831623_scent
seat47575563__seat
sect67443623__sect
sen36058523__sen_
send55237293__send
sene46848053__sene
sente56432873__sente
senti56226693__senti
sept65844363__sept
set36681253__se_t
sett45949053__sett
sext117338093__sext
shent85933493_shent
silent64125843silent
sklent103614353sklent
spent75532833_spent
splent84720193splent
sprent84522383sprent
stent55634513_stent
subrent9315083subrent
subsect112611843subsect
subset83122583subse_t
tablet84227643table_t
talent6323323talent
tangent8314993tangent
tasset65925313tasse_t
tent46159863__tent
unbent83216593unbent
unkent103116053unkent
unpent83117373unpent
unrent63219783unrent
unseat64221023unseat
unset54532433unse_t
unspent92610893unspent
upsend9356883upsend
upset73222593upse_t
urgent73816043urgent
varment12313243varment
vent76049053__vent
wadset10314303wadse_t
went76051873__went
wisents10249063wisents
wisest95016443wisest

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.1561145455.1
2DLD Change Limit1127164025.86019234.8
3Display Results4024020.1233268.3
 (SQL Overall)1786914026.13929107.5
 
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.