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

439 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
pterin8101415(None) 
pterins9812991pterins
apteria9312912apteria
peerie83617892peerie
peering103520352peering
pein65834942p_e_in
pekin111514422p_ekin
peri65636972p_eri_
peril75425952p_eril
peris75537072p_eris
petering112516812petering
purin75527592p_urin
serin55434442_serin
stearin7312002stearin
stein54620542ste_in
steric8317062steric
stern55319122ster_n
tern46134802_ter_n
uteri51012982uteri_
uterine7315192uterine
acetin8314693acetin
aerie54634603_aerie
aldrin7311243aldrin
alevin92511513alevin
alexin132311483alexin
altering91917113altering
aneurin749833aneurin
apter76120203apter__
apteral9311523apteral
apterium1249133apterium
apteryx1942383apteryx
asteria7316183asteria
astern64815813aster_n
atelic8313703atelic
atria56022343at_ria
atrip75315753at_rip
attain6311753attain
attrit6315753attrit
atwain937813atwain
bacterin12410273bacterin
begin85117353_begin
berlin83116373_berlin
brin67038193__brin
burin75626063_burin
butyrin1245813butyrin
cateran9313773cateran
catering112019903catering
ceria75125353_ceria
ceric94023093_ceric
cering94522533_cering
cinerin9313823cinerin
citrin82615413citrin
cleric10612133cleric
clerid9312413clerid
coterie9417403coterie
cretin82917913cretin
detain74617383detain
detrain8412253detrain
dipteran1146203dipteran
dipteron1145593dipteron
eerie55228533_eerie
elaterin849903elaterin
emetin8613463emetin
endrin7312403endrin
enteric9314213enteric
entering91920053entering
enteron7313333enteron
ephedrin1444703ephedrin
ern35738363__er_n
eserine7415903eserine
estrin6315923estrin
etamin81311853etamin
eterne6311723eterne
etesian757853etesian
etheric12311783etheric
extern1348473exter_n
faerie93514683faerie
feria85922713_feria
ferine96422583_ferine
fern76129323_fer_n
fibrin1138533fibrin
florin9312653florin
gherkin1544043gherkin
grin55733723__grin
haemin113412663haemin
hemin103620933_hemin
herein93717793_herein
hern76134893_her_n
heroin94420593_heroin
heron85025503_heron
icteric1138023icteric
interim9912873interim
intern64016543inter_n
iteming1037753iteming
iterant7317783iterant
iterum837903iterum
jeering153513043jeering
jerid132316423_jerid
jerkin17258113_jerkin
kern85326213_ker_n
leering83417643leering
levin84816413_levin
lutein6311263lute_in
merino8315093_merino
merit7339183_merit
merlin83916683_merlin
metering112915633metering
metric10314673metric
metring103215293metring
mirin75023153_mirin
mitering113015403mitering
murein8311763murein
myelin1138973myelin
niterie7313743niterie
olefin937583olefin
olein5316003ole_in
operon8811773operon
outgrin8810553outgrin
overing111918053overing
padri85815173padri_
paean77222723pae_an
paeon74819493pae_on
paesan85114093paesan
pain65647243p__ain
pairing103716733pairing
paltering122612893paltering
papain10313793papain
papering132213313papering
parian83223963p_arian
paring94236493p_aring
paris75145943p_aris
parring103222063parring
pastern94415063paster_n
paten74827343pate__n
pater74740723pater__
paters84935833pater_s
patin76832853p_atin
patron84018043patron
pattering122314423pattering
pattern93712053patter_n
paulin8312983paulin
pavin105623203p_avin
pean66147173p_e_an
pecan91919033p_ecan
pectin102615533pectin
peeing94618083p_eeing
peeking144414953peeking
peeling102919873peeling
peen65938083p_e_en
peening103318303peening
peeping123615213peeping
peer66238353peer__
peered93819493peered
peeries93623023peeries
peers75130273peer_s
peery105719443peer_y
peeving135112243peeving
peewit111110903peewit
peins76128063p_e_ins
pekan111613973p_ekan
pekins121812233p_ekins
pelerine10313013pelerine
pelon74423213p_elon
peltering122011673peltering
pen56558843p_e__n
penis75129323p_enis
penni74617903p_enni
peon65635243p_e_on
pepino10310333p_epino
pepsin10310853pepsin
per56353093p_er__
perch124518833p_erch
perdie94718513p_erdie
perdu84216273p_erdu
perdy115417333p_erdy
pere66450263p_er_e
perea75026443p_erea
peregrin1146993peregrin
pereia85217983p_ereia
pereion9312053p_ereion
pereon83517453p_ereon
peres76246643p_eres
perigon1039853p_erigon
perils84121853p_erils
perinea9313033p_erinea
period9314983p_eriod
perish114619063p_erish
periti8319953p_eriti
perk106232843p_er_k
perking143716463p_erking
perks115325803p_erks
perky145319483p_erky
perm85834633p_er_m
permian112612283p_ermian
perming123416093p_erming
permit10321683p_ermit
perms95524513p_erms
pernio8513143p_ernio
perp89029893p_er_p
perps95521483p_erps
perron83216623perron
perry105222713p_erry
perse75429523p_erse
person83517873p_erson
pert66759323p_er_t
pertain92714963p_ertain
perv97224813p_er_v
pervs105117373p_ervs
pestering122315663pestering
peter74427593peter__
petered103314973petered
peters86624593peter_s
petit74332653p_etit
petrel83111533petrel
petrify1536573petrify
petrol82714063petrol
petti75119453petti_
petting103720953petting
pewit104622793p_ewit
phenix1837133phenix
phytin14459013phytin
picric12309923picric
pidgin10259813pidgin
piecing12410453piecing
pieing93917653pie_ing
pier66035293pier__
pierce104010393pierce
piercing1346663piercing
piers75926333pier_s
piggin103111093piggin
pin57066723p___in
pinyin112710613pinyin
piperine122011833piperine
pipkin14248603pipkin
pippin92810303pippin
pirn67128373p_ir_n
plain74823303p_lain
pleon74216383ple_on
pleuron976343pleuron
poetic10416843poetic
poori74816233poori_
pooris83916843pooris
poplin10413483poplin
poring94227273p_oring
porn65636023p_or_n
portering122012303portering
postern93615613poster_n
postin83521033postin
poteen83514263pote_en
pothering151911283pothering
pottering122612003pottering
pouring103115863pouring
powering142210803powering
prebid113512843prebid
prebind123810643prebind
precis103416703precis
preeing103817673preeing
preen75925053pre_en
prefix18356853prefix
prelim10311423prelim
preman104117453preman
premen105017803premen
premie103617993premie
premix173710333premix
preprint12314183preprint
prerinse1038633prerinse
preriot9316413preriot
preterit10315843preterit
pretrain10310923pretrain
pretrim11310783pretrim
preying133114553preying
prig75924873p__rig
prim85132203p__rim
prink114719673p__rink
print74837463p__rint
prion75119993p__rion
protein92414733prote_in
pteridine1246743pteridine
pterygia1442403pterygia
pteryla1243303pteryla
ptisan8417973ptisan
ptomain1146963ptomain
ptosis83611823ptosis
ptotic102713373ptotic
ptui64912483pt_ui_
ptyalin1274783ptyalin
puerile9310093puerile
puffin141149003puffin
punkin123611523punkin
puri65931443p_uri_
purine85321893p_urine
purins83722653p_urins
puris75332023p_uris
purlin83615863purlin
purring104515823purring
putrid9311173putrid
puttering122611643puttering
pyemia1337553pyemia
pyemic1537893pyemic
pyin96823233p__yin
pyran10514473p_yran
pyric123815073p_yric
pyuria1136953pyuria
quern143610403quer_n
rein46040893_re_in
renin54830033_renin
repin75324703_repin
reran57329103_reran
rerig64018483_rerig
rerun58722153_rerun
resin54131053_resin
retain64523283retain
retrain7615423retrain
retrim83514883retrim
rewin85623963_rewin
rin36663183___rin
sarin55239253_sarin
serein63318463_serein
serif84132133_serif
serine65432673_serine
sering74731813_sering
serins64029673_serins
sherif122915243sherif
skein94814413ske_in
speering113116323speering
spheric14510073spheric
sphering142811943sphering
spiering112713353spiering
stain55727943st_ain
staring84527053staring
statin63921473statin
stearic939423stearic
stearine8311903stearine
stearins8312143stearins
steering93916793steering
steins64818343ste_ins
stelic8313083stelic
stere55328543ster_e
stereo65317913stereo
steres63929533steres
sterile7316603sterile
sterling93615553sterling
sterna63712763sterna
sterns64616763sterns
steroid81314863steroid
sterol6613333sterol
stewing113412493stewing
storing83921123storing
stotin63215063stotin
strain64919573strain
strewn96710013strewn
stria55723213st_ria
string75327563st_ring
strip77524343st_rip
suberin9314563suberin
tain45548073_t_ain
takin94921303_takin
taring73932283_taring
tarn46842723_tar_n
tearing84021493_tearing
teeing73916973_teeing
teen45938203_te_en
teiid6312533_teiid
teind6213613_te_ind
telia55821143_telia
telic76019823_telic
ten35856113_te__n
tenia55324483_tenia
tenon53320513_tenon
tenpin8310583_tenpin
tepid8314313_tepid
terai53525483_terai
terais64023513_terais
terbia8311153_terbia
terbic10410963_terbic
terce75721843_terce
terga63315643_terga
term66233153_ter_m
terming104016003_terming
termini93410813_termini
terms75523473_terms
terne56426153_terne
ternion739493_ternion
terns55226873_terns
terra54419663_terra
terrain7410853_terrain
terrine72517573_terrine
territ63421373_territ
terry84721873_terry
terse55026823_terse
tertian7511193_tertian
tetri52716453_tetri_
tetris62816293_tetris
tewing103914823_tewing
thein85919023_thein
therein102310353therein
therian10311293therian
thin76732393_t_hin
thrip103012183_thrip
tiepin839343tiepin
tiering8315253tiering
tin36362173_t__in
tiring74023093_tiring
tori47542153_tori_
toric76529313_toric
torii55521593_torii
torn46044253_tor_n
toxin124716713_toxin
train56529113_train
treen55622753_treen
trig55528163_t_rig
trim65329523_t_rim
trine54734603_t_rine
trio45233343_t_rio
trip66830393_t_rip
turion6313163_turion
turn46330393_tur_n
twain86313623_twain
twin76023083_t_win
tyin76424003_t_yin
tyring104613023_tyring
uptearing1236103uptearing
uptorn8268093uptor_n
upturn8286243uptur_n
uterus639203uterus
uttering91613083uttering
veering113213683veering
vein75625753_ve_in
venin85118663_venin
verdin103113023_verdin
vermin113414523_vermin
veteran1039353veteran
watering122316313watering
wherein13216593wherein
xeric144315663_xeric
yeelin939343yeelin
yttria954803yttria
yttric1145433yttric
zein135620603_ze_in

Search took 6 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.390458182.1
2DLD Change Limit1127164395.37320978.2
3Display Results4394390.1403135.7
 (SQL Overall)1786914395.90330271.2
 
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.