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

205 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
petaline1031488(None) 
betaine9413782beta_ine
etamine91313072_etamine
ketamine14157052ketamine
metaling111613712metaling
metalise10416052metalise
metalize19414782metalize
metalline1158732metalline
pealike131211272pe_alike
pealing104123202pe_aling
pedaling122412132pedaling
pemoline12310272pemoline
penalise101013762penalise
penalize19912752penalize
percaline13410942percaline
petallike1554632petallike
pettling1168212pettling
potline91015232pot_line
praline93019742p_raline
sepaline10311342sepaline
setline7313922set_line
aline57243153___aline
alkaline12168283alkaline
apetalies1148003apetalies
astatine8313533astatine
beeline93314723be_eline
beltline1036943beltline
bengaline1245633bengaline
berline93716853be_rline
beryline1337083beryline
betaines10313293beta_ines
betaking153010143betaking
bubaline1247163bubaline
cetane8315283ceta__ne
cutline92914543cut_line
dateline9810353dateline
deadline10139053deadline
dealing94323233de_aling
decline103716613de_cline
delaine8314783dela_ine
detailing112510413detailing
detain74617383deta_in_
detained103111643deta_ined
detainee92511723deta_inee
detainer92910793deta_iner
detains83716093deta_ins
egalite8311563_egalite
elapine9310673_elapine
enamine91214303_enamine
etalon648973_etalon_
etalons739063_etalons
etamin81311853_etamin_
etamines101611803_etamines
etamins91511833_etamins
examine161510033_examine
feline94820143fe__line
fettling1266773fettling
flatline11298923flatline
gelatine93213303gelatine
headline12129613headline
healing113922963he_aling
hematine131614673hematine
hemline12311073he_mline
hexamine2046863hexamine
hotline10712343hot_line
hyaline132310723_hyaline
jetlike18276763jet_like
jetliner1534853jet_liner
ketamines15177023ketamines
legalise949493legalise
legalize1839103legalize
legatine91311403legatine
maline84529083__maline
mealie82519803me_ali_e
medaling121912243medaling
melamine12310293melamine
mescaline1348943mescaline
messaline1146873messaline
metalised12310463metalised
metalises11315063metalises
metalist10519353metalist
metalized21412183metalized
metalizes20414233metalizes
metallike1555893metallike
metalling1249593metalling
metallize2067153metallize
neckline1496363neckline
nectarine1146983nectarine
netlike11308913net_like
nettling957213nettling
opaline9412483_opaline
outline72321333out_line
palatine10316063palatine
paling93530133p__aling
pantalone1146833pantalone
pastalike1546723pastalike
patine85328123p__atine
peacing124117073pe_acing
peaking144317683pe_aking
peaklike13115373peaklike
pearling11912013pearling
pearlite1039443pearlite
pebbling1535073pebbling
pedalier1137603pedalier
pedalling1346663pedalling
peddling13217973peddling
peeling102919873pe_eling
peglike14136773pe_glike
pelerine10313013pelerine
pelite84323003pe__lite
pemolines1348613pemolines
penalised12108823penalised
penalises11912763penalises
penality13310713penality
penalized211210223penalized
penalizes20911833penalizes
penlite9313243pe_nlite
pennine93712953pe_nnine
pentane9415743penta__ne
peopling1338353peopling
pepsine11310603pe_psine
peptalking1943253peptalking
percalines1449713percalines
periling11316863periling
perilune1046973perilune
perlite9317313pe_rlite
pertain92714963perta_in_
pertained1238493perta_ined
pertains102113413perta_ins
pestling111010253pestling
petabyte1542783petabyte
petal76526893petal___
petaled103614143petal_ed
petalled1138693petalled
petalody1443863petalody
petaloid1148733petaloid
petalous1058973petalous
petals84719813petal__s
petering112516813petering
petite84320653pet__ite
petnaping1444543petnaping
petrale9312623petral__e
petting103720953pet_ting
pettle84116053pettl__e
petulance1354513petulance
petulant1048793petulant
phenazine2345623phenazine
phthalin1655853phthalin_
phthalins1765373phthalins
picoline12310853picoline
pipeline12149493pipeline
plotline1037643plotline
poetlike1436733poet_like
potlike13910123pot_like
potlines10714213pot_lines
pralines102217723p_ralines
pretaping1439133pretaping
proline92321593p_roline
protamine131310913protamine
ptyalin1274773ptyalin_
ptyalins1364693ptyalins
purline93516533p_urline
putamina1244543putamina
putative1348373putative
ratline74517803rat_line
realise73021813re_alise
realize162717083re_alize
recline94020493re_cline
redline84218833re_dline
regaling10315363regaling
reguline939503reguline
reline65434353re__line
retailing103214733retailing
retain64523283reta_in_
retained93016093reta_ined
retainer82913813reta_iner
retains74522253reta_ins
retaking133114273retaking
retaliate9410633retaliate
retaping113012553retaping
retaxing162311333retaxing
retiling93319483retiling
retine66237333ret__ine
saline65132703__saline
sealing83528563se_aling
setlines8312743set_lines
settling978943settling
staling83925423_staling
stanine73417073_stanine
stealing93416603stealing
stearine8311903stearine
tagline82412453__tagline
tealike111111083te_alike
tetanise8610203tetanise
tetanize17109953tetanize
totaling9610293totaling
totalise8312503totalise
totalize17311523totalize
valine94623093__valine
vealing114217423ve_aling
vitalise11310743vitalise
vitalize20310503vitalize
vitamine1347373vitamine
vituline1147093vituline
yealing112716383ye_aling

Search took 10 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 Filter1786911461620.203880251.2
2DLD Change Limit1461622059.20315882.0
3Display Results2052050.0802562.5
 (SQL Overall)1786912059.48618837.3
 
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.