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

127 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
pemoline1231027(None) 
pemolines1348621pemolines
hemline12311072hem_line
moline84422032__moline
petaline10314882petaline
picoline12310852picoline
proline92321592p_roline
semolina1047492semolina
aerolite8315053aerolite
arecoline1147103arecoline
beeline93314723be_eline
beltline1036943beltline
berline93716853be_rline
beryline1337083beryline
chemokine2084343chemokine
choline122915383_choline
compline14313553compline
cosmoline1346183cosmoline
deadline10139053deadline
decline103716613de_cline
demilune1144423demilune
demoing11311753demo_ing
demolish1447833demolish
demonise11411933demonise
demonize20311533demonize
demoting12311423demoting
emetine9712943_emetine
emodin9310353_emodin_
emodins1039433_emodins
emoting10313563_emoting
emotive1239193_emotive
emplane11410013_emplane
eosine64519413_e_osine
feline94820143fe__line
feminine13199783feminine
gasoline938523gasoline
gemlike14206813gem_like
gumline102810113gum_line
headline12129613headline
hematine131614673hematine
hemlines13310623hem_lines
hemolyze2544193hemolyze
hemplike1936123hemplike
heroine103517493hero_ine
isoline7314013_isoline
kaoline11310143_kaoline
kerosine1238153kerosine
lanoline8311953lanoline
lemonlike1542833lemonlike
lemurine1046523lemurine
leonine7311233le_onine
leporine1049303leporine
maline84529093__maline
memorise121411433memorise
memorize211311103memorize
neckline1496363neckline
paroling113316213paroling
parvoline1477173parvoline
pavonine1346663pavonine
peaklike13115373peaklike
pealike131211273pe_alike
pealing104123203pe_aling
pearling11912013pearling
pearlite1039443pearlite
pebbling1535073pebbling
pecorini1246553pecorini
pecorino1246633pecorino
pedaling122412133pedaling
peddling13217973peddling
peeling102919873pe_eling
peglike14136773pe_glike
pelerine10313013pelerine
pelite84323003pe__lite
pembina1345223pem_bina
penalise101013763penalise
penalize19912753penalize
penlite9313243pe_nlite
pennine93712953pe_nnine
peopling1338353peopling
pepsine11310603pe_psine
percaline13410953percaline
periling11316863periling
perilune1046993perilune
perlite9317323pe_rlite
peroxide1848193peroxide
pestling111010253pestling
pettling1168213pettling
phocine1438833p_hocine
picholine1646643picholine
picolin11310883picolin_
picolines1339623picolines
picolins1239853picolins
pipeline12149503pipeline
pisolite10310373pisolite
plotline1037643plotline
police102918563p__olice
poling93526503p__oling
polite83625073p__olite
pooling103219093p_ooling
potline91015233p_otline
praline93019743p_raline
premolding1644673premolding
prolines102619693p_rolines
promine112819443p_romine
propine113020213p_ropine
ptomaine1245533ptomaine
pumplike1834373pumplike
purline93516533p_urline
pyrolize2248133pyrolize
pyronine1349513pyronine
recline94020493re_cline
redline84218833re_dline
reguline939503reguline
reline65434353re__line
remolade1147203remolade
remolding1338163remolding
removing1439083removing
resoling92916303resoling
semolinas1145433semolinas
semplice1447013semplice
sepaline10311343sepaline
serotine8313573serotine
setline7313923se_tline
timeline1039243timeline
tremolite1156893tremolite
tumpline1237113tumpline
zeolite1638903ze_olite

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 Filter1786911461620.466383457.1
2DLD Change Limit1461621277.76618820.8
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.27821586.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.