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

367 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
sennits7381128(None) 
sennets73712581sennets
sennit63117921sennit_
bennets94712162bennets
bennies93917312bennies
bennis84314802benni_s
henbits12177002henbits
jennets14517632jennets
jennies143511622jennies
pennies94218812pennies
pennis84315742penni_s
reknits1137072reknits
rennets75212632rennets
rennins74013412rennins
seniti64317212se_niti
sennas64214232senn_as
sennet64224142sennet_
sennights1343432sennights
snits54124832s__nits
sonnets74211992sonnets
sonnies7315222sonnies
tennies73017972tennies
tennis64015302tenni_s
tennist72813112tennist
tennists8297792tennists
bandits103814793bandits
bankits133410153bankits
bannets94013843bannets
beanies93821093beanies
bedsits1037563bedsits
befits114711503be_fits
beknots1335083beknots
benefits1345713benefits
bennes86019013benn_es
bennet84823363bennet_
benni74715363benni__
bents76033693be_n_ts
benzins1838693benzins
binits85716673_binits
blennies1056933blennies
bonnets94812803bonnets
bunnies94415003bunnies
cents74730333ce_n_ts
confits122811423confits
debits94214493de_bits
deceits102810883deceits
demits94918073de_mits
denies74729643de_nies
denims95214323de_nims
denning93515173denning
density1137583density
dentils84115583dentils
dentins83419223dentins
dentist8316743dentist
dentists939263dentists
dents65031803de_n_ts
dunnite857333dunnite
dunnites947173dunnites
edits65819033_e_dits
elints65816423_elints
emits75421463_e_mits
enacts84012973_enacts
endite73817593_endite
endites83717063_endites
enlist6417043_enlist
enlists749393_enlists
enmity1137483_enmity
ennuis636473_ennuis
entity9312053_entity
envies9314053_envies
esprits938393esprits
exits125515913_e_xits
fannies103415643fannies
feints94813873fein_ts
fennecs12305693fennecs
fennels10387903fennels
fennier10339253fennier
fenniest113113203fenniest
funnies104113603funnies
gannets83811443gannets
genets75716663ge_nets
genies75324943ge_nies
genips9469943ge_nips
genius74512923ge_nius
gents65729613ge_n_ts
gunnies83413123gunnies
heinies102514543heinies
henbit111412003henbit_
hennas94211803henn_as
hennish1336863hennish
henries102718283henries
hents87330743he_n_ts
hermits12312133hermits
hernias10310773hernias
hinnies103615103hinnies
jennet134714953jennet_
jesuits1436323jesuits
jinnis13489053jinni_s
kainits1137763kainits
kennels11387193kennels
kenning124010543kenning
kennings13315273kennings
kernite1159473kernite
kernites1269113kernites
knits93914743__knits
legits71313003le_gits
lenis56326863le_ni_s
lenite6719983le_nite
lenites7818443le_nites
lenity9612713le_nity
lentils73912973lentils
linnets739823linnets
mannite9312903mannite
mannites10312613mannites
meanies93620743meanies
meinies92516073meinies
menhirs1235913menhirs
merits8320873me_rits
minnies93617363minnies
nannies73015203nannies
ninnies73713613ninnies
nits45741643___nits
pandits103914213pandits
peanuts936993peanuts
peewits12105873peewits
pencils113011763pencils
penis75129323pe_ni_s
penlite9313243penlite
penlites10312263penlites
pennants1037063pennants
pennate93314033pennate
penners93414183penners
penni74617903penni__
pennia84412973penni_a
pennine93712953pennine
pennines103112033pennines
penning103616493penning
pennons939713pennons
pensils92811593pensils
penults937123penults
peonies93620153peonies
permits11314003permits
pewits112810683pe_wits
pfennigs1461983pfennigs
pinnies93318443pinnies
pundits10379293pundits
punnets9409263punnets
rebaits9312573rebaits
recits83621353re_cits
reedits8511743reedits
reemits9611303reemits
refits94017653re_fits
reknit10312533reknit_
reknots1136783reknots
remints95117293remints
remits85622943re_mits
renails74917263renails
renests74014213renests
renigs74314593re_nigs
renins64526453re_nins
rennet64624853rennet_
rennin63914033renni_n
rents55935183re_n_ts
resits64725563re_sits
retints74717013retints
reunite7312713reunite
reunites8312473reunites
saints65122423sain_ts
sandpits1146843sandpits
sanies63031953s_anies
sanity9316203s_anity
sannops936693sannops
sannups934463sannups
santims9312593santims
santirs7312963santirs
scants85219723scan_ts
scenics1137773scenics
scents85317023scen_ts
schuits1235823schuits
sealifts1135473sealifts
seances93015343seances
seats54844343se__ats
secants93413893secants
secrets9311773secrets
sects75622893se__cts
seeings84411293seeings
segni63712483segni__
segnos73610443segn_os
seifs85019333se__ifs
seiners74219273seiners
seines65029903sein_es
seining84020773seining
seis45542393se__i_s
seisins73614393seisins
seizins164010133seizins
selects91912143selects
selenite81713103selenite
selenites91312083selenites
selkies113513353selkies
semis74623533se_mi_s
senarius8310103senarius
senate63725143se_nate
senates73322583senates
sendals81912263sendals
senders83022353senders
sending94221373sending
sends65528243se_n_ds
sendups10115193sendups
senecas939013senecas
senecios1046303senecios
senegas837253senegas
sengi64016513sengi__
senhors103512123senhors
senile63420213se_nile
seniles72618023seniles
senility1139683senility
senior63214043se_nior
seniors73413613seniors
senna54617983senn__a
sennight1245143sennight
senopias1048823senopias
senoras72714953senoras
senores73218113senores
senorita848283senorita
senoritas946503senoritas
senors63620783se_nors
sensate7311883sensate
sensates8511133sensates
senseis73310643senseis
senses63923943se_nses
sensing84116953sensing
sensitise947293sensitise
sensors73514623sensors
sent46963013se_n_t_
sente56432873se_n_te
senti56226693se_n_ti
sentients948463sentients
sentimo9449613sentimo
sentimos10407423sentimos
sentries81318053sentries
sepias83616103se_pias
sepsis83011293sepsi_s
septets998953septets
septics112810433septics
septs75420603se__pts
sequins1637863sequins
serails73318363serails
serais64326133serai_s
sereins73716113sereins
serenity1168963serenity
series64540973se_ries
serifs94017053se_rifs
serines74229543serines
serins64029673se_rins
serries73925353serries
sestets7911473sestets
setouts74110333setouts
sets45549503se___ts
setts55124323se__tts
sewings11369173sewings
sexist133013483se_xist
sexists14267673sexists
sexpots1636293sexpots
sextets1497143sextets
sexts125118383se__xts
shannies113411253shannies
shantis103313083shantis
sheenies111411543sheenies
shinnies113010913shinnies
shits84731163s__hits
shunts95712013shun_ts
sienite7312713sienite
sienites8311913sienites
siennas736123sienn_as
signets83311503signets
sinners74019013sinners
sinning83918443sinning
sits45050203s___its
skits94721853s__kits
slants64819083slan_ts
slits56128853s__lits
snails64816653s_nails
snibs75613753s__nibs
snips75818013s__nips
snit46342473s__nit_
snoots64216663s_noots
snorts64116493s_norts
snots55225103s__nots
snouts64915863s_nouts
soffits1335093soffits
sonants7511233sonants
sonics84315633s_onics
sonnet65923503sonnet_
spaits85017473s_paits
spinets94714813spinets
spinnies103210543spinnies
spirits94112623spirits
spits74429553s__pits
splints94511743splints
splits85416413s_plits
sprints94113773sprints
sprits85122533s_prits
squints16339033squints
stannite847583stannite
stannites947013stannites
stencils1046403stencils
stents65019453sten_ts
sternite8310543sternite
sternites9310073sternites
stints65119763stin_ts
straits74916323straits
stunts65615253stun_ts
submits1139743submits
subnets92512083subnets
subunits1046613subunits
suints64617783suin_ts
suits55028053s__uits
summits1137973summits
sunkets113511283sunkets
sunlit61516103sunlit_
sunnahs10326593sunnahs
sunnas63914563sunn_as
sunnier73412153sunnier
sunniest82712903sunniest
sunnily1037833sunnily
sunning83715673sunning
sunns55017353sunn__s
sunsets72911573sunsets
sunsuits845963sunsuits
sweenies11148763sweenies
syenite1039773syenite
syenites1138943syenites
syndets1136113syndets
syndics1335703syndics
tannins72813223tannins
telnets738373telnets
tenails73713923tenails
tenants7311013tenants
tenets65518953te_nets
tenias64720073te_nias
tenners74014923tenners
tennises82810133tennises
tenpins9410073tenpins
tensity1039103tensity
tents56434213te_n_ts
tenuis64213083tenui_s
tenuity1037453tenuity
territs72714493territs
tinnitus843783tinnitus
tunnies73614263tunnies
unfits93910293_unfits
units54923433__units
unknits1135553unknits
unwits9389893_unwits
venines103516613venines
venins93816703ve_nins
vents86125933ve_n_ts
weenies102915093weenies
wennier10318603wennier
wenniest11259593wenniest
wennish1336243wennish
weskits1434743weskits
xenias133712973xe_nias
yenning11369493yenning
zenith1839073ze_nith
zeniths1935153ze_niths
zinnias1635863zinnias

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273678.22016305.0
3Display Results3673670.1861973.1
 (SQL Overall)1786913678.56220870.2
 
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.