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

423 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
pterins981299(None) 
pterin81014151pterin_
peeries93623022peeries
peering103520352peering
peins76128062p_e_ins
pekins121812232p_ekins
perils84121852p_erils
peris75537072p_eri_s
petering112516812petering
prerinse1038632prerinse
purins83722652p_urins
serins64029672_serins
stearins8312142stearins
steins64818342ste_ins
sterns64616752ster_ns
terns55226872_ter_ns
uterine7315192uterine
acetins9313173acetins
aeries64737783_aeries
aldrins8310203aldrins
alevins102110573alevins
alexins141910663alexins
altering91917113altering
aneurins849063aneurins
aperies9423203aperies
apteria9312913apteri_a
apterium1249133apterium
apterous10410463apterous
arteries8321463arteries
asterias8317003asterias
attains7310983attains
attrits7310613attrits
bacterins13410643bacterins
begins94415303_begins
berlins93216013_berlins
brins75533973__brins
burins84221893_burins
butyrins1345423butyrins
caterans10313203caterans
catering112019903catering
cerias83321973_cerias
cering94522533_cering
cinerins10414093cinerins
citrins92614363citrins
clerics1149333clerics
clerids1049083clerids
coteries10422703coteries
cretins93216423cretins
detains83716093detains
detrains9411753detrains
dipterans1245703dipterans
eateries8324303eateries
elaterins9410033elaterins
emeries91620023emeries
emetins9812643emetins
endrins8312163endrins
enterics10312853enterics
entering91920053entering
enterons8314153enterons
ephedrins1544153ephedrins
erns45428223__er_ns
eserine7415903eserine
eserines8413743eserines
estrins7315853estrins
etamins91511823etamins
eterne6311723eter_ne
eternise8119663eternise
etesians845473etesians
externs1438233exter_ns
faeries104118993faeries
ferias95020393_ferias
ferine96422583_ferine
ferns85220083_fer_ns
fibrins1238633fibrins
florins10311643florins
gherkins1643993gherkins
grins65427223__grins
haemins122811393haemins
hemins113417563_hemins
herns84825583_her_ns
heroins103518013_heroins
herons94820543_herons
icterics1247053icterics
interims101013073interims
interns73116763inter_ns
iteming1037753iteming
iterant7317783iterant
jeering153513043jeering
jerids142810943_jerids
jerkins18358243_jerkins
kerns94719563_ker_ns
leering83417643leering
levins94514653_levins
luteins7310103lute_ins
merino8315093_merino
merinos9311973_merinos
merits8320873_merits
merlins93015803_merlins
metering112915633metering
metrics11312363metrics
metring103215283metring
mirins83918893_mirins
mitering113015393mitering
mureins9310733mureins
myelins1237353myelins
niteries8318373niteries
olefins1037493olefins
oleins6313523ole_ins
operons91411743operons
outgrins979823outgrins
overing111918053overing
paeans85118263pae_ans
paeons83915523pae_ons
paesans93312693paesans
pains75138283p__ains
pairing103716733pairing
pairings11398313pairings
paltering122612893paltering
papains11312363papains
papering132213313papering
parians93519723p_arians
paries84742513p_aries
paring94236493p_aring
parings104219213p_arings
paris75145943p_ari_s
parries93925843parries
parring103222063parring
pasterns104112623paster_ns
patens84820863pate__ns
paters84935823pater__s
patins87528783p_atins
patrons93818103patrons
pattering122314423pattering
patterns10439943patter_ns
paulins9312613paulins
pavins114919663p_avins
peans75437643p_e_ans
pecans101515833p_ecans
pectins112315233pectins
peeing94618083p_eeing
peeking144414953peeking
peeling102919873peeling
peelings11339523peelings
peening103318303peening
peens76428193p_e_ens
peeping123615213peeping
peeress939503peeress
peerie83617893peeri_e
peers75130273peer__s
peeving135112243peeving
peewits12105873peewits
pein65834943p_e_in_
pekans121710553p_ekans
pekin111514423p_ekin_
pelerine10313003pelerine
pelerines11311833pelerines
peltering122011673peltering
penis75129323p_eni_s
pennis84315743p_ennis
pens65649643p_e__ns
peons75327183p_e_ons
pepino10310333p_epino
pepinos1137693p_epinos
pepsins11310433pepsins
perdus93711273p_erdus
peregrins1246963peregrins
pereions10310853p_ereions
pereons92815003p_ereons
peres76246643p_er_es
peri65636973p_eri__
perigons11310083p_erigons
peril75425953p_eri_l
perinea9313033p_erinea
period9314983p_eriod
periods10312243p_eriods
perish114619063p_erish
periti8319953p_eriti
peritus9311803p_eritus
perking143716453p_erking
perks115325803p_er_ks
perming123416083p_erming
permits11314003p_ermits
perms95524513p_er_ms
pernio8513143p_ernio
perps95521483p_er_ps
perries93226603perries
perrons93115483perrons
perses85428063p_erses
persons93717003p_ersons
pertains102113413p_ertains
pervs105117373p_er_vs
pestering122315663pestering
peters86624593peter__s
petrels9279373petrels
petrify1536573petrify
petrols92913083petrols
petrous92714423petrous
petting103720953petting
pettings11349703pettings
pewits112810683p_ewits
phytins15317893phytins
pidgins11259123pidgins
piecing12410453piecing
piecings1345333piecings
pieing93917653pie_ing
pierces113411193pierces
piercing1346663piercing
piercings1453253piercings
piers75926333pier__s
pieties9419223pieties
piggins113010473piggins
pineries102419083pineries
pins65558453p___ins
piperine122011833piperine
piperines131610673piperines
pipkins15328183pipkins
pippins10319753pippins
pirns76020093p_ir_ns
plains85019593p_lains
pleons84213333ple_ons
poesies93217403poesies
poetics11312073poetics
poetries10315583poetries
pooris83916843poori_s
poperies12316793poperies
poplins11313153poplins
poring94227273p_oring
porns75527343p_or_ns
portering122012303portering
posterns102713703poster_ns
postins93721203postins
poteens92910883pote_ens
pothering151911283pothering
potteries11313593potteries
pottering122612003pottering
pouring103115863pouring
powering142210803powering
prebids12399873prebids
prebind123810643prebind
prebinds13357733prebinds
precis103416703preci_s
predries112714383predries
preeing103817673preeing
preens85020113pre_ens
prelims1139823prelims
premies113823063premies
premiss113513813premiss
preprint12314183preprint
preprints1347473preprints
prerinsed1246323prerinsed
prerinses1138803prerinses
preriot9316413preriot
preterits11410943preterits
pretrains11410143pretrains
pretrims1238983pretrims
prexies163415003prexies
preying133114553preying
pries74339533p__ries
prigs85219703p__rigs
prims95425933p__rims
prink114719673p__rink
prinks124315383p__rinks
print74837463p__rint
prints84320103p__rints
prions84317783p__rions
priss74623893p__riss
proteins102114283prote_ins
pteridine1246733pteridine
pteridines1345453pteridines
pteryla1243303pteryla
ptisans9317353ptisans
ptomains1246053ptomains
ptosis83611823ptosi_s
ptyalins1364693ptyalins
puerile9310093puerile
puffins15278913puffins
punkins133111113punkins
purin75527593p_urin_
purine85321893p_urine
purines94420763p_urines
puris75332023p_uri_s
purlins93415423purlins
purring104515823purring
puttering122611643puttering
pyemias1436803pyemias
pyins105815863p__yins
pyrans11411063p_yrans
pyurias1236703pyurias
queries16315873queries
querns15307943quer_ns
reins56234563_re_ins
renins64526453_renins
repins84924313_repins
rerigs74014793_rerigs
reruns66413743_reruns
resins64528773_resins
retains74522253retains
retrains8314523retrains
retries74129073retries
retrims93612373retrims
rewins95020823_rewins
rins46153193___rins
sarins63932623_sarins
sereins73716113_sereins
series64540973_series
serifs94017053_serifs
serin55434443_serin_
serine65432673_serine
serines74229543_serines
sering74731813_sering
sferics1236133sferics
sherifs13299683sherifs
skeins103911903ske_ins
speering113116323speering
speerings12276833speerings
spherics1537073spherics
sphering142811943sphering
spiering112713353spiering
stains64923653st_ains
staring84527053staring
statins73719773statins
stearin7312003stearin_
stearine8311903stearine
stearines9311283stearines
steering93916793steering
stein54620533ste_in_
stereos74314973stereos
steres63929533ster_es
steric8317063steri_c
sterile7316603sterile
sterling93615553sterling
sterlings10308753sterlings
stern55319123ster_n_
sterna63712763ster_na
steroids9911433steroids
sterols7313443sterols
stewing113412493stewing
stories7324273stories
storing83921123storing
stotins73213863stotins
strains74218153strains
string75327563st_ring
strings84617133st_rings
strips85719653st_rips
suberins10315093suberins
tains54936323_t_ains
takins105117403_takins
taring73932283_taring
tarns56433953_tar_ns
tearing84021493_tearing
teeing73916973_teeing
teens56227483_te_ens
teiids736693_teiids
teind6213613_te_ind
teinds738263_te_inds
tenias64720073_tenias
tennis64015303_tennis
tenons62916603_tenons
tenpins9410073_tenpins
tens45647413_te__ns
terais64023503_terais
terbias9310743_terbias
terces83921413_terces
terming104015993_terming
termini93410813_termini
terminus1037383_terminus
terms75523473_ter_ms
tern46134803_ter_n_
terne56426153_ter_ne
ternes65422903_ternes
ternions838813_ternions
terrains8410293_terrains
terras63516953_terras
terries73425613_terries
terrine72517573_terrine
terrines82117523_terrines
territs72714493_territs
tertians839103_tertians
tetris62816293_tetri_s
tewing103914823_tewing
theins95015423_theins
therians1138313therians
thins85826323_t_hins
thrips11299013_thrips
tiepins939463tiepins
tiering8315243tiering
tins45251303_t__ins
tiring74023093_tiring
torics85118353_torics
tories65435883_tories
toxins133314283_toxins
trains64725343_trains
trans54933043_t_rans
treens65317873_treens
triens65417543_t_riens
tries55742813_t_ries
trigs65423063_t_rigs
trims75021473_t_rims
trine54734603_t_rine
trines64132563_t_rines
trios55528093_t_rios
trips74923363_t_rips
turions7311573_turions
turns55623233_tur_ns
twains95811183_twains
twins85118983_t_wins
tyring104613023_tyring
uptearing1236103uptearing
upturns9264973uptur_ns
uteri51012983uteri__
uterus639193uter_us
uttering91613083uttering
veeries102916883veeries
veering113213683veering
veins84620493_ve_ins
venins93816703_venins
verdins112812333_verdins
veterans1148843veterans
watering122316313watering
waterings13229243waterings
yeelins1038813yeelins
yttrias1044513yttrias
zeins144715393_ze_ins

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.1401276364.3
2DLD Change Limit1340274237.69017428.7
3Display Results4234230.1702488.2
 (SQL Overall)1786914238.00022336.4
 
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.