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

272 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
pertain9271496(None) 
certain92612211certain
pertains102113421pertains
appertain1345272appertain
ceratin93020162ceratin
curtain9319792curtain
destain8412082destain
detain74617382de_tain
detrain8412252detrain
keratin113314152keratin
partan83820562parta_n
pearmain1245832pearmain
pectin102615532pect_in
permian112612282permian
pertained1238502pertained
pretrain10310922pretrain
retain64523282re_tain
retrain7615422retrain
sextain14257102sextain
terrain7410852terrain
tertian7511192tertian
vervain1335562vervain
abstain947253abstain
aerating92821003aerating
aeration8319933aeration
appertains1455273appertains
ascertain1144233ascertain
attain6311753_attain
bargain1079063bargain
berating113220763berating
berlin83116373ber_lin
berthing14209593berthing
betaine9413783be_taine
brain76229383_br_ain
captain112111063captain
centai84814783centai_
ceratins102818733ceratins
certainer1146193certainer
certainly1443153certainly
certainty1443193certainty
contain9315833contain
cortin82423153cort_in
creatin93618133creatin
cretin82917913cret_in
curtail9299663curtail
curtains10259703curtains
deltaic1037023deltaic
dentin73919573dent_in
deraign936573der_aign
derail74218813der_ail
derating103222283derating
destains9311813destains
detail74516433de_tail
detains83716093de_tains
detrains9411763detrains
dextrin1587543dextrin
distain8313783distain
drain65222893_dr_ain
elain55324703_e_lain
entail61114343_entail
entertain947863entertain
entrain7313073_entrain
estrin6315923_estrin
etamin81311853_e_tamin
gelatin83514733gelatin
gentian8310103gentian
german9611983germa_n
grain65126253_gr_ain
gratin74520583_gratin
hematin121516023hematin
herein93717793her_ein
hermai118912863hermai_
heroin94420593her_oin
jerkin17258113jer_kin
keratins122313483keratins
lectin82515013lect_in
leptin82512333lept_in
martian93514683martian
martin84122523mart_in
merlin83916683mer_lin
mermaid1297853mermaid
merman10513863merma_n
mortmain1244573mortmain
murrain937763murrain
obtain839183_obtain
oestrin7312243oestrin
operatic1249933operatic
operating12313723operating
operation11314003operation
ordain7810403_ordain
overlain112112443overlain
overthin1438533overthin
overtrain1259783overtrain
pain65647243p___ain
papain10313793p_apain
parfait12312053parfait
parian83223963paria_n
partake1339643partake
partaken1445553partaken
partaking1698673partaking
partans94418283partans
partial92616263partial
parting103527383part_ing
parton84720993part_on
partying14168893partying
patin76832853p_at_in
pean66147173pe__a_n
pearmains1345263pearmains
pecan91919033pe_ca_n
pechan13511543pecha_n
pectase112410363pectase
pectate112214693pectate
pecten102711103pect_en
pectic122913873pect_ic
pectins112315233pect_ins
pein65834943pe___in
pekan111613973pe_ka_n
pekin111514423pe__kin
peltast9310513peltast
peltate92013773peltate
peltation11312963peltation
pelting102917273pelt_ing
penguin1045873penguin
penman10312323penma_n
pentad9313763penta_d
pentads1039523pentads
pentagon1146323pentagon
pentane9415743pentane
pepsin10310853pe_psin
peptalk1554823peptalk
peptic122113153pept_ic
peptid112712373pept_id
peracid12312993peracid
percale11314093percale
percaline13410953percaline
perching163711633perching
percoid12312313percoid
perdie94718513per_die
perea75026443perea__
peregrin1146993peregrin
pereia85217983per_eia
pereion9312053pereion
pereon83517453per_eon
perhaps1446123perhaps
peri65636973per__i_
periapt11313413periapt
peridia10312363peridia
perigon1039853perigon
peril75425953per__il
periling11316863periling
peris75537073per__is
periti8319953periti_
periwig1345163periwig
perking143716463per_king
perming123416093per_ming
permit10321683per_mit
pernio8513143per_nio
peroxid17310273peroxid
perron83216623per_ron
persalt9315413persalt
person83517873per_son
pert66759323pert___
pertaining1347993pertaining
perter84422283pert_er
pertest9317043pertest
pertly115312553pert_ly
perturb1146003perturb
perusing11811063perusing
pervade1337023pervade
pervading1636303pervading
pervasion1446073pervasion
pestling111010253pestling
petal76526893pe_ta_l
petaline10314883pe_taline
petals84719813pe_tals
petard95013803pe_tard
petit74332653pe_t_it
petrale9312623petrale
petsai838083petsai_
petsais938433petsais
petti75119453pe_tti_
petting103720953pe_tting
pettling1168213pettling
phytin14459013phyt_in
pigtail1046623pigtail
pintail9311183pintail
piratic11314293piratic
pirating11314513pirating
plain74823303p__lain
plantain1047903plantain
platan83913693plata_n
portage103013643portage
portaging1346843portaging
portal84218463porta_l
portals94015563portals
porting103021783port_ing
portion9615493portion
portrait10510323portrait
postin83521033post_in
prating103424453p_rating
prawn105312433p_r_awn
predawn1335353predawn
preman104117453prema_n
preobtain1343993preobtain
preordain12124493preordain
prepaid12310133prepaid
pretape113511623pretape
pretaping1439133pretaping
pretax152310193preta_x
preteen939873preteen
pretrains11410143pretrains
pretrim11310783pretrim
prevail1238243prevail
prewarn124410143prewarn
protamin121210543protamin
protein92414733protein
pterin81014153pter__in
ptomain1146963ptomain
purin75527593pur__in
puritan939283purita_n
purlin83615863pur_lin
purloin9107493purloin
pyran10514473pyr_a_n
rain46251733__r_ain
reattain846733reattain
redtail858713redtail
refrain10310043refrain
regain74517763re_gain
remain85919863re_main
reobtain1044623reobtain
reordain9135573reordain
reran57329103rer_a_n
restrain8311703restrain
retail65522073re_tail
retains74522253re_tains
retrains8314533retrains
seatrain847923seatrain
seitan62613233seita_n
serai56830163ser_ai_
serail64222673ser_ail
serais64326133ser_ais
serein63318463ser_ein
sericin9312843sericin
serin55434443ser__in
sextains15246813sextains
sextan13389643sexta_n
spartan948333sparta_n
sprain83614863spr_ain
stain55727943__stain
strain64919573str_ain
superlain1148993superlain
superthin1446833superthin
sustain738773sustain
tain45548073___tain
tartan64217513tarta_n
tearstain943433tearstain
terai53525483ter_ai_
terais64023513ter_ais
terrains8410323terrains
terrapin1046203terrapin
tertial7313863tertial
tertians839103tertians
train56529113_tr_ain
uncertain1146203uncertain
ventail10310453ventail
veratrin1147703veratrin
verdin103113023ver_din
vermian12329713vermian
vermin113414523ver_min
vervains1435293vervains
vitrain1038943vitrain
zeatin15412823zeat_in

Search took 15 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.813219792.1
2DLD Change Limit13402727213.22010138.2
3Display Results2722720.1861462.4
 (SQL Overall)17869127214.21912567.1
 
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.