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

377 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
sextets149714(None) 
septets998951septets
sestets7911471sestets
sextet13916871sextet_
extents142610172_extents
seaters74028932seaters
secrets9311772secrets
sennets73712582sennets
septet8921132septet_
sestet6826202sestet_
settees73513632settees
setters73822062setters
setts55124322se_t_ts
sexes126126222sex_e_s
sexiest142112222sexiest
sexists14267672sexists
sexless1467242sexless
sexpots1636292sexpots
sextans14349262sextans
sextants15287382sextants
sextette1544072sextette
sextettes1643912sextettes
sextons143710412sextons
sextos134012162sext_os
sexts125118382sex__ts
sixtes133612402sixte_s
stets55423912s__tets
beaters94925033beaters
beckets15399823beckets
beets76131443be__ets
befrets1237613befrets
begets96215523be_gets
belters93819413belters
bennets94712163bennets
berets85822523be_rets
besets85718803be_sets
betels84515063be_tels
betters94422093betters
centers94420593centers
cermets1139713cermets
certes84623083certe_s
cetes75731103ce_te_s
deets65330243de__ets
deftest112611713deftest
detects104011093de_tects
detents83615153de_tents
deters74724683de_ters
detest74122843de_test
detests83711743de_tests
dexes135224513dex_e_s
dexies145018343dexie_s
dexter143810893dexte_r
eaters65535943_eaters
ebbets10376833_ebbets
egrets72712243_egrets
emmets10349153_emmets
enters64425643_enters
esters64627733_esters
exacts15359613_exacts
exalts13328313_exalts
excels1536663_excels
excepts1885203_excepts
excess1546053_excess
execs14539723_ex_ecs
exerts133712293_exerts
exes116530813_ex_e_s
exists134710913_exists
exits125515913_ex_its
expats1537683_expats
expects1866883_expects
expels1547173_expels
experts1659063_experts
exsects1655573_exsects
exserts1467013_exserts
extend14267523_extend
extends15227113_extends
extent132714913_extent
extern1348473_extern
externs1438233_externs
extols1337683_extols
extorts1447753_extorts
extras13310223_extras
exults13257633_exults
featest102715113featest
ferrets103111393ferrets
festers104121393festers
fetes85630143fe_te_s
fetters103517903fetters
genets75716663ge_nets
gentes75324163gente_s
gestes75721393geste_s
getters84216093getters
heaters104225213heaters
hefters134312003hefters
helmets12309073helmets
hexers165612753hex_ers
hexes155123043hex_e_s
jennets14517633jennets
jesters144118193jesters
jetes124922843je_te_s
keets95123483ke__ets
kelters113813753kelters
kentes105118643kente_s
kexes166216813kex_e_s
keysets1434343keysets
leets54927123le__ets
leftest10269463leftest
letters73819853letters
lexes127225263lex_e_s
meeters94714543meeters
meets74224613me__ets
melters93918313melters
mentees93214503mentees
mestees94617753mestees
meters85625833me_ters
metes74736213me_te_s
motets84216193_motets
neatens73310403neatens
neatest72516003neatest
nesters74422783nesters
netters73618583netters
netts55320723ne_t_ts
neuters74212263neuters
octets839403_octets
oxters134813273_oxters
pectens11189203pectens
pellets94014783pellets
pelmets11309693pelmets
pelters93720313pelters
pertest9317043pertest
pesters93827093pesters
peters86624593pe_ters
petters93722363petters
pewters124113353pewters
reflets103513153reflets
reglets83512983reglets
regrets83212923regrets
relets64025673re_lets
remeets93712413remeets
rennets75212633rennets
renters74224813renters
rentes65431193rente_s
resets65427613re_sets
resters74130403resters
retems83914573re_tems
retest64028453re_test
retests73813853re_tests
revets94022173re_vets
rewets94617213re_wets
rexes124526953rex_e_s
sachets123914103sachets
sallets73719653sallets
salters73622253salters
saltest71916513saltest
samlets93813553samlets
sates54949323s_ate_s
sautes63924913saute_s
saxes125229343sax_e_s
scatts85914663scat_ts
scepters1237783scepters
scoters93313793scoters
scutes85219193scute_s
seabeds10417223seabeds
sealers74323553sealers
seamers94719433seamers
searest73322023searest
seatbelts1142983seatbelts
seated75131053seate_d
seater64534153seate_r
seatless83213003seatless
seats54844343se__ats
secants93413893secants
secret8325063secret_
secrete9311073secrete
secretes10410473secretes
sectors93116433sectors
sects75622893se__cts
sedates83418033sedate_s
sedatest9249393sedatest
seders74420283se_ders
sedges83817793sedge_s
seeders83017113seeders
seeds64330063se__eds
seekers113712333seekers
seeks94724643se__eks
seels55632823se__els
seemers93814333seemers
seems75525023se__ems
seeps74828753se__eps
seeress7311573seeress
seers55136383se__ers
sees45361053se__e_s
seethes103613743seethes
segments1138903segments
segues7412073segue_s
seidels838393seidels
seiners74219273seiners
seines65029903seine_s
seisers73816393seisers
seises64026713seise_s
seitans73312303seitans
seizers164112503seizers
seizes154317533seize_s
selects91912143selects
sellers73721303sellers
selles64426983selle_s
seltzers1735063seltzers
selves94119613selve_s
semens84616963se_mens
semes75731583se_me_s
senates73322583senate_s
senders83022353senders
sennet64224143sennet_
sennits73811283sennits
senseis73310643senseis
senses63923943sense_s
sente56432873sente__
sentients948463sentients
sepses84515883sepse_s
septate9511873septate
septette1044763septette
septettes1144913septettes
septics112810433septics
septs75420603se__pts
septums1135743septums
sequels1665703sequels
sequents1756993sequents
seres55448893se_re_s
serest64831613se_rest
sergers83815633sergers
serges74225963serge_s
series64540973serie_s
serpents102410373serpents
servers103214833servers
serves94423653serve_s
setons64620173se_tons
setous64917373se_tous
setouts74110333setouts
sets45549503s___ets
sett45949053se_t_t_
settee63721023sette_e
setter64023723sette_r
settlers8289023settlers
settles73916003settles
setups83910463se_tups
sevens93813663se_vens
severs94121123se_vers
sewers94719713se_wers
sexed136618543sex_e_d
sexier13310683sexie_r
sexiness1537943sexiness
sexisms16226223sexisms
sexist133013483sexist_
sexpot1539543sexpot_
sext117338093sex__t_
sextain14257093sextain
sextains15246813sextains
sextan13389643sext_an
sextant142911963sextant
sextile1438573sextile
sextiles1537643sextiles
sexto124415453sex__to
sexton133610793sext_on
sextuplets1951553sextuplets
sheeters113111853sheeters
sheets93918493s_heets
shelters113412803shelters
sherbets1335213sherbets
shotes95321893shote_s
shotts93614683shot_ts
shtetl936433s_htetl
shtetls1034573s_htetls
shutes93518213shute_s
sifters103714783sifters
signets83311503signets
sinters74024073sinters
sippets113310173sippets
sisters73721573sisters
sites56045433s_ite_s
sitters74221543sitters
sixes124526363six_e_s
sixte126216583sixte__
sixteen1434113sixteen
sixteens1542943sixteens
sixths16416373sixt_hs
sixties14310973sixties
sixtieth1842333sixtieth
sixtieths1941373sixtieths
skaters113512943skaters
skates104219393skate_s
skeeters12298963skeeters
skeets104513253s_keets
skelters12349373skelters
skites104418033skite_s
slaters73123723slaters
slates64934063slate_s
sleets64318873s_leets
smelters103310513smelters
smiters93414363smiters
smites83921923smite_s
sockets134012983sockets
softens10347623softens
softest10310603softest
sonnets74211993sonnets
sorbets93012503sorbets
sorters74221113sorters
souters74422583souters
soviets1087293soviets
spates85028173spate_s
specters122811063specters
spelters103912243spelters
spinets94714813spinets
spites84127333spite_s
starets73515923starets
staters73922323staters
states64337083state_s
stats55933363s__tats
stems75219953s__tems
stents65019453s__tents
steps76619883s__teps
sterlets8169273sterlets
stet45947323s__tet_
stews85519143s__tews
stots54828543s__tots
stotts64612853stot_ts
streets73312613streets
stylets10369213stylets
sublets92616703sublets
subnets92512083subnets
subsets92813103subsets
subtest9513963subtest
subtests1037533subtests
subtexts1744903subtexts
suets55126103s__uets
suiters73618873suiters
suites63727403suite_s
sunkets113511283sunkets
sunsets72911573sunsets
suttees74114063suttees
sveltest1135873sveltest
sweaters113811053sweaters
sweetens11255433sweetens
sweetest1137173sweetest
sweets94214433s_weets
swelters113110193swelters
swivets13436963swivets
syndets1136113syndets
systems1234673systems
teeters74018303teeters
telnets738373telnets
tenets65518953te_nets
tenters73921103tenters
tercets93512443tercets
terrets72913573terrets
testees74215913testees
testers74124543testers
testes65125823teste_s
tets45847453___tets
tetters74320473tetters
textless15245793textless
texts125515043tex__ts
velvets13326693velvets
venters103717723venters
versets103913093versets
vervets13419743vervets
vestees103513163vestees
vetters104016313vetters
vexers165210403vex_ers
vexes155719123vex_e_s
weets85427723we__ets
welters103516063welters
westers105221963westers
wetters103817753wetters
wettest10239363wettest
yentes95517603yente_s
yetts86715133ye_t_ts
zesters163517293zesters

Search took 8 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 Limit1340273777.01619103.1
3Display Results3773770.1402692.9
 (SQL Overall)1786913777.29624491.6
 
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.